summaryrefslogtreecommitdiffstats
path: root/modules-available/serversetup-bwlp-ipxe/install.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'modules-available/serversetup-bwlp-ipxe/install.inc.php')
-rw-r--r--modules-available/serversetup-bwlp-ipxe/install.inc.php89
1 files changed, 89 insertions, 0 deletions
diff --git a/modules-available/serversetup-bwlp-ipxe/install.inc.php b/modules-available/serversetup-bwlp-ipxe/install.inc.php
new file mode 100644
index 00000000..25579c13
--- /dev/null
+++ b/modules-available/serversetup-bwlp-ipxe/install.inc.php
@@ -0,0 +1,89 @@
+<?php
+
+$res = array();
+
+$res[] = tableCreate('serversetup_bootentry', "
+ `entryid` varchar(16) CHARACTER SET ascii NOT NULL,
+ `hotkey` varchar(8) CHARACTER SET ascii NOT NULL,
+ `title` varchar(100) NOT NULL,
+ `builtin` tinyint(1) NOT NULL,
+ `data` blob NOT NULL,
+ PRIMARY KEY (`entryid`)
+");
+
+$res[] = tableCreate('serversetup_menu', "
+ `menuid` int(11) NOT NULL AUTO_INCREMENT,
+ `timeoutms` int(10) unsigned NOT NULL,
+ `title` varchar(100) NOT NULL COMMENT 'Escaped/Sanitized for iPXE!',
+ `defaultentryid` int(11) DEFAULT NULL,
+ `isdefault` tinyint(1) NOT NULL,
+ PRIMARY KEY (`menuid`),
+ KEY `defaultentryid` (`defaultentryid`),
+ KEY `isdefault` (`isdefault`)
+");
+
+$res[] = tableCreate('serversetup_menuentry', "
+ `menuentryid` int(11) NOT NULL AUTO_INCREMENT,
+ `menuid` int(11) NOT NULL,
+ `entryid` varchar(16) CHARACTER SET ascii NULL COMMENT 'If NULL, entry is gap',
+ `hotkey` varchar(8) CHARACTER SET ascii NOT NULL,
+ `title` varchar(100) NOT NULL COMMENT 'Sanitize this before insert',
+ `hidden` tinyint(1) NOT NULL,
+ `sortval` int(11) NOT NULL,
+ `plainpass` varchar(80) NOT NULL,
+ `md5pass` char(32) CHARACTER SET ascii NOT NULL,
+ PRIMARY KEY (`menuentryid`),
+ KEY `menuid` (`menuid`,`entryid`),
+ KEY `entryid` (`entryid`)
+");
+
+$res[] = tableCreate('serversetup_menu_location', '
+ `menuid` int(11) NOT NULL,
+ `locationid` int(11) NOT NULL,
+ `defaultentryid` int(11) DEFAULT NULL,
+ PRIMARY KEY (`menuid`,`locationid`),
+ UNIQUE `locationid` (`locationid`),
+ KEY `defaultentryid` (`defaultentryid`)
+');
+
+$res[] = tableCreate('serversetup_localboot', "
+ `systemmodel` varchar(120) NOT NULL,
+ `bootmethod` enum('EXIT','COMBOOT','SANBOOT') CHARACTER SET ascii NOT NULL,
+ PRIMARY KEY (`systemmodel`)
+");
+
+// Add defaultentry override column
+if (!tableHasColumn('serversetup_menu_location', 'defaultentryid')) {
+ if (Database::exec('ALTER TABLE serversetup_menu_location ADD COLUMN `defaultentryid` int(11) DEFAULT NULL,
+ ADD KEY `defaultentryid` (`defaultentryid`)') !== false) {
+ $res[] = UPDATE_DONE;
+ } else {
+ $res[] = UPDATE_FAILED;
+ }
+}
+
+$res[] = tableAddConstraint('serversetup_menu', 'defaultentryid', 'serversetup_menuentry', 'menuentryid',
+ 'ON DELETE SET NULL');
+
+$res[] = tableAddConstraint('serversetup_menuentry', 'entryid', 'serversetup_bootentry', 'entryid',
+ 'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$res[] = tableAddConstraint('serversetup_menuentry', 'menuid', 'serversetup_menu', 'menuid',
+ 'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$res[] = tableAddConstraint('serversetup_menu_location', 'menuid', 'serversetup_menu', 'menuid',
+ 'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$res[] = tableAddConstraint('serversetup_menu_location', 'defaultentryid', 'serversetup_menuentry', 'menuentryid',
+ 'ON UPDATE CASCADE ON DELETE SET NULL');
+
+if (Module::get('location') !== false) {
+ if (!tableExists('location')) {
+ $res[] = UPDATE_RETRY;
+ } else {
+ $res[] = tableAddConstraint('serversetup_menu_location', 'locationid', 'location', 'locationid',
+ 'ON UPDATE CASCADE ON DELETE CASCADE');
+ }
+}
+
+responseFromArray($res);