diff options
| author | michael pereira | 2011-04-26 18:14:42 +0200 |
|---|---|---|
| committer | michael pereira | 2011-04-26 18:14:42 +0200 |
| commit | c1d24fe8a4d36225d8aab3cfa568622db649d76a (patch) | |
| tree | 73ce5b6d584897237d498912fa932985ed5b279d /setup/pbs.sql | |
| parent | config fix (diff) | |
| parent | Filterfix (diff) | |
| download | pbs2-c1d24fe8a4d36225d8aab3cfa568622db649d76a.tar.gz pbs2-c1d24fe8a4d36225d8aab3cfa568622db649d76a.tar.xz pbs2-c1d24fe8a4d36225d8aab3cfa568622db649d76a.zip | |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 6d5dbb3..0ddf900 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -269,7 +269,7 @@ CREATE TABLE IF NOT EXISTS `pbs_client` ( 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 UNIQUE (`macadress`); +ALTER TABLE `pbs_client` ADD UNIQUE (`groupID` ,`macadress`); ALTER TABLE `pbs_client` ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; |