summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index f220008..15d8fe3 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -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`),