From b86a3c3c8b6118ef9e2d340330ef4a86539f801e Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 24 Nov 2017 12:57:30 +0100
Subject: [dnbd3] Add installer script

---
 modules-available/dnbd3/install.inc.php | 41 +++++++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100644 modules-available/dnbd3/install.inc.php

(limited to 'modules-available/dnbd3')

diff --git a/modules-available/dnbd3/install.inc.php b/modules-available/dnbd3/install.inc.php
new file mode 100644
index 00000000..c5096cfe
--- /dev/null
+++ b/modules-available/dnbd3/install.inc.php
@@ -0,0 +1,41 @@
+<?php
+
+$res = array();
+
+$res[] = tableCreate('dnbd3_server', "
+	`serverid` int(11) NOT NULL AUTO_INCREMENT,
+	`machineuuid` char(36) CHARACTER SET ascii DEFAULT NULL,
+	`fixedip` varchar(45) CHARACTER SET ascii DEFAULT NULL,
+	`runid` bigint(20) NOT NULL DEFAULT '0',
+	`lastseen` bigint(20) NOT NULL DEFAULT '0',
+	`uptime` bigint(20) NOT NULL DEFAULT '0',
+	`totalup` bigint(20) NOT NULL DEFAULT '0',
+	`totaldown` bigint(20) NOT NULL DEFAULT '0',
+	`lastup` bigint(20) NOT NULL DEFAULT '0',
+	`lastdown` bigint(20) NOT NULL DEFAULT '0',
+	`clientcount` int(11) NOT NULL DEFAULT '0',
+	`disktotal` bigint(20) NOT NULL DEFAULT '0',
+	`diskfree` bigint(20) NOT NULL DEFAULT '0',
+	`errormsg` varchar(200) DEFAULT NULL,
+	PRIMARY KEY (`serverid`),
+	UNIQUE KEY `machineuuid` (`machineuuid`),
+	UNIQUE KEY `fixedip` (`fixedip`)
+");
+
+$res[] = tableCreate('dnbd3_server_x_location', '
+	`serverid` int(11) NOT NULL,
+	`locationid` int(11) NOT NULL,
+	PRIMARY KEY (`serverid`,`locationid`),
+	KEY `locationid` (`locationid`)
+');
+
+$res[] = tableAddConstraint('dnbd3_server', 'machineuuid', 'machine', 'machineuuid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$res[] = tableAddConstraint('dnbd3_server_x_location', 'locationid', 'location', 'locationid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$res[] = tableAddConstraint('dnbd3_server_x_location', 'serverid', 'dnbd3_server', 'serverid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+responseFromArray($res);
-- 
cgit v1.2.3-55-g7522