summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/poolctrl.sql')
-rw-r--r--setup/poolctrl.sql11
1 files changed, 2 insertions, 9 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 975d4c7..e1badbd 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -96,6 +96,8 @@ CREATE TABLE IF NOT EXISTS `pbs_client` (
`groupID` int(11) NOT NULL,
`macadress` varchar(17) NOT NULL,
`hardwarehash` varchar(32),
+ `ip` varchar(15) NOT NULL,
+ `ip6` varchar(45),
`created` int(15),
PRIMARY KEY (`clientID`),
KEY `groupID` (`groupID`)
@@ -151,15 +153,6 @@ CREATE TABLE IF NOT EXISTS `pbs_membership` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- Constraints
-ALTER TABLE `pbs_filter`
- ADD CONSTRAINT `pbs_filter_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
- ADD CONSTRAINT `pbs_filter_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
- ADD CONSTRAINT `pbs_filter_ibfk_3` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE;
-
-ALTER TABLE `pbs_bootmenu`
- ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
- ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
-
ALTER TABLE `pbs_bootos`
ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;