diff options
| author | michael pereira | 2011-03-07 17:54:01 +0100 |
|---|---|---|
| committer | michael pereira | 2011-03-07 17:54:01 +0100 |
| commit | f122bafccf6a81b87d982956f615e70ceaecfeb3 (patch) | |
| tree | 98e9960b2fda10f29765d3382d7fd92cfc100f92 /pbs.sql | |
| parent | BootMenuEntries fertig (diff) | |
| parent | dirty hack entfertn durch findBy-Methode (diff) | |
| download | pbs2-f122bafccf6a81b87d982956f615e70ceaecfeb3.tar.gz pbs2-f122bafccf6a81b87d982956f615e70ceaecfeb3.tar.xz pbs2-f122bafccf6a81b87d982956f615e70ceaecfeb3.zip | |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -233,6 +233,7 @@ CREATE TABLE IF NOT EXISTS `pbs_poolentries` ( KEY `poolID` (`poolID`), KEY `clientID` (`clientID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; +ALTER TABLE `pbs_poolentries` ADD `poolentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; ALTER TABLE `pbs_poolentries` ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE, |