summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authorSimon2011-03-18 18:49:30 +0100
committerSimon2011-03-18 18:49:30 +0100
commit5139008cee049b2ab24b870a263996fe9043adeb (patch)
treea79c36fce9afc587c73cd4e71c94e72bbc83830e /pbs.sql
parentAnsicht von Pools geändert (diff)
downloadpbs2-5139008cee049b2ab24b870a263996fe9043adeb.tar.gz
pbs2-5139008cee049b2ab24b870a263996fe9043adeb.tar.xz
pbs2-5139008cee049b2ab24b870a263996fe9043adeb.zip
User-Oberfläche, FBGui-Oberfläche legt Session&Clients an - für Kiosk-System
apache-default zum ersetzen, damit server von außen erreichbar ist FilterController weitergearbeitet
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index 58c21b2..76bfc9c 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -209,6 +209,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 CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;