diff options
Diffstat (limited to 'modules-available/passthrough/install.inc.php')
-rw-r--r-- | modules-available/passthrough/install.inc.php | 23 |
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 |