[platal.git] / upgrade / 0.9.16 / 08_forums.sql

CREATE TABLE `forums.innd` (
  `id_innd` int(10) unsigned NOT NULL auto_increment,
  `ipmin` int(10) unsigned default '0' COMMENT 'ip_address',
  `ipmax` int(10) unsigned default '4294967295' COMMENT 'ip_address',
  `uid` smallint(5) unsigned default NULL,
  `read_perm` varchar(100) default '!*',
  `write_perm` varchar(100) default '!*',
  `priority` tinyint(1) unsigned default '255',
  `comment` text,
  PRIMARY KEY  (`id_innd`)
) DEFAULT CHARSET=utf8;

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