Cette erreur je sais d'où elle vient. C'est parce que je crée une nouvelle base de donnée alors que je n'ai droit qu'à une seule. bref,
Lorsque j'essaye d'importer:
--
-- Structure de la table `xoops_avatar`
--
DROP TABLE IF EXISTS `xoops_avatar`;
CREATE TABLE IF NOT EXISTS `xoops_avatar` (
`avatar_id` mediumint(8) unsigned NOT NULL auto_increment,
`avatar_file` varchar(30) collate latin1_general_ci NOT NULL default '',
`avatar_name` varchar(100) collate latin1_general_ci NOT NULL default '',
`avatar_mimetype` varchar(30) collate latin1_general_ci NOT NULL default '',
`avatar_created` int(10) NOT NULL default '0',
`avatar_display` tinyint(1) unsigned NOT NULL default '0',
`avatar_weight` smallint(5) unsigned NOT NULL default '0',
`avatar_type` char(1) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`avatar_id`),
KEY `avatar_type` (`avatar_type`,`avatar_display`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=52 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_avatar_user_link`
--
DROP TABLE IF EXISTS `xoops_avatar_user_link`;
CREATE TABLE IF NOT EXISTS `xoops_avatar_user_link` (
`avatar_id` mediumint(8) unsigned NOT NULL default '0',
`user_id` mediumint(8) unsigned NOT NULL default '0',
KEY `avatar_user_id` (`avatar_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_banner`
--
DROP TABLE IF EXISTS `xoops_banner`;
CREATE TABLE IF NOT EXISTS `xoops_banner` (
`bid` smallint(5) unsigned NOT NULL auto_increment,
`cid` tinyint(3) unsigned NOT NULL default '0',
`imptotal` mediumint(8) unsigned NOT NULL default '0',
`impmade` mediumint(8) unsigned NOT NULL default '0',
`clicks` mediumint(8) unsigned NOT NULL default '0',
`imageurl` varchar(255) collate latin1_general_ci NOT NULL default '',
`clickurl` varchar(255) collate latin1_general_ci NOT NULL default '',
`date` int(10) NOT NULL default '0',
`htmlbanner` tinyint(1) NOT NULL default '0',
`htmlcode` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`bid`),
KEY `idxbannercid` (`cid`),
KEY `idxbannerbidcid` (`bid`,`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bannerclient`
--
DROP TABLE IF EXISTS `xoops_bannerclient`;
CREATE TABLE IF NOT EXISTS `xoops_bannerclient` (
`cid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(60) collate latin1_general_ci NOT NULL default '',
`contact` varchar(60) collate latin1_general_ci NOT NULL default '',
`email` varchar(60) collate latin1_general_ci NOT NULL default '',
`login` varchar(10) collate latin1_general_ci NOT NULL default '',
`passwd` varchar(10) collate latin1_general_ci NOT NULL default '',
`extrainfo` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`cid`),
KEY `login` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bannerfinish`
--
DROP TABLE IF EXISTS `xoops_bannerfinish`;
CREATE TABLE IF NOT EXISTS `xoops_bannerfinish` (
`bid` smallint(5) unsigned NOT NULL auto_increment,
`cid` smallint(5) unsigned NOT NULL default '0',
`impressions` mediumint(8) unsigned NOT NULL default '0',
`clicks` mediumint(8) unsigned NOT NULL default '0',
`datestart` int(10) unsigned NOT NULL default '0',
`dateend` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`bid`),
KEY `cid` (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_categories`
--
DROP TABLE IF EXISTS `xoops_bbex_categories`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_categories` (
`cat_id` smallint(3) unsigned NOT NULL auto_increment,
`cat_title` varchar(100) collate latin1_general_ci NOT NULL default '',
`cat_order` varchar(10) collate latin1_general_ci default NULL,
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_forum_access`
--
DROP TABLE IF EXISTS `xoops_bbex_forum_access`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_forum_access` (
`forum_id` int(4) unsigned NOT NULL default '0',
`user_id` int(5) unsigned NOT NULL default '0',
`can_post` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`forum_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_forum_mods`
--
DROP TABLE IF EXISTS `xoops_bbex_forum_mods`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_forum_mods` (
`forum_id` int(4) unsigned NOT NULL default '0',
`user_id` int(5) unsigned NOT NULL default '0',
KEY `forum_user_id` (`forum_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_forums`
--
DROP TABLE IF EXISTS `xoops_bbex_forums`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_forums` (
`forum_id` int(4) unsigned NOT NULL auto_increment,
`forum_name` varchar(150) collate latin1_general_ci NOT NULL default '',
`forum_desc` text collate latin1_general_ci,
`forum_access` tinyint(2) NOT NULL default '1',
`forum_moderator` int(2) default NULL,
`forum_topics` int(8) NOT NULL default '0',
`forum_posts` int(8) NOT NULL default '0',
`forum_last_post_id` int(5) unsigned NOT NULL default '0',
`cat_id` int(2) NOT NULL default '0',
`forum_type` int(10) default '0',
`allow_html` enum('0','1') collate latin1_general_ci NOT NULL default '0',
`allow_sig` enum('0','1') collate latin1_general_ci NOT NULL default '0',
`posts_per_page` tinyint(3) unsigned NOT NULL default '20',
`hot_threshold` tinyint(3) unsigned NOT NULL default '10',
`topics_per_page` tinyint(3) unsigned NOT NULL default '20',
`show_name` enum('0','1') collate latin1_general_ci NOT NULL default '0',
`show_icons_panel` enum('0','1') collate latin1_general_ci NOT NULL default '1',
`show_smilies_panel` enum('0','1') collate latin1_general_ci NOT NULL default '1',
PRIMARY KEY (`forum_id`),
KEY `forum_last_post_id` (`forum_last_post_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_posts`
--
DROP TABLE IF EXISTS `xoops_bbex_posts`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_posts` (
`post_id` int(8) unsigned NOT NULL auto_increment,
`pid` int(8) NOT NULL default '0',
`topic_id` int(8) NOT NULL default '0',
`forum_id` int(4) NOT NULL default '0',
`post_time` int(10) NOT NULL default '0',
`uid` int(5) unsigned NOT NULL default '0',
`poster_ip` varchar(15) collate latin1_general_ci NOT NULL default '',
`subject` varchar(255) collate latin1_general_ci NOT NULL default '',
`nohtml` tinyint(1) NOT NULL default '0',
`nosmiley` tinyint(1) NOT NULL default '0',
`icon` varchar(25) collate latin1_general_ci NOT NULL default '',
`attachsig` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `uid` (`uid`),
KEY `pid` (`pid`),
KEY `subject` (`subject`(40)),
KEY `forumid_uid` (`forum_id`,`uid`),
KEY `topicid_uid` (`topic_id`,`uid`),
KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
FULLTEXT KEY `search` (`subject`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_posts_text`
--
DROP TABLE IF EXISTS `xoops_bbex_posts_text`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_posts_text` (
`post_id` int(8) unsigned NOT NULL auto_increment,
`post_text` text collate latin1_general_ci,
PRIMARY KEY (`post_id`),
FULLTEXT KEY `search` (`post_text`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_bbex_topics`
--
DROP TABLE IF EXISTS `xoops_bbex_topics`;
CREATE TABLE IF NOT EXISTS `xoops_bbex_topics` (
`topic_id` int(8) unsigned NOT NULL auto_increment,
`topic_title` varchar(255) collate latin1_general_ci default NULL,
`topic_poster` int(5) NOT NULL default '0',
`topic_time` int(10) NOT NULL default '0',
`topic_views` int(5) NOT NULL default '0',
`topic_replies` int(4) NOT NULL default '0',
`topic_last_post_id` int(8) unsigned NOT NULL default '0',
`forum_id` int(4) NOT NULL default '0',
`topic_status` tinyint(1) NOT NULL default '0',
`topic_sticky` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_last_post_id` (`topic_last_post_id`),
KEY `topic_poster` (`topic_poster`),
KEY `topic_forum` (`topic_id`,`forum_id`),
KEY `topic_sticky` (`topic_sticky`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_block_module_link`
--
DROP TABLE IF EXISTS `xoops_block_module_link`;
CREATE TABLE IF NOT EXISTS `xoops_block_module_link` (
`block_id` mediumint(8) unsigned NOT NULL default '0',
`module_id` smallint(5) NOT NULL default '0',
KEY `module_id` (`module_id`),
KEY `block_id` (`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_catads_ads`
--
DROP TABLE IF EXISTS `xoops_catads_ads`;
CREATE TABLE IF NOT EXISTS `xoops_catads_ads` (
`ads_id` int(11) NOT NULL auto_increment,
`cat_id` int(11) NOT NULL default '0',
`ads_title` varchar(100) collate latin1_general_ci NOT NULL default '',
`ads_type` varchar(40) collate latin1_general_ci NOT NULL default '',
`ads_desc` text collate latin1_general_ci NOT NULL,
`price` int(11) NOT NULL default '0',
`monnaie` varchar(20) collate latin1_general_ci NOT NULL default '',
`price_option` varchar(40) collate latin1_general_ci NOT NULL default '',
`email` varchar(100) collate latin1_general_ci NOT NULL default '',
`uid` int(6) NOT NULL default '0',
`phone` varchar(20) collate latin1_general_ci NOT NULL default '',
`town` varchar(200) collate latin1_general_ci NOT NULL default '',
`codpost` varchar(25) collate latin1_general_ci NOT NULL default '',
`created` int(10) NOT NULL default '0',
`published` int(10) NOT NULL default '0',
`expired` int(10) NOT NULL default '0',
`view` tinyint(2) NOT NULL default '0',
`notify_pub` tinyint(1) NOT NULL default '0',
`poster_ip` varchar(20) collate latin1_general_ci NOT NULL default '',
`contact_mode` tinyint(1) NOT NULL default '0',
`countpub` tinyint(1) NOT NULL default '0',
`suspend` tinyint(1) NOT NULL default '0',
`waiting` tinyint(1) NOT NULL default '0',
`photo0` varchar(255) collate latin1_general_ci NOT NULL default '',
`photo1` varchar(255) collate latin1_general_ci NOT NULL default '',
`photo2` varchar(255) collate latin1_general_ci NOT NULL default '',
`photo3` varchar(255) collate latin1_general_ci NOT NULL default '',
`photo4` varchar(255) collate latin1_general_ci NOT NULL default '',
`photo5` varchar(255) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`ads_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_catads_cat`
--
DROP TABLE IF EXISTS `xoops_catads_cat`;
CREATE TABLE IF NOT EXISTS `xoops_catads_cat` (
`cat_id` int(11) unsigned NOT NULL auto_increment,
`pid` int(5) unsigned NOT NULL default '0',
`title` varchar(50) collate latin1_general_ci NOT NULL default '',
`img` varchar(150) collate latin1_general_ci NOT NULL default '',
`weight` int(5) NOT NULL default '0',
`display_price` int(5) NOT NULL default '0',
`nb_photo` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=87 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_catads_options`
--
DROP TABLE IF EXISTS `xoops_catads_options`;
CREATE TABLE IF NOT EXISTS `xoops_catads_options` (
`option_id` tinyint(4) NOT NULL auto_increment,
`option_type` tinyint(4) NOT NULL default '0',
`option_desc` varchar(20) collate latin1_general_ci NOT NULL default '',
`option_order` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`option_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_config`
--
DROP TABLE IF EXISTS `xoops_config`;
CREATE TABLE IF NOT EXISTS `xoops_config` (
`conf_id` smallint(5) unsigned NOT NULL auto_increment,
`conf_modid` smallint(5) unsigned NOT NULL default '0',
`conf_catid` smallint(5) unsigned NOT NULL default '0',
`conf_name` varchar(25) collate latin1_general_ci NOT NULL default '',
`conf_title` varchar(30) collate latin1_general_ci NOT NULL default '',
`conf_value` text collate latin1_general_ci NOT NULL,
`conf_desc` varchar(30) collate latin1_general_ci NOT NULL default '',
`conf_formtype` varchar(15) collate latin1_general_ci NOT NULL default '',
`conf_valuetype` varchar(10) collate latin1_general_ci NOT NULL default '',
`conf_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`conf_id`),
KEY `conf_mod_cat_id` (`conf_modid`,`conf_catid`)
) ENGINE=MyISAM AUTO_INCREMENT=238 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=238 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_configcategory`
--
DROP TABLE IF EXISTS `xoops_configcategory`;
CREATE TABLE IF NOT EXISTS `xoops_configcategory` (
`confcat_id` smallint(5) unsigned NOT NULL auto_increment,
`confcat_name` varchar(25) collate latin1_general_ci NOT NULL default '',
`confcat_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`confcat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_configoption`
--
DROP TABLE IF EXISTS `xoops_configoption`;
CREATE TABLE IF NOT EXISTS `xoops_configoption` (
`confop_id` mediumint(8) unsigned NOT NULL auto_increment,
`confop_name` varchar(255) collate latin1_general_ci NOT NULL default '',
`confop_value` varchar(255) collate latin1_general_ci NOT NULL default '',
`conf_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`confop_id`),
KEY `conf_id` (`conf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=306 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=306 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_field1`
--
DROP TABLE IF EXISTS `xoops_field1`;
CREATE TABLE IF NOT EXISTS `xoops_field1` (
`id` mediumint(9) NOT NULL,
`user_input` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_field2`
--
DROP TABLE IF EXISTS `xoops_field2`;
CREATE TABLE IF NOT EXISTS `xoops_field2` (
`id` mediumint(9) NOT NULL,
`user_input` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_field3`
--
DROP TABLE IF EXISTS `xoops_field3`;
CREATE TABLE IF NOT EXISTS `xoops_field3` (
`id` mediumint(9) NOT NULL,
`user_input` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_field4`
--
DROP TABLE IF EXISTS `xoops_field4`;
CREATE TABLE IF NOT EXISTS `xoops_field4` (
`id` mediumint(9) NOT NULL,
`user_input` blob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_globetable`
--
DROP TABLE IF EXISTS `xoops_globetable`;
CREATE TABLE IF NOT EXISTS `xoops_globetable` (
`id` mediumint(9) NOT NULL auto_increment,
`xcords` varchar(4) collate latin1_general_ci default NULL,
`ycords` varchar(4) collate latin1_general_ci default NULL,
`icon` varchar(20) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_group_permission`
--
DROP TABLE IF EXISTS `xoops_group_permission`;
CREATE TABLE IF NOT EXISTS `xoops_group_permission` (
`gperm_id` int(10) unsigned NOT NULL auto_increment,
`gperm_groupid` smallint(5) unsigned NOT NULL default '0',
`gperm_itemid` mediumint(8) unsigned NOT NULL default '0',
`gperm_modid` mediumint(5) unsigned NOT NULL default '0',
`gperm_name` varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`gperm_id`),
KEY `groupid` (`gperm_groupid`),
KEY `itemid` (`gperm_itemid`),
KEY `gperm_modid` (`gperm_modid`,`gperm_name`(10))
) ENGINE=MyISAM AUTO_INCREMENT=1981 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1981 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_groups`
--
DROP TABLE IF EXISTS `xoops_groups`;
CREATE TABLE IF NOT EXISTS `xoops_groups` (
`groupid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(50) collate latin1_general_ci NOT NULL default '',
`description` text collate latin1_general_ci NOT NULL,
`group_type` varchar(10) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`groupid`),
KEY `group_type` (`group_type`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_groups_users_link`
--
DROP TABLE IF EXISTS `xoops_groups_users_link`;
CREATE TABLE IF NOT EXISTS `xoops_groups_users_link` (
`linkid` mediumint(8) unsigned NOT NULL auto_increment,
`groupid` smallint(5) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`linkid`),
KEY `groupid_uid` (`groupid`,`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=41 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_gs_log`
--
DROP TABLE IF EXISTS `xoops_gs_log`;
CREATE TABLE IF NOT EXISTS `xoops_gs_log` (
`id` int(10) unsigned NOT NULL auto_increment,
`robot` smallint(7) unsigned NOT NULL default '0',
`url` varchar(255) collate latin1_general_ci NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(16) collate latin1_general_ci NOT NULL default '',
`dns` varchar(120) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_gs_robots`
--
DROP TABLE IF EXISTS `xoops_gs_robots`;
CREATE TABLE IF NOT EXISTS `xoops_gs_robots` (
`id` smallint(7) unsigned NOT NULL auto_increment,
`actif` smallint(1) unsigned NOT NULL default '1',
`user_agent` varchar(255) collate latin1_general_ci NOT NULL default '',
`ip1` varchar(16) collate latin1_general_ci NOT NULL default '',
`ip2` varchar(16) collate latin1_general_ci NOT NULL default '',
`nom` varchar(255) collate latin1_general_ci NOT NULL default '',
`detection` enum('detection_user_agent','detection_ip') collate latin1_general_ci NOT NULL default 'detection_user_agent',
`descr_fr` text collate latin1_general_ci,
`descr_en` text collate latin1_general_ci,
`url` varchar(120) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=19 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_image`
--
DROP TABLE IF EXISTS `xoops_image`;
CREATE TABLE IF NOT EXISTS `xoops_image` (
`image_id` mediumint(8) unsigned NOT NULL auto_increment,
`image_name` varchar(30) collate latin1_general_ci NOT NULL default '',
`image_nicename` varchar(255) collate latin1_general_ci NOT NULL default '',
`image_mimetype` varchar(30) collate latin1_general_ci NOT NULL default '',
`image_created` int(10) unsigned NOT NULL default '0',
`image_display` tinyint(1) unsigned NOT NULL default '0',
`image_weight` smallint(5) unsigned NOT NULL default '0',
`imgcat_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`image_id`),
KEY `imgcat_id` (`imgcat_id`),
KEY `image_display` (`image_display`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_imagebody`
--
DROP TABLE IF EXISTS `xoops_imagebody`;
CREATE TABLE IF NOT EXISTS `xoops_imagebody` (
`image_id` mediumint(8) unsigned NOT NULL default '0',
`image_body` mediumblob,
KEY `image_id` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_imagecategory`
--
DROP TABLE IF EXISTS `xoops_imagecategory`;
CREATE TABLE IF NOT EXISTS `xoops_imagecategory` (
`imgcat_id` smallint(5) unsigned NOT NULL auto_increment,
`imgcat_name` varchar(100) collate latin1_general_ci NOT NULL default '',
`imgcat_maxsize` int(8) unsigned NOT NULL default '0',
`imgcat_maxwidth` smallint(3) unsigned NOT NULL default '0',
`imgcat_maxheight` smallint(3) unsigned NOT NULL default '0',
`imgcat_display` tinyint(1) unsigned NOT NULL default '0',
`imgcat_weight` smallint(3) unsigned NOT NULL default '0',
`imgcat_type` char(1) collate latin1_general_ci NOT NULL default '',
`imgcat_storetype` varchar(5) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`imgcat_id`),
KEY `imgcat_display` (`imgcat_display`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_imgset`
--
DROP TABLE IF EXISTS `xoops_imgset`;
CREATE TABLE IF NOT EXISTS `xoops_imgset` (
`imgset_id` smallint(5) unsigned NOT NULL auto_increment,
`imgset_name` varchar(50) collate latin1_general_ci NOT NULL default '',
`imgset_refid` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`imgset_id`),
KEY `imgset_refid` (`imgset_refid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_imgset_tplset_link`
--
DROP TABLE IF EXISTS `xoops_imgset_tplset_link`;
CREATE TABLE IF NOT EXISTS `xoops_imgset_tplset_link` (
`imgset_id` smallint(5) unsigned NOT NULL default '0',
`tplset_name` varchar(50) collate latin1_general_ci NOT NULL default '',
KEY `tplset_name` (`tplset_name`(10))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_imgsetimg`
--
DROP TABLE IF EXISTS `xoops_imgsetimg`;
CREATE TABLE IF NOT EXISTS `xoops_imgsetimg` (
`imgsetimg_id` mediumint(8) unsigned NOT NULL auto_increment,
`imgsetimg_file` varchar(50) collate latin1_general_ci NOT NULL default '',
`imgsetimg_body` blob NOT NULL,
`imgsetimg_imgset` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`imgsetimg_id`),
KEY `imgsetimg_imgset` (`imgsetimg_imgset`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_modules`
--
DROP TABLE IF EXISTS `xoops_modules`;
CREATE TABLE IF NOT EXISTS `xoops_modules` (
`mid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(150) collate latin1_general_ci NOT NULL default '',
`version` smallint(5) unsigned NOT NULL default '100',
`last_update` int(10) unsigned NOT NULL default '0',
`weight` smallint(3) unsigned NOT NULL default '0',
`isactive` tinyint(1) unsigned NOT NULL default '0',
`dirname` varchar(25) collate latin1_general_ci NOT NULL default '',
`hasmain` tinyint(1) unsigned NOT NULL default '0',
`hasadmin` tinyint(1) unsigned NOT NULL default '0',
`hassearch` tinyint(1) unsigned NOT NULL default '0',
`hasconfig` tinyint(1) unsigned NOT NULL default '0',
`hascomments` tinyint(1) unsigned NOT NULL default '0',
`hasnotification` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`mid`),
KEY `hasmain` (`hasmain`),
KEY `hasadmin` (`hasadmin`),
KEY `hassearch` (`hassearch`),
KEY `hasnotification` (`hasnotification`),
KEY `dirname` (`dirname`),
KEY `name` (`name`(15))
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=26 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_broken`
--
DROP TABLE IF EXISTS `xoops_mydownloads_broken`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_broken` (
`reportid` int(5) NOT NULL auto_increment,
`lid` int(11) NOT NULL default '0',
`sender` int(11) NOT NULL default '0',
`ip` varchar(20) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`reportid`),
KEY `lid` (`lid`),
KEY `sender` (`sender`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_cat`
--
DROP TABLE IF EXISTS `xoops_mydownloads_cat`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_cat` (
`cid` int(5) unsigned NOT NULL auto_increment,
`pid` int(5) unsigned NOT NULL default '0',
`title` varchar(50) collate latin1_general_ci NOT NULL default '',
`imgurl` varchar(150) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`cid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=15 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_downloads`
--
DROP TABLE IF EXISTS `xoops_mydownloads_downloads`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_downloads` (
`lid` int(11) unsigned NOT NULL auto_increment,
`cid` int(5) unsigned NOT NULL default '0',
`title` varchar(100) collate latin1_general_ci NOT NULL default '',
`url` varchar(250) collate latin1_general_ci NOT NULL default '',
`homepage` varchar(100) collate latin1_general_ci NOT NULL default '',
`version` varchar(10) collate latin1_general_ci NOT NULL default '',
`size` int(8) NOT NULL default '0',
`platform` varchar(50) collate latin1_general_ci NOT NULL default '',
`logourl` varchar(60) collate latin1_general_ci NOT NULL default '',
`submitter` int(11) NOT NULL default '0',
`status` tinyint(2) NOT NULL default '0',
`date` int(10) NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
`rating` double(6,4) NOT NULL default '0.0000',
`votes` int(11) unsigned NOT NULL default '0',
`comments` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `status` (`status`),
KEY `title` (`title`(40))
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_mod`
--
DROP TABLE IF EXISTS `xoops_mydownloads_mod`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_mod` (
`requestid` int(11) unsigned NOT NULL auto_increment,
`lid` int(11) unsigned NOT NULL default '0',
`cid` int(5) unsigned NOT NULL default '0',
`title` varchar(100) collate latin1_general_ci NOT NULL default '',
`url` varchar(250) collate latin1_general_ci NOT NULL default '',
`homepage` varchar(100) collate latin1_general_ci NOT NULL default '',
`version` varchar(10) collate latin1_general_ci NOT NULL default '',
`size` int(8) NOT NULL default '0',
`platform` varchar(50) collate latin1_general_ci NOT NULL default '',
`logourl` varchar(60) collate latin1_general_ci NOT NULL default '',
`description` text collate latin1_general_ci NOT NULL,
`modifysubmitter` int(11) NOT NULL default '0',
PRIMARY KEY (`requestid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_text`
--
DROP TABLE IF EXISTS `xoops_mydownloads_text`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_text` (
`lid` int(11) unsigned NOT NULL default '0',
`description` text collate latin1_general_ci NOT NULL,
KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mydownloads_votedata`
--
DROP TABLE IF EXISTS `xoops_mydownloads_votedata`;
CREATE TABLE IF NOT EXISTS `xoops_mydownloads_votedata` (
`ratingid` int(11) unsigned NOT NULL auto_increment,
`lid` int(11) unsigned NOT NULL default '0',
`ratinguser` int(11) NOT NULL default '0',
`rating` tinyint(3) unsigned NOT NULL default '0',
`ratinghostname` varchar(60) collate latin1_general_ci NOT NULL default '',
`ratingtimestamp` int(10) NOT NULL default '0',
PRIMARY KEY (`ratingid`),
KEY `ratinguser` (`ratinguser`),
KEY `ratinghostname` (`ratinghostname`),
KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_broken`
--
DROP TABLE IF EXISTS `xoops_mylinks_broken`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_broken` (
`reportid` int(5) NOT NULL auto_increment,
`lid` int(11) unsigned NOT NULL default '0',
`sender` int(11) unsigned NOT NULL default '0',
`ip` varchar(20) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`reportid`),
KEY `lid` (`lid`),
KEY `sender` (`sender`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_cat`
--
DROP TABLE IF EXISTS `xoops_mylinks_cat`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_cat` (
`cid` int(5) unsigned NOT NULL auto_increment,
`pid` int(5) unsigned NOT NULL default '0',
`title` varchar(50) collate latin1_general_ci NOT NULL default '',
`imgurl` varchar(150) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`cid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_links`
--
DROP TABLE IF EXISTS `xoops_mylinks_links`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_links` (
`lid` int(11) unsigned NOT NULL auto_increment,
`cid` int(5) unsigned NOT NULL default '0',
`title` varchar(100) collate latin1_general_ci NOT NULL default '',
`url` varchar(250) collate latin1_general_ci NOT NULL default '',
`logourl` varchar(60) collate latin1_general_ci NOT NULL default '',
`submitter` int(11) unsigned NOT NULL default '0',
`status` tinyint(2) NOT NULL default '0',
`date` int(10) NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
`rating` double(6,4) NOT NULL default '0.0000',
`votes` int(11) unsigned NOT NULL default '0',
`comments` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `status` (`status`),
KEY `title` (`title`(40))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_mod`
--
DROP TABLE IF EXISTS `xoops_mylinks_mod`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_mod` (
`requestid` int(11) unsigned NOT NULL auto_increment,
`lid` int(11) unsigned NOT NULL default '0',
`cid` int(5) unsigned NOT NULL default '0',
`title` varchar(100) collate latin1_general_ci NOT NULL default '',
`url` varchar(250) collate latin1_general_ci NOT NULL default '',
`logourl` varchar(150) collate latin1_general_ci NOT NULL default '',
`description` text collate latin1_general_ci NOT NULL,
`modifysubmitter` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`requestid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_text`
--
DROP TABLE IF EXISTS `xoops_mylinks_text`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_text` (
`lid` int(11) unsigned NOT NULL default '0',
`description` text collate latin1_general_ci NOT NULL,
KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_mylinks_votedata`
--
DROP TABLE IF EXISTS `xoops_mylinks_votedata`;
CREATE TABLE IF NOT EXISTS `xoops_mylinks_votedata` (
`ratingid` int(11) unsigned NOT NULL auto_increment,
`lid` int(11) unsigned NOT NULL default '0',
`ratinguser` int(11) unsigned NOT NULL default '0',
`rating` tinyint(3) unsigned NOT NULL default '0',
`ratinghostname` varchar(60) collate latin1_general_ci NOT NULL default '',
`ratingtimestamp` int(10) NOT NULL default '0',
PRIMARY KEY (`ratingid`),
KEY `ratinguser` (`ratinguser`),
KEY `ratinghostname` (`ratinghostname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_banned`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_banned`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_banned` (
`bid` int(11) unsigned NOT NULL auto_increment,
`user` varchar(25) collate latin1_general_ci NOT NULL,
`from_time` int(10) NOT NULL,
`to_time` int(10) NOT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_messages`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_messages`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_messages` (
`mid` int(11) unsigned NOT NULL auto_increment,
`chatroom` varchar(50) collate latin1_general_ci NOT NULL,
`message` text collate latin1_general_ci NOT NULL,
`poster` varchar(25) collate latin1_general_ci NOT NULL,
`post_time` int(10) NOT NULL,
`poster_ip` varchar(15) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_pmsgs`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_pmsgs`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_pmsgs` (
`mid` int(11) unsigned NOT NULL auto_increment,
`msg_from` varchar(25) collate latin1_general_ci NOT NULL,
`msg_to` varchar(25) collate latin1_general_ci NOT NULL,
`msg_text` text collate latin1_general_ci NOT NULL,
`post_time` int(10) NOT NULL,
`poster_ip` varchar(15) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_requests`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_requests`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_requests` (
`rid` int(11) unsigned NOT NULL auto_increment,
`req_from` varchar(25) collate latin1_general_ci NOT NULL,
`req_to` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_rooms`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_rooms`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_rooms` (
`rid` int(10) unsigned NOT NULL auto_increment,
`room_name` varchar(30) collate latin1_general_ci NOT NULL,
`room_type` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`rid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_visibility`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_visibility`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_visibility` (
`visid` smallint(6) NOT NULL auto_increment,
`rid` smallint(6) NOT NULL default '0',
`groupid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`visid`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_myxoopschat_whosonline`
--
DROP TABLE IF EXISTS `xoops_myxoopschat_whosonline`;
CREATE TABLE IF NOT EXISTS `xoops_myxoopschat_whosonline` (
`wid` int(11) unsigned NOT NULL auto_increment,
`uid` int(5) NOT NULL,
`nick` varchar(25) collate latin1_general_ci NOT NULL,
`user_name` varchar(25) collate latin1_general_ci NOT NULL,
`user_mail` varchar(60) collate latin1_general_ci NOT NULL,
`user_icq` varchar(15) collate latin1_general_ci NOT NULL,
`user_aim` varchar(18) collate latin1_general_ci NOT NULL,
`user_yim` varchar(25) collate latin1_general_ci NOT NULL,
`user_msnm` varchar(25) collate latin1_general_ci NOT NULL,
`user_ip` varchar(15) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`wid`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=37 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_newblocks`
--
DROP TABLE IF EXISTS `xoops_newblocks`;
CREATE TABLE IF NOT EXISTS `xoops_newblocks` (
`bid` mediumint(8) unsigned NOT NULL auto_increment,
`mid` smallint(5) unsigned NOT NULL default '0',
`func_num` tinyint(3) unsigned NOT NULL default '0',
`options` varchar(255) collate latin1_general_ci NOT NULL default '',
`name` varchar(150) collate latin1_general_ci NOT NULL default '',
`title` varchar(255) collate latin1_general_ci NOT NULL default '',
`content` text collate latin1_general_ci NOT NULL,
`side` tinyint(1) unsigned NOT NULL default '0',
`weight` smallint(5) unsigned NOT NULL default '0',
`visible` tinyint(1) unsigned NOT NULL default '0',
`block_type` char(1) collate latin1_general_ci NOT NULL default '',
`c_type` char(1) collate latin1_general_ci NOT NULL default '',
`isactive` tinyint(1) unsigned NOT NULL default '0',
`dirname` varchar(50) collate latin1_general_ci NOT NULL default '',
`func_file` varchar(50) collate latin1_general_ci NOT NULL default '',
`show_func` varchar(50) collate latin1_general_ci NOT NULL default '',
`edit_func` varchar(50) collate latin1_general_ci NOT NULL default '',
`template` varchar(50) collate latin1_general_ci NOT NULL default '',
`bcachetime` int(10) unsigned NOT NULL default '0',
`last_modified` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`bid`),
KEY `mid` (`mid`),
KEY `visible` (`visible`),
KEY `isactive_visible_mid` (`isactive`,`visible`,`mid`),
KEY `mid_funcnum` (`mid`,`func_num`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=44 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_online`
--
DROP TABLE IF EXISTS `xoops_online`;
CREATE TABLE IF NOT EXISTS `xoops_online` (
`online_uid` mediumint(8) unsigned NOT NULL default '0',
`online_uname` varchar(25) collate latin1_general_ci NOT NULL default '',
`online_updated` int(10) unsigned NOT NULL default '0',
`online_module` smallint(5) unsigned NOT NULL default '0',
`online_ip` varchar(15) collate latin1_general_ci NOT NULL default '',
KEY `online_module` (`online_module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_pages`
--
DROP TABLE IF EXISTS `xoops_pages`;
CREATE TABLE IF NOT EXISTS `xoops_pages` (
`CID` tinyint(4) NOT NULL auto_increment,
`pagetitle` varchar(255) collate latin1_general_ci NOT NULL default '0',
`pageheadline` varchar(255) collate latin1_general_ci NOT NULL default '0',
`page` text collate latin1_general_ci NOT NULL,
`weight` int(11) NOT NULL default '1',
`html` int(11) NOT NULL default '0',
`smiley` int(11) NOT NULL default '1',
`xcodes` int(11) NOT NULL default '1',
`breaks` int(10) NOT NULL default '1',
`defaultpage` int(10) NOT NULL default '0',
`indeximage` varchar(255) collate latin1_general_ci default 'blank.png',
`htmlfile` varchar(255) collate latin1_general_ci default NULL,
`mainpage` int(11) NOT NULL default '0',
`submenu` int(11) NOT NULL default '0',
`created` int(10) unsigned NOT NULL default '0',
`comments` tinyint(11) NOT NULL default '0',
`allowcomments` tinyint(11) NOT NULL default '0',
`usedoctitle` tinyint(1) NOT NULL default '0',
`publishdate` int(10) unsigned NOT NULL default '0',
`expiredate` int(10) unsigned NOT NULL default '0',
`counter` int(11) NOT NULL default '0',
`search` text collate latin1_general_ci,
PRIMARY KEY (`CID`),
UNIQUE KEY `topicID` (`CID`),
FULLTEXT KEY `answer` (`page`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Pages' AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_pages_linktous`
--
DROP TABLE IF EXISTS `xoops_pages_linktous`;
CREATE TABLE IF NOT EXISTS `xoops_pages_linktous` (
`submenuitem` int(10) NOT NULL default '10',
`textlink` varchar(255) collate latin1_general_ci NOT NULL default '',
`linkpagelogo` varchar(255) collate latin1_general_ci NOT NULL default '',
`button` varchar(255) collate latin1_general_ci NOT NULL default '',
`microbutton` varchar(255) collate latin1_general_ci NOT NULL default '',
`logo` varchar(255) collate latin1_general_ci NOT NULL default '',
`banner` varchar(255) collate latin1_general_ci NOT NULL default '',
`mainpage` int(10) NOT NULL default '1',
`newsfeed` int(10) NOT NULL default '0',
`texthtml` varchar(255) collate latin1_general_ci NOT NULL default '',
`titlelink` varchar(255) collate latin1_general_ci NOT NULL default '',
`newsfeedjs` mediumint(10) NOT NULL default '0',
`newstitle` varchar(255) collate latin1_general_ci NOT NULL default '',
`linkintro` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`submenuitem`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_pages_refer`
--
DROP TABLE IF EXISTS `xoops_pages_refer`;
CREATE TABLE IF NOT EXISTS `xoops_pages_refer` (
`titlerefer` varchar(255) collate latin1_general_ci NOT NULL default '',
`chanrefheadline` text collate latin1_general_ci NOT NULL,
`submenuitem` int(10) NOT NULL default '10',
`mainpage` int(10) NOT NULL default '1',
`referpagelogo` varchar(255) collate latin1_general_ci NOT NULL default '',
`emailaddress` int(10) NOT NULL default '1',
`usersblurb` int(10) NOT NULL default '0',
`defblurb` varchar(255) collate latin1_general_ci NOT NULL default '',
`smiley` tinyint(11) NOT NULL default '0',
`xcodes` tinyint(11) NOT NULL default '0',
`breaks` tinyint(4) NOT NULL default '0',
`html` tinyint(11) NOT NULL default '1',
`privacy` int(1) NOT NULL default '1',
`emailcheck` int(1) NOT NULL default '1',
`privacy_statement` text collate latin1_general_ci NOT NULL,
`counter` int(11) NOT NULL default '0',
PRIMARY KEY (`submenuitem`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_priv_msgs`
--
DROP TABLE IF EXISTS `xoops_priv_msgs`;
CREATE TABLE IF NOT EXISTS `xoops_priv_msgs` (
`msg_id` mediumint(8) unsigned NOT NULL auto_increment,
`msg_image` varchar(100) collate latin1_general_ci default NULL,
`subject` varchar(255) collate latin1_general_ci NOT NULL default '',
`from_userid` mediumint(8) unsigned NOT NULL default '0',
`to_userid` mediumint(8) unsigned NOT NULL default '0',
`msg_time` int(10) unsigned NOT NULL default '0',
`msg_text` text collate latin1_general_ci NOT NULL,
`read_msg` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`msg_id`),
KEY `to_userid` (`to_userid`),
KEY `touseridreadmsg` (`to_userid`,`read_msg`),
KEY `msgidfromuserid` (`msg_id`,`from_userid`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_ranks`
--
DROP TABLE IF EXISTS `xoops_ranks`;
CREATE TABLE IF NOT EXISTS `xoops_ranks` (
`rank_id` smallint(5) unsigned NOT NULL auto_increment,
`rank_title` varchar(50) collate latin1_general_ci NOT NULL default '',
`rank_min` mediumint(8) unsigned NOT NULL default '0',
`rank_max` mediumint(8) unsigned NOT NULL default '0',
`rank_special` tinyint(1) unsigned NOT NULL default '0',
`rank_image` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`rank_id`),
KEY `rank_min` (`rank_min`),
KEY `rank_max` (`rank_max`),
KEY `rankminrankmaxranspecial` (`rank_min`,`rank_max`,`rank_special`),
KEY `rankspecial` (`rank_special`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_session`
--
DROP TABLE IF EXISTS `xoops_session`;
CREATE TABLE IF NOT EXISTS `xoops_session` (
`sess_id` varchar(32) collate latin1_general_ci NOT NULL default '',
`sess_updated` int(10) unsigned NOT NULL default '0',
`sess_ip` varchar(15) collate latin1_general_ci NOT NULL default '',
`sess_data` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_smiles`
--
DROP TABLE IF EXISTS `xoops_smiles`;
CREATE TABLE IF NOT EXISTS `xoops_smiles` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(50) collate latin1_general_ci NOT NULL default '',
`smile_url` varchar(100) collate latin1_general_ci NOT NULL default '',
`emotion` varchar(75) collate latin1_general_ci NOT NULL default '',
`display` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=18 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_stories`
--
DROP TABLE IF EXISTS `xoops_stories`;
CREATE TABLE IF NOT EXISTS `xoops_stories` (
`storyid` int(8) unsigned NOT NULL auto_increment,
`uid` int(5) unsigned NOT NULL default '0',
`title` varchar(255) collate latin1_general_ci NOT NULL default '',
`created` int(10) unsigned NOT NULL default '0',
`published` int(10) unsigned NOT NULL default '0',
`expired` int(10) unsigned NOT NULL default '0',
`hostname` varchar(20) collate latin1_general_ci NOT NULL default '',
`nohtml` tinyint(1) NOT NULL default '0',
`nosmiley` tinyint(1) NOT NULL default '0',
`hometext` text collate latin1_general_ci NOT NULL,
`bodytext` text collate latin1_general_ci NOT NULL,
`counter` int(8) unsigned NOT NULL default '0',
`topicid` smallint(4) unsigned NOT NULL default '1',
`ihome` tinyint(1) NOT NULL default '0',
`notifypub` tinyint(1) NOT NULL default '0',
`story_type` varchar(5) collate latin1_general_ci NOT NULL default '',
`topicdisplay` tinyint(1) NOT NULL default '0',
`topicalign` char(1) collate latin1_general_ci NOT NULL default 'R',
`comments` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`storyid`),
KEY `idxstoriestopic` (`topicid`),
KEY `ihome` (`ihome`),
KEY `uid` (`uid`),
KEY `published_ihome` (`published`,`ihome`),
KEY `title` (`title`(40)),
KEY `created` (`created`),
FULLTEXT KEY `search` (`title`,`hometext`,`bodytext`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=22 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_topics`
--
DROP TABLE IF EXISTS `xoops_topics`;
CREATE TABLE IF NOT EXISTS `xoops_topics` (
`topic_id` smallint(4) unsigned NOT NULL auto_increment,
`topic_pid` smallint(4) unsigned NOT NULL default '0',
`topic_imgurl` varchar(20) collate latin1_general_ci NOT NULL default '',
`topic_title` varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`topic_id`),
KEY `pid` (`topic_pid`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_tplfile`
--
DROP TABLE IF EXISTS `xoops_tplfile`;
CREATE TABLE IF NOT EXISTS `xoops_tplfile` (
`tpl_id` mediumint(7) unsigned NOT NULL auto_increment,
`tpl_refid` smallint(5) unsigned NOT NULL default '0',
`tpl_module` varchar(25) collate latin1_general_ci NOT NULL default '',
`tpl_tplset` varchar(50) collate latin1_general_ci NOT NULL default '',
`tpl_file` varchar(50) collate latin1_general_ci NOT NULL default '',
`tpl_desc` varchar(255) collate latin1_general_ci NOT NULL default '',
`tpl_lastmodified` int(10) unsigned NOT NULL default '0',
`tpl_lastimported` int(10) unsigned NOT NULL default '0',
`tpl_type` varchar(20) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`tpl_id`),
KEY `tpl_refid` (`tpl_refid`,`tpl_type`),
KEY `tpl_tplset` (`tpl_tplset`,`tpl_file`(10))
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=117 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_tplset`
--
DROP TABLE IF EXISTS `xoops_tplset`;
CREATE TABLE IF NOT EXISTS `xoops_tplset` (
`tplset_id` int(7) unsigned NOT NULL auto_increment,
`tplset_name` varchar(50) collate latin1_general_ci NOT NULL default '',
`tplset_desc` varchar(255) collate latin1_general_ci NOT NULL default '',
`tplset_credits` text collate latin1_general_ci NOT NULL,
`tplset_created` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tplset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_tplsource`
--
DROP TABLE IF EXISTS `xoops_tplsource`;
CREATE TABLE IF NOT EXISTS `xoops_tplsource` (
`tpl_id` mediumint(7) unsigned NOT NULL default '0',
`tpl_source` mediumtext collate latin1_general_ci NOT NULL,
KEY `tpl_id` (`tpl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_users`
--
DROP TABLE IF EXISTS `xoops_users`;
CREATE TABLE IF NOT EXISTS `xoops_users` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) collate latin1_general_ci NOT NULL default '',
`uname` varchar(25) collate latin1_general_ci NOT NULL default '',
`email` varchar(60) collate latin1_general_ci NOT NULL default '',
`url` varchar(100) collate latin1_general_ci NOT NULL default '',
`user_avatar` varchar(30) collate latin1_general_ci NOT NULL default 'blank.gif',
`user_regdate` int(10) unsigned NOT NULL default '0',
`user_icq` varchar(15) collate latin1_general_ci NOT NULL default '',
`user_from` varchar(100) collate latin1_general_ci NOT NULL default '',
`user_sig` tinytext collate latin1_general_ci NOT NULL,
`user_viewemail` tinyint(1) unsigned NOT NULL default '0',
`actkey` varchar(8) collate latin1_general_ci NOT NULL default '',
`user_aim` varchar(18) collate latin1_general_ci NOT NULL default '',
`user_yim` varchar(25) collate latin1_general_ci NOT NULL default '',
`user_msnm` varchar(100) collate latin1_general_ci NOT NULL default '',
`pass` varchar(32) collate latin1_general_ci NOT NULL default '',
`posts` mediumint(8) unsigned NOT NULL default '0',
`attachsig` tinyint(1) unsigned NOT NULL default '0',
`rank` smallint(5) unsigned NOT NULL default '0',
`level` tinyint(3) unsigned NOT NULL default '1',
`theme` varchar(100) collate latin1_general_ci NOT NULL default '',
`timezone_offset` float(3,1) NOT NULL default '0.0',
`last_login` int(10) unsigned NOT NULL default '0',
`umode` varchar(10) collate latin1_general_ci NOT NULL default '',
`uorder` tinyint(1) unsigned NOT NULL default '0',
`notify_method` tinyint(1) NOT NULL default '1',
`notify_mode` tinyint(1) NOT NULL default '0',
`user_occ` varchar(100) collate latin1_general_ci NOT NULL default '',
`bio` tinytext collate latin1_general_ci NOT NULL,
`user_intrest` varchar(150) collate latin1_general_ci NOT NULL default '',
`user_mailok` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`),
KEY `uiduname` (`uid`,`uname`),
KEY `unamepass` (`uname`,`pass`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=32 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_xoopscomments`
--
DROP TABLE IF EXISTS `xoops_xoopscomments`;
CREATE TABLE IF NOT EXISTS `xoops_xoopscomments` (
`com_id` mediumint(8) unsigned NOT NULL auto_increment,
`com_pid` mediumint(8) unsigned NOT NULL default '0',
`com_rootid` mediumint(8) unsigned NOT NULL default '0',
`com_modid` smallint(5) unsigned NOT NULL default '0',
`com_itemid` mediumint(8) unsigned NOT NULL default '0',
`com_icon` varchar(25) collate latin1_general_ci NOT NULL default '',
`com_created` int(10) unsigned NOT NULL default '0',
`com_modified` int(10) unsigned NOT NULL default '0',
`com_uid` mediumint(8) unsigned NOT NULL default '0',
`com_ip` varchar(15) collate latin1_general_ci NOT NULL default '',
`com_title` varchar(255) collate latin1_general_ci NOT NULL default '',
`com_text` text collate latin1_general_ci NOT NULL,
`com_sig` tinyint(1) unsigned NOT NULL default '0',
`com_status` tinyint(1) unsigned NOT NULL default '0',
`com_exparams` varchar(255) collate latin1_general_ci NOT NULL default '',
`dohtml` tinyint(1) unsigned NOT NULL default '0',
`dosmiley` tinyint(1) unsigned NOT NULL default '0',
`doxcode` tinyint(1) unsigned NOT NULL default '0',
`doimage` tinyint(1) unsigned NOT NULL default '0',
`dobr` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`com_id`),
KEY `com_pid` (`com_pid`),
KEY `com_itemid` (`com_itemid`),
KEY `com_uid` (`com_uid`),
KEY `com_title` (`com_title`(40))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_xoopsnotifications`
--
DROP TABLE IF EXISTS `xoops_xoopsnotifications`;
CREATE TABLE IF NOT EXISTS `xoops_xoopsnotifications` (
`not_id` mediumint(8) unsigned NOT NULL auto_increment,
`not_modid` smallint(5) unsigned NOT NULL default '0',
`not_itemid` mediumint(8) unsigned NOT NULL default '0',
`not_category` varchar(30) collate latin1_general_ci NOT NULL default '',
`not_event` varchar(30) collate latin1_general_ci NOT NULL default '',
`not_uid` mediumint(8) unsigned NOT NULL default '0',
`not_mode` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`not_id`),
KEY `not_modid` (`not_modid`),
KEY `not_itemid` (`not_itemid`),
KEY `not_class` (`not_category`),
KEY `not_uid` (`not_uid`),
KEY `not_event` (`not_event`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;
-- --------------------------------------------------------
--
-- Structure de la table `xoops_xoopspoll_desc`
--
DROP TABLE IF EXISTS `xoops_xoopspoll_desc`;
CREATE TABLE IF NOT EXISTS `xoops_xoopspoll_desc` (
`po
Avg "la base de données antivirus est périmée"
