diff options
author | Simon Rettberg | 2019-11-22 17:14:06 +0100 |
---|---|---|
committer | Simon Rettberg | 2019-11-22 17:14:06 +0100 |
commit | 95c8a36dfc7e63f23eae3b411fd1a371da6f774c (patch) | |
tree | 3478a4ae1e21c5e315a38488d1af655f93843420 /modules-available/rebootcontrol/install.inc.php | |
parent | [inc/Taskmanagercallback] Remove unused function (diff) | |
download | slx-admin-95c8a36dfc7e63f23eae3b411fd1a371da6f774c.tar.gz slx-admin-95c8a36dfc7e63f23eae3b411fd1a371da6f774c.tar.xz slx-admin-95c8a36dfc7e63f23eae3b411fd1a371da6f774c.zip |
[rebootcontrol] Start adding WOL functionality
Diffstat (limited to 'modules-available/rebootcontrol/install.inc.php')
-rw-r--r-- | modules-available/rebootcontrol/install.inc.php | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/modules-available/rebootcontrol/install.inc.php b/modules-available/rebootcontrol/install.inc.php new file mode 100644 index 00000000..0ce5dd23 --- /dev/null +++ b/modules-available/rebootcontrol/install.inc.php @@ -0,0 +1,49 @@ +<?php + +$output = array(); + +$output[] = tableCreate('reboot_subnet', " + `subnetid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `start` INT(10) UNSIGNED NOT NULL, + `end` INT(10) UNSIGNED NOT NULL, + `fixed` BOOL NOT NULL, + `isdirect` BOOL NOT NULL, + `lastdirectcheck` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `lastseen` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `seencount` INT(10) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`subnetid`), + KEY `range` (`start`, `end`)"); + +$output[] = tableCreate('reboot_jumphost', " + `hostid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `host` VARCHAR(100) NOT NULL, + `port` SMALLINT(10) UNSIGNED NOT NULL, + `username` VARCHAR(30) NOT NULL, + `reachable` BOOL NOT NULL, + `sshkey` BLOB NOT NULL, + `script` BLOB NOT NULL, + PRIMARY KEY (`hostid`)"); + +$output[] = tableCreate('reboot_jumphost_x_subnet', " + `hostid` INT(10) UNSIGNED NOT NULL, + `subnetid` INT(10) UNSIGNED NOT NULL, + PRIMARY KEY (`hostid`, `subnetid`)"); + +$output[] = tableCreate('reboot_subnet_x_subnet', " + `srcid` INT(10) UNSIGNED NOT NULL, + `dstid` INT(10) UNSIGNED NOT NULL, + `reachable` BOOL NOT NULL, + `lastcheck` INT(10) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`srcid`, `dstid`), + KEY `lastcheck` (`lastcheck`)"); + +$output[] = tableAddConstraint('reboot_jumphost_x_subnet', 'hostid', 'reboot_jumphost', 'hostid', + 'ON UPDATE CASCADE ON DELETE CASCADE'); +$output[] = tableAddConstraint('reboot_jumphost_x_subnet', 'subnetid', 'reboot_subnet', 'subnetid', + 'ON UPDATE CASCADE ON DELETE CASCADE'); +$output[] = tableAddConstraint('reboot_subnet_x_subnet', 'srcid', 'reboot_subnet', 'subnetid', + 'ON UPDATE CASCADE ON DELETE CASCADE'); +$output[] = tableAddConstraint('reboot_subnet_x_subnet', 'dstid', 'reboot_subnet', 'subnetid', + 'ON UPDATE CASCADE ON DELETE CASCADE'); + +responseFromArray($output);
\ No newline at end of file |