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

