Changeset 646 for trunk/Common/Setup/Updates.php

Timestamp:

Mar 25, 2014, 12:35:46 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Tabulka Smlouvy.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -576 +576 @@
 }
 
+function UpdateTo646($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `Contract` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `BillCode` varchar(255) NOT NULL,
+  `Subject` int(11) NOT NULL,
+  `DocumentLine` int(11) NOT NULL,
+  `ValidFrom` date NOT NULL,
+  `ValidTo` date DEFAULT NULL,
+  `File` int(11) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Subject` (`Subject`),
+  KEY `DocumentLine` (`DocumentLine`),
+  KEY `File` (`File`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+  $Manager->Execute('ALTER TABLE `Contract`
+  ADD CONSTRAINT `Contract_ibfk_3` FOREIGN KEY (`File`) REFERENCES `File` (`Id`),
+  ADD CONSTRAINT `Contract_ibfk_1` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),
+  ADD CONSTRAINT `Contract_ibfk_2` FOREIGN KEY (`DocumentLine`) REFERENCES `DocumentLine` (`Id`);
+');
+  $Manager->Execute("INSERT INTO `Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Smlouvy', '1', '/is/?t=Contract&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Smlouvy', '2', '".$ActionId."', '1');");
+  $Manager->Execute("INSERT INTO `Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Sazby DPH', '1', '/is/?t=FinanceVAT&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Sazby DPH', '2', '".$ActionId."', '1');");
+}
+
 
 class Updates
@@ -614 +650 @@
       632 => array('Revision' => 633, 'Function' => 'UpdateTo633'),
       633 => array('Revision' => 645, 'Function' => 'UpdateTo645'),
+      645 => array('Revision' => 646, 'Function' => 'UpdateTo646'),
     ));
   }