summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
Diffstat (limited to 'setup')
-rw-r--r--setup/pbs.sql2
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;