Importer/Exporter base de donnée

L'erreur la plus fréquente est celle-ci:

MySQL a répondu:Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
avatar_name v

Personne ne peut m'aider... ?

Bonjour,
Quelle erreur de syntax est-ce que ça peut être ?

Merci

Bsr

Commence par exporter puis importer uniquement les structures de tes tables sans les données. Car on dirait que l'erreur provient d'une erreur de syntaxe lors de la création d'une table.

Tu peux importer chaque table séparemment afin de trouver celle qui ne fonctionne pas.

Poste éventuellement le code SQL de ton export (sans les données !!!)



PhP  
Il y a 10 types de personnes dans le monde : ceux qui compre­nnent le binaire et les autres ...

Lorsque j'essaye de n'importer que la structure sans les données, voici l'erreur qui m'est affichée:



Il semble que vous ayiez trouvé une anomalie dans l'analyseur syntaxique SQL. Veuillez examiner votre requête attentivement, et vérifier que vos apostrophes sont conformes. Il se pourrait aussi que vous ayiez chargé un fichier dont le contenu binaire n'est pas entre apostrophes. Si vous avez accès à MySQL via son interface de commande en mode ligne, vous pouvez y essayer votre requête. Le message d'erreur présenté plus bas pourrait vous indiquer la source du problème. En dernier recours, veuillez trouver la plus courte requête possible qui cause le problème, et soumettre un rapport d'anomalie en incluant la section à couper:
----Début de la section à couper----
eNo1kg9Q0gcUx+mP5X51K60z5y39dbMyg5/8ERQ4jpH7qSgBCmr2z1RAuVAR­saBBmGm6zCibUdIs
nJulzt2lTXP+6VbOP+g8a8Sw0DblZoJ54t9MZeTOu3fvvXv37n0/792Do6NZ­0SQwBAOGYEEGzCSB
WBAHEolEgMN11jcAQEgshwT60nkkMCtTJE6UZPElkEiYBIlTxcgzIBbCEUAs­Go0PQAc7zZmSsFgS
BgOK+GlEEJaJQV/gsJwTxSCBgRAawgahsqSJ6bxECQ8lykgBYjjRIIuDBGlh­MJOLBGNhp2acMB08
zDpKZzBoIB5CA+zDNCcVRIACUWIRDmCHsz/2IVmcjyNxEAaNcupDWcmpoux0­HoQBGcL0bBnAoDHD
SKBAghJmZaCCg/FEFAZYxWBHbti4E4FAuCIePeAGffixMNDqiUDMTCAQzoAQ­8eX89ORUPuRcFhJI
+Hyn+5hPUEw3XxEeTq4Arbf3JaaJySlSctg74ew/sjs3CryrcCNZrTzbHOX2­fgJMc6+i5/79XK/o
U/adHe2ECO5bTEnrTkkrvPu7m+AH1a73PHYC+b/pNfVJxxSypiN8+trAD/b+­+Xofba1szm6xeZTG
5E6bugdqvn+hgZvvJaRbm2XTmvbXZvNutwbbnorUMGL1W/WMI4EtLyqz9yHh­bX7qxrH7i3jKUY3r
dZXfk2GVA+VYbrTPD7s+s/XZIr/VxWDJxHLl5dMtSLf3siWzbd6h/Q45hGQe­+N1x+VJtWbwhmkol
rcGQyMbzcP1dxxRu2TI6VpvWN1wBDCTEBu8PgA1aU/arutObpuemLR0Gi62z­qKao/YTiMfd8+bLs
/YsO43xcfaOjaUExNTdun7bpLQZk8bhvQu/Q+XOO8n2Z2RlSsr1TfFHCDRV6­7h+mfojoauC2qUKH
7c+nVP3NtJ/0qwx12pLZvcWC7Abfi2eV6syo/IE0btjeyT/qfaiqRXnoon1F­MveuymQJmGw7rsQg
2jPI5gvKJSl+K2lLeZ/AuLSHEWvE9dRcErd8erL9Fl5eKpI0JC34tLepqEVl­XgV0b41fiJwSd81I
j7g0Q/AfSeNuquoMEGCY3W90K64RkoMNV8sayimqupKeb56FRxcl+xyNL9Et­6m5VCytHNqqv7Nit
c9H9WUB9uT2WHlM58HT2SsvYhT0AYP2i66yfSWS1xpfCwojr/ahr8p/fbyfN­LPzbP7l23OOKFaNN
BTnwWpfLhS332p9nzO5yGRx5bXMUpQQIND6OlXcjlm0+3kPKxwvoXxfOzR5Q­zF8vHC/Qq+Ood+6m
LoYHTm0+sUM1FtTKSlKNexKecfPzDgad6uCy3/hXgyb/mgOeV0oo5T3Wq3n+­btNXJXf1v6xKi6Rk
8+YNmijmyc2ntIg8dGSOxAP11nUidnBdiBen9iXjziHPMh5cbPV7dHNj7i34­IK94VxVdwSG2QIPX
6JTS0IXRpdcdQP08i5YKP1kXqjiWItTHd+RM5qkxu//yMhtzzgBHBn8QJN8w­UDK+7H0Eea+Ugp/k
7OV0ydifAV8/PiLTHj+UpPKKbGJJXWob139e17r+glVsq3zabLX3dBsKM0+G­ZU5EbuJHlSy606dW
mbtjEnrzw91iDOYeDRB1Hxthx89FQSeUX02un0rkJjJbZy1S9fhDpr1yMNcA­5zw1wKCMJT8zhLrd
HMEdcNEtr20+Gqwc6K74///amKiUrZ7uPXEefv8Bwb5SMg==
----Fin de la section à couper----
----Début des informations sur l'anomalie----

ERROR: C1 C2 LEN: 2 3 999
STR: 

CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 4.0.27-standard-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.4-pl3
PHP VER,OS: 4.3.10-200.schlund.1 Linux
LANG: fr-iso-8859-1
SQL: PK����µ©T7û¦ˆ4ë�A­533;ôí�����leyenche.sql.­free.fr.sqlí=Ù–Û6²ïþ
½™>Gîiõâxœ“‡§3ãs½dìö=™'6EA§I‚áÒË|Í}ÍwäÇ.6Ùb
`t¢ÏɸE©­ª 
…ÂË—³b[|x¸XeI>ûòÏ÷³›¬xöòåì•U‚óÙÉÑ«£Ó—Eº _nëºxó—¿ÜÝÝ´ì!¢hG9ªé�ôÿ_Py‹šòÍ,E(�·è¨ú5=Z—‘(Àßÿ-ÿý·ò÷ß­ÄìÍìK”¡U2;9ž}Šk¼,ùxüÝì÷ÿ›�,Þ,N)ÆÿŠ†¬šYÕR??:>:;×~E³Ÿÿñ3ý­åäè¬mÍߢ
Ñ_V8'/EÕ›ÙuÛ®kóöóåÅÕåìÇ‹«‹¿]|¹T~žýxùÓÅ×÷W³·ÿ¸ø|ñöêòóìËåÕ,�ê­$_ÌÞ~zÿž"òÇpƒrTFi'ß?ûJÈ´T¾FßòÒñϺA­Ë&®›’õ%�fu´$ƒw}�q­Q…ÑmTG%ïγ?úyFúòþröî§Ùå/ï¾\}1�¿o;Ý�}üt5:žÍf×ü!LV×­3Ê«†p¼^¿˜5y•lr´bø¿¾?‹š‡I—(Cy=W�×IJ†ô6*ãmT§Ç/f1NÉà¡þJr­+´Žš´ž=®’ʉÄHR‹cZY’¡ú¡˜ªi¤ã�Œ¡¡Ô‡?ÖVIU¤ÑÃõŒ¼è�!

ë#Èw(ÙlëëY•EiJ‘Ï-�y¯ù:ôøçÏï>\|þ×ì.ÿ5›Šˆ¼ ¿ÒoõÚãÜìÿ‹g/f—ÿþîãåÞ}¹ø0»øzõ)|÷‘ˆê‡Ë�W?œŸhúH4ñ]è7½O­bê6ÄT…„+7`ÅTPà*ª Ù*«)Œ’=žÊ뎄*óŽrŸË¶<Ý—QN^`›�„0K€r-éíVÚ
CS¬­ÖLœBšdE�ë(µ–‚˜E+d�§I|S9¼.Ú�I=•FøäüÜÅ
³÷OAhEÀ
F|[giËYÅ€ï„�1ØÝ×€v
XÚ¥fc“Õ=o@̵.þ• €%SÈxP
{¹Xx›\BbK¸Ot¬·®½�ëpì¤ÃºëòÊÉÕˆq^GqíKeQ’úIñ&ÉU_Ì…HUÕÝ­Ê—
Q¨2Jò5öQ.]}DïñaTaN½õåt�ê²Nò¤Ú‚ÕE€ÃÕE xOyvÞ-™ºJTÑ¡ý<ä8}ÑÉ¢"¾N-gÊW(

----Fin des informations sur l'anomalie----

requête SQL:

PK����µ©T7û¦ˆ4ë�A­533;ôí�����leyenche.sql.­free.fr.sqlí=Ù–Û6²ïþ ½™>Gîiõâxœ“‡§3ãs½dìö=™'6EA§I‚áÒË|Í}ÍwäÇ.6Ùb
`t¢ÏɸE©­ª  …ÂË—³b[|x¸XeI>ûòÏ÷³›¬xöòåì•U‚óÙÉÑ«£Ó—Eº _nëºxó—¿ÜÝÝ´ì!¢hG9ªé�ôÿ_Py‹šòÍ,E(�·è¨ú5=Z—‘(Àßÿ-ÿý·ò÷ß­ÄìÍìK”¡U2;9ž}Šk¼,ùxüÝì÷ÿ›�,Þ,N)ÆÿŠ†¬šYÕR??:>:;×~E³Ÿÿñ3ý­åäè¬mÍߢ Ñ_V8'/EÕ›ÙuÛ®kóöóåÅÕåìÇ‹«‹¿]|¹T~žýxùÓÅ×÷W³·ÿ¸ø|ñöêòóìËåÕ,�ê­$_ÌÞ~zÿž"òÇpƒrTFi'ß?ûJÈ´T¾FßòÒñϺA­Ë&®›’õ%�fu´$ƒw}�q­Q…ÑmTG%ïγ?úyFúòþröî§Ùå/ï¾\}1�¿o;Ý�}üt5:žÍf×ü!LV×­3Ê«†p¼^¿˜5y•lr´bø¿¾?‹š‡I—(Cy=W�×IJ†ô6*ãmT§Ç/f1NÉà¡þJr­+´Žš´ž=®’ʉÄHR‹cZY’¡ú¡˜ªi¤ã�Œ¡¡Ô‡?ÖVIU¤ÑÃõŒ¼è�! ë#Èw(ÙlëëY•EiJ‘Ï-�y¯ù:ôøçÏï>\|þ×ì.ÿ5›Šˆ¼ ¿ÒoõÚãÜìÿ‹g/f—ÿþîãåÞ}¹ø0»øzõ)|÷‘ˆê‡Ë�W?œŸhúH4ñ]è7½O­bê6ÄT…„+7`ÅTPà*ª Ù*«)Œ’=žÊ뎄*óŽrŸË¶<Ý—QN^`›�„0K€r-éíVÚ
CS¬­ÖLœBšdE�ë(µ–‚˜E+d�§I|S9¼.Ú�I=•FøäüÜÅ ³÷OAhEÀ
F|[giËYÅ€ï„�1ØÝ×€v XÚ¥fc“Õ=o@̵.þ• €%SÈxP {¹Xx›\BbK¸Ot¬·®½�ëpì¤ÃºëòÊÉÕˆq^GqíKeQ’úIñ&ÉU_Ì…HUÕÝ­Ê— Q¨2Jò5öQ.]}DïñaTaN½õåt�ê²Nò¤Ú‚ÕE€ÃÕE xOyvÞ-™ºJTÑ¡ý<ä8}ÑÉ¢"¾N-gÊW(

MySQL a répondu:Documentation

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

Il n'y a pas assez de place pour toute la requete. Bref, j'obtiens l'erreur suivante:

Erreur

requête SQL:

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

MySQL a répondu:Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
`avatar_name`

Personne ne peut m'aider ?