summaryrefslogtreecommitdiffstats
path: root/setup/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r--setup/pbs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql
index 8a59fbb..6614abb 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -264,6 +264,7 @@ CREATE TABLE IF NOT EXISTS `pbs_client` (
) 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 `created` INT( 15 ) NOT NULL;
ALTER TABLE `pbs_client`
ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;