[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_admin/sql/core_sql.php,v $
  14  |     $Revision: 1.53 $
  15  |     $Date: 2006/11/27 08:48:57 $
  16  |     $Author: e107coders $
  17  +----------------------------------------------------------------------------+
  18  */
  19  header("location:../index.php");
  20  exit;
  21  ?>
  22  #
  23  # +---------------------------------------------------------------+
  24  # |        e107 website system
  25  # |        /files/sql.php
  26  # |
  27  # |        ?Steve Dunstan 2001-2002
  28  # |        http://e107.org
  29  # |        jalist@e107.org
  30  # |
  31  # |        Released under the terms and conditions of the
  32  # |        GNU General Public License (http://gnu.org).
  33  # +---------------------------------------------------------------+
  34  # Database : <variable>
  35  # --------------------------------------------------------
  36  
  37  #
  38  # Table structure for table `banlist`
  39  #
  40  
  41  CREATE TABLE banlist (
  42    banlist_ip varchar(100) NOT NULL default '',
  43    banlist_admin smallint(5) unsigned NOT NULL default '0',
  44    banlist_reason tinytext NOT NULL,
  45    PRIMARY KEY  (banlist_ip)
  46  ) TYPE=MyISAM;
  47  # --------------------------------------------------------
  48  
  49  #
  50  # Table structure for table `banner`
  51  #
  52  
  53  CREATE TABLE banner (
  54    banner_id int(10) unsigned NOT NULL auto_increment,
  55    banner_clientname varchar(100) NOT NULL default '',
  56    banner_clientlogin varchar(20) NOT NULL default '',
  57    banner_clientpassword varchar(50) NOT NULL default '',
  58    banner_image varchar(150) NOT NULL default '',
  59    banner_clickurl varchar(150) NOT NULL default '',
  60    banner_impurchased int(10) unsigned NOT NULL default '0',
  61    banner_startdate int(10) unsigned NOT NULL default '0',
  62    banner_enddate int(10) unsigned NOT NULL default '0',
  63    banner_active tinyint(3) unsigned NOT NULL default '0',
  64    banner_clicks int(10) unsigned NOT NULL default '0',
  65    banner_impressions int(10) unsigned NOT NULL default '0',
  66    banner_ip text NOT NULL,
  67    banner_campaign varchar(150) NOT NULL default '',
  68    PRIMARY KEY  (banner_id)
  69  ) TYPE=MyISAM;
  70  # --------------------------------------------------------
  71  
  72  #
  73  # Table structure for table `comments`
  74  #
  75  
  76  CREATE TABLE comments (
  77    comment_id int(10) unsigned NOT NULL auto_increment,
  78    comment_pid int(10) unsigned NOT NULL default '0',
  79    comment_item_id int(10) unsigned NOT NULL default '0',
  80    comment_subject varchar(100) NOT NULL default '',
  81    comment_author varchar(100) NOT NULL default '',
  82    comment_author_email varchar(200) NOT NULL default '',
  83    comment_datestamp int(10) unsigned NOT NULL default '0',
  84    comment_comment text NOT NULL,
  85    comment_blocked tinyint(3) unsigned NOT NULL default '0',
  86    comment_ip varchar(20) NOT NULL default '',
  87    comment_type varchar(10) NOT NULL default '0',
  88    comment_lock tinyint(1) unsigned NOT NULL default '0',
  89    PRIMARY KEY  (comment_id)
  90  ) TYPE=MyISAM;
  91  # --------------------------------------------------------
  92  
  93  #
  94  # Table structure for table `core`
  95  #
  96  CREATE TABLE core (
  97    e107_name varchar(100) NOT NULL default '',
  98    e107_value text NOT NULL,
  99    PRIMARY KEY  (e107_name)
 100  ) TYPE=MyISAM;
 101  # --------------------------------------------------------
 102  
 103  #
 104  # Table structure for table `dblog`
 105  #
 106  CREATE TABLE dblog (
 107    dblog_id int(10) unsigned NOT NULL auto_increment,
 108    dblog_type varchar(60) NOT NULL default '',
 109    dblog_datestamp int(10) unsigned NOT NULL default '0',
 110    dblog_user_id int(10) unsigned NOT NULL default '0',
 111    dblog_ip varchar(80) NOT NULL default '',
 112    dblog_title varchar(255) NOT NULL default '',
 113    dblog_remarks text NOT NULL,
 114    PRIMARY KEY  (dblog_id)
 115  ) TYPE=MyISAM;
 116  # --------------------------------------------------------
 117  
 118  #
 119  # Table structure for table `download`
 120  #
 121  
 122  CREATE TABLE download (
 123    download_id int(10) unsigned NOT NULL auto_increment,
 124    download_name varchar(100) NOT NULL default '',
 125    download_url varchar(150) NOT NULL default '',
 126    download_author varchar(100) NOT NULL default '',
 127    download_author_email varchar(200) NOT NULL default '',
 128    download_author_website varchar(200) NOT NULL default '',
 129    download_description text NOT NULL,
 130    download_filesize varchar(20) NOT NULL default '',
 131    download_requested int(10) unsigned NOT NULL default '0',
 132    download_category int(10) unsigned NOT NULL default '0',
 133    download_active tinyint(3) unsigned NOT NULL default '0',
 134    download_datestamp int(10) unsigned NOT NULL default '0',
 135    download_thumb varchar(150) NOT NULL default '',
 136    download_image varchar(150) NOT NULL default '',
 137    download_comment tinyint(3) unsigned NOT NULL default '0',
 138    download_class varchar(255) NOT NULL default '0',
 139    download_mirror text NOT NULL,
 140    download_mirror_type tinyint(1) unsigned NOT NULL default '0',
 141    download_visible varchar(255) NOT NULL default '0',
 142    PRIMARY KEY  (download_id),
 143    UNIQUE KEY download_name (download_name),
 144    KEY download_category (download_category)
 145  ) TYPE=MyISAM;
 146  # --------------------------------------------------------
 147  
 148  #
 149  # Table structure for table `download_category`
 150  #
 151  
 152  CREATE TABLE download_category (
 153    download_category_id int(10) unsigned NOT NULL auto_increment,
 154    download_category_name varchar(100) NOT NULL default '',
 155    download_category_description text NOT NULL,
 156    download_category_icon varchar(100) NOT NULL default '',
 157    download_category_parent int(10) unsigned NOT NULL default '0',
 158    download_category_class varchar(255) NOT NULL default '0',
 159    download_category_order int(10) unsigned NOT NULL default '0',
 160    PRIMARY KEY  (download_category_id)
 161  ) TYPE=MyISAM;
 162  # --------------------------------------------------------
 163  
 164  #
 165  # Table structure for table `download_mirror`
 166  #
 167  
 168  CREATE TABLE download_mirror (
 169    mirror_id int(10) unsigned NOT NULL auto_increment,
 170    mirror_name varchar(200) NOT NULL default '',
 171    mirror_url varchar(200) NOT NULL default '',
 172    mirror_image varchar(200) NOT NULL default '',
 173    mirror_location varchar(100) NOT NULL default '',
 174    mirror_description text NOT NULL,
 175    mirror_count int(10) unsigned NOT NULL default '0',
 176    PRIMARY KEY  (mirror_id)
 177  ) TYPE=MyISAM;
 178  # --------------------------------------------------------
 179  
 180  #
 181  # Table structure for table `download_requests`
 182  #
 183  CREATE TABLE download_requests (
 184    download_request_id int(10) unsigned NOT NULL auto_increment,
 185    download_request_userid int(10) unsigned NOT NULL default '0',
 186    download_request_ip varchar(30) NOT NULL default '',
 187    download_request_download_id int(10) unsigned NOT NULL default '0',
 188    download_request_datestamp int(10) unsigned NOT NULL default '0',
 189    PRIMARY KEY  (download_request_id),
 190    KEY download_request_userid (download_request_userid),
 191    KEY download_request_download_id (download_request_download_id)
 192  ) TYPE=MyISAM;
 193  # --------------------------------------------------------
 194  
 195  
 196  #
 197  # Table structure for table `flood`
 198  #
 199  
 200  CREATE TABLE flood (
 201    flood_url text NOT NULL,
 202    flood_time int(10) unsigned NOT NULL default '0'
 203  ) TYPE=MyISAM;
 204  # --------------------------------------------------------
 205  
 206  #
 207  # Table structure for table `headlines`
 208  #
 209  
 210  CREATE TABLE headlines (
 211    headline_id int(10) unsigned NOT NULL auto_increment,
 212    headline_url varchar(150) NOT NULL default '',
 213    headline_data text NOT NULL,
 214    headline_timestamp int(10) unsigned NOT NULL default '0',
 215    headline_description text NOT NULL,
 216    headline_image varchar(100) NOT NULL default '',
 217    headline_active tinyint(1) unsigned NOT NULL default '0',
 218    PRIMARY KEY  (headline_id)
 219  ) TYPE=MyISAM;
 220  
 221  # --------------------------------------------------------
 222  
 223  #
 224  # Table structure for table `links`
 225  #
 226  
 227  CREATE TABLE links (
 228    link_id int(10) unsigned NOT NULL auto_increment,
 229    link_name varchar(100) NOT NULL default '',
 230    link_url varchar(200) NOT NULL default '',
 231    link_description text NOT NULL,
 232    link_button varchar(100) NOT NULL default '',
 233    link_category tinyint(3) unsigned NOT NULL default '0',
 234    link_order int(10) unsigned NOT NULL default '0',
 235    link_parent int(10) unsigned NOT NULL default '0',
 236    link_open tinyint(1) unsigned NOT NULL default '0',
 237    link_class varchar(255) NOT NULL default '0',
 238    PRIMARY KEY  (link_id)
 239  ) TYPE=MyISAM;
 240  
 241  # --------------------------------------------------------
 242  
 243  #
 244  # Table structure for table `menus`
 245  #
 246  
 247  CREATE TABLE menus (
 248    menu_id int(10) unsigned NOT NULL auto_increment,
 249    menu_name varchar(100) NOT NULL default '',
 250    menu_location tinyint(3) unsigned NOT NULL default '0',
 251    menu_order tinyint(3) unsigned NOT NULL default '0',
 252    menu_class varchar(255) NOT NULL default '0',
 253    menu_pages text NOT NULL,
 254    menu_path varchar(100) NOT NULL default '',
 255    PRIMARY KEY  (menu_id)
 256  ) TYPE=MyISAM;
 257  # --------------------------------------------------------
 258  
 259  #
 260  # Table structure for table `news`
 261  #
 262  
 263  CREATE TABLE news (
 264    news_id int(10) unsigned NOT NULL auto_increment,
 265    news_title varchar(200) NOT NULL default '',
 266    news_body text NOT NULL,
 267    news_extended text NOT NULL,
 268    news_datestamp int(10) unsigned NOT NULL default '0',
 269    news_author int(10) unsigned NOT NULL default '0',
 270    news_category tinyint(3) unsigned NOT NULL default '0',
 271    news_allow_comments tinyint(3) unsigned NOT NULL default '0',
 272    news_start int(10) unsigned NOT NULL default '0',
 273    news_end int(10) unsigned NOT NULL default '0',
 274    news_class varchar(255) NOT NULL default '0',
 275    news_render_type tinyint(3) unsigned NOT NULL default '0',
 276    news_comment_total int(10) unsigned NOT NULL default '0',
 277    news_summary text NOT NULL,
 278    news_thumbnail text NOT NULL,
 279    news_sticky tinyint(3) unsigned NOT NULL default '0',
 280    PRIMARY KEY  (news_id)
 281  ) TYPE=MyISAM;
 282  
 283  
 284  
 285  
 286  
 287  # --------------------------------------------------------
 288  
 289  #
 290  # Table structure for table `news_category`
 291  #
 292  
 293  CREATE TABLE news_category (
 294    category_id int(10) unsigned NOT NULL auto_increment,
 295    category_name varchar(200) NOT NULL default '',
 296    category_icon varchar(250) NOT NULL default '',
 297    PRIMARY KEY  (category_id)
 298  ) TYPE=MyISAM;
 299  # --------------------------------------------------------
 300  
 301  #
 302  # Table structure for table `online`
 303  #
 304  
 305  CREATE TABLE online (
 306    online_timestamp int(10) unsigned NOT NULL default '0',
 307    online_flag tinyint(3) unsigned NOT NULL default '0',
 308    online_user_id varchar(100) NOT NULL default '',
 309    online_ip varchar(15) NOT NULL default '',
 310    online_location varchar(100) NOT NULL default '',
 311    online_pagecount tinyint(3) unsigned NOT NULL default '0',
 312    online_active int(10) unsigned NOT NULL default '0'
 313  ) TYPE=MyISAM;
 314  # --------------------------------------------------------
 315  
 316  #
 317  # Table structure for table `page`
 318  #
 319  
 320  CREATE TABLE page (
 321    page_id int(10) unsigned NOT NULL auto_increment,
 322    page_title varchar(250) NOT NULL default '',
 323    page_text mediumtext NOT NULL,
 324    page_author int(10) unsigned NOT NULL default '0',
 325    page_datestamp int(10) unsigned NOT NULL default '0',
 326    page_rating_flag tinyint(1) unsigned NOT NULL default '0',
 327    page_comment_flag tinyint(1) unsigned NOT NULL default '0',
 328    page_password varchar(50) NOT NULL default '',
 329    page_class varchar(250) NOT NULL default '',
 330    page_ip_restrict text NOT NULL,
 331    page_theme varchar(50) NOT NULL default '',
 332    PRIMARY KEY  (page_id)
 333  ) TYPE=MyISAM;
 334  # --------------------------------------------------------
 335  
 336  #
 337  # Table structure for table `plugin`
 338  #
 339  
 340  CREATE TABLE plugin (
 341    plugin_id int(10) unsigned NOT NULL auto_increment,
 342    plugin_name varchar(100) NOT NULL default '',
 343    plugin_version varchar(10) NOT NULL default '',
 344    plugin_path varchar(100) NOT NULL default '',
 345    plugin_installflag tinyint(1) unsigned NOT NULL default '0',
 346    plugin_addons text NOT NULL,
 347    PRIMARY KEY  (plugin_id),
 348    UNIQUE KEY plugin_path (plugin_path)
 349  ) TYPE=MyISAM;
 350  
 351  # --------------------------------------------------------
 352  
 353  #
 354  # Table structure for table `rate`
 355  #
 356  
 357  CREATE TABLE preset (
 358    preset_id int(10) unsigned NOT NULL auto_increment,
 359    preset_name varchar(80) NOT NULL default '',
 360    preset_field varchar(80) NOT NULL default '',
 361    preset_value varchar(255) NOT NULL default '',
 362    PRIMARY KEY  (preset_id)
 363  ) TYPE=MyISAM;
 364  
 365  # --------------------------------------------------------
 366  
 367  #
 368  # Table structure for table `rate`
 369  #
 370  
 371  CREATE TABLE rate (
 372    rate_id int(10) unsigned NOT NULL auto_increment,
 373    rate_table varchar(100) NOT NULL default '',
 374    rate_itemid int(10) unsigned NOT NULL default '0',
 375    rate_rating int(10) unsigned NOT NULL default '0',
 376    rate_votes int(10) unsigned NOT NULL default '0',
 377    rate_voters text NOT NULL,
 378    PRIMARY KEY  (rate_id)
 379  ) TYPE=MyISAM;
 380  # --------------------------------------------------------
 381  
 382  #
 383  # Table structure for table `rbinary`
 384  #
 385  
 386  CREATE TABLE rbinary (
 387    binary_id int(10) unsigned NOT NULL auto_increment,
 388    binary_name varchar(200) NOT NULL default '',
 389    binary_filetype varchar(100) NOT NULL default '',
 390    binary_data longblob NOT NULL,
 391    PRIMARY KEY  (binary_id)
 392  ) TYPE=MyISAM;
 393  # --------------------------------------------------------
 394  
 395  #
 396  # Table structure for table `session`
 397  #
 398  
 399  CREATE TABLE session (
 400    session_id varchar(32) NOT NULL default '',
 401    session_expire int(10) unsigned NOT NULL default '0',
 402    session_datestamp int(10) unsigned NOT NULL default '0',
 403    session_ip varchar(200) NOT NULL default '',
 404    session_data text NOT NULL
 405  ) TYPE=MyISAM;
 406  
 407  # --------------------------------------------------------
 408  
 409  #
 410  # Table structure for table `submitnews`
 411  #
 412  
 413  CREATE TABLE submitnews (
 414    submitnews_id int(10) unsigned NOT NULL auto_increment,
 415    submitnews_name varchar(100) NOT NULL default '',
 416    submitnews_email varchar(100) NOT NULL default '',
 417    submitnews_title varchar(200) NOT NULL default '',
 418    submitnews_category tinyint(3) unsigned NOT NULL default '0',
 419    submitnews_item text NOT NULL,
 420    submitnews_datestamp int(10) unsigned NOT NULL default '0',
 421    submitnews_ip varchar(15) NOT NULL default '',
 422    submitnews_auth tinyint(3) unsigned NOT NULL default '0',
 423    submitnews_file varchar(100) NOT NULL default '',
 424    PRIMARY KEY  (submitnews_id)
 425  ) TYPE=MyISAM;
 426  # --------------------------------------------------------
 427  
 428  #
 429  # Table structure for table `tmp`
 430  #
 431  
 432  CREATE TABLE tmp (
 433    tmp_ip varchar(20) NOT NULL default '',
 434    tmp_time int(10) unsigned NOT NULL default '0',
 435    tmp_info text NOT NULL,
 436    KEY tmp_ip (tmp_ip)
 437  ) TYPE=MyISAM;
 438  # --------------------------------------------------------
 439  
 440  #
 441  # Table structure for table `upload`
 442  #
 443  
 444  CREATE TABLE upload (
 445    upload_id int(10) unsigned NOT NULL auto_increment,
 446    upload_poster varchar(100) NOT NULL default '',
 447    upload_email varchar(100) NOT NULL default '',
 448    upload_website varchar(100) NOT NULL default '',
 449    upload_datestamp int(10) unsigned NOT NULL default '0',
 450    upload_name varchar(100) NOT NULL default '',
 451    upload_version varchar(10) NOT NULL default '',
 452    upload_file varchar(100) NOT NULL default '',
 453    upload_ss varchar(100) NOT NULL default '',
 454    upload_description text NOT NULL,
 455    upload_demo varchar(100) NOT NULL default '',
 456    upload_filesize int(10) unsigned NOT NULL default '0',
 457    upload_active tinyint(3) unsigned NOT NULL default '0',
 458    upload_category tinyint(3) unsigned NOT NULL default '0',
 459    PRIMARY KEY  (upload_id),
 460    KEY upload_active (upload_active)
 461  ) TYPE=MyISAM;
 462  
 463  # --------------------------------------------------------
 464  
 465  #
 466  # Table structure for table `user`
 467  #
 468  
 469  CREATE TABLE user (
 470    user_id int(10) unsigned NOT NULL auto_increment,
 471    user_name varchar(100) NOT NULL default '',
 472    user_loginname varchar(100) NOT NULL default '',
 473    user_customtitle varchar(100) NOT NULL default '',
 474    user_password varchar(32) NOT NULL default '',
 475    user_sess varchar(100) NOT NULL default '',
 476    user_email varchar(100) NOT NULL default '',
 477    user_signature text NOT NULL,
 478    user_image varchar(100) NOT NULL default '',
 479    user_timezone varchar(3) NOT NULL default '',
 480    user_hideemail tinyint(3) unsigned NOT NULL default '0',
 481    user_join int(10) unsigned NOT NULL default '0',
 482    user_lastvisit int(10) unsigned NOT NULL default '0',
 483    user_currentvisit int(10) unsigned NOT NULL default '0',
 484    user_lastpost int(10) unsigned NOT NULL default '0',
 485    user_chats int(10) unsigned NOT NULL default '0',
 486    user_comments int(10) unsigned NOT NULL default '0',
 487    user_forums int(10) unsigned NOT NULL default '0',
 488    user_ip varchar(20) NOT NULL default '',
 489    user_ban tinyint(3) unsigned NOT NULL default '0',
 490    user_prefs text NOT NULL,
 491    user_new text NOT NULL,
 492    user_viewed text NOT NULL,
 493    user_visits int(10) unsigned NOT NULL default '0',
 494    user_admin tinyint(3) unsigned NOT NULL default '0',
 495    user_login varchar(100) NOT NULL default '',
 496    user_class text NOT NULL,
 497    user_perms text NOT NULL,
 498    user_realm text NOT NULL,
 499    user_pwchange int(10) unsigned NOT NULL default '0',
 500    user_xup varchar(100) NOT NULL default '',
 501    PRIMARY KEY  (user_id),
 502    UNIQUE KEY user_name (user_name),
 503    KEY user_ban_index (user_ban)
 504  ) TYPE=MyISAM;
 505  # --------------------------------------------------------
 506  
 507  #
 508  # Table structure for table `userclass_classes`
 509  #
 510  CREATE TABLE userclass_classes (
 511    userclass_id tinyint(3) unsigned NOT NULL default '0',
 512    userclass_name varchar(100) NOT NULL default '',
 513    userclass_description varchar(250) NOT NULL default '',
 514    userclass_editclass tinyint(3) unsigned NOT NULL default '0',
 515    PRIMARY KEY  (userclass_id)
 516  ) TYPE=MyISAM;
 517  # --------------------------------------------------------
 518  
 519  #
 520  # Table structure for table `e107_user_extended`
 521  #
 522  
 523  CREATE TABLE user_extended (
 524    user_extended_id int(10) unsigned NOT NULL default '0',
 525    user_hidden_fields text NOT NULL,
 526    PRIMARY KEY  (user_extended_id)
 527  ) TYPE=MyISAM;
 528  # --------------------------------------------------------
 529  
 530  
 531  #
 532  # Table structure for table `e107_user_extended_struct`
 533  #
 534  
 535  CREATE TABLE user_extended_struct (
 536    user_extended_struct_id int(10) unsigned NOT NULL auto_increment,
 537    user_extended_struct_name varchar(255) NOT NULL default '',
 538    user_extended_struct_text varchar(255) NOT NULL default '',
 539    user_extended_struct_type tinyint(3) unsigned NOT NULL default '0',
 540    user_extended_struct_parms varchar(255) NOT NULL default '',
 541    user_extended_struct_values text NOT NULL,
 542    user_extended_struct_default varchar(255) NOT NULL default '',
 543    user_extended_struct_read tinyint(3) unsigned NOT NULL default '0',
 544    user_extended_struct_write tinyint(3) unsigned NOT NULL default '0',
 545    user_extended_struct_required tinyint(3) unsigned NOT NULL default '0',
 546    user_extended_struct_signup tinyint(3) unsigned NOT NULL default '0',
 547    user_extended_struct_applicable tinyint(3) unsigned NOT NULL default '0',
 548    user_extended_struct_order int(10) unsigned NOT NULL default '0',
 549    user_extended_struct_parent int(10) unsigned NOT NULL default '0',
 550    PRIMARY KEY  (user_extended_struct_id)
 551  ) TYPE=MyISAM;
 552  # --------------------------------------------------------
 553  
 554  
 555  #
 556  # Table structure for table `generic`
 557  #
 558  CREATE TABLE generic (
 559    gen_id int(10) unsigned NOT NULL auto_increment,
 560    gen_type varchar(80) NOT NULL default '',
 561    gen_datestamp int(10) unsigned NOT NULL default '0',
 562    gen_user_id int(10) unsigned NOT NULL default '0',
 563    gen_ip varchar(80) NOT NULL default '',
 564    gen_intdata int(10) unsigned NOT NULL default '0',
 565    gen_chardata text NOT NULL,
 566    PRIMARY KEY  (gen_id),
 567    KEY gen_type (gen_type)
 568  ) TYPE=MyISAM;
 569  # --------------------------------------------------------