SET FOREIGN_KEY_CHECKS=0;

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

-- qs_Application

TRUNCATE TABLE `qs_Cart`;
TRUNCATE TABLE `qs_CartItem`;
TRUNCATE TABLE `qs_CartItemGiftCard`;
TRUNCATE TABLE `qs_CartItemPromo`;

-- qs_DContactReason

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

-- qs_DFileType

DROP TABLE `qs_DFilter`;
DROP TABLE `qs_DFormFieldType`;
DROP TABLE `qs_DFormFieldType2Filter`;
DROP TABLE `qs_DFormFieldType2Validate`;

-- qs_DGiftCardStatus

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

-- qs_DNotFoundMode
-- qs_DPageHandler
-- qs_DPageItemGroup

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

-- qs_DPageOption
-- qs_DPromoType

TRUNCATE TABLE `qs_DraftHtmlBlock`;
TRUNCATE TABLE `qs_DraftHtmlBlockContent`;
TRUNCATE TABLE `qs_DraftPage`;
TRUNCATE TABLE `qs_DraftPageContent`;
TRUNCATE TABLE `qs_DraftPageItem`;
TRUNCATE TABLE `qs_DraftPageItemConfig`;
TRUNCATE TABLE `qs_DraftPageOption`;

-- qs_DSlideEffect
-- qs_DSlideType
-- qs_DState

DROP TABLE `qs_DValidate`;

TRUNCATE TABLE `qs_Faq`;
TRUNCATE TABLE `qs_FaqCategory`;
TRUNCATE TABLE `qs_File`;
TRUNCATE TABLE `qs_FormContact`;
TRUNCATE TABLE `qs_FormNewsletter`;
TRUNCATE TABLE `qs_Gallery`;
TRUNCATE TABLE `qs_GalleryImage`;
TRUNCATE TABLE `qs_GiftCard`;

-- qs_HtmlBlock
-- qs_HtmlBlockContent

TRUNCATE TABLE `qs_LockedObject`;
TRUNCATE TABLE `qs_Log`;
TRUNCATE TABLE `qs_Partner`;
TRUNCATE TABLE `qs_News`;
TRUNCATE TABLE `qs_Newsletter`;
TRUNCATE TABLE `qs_NotFound`;

-- qs_Page
-- qs_PageContent

TRUNCATE TABLE `qs_PageIndex`;
-- qs_PageItem
-- qs_PageItemConfig
-- qs_PageOption

TRUNCATE TABLE `qs_PeopleSocialLink`;
TRUNCATE TABLE `qs_People`;

TRUNCATE TABLE `qs_Post`;
TRUNCATE TABLE `qs_Post2Tag`;
TRUNCATE TABLE `qs_PostCategory`;
TRUNCATE TABLE `qs_PostComment`;
TRUNCATE TABLE `qs_PostTag`;
TRUNCATE TABLE `qs_Product`;
TRUNCATE TABLE `qs_Product2Category`;
TRUNCATE TABLE `qs_ProductCategory`;
TRUNCATE TABLE `qs_ProductImage`;
TRUNCATE TABLE `qs_Promo`;
TRUNCATE TABLE `qs_Redirection`;
TRUNCATE TABLE `qs_SanityCheckAppFile`;

-- qs_SanityCheckFileRegistry

TRUNCATE TABLE `qs_SanityCheckUserFile`;

-- qs_Settings
-- qs_SettingsCategory
-- qs_SettingsOptions

TRUNCATE TABLE `qs_ShippingPrice`;
TRUNCATE TABLE `qs_SideBlock`;
TRUNCATE TABLE `qs_SideBlock2Page`;
TRUNCATE TABLE `qs_Slide`;
TRUNCATE TABLE `qs_SlideHotSpot`;
TRUNCATE TABLE `qs_SocialLink`;

-- qs_SocialLinkDictionary

TRUNCATE TABLE `qs_Testimonial`;
TRUNCATE TABLE `qs_Transaction`;
TRUNCATE TABLE `qs_User`;
TRUNCATE TABLE `qs_UserAddress`;
TRUNCATE TABLE `qs_UserCommittee`;
TRUNCATE TABLE `qs_UserList`;
TRUNCATE TABLE `qs_UserRegistrationCompany`;
TRUNCATE TABLE `qs_Company`;
TRUNCATE TABLE `qs_CommitteeDocument`;
TRUNCATE TABLE `qs_Committee`;
TRUNCATE TABLE `qs_Event`;
TRUNCATE TABLE `qs_EventAttendee`;
TRUNCATE TABLE `qs_EventTime`;
TRUNCATE TABLE `qs_LeadershipGroup`;
TRUNCATE TABLE `qs_List`;
TRUNCATE TABLE `qs_ViewControllerLog`;
TRUNCATE TABLE `qs_ViewControllerLogSession`;
TRUNCATE TABLE `qs_WideSlide`;

SET FOREIGN_KEY_CHECKS=1;