# ---------------------------------------------------------------------- #
# Script generated with: DeZign for Databases V7.3.1                     #
# Target DBMS:           MySQL 5                                         #
# Project file:          DISCO Shop.dez                                  #
# Project name:          Datenkraft DISCO 4.0 (Shop)                     #
# Author:                                                                #
# Script type:           Database drop script                            #
# Created on:            2015-09-30 15:11                                #
# ---------------------------------------------------------------------- #


# ---------------------------------------------------------------------- #
# Drop foreign key constraints                                           #
# ---------------------------------------------------------------------- #

ALTER TABLE `ShopArticle_ShopCategory` DROP FOREIGN KEY `ShopCategory_ShopArticle_ShopCategory_1`;

ALTER TABLE `ShopArticle_ShopCategory` DROP FOREIGN KEY `ShopArticle_ShopArticle_ShopCategory_2`;

ALTER TABLE `ShopArticle_ShopCategory` DROP FOREIGN KEY `ShopArticle_ShopCategoryType_ShopArticle_ShopCategory_3`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ArticleEntry_ShopCategory_1`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopCategoryType_ShopCategory_2`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopArticleAttributeType_ShopCategory_3`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopCategory_ShopCategory_4`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopArticleAttributeItem_ShopCategory_5`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopTrackingCode_ShopCategory_6`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopArticleType_ShopCategory_7`;

ALTER TABLE `ShopCategory` DROP FOREIGN KEY `ShopCategory_ShopCategory_8`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopOrder_ShopOrderItem_1`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopArticleItem_ShopOrderItem_2`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopOrderItemType_ShopOrderItem_3`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopOrderItemState_ShopOrderItem_4`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopOrderItemGroup_ShopOrderItem_5`;

ALTER TABLE `ShopOrderItem` DROP FOREIGN KEY `ShopVoucher_ShopOrderItem_6`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopPaymentType_ShopOrder_1`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopOrderPaymentState_ShopOrder_2`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopOrderType_ShopOrder_3`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `Currency_ShopOrder_4`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `Shop_ShopOrder_5`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopUser_ShopOrder_6`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopOrderState_ShopOrder_7`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopDeliveryService_ShopOrder_8`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopOrderSource_ShopOrder_9`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopWAWISupplier_ShopOrder_10`;

ALTER TABLE `ShopOrder` DROP FOREIGN KEY `ShopWAWIStock_ShopOrder_11`;

ALTER TABLE `ShopCustomer` DROP FOREIGN KEY `ShopOrder_ShopCustomer_1`;

ALTER TABLE `ShopCustomer` DROP FOREIGN KEY `Person_ShopCustomer_2`;

ALTER TABLE `ShopCustomer` DROP FOREIGN KEY `Country_ShopCustomer_3`;

ALTER TABLE `ShopCustomer` DROP FOREIGN KEY `Language_ShopCustomer_4`;

ALTER TABLE `ShopCustomer` DROP FOREIGN KEY `Country_ShopCustomer_5`;

ALTER TABLE `ShopCrossSelling` DROP FOREIGN KEY `ShopArticle_ShopCrossSelling_1`;

ALTER TABLE `ShopCrossSelling` DROP FOREIGN KEY `ShopCrossSellingType_ShopCrossSelling_2`;

ALTER TABLE `ShopCrossSelling` DROP FOREIGN KEY `ShopArticle_ShopCrossSelling_3`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `Person_ShopUser_1`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopPaymentType_ShopUser_3`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopPricelist_ShopUser_4`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `Language_ShopUser_5`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `Shop_ShopUser_6`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopUser_ShopUser_7`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopDeliveryService_ShopUser_8`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopPartnerList_ShopUser_9`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopArticleGroup_ShopUser_10`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopUserAddress_ShopUser_12`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopUserAddress_ShopUser_13`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopUserGroup_ShopUser_12`;

ALTER TABLE `ShopUser` DROP FOREIGN KEY `ShopSalesPartner_ShopUser_13`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopArticleType_ShopArticle_1`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ArticleEntry_ShopArticle_2`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopDiscountList_ShopArticle_3`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopVariant_ShopArticle_4`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopArticleDelivery_ShopArticle_5`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopWAWIProductUnit_ShopArticle_6`;

ALTER TABLE `ShopArticle` DROP FOREIGN KEY `ShopWAWISupplier_ShopArticle_7`;

ALTER TABLE `ShopDelivery` DROP FOREIGN KEY `Country_ShopDelivery_1`;

ALTER TABLE `ShopDelivery` DROP FOREIGN KEY `ShopPriceType_ShopDelivery_2`;

ALTER TABLE `ShopDelivery` DROP FOREIGN KEY `ShopWAWITax_ShopDelivery_3`;

ALTER TABLE `ShopDiscountList` DROP FOREIGN KEY `ShopDiscountListType_ShopDiscountList_1`;

ALTER TABLE `ShopDiscountItem` DROP FOREIGN KEY `ShopDiscountList_ShopDiscountItem_1`;

ALTER TABLE `ShopDiscountItem` DROP FOREIGN KEY `ShopPricelist_ShopDiscountItem_2`;

ALTER TABLE `ShopDiscountItem` DROP FOREIGN KEY `Person_ShopDiscountItem_3`;

ALTER TABLE `ShopVariantItem` DROP FOREIGN KEY `ShopVariant_ShopVariantItem_1`;

ALTER TABLE `ShopVariantItem` DROP FOREIGN KEY `ShopVariantItem_ShopVariantItem_2`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticle_ShopArticleItem_1`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticleDelivery_ShopArticleItem_2`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopVariantItem_ShopArticleItem_3`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopWAWIProduct_ShopArticleItem_4`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopDiscountList_ShopArticleItem_5`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticleItem_ShopArticleItem_6`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticleItem_ShopArticleItem_7`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopWAWIProductUnit_ShopArticleItem_8`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticleItemType_ShopArticleItem_9`;

ALTER TABLE `ShopArticleItem` DROP FOREIGN KEY `ShopArticleItemGroup_ShopArticleItem_10`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWITax_ShopWAWIProduct_1`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWISupplier_ShopWAWIProduct_2`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `ShopPriceType_ShopWAWIProduct_3`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWIProductUnit_ShopWAWIProduct_4`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `Currency_ShopWAWIProduct_5`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `Currency_ShopWAWIProduct_6`;

ALTER TABLE `ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWIProductGroup_ShopWAWIProduct_7`;

ALTER TABLE `ShopArticleAttribute` DROP FOREIGN KEY `ShopArticle_ShopArticleAttribute_1`;

ALTER TABLE `ShopArticleAttribute` DROP FOREIGN KEY `ShopArticleAttributeType_ShopArticleAttribute_2`;

ALTER TABLE `ShopArticleAttribute` DROP FOREIGN KEY `ShopArticleAttributeItem_ShopArticleAttribute_3`;

ALTER TABLE `ShopOrderJournal` DROP FOREIGN KEY `ShopOrderJournalType_ShopOrderJournal_1`;

ALTER TABLE `ShopOrderJournal` DROP FOREIGN KEY `ShopOrder_ShopOrderJournal_2`;

ALTER TABLE `ShopOrderJournal` DROP FOREIGN KEY `ShopUser_ShopOrderJournal_3`;

ALTER TABLE `ShopOrderJournal` DROP FOREIGN KEY `ShopOrderJournal_ShopOrderJournal_4`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `ShopVoucherGroup_ShopVoucher_1`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `ShopOrder_ShopVoucher_2`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `Currency_ShopVoucher_3`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `Person_ShopVoucher_4`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `ShopVoucherType_ShopVoucher_5`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `ShopVoucher_ShopVoucher_6`;

ALTER TABLE `ShopVoucher` DROP FOREIGN KEY `ShopUser_ShopVoucher_7`;

ALTER TABLE `ShopVariantAttribute` DROP FOREIGN KEY `ShopVariant_ShopVariantAttribute_1`;

ALTER TABLE `ShopArticleItem_ShopVariantAttribute` DROP FOREIGN KEY `ShopArticleItem_ShopArticleItem_ShopVariantAttribute_1`;

ALTER TABLE `ShopArticleItem_ShopVariantAttribute` DROP FOREIGN KEY `ShopVariantAttribute_ShopArticleItem_ShopVariantAttribute_2`;

ALTER TABLE `Shop` DROP FOREIGN KEY `Country_Shop_1`;

ALTER TABLE `Shop` DROP FOREIGN KEY `Language_Shop_2`;

ALTER TABLE `Shop` DROP FOREIGN KEY `Currency_Shop_3`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `Country_ShopPrice_1`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `ShopArticleItem_ShopPrice_2`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `ShopPriceType_ShopPrice_3`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `Currency_ShopPrice_4`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `Person_ShopPrice_5`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `ShopPriceVariant_ShopPrice_6`;

ALTER TABLE `ShopPrice` DROP FOREIGN KEY `ShopPricelist_ShopPrice_7`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopPricelist_ShopPriceCache_1`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `Country_ShopPriceCache_2`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopArticle_ShopPriceCache_3`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopPriceType_ShopPriceCache_4`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `Currency_ShopPriceCache_5`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopWAWITax_ShopPriceCache_6`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `Person_ShopPriceCache_7`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopArticleItem_ShopPriceCache_8`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopArticleItem_ShopPriceCache_9`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopPrice_ShopPriceCache_10`;

ALTER TABLE `ShopPriceCache` DROP FOREIGN KEY `ShopPriceVariant_ShopPriceCache_11`;

ALTER TABLE `ShopWAWISupplier` DROP FOREIGN KEY `Currency_ShopWAWISupplier_1`;

ALTER TABLE `ShopWAWISupplier` DROP FOREIGN KEY `Language_ShopWAWISupplier_2`;

ALTER TABLE `ShopWAWISupplier` DROP FOREIGN KEY `Country_ShopWAWISupplier_3`;

ALTER TABLE `ShopWAWIDelivery` DROP FOREIGN KEY `ShopWAWIDeliveryState_ShopWAWIDelivery_1`;

ALTER TABLE `ShopWAWIDelivery` DROP FOREIGN KEY `ShopWAWISupplier_ShopWAWIDelivery_2`;

ALTER TABLE `ShopWAWIDelivery` DROP FOREIGN KEY `ShopWAWIDelivery_ShopWAWIDelivery_3`;

ALTER TABLE `ShopWAWITax_Country` DROP FOREIGN KEY `ShopWAWITax_ShopWAWITax_Country_1`;

ALTER TABLE `ShopWAWITax_Country` DROP FOREIGN KEY `Country_ShopWAWITax_Country_2`;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWIDelivery_ShopWAWIDelivery_ShopWAWIProduct_1`;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIDelivery_ShopWAWIProduct_2`;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` DROP FOREIGN KEY `Currency_ShopWAWIDelivery_ShopWAWIProduct_3`;

ALTER TABLE `ShopAccountJournalLine` DROP FOREIGN KEY `ShopAccountJournal_ShopAccountJournalLine_1`;

ALTER TABLE `ShopAccountJournalLine` DROP FOREIGN KEY `Currency_ShopAccountJournalLine_2`;

ALTER TABLE `ShopAccountJournalLine` DROP FOREIGN KEY `ShopOrderItem_ShopAccountJournalLine_3`;

ALTER TABLE `ShopAccountJournalLine` DROP FOREIGN KEY `ShopAccountJournalLine_ShopAccountJournalLine_4`;

ALTER TABLE `ShopAbo` DROP FOREIGN KEY `ShopUser_ShopAbo_1`;

ALTER TABLE `ShopAbo` DROP FOREIGN KEY `ShopOrder_ShopAbo_2`;

ALTER TABLE `ShopAbo` DROP FOREIGN KEY `ShopArticleItem_ShopAbo_3`;

ALTER TABLE `ShopAbo` DROP FOREIGN KEY `ShopOrderItem_ShopAbo_4`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopAccountJournalType_ShopAccountJournal_1`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopOrder_ShopAccountJournal_2`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `Person_ShopAccountJournal_3`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopAccountJournal_ShopAccountJournal_4`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopAccountJournalGroup_ShopAccountJournal_5`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopDeliveryService_ShopAccountJournal_6`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopAccountJournalState_ShopAccountJournal_7`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopWAWISupplier_ShopAccountJournal_8`;

ALTER TABLE `ShopAccountJournal` DROP FOREIGN KEY `ShopWAWIStock_ShopAccountJournal_9`;

ALTER TABLE `ShopWAWIJournal` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIJournal_1`;

ALTER TABLE `ShopWAWIJournal` DROP FOREIGN KEY `ShopWAWIJournalType_ShopWAWIJournal_2`;

ALTER TABLE `ShopWAWIJournal` DROP FOREIGN KEY `ShopWAWIDelivery_ShopWAWIJournal_3`;

ALTER TABLE `ShopWAWIJournal` DROP FOREIGN KEY `ShopAccountJournalLine_ShopWAWIJournal_4`;

ALTER TABLE `ShopWAWIProductPriceJournal` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIProductPriceJournal_1`;

ALTER TABLE `ShopTask` DROP FOREIGN KEY `ShopTaskType_ShopTask_1`;

ALTER TABLE `ShopTask` DROP FOREIGN KEY `ShopOrderJournal_ShopTask_2`;

ALTER TABLE `ShopTaskType_Person` DROP FOREIGN KEY `ShopTaskType_ShopTaskType_Person_1`;

ALTER TABLE `ShopTaskType_Person` DROP FOREIGN KEY `Person_ShopTaskType_Person_2`;

ALTER TABLE `ShopArticleAttributeItem` DROP FOREIGN KEY `ShopArticleAttributeType_ShopArticleAttributeItem_1`;

ALTER TABLE `ShopArticleAttributeItem` DROP FOREIGN KEY `ArticleEntry_ShopArticleAttributeItem_2`;

ALTER TABLE `ShopArticleAttributeItem` DROP FOREIGN KEY `ShopTrackingCode_ShopArticleAttributeItem_3`;

ALTER TABLE `ShopPaymentItem` DROP FOREIGN KEY `ShopOrder_ShopPaymentItem_1`;

ALTER TABLE `ShopPaymentItem` DROP FOREIGN KEY `ShopPaymentType_ShopPaymentItem_2`;

ALTER TABLE `ShopPaymentItem` DROP FOREIGN KEY `ShopPaymentItemType_ShopPaymentItem_3`;

ALTER TABLE `Shop_ShopConfig` DROP FOREIGN KEY `ShopConfig_Shop_ShopConfig_1`;

ALTER TABLE `Shop_ShopConfig` DROP FOREIGN KEY `Shop_Shop_ShopConfig_2`;

ALTER TABLE `Shop_ArticleEntry` DROP FOREIGN KEY `Shop_Shop_ArticleEntry_1`;

ALTER TABLE `Shop_ArticleEntry` DROP FOREIGN KEY `ArticleEntry_Shop_ArticleEntry_2`;

ALTER TABLE `ShopVariantItem_Picture` DROP FOREIGN KEY `ShopVariantItem_ShopVariantItem_Picture_1`;

ALTER TABLE `ShopVariantItem_Picture` DROP FOREIGN KEY `Picture_ShopVariantItem_Picture_2`;

ALTER TABLE `ShopUser_ShopCategory` DROP FOREIGN KEY `ShopUser_ShopUser_ShopCategory_1`;

ALTER TABLE `ShopUser_ShopCategory` DROP FOREIGN KEY `ShopCategory_ShopUser_ShopCategory_2`;

ALTER TABLE `ShopUser_ShopCategory` DROP FOREIGN KEY `ShopUser_ShopCategory_Type_ShopUser_ShopCategory_3`;

ALTER TABLE `ShopArticleItem_FieldData` DROP FOREIGN KEY `ShopArticleItem_ShopArticleItem_FieldData_1`;

ALTER TABLE `ShopArticleItem_FieldData` DROP FOREIGN KEY `FieldData_ShopArticleItem_FieldData_2`;

ALTER TABLE `ShopWAWIProduct_FieldData` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIProduct_FieldData_1`;

ALTER TABLE `ShopWAWIProduct_FieldData` DROP FOREIGN KEY `FieldData_ShopWAWIProduct_FieldData_2`;

ALTER TABLE `ShopFilterConfig` DROP FOREIGN KEY `ShopCategory_ShopFilterConfig_1`;

ALTER TABLE `ShopFilterConfig` DROP FOREIGN KEY `ShopArticleAttributeType_ShopFilterConfig_2`;

ALTER TABLE `ShopFilterConfig` DROP FOREIGN KEY `ShopFilterConfigType_ShopFilterConfig_3`;

ALTER TABLE `ShopWAWIDeliveryValue` DROP FOREIGN KEY `ShopWAWIDeliveryValueType_ShopWAWIDeliveryValue_1`;

ALTER TABLE `ShopWAWISupplier_ShopWAWIDeliveryValue` DROP FOREIGN KEY `ShopWAWISupplier_ShopWAWISupplier_ShopWAWIDeliveryValue_1`;

ALTER TABLE `ShopWAWISupplier_ShopWAWIDeliveryValue` DROP FOREIGN KEY `ShopWAWIDeliveryValue_ShopWAWISupplier_ShopWAWIDeliveryValue_2`;

ALTER TABLE `ShopWAWIDeliveryProductValue` DROP FOREIGN KEY `ShopWAWIDelivery_ShopWAWIProduct_ShopWAWIDeliveryProductValue_1`;

ALTER TABLE `ShopWAWIDeliveryProductValue` DROP FOREIGN KEY `ShopWAWIDeliveryValue_ShopWAWIDeliveryProductValue_2`;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIDeliveryValue` DROP FOREIGN KEY `ShopWAWIDelivery_ShopWAWIDelivery_ShopWAWIDeliveryValue_1`;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIDeliveryValue` DROP FOREIGN KEY `ShopWAWIDeliveryValue_ShopWAWIDelivery_ShopWAWIDeliveryValue_2`;

ALTER TABLE `ShopAbo_ShopOrder` DROP FOREIGN KEY `ShopAbo_ShopAbo_ShopOrder_1`;

ALTER TABLE `ShopAbo_ShopOrder` DROP FOREIGN KEY `ShopOrder_ShopAbo_ShopOrder_2`;

ALTER TABLE `ShopOrderItemGroup` DROP FOREIGN KEY `ShopArticleItem_ShopOrderItemGroup_1`;

ALTER TABLE `ShopVoucher_ShopVoucherFunction` DROP FOREIGN KEY `ShopVoucher_ShopVoucher_ShopVoucherFunction_1`;

ALTER TABLE `ShopVoucher_ShopVoucherFunction` DROP FOREIGN KEY `ShopVoucherFunction_ShopVoucher_ShopVoucherFunction_2`;

ALTER TABLE `ShopVoucher_ShopArticle` DROP FOREIGN KEY `ShopVoucher_ShopVoucher_ShopArticle_1`;

ALTER TABLE `ShopVoucher_ShopArticle` DROP FOREIGN KEY `ShopArticle_ShopVoucher_ShopArticle_2`;

ALTER TABLE `ShopArticleItemGroup` DROP FOREIGN KEY `ShopArticle_ShopArticleItemGroup_1`;

ALTER TABLE `ShopUser_ShopUserOption` DROP FOREIGN KEY `ShopUser_ShopUser_ShopUserOption_1`;

ALTER TABLE `ShopUser_ShopUserOption` DROP FOREIGN KEY `ShopUserOption_ShopUser_ShopUserOption_2`;

ALTER TABLE `ShopCategory_ShopCategoryFunction` DROP FOREIGN KEY `ShopCategory_ShopCategory_ShopCategoryFunction_1`;

ALTER TABLE `ShopCategory_ShopCategoryFunction` DROP FOREIGN KEY `ShopCategoryFunction_ShopCategory_ShopCategoryFunction_2`;

ALTER TABLE `ShopDeliveryServiceOption` DROP FOREIGN KEY `ShopDeliveryService_ShopDeliveryServiceOption_1`;

ALTER TABLE `ShopOrder_ShopDeliveryServiceOption` DROP FOREIGN KEY `ShopOrder_ShopOrder_ShopDeliveryServiceOption_1`;

ALTER TABLE `ShopOrder_ShopDeliveryServiceOption` DROP FOREIGN KEY `ShopDeliveryServiceOption_ShopOrder_ShopDeliveryServiceOption_2`;

ALTER TABLE `ShopAccountJournal_ShopDeliveryServiceOption` DROP FOREIGN KEY `SAJ_SAJ_SDS_1`;

ALTER TABLE `ShopAccountJournal_ShopDeliveryServiceOption` DROP FOREIGN KEY `SDSO_SAJ_SDS_2`;

ALTER TABLE `ShopArticleItem_Picture` DROP FOREIGN KEY `ShopArticleItem_ShopArticleItem_Picture_1`;

ALTER TABLE `ShopArticleItem_Picture` DROP FOREIGN KEY `Picture_ShopArticleItem_Picture_2`;

ALTER TABLE `ShopUser_FieldData` DROP FOREIGN KEY `ShopUser_ShopUser_FieldData_1`;

ALTER TABLE `ShopUser_FieldData` DROP FOREIGN KEY `FieldData_ShopUser_FieldData_2`;

ALTER TABLE `ShopWAWIProductDeliveryPacking` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIProductDeliveryPacking_1`;

ALTER TABLE `ShopWAWIProductDeliveryPacking` DROP FOREIGN KEY `ShopWAWIProductUnit_ShopWAWIProductDeliveryPacking_2`;

ALTER TABLE `ShopTask_Person` DROP FOREIGN KEY `ShopTask_ShopTask_Person_1`;

ALTER TABLE `ShopTask_Person` DROP FOREIGN KEY `Person_ShopTask_Person_2`;

ALTER TABLE `ShopArticleGroup` DROP FOREIGN KEY `ShopArticleGroupType_ShopArticleGroup_1`;

ALTER TABLE `ShopArticle_ShopArticleGroup` DROP FOREIGN KEY `ShopArticleGroup_ShopArticle_ShopArticleGroup_1`;

ALTER TABLE `ShopArticle_ShopArticleGroup` DROP FOREIGN KEY `ShopArticle_ShopArticle_ShopArticleGroup_2`;

ALTER TABLE `ShopPartnerBrokerage` DROP FOREIGN KEY `ShopArticleGroup_ShopPartnerBrokerage_1`;

ALTER TABLE `ShopPartnerBrokerage` DROP FOREIGN KEY `ShopPartnerBrokerageType_ShopPartnerBrokerage_2`;

ALTER TABLE `ShopPartnerBrokerage` DROP FOREIGN KEY `ShopPartnerList_ShopPartnerBrokerage_3`;

ALTER TABLE `ShopArticleInterests` DROP FOREIGN KEY `ShopArticle_ShopArticleInterests_1`;

ALTER TABLE `ShopArticleInterests` DROP FOREIGN KEY `Person_ShopArticleInterests_2`;

ALTER TABLE `ShopArticleInterests` DROP FOREIGN KEY `ShopArticleInterestsType_ShopArticleInterests_3`;

ALTER TABLE `ShopArticleInterests` DROP FOREIGN KEY `ShopArticleItem_ShopArticleInterests_4`;

ALTER TABLE `ShopArticleInterests` DROP FOREIGN KEY `Shop_ShopArticleInterests_5`;

ALTER TABLE `ShopVoucher_ShopCategory` DROP FOREIGN KEY `ShopVoucher_ShopVoucher_ShopCategory_1`;

ALTER TABLE `ShopVoucher_ShopCategory` DROP FOREIGN KEY `ShopCategory_ShopVoucher_ShopCategory_2`;

ALTER TABLE `ShopSearch` DROP FOREIGN KEY `Shop_ShopSearch_1`;

ALTER TABLE `ShopSearch` DROP FOREIGN KEY `Language_ShopSearch_2`;

ALTER TABLE `ShopSearch` DROP FOREIGN KEY `ShopUser_ShopSearch_3`;

ALTER TABLE `ShopCategory_ShopArticleAttributeItem` DROP FOREIGN KEY `ShopCategory_ShopCategory_ShopArticleAttributeItem_1`;

ALTER TABLE `ShopCategory_ShopArticleAttributeItem` DROP FOREIGN KEY `ShopArticleAttributeItem_ShopCategory_ShopArticleAttributeItem_2`;

ALTER TABLE `ShopCategory_ShopArticleAttributeItem` DROP FOREIGN KEY `ArticleEntry_ShopCategory_ShopArticleAttributeItem_3`;

ALTER TABLE `ShopWAWISupplierProduct` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWISupplierProduct_1`;

ALTER TABLE `ShopWAWISupplierProduct` DROP FOREIGN KEY `ShopWAWISupplier_ShopWAWISupplierProduct_2`;

ALTER TABLE `ShopWAWISupplierProduct` DROP FOREIGN KEY `Currency_ShopWAWISupplierProduct_3`;

ALTER TABLE `ShopUserAddress` DROP FOREIGN KEY `ShopUser_ShopUserAddress_1`;

ALTER TABLE `ShopUserAddress` DROP FOREIGN KEY `Country_ShopUserAddress_2`;

ALTER TABLE `ShopWAWIProduct_ShopWAWIStock` DROP FOREIGN KEY `ShopWAWIProduct_ShopWAWIProduct_ShopWAWIStock_1`;

ALTER TABLE `ShopWAWIProduct_ShopWAWIStock` DROP FOREIGN KEY `ShopWAWIStock_ShopWAWIProduct_ShopWAWIStock_2`;

ALTER TABLE `ShopUserManager` DROP FOREIGN KEY `Worker_ShopUserManager_1`;

ALTER TABLE `ShopUserRelationship` DROP FOREIGN KEY `ShopUserRelationshipType_ShopUserRelationship_1`;

ALTER TABLE `ShopUserRelationship` DROP FOREIGN KEY `ShopUser_ShopUserRelationship_2`;

ALTER TABLE `ShopUserRelationship` DROP FOREIGN KEY `ShopUser_ShopUserRelationship_3`;

ALTER TABLE `ShopSalesPartner` DROP FOREIGN KEY `ShopUser_ShopSalesPartner_1`;

# ---------------------------------------------------------------------- #
# Drop table "ShopSalesPartner"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopSalesPartner` MODIFY `ShopSalesPartner_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopSalesPartner` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopSalesPartner`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserRelationship"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopUserRelationship` MODIFY `ShopUserRelationship_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopUserRelationship` ALTER COLUMN `ShopUserRelationship_Order` DROP DEFAULT;

ALTER TABLE `ShopUserRelationship` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserRelationship`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserAddress"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopUserAddress` MODIFY `ShopUserAddress_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopUserAddress` ALTER COLUMN `ShopUserAddress_Sex` DROP DEFAULT;

ALTER TABLE `ShopUserAddress` ALTER COLUMN `ShopUserAddress_IsCompany` DROP DEFAULT;

ALTER TABLE `ShopUserAddress` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserAddress`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCategory_ShopArticleAttributeItem"                     #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopCategory_ShopArticleAttributeItem` MODIFY `ShopCategory_ShopArticleAttributeItem_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopCategory_ShopArticleAttributeItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCategory_ShopArticleAttributeItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopSearch"                                                #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopSearch` MODIFY `ShopSearch_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopSearch` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopSearch`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucher_ShopCategory"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVoucher_ShopCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucher_ShopCategory`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleInterests"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleInterests` MODIFY `ShopArticleInterests_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleInterests` ALTER COLUMN `ShopArticleInterests_Active` DROP DEFAULT;

ALTER TABLE `ShopArticleInterests` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleInterests`;

# ---------------------------------------------------------------------- #
# Drop table "ShopTask_Person"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopTask_Person` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopTask_Person`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUser_FieldData"                                        #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUser_FieldData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUser_FieldData`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItem_Picture"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleItem_Picture` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItem_Picture`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournal_ShopDeliveryServiceOption"              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopAccountJournal_ShopDeliveryServiceOption` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournal_ShopDeliveryServiceOption`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrder_ShopDeliveryServiceOption"                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrder_ShopDeliveryServiceOption` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrder_ShopDeliveryServiceOption`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCategory_ShopCategoryFunction"                         #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopCategory_ShopCategoryFunction` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCategory_ShopCategoryFunction`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUser_ShopUserOption"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUser_ShopUserOption` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUser_ShopUserOption`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucher_ShopArticle"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVoucher_ShopArticle` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucher_ShopArticle`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucher_ShopVoucherFunction"                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVoucher_ShopVoucherFunction` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucher_ShopVoucherFunction`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderItemGroup"                                        #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopOrderItemGroup` MODIFY `ShopOrderItemGroup_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopOrderItemGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderItemGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAbo_ShopOrder"                                         #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopAbo_ShopOrder` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAbo_ShopOrder`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDelivery_ShopWAWIDeliveryValue"                    #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDelivery_ShopWAWIDeliveryValue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDelivery_ShopWAWIDeliveryValue`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDeliveryProductValue"                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDeliveryProductValue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDeliveryProductValue`;

# ---------------------------------------------------------------------- #
# Drop table "ShopFilterConfig"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopFilterConfig` MODIFY `ShopFilterConfig_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopFilterConfig` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopFilterConfig`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItem_FieldData"                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleItem_FieldData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItem_FieldData`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUser_ShopCategory"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUser_ShopCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUser_ShopCategory`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVariantItem_Picture"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVariantItem_Picture` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVariantItem_Picture`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPaymentItem"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopPaymentItem` MODIFY `ShopPaymentItem_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopPaymentItem` ALTER COLUMN `ShopOrder_ID` DROP DEFAULT;

ALTER TABLE `ShopPaymentItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPaymentItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopTask"                                                  #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopTask` MODIFY `ShopTask_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopTask` ALTER COLUMN `ShopTask_Active` DROP DEFAULT;

ALTER TABLE `ShopTask` ALTER COLUMN `ShopTask_ShowToUser` DROP DEFAULT;

ALTER TABLE `ShopTask` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopTask`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIJournal"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIJournal` MODIFY `ShopWAWIJournal_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIJournal` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIJournal`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournal"                                        #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopAccountJournal` MODIFY `ShopAccountJournal_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopAccountJournal` ALTER COLUMN `ShopAccountJournal_Active` DROP DEFAULT;

ALTER TABLE `ShopAccountJournal` ALTER COLUMN `ShopAccountJournal_Complete` DROP DEFAULT;

ALTER TABLE `ShopAccountJournal` ALTER COLUMN `ShopAccountJournal_ShowVAT` DROP DEFAULT;

ALTER TABLE `ShopAccountJournal` ALTER COLUMN `ShopAccountJournal_Brokerage` DROP DEFAULT;

ALTER TABLE `ShopAccountJournal` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournal`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAbo"                                                   #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopAbo` MODIFY `ShopAbo_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopAbo` ALTER COLUMN `ShopAbo_Active` DROP DEFAULT;

ALTER TABLE `ShopAbo` ALTER COLUMN `ShopAbo_ItemCount` DROP DEFAULT;

ALTER TABLE `ShopAbo` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAbo`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournalLine"                                    #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopAccountJournalLine` MODIFY `ShopAccountJournalLine_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopAccountJournalLine` ALTER COLUMN `ShopAccountJournalLine_ExchangeRate` DROP DEFAULT;

ALTER TABLE `ShopAccountJournalLine` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournalLine`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDelivery_ShopWAWIProduct"                          #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` ALTER COLUMN `ShopWAWIDelivery_ShopWAWIProduct_OrderClosed` DROP DEFAULT;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` ALTER COLUMN `ShopWAWIDelivery_ShopWAWIProduct_DeliverClosed` DROP DEFAULT;

ALTER TABLE `ShopWAWIDelivery_ShopWAWIProduct` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDelivery_ShopWAWIProduct`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDelivery"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIDelivery` MODIFY `ShopWAWIDelivery_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIDelivery` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDelivery`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPriceCache"                                            #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopPriceCache` MODIFY `ShopPriceCache_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopPriceCache` ALTER COLUMN `ShopPriceCache_Listprice` DROP DEFAULT;

ALTER TABLE `ShopPriceCache` ALTER COLUMN `ShopPriceCache_IgnoreMinPrice` DROP DEFAULT;

ALTER TABLE `ShopPriceCache` ALTER COLUMN `ShopPriceCache_IsMinPrice` DROP DEFAULT;

ALTER TABLE `ShopPriceCache` ALTER COLUMN `ShopPriceCache_MinStock` DROP DEFAULT;

ALTER TABLE `ShopPriceCache` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPriceCache`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPrice"                                                 #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopPrice` MODIFY `ShopPrice_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopPrice` ALTER COLUMN `ShopPrice_Count` DROP DEFAULT;

ALTER TABLE `ShopPrice` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPrice`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItem_ShopVariantAttribute"                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleItem_ShopVariantAttribute` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItem_ShopVariantAttribute`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucher"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopVoucher` MODIFY `ShopVoucher_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_Type` DROP DEFAULT;

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_Active` DROP DEFAULT;

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_Regenerate` DROP DEFAULT;

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_AllowInvoice` DROP DEFAULT;

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_Uniquely` DROP DEFAULT;

ALTER TABLE `ShopVoucher` ALTER COLUMN `ShopVoucher_MinOrder` DROP DEFAULT;

ALTER TABLE `ShopVoucher` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucher`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderJournal"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopOrderJournal` MODIFY `ShopOrderJournal_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopOrderJournal` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderJournal`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItem"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleItem` MODIFY `ShopArticleItem_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_Show` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_IgnoreMinPrice` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_StockRestriction` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_CartCount` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_ProductCount` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_FreeDelivery` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` ALTER COLUMN `ShopArticleItem_Buyable` DROP DEFAULT;

ALTER TABLE `ShopArticleItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVariantItem"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopVariantItem` MODIFY `ShopVariantItem_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopVariantItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVariantItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUser"                                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_Active` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_IsCompany` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_DeliveryWithInvoice` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_AllowInvoice` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_Partner` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_Partner_Interval` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_Delivery_Free` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_IsAnoymous` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_LoyaltyBonus` DROP DEFAULT;

ALTER TABLE `ShopUser` ALTER COLUMN `ShopUser_Imported` DROP DEFAULT;

ALTER TABLE `ShopUser` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUser`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCustomer"                                              #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopCustomer` MODIFY `ShopCustomer_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopCustomer` ALTER COLUMN `ShopCustomer_Person_Sex` DROP DEFAULT;

ALTER TABLE `ShopCustomer` ALTER COLUMN `ShopCustomer_CreditCard3DSecure` DROP DEFAULT;

ALTER TABLE `ShopCustomer` ALTER COLUMN `ShopCustomer_IsCompany` DROP DEFAULT;

ALTER TABLE `ShopCustomer` ALTER COLUMN `ShopCustomer_DeliverySex` DROP DEFAULT;

ALTER TABLE `ShopCustomer` ALTER COLUMN `ShopCustomer_DeliveryWithInvoice` DROP DEFAULT;

ALTER TABLE `ShopCustomer` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCustomer`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrder"                                                 #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopOrder` MODIFY `ShopOrder_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopOrder` ALTER COLUMN `ShopOrder_ShowVAT` DROP DEFAULT;

ALTER TABLE `ShopOrder` ALTER COLUMN `ShopOrder_TrackedExternal` DROP DEFAULT;

ALTER TABLE `ShopOrder` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrder`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderItem"                                             #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopOrderItem` MODIFY `ShopOrderItem_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopOrderItem` ALTER COLUMN `ShopOrderItem_ListPriceExcl` DROP DEFAULT;

ALTER TABLE `ShopOrderItem` ALTER COLUMN `ShopOrderItem_ListPriceIncl` DROP DEFAULT;

ALTER TABLE `ShopOrderItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCategory"                                              #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopCategory` MODIFY `ShopCategory_ID` INTEGER(11) NOT NULL;

# Drop constraints #

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_Show` DROP DEFAULT;

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_Glassy` DROP DEFAULT;

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_IsDynamic` DROP DEFAULT;

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_IsCopied` DROP DEFAULT;

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_AddFilter` DROP DEFAULT;

ALTER TABLE `ShopCategory` ALTER COLUMN `ShopCategory_QualitycheckContent` DROP DEFAULT;

ALTER TABLE `ShopCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCategory`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticle_ShopCategory"                                  #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticle_ShopCategory` MODIFY `ShopArticle_ShopCategory_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticle_ShopCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticle_ShopCategory`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCrossSelling"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopCrossSelling` MODIFY `ShopCrossSelling_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopCrossSelling` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCrossSelling`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticle_ShopArticleGroup"                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticle_ShopArticleGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticle_ShopArticleGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItemGroup"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleItemGroup` MODIFY `ShopArticleItemGroup_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleItemGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItemGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleAttribute"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleAttribute` MODIFY `ShopArticleAttribute_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleAttribute` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleAttribute`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticle"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticle` MODIFY `ShopArticle_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticle` ALTER COLUMN `ShopArticle_Show` DROP DEFAULT;

ALTER TABLE `ShopArticle` ALTER COLUMN `ShopArticle_PackingUnit` DROP DEFAULT;

ALTER TABLE `ShopArticle` ALTER COLUMN `ShopArticle_Buyable` DROP DEFAULT;

ALTER TABLE `ShopArticle` ALTER COLUMN `ShopArticle_OrderWeight` DROP DEFAULT;

ALTER TABLE `ShopArticle` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticle`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProduct_ShopWAWIStock"                             #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIProduct_ShopWAWIStock` MODIFY `ShopWAWIProduct_ShopWAWIStock_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIProduct_ShopWAWIStock` ALTER COLUMN `ShopWAWIProduct_ShopWAWIStock_Stock` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct_ShopWAWIStock` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProduct_ShopWAWIStock`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWISupplierProduct"                                   #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWISupplierProduct` MODIFY `ShopWAWISupplierProduct_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWISupplierProduct` ALTER COLUMN `ShopWAWISupplierProduct_InStock` DROP DEFAULT;

ALTER TABLE `ShopWAWISupplierProduct` ALTER COLUMN `ShopWAWISupplierProduct_Active` DROP DEFAULT;

ALTER TABLE `ShopWAWISupplierProduct` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWISupplierProduct`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPartnerBrokerage"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopPartnerBrokerage` MODIFY `ShopPartnerBrokerage_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopPartnerBrokerage` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPartnerBrokerage`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleGroup"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleGroup` MODIFY `ShopArticleGroup_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleGroup` ALTER COLUMN `ShopArticleGroup_Show` DROP DEFAULT;

ALTER TABLE `ShopArticleGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProductDeliveryPacking"                            #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIProductDeliveryPacking` MODIFY `ShopWAWIProductDeliveryPacking_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIProductDeliveryPacking` ALTER COLUMN `ShopWAWIProductDeliveryPacking_ConsiderInCreation` DROP DEFAULT;

ALTER TABLE `ShopWAWIProductDeliveryPacking` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProductDeliveryPacking`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWISupplier_ShopWAWIDeliveryValue"                    #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWISupplier_ShopWAWIDeliveryValue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWISupplier_ShopWAWIDeliveryValue`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDeliveryValue"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDeliveryValue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDeliveryValue`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProduct_FieldData"                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIProduct_FieldData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProduct_FieldData`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleAttributeItem"                                  #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleAttributeItem` MODIFY `ShopArticleAttributeItem_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleAttributeItem` ALTER COLUMN `ShopArticleAttributeItem_Show` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleAttributeItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProductPriceJournal"                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIProductPriceJournal` MODIFY `ShopWAWIProductPriceJournal_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIProductPriceJournal` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProductPriceJournal`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProduct"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIProduct` MODIFY `ShopWAWIProduct_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Show` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Active` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Imported` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Stock_Min` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Stock_PreFill` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Delivery_Packing_Size_Modifier` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Fragile` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` ALTER COLUMN `ShopWAWIProduct_Virtual` DROP DEFAULT;

ALTER TABLE `ShopWAWIProduct` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProduct`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDiscountItem"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopDiscountItem` MODIFY `ShopDiscountItem_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopDiscountItem` ALTER COLUMN `ShopDiscountItem_Count` DROP DEFAULT;

ALTER TABLE `ShopDiscountItem` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDiscountItem`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDiscountList"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopDiscountList` MODIFY `ShopDiscountList_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopDiscountList` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDiscountList`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDelivery"                                              #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopDelivery` MODIFY `ShopDelivery_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopDelivery` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDelivery`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserRelationshipType"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUserRelationshipType` ALTER COLUMN `ShopUserRelationshipType_Order` DROP DEFAULT;

ALTER TABLE `ShopUserRelationshipType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserRelationshipType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserGroup"                                             #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopUserGroup` MODIFY `ShopUserGroup_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopUserGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserManager"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUserManager` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserManager`;

# ---------------------------------------------------------------------- #
# Drop table "Worker"                                                    #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Worker` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Worker`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIStock"                                             #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIStock` MODIFY `ShopWAWIStock_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIStock` ALTER COLUMN `ShopWAWIStock_Active` DROP DEFAULT;

ALTER TABLE `ShopWAWIStock` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIStock`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProductGroup"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWIProductGroup` MODIFY `ShopWAWIProductGroup_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWIProductGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProductGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderSource"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderSource` ALTER COLUMN `ShopOrderSource_ShowFilter` DROP DEFAULT;

ALTER TABLE `ShopOrderSource` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderSource`;

# ---------------------------------------------------------------------- #
# Drop table "ShopTrackingCode"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopTrackingCode` MODIFY `ShopTrackingCode_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopTrackingCode` ALTER COLUMN `ShopTrackingCode_Active` DROP DEFAULT;

ALTER TABLE `ShopTrackingCode` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopTrackingCode`;

# ---------------------------------------------------------------------- #
# Drop table "ShopSqlReport"                                             #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopSqlReport` MODIFY `ShopSqlReport_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopSqlReport` ALTER COLUMN `ShopSqlReport_Show` DROP DEFAULT;

ALTER TABLE `ShopSqlReport` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopSqlReport`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleInterestsType"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleInterestsType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleInterestsType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPartnerBrokerageType"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPartnerBrokerageType` ALTER COLUMN `ShopPartnerBrokerageType_Show` DROP DEFAULT;

ALTER TABLE `ShopPartnerBrokerageType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPartnerBrokerageType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPartnerList"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopPartnerList` MODIFY `ShopPartnerList_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopPartnerList` ALTER COLUMN `ShopPartnerList_Show` DROP DEFAULT;

ALTER TABLE `ShopPartnerList` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPartnerList`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleGroupType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleGroupType` ALTER COLUMN `ShopArticleGroupType_Show` DROP DEFAULT;

ALTER TABLE `ShopArticleGroupType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleGroupType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournalState"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopAccountJournalState` ALTER COLUMN `ShopAccountJournalState_Active` DROP DEFAULT;

ALTER TABLE `ShopAccountJournalState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournalState`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDeliveryServiceOption"                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopDeliveryServiceOption` ALTER COLUMN `ShopDeliveryServiceOption_Show` DROP DEFAULT;

ALTER TABLE `ShopDeliveryServiceOption` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDeliveryServiceOption`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCategoryFunction"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopCategoryFunction` ALTER COLUMN `ShopCategoryFunction_Active` DROP DEFAULT;

ALTER TABLE `ShopCategoryFunction` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCategoryFunction`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUserOption"                                            #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUserOption` ALTER COLUMN `ShopUserOption_Show` DROP DEFAULT;

ALTER TABLE `ShopUserOption` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUserOption`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucherType"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVoucherType` ALTER COLUMN `ShopVoucherType_Active` DROP DEFAULT;

ALTER TABLE `ShopVoucherType` ALTER COLUMN `ShopVoucherType_Discount` DROP DEFAULT;

ALTER TABLE `ShopVoucherType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucherType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucherFunction"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVoucherFunction` ALTER COLUMN `ShopVoucherFunction_Active` DROP DEFAULT;

ALTER TABLE `ShopVoucherFunction` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucherFunction`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleItemType"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleItemType` ALTER COLUMN `ShopArticleItemType_Active` DROP DEFAULT;

ALTER TABLE `ShopArticleItemType` ALTER COLUMN `ShopArticleItemType_Bundle` DROP DEFAULT;

ALTER TABLE `ShopArticleItemType` ALTER COLUMN `ShopArticleItemType_Group` DROP DEFAULT;

ALTER TABLE `ShopArticleItemType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleItemType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDeliveryService"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopDeliveryService` ALTER COLUMN `ShopDeliveryService_Selectable` DROP DEFAULT;

ALTER TABLE `ShopDeliveryService` ALTER COLUMN `ShopDeliveryService_ShowTrackingNumber` DROP DEFAULT;

ALTER TABLE `ShopDeliveryService` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDeliveryService`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDeliveryValueType"                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDeliveryValueType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDeliveryValueType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPriceVariant"                                          #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPriceVariant` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPriceVariant`;

# ---------------------------------------------------------------------- #
# Drop table "ShopFilterConfigType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopFilterConfigType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopFilterConfigType`;

# ---------------------------------------------------------------------- #
# Drop table "FieldData"                                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `FieldData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldData`;

# ---------------------------------------------------------------------- #
# Drop table "ShopUser_ShopCategory_Type"                                #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopUser_ShopCategory_Type` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopUser_ShopCategory_Type`;

# ---------------------------------------------------------------------- #
# Drop table "Picture"                                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Picture` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Picture`;

# ---------------------------------------------------------------------- #
# Drop table "Shop_ArticleEntry"                                         #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Shop_ArticleEntry` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Shop_ArticleEntry`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournalGroup"                                   #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopAccountJournalGroup` MODIFY `ShopAccountJournalGroup_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopAccountJournalGroup` ALTER COLUMN `ShopAccountJournalGroup_Active` DROP DEFAULT;

ALTER TABLE `ShopAccountJournalGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournalGroup`;

# ---------------------------------------------------------------------- #
# Drop table "Shop_ShopConfig"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Shop_ShopConfig` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Shop_ShopConfig`;

# ---------------------------------------------------------------------- #
# Drop table "ShopConfig"                                                #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopConfig` ALTER COLUMN `ShopConfig_Critical` DROP DEFAULT;

ALTER TABLE `ShopConfig` ALTER COLUMN `ShopConfig_Required` DROP DEFAULT;

ALTER TABLE `ShopConfig` ALTER COLUMN `ShopConfig_Multiline` DROP DEFAULT;

ALTER TABLE `ShopConfig` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopConfig`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPaymentItemType"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPaymentItemType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPaymentItemType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIProductUnit"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIProductUnit` ALTER COLUMN `ShopWAWIProductUnit_Standard` DROP DEFAULT;

ALTER TABLE `ShopWAWIProductUnit` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIProductUnit`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCategoryType"                                          #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopCategoryType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCategoryType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticle_ShopCategoryType"                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticle_ShopCategoryType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticle_ShopCategoryType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderItemState"                                        #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderItemState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderItemState`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderState"                                            #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderState`;

# ---------------------------------------------------------------------- #
# Drop table "ShopTaskType_Person"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopTaskType_Person` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopTaskType_Person`;

# ---------------------------------------------------------------------- #
# Drop table "ShopTaskType"                                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopTaskType` ALTER COLUMN `ShopTaskType_Active` DROP DEFAULT;

ALTER TABLE `ShopTaskType` ALTER COLUMN `ShopTaskType_SendMailOnCreation` DROP DEFAULT;

ALTER TABLE `ShopTaskType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopTaskType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIJournalType"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIJournalType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIJournalType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPriceType"                                             #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPriceType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPriceType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopAccountJournalType"                                    #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopAccountJournalType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopAccountJournalType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWITax_Country"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWITax_Country` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWITax_Country`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWIDeliveryState"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWIDeliveryState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWIDeliveryState`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWITax"                                               #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopWAWITax` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWITax`;

# ---------------------------------------------------------------------- #
# Drop table "ShopWAWISupplier"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopWAWISupplier` MODIFY `ShopWAWISupplier_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopWAWISupplier` ALTER COLUMN `ShopWAWISupplier_Dropshipping` DROP DEFAULT;

ALTER TABLE `ShopWAWISupplier` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopWAWISupplier`;

# ---------------------------------------------------------------------- #
# Drop table "Shop"                                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Shop` ALTER COLUMN `Shop_ShopArticle_Enabled` DROP DEFAULT;

ALTER TABLE `Shop` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Shop`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVariantAttribute"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopVariantAttribute` MODIFY `ShopVariantAttribute_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ShopVariantAttribute` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVariantAttribute`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVoucherGroup"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopVoucherGroup` MODIFY `ShopVoucherGroup_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopVoucherGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVoucherGroup`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderJournalType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderJournalType` ALTER COLUMN `ShopOrderJournalType_Visible` DROP DEFAULT;

ALTER TABLE `ShopOrderJournalType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderJournalType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderItemType"                                         #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderItemType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderItemType`;

# ---------------------------------------------------------------------- #
# Drop table "Language"                                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Language` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Language`;

# ---------------------------------------------------------------------- #
# Drop table "Currency"                                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Currency` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Currency`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleAttributeType"                                  #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleAttributeType` MODIFY `ShopArticleAttributeType_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_Filter` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_FilterMultipleChoice` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_Show` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_ShowOnDetailPage` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_ShowOnCategoryPage` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_Compare` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_Tracking` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` ALTER COLUMN `ShopArticleAttributeType_HasCategoryPages` DROP DEFAULT;

ALTER TABLE `ShopArticleAttributeType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleAttributeType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPricelist"                                             #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPricelist` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPricelist`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderType"                                             #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopCrossSellingType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopCrossSellingType` ALTER COLUMN `ShopCrossSellingType_Show` DROP DEFAULT;

ALTER TABLE `ShopCrossSellingType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopCrossSellingType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleDelivery"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopArticleDelivery` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleDelivery`;

# ---------------------------------------------------------------------- #
# Drop table "ShopVariant"                                               #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopVariant` ALTER COLUMN `ShopVariant_HasSubLevel` DROP DEFAULT;

ALTER TABLE `ShopVariant` ALTER COLUMN `ShopVariant_Common` DROP DEFAULT;

ALTER TABLE `ShopVariant` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopVariant`;

# ---------------------------------------------------------------------- #
# Drop table "ShopDiscountListType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopDiscountListType` ALTER COLUMN `ShopDiscountListType_Show` DROP DEFAULT;

ALTER TABLE `ShopDiscountListType` ALTER COLUMN `ShopDiscountListType_Group` DROP DEFAULT;

ALTER TABLE `ShopDiscountListType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopDiscountListType`;

# ---------------------------------------------------------------------- #
# Drop table "ShopOrderPaymentState"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopOrderPaymentState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopOrderPaymentState`;

# ---------------------------------------------------------------------- #
# Drop table "ShopPaymentType"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ShopPaymentType` ALTER COLUMN `ShopPaymentType_Abo` DROP DEFAULT;

ALTER TABLE `ShopPaymentType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopPaymentType`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntry"                                              #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ArticleEntry` MODIFY `ArticleEntry_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ArticleEntry` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry`;

# ---------------------------------------------------------------------- #
# Drop table "Country"                                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Country` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Country`;

# ---------------------------------------------------------------------- #
# Drop table "ShopArticleType"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ShopArticleType` MODIFY `ShopArticleType_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `ShopArticleType` ALTER COLUMN `ShopArticleType_System` DROP DEFAULT;

ALTER TABLE `ShopArticleType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ShopArticleType`;

# ---------------------------------------------------------------------- #
# Drop table "Person"                                                    #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Person` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Person`;
