SET foreign_key_checks = 0;

TRUNCATE TABLE translations;
TRUNCATE TABLE translation_translations;
TRUNCATE TABLE slider_slide_translations;
TRUNCATE TABLE slider_slides;
TRUNCATE TABLE slider_translations;
TRUNCATE TABLE sliders;

TRUNCATE TABLE page_translations;
TRUNCATE TABLE pages;

TRUNCATE TABLE meta_data_translations;
TRUNCATE TABLE meta_data;

TRUNCATE TABLE menu_item_translations;
TRUNCATE TABLE menu_items;
TRUNCATE TABLE menu_translations;
TRUNCATE TABLE menus;


TRUNCATE TABLE reviews;
TRUNCATE TABLE reported_ebooks;
TRUNCATE TABLE favorite_lists;


TRUNCATE TABLE entity_files;
TRUNCATE TABLE files;

TRUNCATE TABLE ebook_views;
TRUNCATE TABLE ebook_downloads;
TRUNCATE TABLE ebook_translations;
TRUNCATE TABLE ebook_categories;
TRUNCATE TABLE ebook_authors;
TRUNCATE TABLE ebooks;

TRUNCATE TABLE category_translations;
TRUNCATE TABLE categories;

TRUNCATE TABLE author_translations;
TRUNCATE TABLE authors;

TRUNCATE TABLE setting_translations;
TRUNCATE TABLE settings;

TRUNCATE TABLE comments;

SET foreign_key_checks = 1;