summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
Diffstat (limited to 'setup')
-rw-r--r--setup/pbs-newdata.sql8
-rw-r--r--setup/pbs.sql3
2 files changed, 6 insertions, 5 deletions
diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql
index 3745a7d..1231cf1 100644
--- a/setup/pbs-newdata.sql
+++ b/setup/pbs-newdata.sql
@@ -93,10 +93,10 @@ INSERT INTO `pbs_bootos` (`bootosID`, `path_config`, `groupID`, `membershipID`,
-- 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 2'),
-(3, 'Preboot 3', 1, 1, 'path 3');
+INSERT INTO `pbs_preboot` (`prebootID`, `title`, `membershipID`, `groupID`, `path_preboot`, `created`, `source`) VALUES
+(1, 'Preboot 1', 1, 1, 'path 1', '1299694422', 'source1'),
+(2, 'Preboot 2', 1, 1, 'path 2', '1299694422', 'source1'),
+(3, 'Preboot 3', 1, 1, 'path 3', '1299694422', 'source1');
-- Adding bootiso
INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`) VALUES
diff --git a/setup/pbs.sql b/setup/pbs.sql
index ef818aa..491bfc3 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -154,7 +154,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootosuser` (
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,
@@ -225,6 +224,8 @@ CREATE TABLE IF NOT EXISTS `pbs_preboot` (
`membershipID` int(11),
`groupID` int(11) NOT NULL,
`path_preboot` varchar(140) NOT NULL,
+ `source` varchar(140),
+ `created` VARCHAR(14) NOT NULL,
PRIMARY KEY (`prebootID`),
KEY `membershipID` (`membershipID`),
KEY `groupID` (`groupID`)