-- html emails module (deprecated)
-- TRUNCATE `qs_ContactGroup`;
-- INSERT INTO `qs_ContactGroup` (`id`, `title`, `system`, `sorter`, `added`, `changed`) VALUES (1, 'News', 'y', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
-- TRUNCATE `qs_ContactPerson`;
-- TRUNCATE `qs_ContactPerson2Group`;
-- TRUNCATE `qs_Mail`;
-- TRUNCATE `qs_Mail2Group`;
-- TRUNCATE `qs_MailAttachment`;
-- TRUNCATE `qs_MailForwardReport`;
-- TRUNCATE `qs_MailReport`;
-- TRUNCATE `qs_MailTemplate`;

-- qs_DContactReason

DROP TABLE `qs_DCountry`;
DROP TABLE `qs_DCountryState`;

TRUNCATE `qs_DPostTag`;

-- qs_DSlideEffect
-- qs_DSlideType
-- qs_DState

TRUNCATE `qs_Faq`;
TRUNCATE `qs_FaqCategory`;
TRUNCATE `qs_FormContact`;
TRUNCATE `qs_Gallery`;
TRUNCATE `qs_GalleryCategory`;
TRUNCATE `qs_Manufacturer`;
TRUNCATE `qs_News`;
TRUNCATE `qs_People`;
TRUNCATE `qs_Portfolio`;
TRUNCATE `qs_PortfolioCategory`;
TRUNCATE `qs_Post`;
TRUNCATE `qs_Post2Tag`;
TRUNCATE `qs_PostCategory`;
TRUNCATE `qs_PostComment`;
TRUNCATE `qs_SideBlock`;
TRUNCATE `qs_SideBlock2Page`;
TRUNCATE `qs_Slide`;
TRUNCATE `qs_SlideHotSpot`;

-- qs_SocialLink

TRUNCATE `qs_Testimonial`;
TRUNCATE `qs_User`;

DELETE FROM `qs_zz_Admin` WHERE `login` <> 'admin' AND `login` <> 'support';
UPDATE `qs_zz_Admin` SET `id` = 1 WHERE `login` = 'admin' LIMIT 1;
UPDATE `qs_zz_Admin` SET `id` = 2 WHERE `login` = 'support' LIMIT 1;
ALTER TABLE `qs_zz_Admin` AUTO_INCREMENT = 3;

-- qs_zz_DFileType

DROP TABLE `qs_zz_DFilter`;
DROP TABLE `qs_zz_DFormFieldType`;
DROP TABLE `qs_zz_DFormFieldType2Filter`;
DROP TABLE `qs_zz_DFormFieldType2Validate`;

DELETE FROM `qs_zz_DLanguage` WHERE `name` <> 'eng';

-- qs_zz_DNotFoundMode
-- qs_zz_DPageHandler
-- qs_zz_DPageItemGroup

DELETE FROM `qs_zz_DPageItemType` WHERE `type` IN ('SearchLucence_');

-- qs_zz_DPageOption

TRUNCATE `qs_zz_DraftHtmlBlock`;
TRUNCATE `qs_zz_DraftHtmlBlockContent`;
TRUNCATE `qs_zz_DraftPage`;
TRUNCATE `qs_zz_DraftPageContent`;
TRUNCATE `qs_zz_DraftPageItem`;
TRUNCATE `qs_zz_DraftPageItemConfig`;
TRUNCATE `qs_zz_DraftPageOption`;

DROP TABLE `qs_zz_DValidate`;

TRUNCATE `qs_zz_File`;

DROP TABLE `qs_zz_Form`;
DROP TABLE `qs_zz_FormField`;
DROP TABLE `qs_zz_FormFieldLabel`;

-- qs_zz_HtmlBlock
-- qs_zz_HtmlBlockContent

TRUNCATE `qs_zz_Log`;
TRUNCATE `qs_zz_NotFound`;

-- qs_zz_Page
-- qs_zz_PageContent

TRUNCATE  `qs_zz_PageIndex`;

-- qs_zz_PageItem
-- qs_zz_PageItemConfig
-- TRUNCATE `qs_zz_PageOption`;

TRUNCATE `qs_zz_Redirection`;

-- qs_zz_Settings
-- qs_zz_SettingsCategory
-- qs_zz_SettingsOptions
