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

Timestamp:

May 31, 2014, 1:07:01 AM (10 years ago)

Author:

chronos

Message:

• Upraveno: Definice třídy Subject přesunuta do samostatného modulu Subject.
• Přidáno: K Subjektům přidána definice Kontaktů a druhů kontaktů.

File:

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

trunk/Common/Setup/Updates.php

@@ -727 +727 @@
 }
 
+function UpdateTo661($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `Contact` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Category` int(11) NOT NULL,
+    `Value` varchar(255) NOT NULL,
+    `Subject` int(11) DEFAULT NULL,
+    `User` int(11) DEFAULT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Category` (`Category`),
+    KEY `User` (`User`),
+    KEY `Subject` (`Subject`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `ContactCategory` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Name` varchar(255) NOT NULL,
+    PRIMARY KEY (`Id`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `Contact`
+    ADD CONSTRAINT `Contact_ibfk_3` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
+    ADD CONSTRAINT `Contact_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ContactCategory` (`Id`),
+    ADD CONSTRAINT `Contact_ibfk_2` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`);');
+
+  $Manager->Execute("INSERT INTO `Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Kontakty', '1', '/is/?t=Contact&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Kontakty', '12', '".$ActionId."', '1');");
+  $ConatctMenuId = $Manager->Database->insert_id;
+
+  $Manager->Execute("INSERT INTO `Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Druhy kontakty', '1', '/is/?t=ContactCategory&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Druhy kontaktů', ".$ConatctMenuId.", '".$ActionId."', '1');");
+
+  $Manager->Execute("INSERT INTO `ContactCategory` (`Id` ,`Name`)
+VALUES (NULL , 'Telefón'), (NULL , 'ICQ'), (NULL , 'Jabber'), (NULL , 'Email'), (NULL , 'Skype');");
+}
+
 class Updates
 {
@@ -767 +813 @@
       646 => array('Revision' => 647, 'Function' => 'UpdateTo647'),
       647 => array('Revision' => 657, 'Function' => 'UpdateTo657'),
+      657 => array('Revision' => 661, 'Function' => 'UpdateTo661'),
     ));
   }