summaryrefslogtreecommitdiffstats
path: root/pbs-newdata.sql
diff options
context:
space:
mode:
authormichael pereira2011-03-21 10:59:53 +0100
committermichael pereira2011-03-21 10:59:53 +0100
commit436e76957269a2e3bd52a0f55b00f8a200ba4047 (patch)
tree76b5736c6a68fd6e549dcff2a3b01a7a9fbfeb5a /pbs-newdata.sql
parentzfproject (diff)
downloadpbs2-436e76957269a2e3bd52a0f55b00f8a200ba4047.tar.gz
pbs2-436e76957269a2e3bd52a0f55b00f8a200ba4047.tar.xz
pbs2-436e76957269a2e3bd52a0f55b00f8a200ba4047.zip
pbs-newdata
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r--pbs-newdata.sql14
1 files changed, 10 insertions, 4 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 9e1674b..d3dd6ab 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -67,10 +67,16 @@ INSERT INTO `pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `ti
(10, 1, 1, 1, 'BootOs 10', 'Description 10', 'initpath 10', 'kernelpath 10', 'default kcl 10', '1299693782', '2012-03-09', 0);
-- Adding bootiso
-INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `path_fbgui`, `serialnumber`, `created`, `expires`, `public`) VALUES
-(1, 'BootIso 1', 1, 1, 'Path 1', 123456789, '123', '2012-03-09', 0),
-(2, 'BootIso 2', 1, 1, 'Path 2', 2147483647, '456', '2012-03-09', 0),
-(3, 'BootIso 3', 1, 1, 'Path 3', 2147483647, '789', '2012-03-09', 0);
+INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`) VALUES
+(1, 'BootIso 1', 1, 1, '1', 123456789, '123', '2012-03-09', 0),
+(2, 'BootIso 2', 1, 1, '2', 2147483647, '456', '2012-03-09', 0),
+(3, 'BootIso 3', 1, 1, '3', 2147483647, '789', '2012-03-09', 0);
+
+-- Adding preboot
+INSERT INTO `pbs_preboot` (`prebootID`, `title`, `membershipID`, `groupID`, `path_preboot`) VALUES
+(1, 'Preboot 1', 1, 1, 'path 1'),
+(2, 'Preboot 2', 1, 1, 'path 1'),
+(3, 'Preboot 3', 1, 1, 'path 1');
-- Adding Pools
INSERT INTO `pbs_pool` (`poolID`, `groupID`, `title`, `description`, `location`) VALUES