Rechercher : dans
Par :

Importer/Exporter base de donnée

Dernière réponse le 13 déc 2007 à 15:58:28 otherwise01, le 19 oct 2007 à 21:46:53 
 Signaler ce message aux modérateurs

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

Configuration: Windows Vista
Firefox 2.0.0.8

Meilleures réponses pour « Importer/Exporter base de donnée » dans :
Importer et exporter des données sous MySQL Voir Importation et exportation Les Système de Gestion de Bases de Données tels que MySQL permettent de manipuler facilement et avec beaucoup de souplesse un très important volume de données. Toutefois, aussi robuste soit MySQL, il peut être intéressant...
Import / export de données Ingres VoirIngres permet d'exporter les données d'une installation Ingres vers une autre (quels que soient l'OS cible ou source) par les commandes : unloaddb copydb Ce qui change entre ces 2 commandes c'est leur périmètre : unloaddb concerne tous...
Exporter à coup sûr du CSV VoirExporter des données au format CSV n'est pas si trivial qu'il n'y paraît. Dès que vos données contiennent des virgules ou des guillemets, tout semble partir en vrille. Il y a une astuce. Voici comment procéder pour exporter à coup sûr vos...
Oracle - Optimiser les performances de l'Import/Export VoirOptimiser les performances de l’Import/Export Utiliser « commit=y » Adapter la taille du buffer au besoin « BUFFER=…. » Il est préférable de désactiver les triggers, les contraintes et supprimer les index avant l’import et les recréer après...
Administrateur de bases de données VoirAdministrateur de bases de données L'administrateur de bases de données (parfois appelé responsable de bases de données ou en anglais database administrator, noté DBA) est chargé du maintien et de l'évolution des bases de données constituant le...
Oracle - Introduction au SGBD Oracle VoirIntroduction au SGBD Oracle Oracle est un SGBD (système de gestion de bases de données) édité par la société du même nom (Oracle Corporation - http://www.oracle.com), leader mondial des bases de données. La société Oracle Corporation a été créée en...
Connexion à la base de données avec JDBC VoirConnexion à la base de données L'API (Application Programming Interface) JDBC, c'est-à-dire la bibliothèque de classes JDBC, se charge de trois étapes indispensables à la connexion à une base de données : la création d'une connexion à la...

1

otherwise01, le 19 oct 2007 à 22:22:16

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

Répondre à otherwise01

2

otherwise01, le 20 oct 2007 à 09:53:24

Personne ne peut m'aider... ?

Répondre à otherwise01

3

otherwise01, le 20 oct 2007 à 18:35:48

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

Merci

Répondre à otherwise01

4

PhP, le 20 oct 2007 à 19:40:08

Bsr

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

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

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



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

Répondre à PhP

5

otherwise01, le 20 oct 2007 à 21:17:59

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



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

ERROR: C1 C2 LEN: 2 3 999
STR: 

CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 4.0.27-standard-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.4-pl3
PHP VER,OS: 4.3.10-200.schlund.1 Linux
LANG: fr-iso-8859-1
SQL: PK����µ©T7û¦ˆ4ë��ôí�����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

Répondre à otherwise01

6

otherwise01, le 20 oct 2007 à 22:18:30

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

Répondre à otherwise01

7

otherwise01, le 20 oct 2007 à 22:21:20

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`

Répondre à otherwise01

8

otherwise01, le 22 oct 2007 à 11:35:29

Personne ne peut m'aider ?

Répondre à otherwise01

9

 lookouster, le 13 déc 2007 à 15:58:28

Salut.
en local, ca marche nespa.
Ya un prob de compatibilité avec la version de mysql de chez 2&2 lol. Vire les default charset='latin1' de ton code sql et ca ira à merveille j pense.

Répondre à lookouster