From 156abd0d614adfffed22e1d4de3168c22bf611c6 Mon Sep 17 00:00:00 2001 From: Simon Date: Wed, 20 Apr 2011 18:00:20 +0200 Subject: Created bei Client hinzugefĆ¼gt --- setup/pbs-newdata.sql | 17 +++++++++-------- setup/pbs.sql | 1 + 2 files changed, 10 insertions(+), 8 deletions(-) (limited to 'setup') diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql index e648920..2778d87 100644 --- a/setup/pbs-newdata.sql +++ b/setup/pbs-newdata.sql @@ -62,14 +62,6 @@ INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `visib (1, 'Default Config', 1, null, '1', '1299693677'), (2, 'Config 2', 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'), @@ -78,6 +70,15 @@ INSERT INTO `pbs_hometype` (`hometypeID`, `name`) VALUES (3, 'extern'), (4, 'dropbox'); +-- 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, 2, 'login4', 'password4', null, 0), +(5, 2, 'login5', 'password5', null, 1); + + -- 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 (1, 'configpath 1', 1, 1, 'BootOs 1', 'Description 1', 'initpath 1', 'kernelpath 1', 'default kcl 1', '1299693782', '2012-03-09', 0, null, null, null, null, null), diff --git a/setup/pbs.sql b/setup/pbs.sql index 8a59fbb..6614abb 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -264,6 +264,7 @@ CREATE TABLE IF NOT EXISTS `pbs_client` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; ALTER TABLE `pbs_client` ADD `groupID` INT NOT NULL AFTER `clientID` ; ALTER TABLE `pbs_client` ADD UNIQUE (`macadress`); +ALTER TABLE `pbs_client` ADD `created` INT( 15 ) NOT NULL; ALTER TABLE `pbs_client` ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; -- cgit v1.2.3-55-g7522