[Sommaire] [Imprimer]

   1  # phpMyAdmin MySQL-Dump

   2  # version 2.3.2

   3  # http://www.phpmyadmin.net/ (download page)

   4  #

   5  # Host: localhost

   6  # Generation Time: Jan 09, 2003 at 12:35 AM

   7  # Server version: 3.23.54

   8  # PHP Version: 4.2.2

   9  # Database : `xoops2`

  10  # --------------------------------------------------------

  11  
  12  #

  13  # Table structure for table `avatar`

  14  #

  15  
  16  CREATE TABLE avatar (
  17    avatar_id mediumint(8) unsigned NOT NULL auto_increment,
  18    avatar_file varchar(30) NOT NULL default '',
  19    avatar_name varchar(100) NOT NULL default '',
  20    avatar_mimetype varchar(30) NOT NULL default '',
  21    avatar_created int(10) NOT NULL default '0',
  22    avatar_display tinyint(1) unsigned NOT NULL default '0',
  23    avatar_weight smallint(5) unsigned NOT NULL default '0',
  24    avatar_type char(1) NOT NULL default '',
  25    PRIMARY KEY  (avatar_id),
  26    KEY avatar_type (avatar_type,avatar_display)
  27  ) TYPE=MyISAM;
  28  # --------------------------------------------------------

  29  
  30  #

  31  # Table structure for table `avatar_user_link`

  32  #

  33  
  34  CREATE TABLE avatar_user_link (
  35    avatar_id mediumint(8) unsigned NOT NULL default '0',
  36    user_id mediumint(8) unsigned NOT NULL default '0',
  37    KEY avatar_user_id (avatar_id,user_id)
  38  ) TYPE=MyISAM;
  39  # --------------------------------------------------------

  40  
  41  #

  42  # Table structure for table `banner`

  43  #

  44  
  45  CREATE TABLE banner (
  46    bid smallint(5) unsigned NOT NULL auto_increment,
  47    cid tinyint(3) unsigned NOT NULL default '0',
  48    imptotal mediumint(8) unsigned NOT NULL default '0',
  49    impmade mediumint(8) unsigned NOT NULL default '0',
  50    clicks mediumint(8) unsigned NOT NULL default '0',
  51    imageurl varchar(255) NOT NULL default '',
  52    clickurl varchar(255) NOT NULL default '',
  53    date int(10) NOT NULL default '0',
  54    htmlbanner tinyint(1) NOT NULL default '0',
  55    htmlcode text NOT NULL,
  56    PRIMARY KEY  (bid),
  57    KEY idxbannercid (cid),
  58    KEY idxbannerbidcid (bid,cid)
  59  ) TYPE=MyISAM;
  60  # --------------------------------------------------------

  61  
  62  #

  63  # Table structure for table `bannerclient`

  64  #

  65  
  66  CREATE TABLE bannerclient (
  67    cid smallint(5) unsigned NOT NULL auto_increment,
  68    name varchar(60) NOT NULL default '',
  69    contact varchar(60) NOT NULL default '',
  70    email varchar(60) NOT NULL default '',
  71    login varchar(10) NOT NULL default '',
  72    passwd varchar(10) NOT NULL default '',
  73    extrainfo text NOT NULL,
  74    PRIMARY KEY  (cid),
  75    KEY login (login)
  76  ) TYPE=MyISAM;
  77  # --------------------------------------------------------

  78  
  79  #

  80  # Table structure for table `bannerfinish`

  81  #

  82  
  83  CREATE TABLE bannerfinish (
  84    bid smallint(5) unsigned NOT NULL auto_increment,
  85    cid smallint(5) unsigned NOT NULL default '0',
  86    impressions mediumint(8) unsigned NOT NULL default '0',
  87    clicks mediumint(8) unsigned NOT NULL default '0',
  88    datestart int(10) unsigned NOT NULL default '0',
  89    dateend int(10) unsigned NOT NULL default '0',
  90    PRIMARY KEY  (bid),
  91    KEY cid (cid)
  92  ) TYPE=MyISAM;
  93  # --------------------------------------------------------

  94  
  95  #

  96  # Table structure for table `block_module_link`

  97  #

  98  
  99  CREATE TABLE block_module_link (
 100    block_id mediumint(8) unsigned NOT NULL default '0',
 101    module_id smallint(5) NOT NULL default '0',
 102    KEY module_id (module_id),
 103    KEY block_id (block_id)
 104  ) TYPE=MyISAM;
 105  # --------------------------------------------------------

 106  
 107  #

 108  # Table structure for table `comments`

 109  #

 110  
 111  CREATE TABLE xoopscomments (
 112    com_id mediumint(8) unsigned NOT NULL auto_increment,
 113    com_pid mediumint(8) unsigned NOT NULL default '0',
 114    com_rootid mediumint(8) unsigned NOT NULL default '0',
 115    com_modid smallint(5) unsigned NOT NULL default '0',
 116    com_itemid mediumint(8) unsigned NOT NULL default '0',
 117    com_icon varchar(25) NOT NULL default '',
 118    com_created int(10) unsigned NOT NULL default '0',
 119    com_modified int(10) unsigned NOT NULL default '0',
 120    com_uid mediumint(8) unsigned NOT NULL default '0',
 121    com_ip varchar(15) NOT NULL default '',
 122    com_title varchar(255) NOT NULL default '',
 123    com_text text NOT NULL,
 124    com_sig tinyint(1) unsigned NOT NULL default '0',
 125    com_status tinyint(1) unsigned NOT NULL default '0',
 126    com_exparams varchar(255) NOT NULL default '',
 127    dohtml tinyint(1) unsigned NOT NULL default '0',
 128    dosmiley tinyint(1) unsigned NOT NULL default '0',
 129    doxcode tinyint(1) unsigned NOT NULL default '0',
 130    doimage tinyint(1) unsigned NOT NULL default '0',
 131    dobr tinyint(1) unsigned NOT NULL default '0',
 132    PRIMARY KEY  (com_id),
 133    KEY com_pid (com_pid),
 134    KEY com_itemid (com_itemid),
 135    KEY com_uid (com_uid),
 136    KEY com_title (com_title(40))
 137  ) TYPE=MyISAM;
 138  # --------------------------------------------------------

 139  
 140  # RMV-NOTIFY

 141  # Table structure for table `notifications`

 142  #

 143  
 144  CREATE TABLE xoopsnotifications (
 145    not_id mediumint(8) unsigned NOT NULL auto_increment,
 146    not_modid smallint(5) unsigned NOT NULL default '0',
 147    not_itemid mediumint(8) unsigned NOT NULL default '0',
 148    not_category varchar(30) NOT NULL default '',
 149    not_event varchar(30) NOT NULL default '',
 150    not_uid mediumint(8) unsigned NOT NULL default '0',
 151    not_mode tinyint(1) NOT NULL default 0,
 152    PRIMARY KEY (not_id),
 153    KEY not_modid (not_modid),
 154    KEY not_itemid (not_itemid),
 155    KEY not_class (not_category),
 156    KEY not_uid (not_uid),
 157    KEY not_event (not_event)
 158  ) TYPE=MyISAM;
 159  # --------------------------------------------------------

 160  
 161  #

 162  # Table structure for table `config`

 163  #

 164  
 165  CREATE TABLE config (
 166    conf_id smallint(5) unsigned NOT NULL auto_increment,
 167    conf_modid smallint(5) unsigned NOT NULL default '0',
 168    conf_catid smallint(5) unsigned NOT NULL default '0',
 169    conf_name varchar(25) NOT NULL default '',
 170    conf_title varchar(30) NOT NULL default '',
 171    conf_value text NOT NULL,
 172    conf_desc varchar(30) NOT NULL default '',
 173    conf_formtype varchar(15) NOT NULL default '',
 174    conf_valuetype varchar(10) NOT NULL default '',
 175    conf_order smallint(5) unsigned NOT NULL default '0',
 176    PRIMARY KEY  (conf_id),
 177    KEY conf_mod_cat_id (conf_modid,conf_catid)
 178  ) TYPE=MyISAM;
 179  # --------------------------------------------------------

 180  
 181  #

 182  # Table structure for table `configcategory`

 183  #

 184  
 185  CREATE TABLE configcategory (
 186    confcat_id smallint(5) unsigned NOT NULL auto_increment,
 187    confcat_name varchar(25) NOT NULL default '',
 188    confcat_order smallint(5) unsigned NOT NULL default '0',
 189    PRIMARY KEY  (confcat_id)
 190  ) TYPE=MyISAM;
 191  # --------------------------------------------------------

 192  
 193  #

 194  # Table structure for table `configoption`

 195  #

 196  
 197  CREATE TABLE configoption (
 198    confop_id mediumint(8) unsigned NOT NULL auto_increment,
 199    confop_name varchar(255) NOT NULL default '',
 200    confop_value varchar(255) NOT NULL default '',
 201    conf_id smallint(5) unsigned NOT NULL default '0',
 202    PRIMARY KEY  (confop_id),
 203    KEY conf_id (conf_id)
 204  ) TYPE=MyISAM;
 205  # --------------------------------------------------------

 206  
 207  #

 208  # Table structure for table `groups`

 209  #

 210  
 211  CREATE TABLE groups (
 212    groupid smallint(5) unsigned NOT NULL auto_increment,
 213    name varchar(50) NOT NULL default '',
 214    description text NOT NULL,
 215    group_type varchar(10) NOT NULL default '',
 216    PRIMARY KEY  (groupid),
 217    KEY group_type (group_type)
 218  ) TYPE=MyISAM;
 219  # --------------------------------------------------------

 220  
 221  #

 222  # Table structure for table `group_permission`

 223  #

 224  
 225  CREATE TABLE group_permission (
 226    gperm_id int(10) unsigned NOT NULL auto_increment,
 227    gperm_groupid smallint(5) unsigned NOT NULL default '0',
 228    gperm_itemid mediumint(8) unsigned NOT NULL default '0',
 229    gperm_modid mediumint(5) unsigned NOT NULL default '0',
 230    gperm_name varchar(50) NOT NULL default '',
 231    PRIMARY KEY  (gperm_id),
 232    KEY groupid (gperm_groupid),
 233    KEY itemid (gperm_itemid),
 234    KEY gperm_modid (gperm_modid,gperm_name(10))
 235  ) TYPE=MyISAM;
 236  # --------------------------------------------------------

 237  
 238  
 239  #

 240  # Table structure for table `groups_users_link`

 241  #

 242  
 243  CREATE TABLE groups_users_link (
 244    linkid mediumint(8) unsigned NOT NULL auto_increment,
 245    groupid smallint(5) unsigned NOT NULL default '0',
 246    uid mediumint(8) unsigned NOT NULL default '0',
 247    PRIMARY KEY  (linkid),
 248    KEY groupid_uid (groupid,uid)
 249  ) TYPE=MyISAM;
 250  # --------------------------------------------------------

 251  
 252  #

 253  # Table structure for table `image`

 254  #

 255  
 256  CREATE TABLE image (
 257    image_id mediumint(8) unsigned NOT NULL auto_increment,
 258    image_name varchar(30) NOT NULL default '',
 259    image_nicename varchar(255) NOT NULL default '',
 260    image_mimetype varchar(30) NOT NULL default '',
 261    image_created int(10) unsigned NOT NULL default '0',
 262    image_display tinyint(1) unsigned NOT NULL default '0',
 263    image_weight smallint(5) unsigned NOT NULL default '0',
 264    imgcat_id smallint(5) unsigned NOT NULL default '0',
 265    PRIMARY KEY  (image_id),
 266    KEY imgcat_id (imgcat_id),
 267    KEY image_display (image_display)
 268  ) TYPE=MyISAM;
 269  # --------------------------------------------------------

 270  
 271  #

 272  # Table structure for table `imagebody`

 273  #

 274  
 275  CREATE TABLE imagebody (
 276    image_id mediumint(8) unsigned NOT NULL default '0',
 277    image_body mediumblob,
 278    KEY image_id (image_id)
 279  ) TYPE=MyISAM;
 280  # --------------------------------------------------------

 281  
 282  #

 283  # Table structure for table `imagecategory`

 284  #

 285  
 286  CREATE TABLE imagecategory (
 287    imgcat_id smallint(5) unsigned NOT NULL auto_increment,
 288    imgcat_name varchar(100) NOT NULL default '',
 289    imgcat_maxsize int(8) unsigned NOT NULL default '0',
 290    imgcat_maxwidth smallint(3) unsigned NOT NULL default '0',
 291    imgcat_maxheight smallint(3) unsigned NOT NULL default '0',
 292    imgcat_display tinyint(1) unsigned NOT NULL default '0',
 293    imgcat_weight smallint(3) unsigned NOT NULL default '0',
 294    imgcat_type char(1) NOT NULL default '',
 295    imgcat_storetype varchar(5) NOT NULL default '',
 296    PRIMARY KEY  (imgcat_id),
 297    KEY imgcat_display (imgcat_display)
 298  ) TYPE=MyISAM;
 299  # --------------------------------------------------------

 300  
 301  
 302  #

 303  # Table structure for table `imgset`

 304  #

 305  
 306  CREATE TABLE imgset (
 307    imgset_id smallint(5) unsigned NOT NULL auto_increment,
 308    imgset_name varchar(50) NOT NULL default '',
 309    imgset_refid mediumint(8) unsigned NOT NULL default '0',
 310    PRIMARY KEY  (imgset_id),
 311    KEY imgset_refid (imgset_refid)
 312  ) TYPE=MyISAM;
 313  # --------------------------------------------------------

 314  
 315  #

 316  # Table structure for table `imgset_tplset_link`

 317  #

 318  
 319  CREATE TABLE imgset_tplset_link (
 320    imgset_id smallint(5) unsigned NOT NULL default '0',
 321    tplset_name varchar(50) NOT NULL default '',
 322    KEY tplset_name (tplset_name(10))
 323  ) TYPE=MyISAM;
 324  # --------------------------------------------------------

 325  
 326  #

 327  # Table structure for table `imgsetimg`

 328  #

 329  
 330  CREATE TABLE imgsetimg (
 331    imgsetimg_id mediumint(8) unsigned NOT NULL auto_increment,
 332    imgsetimg_file varchar(50) NOT NULL default '',
 333    imgsetimg_body blob NOT NULL,
 334    imgsetimg_imgset smallint(5) unsigned NOT NULL default '0',
 335    PRIMARY KEY  (imgsetimg_id),
 336    KEY imgsetimg_imgset (imgsetimg_imgset)
 337  ) TYPE=MyISAM;
 338  # --------------------------------------------------------

 339  
 340  #

 341  # Table structure for table `modules`

 342  #

 343  
 344  CREATE TABLE modules (
 345    mid smallint(5) unsigned NOT NULL auto_increment,
 346    name varchar(150) NOT NULL default '',
 347    version smallint(5) unsigned NOT NULL default '100',
 348    last_update int(10) unsigned NOT NULL default '0',
 349    weight smallint(3) unsigned NOT NULL default '0',
 350    isactive tinyint(1) unsigned NOT NULL default '0',
 351    dirname varchar(25) NOT NULL default '',
 352    hasmain tinyint(1) unsigned NOT NULL default '0',
 353    hasadmin tinyint(1) unsigned NOT NULL default '0',
 354    hassearch tinyint(1) unsigned NOT NULL default '0',
 355    hasconfig tinyint(1) unsigned NOT NULL default '0',
 356    hascomments tinyint(1) unsigned NOT NULL default '0',
 357    hasnotification tinyint(1) unsigned NOT NULL default '0',
 358    PRIMARY KEY  (mid),
 359    KEY hasmain (hasmain),
 360    KEY hasadmin (hasadmin),
 361    KEY hassearch (hassearch),
 362    KEY hasnotification (hasnotification),
 363    KEY dirname (dirname),
 364    KEY name (name(15))
 365  ) TYPE=MyISAM;
 366  # --------------------------------------------------------

 367  
 368  #

 369  # Table structure for table `newblocks`

 370  #

 371  
 372  CREATE TABLE newblocks (
 373    bid mediumint(8) unsigned NOT NULL auto_increment,
 374    mid smallint(5) unsigned NOT NULL default '0',
 375    func_num tinyint(3) unsigned NOT NULL default '0',
 376    options varchar(255) NOT NULL default '',
 377    name varchar(150) NOT NULL default '',
 378    title varchar(255) NOT NULL default '',
 379    content text NOT NULL,
 380    side tinyint(1) unsigned NOT NULL default '0',
 381    weight smallint(5) unsigned NOT NULL default '0',
 382    visible tinyint(1) unsigned NOT NULL default '0',
 383    block_type char(1) NOT NULL default '',
 384    c_type char(1) NOT NULL default '',
 385    isactive tinyint(1) unsigned NOT NULL default '0',
 386    dirname varchar(50) NOT NULL default '',
 387    func_file varchar(50) NOT NULL default '',
 388    show_func varchar(50) NOT NULL default '',
 389    edit_func varchar(50) NOT NULL default '',
 390    template varchar(50) NOT NULL default '',
 391    bcachetime int(10) unsigned NOT NULL default '0',
 392    last_modified int(10) unsigned NOT NULL default '0',
 393    PRIMARY KEY  (bid),
 394    KEY mid (mid),
 395    KEY visible (visible),
 396    KEY isactive_visible_mid (isactive,visible,mid),
 397    KEY mid_funcnum (mid,func_num)
 398  ) TYPE=MyISAM;
 399  # --------------------------------------------------------

 400  
 401  #

 402  # Table structure for table `online`

 403  #

 404  
 405  CREATE TABLE online (
 406    online_uid mediumint(8) unsigned NOT NULL default '0',
 407    online_uname varchar(25) NOT NULL default '',
 408    online_updated int(10) unsigned NOT NULL default '0',
 409    online_module smallint(5) unsigned NOT NULL default '0',
 410    online_ip varchar(15) NOT NULL default '',
 411    KEY online_module (online_module)
 412  ) TYPE=MyISAM;
 413  # --------------------------------------------------------

 414  
 415  #

 416  # Table structure for table `priv_msgs`

 417  #

 418  
 419  CREATE TABLE priv_msgs (
 420    msg_id mediumint(8) unsigned NOT NULL auto_increment,
 421    msg_image varchar(100) default NULL,
 422    subject varchar(255) NOT NULL default '',
 423    from_userid mediumint(8) unsigned NOT NULL default '0',
 424    to_userid mediumint(8) unsigned NOT NULL default '0',
 425    msg_time int(10) unsigned NOT NULL default '0',
 426    msg_text text NOT NULL,
 427    read_msg tinyint(1) unsigned NOT NULL default '0',
 428    PRIMARY KEY  (msg_id),
 429    KEY to_userid (to_userid),
 430    KEY touseridreadmsg (to_userid,read_msg),
 431    KEY msgidfromuserid (msg_id,from_userid)
 432  ) TYPE=MyISAM;
 433  # --------------------------------------------------------

 434  
 435  #

 436  # Table structure for table `ranks`

 437  #

 438  
 439  CREATE TABLE ranks (
 440    rank_id smallint(5) unsigned NOT NULL auto_increment,
 441    rank_title varchar(50) NOT NULL default '',
 442    rank_min mediumint(8) unsigned NOT NULL default '0',
 443    rank_max mediumint(8) unsigned NOT NULL default '0',
 444    rank_special tinyint(1) unsigned NOT NULL default '0',
 445    rank_image varchar(255) default NULL,
 446    PRIMARY KEY  (rank_id),
 447    KEY rank_min (rank_min),
 448    KEY rank_max (rank_max),
 449    KEY rankminrankmaxranspecial (rank_min,rank_max,rank_special),
 450    KEY rankspecial (rank_special)
 451  ) TYPE=MyISAM;
 452  # --------------------------------------------------------

 453  
 454  #

 455  # Table structure for table `session`

 456  #

 457  
 458  CREATE TABLE session (
 459    sess_id varchar(32) NOT NULL default '',
 460    sess_updated int(10) unsigned NOT NULL default '0',
 461    sess_ip varchar(15) NOT NULL default '',
 462    sess_data text NOT NULL,
 463    PRIMARY KEY  (sess_id),
 464    KEY updated (sess_updated)
 465  ) TYPE=MyISAM;
 466  # --------------------------------------------------------

 467  
 468  #

 469  # Table structure for table `smiles`

 470  #

 471  
 472  CREATE TABLE smiles (
 473    id smallint(5) unsigned NOT NULL auto_increment,
 474    code varchar(50) NOT NULL default '',
 475    smile_url varchar(100) NOT NULL default '',
 476    emotion varchar(75) NOT NULL default '',
 477    display tinyint(1) NOT NULL default '0',
 478    PRIMARY KEY  (id)
 479  ) TYPE=MyISAM;
 480  # --------------------------------------------------------

 481  
 482  #

 483  # Table structure for table `tplset`

 484  #

 485  
 486  CREATE TABLE tplset (
 487    tplset_id int(7) unsigned NOT NULL auto_increment,
 488    tplset_name varchar(50) NOT NULL default '',
 489    tplset_desc varchar(255) NOT NULL default '',
 490    tplset_credits text NOT NULL,
 491    tplset_created int(10) unsigned NOT NULL default '0',
 492    PRIMARY KEY  (tplset_id)
 493  ) TYPE=MyISAM;
 494  # --------------------------------------------------------

 495  
 496  #

 497  # Table structure for table `tplfile`

 498  #

 499  
 500  CREATE TABLE tplfile (
 501    tpl_id mediumint(7) unsigned NOT NULL auto_increment,
 502    tpl_refid smallint(5) unsigned NOT NULL default '0',
 503    tpl_module varchar(25) NOT NULL default '',
 504    tpl_tplset varchar(50) NOT NULL default '',
 505    tpl_file varchar(50) NOT NULL default '',
 506    tpl_desc varchar(255) NOT NULL default '',
 507    tpl_lastmodified int(10) unsigned NOT NULL default '0',
 508    tpl_lastimported int(10) unsigned NOT NULL default '0',
 509    tpl_type varchar(20) NOT NULL default '',
 510    PRIMARY KEY  (tpl_id),
 511    KEY tpl_refid (tpl_refid,tpl_type),
 512    KEY tpl_tplset (tpl_tplset,tpl_file(10))
 513  ) TYPE=MyISAM;
 514  # --------------------------------------------------------

 515  
 516  #

 517  # Table structure for table `tplsource`

 518  #

 519  
 520  CREATE TABLE tplsource (
 521    tpl_id mediumint(7) unsigned NOT NULL default '0',
 522    tpl_source mediumtext NOT NULL,
 523    KEY tpl_id (tpl_id)
 524  ) TYPE=MyISAM;
 525  # --------------------------------------------------------

 526  
 527  # RMV-NOTIFY (added two columns)

 528  # Table structure for table `users`

 529  #

 530  
 531  CREATE TABLE users (
 532    uid mediumint(8) unsigned NOT NULL auto_increment,
 533    name varchar(60) NOT NULL default '',
 534    uname varchar(25) NOT NULL default '',
 535    email varchar(60) NOT NULL default '',
 536    url varchar(100) NOT NULL default '',
 537    user_avatar varchar(30) NOT NULL default 'blank.gif',
 538    user_regdate int(10) unsigned NOT NULL default '0',
 539    user_icq varchar(15) NOT NULL default '',
 540    user_from varchar(100) NOT NULL default '',
 541    user_sig tinytext NOT NULL,
 542    user_viewemail tinyint(1) unsigned NOT NULL default '0',
 543    actkey varchar(8) NOT NULL default '',
 544    user_aim varchar(18) NOT NULL default '',
 545    user_yim varchar(25) NOT NULL default '',
 546    user_msnm varchar(100) NOT NULL default '',
 547    pass varchar(32) NOT NULL default '',
 548    posts mediumint(8) unsigned NOT NULL default '0',
 549    attachsig tinyint(1) unsigned NOT NULL default '0',
 550    rank smallint(5) unsigned NOT NULL default '0',
 551    level tinyint(3) unsigned NOT NULL default '1',
 552    theme varchar(100) NOT NULL default '',
 553    timezone_offset float(3,1) NOT NULL default '0.0',
 554    last_login int(10) unsigned NOT NULL default '0',
 555    umode varchar(10) NOT NULL default '',
 556    uorder tinyint(1) unsigned NOT NULL default '0',
 557    notify_method tinyint(1) NOT NULL default '1',
 558    notify_mode tinyint(1) NOT NULL default '0',
 559    user_occ varchar(100) NOT NULL default '',
 560    bio tinytext NOT NULL,
 561    user_intrest varchar(150) NOT NULL default '',
 562    user_mailok tinyint(1) unsigned NOT NULL default '1',
 563    PRIMARY KEY  (uid),
 564    KEY uname (uname),
 565    KEY email (email),
 566    KEY uiduname (uid,uname),
 567    KEY unamepass (uname,pass)
 568  ) TYPE=MyISAM;