diff options
author | Simon | 2011-03-16 14:42:40 +0100 |
---|---|---|
committer | Simon | 2011-03-16 14:42:40 +0100 |
commit | 29224a1ccc162e457589210168c38529e81a572d (patch) | |
tree | f049b58ed09cd4bd9de2e3fe882593b75b16cae4 /pbs.sql | |
parent | Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff) | |
download | pbs2-29224a1ccc162e457589210168c38529e81a572d.tar.gz pbs2-29224a1ccc162e457589210168c38529e81a572d.tar.xz pbs2-29224a1ccc162e457589210168c38529e81a572d.zip |
Helper initialisiert, ClientController geadded
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 4 |
1 files changed, 4 insertions, 0 deletions
@@ -208,6 +208,9 @@ CREATE TABLE IF NOT EXISTS `pbs_client` ( `hardwarehash` varchar(32), PRIMARY KEY (`clientID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; +ALTER TABLE `pbs_client` ADD `groupID` INT NOT NULL AFTER `clientID` ; +ALTER TABLE `pbs_client` + ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_session` ( `sessionID` int(11) NOT NULL AUTO_INCREMENT, @@ -225,6 +228,7 @@ ALTER TABLE `pbs_session` ADD `alphasessionID` VARCHAR( 16 ) NOT NULL AFTER `ses ALTER TABLE `pbs_session` ADD `bootmenuentryID` INT AFTER `clientID` ; ALTER TABLE `pbs_session` ADD `membershipID` INT NULL AFTER `bootisoID` ; + ALTER TABLE `pbs_session` ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_session_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE, |