diff options
author | michael pereira | 2011-03-18 19:27:33 +0100 |
---|---|---|
committer | michael pereira | 2011-03-18 19:27:33 +0100 |
commit | 87b3b1d9c0cecf76d1eb39cf2548072607de59ea (patch) | |
tree | 5d07af0d68e20a38422a72864b3ca68b1a1b07be /pbs.sql | |
parent | BootOs Update implementiert, BootISO anlegen und some fixes (diff) | |
parent | User-Oberfläche, FBGui-Oberfläche legt Session&Clients an - für Kiosk-System (diff) | |
download | pbs2-87b3b1d9c0cecf76d1eb39cf2548072607de59ea.tar.gz pbs2-87b3b1d9c0cecf76d1eb39cf2548072607de59ea.tar.xz pbs2-87b3b1d9c0cecf76d1eb39cf2548072607de59ea.zip |
newsql geaendert
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -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; |