diff options
author | Simon | 2011-03-08 16:40:30 +0100 |
---|---|---|
committer | Simon | 2011-03-08 16:40:30 +0100 |
commit | 90daca1a5ec239dfb7f44e54f1c22cf299181143 (patch) | |
tree | a8e91fd36e90e8a5dcedfcaeaa92099b5ca962f8 /pbs.sql | |
parent | session hinzugefügt (diff) | |
download | pbs2-90daca1a5ec239dfb7f44e54f1c22cf299181143.tar.gz pbs2-90daca1a5ec239dfb7f44e54f1c22cf299181143.tar.xz pbs2-90daca1a5ec239dfb7f44e54f1c22cf299181143.zip |
create, edit, delete session - fehlt noch mit selectboxen && sql-data abgeändert
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -214,7 +214,7 @@ CREATE TABLE IF NOT EXISTS `pbs_session` ( KEY `clientID` (`clientID`), 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 `bootisoID` INT NOT NULL AFTER `bootosID`; ALTER TABLE `pbs_session` ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`), |