upgrade/0.9.16/08_forums.sql

   1 USE forums;
   2
   3 CREATE TABLE IF NOT EXISTS `innd` (
   4   `id_innd` int(10) unsigned NOT NULL auto_increment,
   5   `ipmin` int(10) unsigned default '0' COMMENT 'ip_address',
   6   `ipmax` int(10) unsigned default '4294967295' COMMENT 'ip_address',
   7   `uid` smallint(5) unsigned default NULL,
   8   `read_perm` varchar(100) default '!*',
   9   `write_perm` varchar(100) default '!*',
  10   `priority` tinyint(1) unsigned default '255',
  11   `comment` text,
  12   PRIMARY KEY  (`id_innd`)
  13 ) DEFAULT CHARSET=utf8;
  14
  15 INSERT INTO `innd` VALUES (1,0,4294967295,NULL,'xorg.*,!xorg.prive.*','xorg.*,!xorg.prive.*,!xorg.pa.emploi',0,'par defaut pour tous');