# ---------------------------------------------------------------------- #
# Script generated with: DeZign for Databases V7.3.1                     #
# Target DBMS:           MySQL 5                                         #
# Project file:          DISCO Shop Cms.dez                              #
# Project name:          Datenkraft DISCO 4.0 (CMS)                      #
# Author:                                                                #
# Script type:           Database drop script                            #
# Created on:            2015-05-07 13:47                                #
# ---------------------------------------------------------------------- #


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

ALTER TABLE `PersonGroup` DROP FOREIGN KEY `PersonGroupType_PersonGroup`;

ALTER TABLE `Person` DROP FOREIGN KEY `PersonGroup_Person`;

ALTER TABLE `Country` DROP FOREIGN KEY `Language_Country`;

ALTER TABLE `Country` DROP FOREIGN KEY `Currency_Country`;

ALTER TABLE `Authorization` DROP FOREIGN KEY `AuthorizationSubType_Authorization`;

ALTER TABLE `Worker` DROP FOREIGN KEY `Person_Worker`;

ALTER TABLE `Worker` DROP FOREIGN KEY `Language_Worker`;

ALTER TABLE `Person_Authorization` DROP FOREIGN KEY `Authorization_Person_Authorization`;

ALTER TABLE `Person_Authorization` DROP FOREIGN KEY `Person_Person_Authorization`;

ALTER TABLE `PersonGroup_Authorization` DROP FOREIGN KEY `PersonGroup_PersonGroup_Authorization`;

ALTER TABLE `PersonGroup_Authorization` DROP FOREIGN KEY `Authorization_PersonGroup_Authorization`;

ALTER TABLE `Menu` DROP FOREIGN KEY `Authorization_Menu`;

ALTER TABLE `MenuParameter` DROP FOREIGN KEY `Menu_MenuParameter`;

ALTER TABLE `LTMTranslation_Language` DROP FOREIGN KEY `LTMTranslation_LTMTranslation_Language`;

ALTER TABLE `LTMTranslation_Language` DROP FOREIGN KEY `Language_LTMTranslation_Language`;

ALTER TABLE `ArticleEntry_Document` DROP FOREIGN KEY `Document_ArticleEntry_Document`;

ALTER TABLE `ArticleEntry_Document` DROP FOREIGN KEY `ArticleEntry_ArticleEntry_Document`;

ALTER TABLE `ArticleEntry_Link` DROP FOREIGN KEY `ArticleEntry_ArticleEntry_Link`;

ALTER TABLE `ArticleEntry_Link` DROP FOREIGN KEY `Link_ArticleEntry_Link`;

ALTER TABLE `ArticleEntry_Picture` DROP FOREIGN KEY `ArticleEntry_ArticleEntry_Picture`;

ALTER TABLE `ArticleEntry_Picture` DROP FOREIGN KEY `Picture_ArticleEntry_Picture`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `ArticleEntry_CMSArticle_Parent`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `Language_CMSArticle`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `CMSArticleCategory_CMSArticle`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `Person_CMSArticle`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `ArticleEntry_CMSArticle`;

ALTER TABLE `CMSArticle` DROP FOREIGN KEY `CMSArticle_CMSArticle`;

ALTER TABLE `Document` DROP FOREIGN KEY `DocumentCategory_Document`;

ALTER TABLE `Document` DROP FOREIGN KEY `Picture_Document`;

ALTER TABLE `Link` DROP FOREIGN KEY `LinkCategory_Link`;

ALTER TABLE `Picture` DROP FOREIGN KEY `PictureCategory_Picture`;

ALTER TABLE `PictureFile` DROP FOREIGN KEY `PictureFile_Type_PictureFile`;

ALTER TABLE `PictureFile` DROP FOREIGN KEY `Picture_PictureFile`;

ALTER TABLE `Version` DROP FOREIGN KEY `VersionType_Version`;

ALTER TABLE `Version` DROP FOREIGN KEY `Language_Version`;

ALTER TABLE `Version` DROP FOREIGN KEY `VersionState_Version`;

ALTER TABLE `Version` DROP FOREIGN KEY `Person_Version`;

ALTER TABLE `Contact` DROP FOREIGN KEY `Person_Contact`;

ALTER TABLE `Contact` DROP FOREIGN KEY `ContactType_Contact`;

ALTER TABLE `Language_Person` DROP FOREIGN KEY `Language_Language_Person`;

ALTER TABLE `Language_Person` DROP FOREIGN KEY `Person_Language_Person`;

ALTER TABLE `NewsletterRecipient` DROP FOREIGN KEY `Person_NewsletterRecipient`;

ALTER TABLE `NewsletterRecipient` DROP FOREIGN KEY `Language_NewsletterRecipient`;

ALTER TABLE `NewsletterRecipient` DROP FOREIGN KEY `NewsletterRecipientImport_NewsletterRecipient`;

ALTER TABLE `Newsletter` DROP FOREIGN KEY `NewsletterState_Newsletter`;

ALTER TABLE `Newsletter` DROP FOREIGN KEY `ArticleEntry_Newsletter`;

ALTER TABLE `Newsletter` DROP FOREIGN KEY `NewsletterType_Newsletter`;

ALTER TABLE `NewsletterGroup_NewsletterRecipient` DROP FOREIGN KEY `NewsletterGroup_NewsletterGroup_NewsletterRecipient`;

ALTER TABLE `NewsletterGroup_NewsletterRecipient` DROP FOREIGN KEY `NewsletterRecipient_NewsletterGroup_NewsletterRecipient`;

ALTER TABLE `NewsletterQueue` DROP FOREIGN KEY `NewsletterRecipient_NewsletterQueue`;

ALTER TABLE `NewsletterQueue` DROP FOREIGN KEY `Newsletter_NewsletterQueue`;

ALTER TABLE `NewsletterQueue` DROP FOREIGN KEY `Language_NewsletterQueue`;

ALTER TABLE `NewsletterQueue` DROP FOREIGN KEY `NewsletterInstance_NewsletterQueue`;

ALTER TABLE `Newsletter_ArticleEntry` DROP FOREIGN KEY `ArticleEntry_Newsletter_ArticleEntry`;

ALTER TABLE `Newsletter_ArticleEntry` DROP FOREIGN KEY `Newsletter_Newsletter_ArticleEntry`;

ALTER TABLE `NewsletterType` DROP FOREIGN KEY `NewsletterGroup_NewsletterType`;

ALTER TABLE `Customer` DROP FOREIGN KEY `Person_Customer`;

ALTER TABLE `Customer` DROP FOREIGN KEY `Country_Customer`;

ALTER TABLE `Customer` DROP FOREIGN KEY `Language_Customer`;

ALTER TABLE `FieldDefinition` DROP FOREIGN KEY `FieldDefinitionDatatype_FieldDefinition`;

ALTER TABLE `FieldDefinition` DROP FOREIGN KEY `FieldDefinitionType_FieldDefinition`;

ALTER TABLE `FieldData` DROP FOREIGN KEY `FieldDefinition_FieldData`;

ALTER TABLE `FieldData` DROP FOREIGN KEY `ArticleEntry_FieldData`;

ALTER TABLE `FieldSelect` DROP FOREIGN KEY `FieldDefinition_FieldSelect`;

ALTER TABLE `FieldSelect` DROP FOREIGN KEY `FieldSelect_FieldSelect`;

ALTER TABLE `FieldData_FieldSelect` DROP FOREIGN KEY `FieldData_FieldData_FieldSelect`;

ALTER TABLE `FieldData_FieldSelect` DROP FOREIGN KEY `FieldSelect_FieldData_FieldSelect`;

ALTER TABLE `NewsletterClickJournal` DROP FOREIGN KEY `NewsletterQueue_NewsletterClickJournal`;

ALTER TABLE `ArticleEntry_MapLocation` DROP FOREIGN KEY `ArticleEntry_ArticleEntry_MapLocation`;

ALTER TABLE `ArticleEntry_MapLocation` DROP FOREIGN KEY `MapLocation_ArticleEntry_MapLocation`;

ALTER TABLE `MapLocation` DROP FOREIGN KEY `MapLocationCategory_MapLocation`;

ALTER TABLE `Queue` DROP FOREIGN KEY `QueueState_Queue`;

ALTER TABLE `Queue` DROP FOREIGN KEY `QueueType_Queue`;

ALTER TABLE `QueueData` DROP FOREIGN KEY `Queue_QueueData`;

ALTER TABLE `Rating` DROP FOREIGN KEY `ArticleEntry_Rating`;

ALTER TABLE `ArticleEntryDateTime` DROP FOREIGN KEY `ArticleEntry_ArticleEntryDateTime`;

ALTER TABLE `ArticleEntryDateTime` DROP FOREIGN KEY `ArticleEntryDateTimeType_ArticleEntryDateTime`;

ALTER TABLE `CountryZone_Country` DROP FOREIGN KEY `CountryZone_CountryZone_Country`;

ALTER TABLE `CountryZone_Country` DROP FOREIGN KEY `Country_CountryZone_Country`;

ALTER TABLE `Clipboard` DROP FOREIGN KEY `Worker_Clipboard`;

# ---------------------------------------------------------------------- #
# Drop table "FieldData_FieldSelect"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `FieldData_FieldSelect` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldData_FieldSelect`;

# ---------------------------------------------------------------------- #
# Drop table "FieldSelect"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `FieldSelect` MODIFY `FieldSelect_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `FieldSelect` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldSelect`;

# ---------------------------------------------------------------------- #
# Drop table "CMSArticle"                                                #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `CMSArticle` MODIFY `CMSArticle_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `CMSArticle` ALTER COLUMN `CMSArticle_Linked` DROP DEFAULT;

ALTER TABLE `CMSArticle` DROP PRIMARY KEY;

DROP INDEX `TUC_CMSArticle_1` ON `CMSArticle`;

# Drop table #

DROP TABLE `CMSArticle`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntry_Document"                                     #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ArticleEntry_Document` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry_Document`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntry_MapLocation"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ArticleEntry_MapLocation` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry_MapLocation`;

# ---------------------------------------------------------------------- #
# Drop table "Document"                                                  #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Document` MODIFY `Document_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `Document` ALTER COLUMN `__Document_Show` DROP DEFAULT;

ALTER TABLE `Document` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Document`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntry_Picture"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ArticleEntry_Picture` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry_Picture`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntry_Link"                                         #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ArticleEntry_Link` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry_Link`;

# ---------------------------------------------------------------------- #
# Drop table "Clipboard"                                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Clipboard` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Clipboard`;

# ---------------------------------------------------------------------- #
# Drop table "CountryZone_Country"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `CountryZone_Country` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `CountryZone_Country`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntryDateTime"                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `ArticleEntryDateTime` MODIFY `ArticleEntryDateTime_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `ArticleEntryDateTime` ALTER COLUMN `ArticleEntryDateTime_Main` DROP DEFAULT;

ALTER TABLE `ArticleEntryDateTime` ALTER COLUMN `ArticleEntryDateTime_Active` DROP DEFAULT;

ALTER TABLE `ArticleEntryDateTime` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntryDateTime`;

# ---------------------------------------------------------------------- #
# Drop table "QueueData"                                                 #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `QueueData` MODIFY `QueueData_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `QueueData` ALTER COLUMN `QueueData_Done` DROP DEFAULT;

ALTER TABLE `QueueData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `QueueData`;

# ---------------------------------------------------------------------- #
# Drop table "Queue"                                                     #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Queue` MODIFY `Queue_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `Queue` ALTER COLUMN `Queue_Priority` DROP DEFAULT;

ALTER TABLE `Queue` ALTER COLUMN `Queue_Lock` DROP DEFAULT;

ALTER TABLE `Queue` ALTER COLUMN `Queue_Active` DROP DEFAULT;

ALTER TABLE `Queue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Queue`;

# ---------------------------------------------------------------------- #
# Drop table "MapLocation"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `MapLocation` MODIFY `MapLocation_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `MapLocation` ALTER COLUMN `MapLocation_RoutingDestination` DROP DEFAULT;

ALTER TABLE `MapLocation` ALTER COLUMN `__MapLocation_Show` DROP DEFAULT;

ALTER TABLE `MapLocation` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `MapLocation`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterClickJournal"                                    #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterClickJournal` MODIFY `NewsletterClickJournal_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterClickJournal` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterClickJournal`;

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

# Remove autoinc for PK drop #

ALTER TABLE `FieldData` MODIFY `FieldData_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `FieldData` ALTER COLUMN `FieldData_Boolean` DROP DEFAULT;

ALTER TABLE `FieldData` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldData`;

# ---------------------------------------------------------------------- #
# Drop table "FieldDefinition"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `FieldDefinition` MODIFY `FieldDefinition_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `FieldDefinition` ALTER COLUMN `FieldDefinition_ActiveFrontend` DROP DEFAULT;

ALTER TABLE `FieldDefinition` ALTER COLUMN `FieldDefinition_ActiveBackend` DROP DEFAULT;

ALTER TABLE `FieldDefinition` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldDefinition`;

# ---------------------------------------------------------------------- #
# Drop table "Customer"                                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Customer` ALTER COLUMN `Customer_Active` DROP DEFAULT;

ALTER TABLE `Customer` ALTER COLUMN `Customer_IsCompany` DROP DEFAULT;

ALTER TABLE `Customer` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Customer`;

# ---------------------------------------------------------------------- #
# Drop table "Newsletter_ArticleEntry"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Newsletter_ArticleEntry` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Newsletter_ArticleEntry`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterQueue"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterQueue` MODIFY `NewsletterQueue_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterQueue` ALTER COLUMN `NewsletterQueue_Send` DROP DEFAULT;

ALTER TABLE `NewsletterQueue` ALTER COLUMN `NewsletterQueue_Tries` DROP DEFAULT;

ALTER TABLE `NewsletterQueue` ALTER COLUMN `NewsletterQueue_BounceBack` DROP DEFAULT;

ALTER TABLE `NewsletterQueue` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterQueue`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterGroup_NewsletterRecipient"                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `NewsletterGroup_NewsletterRecipient` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterGroup_NewsletterRecipient`;

# ---------------------------------------------------------------------- #
# Drop table "Newsletter"                                                #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Newsletter` MODIFY `Newsletter_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `Newsletter` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Newsletter`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterRecipient"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `NewsletterRecipient` ALTER COLUMN `NewsletterRecipient_Active` DROP DEFAULT;

ALTER TABLE `NewsletterRecipient` ALTER COLUMN `NewsletterRecipient_PrivateSalutation` DROP DEFAULT;

ALTER TABLE `NewsletterRecipient` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterRecipient`;

# ---------------------------------------------------------------------- #
# Drop table "Language_Person"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Language_Person` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Language_Person`;

# ---------------------------------------------------------------------- #
# Drop table "Contact"                                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Contact` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Contact`;

# ---------------------------------------------------------------------- #
# Drop table "Version"                                                   #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Version` MODIFY `Version_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `Version` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Version`;

# ---------------------------------------------------------------------- #
# Drop table "PictureFile"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `PictureFile` MODIFY `PictureFile_ID` INTEGER UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `PictureFile` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PictureFile`;

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

# Remove autoinc for PK drop #

ALTER TABLE `Picture` MODIFY `Picture_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `Picture` ALTER COLUMN `Picture_Symbolic` DROP DEFAULT;

ALTER TABLE `Picture` ALTER COLUMN `Picture_XRated` DROP DEFAULT;

ALTER TABLE `Picture` ALTER COLUMN `__Picture_Show` DROP DEFAULT;

ALTER TABLE `Picture` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Picture`;

# ---------------------------------------------------------------------- #
# Drop table "Link"                                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Link` MODIFY `Link_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `Link` ALTER COLUMN `__Link_Show` DROP DEFAULT;

ALTER TABLE `Link` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Link`;

# ---------------------------------------------------------------------- #
# Drop table "PersonGroup_Authorization"                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `PersonGroup_Authorization` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PersonGroup_Authorization`;

# ---------------------------------------------------------------------- #
# Drop table "Person_Authorization"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Person_Authorization` ALTER COLUMN `Person_Authorization_Access` DROP DEFAULT;

ALTER TABLE `Person_Authorization` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Person_Authorization`;

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

# Drop constraints #

ALTER TABLE `Worker` ALTER COLUMN `Worker_Active` DROP DEFAULT;

ALTER TABLE `Worker` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Worker`;

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

# Drop constraints #

ALTER TABLE `Country` ALTER COLUMN `Country_EUMember` DROP DEFAULT;

ALTER TABLE `Country` ALTER COLUMN `Country_Show` DROP DEFAULT;

ALTER TABLE `Country` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Country`;

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

# Remove autoinc for PK drop #

ALTER TABLE `Person` MODIFY `Person_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `Person` ALTER COLUMN `Person_Sex` DROP DEFAULT;

ALTER TABLE `Person` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Person`;

# ---------------------------------------------------------------------- #
# Drop table "PersonGroup"                                               #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `PersonGroup` MODIFY `PersonGroup_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `PersonGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PersonGroup`;

# ---------------------------------------------------------------------- #
# Drop table "Sms"                                                       #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Sms` MODIFY `Sms_ID` INTEGER(11) NOT NULL;

# Drop constraints #

ALTER TABLE `Sms` ALTER COLUMN `Sms_ErrorCount` DROP DEFAULT;

ALTER TABLE `Sms` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Sms`;

# ---------------------------------------------------------------------- #
# Drop table "CountryZone"                                               #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `CountryZone` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `CountryZone`;

# ---------------------------------------------------------------------- #
# Drop table "ArticleEntryDateTimeType"                                  #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ArticleEntryDateTimeType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntryDateTimeType`;

# ---------------------------------------------------------------------- #
# Drop table "Rating"                                                    #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Rating` MODIFY `Rating_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `Rating` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Rating`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterFilter"                                          #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterFilter` MODIFY `NewsletterFilter_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterFilter` ALTER COLUMN `NewsletterFilter_Active` DROP DEFAULT;

ALTER TABLE `NewsletterFilter` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterFilter`;

# ---------------------------------------------------------------------- #
# Drop table "QueueType"                                                 #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `QueueType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `QueueType`;

# ---------------------------------------------------------------------- #
# Drop table "QueueState"                                                #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `QueueState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `QueueState`;

# ---------------------------------------------------------------------- #
# Drop table "MapLocationCategory"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `MapLocationCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `MapLocationCategory`;

# ---------------------------------------------------------------------- #
# Drop table "FieldDefinitionDatatype"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `FieldDefinitionDatatype` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldDefinitionDatatype`;

# ---------------------------------------------------------------------- #
# Drop table "FieldDefinitionType"                                       #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `FieldDefinitionType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `FieldDefinitionType`;

# ---------------------------------------------------------------------- #
# Drop table "LinkCategory"                                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `LinkCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `LinkCategory`;

# ---------------------------------------------------------------------- #
# Drop table "ContactType"                                               #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `ContactType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ContactType`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterRecipientImport"                                 #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterRecipientImport` MODIFY `NewsletterRecipientImport_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterRecipientImport` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterRecipientImport`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterInstance"                                        #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterInstance` MODIFY `NewsletterInstance_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterInstance` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterInstance`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterType"                                            #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `NewsletterType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterType`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterState"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `NewsletterState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterState`;

# ---------------------------------------------------------------------- #
# Drop table "NewsletterGroup"                                           #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `NewsletterGroup` MODIFY `NewsletterGroup_ID` INTEGER NOT NULL;

# Drop constraints #

ALTER TABLE `NewsletterGroup` ALTER COLUMN `NewsletterGroup_Show` DROP DEFAULT;

ALTER TABLE `NewsletterGroup` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `NewsletterGroup`;

# ---------------------------------------------------------------------- #
# Drop table "CMSMapping"                                                #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `CMSMapping` ALTER COLUMN `CMSMapping_Internal` DROP DEFAULT;

ALTER TABLE `CMSMapping` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `CMSMapping`;

# ---------------------------------------------------------------------- #
# Drop table "VersionState"                                              #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `VersionState` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `VersionState`;

# ---------------------------------------------------------------------- #
# Drop table "VersionType"                                               #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `VersionType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `VersionType`;

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

# Drop constraints #

ALTER TABLE `Currency` ALTER COLUMN `Currency_ExchangeRate` DROP DEFAULT;

ALTER TABLE `Currency` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Currency`;

# ---------------------------------------------------------------------- #
# Drop table "PictureCategory"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `PictureCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PictureCategory`;

# ---------------------------------------------------------------------- #
# Drop table "DocumentCategory"                                          #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `DocumentCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `DocumentCategory`;

# ---------------------------------------------------------------------- #
# Drop table "PictureFile_Type"                                          #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `PictureFile_Type` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PictureFile_Type`;

# ---------------------------------------------------------------------- #
# Drop table "CMSArticleCategory"                                        #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `CMSArticleCategory` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `CMSArticleCategory`;

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

# Remove autoinc for PK drop #

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

# Drop constraints #

ALTER TABLE `ArticleEntry` ALTER COLUMN `ArticleEntry_Date` DROP DEFAULT;

ALTER TABLE `ArticleEntry` ALTER COLUMN `ArticleEntry_Expire` DROP DEFAULT;

ALTER TABLE `ArticleEntry` ALTER COLUMN `__ArticleEntry_Show` DROP DEFAULT;

ALTER TABLE `ArticleEntry` ALTER COLUMN `__ArticleEntry_HTML` DROP DEFAULT;

ALTER TABLE `ArticleEntry` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `ArticleEntry`;

# ---------------------------------------------------------------------- #
# Drop table "PersonGroupType"                                           #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `PersonGroupType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `PersonGroupType`;

# ---------------------------------------------------------------------- #
# Drop table "LTMTranslation_Language"                                   #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `LTMTranslation_Language` ALTER COLUMN `Translation_UserEdit` DROP DEFAULT;

ALTER TABLE `LTMTranslation_Language` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `LTMTranslation_Language`;

# ---------------------------------------------------------------------- #
# Drop table "LTMTranslation"                                            #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `LTMTranslation` ALTER COLUMN `Translation_Internal` DROP DEFAULT;

ALTER TABLE `LTMTranslation` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `LTMTranslation`;

# ---------------------------------------------------------------------- #
# Drop table "MenuParameter"                                             #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `MenuParameter` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `MenuParameter`;

# ---------------------------------------------------------------------- #
# Drop table "Menu"                                                      #
# ---------------------------------------------------------------------- #

# Remove autoinc for PK drop #

ALTER TABLE `Menu` MODIFY `Menu_ID` INTEGER(10) UNSIGNED NOT NULL;

# Drop constraints #

ALTER TABLE `Menu` ALTER COLUMN `Menu_Show` DROP DEFAULT;

ALTER TABLE `Menu` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Menu`;

# ---------------------------------------------------------------------- #
# Drop table "Authorization"                                             #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `Authorization` ALTER COLUMN `Authorization_Type` DROP DEFAULT;

ALTER TABLE `Authorization` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Authorization`;

# ---------------------------------------------------------------------- #
# Drop table "AuthorizationSubType"                                      #
# ---------------------------------------------------------------------- #

# Drop constraints #

ALTER TABLE `AuthorizationSubType` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `AuthorizationSubType`;

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

# Drop constraints #

ALTER TABLE `Language` ALTER COLUMN `Language_Charset` DROP DEFAULT;

ALTER TABLE `Language` ALTER COLUMN `Language_Backend_Show` DROP DEFAULT;

ALTER TABLE `Language` ALTER COLUMN `Language_Frontend_Show` DROP DEFAULT;

ALTER TABLE `Language` DROP PRIMARY KEY;

# Drop table #

DROP TABLE `Language`;
