[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_pg.php,v $
  14  |     $Revision: 1.5 $
  15  |     $Date: 2006/10/19 21:17:06 $
  16  |     $Author: mrpete $
  17  +----------------------------------------------------------------------------+
  18  */
  19  header("location:../index.php");
  20  exit;
  21  ?>
  22  
  23  CREATE SEQUENCE banner_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  24  CREATE SEQUENCE chatbox_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  25  CREATE SEQUENCE comments_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  26  CREATE SEQUENCE content_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  27  CREATE SEQUENCE download_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  28  CREATE SEQUENCE download_category_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  29  CREATE SEQUENCE forum_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  30  CREATE SEQUENCE forum_t_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  31  CREATE SEQUENCE headlines_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  32  CREATE SEQUENCE links_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  33  CREATE SEQUENCE menus_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  34  CREATE SEQUENCE news_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  35  CREATE SEQUENCE news_category_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  36  CREATE SEQUENCE plugin_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  37  CREATE SEQUENCE poll_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  38  CREATE SEQUENCE rate_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
  39  
  40  
  41  
  42  
  43  
  44  CREATE TABLE banlist (
  45    banlist_ip varchar(100) NOT NULL,
  46    banlist_admin int4 DEFAULT '0' NOT NULL,
  47    banlist_reason text NOT NULL,
  48    CONSTRAINT banlist_pkey PRIMARY KEY (banlist_ip)
  49  );
  50  
  51  CREATE TABLE banner (
  52    banner_id int4 NOT NULL,
  53    banner_clientname varchar(100) DEFAULT '' NOT NULL,
  54    banner_clientlogin varchar(20) DEFAULT '' NOT NULL,
  55    banner_clientpassword varchar(50) DEFAULT '' NOT NULL,
  56    banner_image varchar(150) DEFAULT '' NOT NULL,
  57    banner_clickurl varchar(150) DEFAULT '' NOT NULL,
  58    banner_impurchased int4 DEFAULT '0' NOT NULL,
  59    banner_startdate int4 DEFAULT '0' NOT NULL,
  60    banner_enddate int4 DEFAULT '0' NOT NULL,
  61    banner_active int2 DEFAULT '0' NOT NULL,
  62    banner_clicks int4 DEFAULT '0' NOT NULL,
  63    banner_impressions int4 DEFAULT '0' NOT NULL,
  64    banner_ip text NOT NULL,
  65    banner_campaign varchar(150) DEFAULT '' NOT NULL,
  66    CONSTRAINT banner_pkey PRIMARY KEY (banner_id)
  67  );
  68  
  69  CREATE TABLE chatbox (
  70    cb_id int4 NOT NULL,
  71    cb_nick varchar(30) DEFAULT '' NOT NULL,
  72    cb_message text NOT NULL,
  73    cb_datestamp int4 DEFAULT '0' NOT NULL,
  74    cb_blocked int2 DEFAULT '0' NOT NULL,
  75    cb_ip varchar(15) DEFAULT '' NOT NULL,
  76    CONSTRAINT chatbox_pkey PRIMARY KEY (cb_id)
  77  );
  78  
  79  CREATE TABLE comments (
  80    comment_id int4 DEFAULT '0' NOT NULL,
  81    comment_pid int4 DEFAULT '0' NOT NULL,
  82    comment_item_id int4 DEFAULT '0' NOT NULL,
  83    comment_subject varchar(100) DEFAULT '' NOT NULL,
  84    comment_author varchar(100) DEFAULT '' NOT NULL,
  85    comment_author_email varchar(200) DEFAULT '' NOT NULL,
  86    comment_datestamp int4 DEFAULT '0' NOT NULL,
  87    comment_comment text NOT NULL,
  88    comment_blocked int2 DEFAULT '0' NOT NULL,
  89    comment_ip varchar(20) DEFAULT '' NOT NULL,
  90    comment_type varchar(10) DEFAULT '' NOT NULL,
  91    CONSTRAINT comments_pkey PRIMARY KEY (comment_id)
  92  );
  93  
  94  CREATE TABLE content (
  95    content_id int4 DEFAULT '0' NOT NULL,
  96    content_heading text NOT NULL,
  97    content_subheading text NOT NULL,
  98    content_content text NOT NULL,
  99    content_parent int4 DEFAULT '0' NOT NULL,
 100    content_datestamp int4 DEFAULT '0' NOT NULL,
 101    content_author varchar(200) DEFAULT '' NOT NULL,
 102    content_comment int2 DEFAULT '0' NOT NULL,
 103    content_summary text NOT NULL,
 104    content_type int2 DEFAULT '0' NOT NULL,
 105    content_review_score int2 DEFAULT '0' NOT NULL,
 106    content_pe_icon int2 DEFAULT '0' NOT NULL,
 107    content_class int2 DEFAULT '0' NOT NULL,
 108    CONSTRAINT content_pkey PRIMARY KEY (content_id)
 109  );
 110  
 111  CREATE TABLE core (
 112    e107_name varchar(20) DEFAULT '' NOT NULL,
 113    e107_value text NOT NULL,
 114    CONSTRAINT core_pkey PRIMARY KEY (e107_name)
 115  );
 116  
 117  CREATE TABLE download (
 118    download_id int4 DEFAULT '0' NOT NULL,
 119    download_name varchar(100) DEFAULT '' UNIQUE NOT NULL,
 120    download_url varchar(150) DEFAULT '' NOT NULL,
 121    download_author varchar(100) DEFAULT '' NOT NULL,
 122    download_author_email varchar(200) DEFAULT '' NOT NULL,
 123    download_author_website varchar(200) DEFAULT '' NOT NULL,
 124    download_description text NOT NULL,
 125    download_filesize varchar(20) DEFAULT '' NOT NULL,
 126    download_requested int4 DEFAULT '0' NOT NULL,
 127    download_category int4 DEFAULT '0' NOT NULL,
 128    download_active int2 DEFAULT '0' NOT NULL,
 129    download_datestamp int4 DEFAULT '0' NOT NULL,
 130    download_thumb varchar(150) DEFAULT '' NOT NULL,
 131    download_image varchar(150) DEFAULT '' NOT NULL,
 132    download_comment int2 DEFAULT '0' NOT NULL,
 133    CONSTRAINT download_pkey PRIMARY KEY (download_id)
 134  );
 135  
 136  CREATE TABLE download_category (
 137    download_category_id int4 DEFAULT '0' NOT NULL,
 138    download_category_name varchar(100) DEFAULT '' NOT NULL,
 139    download_category_description text NOT NULL,
 140    download_category_icon varchar(100) DEFAULT '' NOT NULL,
 141    download_category_parent int4 DEFAULT '0' NOT NULL,
 142    download_category_class varchar(100) DEFAULT '' NOT NULL,
 143    CONSTRAINT download_category_pkey PRIMARY KEY (download_category_id)
 144  );
 145  
 146  CREATE TABLE flood (
 147    flood_url text NOT NULL,
 148    flood_time int4 DEFAULT '0' NOT NULL,
 149  );
 150  
 151  CREATE TABLE forum (
 152    forum_id int4 DEFAULT '0' NOT NULL,
 153    forum_name varchar(250) DEFAULT '' NOT NULL,
 154    forum_description text NOT NULL,
 155    forum_parent int4 DEFAULT '0' NOT NULL,
 156    forum_datestamp int4 DEFAULT '0' NOT NULL,
 157    forum_moderators text NOT NULL,
 158    forum_threads int4 DEFAULT '0' NOT NULL,
 159    forum_replies int4 DEFAULT '0' NOT NULL,
 160    forum_lastpost varchar(200) DEFAULT '' NOT NULL,
 161    forum_class varchar(100) DEFAULT '' NOT NULL,
 162    forum_order int4 DEFAULT '0' NOT NULL,
 163    CONSTRAINT forum_pkey PRIMARY KEY (forum_id)
 164  );
 165  
 166  CREATE TABLE forum_t (
 167    thread_id int4 DEFAULT '0' NOT NULL,
 168    thread_name varchar(250) DEFAULT '' NOT NULL,
 169    thread_thread text NOT NULL,
 170    thread_forum_id int4 DEFAULT '0' NOT NULL,
 171    thread_datestamp int4 DEFAULT '0' NOT NULL,
 172    thread_parent int4 DEFAULT '0' NOT NULL,
 173    thread_user varchar(250) DEFAULT '' NOT NULL,
 174    thread_views int4 DEFAULT '0' NOT NULL,
 175    thread_active int2 DEFAULT '0' NOT NULL,
 176    thread_lastpost int4 DEFAULT '0' NOT NULL,
 177    thread_s int2 DEFAULT '0' NOT NULL,
 178    CONSTRAINT forum_t_pkey PRIMARY KEY (thread_id)
 179  );
 180  
 181  CREATE TABLE headlines (
 182    headline_id int4 DEFAULT '0' NOT NULL,
 183    headline_url varchar(150) DEFAULT '' NOT NULL,
 184    headline_data text NOT NULL,
 185    headline_timestamp int4 DEFAULT '0' NOT NULL,
 186    headline_description text NOT NULL,
 187    headline_image varchar(100) DEFAULT '' NOT NULL,
 188    headline_active int2 DEFAULT '0' NOT NULL,
 189    CONSTRAINT headlines_pkey PRIMARY KEY (headline_id)
 190  );
 191  
 192  CREATE TABLE links (
 193    link_id int4 DEFAULT '0' NOT NULL,
 194    link_name varchar(100) DEFAULT '' NOT NULL,
 195    link_url varchar(200) DEFAULT '' NOT NULL,
 196    link_description text NOT NULL,
 197    link_button varchar(100) DEFAULT '' NOT NULL,
 198    link_category int2 DEFAULT '0' NOT NULL,
 199    link_order int4 DEFAULT '0' NOT NULL,
 200    link_refer int4 DEFAULT '0' NOT NULL,
 201    link_open int2 DEFAULT '0' NOT NULL,
 202    link_class int2 DEFAULT '0' NOT NULL,
 203    CONSTRAINT links_pkey PRIMARY KEY (link_id)
 204  );
 205  
 206  CREATE TABLE menus (
 207    menu_id int4 DEFAULT '0' NOT NULL,
 208    menu_name varchar(100) DEFAULT '' NOT NULL,
 209    menu_location int2 DEFAULT '0' NOT NULL,
 210    menu_order int2 DEFAULT '0' NOT NULL,
 211    menu_class int2 DEFAULT '0' NOT NULL,
 212    menu_pages text NOT NULL,
 213    CONSTRAINT menus_pkey PRIMARY KEY (menu_id)
 214  );
 215  
 216  CREATE TABLE news (
 217    news_id int4 DEFAULT '0' NOT NULL,
 218    news_title varchar(200) DEFAULT '' NOT NULL,
 219    news_body text NOT NULL,
 220    news_extended text NOT NULL,
 221    news_datestamp int4 DEFAULT '0' NOT NULL,
 222    news_author int4 DEFAULT '0' NOT NULL,
 223    news_category int2 DEFAULT '0' NOT NULL,
 224    news_allow_comments int2 DEFAULT '0' NOT NULL,
 225    news_start int4 DEFAULT '0' NOT NULL,
 226    news_end int4 DEFAULT '0' NOT NULL,
 227    news_class int2 DEFAULT '0' NOT NULL,
 228    news_render_type int2 DEFAULT '0' NOT NULL,
 229    news_comment_total int4 DEFAULT '0' NOT NULL,
 230    CONSTRAINT news_pkey PRIMARY KEY (news_id)
 231  );
 232  
 233  CREATE TABLE news_category (
 234    category_id int4 DEFAULT '0' NOT NULL,
 235    category_name varchar(200) DEFAULT '' NOT NULL,
 236    category_icon varchar(250) DEFAULT '' NOT NULL,
 237    CONSTRAINT news_category_pkey PRIMARY KEY (category_id)
 238  );
 239  
 240  CREATE TABLE online (
 241    online_timestamp int4 DEFAULT '0' NOT NULL,
 242    online_flag int2 DEFAULT '0' NOT NULL,
 243    online_user_id varchar(100) DEFAULT '' NOT NULL,
 244    online_ip varchar(15) DEFAULT '' NOT NULL,
 245    online_location varchar(100) DEFAULT '' NOT NULL,
 246    online_pagecount tinyint(3) int2 DEFAULT '0' NOT NULL,
 247    online_active int4 DEFAULT '0' NOT NULL,
 248    
 249  );
 250  
 251  CREATE TABLE plugin (
 252    plugin_id int4 DEFAULT '0' NOT NULL,
 253    plugin_name varchar(100) DEFAULT '' NOT NULL,
 254    plugin_version varchar(10) DEFAULT '' NOT NULL,
 255    plugin_path varchar(100) DEFAULT '' NOT NULL,
 256    plugin_installflag int2 DEFAULT '0' NOT NULL,
 257    CONSTRAINT plugin_pkey PRIMARY KEY (plugin_id)
 258  );
 259  
 260  CREATE TABLE poll (
 261    poll_id int4 DEFAULT '0' NOT NULL,
 262    poll_datestamp int4 DEFAULT '0' NOT NULL,
 263    poll_end_datestamp int4 DEFAULT '0' NOT NULL,
 264    poll_admin_id int4 DEFAULT '0' NOT NULL,
 265    poll_title varchar(250) DEFAULT '' NOT NULL,
 266    poll_option_1 varchar(250) DEFAULT '' NOT NULL,
 267    poll_option_2 varchar(250) DEFAULT '' NOT NULL,
 268    poll_option_3 varchar(250) DEFAULT '' NOT NULL,
 269    poll_option_4 varchar(250) DEFAULT '' NOT NULL,
 270    poll_option_5 varchar(250) DEFAULT '' NOT NULL,
 271    poll_option_6 varchar(250) DEFAULT '' NOT NULL,
 272    poll_option_7 varchar(250) DEFAULT '' NOT NULL,
 273    poll_option_8 varchar(250) DEFAULT '' NOT NULL,
 274    poll_option_9 varchar(250) DEFAULT '' NOT NULL,
 275    poll_option_10 varchar(250) DEFAULT '' NOT NULL,
 276    poll_votes_1 int4 DEFAULT '0' NOT NULL,
 277    poll_votes_2 int4 DEFAULT '0' NOT NULL,
 278    poll_votes_3 int4 DEFAULT '0' NOT NULL,
 279    poll_votes_4 int4 DEFAULT '0' NOT NULL,
 280    poll_votes_5 int4 DEFAULT '0' NOT NULL,
 281    poll_votes_6 int4 DEFAULT '0' NOT NULL,
 282    poll_votes_7 int4 DEFAULT '0' NOT NULL,
 283    poll_votes_8 int4 DEFAULT '0' NOT NULL,
 284    poll_votes_9 int4 DEFAULT '0' NOT NULL,
 285    poll_votes_10 int4 DEFAULT '0' NOT NULL,
 286    poll_ip text NOT NULL,
 287    poll_active int2 DEFAULT '0' NOT NULL,
 288    poll_comment int2 DEFAULT '1' NOT NULL,
 289    CONSTRAINT poll_pkey PRIMARY KEY (poll_id)
 290  );
 291  
 292  CREATE TABLE rate (
 293    rate_id int4 DEFAULT '0' NOT NULL,
 294    rate_table varchar(100) DEFAULT '' NOT NULL,
 295    rate_itemid int4 DEFAULT '0' NOT NULL,
 296    rate_rating int4 DEFAULT '0' NOT NULL,
 297    rate_votes int4 DEFAULT '0' NOT NULL,
 298    rate_voters text NOT NULL,
 299    CONSTRAINT rate_pkey PRIMARY KEY (rate_id)
 300  );