diff options
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 3 |
1 files changed, 3 insertions, 0 deletions
@@ -216,6 +216,9 @@ CREATE TABLE IF NOT EXISTS `pbs_session` ( KEY `bootosID` (`bootosID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ALTER TABLE `pbs_session` ADD `bootisoID` INT NOT NULL AFTER `bootosID`; +ALTER TABLE `pbs_session` ADD `alphasessionID` VARCHAR( 16 ) NOT NULL AFTER `sessionID` , +ADD UNIQUE (`alphasessionID`) ; +ALTER TABLE `pbs_session` ADD `bootmenuentryID` INT AFTER `clientID` ; ALTER TABLE `pbs_session` ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`), |
