1 files changed, 23 insertions, 0 deletions
diff --git a/modules-available/passthrough/install.inc.php b/modules-available/passthrough/install.inc.php
new file mode 100644
index 00000000..01d3edbb
--- /dev/null
+++ b/modules-available/passthrough/install.inc.php
@@ -0,0 +1,23 @@
+<?php
+
+$result[] = tableCreate('passthrough_group', "
+  `groupid` varchar(32) CHARACTER SET ascii DEFAULT NULL,
+  `title` varchar(200) NOT NULL,
+  PRIMARY KEY (`groupid`)
+");
+
+$result[] = tableCreate('passthrough_group_x_location', "
+  `groupid` varchar(32) CHARACTER SET ascii DEFAULT NULL,
+  `locationid` INT(11) NOT NULL,
+  PRIMARY KEY (`groupid`, `locationid`)
+");
+
+$result[] = tableAddConstraint('passthrough_group_x_location', 'groupid',
+	'passthrough_group', 'groupid',
+	'ON DELETE CASCADE ON UPDATE CASCADE');
+
+$result[] = tableAddConstraint('passthrough_group_x_location', 'locationid',
+	'location', 'locationid',
+	'ON DELETE CASCADE ON UPDATE CASCADE');
+
+responseFromArray($result);
+\ No newline at end of file