diff options
| author | Simon | 2011-04-26 18:17:27 +0200 |
|---|---|---|
| committer | Simon | 2011-04-26 18:17:27 +0200 |
| commit | a102b7214c819f79eda990724911eeb74d424a00 (patch) | |
| tree | c586600b95eb6dbfe2937d6b27ba6c56af813140 /setup/pbs.sql | |
| parent | Quickfix new Client (diff) | |
| download | pbs2-a102b7214c819f79eda990724911eeb74d424a00.tar.gz pbs2-a102b7214c819f79eda990724911eeb74d424a00.tar.xz pbs2-a102b7214c819f79eda990724911eeb74d424a00.zip | |
Notices in Filter entfernt
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; |