diff options
| author | Simon | 2011-04-20 18:03:05 +0200 |
|---|---|---|
| committer | Simon | 2011-04-20 18:03:05 +0200 |
| commit | 94af6bea4d49645f5d0780d3dcf388c129527815 (patch) | |
| tree | e633a108b9888507ce9c3ada3109900c91ebeda6 /setup | |
| parent | Created bei Client hinzugefügt (diff) | |
| download | pbs2-94af6bea4d49645f5d0780d3dcf388c129527815.tar.gz pbs2-94af6bea4d49645f5d0780d3dcf388c129527815.tar.xz pbs2-94af6bea4d49645f5d0780d3dcf388c129527815.zip | |
Datenbankeintrag geändert
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 6614abb..e50f637 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -260,11 +260,11 @@ CREATE TABLE IF NOT EXISTS `pbs_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, `macadress` varchar(17) NOT NULL, `hardwarehash` varchar(32), + `created` int(15), 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 `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; |