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-newdata.sql | 28 ++++++++++++++++++++++------
 1 file changed, 22 insertions(+), 6 deletions(-)

(limited to 'pbs-newdata.sql')

diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index e10ce02..0c1fffb 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -69,12 +69,28 @@ INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VAL
 (14, 1, '64:46:85:A1:89:23', '9684216842068420616841asd6516984');
 
 -- Adding config
-INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES
-(1, 'Config 1', 1, null, 'shellscript 1', '1299693677'),
-(2, 'Config 2', 1, null, 'shellskript 2', '1299693690'),
-(3, 'Config 3', 1, null, 'shellskript 3', '1299693690'),
-(4, 'Config 4', null, 1, 'shellskript 4', '1299693690'),
-(5, 'Config 5', null, 1, 'shellskript 5', '1299693690');
+INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `visible`, `created`) VALUES
+(1, 'Config 1', 1, null, '1', '1299693677'),
+(2, 'Config 2', 1, null, '0', '1299693690'),
+(3, 'Config 3', 1, null, '1', '1299693690'),
+(4, 'Config 4', null, 1, '1', '1299693690'),
+(5, 'Config 5', null, 1, '1', '1299693690');
+
+-- Adding bootosuser
+INSERT INTO `pbs_bootosuser` (`bootosuserID`, `configID`, `login`, `password`, `homepath`, `hometypeID`) VALUES
+(1, 1, 'login1', 'password1', null, 0),
+(2, 1, 'login2', 'password2', null, 1),
+(3, 1, 'login3', 'password3', '/home/bla/blub', 2),
+(4, 4, 'login4', 'password4', null, 0),
+(5, 4, 'login5', 'password5', null, 1);
+
+-- Adding hometype
+INSERT INTO `pbs_hometype` (`hometypeID`, `name`) VALUES
+(0, 'standard'),
+(1, 'usbstick'),
+(2, 'custom path'),
+(3, 'extern'),
+(4, 'dropbox');
 
 -- Adding bootos
 INSERT INTO `pbs_bootos` (`bootosID`, `path_config`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`, `source`, `distro`, `distroversion`, `shortname`, `share`) VALUES
-- 
cgit v1.2.3-55-g7522

