1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
<?php
$result = array();
$result[] = 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,
`module` varchar(30) NOT NULL,
`data` blob NOT NULL,
PRIMARY KEY (`entryid`)
");
$result[] = 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`)
");
$result[] = 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 or another menu',
`refmenuid` int(11) DEFAULT NULL COMMENT 'If entryid is NULL this can be a ref to another menu',
`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`,`sortval`),
KEY `entryid` (`entryid`)
");
$result[] = 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`)
');
$result[] = tableCreate('serversetup_localboot', "
`systemmodel` varchar(120) NOT NULL,
`pcbios` varchar(16) CHARACTER SET ascii DEFAULT NULL,
`efi` varchar(16) CHARACTER SET ascii DEFAULT 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) {
$result[] = UPDATE_DONE;
} else {
$result[] = UPDATE_FAILED;
}
}
$result[] = tableAddConstraint('serversetup_menu', 'defaultentryid', 'serversetup_menuentry', 'menuentryid',
'ON DELETE SET NULL');
$result[] = tableAddConstraint('serversetup_menuentry', 'entryid', 'serversetup_bootentry', 'entryid',
'ON UPDATE CASCADE ON DELETE CASCADE');
$result[] = tableAddConstraint('serversetup_menuentry', 'menuid', 'serversetup_menu', 'menuid',
'ON UPDATE CASCADE ON DELETE CASCADE');
$result[] = tableAddConstraint('serversetup_menu_location', 'menuid', 'serversetup_menu', 'menuid',
'ON UPDATE CASCADE ON DELETE CASCADE');
$result[] = tableAddConstraint('serversetup_menu_location', 'defaultentryid', 'serversetup_menuentry', 'menuentryid',
'ON UPDATE CASCADE ON DELETE SET NULL');
// 2019-03-19 Add refmenuid to have cascaded menus
if (!tableHasColumn('serversetup_menuentry', 'refmenuid')) {
if (Database::exec("ALTER TABLE serversetup_menuentry ADD COLUMN `refmenuid` int(11) DEFAULT NULL COMMENT 'If entryid is NULL this can be a ref to another menu'") !== false) {
$result[] = UPDATE_DONE;
} else {
$result[] = UPDATE_FAILED;
}
}
// 2019-03-26 Make localboot config distinct for efi and bios
if (!tableHasColumn('serversetup_localboot', 'pcbios')) {
if (Database::exec("ALTER TABLE serversetup_localboot DROP COLUMN `bootmethod`,
ADD COLUMN `pcbios` varchar(16) CHARACTER SET ascii DEFAULT NULL, ADD COLUMN `efi` varchar(16) CHARACTER SET ascii DEFAULT NULL") !== false) {
$result[] = UPDATE_DONE;
} else {
$result[] = UPDATE_FAILED;
}
}
$result[] = tableAddConstraint('serversetup_menuentry', 'refmenuid', 'serversetup_menu', 'menuid',
'ON UPDATE CASCADE ON DELETE SET NULL');
if (Module::get('locations') !== false) {
if (!tableExists('location')) {
$result[] = UPDATE_RETRY;
} else {
$result[] = tableAddConstraint('serversetup_menu_location', 'locationid', 'location', 'locationid',
'ON UPDATE CASCADE ON DELETE CASCADE');
}
}
// 2019-09-21 Add module column to bootentry
if (!tableHasColumn('serversetup_bootentry', 'module')) {
// First, nullable, so we can update old entries
if (Database::exec("ALTER TABLE serversetup_bootentry
ADD COLUMN `module` varchar(30) CHARACTER SET ascii DEFAULT NULL AFTER `builtin`") !== false) {
$result[] = UPDATE_DONE;
} else {
$result[] = UPDATE_FAILED;
}
}
// 2024-07-22 NULLable module column makes no sense and breaks slx-admin - disallow
if (tableGetDescribeColumn('serversetup_bootentry', 'module', 'Null') === 'YES') {
// Update any old fields that now have NULL as module
$res = Database::simpleQuery('SELECT entryid, data FROM serversetup_bootentry WHERE module IS NULL');
foreach ($res as $row) {
$json = json_decode($row['data'], true);
if (isset($json['script'])) {
Database::exec("UPDATE serversetup_bootentry SET module = '.script' WHERE entryid = :id", ['id' => $row['entryid']]);
} else {
Database::exec("UPDATE serversetup_bootentry SET module = '.exec' WHERE entryid = :id", ['id' => $row['entryid']]);
}
}
// Just to be safe
Database::simpleQuery('DELETE FROM serversetup_bootentry WHERE module IS NULL');
if (Database::exec("ALTER TABLE serversetup_bootentry
MODIFY `module` varchar(30) CHARACTER SET ascii NOT NULL") !== false) {
$result[] = UPDATE_DONE;
} else {
$result[] = UPDATE_FAILED;
}
}
if (Module::isAvailable('serversetup')) {
IPxe::createDefaultEntries();
}
responseFromArray($result);
|
