Importer/Exporter base de donnée Fermé

Question

Bonsoir,

Je n'arrive pas à importer/exporte une base de donnée.
La première est chez free, avec phpmyadmin version 2.6.3-pl1  et la seconde (dans laquelle je souhaite transférer les tables) est chez 1and1 et utilise la version 2.6.4 pl3 de phpmyadmin.

J'ai constamment des erreurs lorsque j'importe les tables que j'ai enregistré chez free...

Pouvez-vous m'aider ?
Merci

otherwise01 · Answer

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

otherwise01 · Answer

Personne ne peut m'aider... ?

otherwise01 · Answer

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

PhP · Answer

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 !!!)

otherwise01 · Answer

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/8ERQ4jpH7qSgBCmr2z1RAuVARsaBBmGm6zCibUdIs
nJulzt2lTXP+6VbOP+g8a8Sw0DblZoJ54t9MZeTOu3fvvXv37n0/792Do6NZ0SQwBAOGYEEGzCSB
WBAHEolEgMN11jcAQEgshwT60nkkMCtTJE6UZPElkEiYBIlTxcgzIBbCEUAsGo0PQAc7zZmSsFgS
BgOK+GlEEJaJQV/gsJwTxSCBgRAawgahsqSJ6bxECQ8lykgBYjjRIIuDBGlhMJOLBGNhp2acMB08
zDpKZzBoIB5CA+zDNCcVRIACUWIRDmCHsz/2IVmcjyNxEAaNcupDWcmpoux0HoQBGcL0bBnAoDHD
SKBAghJmZaCCg/FEFAZYxWBHbti4E4FAuCIePeAGffixMNDqiUDMTCAQzoAQ8eX89ORUPuRcFhJI
+Hyn+5hPUEw3XxEeTq4Arbf3JaaJySlSctg74ew/sjs3CryrcCNZrTzbHOX2fgJMc6+i5/79XK/o
U/adHe2ECO5bTEnrTkkrvPu7m+AH1a73PHYC+b/pNfVJxxSypiN8+trAD/b++Xofba1szm6xeZTG
5E6bugdqvn+hgZvvJaRbm2XTmvbXZvNutwbbnorUMGL1W/WMI4EtLyqz9yHhbX7qxrH7i3jKUY3r
dZXfk2GVA+VYbrTPD7s+s/XZIr/VxWDJxHLl5dMtSLf3siWzbd6h/Q45hGQe+N1x+VJtWbwhmkol
rcGQyMbzcP1dxxRu2TI6VpvWN1wBDCTEBu8PgA1aU/arutObpuemLR0Gi62zqKao/YTiMfd8+bLs
/YsO43xcfaOjaUExNTdun7bpLQZk8bhvQu/Q+XOO8n2Z2RlSsr1TfFHCDRV67h+mfojoauC2qUKH
7c+nVP3NtJ/0qwx12pLZvcWC7Abfi2eV6syo/IE0btjeyT/qfaiqRXnoon1FMveuymQJmGw7rsQg
2jPI5gvKJSl+K2lLeZ/AuLSHEWvE9dRcErd8erL9Fl5eKpI0JC34tLepqEVlXgV0b41fiJwSd81I
j7g0Q/AfSeNuquoMEGCY3W90K64RkoMNV8sayimqupKeb56FRxcl+xyNL9Et6m5VCytHNqqv7Nit
c9H9WUB9uT2WHlM58HT2SsvYhT0AYP2i66yfSWS1xpfCwojr/ahr8p/fbyfNLPzbP7l23OOKFaNN
BTnwWpfLhS332p9nzO5yGRx5bXMUpQQIND6OlXcjlm0+3kPKxwvoXxfOzR5QzF8vHC/Qq+Ood+6m
LoYHTm0+sUM1FtTKSlKNexKecfPzDgad6uCy3/hXgyb/mgOeV0oo5T3Wq3n+btNXJXf1v6xKi6Rk
8+YNmijmyc2ntIg8dGSOxAP11nUidnBdiBen9iXjziHPMh5cbPV7dHNj7i34IK94VxVdwSG2QIPX
6JTS0IXRpdcdQP08i5YKP1kXqjiWItTHd+RM5qkxu//yMhtzzgBHBn8QJN8wUDK+7H0Eea+Ugp/k
7OV0ydifAV8/PiLTHj+UpPKKbGJJXWob139e17r+glVsq3zabLX3dBsKM0+GZU5EbuJHlSy606dW
mbtjEnrzw91iDOYeDRB1Hxthx89FQSeUX02un0rkJjJbZy1S9fhDpr1yMNcA5zw1wKCMJT8zhLrd
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ë��ôí��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}qQ…Ñ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½Obê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ë��ôí��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}qQ…Ñ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½Obê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

otherwise01 · Answer

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

otherwise01 · Answer

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`

otherwise01 · Answer

Personne ne peut m'aider ?

Importer/Exporter base de donnée

8 réponses

Discussions similaires