diff options
| author | Simon | 2011-03-07 13:57:04 +0100 |
|---|---|---|
| committer | Simon | 2011-03-07 13:57:04 +0100 |
| commit | 5688b750744f8568414dc745961747e5629bd194 (patch) | |
| tree | d8821314ada6f422d3d362666e7060af502709a3 /pbs.sql | |
| parent | view variable in application.ini hinzugefügt (diff) | |
| download | pbs2-5688b750744f8568414dc745961747e5629bd194.tar.gz pbs2-5688b750744f8568414dc745961747e5629bd194.tar.xz pbs2-5688b750744f8568414dc745961747e5629bd194.zip | |
Pool actions zum bearbeiten von Pools hinzugefügt
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -230,6 +230,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, |