From a102b7214c819f79eda990724911eeb74d424a00 Mon Sep 17 00:00:00 2001 From: Simon Date: Tue, 26 Apr 2011 18:17:27 +0200 Subject: Notices in Filter entfernt --- setup/pbs.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'setup') 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; -- cgit v1.2.3-55-g7522