From 215dff4ba8c01fc70c9e6c4589140734bbf7fd41 Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Tue, 20 Nov 2001 22:29:14 +0000
Subject: Moved from parent directory - no other changes ... at least I don't
remember any ... I'll regret saying that, I just know it ...
git-svn-id: file:///svn/phpbb/trunk@1393 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/schemas/postgres_schema.sql | 534 +++++++++++++++++++++++++++++++++++
1 file changed, 534 insertions(+)
create mode 100644 phpBB/db/schemas/postgres_schema.sql
(limited to 'phpBB/db/schemas/postgres_schema.sql')
diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql
new file mode 100644
index 0000000000..b5c50e26c4
--- /dev/null
+++ b/phpBB/db/schemas/postgres_schema.sql
@@ -0,0 +1,534 @@
+/*
+ phpBB2 PostgreSQL DB schema - phpBB group 2001
+
+
+ $Id$
+*/
+
+CREATE SEQUENCE phpbb_banlist_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_categories_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_config_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_disallow_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_forums_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_posts_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_privmsgs_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_ranks_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_search_wordlist_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_smilies_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_themes_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_topics_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_users_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_words_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_groups_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_forum_prune_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+CREATE SEQUENCE phpbb_vote_desc_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_auth_access
+-------------------------------------------------------- */
+CREATE TABLE phpbb_auth_access (
+ group_id int DEFAULT '0' NOT NULL,
+ forum_id int2 DEFAULT '0' NOT NULL,
+ auth_view int2 DEFAULT '0' NOT NULL,
+ auth_read int2 DEFAULT '0' NOT NULL,
+ auth_post int2 DEFAULT '0' NOT NULL,
+ auth_reply int2 DEFAULT '0' NOT NULL,
+ auth_edit int2 DEFAULT '0' NOT NULL,
+ auth_delete int2 DEFAULT '0' NOT NULL,
+ auth_announce int2 DEFAULT '0' NOT NULL,
+ auth_sticky int2 DEFAULT '0' NOT NULL,
+ auth_pollcreate int2 DEFAULT '0' NOT NULL,
+ auth_attachments int2 DEFAULT '0' NOT NULL,
+ auth_vote int2 DEFAULT '0' NOT NULL,
+ auth_mod int2 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_auth_access_pkey PRIMARY KEY (group_id)
+);
+CREATE INDEX group_id_phpbb_auth_access_index ON phpbb_auth_access (forum_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_groups
+-------------------------------------------------------- */
+CREATE TABLE phpbb_groups (
+ group_id int DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL,
+ group_name varchar(40) NOT NULL,
+ group_type int2 DEFAULT '1' NOT NULL,
+ group_description varchar(255) NOT NULL,
+ group_moderator int4 DEFAULT '0' NOT NULL,
+ group_single_user int2 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_banlist
+-------------------------------------------------------- */
+CREATE TABLE phpbb_banlist (
+ ban_id int4 DEFAULT nextval('phpbb_banlist_id_seq'::text) NOT NULL,
+ ban_userid int4,
+ ban_ip char(8),
+ ban_email varchar(255),
+ CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id)
+);
+CREATE INDEX ban_userid_phpbb_banlist_index ON phpbb_banlist (ban_userid);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_categories
+-------------------------------------------------------- */
+CREATE TABLE phpbb_categories (
+ cat_id int4 DEFAULT nextval('phpbb_categories_id_seq'::text) NOT NULL,
+ cat_title varchar(100),
+ cat_order int4,
+ CONSTRAINT phpbb_categories_pkey PRIMARY KEY (cat_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_config
+-------------------------------------------------------- */
+CREATE TABLE phpbb_config (
+ config_name varchar(255) NOT NULL,
+ config_value varchar(255) NOT NULL,
+ CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_name)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_disallow
+-------------------------------------------------------- */
+CREATE TABLE phpbb_disallow (
+ disallow_id int4 DEFAULT nextval('phpbb_disallow_id_s'::text) NOT NULL,
+ disallow_username varchar(25),
+ CONSTRAINT phpbb_disallow_pkey PRIMARY KEY (disallow_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_forums
+-------------------------------------------------------- */
+CREATE TABLE phpbb_forums (
+ forum_id int4 DEFAULT nextval('phpbb_forums_id_seq'::text) NOT NULL,
+ cat_id int4,
+ forum_name varchar(150),
+ forum_desc text,
+ forum_status int2 DEFAULT '0' NOT NULL,
+ forum_order int4 DEFAULT '1' NOT NULL,
+ forum_posts int4 DEFAULT '0' NOT NULL,
+ forum_topics int4 DEFAULT '0' NOT NULL,
+ forum_last_post_id int4 DEFAULT '0' NOT NULL,
+ prune_enable int2 DEFAULT '1' NOT NULL,
+ prune_next int,
+ auth_view int2 DEFAULT '0' NOT NULL,
+ auth_read int2 DEFAULT '0' NOT NULL,
+ auth_post int2 DEFAULT '0' NOT NULL,
+ auth_reply int2 DEFAULT '0' NOT NULL,
+ auth_edit int2 DEFAULT '0' NOT NULL,
+ auth_delete int2 DEFAULT '0' NOT NULL,
+ auth_announce int2 DEFAULT '0' NOT NULL,
+ auth_sticky int2 DEFAULT '0' NOT NULL,
+ auth_pollcreate int2 DEFAULT '0' NOT NULL,
+ auth_vote int2 DEFAULT '0' NOT NULL,
+ auth_attachments int2 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_forums_pkey PRIMARY KEY (forum_id)
+);
+CREATE INDEX cat_id_phpbb_forums_index ON phpbb_forums (cat_id);
+CREATE INDEX forum_id_phpbb_forums_index ON phpbb_forums (forum_id);
+CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_forum_prune
+-------------------------------------------------------- */
+CREATE TABLE phpbb_forum_prune (
+ prune_id int4 DEFAULT nextval('phpbb_forum_prune_id_seq'::text) NOT NULL,
+ forum_id int4 NOT NULL,
+ prune_days int4 NOT NULL,
+ prune_freq int4 NOT NULL,
+ CONSTRAINT phpbb_forum_prune_pkey PRIMARY KEY (prune_id)
+);
+CREATE INDEX prune_id_phpbb_forum_prune_index ON phpbb_forum_prune (prune_id);
+CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_posts
+-------------------------------------------------------- */
+CREATE TABLE phpbb_posts (
+ post_id int4 DEFAULT nextval('phpbb_posts_id_seq'::text) NOT NULL,
+ topic_id int4 DEFAULT '0' NOT NULL,
+ forum_id int4 DEFAULT '0' NOT NULL,
+ poster_id int4 DEFAULT '0' NOT NULL,
+ post_time int4 DEFAULT '0' NOT NULL,
+ post_username varchar(30),
+ poster_ip char(8) DEFAULT '' NOT NULL,
+ enable_bbcode int2 DEFAULT '1' NOT NULL,
+ enable_html int2 DEFAULT '0' NOT NULL,
+ enable_smilies int2 DEFAULT '1' NOT NULL,
+ enable_sig int2 DEFAULT '1' NOT NULL,
+ bbcode_uid varchar(10) DEFAULT '' NOT NULL,
+ post_edit_time int4,
+ post_edit_count int2 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id)
+);
+CREATE INDEX forum_id_phpbb_posts_index ON phpbb_posts (forum_id);
+CREATE INDEX post_time_phpbb_posts_index ON phpbb_posts (post_time);
+CREATE INDEX poster_id_phpbb_posts_index ON phpbb_posts (poster_id);
+CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_posts_text
+-------------------------------------------------------- */
+CREATE TABLE phpbb_posts_text (
+ post_id int4 DEFAULT '0' NOT NULL,
+ post_subject varchar(255),
+ post_text text,
+ CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_privmsgs
+-------------------------------------------------------- */
+CREATE TABLE phpbb_privmsgs (
+ privmsgs_id int4 DEFAULT nextval('phpbb_privmsgs_id_seq'::text) NOT NULL,
+ privmsgs_type int2 DEFAULT '0' NOT NULL,
+ privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
+ privmsgs_from_userid int4 DEFAULT '0' NOT NULL,
+ privmsgs_to_userid int4 DEFAULT '0' NOT NULL,
+ privmsgs_date int4 DEFAULT '0' NOT NULL,
+ privmsgs_ip char(8) NOT NULL,
+ privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL,
+ privmsgs_enable_html int2 DEFAULT '0' NOT NULL,
+ privmsgs_enable_smilies int2 DEFAULT '1' NOT NULL,
+ privmsgs_attach_sig int2 DEFAULT '1' NOT NULL,
+ CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id)
+);
+CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid);
+CREATE INDEX privmsgs_to_userid_index ON phpbb_privmsgs (privmsgs_to_userid);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_privmsgs_text
+-------------------------------------------------------- */
+CREATE TABLE phpbb_privmsgs_text (
+ privmsgs_text_id int4 DEFAULT '0' NOT NULL,
+ privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
+ privmsgs_text text,
+ CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_ranks
+-------------------------------------------------------- */
+CREATE TABLE phpbb_ranks (
+ rank_id int4 DEFAULT nextval('phpbb_ranks_id_seq'::text) NOT NULL,
+ rank_title varchar(50) DEFAULT '' NOT NULL,
+ rank_min int4 DEFAULT '0' NOT NULL,
+ rank_max int4 DEFAULT '0' NOT NULL,
+ rank_special int2 DEFAULT '0',
+ rank_image varchar(255),
+ CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (rank_id)
+);
+CREATE INDEX rank_id_phpbb_ranks_index ON phpbb_ranks (rank_id);
+CREATE INDEX rank_max_phpbb_ranks_index ON phpbb_ranks (rank_max);
+CREATE INDEX rank_min_phpbb_ranks_index ON phpbb_ranks (rank_min);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_search_results
+-------------------------------------------------------- */
+CREATE TABLE phpbb_search_results (
+ search_id int4 NOT NULL default '0',
+ session_id char(32) NOT NULL default '',
+ search_array text NOT NULL,
+ CONSTRAINT phpbb_search_results_pkey PRIMARY KEY (search_id)
+);
+CREATE INDEX session_id_phpbb_search_results ON phpbb_search_results (session_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_search_wordlist
+-------------------------------------------------------- */
+CREATE TABLE phpbb_search_wordlist (
+ word_id int4 DEFAULT nextval('phpbb_search_wordlist_id_seq'::text) NOT NULL,
+ word_text varchar(100) NOT NULL default '',
+ word_weight int2 NOT NULL default '0',
+ CONSTRAINT phpbb_search_results_pkey PRIMARY KEY (word_id),
+)
+CREATE INDEX word_text_phpbb_search_wordlist ON phpbb_search_wordlist (word_text);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_search_wordmatch
+-------------------------------------------------------- */
+CREATE TABLE phpbb_search_wordmatch (
+ post_id int4 NOT NULL default '0',
+ word_id int4 NOT NULL default '0',
+ word_count int2 NOT NULL default '0',
+ title_match int2 NOT NULL default '0'
+)
+CREATE INDEX word_id_phpbb_search_wordmatch ON phpbb_search_wordmatch (word_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_sessions
+-------------------------------------------------------- */
+CREATE TABLE phpbb_sessions (
+ session_id char(32) DEFAULT '0' NOT NULL,
+ session_user_id int4 DEFAULT '0' NOT NULL,
+ session_start int4 DEFAULT '0' NOT NULL,
+ session_time int4 DEFAULT '0' NOT NULL,
+ session_last_visit int4 DEFAULT '0' NOT NULL,
+ session_ip char(8) DEFAULT '0' NOT NULL,
+ session_page int4 DEFAULT '0' NOT NULL,
+ session_logged_in int2 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_session_pkey PRIMARY KEY (session_id)
+);
+CREATE INDEX session_user_id ON phpbb_sessions (session_user_id);
+CREATE INDEX session_id_ip_user_id ON phpbb_sessions (session_id, session_ip, session_user_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_smilies
+-------------------------------------------------------- */
+CREATE TABLE phpbb_smilies (
+ smilies_id int4 DEFAULT nextval('phpbb_smilies_id_seq'::text) NOT NULL,
+ code varchar(50),
+ smile_url varchar(100),
+ emoticon varchar(75),
+ CONSTRAINT phpbb_smilies_pkey PRIMARY KEY (smilies_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_themes
+-------------------------------------------------------- */
+CREATE TABLE phpbb_themes (
+ themes_id int4 DEFAULT nextval('phpbb_themes_id_seq'::text) NOT NULL,
+ style_name varchar(30),
+ template_name varchar(30) NOT NULL default '',
+ head_stylesheet varchar(100),
+ body_background varchar(100),
+ body_bgcolor char(6),
+ body_text char(6),
+ body_link char(6),
+ body_vlink char(6),
+ body_alink char(6),
+ body_hlink char(6),
+ tr_color1 char(6),
+ tr_color2 char(6),
+ tr_color3 char(6),
+ tr_class1 varchar(25),
+ tr_class2 varchar(25),
+ tr_class3 varchar(25),
+ th_color1 char(6),
+ th_color2 char(6),
+ th_color3 char(6),
+ th_class1 varchar(25),
+ th_class2 varchar(25),
+ th_class3 varchar(25),
+ td_color1 char(6),
+ td_color2 char(6),
+ td_color3 char(6),
+ td_class1 varchar(25),
+ td_class2 varchar(25),
+ td_class3 varchar(25),
+ fontface1 varchar(25),
+ fontface2 varchar(25),
+ fontface3 varchar(25),
+ fontsize1 int2,
+ fontsize2 int2,
+ fontsize3 int2,
+ fontcolor1 char(6),
+ fontcolor2 char(6),
+ fontcolor3 char(6),
+ span_class1 varchar(25),
+ span_class2 varchar(25),
+ span_class3 varchar(25),
+ CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_themes_name
+-------------------------------------------------------- */
+CREATE TABLE phpbb_themes_name (
+ themes_id int4 DEFAULT '0' NOT NULL,
+ tr_color1_name char(50),
+ tr_color2_name char(50),
+ tr_color3_name char(50),
+ tr_class1_name varchar(50),
+ tr_class2_name varchar(50),
+ tr_class3_name varchar(50),
+ th_color1_name char(50),
+ th_color2_name char(50),
+ th_color3_name char(50),
+ th_class1_name varchar(50),
+ th_class2_name varchar(50),
+ th_class3_name varchar(50),
+ td_color1_name char(50),
+ td_color2_name char(50),
+ td_color3_name char(50),
+ td_class1_name varchar(50),
+ td_class2_name varchar(50),
+ td_class3_name varchar(50),
+ fontface1_name varchar(50),
+ fontface2_name varchar(50),
+ fontface3_name varchar(50),
+ fontsize1_name varchar(50),
+ fontsize2_name varchar(50),
+ fontsize3_name varchar(50),
+ fontcolor1_name char(50),
+ fontcolor2_name char(50),
+ fontcolor3_name char(50),
+ span_class1_name varchar(50),
+ span_class2_name varchar(50),
+ span_class3_name varchar(50),
+ CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_topics
+-------------------------------------------------------- */
+CREATE TABLE phpbb_topics (
+ topic_id int4 DEFAULT nextval('phpbb_topics_id_seq'::text) NOT NULL,
+ forum_id int4 DEFAULT '0' NOT NULL,
+ topic_title varchar(100) DEFAULT '' NOT NULL,
+ topic_poster int4 DEFAULT '0' NOT NULL,
+ topic_time int4 DEFAULT '0' NOT NULL,
+ topic_views int4 DEFAULT '0' NOT NULL,
+ topic_replies int4 DEFAULT '0' NOT NULL,
+ topic_status int2 DEFAULT '0' NOT NULL,
+ topic_vote int2 DEFAULT '0' NOT NULL,
+ topic_type int2 DEFAULT '0' NOT NULL,
+ topic_moved_id int4,
+ topic_last_post_id int4 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id)
+);
+CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id);
+CREATE INDEX topic_moved_id_phpbb_topics_index ON phpbb_topics (topic_moved_id);
+CREATE INDEX topic_last_post_id_phpbb_topics_index ON phpbb_topics (topic_last_post_id);
+CREATE INDEX topic_type_phpbb_topics_index ON phpbb_topics (topic_type);
+CREATE INDEX topic_poster_phpbb_topics_index ON phpbb_topics (topic_poster);
+CREATE INDEX topic_time_phpbb_topics_index ON phpbb_topics (topic_time);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_topics_watch
+-------------------------------------------------------- */
+CREATE TABLE phpbb_topics_watch (
+ topic_id int4,
+ user_id int4,
+ notify_status int2 NOT NULL default '0'
+);
+CREATE INDEX topic_id_phpbb_topics_watch_index ON phpbb_topics_watch (topic_id);
+CREATE INDEX user_id_phpbb_topics_watch_index ON phpbb_topics_watch (user_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_user_group
+-------------------------------------------------------- */
+CREATE TABLE phpbb_user_group (
+ group_id int DEFAULT '0' NOT NULL,
+ user_id int DEFAULT '0' NOT NULL,
+ user_pending int2
+);
+CREATE INDEX group_id_phpbb_user_group_index ON phpbb_user_group (group_id);
+CREATE INDEX user_id_phpbb_user_group_index ON phpbb_user_group (user_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_users
+-------------------------------------------------------- */
+CREATE TABLE phpbb_users (
+ user_id int4 DEFAULT nextval('phpbb_users_id_seq'::text) NOT NULL,
+ user_active int2,
+ username varchar(25) DEFAULT '' NOT NULL,
+ user_regdate int4 DEFAULT '0' NOT NULL,
+ user_password varchar(32) DEFAULT '' NOT NULL,
+ user_autologin_key varchar(32),
+ user_email varchar(255),
+ user_icq varchar(15),
+ user_website varchar(100),
+ user_occ varchar(100),
+ user_from varchar(100),
+ user_interests varchar(255),
+ user_sig text,
+ user_sig_bbcode_uid char(10),
+ user_style int4,
+ user_aim varchar(255),
+ user_yim varchar(255),
+ user_msnm varchar(255),
+ user_posts int4 DEFAULT '0' NOT NULL,
+ user_emailtime int4,
+ user_viewemail int2,
+ user_attachsig int2,
+ user_allowhtml int2,
+ user_allowbbcode int2,
+ user_allowsmile int2,
+ user_allow_pm int2 DEFAULT '1' NOT NULL,
+ user_allowavatar int2 DEFAULT '1' NOT NULL,
+ user_allow_viewonline int2 DEFAULT '1' NOT NULL,
+ user_rank int4 DEFAULT '0',
+ user_avatar varchar(100),
+ user_avatar_type int2 DEFAULT '0' NOT NULL,
+ user_level int4 DEFAULT '1',
+ user_lang varchar(255),
+ user_timezone int4 DEFAULT '0' NOT NULL,
+ user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
+ user_notify_pm int2 DEFAULT '1' NOT NULL,
+ user_notify int2,
+ user_actkey varchar(32),
+ user_newpasswd varchar(32),
+ CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id)
+);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_vote_desc
+-------------------------------------------------------- */
+CREATE TABLE phpbb_vote_desc (
+ vote_id int4 DEFAULT nextval('phpbb_vote_desc_id_seq'::text) NOT NULL ,
+ topic_id int4 NOT NULL DEFAULT '0',
+ vote_text text NOT NULL,
+ vote_start int4 DEFAULT '0' NOT NULL,
+ vote_length int4 DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_vote_dsc_pkey PRIMARY KEY (vote_id)
+);
+CREATE INDEX topic_id_phpbb_vote_desc_index ON phpbb_vote_desc (topic_id);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_vote_results
+-------------------------------------------------------- */
+CREATE TABLE phpbb_vote_results (
+ vote_id int4 NOT NULL DEFAULT '0',
+ vote_option_id int4 NOT NULL DEFAULT '0',
+ vote_option_text varchar(255) NOT NULL,
+ vote_result int4 NOT NULL DEFAULT '0'
+);
+CREATE INDEX option_id_phpbb_vote_results_index ON phpbb_vote_results (vote_option_id);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_vote_voters
+-------------------------------------------------------- */
+CREATE TABLE phpbb_vote_voters (
+ vote_id int4 NOT NULL DEFAULT '0',
+ vote_user_id int4 NOT NULL DEFAULT '0',
+ vote_user_ip char(8) NOT NULL
+);
+CREATE INDEX vote_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_id);
+CREATE INDEX vote_user_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_user_id);
+CREATE INDEX vote_user_ip_phpbb_vote_voters_index ON phpbb_vote_voters (vote_user_ip);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_words
+-------------------------------------------------------- */
+CREATE TABLE phpbb_words (
+ word_id int4 DEFAULT nextval('phpbb_words_id_seq'::text) NOT NULL,
+ word varchar(100) DEFAULT '' NOT NULL,
+ replacement varchar(100) DEFAULT '' NOT NULL,
+ CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id)
+);
--
cgit v1.2.1