ALTER TABLE `ShopUser`
	ADD COLUMN `Country_Code` char(2) NOT NULL AFTER `Person_ID`,
	ADD COLUMN `Country_Code_Invoice` char(2) DEFAULT NULL AFTER `ShopArticleGroup_ID`,
	ADD COLUMN `ShopUser_AdditionalName` varchar(255) DEFAULT NULL AFTER `ShopUser_Active`,
	ADD COLUMN `ShopUser_Street` varchar(255) NOT NULL AFTER `ShopUser_IsCompany`,
	ADD COLUMN `ShopUser_ZIPCode` varchar(10) NOT NULL AFTER `ShopUser_Street`,
	ADD COLUMN `ShopUser_City` varchar(255) NOT NULL AFTER `ShopUser_ZIPCode`,
	ADD COLUMN `ShopUser_District` varchar(255) DEFAULT NULL AFTER `ShopUser_City`,
	ADD COLUMN `ShopUser_DeliveryCompany` varchar(255) DEFAULT NULL AFTER `ShopUser_District`,
	ADD COLUMN `ShopUser_DeliverySex` enum('male','female','unknown') NOT NULL DEFAULT 'unknown' AFTER `ShopUser_DeliveryCompany`,
	ADD COLUMN `ShopUser_DeliveryTitle` varchar(100) DEFAULT NULL AFTER `ShopUser_DeliverySex`,
	ADD COLUMN `ShopUser_DeliveryFirstname` varchar(255) DEFAULT NULL AFTER `ShopUser_DeliveryTitle`,
	ADD COLUMN `ShopUser_DeliveryLastname` varchar(255) DEFAULT NULL AFTER `ShopUser_DeliveryFirstname`,
	ADD COLUMN `ShopUser_DeliveryStreet` varchar(255) DEFAULT NULL AFTER `ShopUser_DeliveryLastname`,
	ADD COLUMN `ShopUser_DeliveryZIPCode` varchar(10) DEFAULT NULL AFTER `ShopUser_DeliveryStreet`,
	ADD COLUMN `ShopUser_DeliveryCity` varchar(255) DEFAULT NULL AFTER `ShopUser_DeliveryZIPCode`,
	ADD COLUMN `ShopUser_DeliveryDistrict` varchar(255) DEFAULT NULL AFTER `ShopUser_DeliveryCity`,
	ADD COLUMN `ShopUser_UID` varchar(255) DEFAULT NULL AFTER `ShopUser_Fax`,
	ADD COLUMN `ShopUser_AddressNumber` varchar(255) DEFAULT NULL AFTER `ShopUser_Info`,
	ADD COLUMN `ShopUser_Hash` varchar(255) DEFAULT NULL AFTER `ShopUser_AddressNumber`;


CREATE INDEX `IDX_ShopUser_4` ON `ShopUser` (`Country_Code`);
CREATE INDEX `IDX_ShopUser_13` ON `ShopUser` (`Country_Code_Invoice`);
	
ALTER TABLE `ShopUser`
	ADD CONSTRAINT `Country_ShopUser_11` FOREIGN KEY (`Country_Code_Invoice`) REFERENCES `Country` (`Country_Code`),
	ADD CONSTRAINT `Country_ShopUser_2` FOREIGN KEY (`Country_Code`) REFERENCES `Country` (`Country_Code`) ON UPDATE CASCADE;
	
ALTER TABLE `ShopCustomer`
	ADD COLUMN `ShopCustomer_District` varchar(40) DEFAULT NULL AFTER `ShopCustomer_City`,
	ADD COLUMN `ShopCustomer_DeliveryDistrict` varchar(255) DEFAULT NULL AFTER `ShopCustomer_DeliveryCity`,
	ADD COLUMN `ShopCustomer_AddressNumber` varchar(255) DEFAULT NULL AFTER `ShopCustomer_AccountName`,
	ADD COLUMN `ShopCustomer_Hash` varchar(255) DEFAULT NULL AFTER `ShopCustomer_AddressNumber`;



