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/pbs.sql')

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

