1 files changed, 383 insertions, 277 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index 698d4a3d98..5e50524d20 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -1,329 +1,435 @@
 #
-# phpBB2 PostgreSQL DB schema - phpBB team 2001
+# phpBB2 PostgreSQL DB schema - phpBB group 2001
 #
 #
 # $Id$
 #
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_banlist'
-#
-
-CREATE TABLE phpbb_banlist (
-   ban_id SERIAL PRIMARY KEY,
-   ban_userid int,
-   ban_ip int,
-   ban_start int,
-   ban_end int,
-   ban_time_type int
+CREATE SEQUENCE "phpbb_banlist_ban_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_categories_cat_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_config_config_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_disallow_disallow_id_s" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_forums_forum_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_posts_post_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_privmsgs_msg_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_ranks_rank_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_smilies_smilies_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_themes_themes_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_topics_topic_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_users_user_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+CREATE SEQUENCE "phpbb_words_word_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_auth_forums" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_auth_forums" (
+   "forum_id" int4 DEFAULT '0' NOT NULL,
+   "auth_read" int2,
+   "auth_post" int2,
+   "auth_reply" int2,
+   "auth_edit" int2,
+   "auth_delete" int2,
+   "auth_list" int2
 );
-CREATE INDEX banlist_ban_id ON phpbb_banlist (ban_id);
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_categories'
-#
 
-CREATE TABLE phpbb_categories (
-   cat_id SERIAL PRIMARY KEY,
-   cat_title varchar(100),
-   cat_order varchar(10)
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_auth_groups" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_auth_groups" (
+   "group_id" int4 DEFAULT '0' NOT NULL,
+   "forum_id" int2 DEFAULT '0' NOT NULL,
+   "can_read" int2,
+   "can_post" int2,
+   "can_reply" int2,
+   "can_edit" int2,
+   "can_delete" int2,
+   "group_level" int2 DEFAULT '0' NOT NULL,
+   "group_ban" int2
 );
-CREATE INDEX categories_cat_id ON phpbb_categories (cat_id);
-
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_config'
-#
 
-CREATE TABLE phpbb_config (
-   config_id SERIAL PRIMARY KEY,
-   sitename varchar(100),
-   allow_html int2,
-   allow_bbcode int2,
-   allow_sig int2,
-   allow_namechange int2,
-   require_activation int2,
-   selected int2 DEFAULT 0 NOT NULL UNIQUE,
-   posts_per_page int,
-   hot_threshold int,
-   topics_per_page int,
-   allow_theme_create int,
-   override_themes int2,
-   email_sig varchar(255),
-   email_from varchar(100),
-   system_timezone varchar(4),
-   default_lang varchar(255)
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_auth_hosts" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_auth_hosts" (
+   "host_id" int2 DEFAULT '0' NOT NULL,
+   "host_ip" char(8) DEFAULT '' NOT NULL,
+   "forum_id" int2,
+   "ip_ban" int2
 );
-CREATE INDEX config_config_id ON phpbb_config (config_id);
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_disallow'
-#
 
-CREATE TABLE phpbb_disallow (
-   disallow_id SERIAL,
-   disallow_username varchar(50)
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_banlist" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_banlist" (
+   "ban_id" int4 DEFAULT nextval('phpbb_banlist_ban_id_seq'::text) NOT NULL,
+   "ban_userid" int4,
+   "ban_ip" char(8),
+   "ban_start" int4,
+   "ban_end" int4,
+   "ban_time_type" int4,
+   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_forum_access'
-#
-
-CREATE TABLE phpbb_forum_access (
-   forum_id SERIAL PRIMARY KEY,
-   user_id int,
-   can_post int2 DEFAULT 0 NOT NULL
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_categories" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_categories" (
+   "cat_id" int4 DEFAULT nextval('phpbb_categories_cat_id_seq'::text) NOT NULL,
+   "cat_title" varchar(100),
+   "cat_order" varchar(10),
+   CONSTRAINT "phpbb_categories_pkey" PRIMARY KEY ("cat_id")
 );
-CREATE INDEX forum_access_forum_id ON phpbb_forum_access (forum_id);
-CREATE INDEX forum_access_user_id ON phpbb_forum_access (user_id);
-
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_forum_mods'
-#
 
-CREATE TABLE phpbb_forum_mods (
-   forum_id int NOT NULL DEFAULT 0,
-   user_id int NOT NULL DEFAULT 0,
-   mod_notify int2
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_config" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_config" (
+   "config_id" int2 NOT NULL,
+   "sitename" varchar(100) NOT NULL,
+   "allow_html" int2 NOT NULL,
+   "allow_bbcode" int2 NOT NULL,
+   "allow_sig" int2 NOT NULL,
+   "allow_namechange" int2 NOT NULL,
+   "allow_theme_create" int2 NOT NULL,
+   "posts_per_page" int2 NOT NULL,
+   "topics_per_page" int2 NOT NULL,
+   "hot_threshold" int2 NOT NULL,
+   "email_sig" varchar(255) NOT NULL,
+   "email_from" varchar(100) NOT NULL,
+   "default_theme" int4 NOT NULL,
+   "default_dateformat" varchar(20) NOT NULL,
+   "default_lang" varchar(50) NOT NULL,
+   "system_timezone" int4 NOT NULL,
+   "sys_template" varchar(50) NOT NULL,
+   "override_themes" int2 NOT NULL,
+   "selected" int2 NOT NULL,
+   CONSTRAINT "phpbb_config_pkey" PRIMARY KEY ("config_id")
 );
-CREATE INDEX forum_mods_forum_id ON phpbb_forum_mods (forum_id);
-CREATE INDEX forum_mods_user_id ON phpbb_forum_mods (user_id);
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_forums'
-#
 
-CREATE TABLE phpbb_forums (
-   forum_id SERIAL PRIMARY KEY,
-   forum_name varchar(150),
-   forum_desc text,
-   forum_access int2,
-   cat_id int,
-   forum_order int DEFAULT '1' NOT NULL,
-   forum_type int2,
-   forum_posts int DEFAULT '0' NOT NULL,
-   forum_topics int DEFAULT '0' NOT NULL,
-   forum_last_post_id int DEFAULT '0' NOT NULL
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_disallow" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_disallow" (
+   "disallow_id" int4 DEFAULT nextval('phpbb_disallow_disallow_id_s'::text) NOT NULL,
+   "disallow_username" varchar(50),
+   CONSTRAINT "phpbb_disallow_pkey" PRIMARY KEY ("disallow_id")
 );
-CREATE INDEX forums_forum_id ON phpbb_forums (forum_id);
-CREATE INDEX forums_forum_order ON phpbb_forums (forum_order);
-CREATE INDEX forums_cat_id ON phpbb_forums (cat_id);
 
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_headermetafooter'
-#
-
-CREATE TABLE phpbb_headermetafooter (
-   header text,
-   meta text,
-   footer text
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_forum_access" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_forum_access" (
+   "forum_id" int4 DEFAULT '0' NOT NULL,
+   "user_id" int4 DEFAULT '0' NOT NULL,
+   "can_post" int2 DEFAULT '0' NOT NULL
 );
+CREATE  INDEX "_phpbb_forum_access_index" ON "phpbb_forum_access" ("forum_id", "user_id");
 
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_posts'
-#
-
-CREATE TABLE phpbb_posts (
-   post_id SERIAL PRIMARY KEY,
-   topic_id int DEFAULT '0' NOT NULL,
-   forum_id int DEFAULT '0' NOT NULL,
-   poster_id int DEFAULT '0' NOT NULL,
-   post_time int DEFAULT '0' NOT NULL,
-   poster_ip int DEFAULT '0' NOT NULL
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_forum_mods" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_forum_mods" (
+   "forum_id" int4 DEFAULT '0' NOT NULL,
+   "user_id" int4 DEFAULT '0' NOT NULL,
+   "mod_notify" int2
 );
-CREATE INDEX posts_post_id ON phpbb_posts (post_id);
-CREATE INDEX posts_forum_id ON phpbb_posts (forum_id);
-CREATE INDEX posts_topic_id ON phpbb_posts (topic_id);
-CREATE INDEX posts_poster_id ON phpbb_posts (poster_id);
-
-
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_posts_text'
-#
-
-CREATE TABLE phpbb_posts_text (
-   post_id int DEFAULT '0' NOT NULL PRIMARY KEY,
-   post_text text
+CREATE  INDEX "_phpbb_forum_mods_index" ON "phpbb_forum_mods" ("forum_id", "user_id");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_forums" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_forums" (
+   "forum_id" int4 DEFAULT nextval('phpbb_forums_forum_id_seq'::text) NOT NULL,
+   "forum_name" varchar(150),
+   "forum_desc" text,
+   "forum_access" int2,
+   "cat_id" int4,
+   "forum_order" int4 DEFAULT '1' NOT NULL,
+   "forum_type" int2,
+   "forum_posts" int4 DEFAULT '0' NOT NULL,
+   "forum_topics" int4 DEFAULT '0' NOT NULL,
+   "forum_last_post_id" int4 DEFAULT '0' NOT NULL,
+   CONSTRAINT "phpbb_forums_pkey" PRIMARY KEY ("forum_id")
 );
-
-
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_priv_msgs'
-#
-
-CREATE TABLE phpbb_priv_msgs (
-   msg_id SERIAL PRIMARY KEY,
-   from_userid int DEFAULT '0' NOT NULL,
-   to_userid int DEFAULT '0' NOT NULL,
-   msg_time int DEFAULT '0' NOT NULL,
-   poster_ip int DEFAULT '0' NOT NULL,
-   msg_status int DEFAULT '0' NOT NULL,
-   msg_text text NOT NULL
+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 "forum_type_phpbb_forums_index" ON "phpbb_forums" ("forum_type");
+CREATE  INDEX "forums_order_phpbb_forums_index" ON "phpbb_forums" ("forum_order");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_groups" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_groups" (
+   "group_id" int4 DEFAULT '0' NOT NULL,
+   "group_name" varchar(100) DEFAULT '' NOT NULL,
+   "group_note" varchar(255) DEFAULT '' NOT NULL,
+   "group_level" int2 DEFAULT '0' NOT NULL
 );
-CREATE INDEX priv_msgs_to_userid ON phpbb_priv_msgs (to_userid);
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_ranks'
-#
 
-CREATE TABLE phpbb_ranks (
-   rank_id SERIAL PRIMARY KEY,
-   rank_title varchar(50) NOT NULL,
-   rank_min int DEFAULT '0' NOT NULL,
-   rank_max int DEFAULT '0' NOT NULL,
-   rank_special int2 DEFAULT '0',
-   rank_image varchar(255)
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_posts" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_posts" (
+   "post_id" int4 DEFAULT nextval('phpbb_posts_post_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,
+   "poster_ip" varchar(8) DEFAULT '' NOT NULL,
+   "bbcode_uid" varchar(10) DEFAULT '' NOT NULL,
+   CONSTRAINT "phpbb_posts_pkey" PRIMARY KEY ("post_id")
 );
-CREATE INDEX ranks_rank_min ON phpbb_ranks (rank_min);
-CREATE INDEX ranks_rank_max ON phpbb_ranks (rank_max);
-
-
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_sessions'
-#
-
-CREATE TABLE phpbb_sessions (
-   sess_id int4 DEFAULT '0' NOT NULL PRIMARY KEY,
-   user_id int DEFAULT '0' NOT NULL,
-   start_time int4 DEFAULT '0' NOT NULL,
-   remote_ip int DEFAULT '0' NOT NULL,
-   username varchar(40),
-   forum int
+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_text" text,
+   CONSTRAINT "phpbb_posts_text_pkey" PRIMARY KEY ("post_id")
+);
+CREATE  INDEX "post_id_phpbb_posts_text_index" ON "phpbb_posts_text" ("post_id");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_privmsgs" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_privmsgs" (
+   "msg_id" int4 DEFAULT nextval('phpbb_privmsgs_msg_id_seq'::text) NOT NULL,
+   "from_userid" int4 DEFAULT '0' NOT NULL,
+   "to_userid" int4 DEFAULT '0' NOT NULL,
+   "msg_time" int4 DEFAULT '0' NOT NULL,
+   "poster_ip" varchar(8),
+   "msg_status" int4 DEFAULT '0' NOT NULL,
+   "msg_text" text NOT NULL,
+   "newmsg" int2 DEFAULT '0' NOT NULL,
+   CONSTRAINT "phpbb_privmsgs_pkey" PRIMARY KEY ("msg_id")
+);
+CREATE  INDEX "to_userid_phpbb_privmsgs_index" ON "phpbb_privmsgs" ("to_userid");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_ranks" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_ranks" (
+   "rank_id" int4 DEFAULT nextval('phpbb_ranks_rank_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_session" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_session" (
+   "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_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_session (session_user_id) 
+CREATE INDEX session_id_ip_user_id ON phpbb_session (session_id, session_ip, session_user_id) 
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_session_keys" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_session_keys" (
+   "key_user_id" int4 DEFAULT '0' NOT NULL,
+   "key_ip" varchar(8) DEFAULT '' NOT NULL,
+   "key_login" varchar(32) DEFAULT '' NOT NULL,
+   CONSTRAINT "phpbb_session_keys_pkey" PRIMARY KEY ("key_user_id")
+);
+CREATE  INDEX "key_ip_phpbb_session_keys_index" ON "phpbb_session_keys" ("key_ip");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_smilies" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_smilies" (
+   "smilies_id" int4 DEFAULT nextval('phpbb_smilies_smilies_id_seq'::text) NOT NULL,
+   "code" varchar(50),
+   "smile_url" varchar(100),
+   "emoticon" varchar(75),
+   CONSTRAINT "phpbb_smilies_pkey" PRIMARY KEY ("smilies_id")
 );
-CREATE INDEX sessions_start_time ON phpbb_sessions (start_time);
-CREATE INDEX sessions_remote_ip ON phpbb_sessions (remote_ip);
-
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_themes'
-#
 
-CREATE TABLE phpbb_themes (
-   theme_id SERIAL PRIMARY KEY,
-   theme_name varchar(35),
-   bgcolor varchar(10),
-   textcolor varchar(10),
-   color1 varchar(10),
-   color2 varchar(10),
-   table_bgcolor varchar(10),
-   header_image varchar(50),
-   newtopic_image varchar(50),
-   reply_image varchar(50),
-   linkcolor varchar(15),
-   vlinkcolor varchar(15),
-   theme_default int2 DEFAULT '0',
-   fontface varchar(100),
-   fontsize1 varchar(5),
-   fontsize2 varchar(5),
-   fontsize3 varchar(5),
-   fontsize4 varchar(5),
-   tablewidth varchar(10),
-   replylocked_image varchar(255)
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_themes" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_themes" (
+   "themes_id" int4 DEFAULT nextval('phpbb_themes_themes_id_seq'::text) NOT NULL,
+   "themes_name" varchar(30),
+   "head_stylesheet" varchar(100),
+   "body_background" varchar(100),
+   "body_bgcolor" varchar(6),
+   "body_text" varchar(6),
+   "body_link" varchar(6),
+   "body_vlink" varchar(6),
+   "body_alink" varchar(6),
+   "body_hlink" varchar(6),
+   "tr_color1" varchar(6),
+   "tr_color2" varchar(6),
+   "tr_color3" varchar(6),
+   "th_color1" varchar(6),
+   "th_color2" varchar(6),
+   "th_color3" varchar(6),
+   "td_color1" varchar(6),
+   "td_color2" varchar(6),
+   "td_color3" varchar(6),
+   "fontface1" varchar(15),
+   "fontface2" varchar(15),
+   "fontface3" varchar(15),
+   "fontsize1" int2,
+   "fontsize2" int2,
+   "fontsize3" int2,
+   "fontcolor1" varchar(6),
+   "fontcolor2" varchar(6),
+   "fontcolor3" varchar(6),
+   "img1" varchar(100),
+   "img2" varchar(100),
+   "img3" varchar(100),
+   "img4" varchar(100),
+   CONSTRAINT "phpbb_themes_pkey" PRIMARY KEY ("themes_id")
+);
+CREATE  INDEX "themes_name_phpbb_themes_index" ON "phpbb_themes" ("themes_name");
+
+
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_themes_name" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_themes_name" (
+   "themes_id" int4 DEFAULT '0' NOT NULL,
+   "tr_color1_name" varchar(25),
+   "tr_color2_name" varchar(25),
+   "tr_color3_name" varchar(25),
+   "th_color1_name" varchar(25),
+   "th_color2_name" varchar(25),
+   "th_color3_name" varchar(25),
+   "td_color1_name" varchar(25),
+   "td_color2_name" varchar(25),
+   "td_color3_name" varchar(25),
+   "fontface1_name" varchar(25),
+   "fontface2_name" varchar(25),
+   "fontface3_name" varchar(25),
+   "fontsize1_name" varchar(25),
+   "fontsize2_name" varchar(25),
+   "fontsize3_name" varchar(25),
+   "fontcolor1_name" varchar(25),
+   "fontcolor2_name" varchar(25),
+   "fontcolor3_name" varchar(25),
+   "img1_name" varchar(25),
+   "img2_name" varchar(25),
+   "img3_name" varchar(25),
+   "img4_name" varchar(25),
+   CONSTRAINT "phpbb_themes_name_pkey" PRIMARY KEY ("themes_id")
 );
 
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_topics'
-#
-
-CREATE TABLE phpbb_topics (
-   topic_id SERIAL PRIMARY KEY,
-   topic_title varchar(100) NOT NULL,
-   topic_poster int DEFAULT '0' NOT NULL,
-   topic_time int DEFAULT '0' NOT NULL,
-   topic_views int DEFAULT '0' NOT NULL,
-   topic_replies int DEFAULT '0' NOT NULL,
-   forum_id int DEFAULT '0' NOT NULL,
-   topic_status int2 DEFAULT '0' NOT NULL,
-   topic_notify int2 DEFAULT '0',
-   topic_last_post_id int DEFAULT '0' NOT NULL
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_topics" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_topics" (
+   "topic_id" int4 DEFAULT nextval('phpbb_topics_topic_id_seq'::text) 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,
+   "forum_id" int4 DEFAULT '0' NOT NULL,
+   "topic_status" int2 DEFAULT '0' NOT NULL,
+   "topic_notify" int2 DEFAULT '0',
+   "topic_last_post_id" int4 DEFAULT '0' NOT NULL,
+   CONSTRAINT "phpbb_topics_pkey" PRIMARY KEY ("topic_id")
 );
-CREATE INDEX topics_topic_id ON phpbb_topics (topic_id);
-CREATE INDEX topics_forum_id ON phpbb_topics (forum_id);
+CREATE  INDEX "_phpbb_topics_index" ON "phpbb_topics" ("forum_id", "topic_id");
+CREATE  INDEX "forum_id_phpbb_topics_index" ON "phpbb_topics" ("forum_id");
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_users'
-#
 
-CREATE TABLE phpbb_users (
-   user_id SERIAL PRIMARY KEY,
-   username varchar(40) NOT NULL,
-   user_regdate varchar(20) NOT NULL,
-   user_password varchar(32) NOT NULL,
-   user_email varchar(255),
-   user_icq varchar(15),
-   user_website varchar(100),
-   user_occ varchar(100),
-   user_from varchar(100),
-   user_intrest varchar(150),
-   user_sig varchar(255),
-   user_viewemail int2,
-   user_theme int,
-   user_aim varchar(255),
-   user_yim varchar(255),
-   user_msnm varchar(255),
-   user_posts int DEFAULT '0',
-   user_attachsig int2,
-   user_desmile int2,
-   user_html int2,
-   user_bbcode int2,
-   user_rank int DEFAULT '0',
-   user_level int DEFAULT '1',
-   user_lang varchar(255),
-   user_timezone varchar(4),
-   user_active int2,
-   user_actkey varchar(32),
-   user_newpasswd varchar(32),
-   user_notify int2
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_user_groups" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_user_groups" (
+   "group_id" int4 DEFAULT '0' NOT NULL,
+   "user_id" int4 DEFAULT '0' NOT NULL
 );
-CREATE INDEX users_user_id ON phpbb_users (user_id);
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_whosonline'
-#
 
-CREATE TABLE phpbb_whosonline (
-   id SERIAL PRIMARY KEY,
-   ip varchar(255),
-   name varchar(255),
-   count varchar(255),
-   date varchar(255),
-   username varchar(40),
-   forum int
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_users" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_users" (
+   "user_id" int4 DEFAULT nextval('phpbb_users_user_id_seq'::text) NOT NULL,
+   "username" varchar(40) 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" varchar(255),
+   "user_viewemail" int2,
+   "user_theme" int4,
+   "user_aim" varchar(255),
+   "user_yim" varchar(255),
+   "user_msnm" varchar(255),
+   "user_posts" int4 DEFAULT '0',
+   "user_attachsig" int2,
+   "user_desmile" int2,
+   "user_html" int2,
+   "user_bbcode" int2,
+   "user_rank" int4 DEFAULT '0',
+   "user_avatar" varchar(100),
+   "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_actkey" varchar(32),
+   "user_newpasswd" varchar(32),
+   "user_notify" int2,
+   "user_active" int2,
+   "user_template" varchar(50),
+   CONSTRAINT "phpbb_users_pkey" PRIMARY KEY ("user_id")
 );
-CREATE INDEX whosonline_id ON phpbb_whosonline (id);
 
 
-# --------------------------------------------------------
-#
-# Table structure for table 'phpbb_words'
-#
-
-CREATE TABLE phpbb_words (
-   word_id SERIAL PRIMARY KEY,
-   word varchar(100) NOT NULL,
-   replacement varchar(100) NOT NULL
+/* -------------------------------------------------------- 
+  Table structure for table "phpbb_words" 
+-------------------------------------------------------- */
+CREATE TABLE "phpbb_words" (
+   "word_id" int4 DEFAULT nextval('phpbb_words_word_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")
 );
-CREATE INDEX words_word_id ON phpbb_words (word_id);
-