Changeset 486 for trunk/sql/updates/479.sql

Timestamp:

Feb 10, 2013, 9:20:06 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Příprava na zrušení tabulek dokladů a jejich převedení na tabulky File a FinanceInvoice.

File:

• trunk/sql/updates/479.sql (modified) (2 diffs)

trunk/sql/updates/479.sql

@@ -41 +41 @@
   ADD CONSTRAINT `Service_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ServiceCategory` (`Id`);
 
+ALTER TABLE `ServiceCustomerRel` ADD FOREIGN KEY ( `Service` ) REFERENCES `Service` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+
 -- Transform data from FinanceTariff
 INSERT INTO Service (SELECT Id AS Id, Name, `Group` AS Category, Price, MemberCount AS CustomerCount, 
@@ -60 +63 @@
 ALTER TABLE `Service` ADD INDEX ( `ReplaceId` ) ;
 ALTER TABLE `Service` ADD FOREIGN KEY ( `ReplaceId` ) REFERENCES `Service` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+