-- ------------------------
-- 13.1.2016 --- Innerdienst column in ShopCustomer
-- ------------------------
ALTER TABLE `ShopCustomer`
	ADD COLUMN `ShopCustomer_Innerdienst` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `ShopCustomer_Billpay_InvoiceDueDate`;

ALTER TABLE `ShopCustomer`
	ADD CONSTRAINT `ShopCustomer_Innerdienst_1` FOREIGN KEY (`ShopCustomer_Innerdienst`) REFERENCES `Person` (`Person_ID`);




-- ------------------------
-- 13.1.2016 Freigabe status (0/1)
-- ------------------------
ALTER TABLE `ShopOrder`
	ADD COLUMN `ShopOrder_Released` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `ShopOrder_ComissionNumber`;