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

Timestamp:

Jan 13, 2015, 12:18:19 AM (10 years ago)

Author:

chronos

Message:

• Added: Scheduler available action table. Modules can register actions as read only items in table.

File:

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

trunk/Common/Setup/Updates.php

@@ -1207 +1207 @@
   
   $Manager->Execute('INSERT INTO `Module` (`Id`, `Name`, `Title`) VALUES (NULL, "Plánovač", "Scheduler");');
+}
+
+function UpdateTo730($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `SchedulerAction` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Class` varchar(255) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');      
+        $Manager->Execute('ALTER TABLE `SchedulerAction` ADD PRIMARY KEY (`Id`);');
+        
+  $Manager->Execute('ALTER TABLE `Scheduler` CHANGE `Class` `Action` INT(11) NOT NULL;');
+  $Manager->Execute("ALTER TABLE `Scheduler` ADD INDEX ( `Action` ) ");
+  $Manager->Execute('ALTER TABLE `Scheduler` ADD CONSTRAINT `Schedule_ibfk_2` FOREIGN KEY (`Action`) REFERENCES `SchedulerAction` (`Id`);');
+  $Manager->Execute('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) VALUES (NULL, "Import bankovních účtů", "ScheduleBankImport");');  
 }
 
@@ -1271 +1286 @@
         725 => array('Revision' => 726, 'Function' => 'UpdateTo726'),
         726 => array('Revision' => 729, 'Function' => 'UpdateTo729'),
+        729 => array('Revision' => 730, 'Function' => 'UpdateTo730'),
     ));
   }