[isf-wifidog] FirewallRuleSets & User Classes

[Benoit Grégoire]

On Thursday 03 March 2005 10:43, Scott Tully wrote:
>  >        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;

The class shouls also be a foreign key.

-- 
Benoit Grégoire, http://benoitg.coeus.ca/
-------------- section suivante --------------
Une pièce jointe non texte a été nettoyée...
Nom: non disponible
Type: application/pgp-signature
Taille: 189 octets
Desc: non disponible
Url: http://listes.philippeapril.com/pipermail/wifidog/attachments/20050303/24a34106/attachment.pgp