From be3bf392777efb6c953064e095b5fe510bff1ca8 Mon Sep 17 00:00:00 2001 From: michael pereira Date: Mon, 18 Apr 2011 16:33:13 +0200 Subject: API-Key bei Membership & BootOS über API fertig --- pbs.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'pbs.sql') diff --git a/pbs.sql b/pbs.sql index 80c368b..b2371d9 100644 --- a/pbs.sql +++ b/pbs.sql @@ -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`) -- cgit v1.2.3-55-g7522