Initial commit

1 files changed, 31 insertions, 0 deletions

diff --git a/modules-available/usblockoff/install.inc.php b/modules-available/usblockoff/install.inc.php
new file mode 100644
index 00000000..690f45d4
--- /dev/null
+++ b/modules-available/usblockoff/install.inc.php
@@ -0,0 +1,31 @@
+<?php
+
+$res = array();
+
+$t1 = $res[] = tableCreate('usb_devices', '
+	`uid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
+	`id` varchar(50),
+	`serial` varchar(512) NOT NULL DEFAULT 0,
+	`name` varchar(1024) CHARACTER SET ascii DEFAULT NULL,
+	`machineuuid` char(36) CHARACTER SET ascii DEFAULT NULL,
+	`time` INT(11) NOT NULL DEFAULT 0,
+	`user` varchar(8),
+	`ruleInformation` varchar(1024),
+	PRIMARY KEY (`uid`)
+');
+
+$t2 = $res[] = tableCreate('usb_configs', '
+	`configid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
+	`configname` VARCHAR(200) NOT NULL,
+	`rulesconfig` BLOB,
+	`daemonconfig` BLOB,
+	PRIMARY KEY (`configid`)
+');
+
+//$ret = Database::exec("DROP TABLE `usb_devices`");
+
+if (in_array(UPDATE_DONE, $res)) {
+	finalResponse(UPDATE_DONE, 'Table created successfully');
+}
+
+finalResponse(UPDATE_NOOP, 'Everything already up to date');