Remove Event

[mg-1999]

Is there a way to remove an event completely from the software? Because I cant find it.

[cbellone]

Hi @mg-1999
no, there isn't yet a way to delete an event. We are planning to add a "visible" flag. Would that be enough?

[mg-1999]

It does the job if you only have a few events, but it stacks up eventually. So a true removal would be a nice addition to the software.

[cbellone]

OK then, we'll try to schedule it for the release 1.8.
Thanks a lot!

[syjer]

current queries (and potentially not in the correct order... :D)

delete from waiting_queue where event_id = 0;
delete from plugin_log where event_id = 0;
delete from plugin_configuration where event_id = 0;
delete from configuration_event where event_id_fk = 0;
delete from configuration_ticket_category where event_id_fk = 0;
delete from email_message where event_id = 0
delete from ticket_field_value where ticket_field_configuration_id_fk in (select id from ticket_field_configuration where event_id_fk = 0);
delete from ticket_field_description where ticket_field_configuration_id_fk in (select id from ticket_field_configuration where event_id_fk = 0);
delete from ticket_field_configuration where event_id_fk= 0;
delete from event_migration where event_id = 0;
delete from sponsor_scan where event_id = 0;
delete from ticket where event_id = 0;
-- tickets_reservation will remain in the system though
update tickets_reservation set promo_code_id_fk = null where promo_code_id_fk in (select id from promo_code where event_id_fk = 0);
delete from promo_code where event_id_fk = 0;
delete from ticket_category_text where ticket_category_id_fk in (select id from ticket_category where event_id = 0)
delete from ticket_category where event_id = 0;
delete from event_description_text where event_id_fk  = 0;
delete from event where id = 0;

[syjer]

note: SPECIAL_PRICE.ticket_category_id does not have an active FK constraint

[syjer]

finally implemented :)