Cacher is the code snippet organizer for pro developers

SET FOREIGN_KEY_CHECKS=0;
-- SELECT
--     Concat('TRUNCATE TABLE ', TABLE_NAME)
-- FROM
--     INFORMATION_SCHEMA.TABLES
-- WHERE
--     table_schema = 'crawler';
    
TRUNCATE TABLE place_attributes;
TRUNCATE TABLE place_categories;
TRUNCATE TABLE place_links;
TRUNCATE TABLE place_open_hours;
TRUNCATE TABLE place_reviews;
TRUNCATE TABLE places;
TRUNCATE TABLE postal_codes;
TRUNCATE TABLE postal_codes_distance;
TRUNCATE TABLE postal_codes_pages;
TRUNCATE TABLE region_boundaries;
TRUNCATE TABLE region_places;
TRUNCATE TABLE regions;
TRUNCATE TABLE social_links;
TRUNCATE TABLE temp;
    


SET FOREIGN_KEY_CHECKS=1;