[isf-wifidog] FirewallRuleSets & User Classes

[Scott Tully]

 >        In SQL99, the same thing replacing the shared primary key with
> a foreign key. It's mostly the management aspect that I was concerned
> about. The technical aspects are fairly trivial by comparison.
> 
>        In other words, I think you're spot on for the tech part, but
> that wasn't my worry.
> 

Sorry, that i have to do this in MySQL, but here it is

-- 
-- Table structure for table `node_user`
-- 

CREATE TABLE `node_user` (
  `user_id` varchar(128) NOT NULL default '',
  `node_id` varchar(32) NOT NULL default '',
  `class` int(3) NOT NULL default '3',
  KEY `node_id` (`node_id`),
  KEY `user_id` (`user_id`)
) TYPE=InnoDB;

-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `node_user`
-- 
ALTER TABLE `node_user`
  ADD CONSTRAINT `fk_node_user_id` FOREIGN KEY (`user_id`) REFERENCES
`users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_node_id` FOREIGN KEY (`node_id`) REFERENCES
`nodes` (`node_id`) ON DELETE CASCADE ON UPDATE CASCADE;