config und bootosuser in DB angelegt

1 files changed, 22 insertions, 1 deletions

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,