From f0e9f6bd3e1082a244f3904adbef655594666bf1 Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Tue, 19 Apr 2011 13:02:24 +0200
Subject: config und bootosuser in DB angelegt

---
 pbs.sql | 23 ++++++++++++++++++++++-
 1 file changed, 22 insertions(+), 1 deletion(-)

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index f8da71f..02e6135 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -122,7 +122,7 @@ CREATE TABLE IF NOT EXISTS `pbs_config` (
   `title` varchar(30) NOT NULL,
   `groupID` int(11),
   `membershipID` int(11),
-  `shellscript` text NOT NULL,
+  `visible` tinyint(1) DEFAULT '0',
   `created` VARCHAR(14) NOT NULL,
   PRIMARY KEY (`configID`),
   KEY `groupID` (`groupID`),
@@ -133,7 +133,28 @@ ALTER TABLE `pbs_config`
   ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
 
+CREATE TABLE IF NOT EXISTS `pbs_hometype` (
+  `hometypeID` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(30) NOT NULL,
+  PRIMARY KEY (`hometypeID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
   
+CREATE TABLE IF NOT EXISTS `pbs_bootosuser` (
+  `bootosuserID` int(11) NOT NULL AUTO_INCREMENT,
+  `configID` int(11) NOT NULL,
+  `login` varchar(30) NOT NULL,
+  `password` varchar(30) NOT NULL,
+  `homepath` varchar(140),
+  `hometypeID` int(11),
+  PRIMARY KEY (`bootosuserID`),
+  KEY `configID` (`configID`),
+  KEY `hometypeID` (`hometypeID`)  
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+ALTER TABLE `pbs_bootosuser`
+  ADD CONSTRAINT `pbs_bootosuser_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE CASCADE;
+
+
 CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `bootosID` int(11) NOT NULL AUTO_INCREMENT,
   `groupID` int(11) NOT NULL,
-- 
cgit v1.2.3-55-g7522

