|
|
|
|
Posté par
otherwise01, le vendredi 19 octobre 2007 à 21:46:53Configuration: Windows Vista Firefox 2.0.0.8
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 comprennent 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/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ë�A533;ôí�����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ë�A533;ôí�����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 |
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 ?
|