summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authormichael pereira2011-03-16 16:35:20 +0100
committermichael pereira2011-03-16 16:35:20 +0100
commitb09352fc9ec322ea0ae744077a66fcaf61465ed5 (patch)
treeb9e45999ce4d1eaa08035601bfd8f14f91547d30 /pbs.sql
parentKCLAppend hinzugefuegt, KCL fertig :-) (diff)
parentClientController geändert, Forms können in FBGui und User nicht benutzt werden (diff)
downloadpbs2-b09352fc9ec322ea0ae744077a66fcaf61465ed5.tar.gz
pbs2-b09352fc9ec322ea0ae744077a66fcaf61465ed5.tar.xz
pbs2-b09352fc9ec322ea0ae744077a66fcaf61465ed5.zip
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index eaf1b0f..2b3a198 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -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 SET NULL,