diff options
author | michael pereira | 2011-04-19 13:02:24 +0200 |
---|---|---|
committer | michael pereira | 2011-04-19 13:02:24 +0200 |
commit | f0e9f6bd3e1082a244f3904adbef655594666bf1 (patch) | |
tree | dd08c42331acb84c8ebe43e257d99b11942fc820 /pbs-newdata.sql | |
parent | minor fixes (diff) | |
download | pbs2-f0e9f6bd3e1082a244f3904adbef655594666bf1.tar.gz pbs2-f0e9f6bd3e1082a244f3904adbef655594666bf1.tar.xz pbs2-f0e9f6bd3e1082a244f3904adbef655594666bf1.zip |
config und bootosuser in DB angelegt
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r-- | pbs-newdata.sql | 28 |
1 files changed, 22 insertions, 6 deletions
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 |