CREATE TABLE `%prefixe%site` (
  `id_site` int(11) unsigned NOT NULL auto_increment,
  `sect` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `titre` varchar(255) NOT NULL default '',
  `url` text NOT NULL,
  `url_rss` text NOT NULL,
  `description` mediumtext NOT NULL,
  `mail_auteur` varchar(255) NOT NULL default '',
  `valide` int(11) unsigned NOT NULL default '0',
  `compteur` int(11) unsigned NOT NULL default '2',
  `note` int(11) unsigned NOT NULL default '2',
  `dat` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id_site` )) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci ;

--------------------------------------------------------------

CREATE TABLE `%prefixe%cat` (
  `id_cat` int(11) unsigned NOT NULL auto_increment,
  `titre` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `compteur` int(11) unsigned NOT NULL default '2',
PRIMARY KEY ( `id_cat` )) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

--------------------------------------------------------------

CREATE TABLE `%prefixe%page` (
  `id_page` int(11) unsigned NOT NULL auto_increment,
  `titre` varchar(255) NOT NULL default '',
  `contenu` mediumtext NOT NULL,
  `compteur` int(11) unsigned NOT NULL default '2',
PRIMARY KEY ( `id_page` )) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

--------------------------------------------------------------

CREATE TABLE `%prefixe%sect` (
  `id_sect` int(11) unsigned NOT NULL auto_increment,
  `titre` varchar(255) NOT NULL default '',
  `id_cat` int(11) NOT NULL default 0,
  `description` mediumtext NOT NULL,
  `compteur` int(11) unsigned NOT NULL default '2',
PRIMARY KEY ( `id_sect` )) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;