summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql10
1 files changed, 6 insertions, 4 deletions
diff --git a/pbs.sql b/pbs.sql
index db02a1e..80c368b 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -135,25 +135,27 @@ ALTER TABLE `pbs_config`
CREATE TABLE IF NOT EXISTS `pbs_bootos` (
`bootosID` int(11) NOT NULL AUTO_INCREMENT,
- `configID` int(11),
`groupID` int(11) NOT NULL,
`membershipID` int(11),
`title` varchar(30) NOT NULL,
`description` varchar(140),
+ `distro` varchar(30),
+ `distroversion` varchar(30),
+ `source` varchar(140),
+ `share` varchar(30),
+ `shortname` varchar(30),
`path_init` varchar(140) NOT NULL,
`path_kernel` varchar(140) NOT NULL,
+ `path_config` varchar(140),
`defaultkcl` varchar(255),
`created` VARCHAR(14) NOT NULL,
`expires` VARCHAR(14),
`public` int(11) NOT NULL,
PRIMARY KEY (`bootosID`),
- KEY `configID` (`configID`),
KEY `groupID` (`groupID`),
KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
ALTER TABLE `pbs_bootos`
- ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;