resert_pos_data.sql

DELETE FROM `pos_brains`
WHERE `pos_brain_id` = (SELECT `pos_brain_id` FROM `locations` WHERE `location_id` = '5');

DELETE FROM `employees`
WHERE `location_id` = '5';

DELETE FROM `job_roles`
WHERE `location_id` = '5';

DELETE FROM `choices`
WHERE `location_id` = '5';

DELETE FROM `menu_categories`
WHERE `location_id` = '5';

DELETE FROM `menu_items`
WHERE `location_id` = '5';

DELETE FROM `item_groups`
WHERE `location_id` = '5';

DELETE FROM `revenue_classes`
WHERE `location_id` = '5';

DELETE FROM `hospitality_timesheet_segments`
WHERE `location_id` = '5';

DELETE FROM `hospitality_timesheets`
WHERE `location_id` = '5';

DELETE FROM `hospitality_ticket_items`
WHERE `location_id` = '5';

DELETE FROM `hospitality_tickets`
WHERE `location_id` = '5';

DELETE FROM `hospitality_tender_types`
WHERE `location_id` = '5';

DELETE FROM `hospitality_tender_maps`
WHERE `location_id` = '5';

DELETE FROM `hospitality_revenue_centers`
WHERE `location_id` = '5';

DELETE FROM `hospitality_reasons`
WHERE `location_id` = '5';

DELETE FROM `hospitality_period_definitions`
WHERE `location_id` = '5';

DELETE FROM `hospitality_parameters`
WHERE `location_id` = '5';

DELETE FROM `hospitality_covers`
WHERE `location_id` = '5';

DELETE FROM `hospitality_breaks`
WHERE `location_id` = '5';