[isf-wifidog] FirewallRuleSets & User Classes

[Scott Tully]

> >
> > 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;
> 
> The class shouls also be a foreign key.
> 

Not sure if this is what you are thinking, but i created a
user_classes table and defined a few classes.  I created a foreign key
from the `class` field in node_user to the user_classes table/field. 
I also added a field to the nodes tables called default_class, this is
also linked to the user_classes table/field.

If we are concerned about a user having the correct privileges per
location, then the class of a user should not be determined by a
default user class, but a default location class (users have no
class).  If the user's class is not defined, then the user will be
assigned the class determined by the admin of the location, i.e. the
default location class.

Make sense? 

Scott