path: root/modules-available/passthrough/install.inc.php

<?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);