Changeset 596 for trunk/Common/Setup/Updates.php
- Timestamp:
- Nov 20, 2013, 10:37:38 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Common/Setup/Updates.php
r595 r596 427 427 $Manager->Execute("UPDATE `PermissionOperation` SET `Module` = 'Meals' WHERE `PermissionOperation`.`Module` ='EatingPlace';"); 428 428 $Manager->Execute("UPDATE `PermissionOperation` SET `Module` = 'NetworkShare' WHERE `PermissionOperation`.`Module` ='Share';"); 429 $Manager->Execute("UPDATE `PermissionOperation` SET `Module` = ' SubjectOpenTime' WHERE `PermissionOperation`.`Module` ='OpeningHours';");429 $Manager->Execute("UPDATE `PermissionOperation` SET `Module` = 'OpeningHours' WHERE `PermissionOperation`.`Module` ='SubjectOpenTime';"); 430 430 $Manager->Execute("UPDATE `PermissionOperation` SET `Module`=(SELECT `Id` FROM `Module` WHERE `Module`.`Name` = `PermissionOperation`.`Module`)"); 431 431 $Manager->Execute("ALTER TABLE `PermissionOperation` CHANGE `Module` `Module` INT( 11 ) NOT NULL ;"); … … 445 445 $Manager->Execute('ALTER TABLE `StockItem` ADD `Esemble` INT NULL , 446 446 ADD INDEX ( `Esemble` ) ;'); 447 $Manager->Execute('ALTER TABLE `StockItem` ADD FOREIGN KEY ( `Esemble` ) REFERENCES StockItem` (447 $Manager->Execute('ALTER TABLE `StockItem` ADD FOREIGN KEY ( `Esemble` ) REFERENCES `StockItem` ( 448 448 `Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;'); 449 449 }
Note:
See TracChangeset
for help on using the changeset viewer.