diff options
Diffstat (limited to 'modules-available/passthrough/install.inc.php')
| -rw-r--r-- | modules-available/passthrough/install.inc.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/modules-available/passthrough/install.inc.php b/modules-available/passthrough/install.inc.php index e08be38b..01d3edbb 100644 --- a/modules-available/passthrough/install.inc.php +++ b/modules-available/passthrough/install.inc.php @@ -6,4 +6,18 @@ $result[] = tableCreate('passthrough_group', " 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 |