Changeset 734

Timestamp:

Mar 15, 2015, 10:42:57 AM (10 years ago)

Author:

chronos

Message:

• Fixed: Databae upgrade script.

File:

• trunk/Common/Setup/Updates.php (modified) (1 diff)

trunk/Common/Setup/Updates.php

@@ -1214 +1214 @@
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Name` varchar(255) NOT NULL,
-  `Class` varchar(255) NOT NULL
+  `Class` varchar(255) NOT NULL,
+        PRIMARY KEY (`Id`)
 ) 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('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) VALUES (NULL, "Import bankovních účtů", "ScheduleBankImport");');
+  $Manager->Execute('UPDATE `Scheduler` SET `Action` = 1 WHERE `Scheduler`.`Id` = 1;');
   $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");');  
 }