diff options
author | michael pereira | 2011-04-18 16:33:13 +0200 |
---|---|---|
committer | michael pereira | 2011-04-18 16:33:13 +0200 |
commit | be3bf392777efb6c953064e095b5fe510bff1ca8 (patch) | |
tree | d05ed80b1d25ce33b4bdf8d2c21a105e99b133b7 /pbs.sql | |
parent | Public Level -1 (nicht freigeschaltet) bei Bootiso und Bootos (diff) | |
download | pbs2-be3bf392777efb6c953064e095b5fe510bff1ca8.tar.gz pbs2-be3bf392777efb6c953064e095b5fe510bff1ca8.tar.xz pbs2-be3bf392777efb6c953064e095b5fe510bff1ca8.zip |
API-Key bei Membership & BootOS über API fertig
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -105,6 +105,7 @@ CREATE TABLE IF NOT EXISTS `pbs_membership` ( `roleID` int(11) NOT NULL, `personID` int(11) NOT NULL, `suspended` tinyint(1) NOT NULL, + `apikey` varchar(30), PRIMARY KEY (`membershipID`), KEY `groupID` (`groupID`), KEY `roleID` (`roleID`), @@ -144,13 +145,13 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` ( `source` varchar(140), `share` varchar(30), `shortname` varchar(30), - `path_init` varchar(140) NOT NULL, - `path_kernel` varchar(140) NOT NULL, + `path_init` varchar(140), + `path_kernel` varchar(140), `path_config` varchar(140), `defaultkcl` varchar(255), `created` VARCHAR(14) NOT NULL, `expires` VARCHAR(14), - `public` int(11) NOT NULL, + `public` int(11) NOT NULL DEFAULT '-1', PRIMARY KEY (`bootosID`), KEY `groupID` (`groupID`), KEY `membershipID` (`membershipID`) |