diff options
Diffstat (limited to 'modules-available/serversetup-bwlp/install.inc.php')
-rw-r--r-- | modules-available/serversetup-bwlp/install.inc.php | 89 |
1 files changed, 0 insertions, 89 deletions
diff --git a/modules-available/serversetup-bwlp/install.inc.php b/modules-available/serversetup-bwlp/install.inc.php deleted file mode 100644 index 25579c13..00000000 --- a/modules-available/serversetup-bwlp/install.inc.php +++ /dev/null @@ -1,89 +0,0 @@ -<?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); |