diff options
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 9eee1ab..8a59fbb 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -193,7 +193,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenu` ( KEY `membershipID` (`membershipID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ALTER TABLE `pbs_bootmenu` ADD `startcounter` INT NOT NULL AFTER `title`; -ALTER TABLE `pbs_bootmenu` CHANGE `startcounter` `startcounter` INT( 11 ) NOT NULL DEFAULT '300' +ALTER TABLE `pbs_bootmenu` CHANGE `startcounter` `startcounter` INT( 11 ) NOT NULL DEFAULT '300'; ALTER TABLE `pbs_bootmenu` ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL, |