From c2a6dfb649107ce3ad64162e2bb2c3c7275650fb Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 12 Feb 2019 14:55:12 +0100
Subject: [serversetup*] PXELinux and iPXE side-by-side

---
 .../serversetup-bwlp-ipxe/install.inc.php          | 89 ++++++++++++++++++++++
 1 file changed, 89 insertions(+)
 create mode 100644 modules-available/serversetup-bwlp-ipxe/install.inc.php

(limited to 'modules-available/serversetup-bwlp-ipxe/install.inc.php')

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);
-- 
cgit v1.2.3-55-g7522