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/ms_access_primer.zip | Bin 0 -> 107531 bytes
phpBB/db/schemas/mssql_basic.sql | 202 +++++++++
phpBB/db/schemas/mssql_schema.sql | 775 ++++++++++++++++++++++++++++++++++
phpBB/db/schemas/mysql_basic.sql | 147 +++++++
phpBB/db/schemas/mysql_schema.sql | 584 +++++++++++++++++++++++++
phpBB/db/schemas/oracle_basic.sql | 181 ++++++++
phpBB/db/schemas/oracle_schema.sql | 522 +++++++++++++++++++++++
phpBB/db/schemas/oracle_triggers.sql | 217 ++++++++++
phpBB/db/schemas/postgres_basic.sql | 149 +++++++
phpBB/db/schemas/postgres_schema.sql | 534 +++++++++++++++++++++++
10 files changed, 3311 insertions(+)
create mode 100644 phpBB/db/schemas/ms_access_primer.zip
create mode 100644 phpBB/db/schemas/mssql_basic.sql
create mode 100644 phpBB/db/schemas/mssql_schema.sql
create mode 100644 phpBB/db/schemas/mysql_basic.sql
create mode 100644 phpBB/db/schemas/mysql_schema.sql
create mode 100644 phpBB/db/schemas/oracle_basic.sql
create mode 100644 phpBB/db/schemas/oracle_schema.sql
create mode 100644 phpBB/db/schemas/oracle_triggers.sql
create mode 100644 phpBB/db/schemas/postgres_basic.sql
create mode 100644 phpBB/db/schemas/postgres_schema.sql
diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip
new file mode 100644
index 0000000000..53dbbfb5ce
Binary files /dev/null and b/phpBB/db/schemas/ms_access_primer.zip differ
diff --git a/phpBB/db/schemas/mssql_basic.sql b/phpBB/db/schemas/mssql_basic.sql
new file mode 100644
index 0000000000..3b7db5c33f
--- /dev/null
+++ b/phpBB/db/schemas/mssql_basic.sql
@@ -0,0 +1,202 @@
+/*
+
+ Basic DB data for phpBB2 devel (MSSQL)
+
+ $Id$
+
+*/
+
+BEGIN TRANSACTION;
+
+/*
+ -- Config
+*/
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mssql');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','900');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_admin_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
+
+
+/*
+ -- Categories
+*/
+SET IDENTITY_INSERT phpbb_categories ON;
+
+INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
+
+SET IDENTITY_INSERT phpbb_categories OFF;
+
+
+/*
+ -- Forums
+*/
+SET IDENTITY_INSERT phpbb_forums ON;
+
+INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 1, 'Test Forum 1', 'This is just a test forum, nothing special here.', '', 1, 1, 1, 1, '', 1, '', '', '', '', 1, 1, 3, 1, 1, 1, 3);
+
+SET IDENTITY_INSERT phpbb_forums OFF;
+
+
+/*
+ -- Users
+ Default Admin --> username: admin
+ password: admin (change this or remove it once everything is working!)
+*/
+INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_autologin_key, user_level, user_posts, user_timezone, user_dateformat, user_lang, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_regdate, user_rank, user_avatar, user_email, user_icq, user_website, user_from, user_sig, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (-1, '', 'Anonymous', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '');
+INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_autologin_key, user_level, user_posts, user_timezone, user_dateformat, user_style, user_lang, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_regdate, user_rank, user_avatar, user_email, user_icq, user_website, user_from, user_sig, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (2, 1, 'Admin', '21232f297a57a5a743894a0e4a801fc3', '', 1, 1, 0, 'd M Y h:i a', 1, '', 1, '', '', 1, 1, 1, 1, 1, '', 1, 0, 1, '', 'admin@yourdomain.com', '', '', '', '', '', '', '', '', '', '', '');
+
+
+/*
+ -- Ranks
+*/
+SET IDENTITY_INSERT phpbb_ranks ON;
+
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES (1, 'Site Admin', -1, -1, 1, '');
+
+SET IDENTITY_INSERT phpbb_ranks OFF;
+
+
+/*
+ -- Groups
+*/
+INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', '', 1);
+INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (2, 1, 'Admin', 'Personal User', '', 1);
+
+
+/*
+ -- User -> Group
+*/
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, '');
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, '');
+
+
+/*
+ -- Demo Topic
+*/
+SET IDENTITY_INSERT phpbb_topics ON;
+
+INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_type, topic_vote, topic_last_post_id, topic_moved_id) VALUES (1, 1, 'Welcome to phpBB 2', 2, 972086460, '', '', '', '', '', 1, '');
+
+SET IDENTITY_INSERT phpbb_topics OFF;
+
+/*
+ -- Demo Post
+*/
+SET IDENTITY_INSERT phpbb_posts ON;
+
+INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, bbcode_uid, post_edit_time, post_edit_count) VALUES (1, 1, 1, 2, 972086460, '7F000001', '', 1, '', 1, '', '', '', '');
+
+INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, '', 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
+
+SET IDENTITY_INSERT phpbb_posts OFF;
+
+/*
+ -- Themes
+*/
+SET IDENTITY_INSERT phpbb_themes ON;
+
+INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1,'subSilver','subSilver','','','E5E5E5','000000','006699','5584AA','FF9933','EDF2F2','EFEFEF','DEE3E7','c2cdd6','','','','CBD3D9','BCBCBC','1B7CAD','','','','AEBDC4','006699','FFFFFF','row1','row2','','Verdana,Arial,Helvetica,sans-serif','Verdana,Arial,Helvetica,sans-serif','courier','','','','004c75','004c75','004c75','','','');
+
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (2,'PSO [ Wheat ] ','PSO','','','FFFFFF','000000','002266','004411','','','','','','','','','001100','E5CCA5','D4A294','','','','EBE4D9','DAD1C4','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (3,'PSO [ Ocean ]','PSO','','','DFF5FF','000000','011001','2100cc','','','','','','','','','000000','A7C1CB','7897A8','','','','83D7CC','A0CCE0','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (4,'PSO [ Blue ]','PSO','','','FFFFFF','000000','417FB9','4E6172','0000AA','','','','','','','','000000','90BAE2','5195D4','','','','cde3f2','daedFd','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (5,'PSO [ Cool Midnight ]','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (6,'PSO [ Pastel Purple ]','PSO','','','FFFFFF','000000','445588','337744','','','','','','','','','CCCCDD','CCCCDD','DDDDEE','','','','EFEFEF','FEFEFE','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',1,2,3,'','','0000EE','','','');
+
+SET IDENTITY_INSERT phpbb_themes OFF;
+
+/*
+ -- Smilies
+*/
+SET IDENTITY_INSERT phpbb_smilies ON;
+
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '2', ':-D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '3', ':grin:', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '4', ':)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '5', ':-)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '6', ':smile:', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '7', ':(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '8', ':-(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '9', ':sad:', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '10', ':o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '11', ':-o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '12', ':eek:', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '13', ':?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '14', ':-?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '15', ':???:', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '16', '8)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '17', '8-)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '18', ':cool:', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '19', ':lol:', 'icon_lol.gif', 'Laughing');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '20', ':x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '21', ':-x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '22', ':mad:', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '23', ':P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '24', ':-P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '25', ':razz:', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '26', ':oops:', 'icon_redface.gif', 'Embarassed');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '27', ':cry:', 'icon_cry.gif', 'Crying or Very sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '28', ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '29', ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '30', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '31', ':wink:', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '32', ';)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '33', ';-)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '34', ':!:', 'icon_exclaim.gif', 'Exclamation');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '35', ':?:', 'icon_question.gif', 'Question');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '36', ':idea:', 'icon_idea.gif', 'Idea');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', ':arrow:', 'icon_arrow.gif', 'Arrow');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':-|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':neutral:', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '41', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
+
+SET IDENTITY_INSERT phpbb_smilies OFF;
+
+COMMIT;
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql
new file mode 100644
index 0000000000..8cc34abcdb
--- /dev/null
+++ b/phpBB/db/schemas/mssql_schema.sql
@@ -0,0 +1,775 @@
+/*
+
+ mssql_schema.sql for phpBB2 (c) 2001, phpBB Group
+
+ $Id$
+
+*/
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_user_group_phpbb_groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_user_group] DROP CONSTRAINT FK_phpbb_user_group_phpbb_groups
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_posts_text_phpbb_posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_posts_text] DROP CONSTRAINT FK_phpbb_posts_text_phpbb_posts
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_privmsgs_text_phpbb_privmsgs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_privmsgs_text] DROP CONSTRAINT FK_phpbb_privmsgs_text_phpbb_privmsgs
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_themes_name_phpbb_themes]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_themes_name] DROP CONSTRAINT FK_phpbb_themes_name_phpbb_themes
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_topics_watch_phpbb_topics]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_topics_watch] DROP CONSTRAINT FK_phpbb_topics_watch_phpbb_topics
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_topics_watch_phpbb_users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_topics_watch] DROP CONSTRAINT FK_phpbb_topics_watch_phpbb_users
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[FK_phpbb_user_group_phpbb_users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
+ALTER TABLE [phpbb_user_group] DROP CONSTRAINT FK_phpbb_user_group_phpbb_users
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_auth_access]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_auth_access]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_banlist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_banlist]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_categories]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_config]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_disallow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_disallow]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_forum_prune]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_forum_prune]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_forums]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_groups]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_posts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_posts]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_posts_text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_posts_text]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_privmsgs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_privmsgs]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_privmsgs_text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_privmsgs_text]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_ranks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_ranks]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_session]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_session]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_smilies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_smilies]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_themes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_themes]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_themes_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_themes_name]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_topics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_topics]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_topics_watch]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_topics_watch]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_user_group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_user_group]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_users]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_vote_desc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_vote_desc]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_vote_results]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_vote_results]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_vote_voters]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_vote_voters]
+GO
+
+if exists (select * from sysobjects where id = object_id(N'[phpbb_words]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+drop table [phpbb_words]
+GO
+
+CREATE TABLE [phpbb_auth_access] (
+ [group_id] [int] NULL ,
+ [forum_id] [int] NULL ,
+ [auth_view] [smallint] NOT NULL ,
+ [auth_read] [smallint] NOT NULL ,
+ [auth_post] [smallint] NOT NULL ,
+ [auth_reply] [smallint] NOT NULL ,
+ [auth_edit] [smallint] NOT NULL ,
+ [auth_delete] [smallint] NOT NULL ,
+ [auth_sticky] [smallint] NOT NULL ,
+ [auth_announce] [smallint] NOT NULL ,
+ [auth_vote] [smallint] NOT NULL ,
+ [auth_pollcreate] [smallint] NOT NULL ,
+ [auth_attachments] [smallint] NOT NULL ,
+ [auth_mod] [smallint] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_banlist] (
+ [ban_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [ban_userid] [int] NULL ,
+ [ban_ip] [char] (8) NULL ,
+ [ban_email] [varchar] (50) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_categories] (
+ [cat_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [cat_title] [varchar] (50) NOT NULL ,
+ [cat_order] [int] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_config] (
+ [config_name] [varchar] (255) NULL ,
+ [config_value] [varchar] (255) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_disallow] (
+ [disallow_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [disallow_username] [varchar] (100) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_forum_prune] (
+ [prune_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [forum_id] [int] NOT NULL ,
+ [prune_days] [int] NOT NULL ,
+ [prune_freq] [int] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_forums] (
+ [forum_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [cat_id] [int] NOT NULL ,
+ [forum_name] [varchar] (100) NOT NULL ,
+ [forum_desc] [varchar] (255) NULL ,
+ [forum_status] [smallint] NOT NULL ,
+ [forum_order] [int] NOT NULL ,
+ [forum_posts] [int] NOT NULL ,
+ [forum_topics] [smallint] NOT NULL ,
+ [forum_last_post_id] [int] NOT NULL ,
+ [prune_next] [int] NULL ,
+ [prune_enable] [smallint] NOT NULL ,
+ [auth_view] [smallint] NOT NULL ,
+ [auth_read] [smallint] NOT NULL ,
+ [auth_post] [smallint] NOT NULL ,
+ [auth_reply] [smallint] NOT NULL ,
+ [auth_edit] [smallint] NOT NULL ,
+ [auth_delete] [smallint] NOT NULL ,
+ [auth_sticky] [smallint] NOT NULL ,
+ [auth_announce] [smallint] NOT NULL ,
+ [auth_vote] [smallint] NOT NULL ,
+ [auth_pollcreate] [smallint] NOT NULL ,
+ [auth_attachments] [smallint] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_groups] (
+ [group_id] [int] NOT NULL ,
+ [group_type] [smallint] NULL ,
+ [group_name] [varchar] (50) NOT NULL ,
+ [group_description] [varchar] (255) NOT NULL ,
+ [group_moderator] [int] NULL ,
+ [group_single_user] [smallint] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_posts] (
+ [post_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [topic_id] [int] NOT NULL ,
+ [forum_id] [int] NOT NULL ,
+ [poster_id] [int] NOT NULL ,
+ [post_time] [int] NOT NULL ,
+ [poster_ip] [char] (8) NULL ,
+ [post_username] [varchar] (50) NULL ,
+ [enable_bbcode] [smallint] NULL ,
+ [enable_html] [smallint] NULL ,
+ [enable_smilies] [smallint] NULL ,
+ [enable_sig] [smallint] NULL ,
+ [bbcode_uid] [char] (10) NULL ,
+ [post_edit_time] [int] NULL ,
+ [post_edit_count] [smallint] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_posts_text] (
+ [post_id] [int] NOT NULL ,
+ [post_subject] [varchar] (100) NULL ,
+ [post_text] [text] NULL
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_privmsgs] (
+ [privmsgs_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [privmsgs_type] [smallint] NOT NULL ,
+ [privmsgs_subject] [varchar] (100) NOT NULL ,
+ [privmsgs_from_userid] [int] NOT NULL ,
+ [privmsgs_to_userid] [int] NOT NULL ,
+ [privmsgs_date] [int] NOT NULL ,
+ [privmsgs_ip] [char] (8) NOT NULL ,
+ [privmsgs_enable_bbcode] [smallint] NULL ,
+ [privmsgs_enable_html] [smallint] NULL ,
+ [privmsgs_enable_smilies] [smallint] NULL ,
+ [privmsgs_attach_sig] [smallint] NULL ,
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_privmsgs_text] (
+ [privmsgs_text_id] [int] NOT NULL ,
+ [privmsgs_bbcode_uid] [char] (10) NULL
+ [privmsgs_text] [text] NULL
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_ranks] (
+ [rank_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [rank_title] [varchar] (50) NOT NULL ,
+ [rank_min] [int] NULL ,
+ [rank_max] [int] NULL ,
+ [rank_special] [smallint] NULL ,
+ [rank_image] [varchar] (50) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_session] (
+ [session_id] [char] (32) NOT NULL ,
+ [session_user_id] [int] NOT NULL ,
+ [session_start] [int] NULL ,
+ [session_time] [int] NULL ,
+ [session_last_visit] [int] NULL ,
+ [session_ip] [char] (8) NOT NULL ,
+ [session_page] [int] NULL ,
+ [session_logged_in] [smallint] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_smilies] (
+ [smilies_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [code] [varchar] (10) NOT NULL ,
+ [smile_url] [varchar] (50) NOT NULL ,
+ [emoticon] [varchar] (50) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_themes] (
+ [themes_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [style_name] [varchar] (50) NOT NULL ,
+ [head_stylesheet] [varchar] (50) NULL ,
+ [body_background] [varchar] (50) NULL ,
+ [body_bgcolor] [char] (6) NULL ,
+ [body_text] [char] (6) NULL ,
+ [body_link] [char] (6) NULL ,
+ [body_vlink] [char] (6) NULL ,
+ [body_alink] [char] (6) NULL ,
+ [body_hlink] [char] (6) NULL ,
+ [tr_color1] [char] (6) NULL ,
+ [tr_color2] [char] (6) NULL ,
+ [tr_color3] [char] (6) NULL ,
+ [tr_class1] [varchar] (25) NULL ,
+ [tr_class2] [varchar] (25) NULL ,
+ [tr_class3] [varchar] (25) NULL ,
+ [th_color1] [char] (6) NULL ,
+ [th_color2] [char] (6) NULL ,
+ [th_color3] [char] (6) NULL ,
+ [th_class1] [varchar] (25) NULL ,
+ [th_class2] [varchar] (25) NULL ,
+ [th_class3] [varchar] (25) NULL ,
+ [td_color1] [char] (6) NULL ,
+ [td_color2] [char] (6) NULL ,
+ [td_color3] [char] (6) NULL ,
+ [td_class1] [varchar] (25) NULL ,
+ [td_class2] [varchar] (25) NULL ,
+ [td_class3] [varchar] (25) NULL ,
+ [fontface1] [varchar] (50) NULL ,
+ [fontface2] [varchar] (50) NULL ,
+ [fontface3] [varchar] (50) NULL ,
+ [fontsize1] [smallint] NULL ,
+ [fontsize2] [smallint] NULL ,
+ [fontsize3] [smallint] NULL ,
+ [fontcolor1] [char] (6) NULL ,
+ [fontcolor2] [char] (6) NULL ,
+ [fontcolor3] [char] (6) NULL ,
+ [span_class1] [varchar] (25) NULL ,
+ [span_class2] [varchar] (25) NULL ,
+ [span_class3] [varchar] (25) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_themes_name] (
+ [themes_id] [int] NOT NULL ,
+ [tr_color1_name] [varchar] (25) NULL ,
+ [tr_color2_name] [varchar] (25) NULL ,
+ [tr_color3_name] [varchar] (25) NULL ,
+ [tr_class1_name] [varchar] (25) NULL ,
+ [tr_class2_name] [varchar] (25) NULL ,
+ [tr_class3_name] [varchar] (25) NULL ,
+ [th_color1_name] [varchar] (25) NULL ,
+ [th_color2_name] [varchar] (25) NULL ,
+ [th_color3_name] [varchar] (25) NULL ,
+ [th_class1_name] [varchar] (25) NULL ,
+ [th_class2_name] [varchar] (25) NULL ,
+ [th_class3_name] [varchar] (25) NULL ,
+ [td_color1_name] [varchar] (25) NULL ,
+ [td_color2_name] [varchar] (25) NULL ,
+ [td_color3_name] [varchar] (25) NULL ,
+ [td_class1_name] [varchar] (25) NULL ,
+ [td_class2_name] [varchar] (25) NULL ,
+ [td_class3_name] [varchar] (25) NULL ,
+ [fontface1_name] [varchar] (25) NULL ,
+ [fontface2_name] [varchar] (25) NULL ,
+ [fontface3_name] [varchar] (25) NULL ,
+ [fontsize1_name] [varchar] (25) NULL ,
+ [fontsize2_name] [varchar] (25) NULL ,
+ [fontsize3_name] [varchar] (25) NULL ,
+ [fontcolor1_name] [varchar] (25) NULL ,
+ [fontcolor2_name] [varchar] (25) NULL ,
+ [fontcolor3_name] [varchar] (25) NULL ,
+ [span_class1_name] [varchar] (25) NULL ,
+ [span_class2_name] [varchar] (25) NULL ,
+ [span_class3_name] [varchar] (25) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_topics] (
+ [topic_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [forum_id] [int] NOT NULL ,
+ [topic_title] [varchar] (100) NOT NULL ,
+ [topic_poster] [int] NOT NULL ,
+ [topic_time] [int] NOT NULL ,
+ [topic_views] [int] NOT NULL ,
+ [topic_replies] [int] NOT NULL ,
+ [topic_status] [smallint] NOT NULL ,
+ [topic_type] [smallint] NOT NULL ,
+ [topic_vote] [smallint] NOT NULL ,
+ [topic_last_post_id] [int] NULL ,
+ [topic_moved_id] [int] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_topics_watch] (
+ [topic_id] [int] NOT NULL ,
+ [user_id] [int] NOT NULL ,
+ [notify_status] [smallint] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_user_group] (
+ [group_id] [int] NOT NULL ,
+ [user_id] [int] NOT NULL ,
+ [user_pending] [smallint] NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_users] (
+ [user_id] [int] NOT NULL ,
+ [user_active] [smallint] NULL ,
+ [username] [varchar] (40) NOT NULL ,
+ [user_password] [char] (32) NULL ,
+ [user_autologin_key] [char] (32) NULL ,
+ [user_level] [smallint] NULL ,
+ [user_posts] [int] NOT NULL ,
+ [user_timezone] [int] NOT NULL ,
+ [user_dateformat] [varchar] (15) NOT NULL ,
+ [user_style] [int] NULL ,
+ [user_lang] [varchar] (50) NULL ,
+ [user_viewemail] [smallint] NULL ,
+ [user_attachsig] [smallint] NULL ,
+ [user_allowhtml] [smallint] NULL ,
+ [user_allowbbcode] [smallint] NULL ,
+ [user_allowsmile] [smallint] NULL ,
+ [user_allowavatar] [smallint] NOT NULL ,
+ [user_allow_pm] [smallint] NOT NULL ,
+ [user_allow_viewonline] [smallint] NOT NULL ,
+ [user_notify] [smallint] NOT NULL ,
+ [user_notify_pm] [smallint] NOT NULL ,
+ [user_regdate] [int] NOT NULL ,
+ [user_rank] [int] NULL ,
+ [user_avatar] [varchar] (100) NULL ,
+ [user_avatar_type] [smallint] NOT NULL,
+ [user_email] [varchar] (25) NULL ,
+ [user_icq] [varchar] (15) NULL ,
+ [user_website] [varchar] (50) NULL ,
+ [user_from] [varchar] (200) NULL ,
+ [user_sig] [text] NULL ,
+ [user_sig_bbcode_uid] [char] (10) NULL,
+ [user_aim] [varchar] (50) NULL ,
+ [user_yim] [varchar] (50) NULL ,
+ [user_msnm] [varchar] (50) NULL ,
+ [user_occ] [varchar] (255) NULL ,
+ [user_interests] [varchar] (255) NULL ,
+ [user_actkey] [char] (32) NULL ,
+ [user_newpasswd] [char] (32) NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_vote_desc] (
+ [vote_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [topic_id] [int] NOT NULL ,
+ [vote_text] [varchar] (255) NOT NULL ,
+ [vote_start] [int] NOT NULL ,
+ [vote_length] [int] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_vote_results] (
+ [vote_id] [int] NOT NULL ,
+ [vote_option_id] [int] NOT NULL ,
+ [vote_option_text] [varchar] (255) NOT NULL ,
+ [vote_result] [int] NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_vote_voters] (
+ [vote_id] [int] NOT NULL ,
+ [vote_user_id] [int] NOT NULL ,
+ [vote_user_ip] [char] (8) NOT NULL
+) ON [PRIMARY]
+GO
+
+CREATE TABLE [phpbb_words] (
+ [word_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [word] [varchar] (255) NOT NULL ,
+ [replacement] [varchar] (255) NOT NULL
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED
+ (
+ [ban_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_categories] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_categories] PRIMARY KEY CLUSTERED
+ (
+ [cat_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED
+ (
+ [disallow_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_forum_prune] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_forum_prune] PRIMARY KEY CLUSTERED
+ (
+ [prune_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED
+ (
+ [forum_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED
+ (
+ [group_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED
+ (
+ [post_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED
+ (
+ [privmsgs_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_privmsgs_text] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_privmsgs_text] PRIMARY KEY CLUSTERED
+ (
+ [privmsgs_text_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED
+ (
+ [rank_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED
+ (
+ [smilies_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_themes] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_themes] PRIMARY KEY CLUSTERED
+ (
+ [themes_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_themes_name] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_themes_name] PRIMARY KEY CLUSTERED
+ (
+ [themes_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED
+ (
+ [topic_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_users] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED
+ (
+ [user_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_vote_desc] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_vote_desc] PRIMARY KEY CLUSTERED
+ (
+ [vote_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_words] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED
+ (
+ [word_id]
+ ) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_auth_access] WITH NOCHECK ADD
+ CONSTRAINT [DF_phpbb_auth_access_auth_view] DEFAULT (0) FOR [auth_view],
+ CONSTRAINT [DF_phpbb_auth_access_auth_read] DEFAULT (0) FOR [auth_read],
+ CONSTRAINT [DF_phpbb_auth_access_auth_post] DEFAULT (0) FOR [auth_post],
+ CONSTRAINT [DF_phpbb_auth_access_auth_reply] DEFAULT (0) FOR [auth_reply],
+ CONSTRAINT [DF_phpbb_auth_access_auth_edit] DEFAULT (0) FOR [auth_edit],
+ CONSTRAINT [DF_phpbb_auth_access_auth_delete] DEFAULT (0) FOR [auth_delete],
+ CONSTRAINT [DF_phpbb_auth_access_auth_sticky] DEFAULT (0) FOR [auth_sticky],
+ CONSTRAINT [DF_phpbb_auth_access_auth_announce] DEFAULT (0) FOR [auth_announce],
+ CONSTRAINT [DF_phpbb_auth_access_auth_vote] DEFAULT (0) FOR [auth_vote],
+ CONSTRAINT [DF_phpbb_auth_access_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate],
+ CONSTRAINT [DF_phpbb_auth_access_auth_attachments] DEFAULT (0) FOR [auth_attachments],
+ CONSTRAINT [DF_phpbb_auth_access_auth_mod] DEFAULT (0) FOR [auth_mod]
+GO
+
+ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
+ CONSTRAINT [DF_phpbb_forums_forum_posts] DEFAULT (0) FOR [forum_posts],
+ CONSTRAINT [DF_phpbb_forums_forum_topics] DEFAULT (0) FOR [forum_topics],
+ CONSTRAINT [DF_phpbb_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id],
+ CONSTRAINT [DF_phpbb_forums_prune_enable] DEFAULT (0) FOR [prune_enable],
+ CONSTRAINT [DF_phpbb_forums_auth_view] DEFAULT (0) FOR [auth_view],
+ CONSTRAINT [DF_phpbb_forums_auth_read] DEFAULT (0) FOR [auth_read],
+ CONSTRAINT [DF_phpbb_forums_auth_post] DEFAULT (0) FOR [auth_post],
+ CONSTRAINT [DF_phpbb_forums_auth_reply] DEFAULT (0) FOR [auth_reply],
+ CONSTRAINT [DF_phpbb_forums_auth_edit] DEFAULT (0) FOR [auth_edit],
+ CONSTRAINT [DF_phpbb_forums_auth_delete] DEFAULT (0) FOR [auth_delete],
+ CONSTRAINT [DF_phpbb_forums_auth_sticky] DEFAULT (0) FOR [auth_sticky],
+ CONSTRAINT [DF_phpbb_forums_auth_announce] DEFAULT (0) FOR [auth_announce],
+ CONSTRAINT [DF_phpbb_forums_auth_vote] DEFAULT (0) FOR [auth_vote],
+ CONSTRAINT [DF_phpbb_forums_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate],
+ CONSTRAINT [DF_phpbb_forums_auth_attachments] DEFAULT (0) FOR [auth_attachments]
+GO
+
+ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
+ CONSTRAINT [DF_phpbb_topics_topic_views] DEFAULT (0) FOR [topic_views],
+ CONSTRAINT [DF_phpbb_topics_topic_replies] DEFAULT (0) FOR [topic_replies],
+ CONSTRAINT [DF_phpbb_topics_topic_status] DEFAULT (0) FOR [topic_status],
+ CONSTRAINT [DF_phpbb_topics_topic_type] DEFAULT (0) FOR [topic_type],
+ CONSTRAINT [DF_phpbb_topics_topic_vote] DEFAULT (0) FOR [topic_vote]
+GO
+
+ALTER TABLE [phpbb_users] WITH NOCHECK ADD
+ CONSTRAINT [DF_phpbb_users_user_posts] DEFAULT (0) FOR [user_posts],
+ CONSTRAINT [DF_phpbb_users_user_viewemail] DEFAULT (1) FOR [user_viewemail],
+ CONSTRAINT [DF_phpbb_users_user_attachsig] DEFAULT (1) FOR [user_attachsig],
+ CONSTRAINT [DF_phpbb_users_user_allowhtml] DEFAULT (0) FOR [user_allowhtml],
+ CONSTRAINT [DF_phpbb_users_user_allowbbcode] DEFAULT (1) FOR [user_allowbbcode],
+ CONSTRAINT [DF_phpbb_users_user_allowsmile] DEFAULT (1) FOR [user_allowsmile],
+ CONSTRAINT [DF_phpbb_users_user_allowavatar] DEFAULT (1) FOR [user_allowavatar],
+ CONSTRAINT [DF_phpbb_users_user_allow_pm] DEFAULT (1) FOR [user_allow_pm],
+ CONSTRAINT [DF_phpbb_users_user_allow_viewonline] DEFAULT (1) FOR [user_allow_viewonline],
+ CONSTRAINT [DF_phpbb_users_user_notify] DEFAULT (1) FOR [user_notify],
+ CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (1) FOR [user_notify_pm],
+ CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type]
+GO
+
+ CREATE INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access]([group_id], [forum_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_banlist] ON [phpbb_banlist]([ban_userid], [ban_ip]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_categories] ON [phpbb_categories]([cat_order]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_forum_prune] ON [phpbb_forum_prune]([forum_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_forums] ON [phpbb_forums]([cat_id], [forum_order], [forum_last_post_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_groups] ON [phpbb_groups]([group_single_user]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_posts] ON [phpbb_posts]([topic_id], [forum_id], [poster_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_posts_text] ON [phpbb_posts_text]([post_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs]([privmsgs_from_userid], [privmsgs_to_userid]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_max], [rank_special]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_session] ON [phpbb_session]([session_id], [session_user_id], [session_ip], [session_logged_in]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_topics] ON [phpbb_topics]([forum_id], [topic_type], [topic_last_post_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch]([topic_id], [user_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_users] ON [phpbb_users]([user_level]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_vote_desc] ON [phpbb_vote_desc]([topic_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_vote_results] ON [phpbb_vote_results]([vote_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_vote_results_1] ON [phpbb_vote_results]([vote_option_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_vote_voters] ON [phpbb_vote_voters]([vote_id]) ON [PRIMARY]
+GO
+
+ CREATE INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters]([vote_user_id]) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_posts_text] ADD
+ CONSTRAINT [FK_phpbb_posts_text_phpbb_posts] FOREIGN KEY
+ (
+ [post_id]
+ ) REFERENCES [phpbb_posts] (
+ [post_id]
+ )
+GO
+
+ALTER TABLE [phpbb_privmsgs_text] ADD
+ CONSTRAINT [FK_phpbb_privmsgs_text_phpbb_privmsgs] FOREIGN KEY
+ (
+ [privmsgs_text_id]
+ ) REFERENCES [phpbb_privmsgs] (
+ [privmsgs_id]
+ )
+GO
+
+ALTER TABLE [phpbb_themes_name] ADD
+ CONSTRAINT [FK_phpbb_themes_name_phpbb_themes] FOREIGN KEY
+ (
+ [themes_id]
+ ) REFERENCES [phpbb_themes] (
+ [themes_id]
+ )
+GO
+
+ALTER TABLE [phpbb_topics_watch] ADD
+ CONSTRAINT [FK_phpbb_topics_watch_phpbb_topics] FOREIGN KEY
+ (
+ [topic_id]
+ ) REFERENCES [phpbb_topics] (
+ [topic_id]
+ ),
+ CONSTRAINT [FK_phpbb_topics_watch_phpbb_users] FOREIGN KEY
+ (
+ [user_id]
+ ) REFERENCES [phpbb_users] (
+ [user_id]
+ )
+GO
+
+ALTER TABLE [phpbb_user_group] ADD
+ CONSTRAINT [FK_phpbb_user_group_phpbb_groups] FOREIGN KEY
+ (
+ [group_id]
+ ) REFERENCES [phpbb_groups] (
+ [group_id]
+ ),
+ CONSTRAINT [FK_phpbb_user_group_phpbb_users] FOREIGN KEY
+ (
+ [user_id]
+ ) REFERENCES [phpbb_users] (
+ [user_id]
+ )
+GO
diff --git a/phpBB/db/schemas/mysql_basic.sql b/phpBB/db/schemas/mysql_basic.sql
new file mode 100644
index 0000000000..86b229bcd8
--- /dev/null
+++ b/phpBB/db/schemas/mysql_basic.sql
@@ -0,0 +1,147 @@
+#
+# Basic DB data for phpBB2 devel
+#
+# $Id$
+
+# -- Config
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','900');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_admin_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
+
+
+# -- Categories
+INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
+
+
+# -- Forums
+INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 1, 1, 1, 3);
+
+# -- Users
+INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( '-1', 'Anonymous', '0', '', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '0', '0', '1', '', '', '', '', '', '', '', '', '0', '0');
+
+# username: admin password: admin (change this or remove it once everything is working!)
+INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( '2', 'Admin', '1', '', '', '', 'admin@yourdomain.com', '', '', '', '', '', '', '1', '1', '', '', '', '1', '0', '1', '0', '1', '1', '1', '1', '1', '', '', '0', 'd M Y h:i a', '', '', '0', '1');
+
+
+# -- Ranks
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '-1', '1', '');
+
+# -- Groups
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
+
+
+# -- User -> Group
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
+
+
+# -- Demo Topic
+INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1);
+
+
+# -- Demo Post
+INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, '972086460', '', '7F000001');
+INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, '', 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
+
+
+# -- Themes
+INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1,'subSilver','subSilver','','','E5E5E5','000000','006699','5584AA','FF9933','EDF2F2','EFEFEF','DEE3E7','c2cdd6','','','','CBD3D9','BCBCBC','1B7CAD','','','','AEBDC4','006699','FFFFFF','row1','row2','','Verdana,Arial,Helvetica,sans-serif','Verdana,Arial,Helvetica,sans-serif','courier','','','','004c75','004c75','004c75','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (2,'PSO [ Wheat ] ','PSO','','','FFFFFF','000000','002266','004411','','','','','','','','','001100','E5CCA5','D4A294','','','','EBE4D9','DAD1C4','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (3,'PSO [ Ocean ]','PSO','','','DFF5FF','000000','011001','2100cc','','','','','','','','','000000','A7C1CB','7897A8','','','','83D7CC','A0CCE0','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (4,'PSO [ Blue ]','PSO','','','FFFFFF','000000','417FB9','4E6172','0000AA','','','','','','','','000000','90BAE2','5195D4','','','','cde3f2','daedFd','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (5,'PSO [ Cool Midnight ]','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (6,'PSO [ Pastel Purple ]','PSO','','','FFFFFF','000000','445588','337744','','','','','','','','','CCCCDD','CCCCDD','DDDDEE','','','','EFEFEF','FEFEFE','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',1,2,3,'','','0000EE','','','');
+
+
+# -- Smilies
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '2', ':-D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '3', ':grin:', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '4', ':)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '5', ':-)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '6', ':smile:', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '7', ':(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '8', ':-(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '9', ':sad:', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '10', ':o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '11', ':-o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '12', ':eek:', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '13', ':?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '14', ':-?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '15', ':???:', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '16', '8)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '17', '8-)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '18', ':cool:', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '19', ':lol:', 'icon_lol.gif', 'Laughing');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '20', ':x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '21', ':-x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '22', ':mad:', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '23', ':P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '24', ':-P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '25', ':razz:', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '26', ':oops:', 'icon_redface.gif', 'Embarassed');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '27', ':cry:', 'icon_cry.gif', 'Crying or Very sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '28', ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '29', ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '30', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '31', ':wink:', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '32', ';)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '33', ';-)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '34', ':!:', 'icon_exclaim.gif', 'Exclamation');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '35', ':?:', 'icon_question.gif', 'Question');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '36', ':idea:', 'icon_idea.gif', 'Idea');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', ':arrow:', 'icon_arrow.gif', 'Arrow');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':-|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':neutral:', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '41', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql
new file mode 100644
index 0000000000..8c417f2451
--- /dev/null
+++ b/phpBB/db/schemas/mysql_schema.sql
@@ -0,0 +1,584 @@
+#
+# phpBB2 - MySQL schema
+#
+# $Id$
+#
+
+#
+# Table structure for table 'phpbb_auth_access'
+#
+DROP TABLE IF EXISTS phpbb_auth_access;
+CREATE TABLE phpbb_auth_access (
+ group_id int(11) DEFAULT '0' NOT NULL,
+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ auth_view tinyint(1) DEFAULT '0' NOT NULL,
+ auth_read tinyint(1) DEFAULT '0' NOT NULL,
+ auth_post tinyint(1) DEFAULT '0' NOT NULL,
+ auth_reply tinyint(1) DEFAULT '0' NOT NULL,
+ auth_edit tinyint(1) DEFAULT '0' NOT NULL,
+ auth_delete tinyint(1) DEFAULT '0' NOT NULL,
+ auth_sticky tinyint(1) DEFAULT '0' NOT NULL,
+ auth_announce tinyint(1) DEFAULT '0' NOT NULL,
+ auth_vote tinyint(1) DEFAULT '0' NOT NULL,
+ auth_pollcreate tinyint(1) DEFAULT '0' NOT NULL,
+ auth_attachments tinyint(1) DEFAULT '0' NOT NULL,
+ auth_mod tinyint(1) DEFAULT '0' NOT NULL,
+ KEY group_id (group_id),
+ KEY forum_id (forum_id)
+);
+
+
+#
+# Table structure for table 'phpbb_user_group'
+#
+DROP TABLE IF EXISTS phpbb_user_group;
+CREATE TABLE phpbb_user_group (
+ group_id int(11) DEFAULT '0' NOT NULL,
+ user_id int(11) DEFAULT '0' NOT NULL,
+ user_pending tinyint(1),
+ KEY group_id (group_id),
+ KEY user_id (user_id)
+);
+
+#
+# Table structure for table 'phpbb_groups'
+#
+DROP TABLE IF EXISTS phpbb_groups;
+CREATE TABLE phpbb_groups (
+ group_id int(11) NOT NULL auto_increment,
+ group_type tinyint(4) DEFAULT '1' NOT NULL,
+ group_name varchar(40) NOT NULL,
+ group_description varchar(255) NOT NULL,
+ group_moderator int(11) DEFAULT '0' NOT NULL,
+ group_single_user tinyint(1) DEFAULT '1' NOT NULL,
+ PRIMARY KEY (group_id),
+ KEY group_single_user (group_single_user)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_banlist'
+#
+DROP TABLE IF EXISTS phpbb_banlist;
+CREATE TABLE phpbb_banlist (
+ ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ ban_userid int(11) NOT NULL,
+ ban_ip char(8) NOT NULL,
+ ban_email varchar(255),
+ PRIMARY KEY (ban_id),
+ KEY ban_ip_user_id (ban_ip, ban_userid)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_categories'
+#
+DROP TABLE IF EXISTS phpbb_categories;
+CREATE TABLE phpbb_categories (
+ cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ cat_title varchar(100),
+ cat_order mediumint(8) UNSIGNED NOT NULL,
+ PRIMARY KEY (cat_id),
+ KEY cat_order (cat_order)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_config'
+#
+DROP TABLE IF EXISTS phpbb_config;
+CREATE TABLE phpbb_config (
+ config_name varchar(255) NOT NULL,
+ config_value varchar(255) NOT NULL,
+ PRIMARY KEY (config_name)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_disallow'
+#
+DROP TABLE IF EXISTS phpbb_disallow;
+CREATE TABLE phpbb_disallow (
+ disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ disallow_username varchar(25),
+ PRIMARY KEY (disallow_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_forum_prune'
+#
+DROP TABLE IF EXISTS phpbb_forum_prune;
+CREATE TABLE phpbb_forum_prune (
+ prune_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ forum_id mediumint(8) UNSIGNED NOT NULL,
+ prune_days tinyint(4) UNSIGNED NOT NULL,
+ prune_freq tinyint(4) UNSIGNED NOT NULL,
+ PRIMARY KEY(prune_id),
+ KEY forum_id (forum_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_forums'
+#
+DROP TABLE IF EXISTS phpbb_forums;
+CREATE TABLE phpbb_forums (
+ forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ cat_id mediumint(8) UNSIGNED NOT NULL,
+ forum_name varchar(150),
+ forum_desc text,
+ forum_status tinyint(4) DEFAULT '0' NOT NULL,
+ forum_order mediumint(8) UNSIGNED DEFAULT '1' NOT NULL,
+ forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ prune_next int(11),
+ prune_enable tinyint(1) DEFAULT '1' NOT NULL,
+ auth_view tinyint(2) DEFAULT '0' NOT NULL,
+ auth_read tinyint(2) DEFAULT '0' NOT NULL,
+ auth_post tinyint(2) DEFAULT '0' NOT NULL,
+ auth_reply tinyint(2) DEFAULT '0' NOT NULL,
+ auth_edit tinyint(2) DEFAULT '0' NOT NULL,
+ auth_delete tinyint(2) DEFAULT '0' NOT NULL,
+ auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
+ auth_announce tinyint(2) DEFAULT '0' NOT NULL,
+ auth_vote tinyint(2) DEFAULT '0' NOT NULL,
+ auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
+ auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
+ PRIMARY KEY (forum_id),
+ KEY forums_order (forum_order),
+ KEY cat_id (cat_id),
+ KEY forum_last_post_id (forum_last_post_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_posts'
+#
+DROP TABLE IF EXISTS phpbb_posts;
+CREATE TABLE phpbb_posts (
+ post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ poster_id int(11) DEFAULT '0' NOT NULL,
+ post_time int(11) DEFAULT '0' NOT NULL,
+ poster_ip char(8) NOT NULL,
+ post_username varchar(30),
+ enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
+ enable_html tinyint(1) DEFAULT '0' NOT NULL,
+ enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
+ enable_sig tinyint(1) DEFAULT '1' NOT NULL,
+ bbcode_uid char(10) NOT NULL,
+ post_edit_time int(11),
+ post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
+ PRIMARY KEY (post_id),
+ KEY forum_id (forum_id),
+ KEY topic_id (topic_id),
+ KEY poster_id (poster_id),
+ KEY post_time (post_time)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_posts_text'
+#
+DROP TABLE IF EXISTS phpbb_posts_text;
+CREATE TABLE phpbb_posts_text (
+ post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ post_subject varchar(255),
+ post_text text,
+ PRIMARY KEY (post_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_privmsgs'
+#
+DROP TABLE IF EXISTS phpbb_privmsgs;
+CREATE TABLE phpbb_privmsgs (
+ privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
+ privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
+ privmsgs_from_userid int(11) DEFAULT '0' NOT NULL,
+ privmsgs_to_userid int(11) DEFAULT '0' NOT NULL,
+ privmsgs_date int(11) DEFAULT '0' NOT NULL,
+ privmsgs_ip char(8) NOT NULL,
+ privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
+ privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
+ privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
+ privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL,
+ PRIMARY KEY (privmsgs_id),
+ KEY privmsgs_from_userid (privmsgs_from_userid),
+ KEY privmsgs_to_userid (privmsgs_to_userid)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_privmsgs_text'
+#
+DROP TABLE IF EXISTS phpbb_privmsgs_text;
+CREATE TABLE phpbb_privmsgs_text (
+ privmsgs_text_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
+ privmsgs_text text,
+ PRIMARY KEY (privmsgs_text_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_ranks'
+#
+DROP TABLE IF EXISTS phpbb_ranks;
+CREATE TABLE phpbb_ranks (
+ rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
+ rank_title varchar(50) NOT NULL,
+ rank_min mediumint(8) DEFAULT '0' NOT NULL,
+ rank_max mediumint(8) DEFAULT '0' NOT NULL,
+ rank_special tinyint(1) DEFAULT '0',
+ rank_image varchar(255),
+ PRIMARY KEY (rank_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table `phpbb_search_results`
+#
+DROP TABLE IF EXISTS phpbb_search_results;
+CREATE TABLE phpbb_search_results (
+ search_id mediumint(8) UNSIGNED NOT NULL default '0',
+ session_id char(32) NOT NULL default '',
+ search_array text NOT NULL,
+ PRIMARY KEY (search_id),
+ KEY session_id (session_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table `phpbb_search_wordlist`
+#
+DROP TABLE IF EXISTS phpbb_search_wordlist;
+CREATE TABLE phpbb_search_wordlist (
+ word_text varchar(50) binary NOT NULL default '',
+ word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ word_common tinyint(1) unsigned NOT NULL default '0',
+ PRIMARY KEY (word_text),
+ KEY word_id (word_id)
+);
+
+# --------------------------------------------------------
+#
+# Table structure for table `phpbb_search_wordmatch`
+#
+DROP TABLE IF EXISTS phpbb_search_wordmatch;
+CREATE TABLE phpbb_search_wordmatch (
+ post_id mediumint(8) UNSIGNED NOT NULL default '0',
+ word_id mediumint(8) UNSIGNED NOT NULL default '0',
+ title_match tinyint(1) NOT NULL default '0',
+ KEY word_id (word_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_sessions'
+#
+# Note that if you're running 3.23.x you may want to make
+# this table a type HEAP. This type of table is stored
+# within system memory and therefore for big busy boards
+# is likely to be noticeably faster than continually
+# writing to disk ...
+#
+# I must admit I read about this type on vB's board.
+# Hey, I never said you cannot get basic ideas from
+# competing boards, just that I find it's best not to
+# look at any code ... !
+#
+DROP TABLE IF EXISTS phpbb_sessions;
+CREATE TABLE phpbb_sessions (
+ session_id char(32) DEFAULT '' NOT NULL,
+ session_user_id int(11) DEFAULT '0' NOT NULL,
+ session_start int(11) DEFAULT '0' NOT NULL,
+ session_time int(11) DEFAULT '0' NOT NULL,
+ session_last_visit int(11) DEFAULT '0' NOT NULL,
+ session_ip char(8) DEFAULT '0' NOT NULL,
+ session_page int(11) DEFAULT '0' NOT NULL,
+ session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
+ PRIMARY KEY (session_id),
+ KEY session_user_id (session_user_id),
+ KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_smilies'
+#
+DROP TABLE IF EXISTS phpbb_smilies;
+CREATE TABLE phpbb_smilies (
+ smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
+ code varchar(50),
+ smile_url varchar(100),
+ emoticon varchar(75),
+ PRIMARY KEY (smilies_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_themes'
+#
+DROP TABLE IF EXISTS phpbb_themes;
+CREATE TABLE phpbb_themes (
+ themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ template_name varchar(30) NOT NULL default '',
+ style_name varchar(30) NOT NULL default '',
+ head_stylesheet varchar(100) default NULL,
+ body_background varchar(100) default NULL,
+ body_bgcolor varchar(6) default NULL,
+ body_text varchar(6) default NULL,
+ body_link varchar(6) default NULL,
+ body_vlink varchar(6) default NULL,
+ body_alink varchar(6) default NULL,
+ body_hlink varchar(6) default NULL,
+ tr_color1 varchar(6) default NULL,
+ tr_color2 varchar(6) default NULL,
+ tr_color3 varchar(6) default NULL,
+ tr_class1 varchar(25) default NULL,
+ tr_class2 varchar(25) default NULL,
+ tr_class3 varchar(25) default NULL,
+ th_color1 varchar(6) default NULL,
+ th_color2 varchar(6) default NULL,
+ th_color3 varchar(6) default NULL,
+ th_class1 varchar(25) default NULL,
+ th_class2 varchar(25) default NULL,
+ th_class3 varchar(25) default NULL,
+ td_color1 varchar(6) default NULL,
+ td_color2 varchar(6) default NULL,
+ td_color3 varchar(6) default NULL,
+ td_class1 varchar(25) default NULL,
+ td_class2 varchar(25) default NULL,
+ td_class3 varchar(25) default NULL,
+ fontface1 varchar(50) default NULL,
+ fontface2 varchar(50) default NULL,
+ fontface3 varchar(50) default NULL,
+ fontsize1 tinyint(4) default NULL,
+ fontsize2 tinyint(4) default NULL,
+ fontsize3 tinyint(4) default NULL,
+ fontcolor1 varchar(6) default NULL,
+ fontcolor2 varchar(6) default NULL,
+ fontcolor3 varchar(6) default NULL,
+ span_class1 varchar(25) default NULL,
+ span_class2 varchar(25) default NULL,
+ span_class3 varchar(25) default NULL,
+ img_size_poll smallint(5) UNSIGNED,
+ img_size_privmsg smallint(5) UNSIGNED,
+ PRIMARY KEY (themes_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_themes_name'
+#
+DROP TABLE IF EXISTS phpbb_themes_name;
+CREATE TABLE phpbb_themes_name (
+ themes_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
+ tr_color1_name char(50),
+ tr_color2_name char(50),
+ tr_color3_name char(50),
+ tr_class1_name char(50),
+ tr_class2_name char(50),
+ tr_class3_name char(50),
+ th_color1_name char(50),
+ th_color2_name char(50),
+ th_color3_name char(50),
+ th_class1_name char(50),
+ th_class2_name char(50),
+ th_class3_name char(50),
+ td_color1_name char(50),
+ td_color2_name char(50),
+ td_color3_name char(50),
+ td_class1_name char(50),
+ td_class2_name char(50),
+ td_class3_name char(50),
+ fontface1_name char(50),
+ fontface2_name char(50),
+ fontface3_name char(50),
+ fontsize1_name char(50),
+ fontsize2_name char(50),
+ fontsize3_name char(50),
+ fontcolor1_name char(50),
+ fontcolor2_name char(50),
+ fontcolor3_name char(50),
+ span_class1_name char(50),
+ span_class2_name char(50),
+ span_class3_name char(50),
+ PRIMARY KEY (themes_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_topics'
+#
+DROP TABLE IF EXISTS phpbb_topics;
+CREATE TABLE phpbb_topics (
+ topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ topic_title char(100) NOT NULL,
+ topic_poster int(11) DEFAULT '0' NOT NULL,
+ topic_time int(11) DEFAULT '0' NOT NULL,
+ topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ topic_status tinyint(3) DEFAULT '0' NOT NULL,
+ topic_vote tinyint(1) DEFAULT '0' NOT NULL,
+ topic_type tinyint(3) DEFAULT '0' NOT NULL,
+ topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ topic_moved_id mediumint(8) UNSIGNED,
+ PRIMARY KEY (topic_id),
+ KEY forum_id (forum_id),
+ KEY topic_moved_id (topic_moved_id),
+ KEY topic_status (topic_status)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_topics_watch'
+#
+DROP TABLE IF EXISTS phpbb_topics_watch;
+CREATE TABLE phpbb_topics_watch (
+ topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ user_id int(11) NOT NULL DEFAULT '0',
+ notify_status tinyint(1) NOT NULL default '0',
+ KEY topic_id (topic_id),
+ KEY user_id (user_id),
+ KEY notify_status (notify_status)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_users'
+#
+DROP TABLE IF EXISTS phpbb_users;
+CREATE TABLE phpbb_users (
+ user_id int(11) NOT NULL auto_increment,
+ user_active tinyint(1) DEFAULT '1',
+ username varchar(25) NOT NULL,
+ user_password varchar(32) NOT NULL,
+ user_autologin_key varchar(32),
+ user_regdate int(11) DEFAULT '0' NOT NULL,
+ user_level tinyint(4) DEFAULT '0',
+ user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ user_timezone tinyint(4) DEFAULT '0' NOT NULL,
+ user_style tinyint(4),
+ user_lang varchar(255),
+ user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
+ user_lastvisit int(11) DEFAULT '0' NOT NULL,
+ user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
+ user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
+ user_last_privmsg int(11) DEFAULT '0' NOT NULL,
+ user_emailtime int(11),
+ user_viewemail tinyint(1),
+ user_attachsig tinyint(1),
+ user_allowhtml tinyint(1),
+ user_allowbbcode tinyint(1),
+ user_allowsmile tinyint(1),
+ user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
+ user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
+ user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
+ user_notify tinyint(1) DEFAULT '1' NOT NULL,
+ user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
+ user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
+ user_rank int(11) DEFAULT '0',
+ user_avatar varchar(100),
+ user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
+ user_email varchar(255),
+ user_icq varchar(15),
+ user_website varchar(100),
+ user_from varchar(100),
+ user_sig text,
+ user_sig_bbcode_uid char(10),
+ user_aim varchar(255),
+ user_yim varchar(255),
+ user_msnm varchar(255),
+ user_occ varchar(100),
+ user_interests varchar(255),
+ user_actkey varchar(32),
+ user_newpasswd varchar(32),
+ PRIMARY KEY (user_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_vote_desc'
+#
+DROP TABLE IF EXISTS phpbb_vote_desc;
+CREATE TABLE phpbb_vote_desc (
+ vote_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ vote_text text NOT NULL,
+ vote_start int(11) NOT NULL DEFAULT '0',
+ vote_length int(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (vote_id),
+ KEY topic_id (topic_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_vote_results'
+#
+DROP TABLE IF EXISTS phpbb_vote_results;
+CREATE TABLE phpbb_vote_results (
+ vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ vote_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
+ vote_option_text varchar(255) NOT NULL,
+ vote_result int(11) NOT NULL DEFAULT '0',
+ KEY vote_option_id (vote_option_id),
+ KEY vote_id (vote_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_vote_voters'
+#
+DROP TABLE IF EXISTS phpbb_vote_voters;
+CREATE TABLE phpbb_vote_voters (
+ vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ vote_user_id int(11) NOT NULL DEFAULT '0',
+ vote_user_ip char(8) NOT NULL,
+ KEY vote_id (vote_id),
+ KEY vote_user_id (vote_user_id),
+ KEY vote_user_ip (vote_user_ip)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_words'
+#
+DROP TABLE IF EXISTS phpbb_words;
+CREATE TABLE phpbb_words (
+ word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ word char(100) NOT NULL,
+ replacement char(100) NOT NULL,
+ PRIMARY KEY (word_id)
+);
diff --git a/phpBB/db/schemas/oracle_basic.sql b/phpBB/db/schemas/oracle_basic.sql
new file mode 100644
index 0000000000..bc951a6297
--- /dev/null
+++ b/phpBB/db/schemas/oracle_basic.sql
@@ -0,0 +1,181 @@
+/*
+* Basic DB data for phpBB2 devel
+*
+* $Id$
+*/
+
+-- Config
+INSERT INTO phpbb_config VALUES ('board_disable','0');
+INSERT INTO phpbb_config VALUES ('board_startdate','994190324');
+INSERT INTO phpbb_config VALUES ('sitename','yourdomain.com');
+INSERT INTO phpbb_config VALUES ('cookie_name','phpbb2oracle');
+INSERT INTO phpbb_config VALUES ('cookie_path','/');
+INSERT INTO phpbb_config VALUES ('cookie_domain','');
+INSERT INTO phpbb_config VALUES ('cookie_secure','0');
+INSERT INTO phpbb_config VALUES ('session_length','900');
+INSERT INTO phpbb_config VALUES ('allow_html','0');
+INSERT INTO phpbb_config VALUES ('allow_html_tags','b,i,u,pre');
+INSERT INTO phpbb_config VALUES ('allow_bbcode','1');
+INSERT INTO phpbb_config VALUES ('allow_smilies','1');
+INSERT INTO phpbb_config VALUES ('allow_sig','1');
+INSERT INTO phpbb_config VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config VALUES ('allow_theme_create','0');
+INSERT INTO phpbb_config VALUES ('allow_avatar_local','0');
+INSERT INTO phpbb_config VALUES ('allow_avatar_remote','1');
+INSERT INTO phpbb_config VALUES ('allow_avatar_upload','1');
+INSERT INTO phpbb_config VALUES ('override_user_style','0');
+INSERT INTO phpbb_config VALUES ('posts_per_page','15');
+INSERT INTO phpbb_config VALUES ('topics_per_page','50');
+INSERT INTO phpbb_config VALUES ('hot_threshold','25');
+INSERT INTO phpbb_config VALUES ('max_poll_options','10');
+INSERT INTO phpbb_config VALUES ('max_sig_chars','255');
+INSERT INTO phpbb_config VALUES ('max_inbox_privmsgs','50');
+INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25');
+INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50');
+INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management');
+INSERT INTO phpbb_config VALUES ('board_email','youraddress@yourdomain.com');
+INSERT INTO phpbb_config VALUES ('smtp_delivery','0');
+INSERT INTO phpbb_config VALUES ('smtp_host','');
+INSERT INTO phpbb_config VALUES ('require_activation','0');
+INSERT INTO phpbb_config VALUES ('require_admin_activation','0');
+INSERT INTO phpbb_config VALUES ('flood_interval','15');
+INSERT INTO phpbb_config VALUES ('avatar_filesize','6144');
+INSERT INTO phpbb_config VALUES ('avatar_max_width','80');
+INSERT INTO phpbb_config VALUES ('avatar_max_height','80');
+INSERT INTO phpbb_config VALUES ('avatar_path','images/avatars');
+INSERT INTO phpbb_config VALUES ('smilies_path','images/smiles');
+INSERT INTO phpbb_config VALUES ('default_style','8');
+INSERT INTO phpbb_config VALUES ('default_admin_style','2');
+INSERT INTO phpbb_config VALUES ('default_lang','english');
+INSERT INTO phpbb_config VALUES ('default_dateformat','D M d, Y g:i a');
+INSERT INTO phpbb_config VALUES ('board_timezone','0');
+INSERT INTO phpbb_config VALUES ('prune_enable','1');
+INSERT INTO phpbb_config VALUES ('gzip_compress','1');
+
+
+-- Categories
+INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
+
+
+-- Forums
+INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 3, 3, 3);
+
+
+-- Users
+INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active, user_template) VALUES
+ ( '-1', 'Anonymous', '0', '972086460', '1', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '0', '', '', '', '0', '0', '1', '1', '', '', '', '-8', 'D M d, Y g:i a', '', '', '0', '0');
+
+-- username: admin password: admin (change this or remove it once everything is working!)
+INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( '2', 'Admin', '1', '972086460', '21232f297a57a5a743894a0e4a801fc3', '', 'admin@yourdomain.com', '', '', '', '', '', 'A Signature', '1', '2', '', '', '', '0', '0', '1', '0', '1', '1', '1', '1', '1', '', 'english', '-8', 'd M Y h:i a', '', '', '0', '1');
+
+
+-- Ranks
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '-1', '1', '');
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '2', 'Newbie', '0', '9', '0', '');
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '5', 'Here Often', '10', '49', '0', '');
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '6', 'Should Get Out More', '50', '199', '0', '');
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '7', 'Has No Life', '200', '9999', '0', '');
+
+
+-- Groups
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
+
+
+-- User -> Group
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
+
+
+-- User Access (admin is set as ... an admin)
+INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_mod) VALUES (2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
+
+
+-- Demo Topic
+INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Demo Topic', 2, 972086460, 0, 0, 1, 0, 0, 1);
+
+
+-- Demo Post
+INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, '', '7F000001');
+INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, 'This is the subject', 'This is a demo post in the demo topic, what do you think of it?');
+
+
+-- Themes
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1,'Original default','Default','','','','','','','','','','','','','','','','','','','','','CCCCCC','DDDDDD','','','','','','','',NULL,NULL,NULL,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (2,'PSO [ Grey ]','PSO', '','','FFFFFF','000000','002266','004411','','','','','','','','','000000','D2D2D2','BCBCBC','','','','EDEDED','DEDEDE','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (3,'PSO [ Wheat ] ','PSO','','','FFFFFF','000000','002266','004411','','','','','','','','','001100','E5CCA5','D4A294','','','','EBE4D9','DAD1C4','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (4,'PSO [ Ocean ]','PSO','','','DFF5FF','000000','011001','2100cc','','','','','','','','','000000','A7C1CB','7897A8','','','','83D7CC','A0CCE0','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (6,'PSO [ Blue ]','PSO','','','FFFFFF','000000','417FB9','4E6172','0000AA','','','','','','','','000000','90BAE2','5195D4','','','','cde3f2','daedFd','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (7,'PSO [ Cool Midnight ]','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (8,'PSO [ Pastel Purple ]','PSO','','','FFFFFF','000000','445588','337744','','','','','','','','','CCCCDD','CCCCDD','DDDDEE','','','','EFEFEF','FEFEFE','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',1,2,3,'','','0000EE','','','');
+INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (9,'subSilver','subSilver','','','E5E5E5','000000','006699','5584AA','FF9933','EDF2F2','EFEFEF','DEE3E7','c2cdd6','','','','CBD3D9','BCBCBC','1B7CAD','','','','AEBDC4','006699','FFFFFF','row1','row2','','Verdana,Arial,Helvetica,sans-serif','Verdana,Arial,Helvetica,sans-serif','courier','','','','004c75','004c75','004c75','','','');
+
+
+-- Smilies
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '2', ':-D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '3', ':grin:', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '4', ':)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '5', ':-)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '6', ':smile:', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '7', ':(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '8', ':-(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '9', ':sad:', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '10', ':o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '11', ':-o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '12', ':eek:', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '13', ':?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '14', ':-?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '15', ':???:', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '16', '8)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '17', '8-)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '18', ':cool:', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '19', ':lol:', 'icon_lol.gif', 'Laughing');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '20', ':x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '21', ':-x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '22', ':mad:', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '23', ':P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '24', ':-P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '25', ':razz:', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '26', ':oops:', 'icon_redface.gif', 'Embarassed');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '27', ':cry:', 'icon_cry.gif', 'Crying or Very sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '28', ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '29', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '30', ':wink:', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '31', ';)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '32', ';-)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '33', ':!:', 'icon_exclaim.gif', 'Exclamation');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '34', ':?:', 'icon_question.gif', 'Question');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '35', ':idea:', 'icon_idea.gif', 'Idea');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '36', ':arrow:', 'icon_arrow.gif', 'Arrow');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', ':|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':-|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':neutral:', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
+
+-- Words
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '1', 'asshole', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '2', 'assram*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '3', 'asswipe', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '4', 'asstool*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '5', 'bastard', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '6', 'bitch', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '7', 'bollock*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '8', 'crap*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '9', '*crap', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '10', 'cunt*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '11', 'dickweed', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '12', 'dickwad', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '13', 'dickhead', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '14', '*fuck*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '15', 'fuk*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '16', 'masturbat*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '17', 'piss*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '18', 'prick', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '19', 'pussy', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '20', '*shit*', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '21', 'slut', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '22', 'tits', '*beep*');
+INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '23', '*wank*', '*beep*');
+
+COMMIT;
diff --git a/phpBB/db/schemas/oracle_schema.sql b/phpBB/db/schemas/oracle_schema.sql
new file mode 100644
index 0000000000..cbfc0e3139
--- /dev/null
+++ b/phpBB/db/schemas/oracle_schema.sql
@@ -0,0 +1,522 @@
+/*
+ phpBB2 Oracle 8i DB schema - (c) 2001 The phpBB Group
+
+ $Id$
+*/
+
+/*
+ This first section is optional, however its probably the best method
+ of running phpBB on Oracle. If you already have a tablespace and user created
+ for phpBB you can leave this section commented out!
+
+ The first set of statements create a phpBB tablespace and a phpBB user,
+ make sure you change the password of the phpBB user befor you run this script!!
+*/
+
+/*
+CREATE TABLESPACE phpbb
+ DATAFILE 'E:/web/Oracle8i/ORADATA/phpbb01.dbf'
+ SIZE 10M
+ AUTOEXTEND ON NEXT 10M
+ MAXSIZE 100M;
+
+CREATE USER phpbb
+ IDENTIFIED BY phpbb_password
+ DEFAULT TABLESPACE phpbb
+ TEMPORARY TABLESPACE temp;
+
+GRANT CREATE SESSION TO phpbb;
+GRANT CREATE TABLE TO phpbb;
+GRANT CREATE SEQUENCE TO phpbb;
+GRANT CREATE TRIGGER TO phpbb;
+
+ALTER USER phpbb QUOTA unlimited ON phpbb;
+
+COMMIT;
+DISCONNECT;
+
+CONNECT phpbb/phpbb_password;
+*/
+
+
+
+CREATE SEQUENCE phpbb_banlist_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_categories_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_config_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_disallow_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_forums_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_posts_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_privmsgs_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_ranks_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_smilies_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_themes_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_topics_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_users_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_words_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_groups_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_forum_prune_id_seq increment by 1 start with 2 minvalue 0;
+CREATE SEQUENCE phpbb_vote_desc_id_seq increment by 1 start with 2 minvalue 0;
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_auth_access
+-------------------------------------------------------- */
+CREATE TABLE phpbb_auth_access (
+ group_id number(4) DEFAULT '0' NOT NULL,
+ forum_id number(4) DEFAULT '0' NOT NULL,
+ auth_view number(4) DEFAULT '0' NOT NULL,
+ auth_read number(4) DEFAULT '0' NOT NULL,
+ auth_post number(4) DEFAULT '0' NOT NULL,
+ auth_reply number(4) DEFAULT '0' NOT NULL,
+ auth_edit number(4) DEFAULT '0' NOT NULL,
+ auth_delete number(4) DEFAULT '0' NOT NULL,
+ auth_announce number(4) DEFAULT '0' NOT NULL,
+ auth_sticky number(4) DEFAULT '0' NOT NULL,
+ auth_pollcreate number(4) DEFAULT '0' NOT NULL,
+ auth_attachments number(4) DEFAULT '0' NOT NULL,
+ auth_vote number(4) DEFAULT '0' NOT NULL,
+ auth_mod number(4) DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_auth_access_pkey PRIMARY KEY (group_id)
+);
+CREATE INDEX group_phpbb_auth_access_index ON phpbb_auth_access (forum_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_groups
+-------------------------------------------------------- */
+CREATE TABLE phpbb_groups (
+ group_id number(4) NOT NULL,
+ group_name varchar(40) NOT NULL,
+ group_type number(2) DEFAULT '1' NOT NULL,
+ group_description varchar(255) NOT NULL,
+ group_moderator number(4) DEFAULT '0' NOT NULL,
+ group_single_user number(4) DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id)
+);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_banlist
+-------------------------------------------------------- */
+CREATE TABLE phpbb_banlist (
+ ban_id number(4) NOT NULL,
+ ban_userid number(4),
+ 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 number(4) NOT NULL,
+ cat_title varchar(100),
+ cat_order number(4),
+ 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),
+ CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_name)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_disallow
+-------------------------------------------------------- */
+CREATE TABLE phpbb_disallow (
+ disallow_id number(4) 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 number(4) NOT NULL,
+ cat_id number(4),
+ forum_name varchar(150),
+ forum_desc varchar(2000),
+ forum_status number(4) DEFAULT '0' NOT NULL,
+ forum_order number(4) DEFAULT '1' NOT NULL,
+ forum_posts number(4) DEFAULT '0' NOT NULL,
+ forum_topics number(4) DEFAULT '0' NOT NULL,
+ forum_last_post_id number(4) DEFAULT '0' NOT NULL,
+ prune_enable number(4) DEFAULT '1' NOT NULL,
+ prune_next number(4),
+ auth_view number(4) DEFAULT '0' NOT NULL,
+ auth_read number(4) DEFAULT '0' NOT NULL,
+ auth_post number(4) DEFAULT '0' NOT NULL,
+ auth_reply number(4) DEFAULT '0' NOT NULL,
+ auth_edit number(4) DEFAULT '0' NOT NULL,
+ auth_delete number(4) DEFAULT '0' NOT NULL,
+ auth_announce number(4) DEFAULT '0' NOT NULL,
+ auth_sticky number(4) DEFAULT '0' NOT NULL,
+ auth_pollcreate number(4) DEFAULT '0' NOT NULL,
+ auth_vote number(4) DEFAULT '0' NOT NULL,
+ auth_attachments number(4) 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 forums_order_phpbb_forums ON phpbb_forums (forum_order);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_forum_prune
+-------------------------------------------------------- */
+CREATE TABLE phpbb_forum_prune (
+ prune_id number(4) NOT NULL,
+ forum_id number(4) NOT NULL,
+ prune_days number(4) NOT NULL,
+ prune_freq number(4) NOT NULL,
+ CONSTRAINT phpbb_forum_prune_pkey PRIMARY KEY (prune_id)
+);
+CREATE INDEX forum_id_phpbb_forum_prune ON phpbb_forum_prune (forum_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_posts
+-------------------------------------------------------- */
+CREATE TABLE phpbb_posts (
+ post_id number(4) NOT NULL,
+ topic_id number(4) DEFAULT '0' NOT NULL,
+ forum_id number(4) DEFAULT '0' NOT NULL,
+ poster_id number(4) DEFAULT '0' NOT NULL,
+ post_time number(11) DEFAULT '0' NOT NULL,
+ post_username varchar(30),
+ poster_ip char(8) DEFAULT '' NOT NULL,
+ enable_bbcode number(4) DEFAULT '1' NOT NULL,
+ enable_html number(4) DEFAULT '0' NOT NULL,
+ enable_smilies number(4) DEFAULT '1' NOT NULL,
+ enable_sig number(4) DEFAULT '1' NOT NULL,
+ bbcode_uid varchar(10) DEFAULT '',
+ post_edit_time number(11),
+ post_edit_count number(4) 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 number(4) DEFAULT '0' NOT NULL,
+ post_subject varchar(255),
+ post_text varchar(2000),
+ CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_privmsgs
+-------------------------------------------------------- */
+CREATE TABLE phpbb_privmsgs (
+ privmsgs_id number(4) NOT NULL,
+ privmsgs_type number(4) DEFAULT '0' NOT NULL,
+ privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
+ privmsgs_from_userid number(4) DEFAULT '0' NOT NULL,
+ privmsgs_to_userid number(4) DEFAULT '0' NOT NULL,
+ privmsgs_date number(4) DEFAULT '0' NOT NULL,
+ privmsgs_ip char(8) NOT NULL,
+ privmsgs_enable_bbcode number(1) DEFAULT '1' NOT NULL,
+ privmsgs_enable_html number(1) DEFAULT '0' NOT NULL,
+ privmsgs_enable_smilies number(1) DEFAULT '1' NOT NULL,
+ privmsgs_attach_sig number(1) 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 number(4) DEFAULT '0' NOT NULL,
+ privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
+ privmsgs_text varchar(2000),
+ CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id)
+);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_ranks
+-------------------------------------------------------- */
+CREATE TABLE phpbb_ranks (
+ rank_id number(4) NOT NULL,
+ rank_title varchar(50) DEFAULT '' NOT NULL,
+ rank_min number(4) DEFAULT '0' NOT NULL,
+ rank_max number(4) DEFAULT '0' NOT NULL,
+ rank_special number(4) DEFAULT '0',
+ rank_image varchar(255),
+ CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (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_sessions (
+ session_id char(32) DEFAULT '0' NOT NULL,
+ session_user_id number(11) DEFAULT '0' NOT NULL,
+ session_start number(11) DEFAULT '0' NOT NULL,
+ session_time number(11) DEFAULT '0' NOT NULL,
+ session_last_visit number(11) DEFAULT '0' NOT NULL,
+ session_ip char(8) DEFAULT '0' NOT NULL,
+ session_page number(11) DEFAULT '0' NOT NULL,
+ session_logged_in number(11) DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_sessions_pkey PRIMARY KEY (session_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 number(4) 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 number(4) NOT NULL,
+ style_name varchar(30),
+ template_name varchar(30) DEFAULT '' NOT NULL,
+ 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 number(4),
+ fontsize2 number(4),
+ fontsize3 number(4),
+ 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 number(4) DEFAULT '0' NOT NULL,
+ tr_color1_name varchar(50),
+ tr_color2_name varchar(50),
+ tr_color3_name varchar(50),
+ tr_class1_name varchar(50),
+ tr_class2_name varchar(50),
+ tr_class3_name varchar(50),
+ th_color1_name varchar(50),
+ th_color2_name varchar(50),
+ th_color3_name varchar(50),
+ th_class1_name varchar(50),
+ th_class2_name varchar(50),
+ th_class3_name varchar(50),
+ td_color1_name varchar(50),
+ td_color2_name varchar(50),
+ td_color3_name varchar(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 varchar(50),
+ fontcolor2_name varchar(50),
+ fontcolor3_name varchar(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 number(4) NOT NULL,
+ topic_title varchar(100) DEFAULT '' NOT NULL,
+ topic_poster number(4) DEFAULT '0' NOT NULL,
+ topic_time number(11) DEFAULT '0' NOT NULL,
+ topic_views number(4) DEFAULT '0' NOT NULL,
+ topic_replies number(4) DEFAULT '0' NOT NULL,
+ forum_id number(4) DEFAULT '0' NOT NULL,
+ topic_status number(4) DEFAULT '0' NOT NULL,
+ topic_vote number(4) DEFAULT '0' NOT NULL,
+ topic_type number(4) DEFAULT '0' NOT NULL,
+ topic_moved_id number(4),
+ topic_last_post_id number(4) DEFAULT '0' NOT NULL,
+ CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_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_topics_watch
+-------------------------------------------------------- */
+CREATE TABLE phpbb_topics_watch (
+ topic_id number(4),
+ user_id number(4),
+ notify_status number(4) DEFAULT '0' NOT NULL
+);
+CREATE INDEX phpbb_topics_watch_index ON phpbb_topics_watch (topic_id, user_id);
+
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_user_group
+-------------------------------------------------------- */
+CREATE TABLE phpbb_user_group (
+ group_id number(4) DEFAULT '0' NOT NULL,
+ user_id number(4) DEFAULT '0' NOT NULL,
+ user_pending number(4)
+);
+CREATE INDEX group_id_phpbb_user_group 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 number(4) NOT NULL,
+ user_active number(4),
+ username varchar(25) DEFAULT '' NOT NULL,
+ user_regdate number(11) 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(2000),
+ user_sig_bbcode_uid char(10),
+ user_style number(4),
+ user_aim varchar(255),
+ user_yim varchar(255),
+ user_msnm varchar(255),
+ user_posts number(4) DEFAULT '0' NOT NULL,
+ user_viewemail number(4),
+ user_attachsig number(4),
+ user_allowhtml number(4),
+ user_allowbbcode number(4),
+ user_allowsmile number(4),
+ user_allow_pm number(4) DEFAULT '1' NOT NULL,
+ user_allowavatar number(4) DEFAULT '1' NOT NULL,
+ user_allow_viewonline number(4) DEFAULT '1' NOT NULL,
+ user_rank number(4) DEFAULT '0',
+ user_avatar varchar(100),
+ user_level number(4) DEFAULT '1',
+ user_lang varchar(255),
+ user_timezone number(4) DEFAULT '0' NOT NULL,
+ user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
+ user_notify_pm number(4) DEFAULT '1' NOT NULL,
+ user_notify number(4),
+ 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 number(4) NOT NULL,
+ topic_id number(4) DEFAULT '0' NOT NULL,
+ vote_text varchar2(4000) NOT NULL,
+ vote_start number(4) DEFAULT '0' NOT NULL,
+ vote_length number(4) 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 number(4) DEFAULT '0' NOT NULL,
+ vote_option_id number(4) DEFAULT '0' NOT NULL,
+ vote_option_text varchar(255) NOT NULL,
+ vote_result number(4) DEFAULT '0' NOT NULL
+);
+CREATE INDEX option_id_vote_results_index ON phpbb_vote_results (vote_option_id);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_vote_voters
+-------------------------------------------------------- */
+CREATE TABLE phpbb_vote_voters (
+ vote_id number(4) DEFAULT '0' NOT NULL,
+ vote_user_id number(4) DEFAULT '0' NOT NULL,
+ vote_user_ip char(8) NOT NULL
+);
+CREATE INDEX vote_id_vote_voters_index ON phpbb_vote_voters (vote_id);
+CREATE INDEX vote_user_id_vote_voters_index ON phpbb_vote_voters (vote_user_id);
+CREATE INDEX vote_user_ip_vote_voters_index ON phpbb_vote_voters (vote_user_ip);
+
+/* --------------------------------------------------------
+ Table structure for table phpbb_words
+-------------------------------------------------------- */
+CREATE TABLE phpbb_words (
+ word_id number(4) NOT NULL,
+ word varchar(100) DEFAULT '' NOT NULL,
+ replacement varchar(100) DEFAULT '' NOT NULL,
+ CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id)
+);
+
+COMMIT;
diff --git a/phpBB/db/schemas/oracle_triggers.sql b/phpBB/db/schemas/oracle_triggers.sql
new file mode 100644
index 0000000000..f22fa46f66
--- /dev/null
+++ b/phpBB/db/schemas/oracle_triggers.sql
@@ -0,0 +1,217 @@
+/*
+ phpBB2 Oracle 8i Triggers File - (c) 2001 The phpBB Group
+
+ $Id$
+ */
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_groups
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_GROUPS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "GROUP_ID" ON "PHPBB"."PHPBB_GROUPS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_GROUPS_ID_SEQ.NEXTVAL
+INTO :NEW.group_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_banlist
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_BANLIST_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "BAN_ID" ON "PHPBB"."PHPBB_BANLIST"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_BANLIST_ID_SEQ.NEXTVAL
+INTO :NEW.ban_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_categories
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_CATEGORIES_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "CAT_ID" ON "PHPBB"."PHPBB_CATEGORIES"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_CATEGORIES_ID_SEQ.NEXTVAL
+INTO :NEW.cat_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_disallow
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_DISALLOW_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "DISALLOW_ID" ON "PHPBB"."PHPBB_DISALLOW"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_DISALLOW_ID_SEQ.NEXTVAL
+INTO :NEW.disallow_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_forums
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUMS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "FORUM_ID" ON "PHPBB"."PHPBB_FORUMS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_FORUMS_ID_SEQ.NEXTVAL
+INTO :NEW.forum_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_forum_prune
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUM_PRUNE_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "PRUNE_ID" ON "PHPBB"."PHPBB_FORUM_PRUNE"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_FORUM_PRUNE_ID_SEQ.NEXTVAL
+INTO :NEW.prune_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_posts
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_POSTS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "POST_ID" ON "PHPBB"."PHPBB_POSTS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_POSTS_ID_SEQ.NEXTVAL
+INTO :NEW.post_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_privmsgs
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_PRIVMSGS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "PRIVMSGS_ID" ON "PHPBB"."PHPBB_PRIVMSGS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_PRIVMSGS_ID_SEQ.NEXTVAL
+INTO :NEW.privmsgs_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_ranks
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_RANK_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "RANK_ID" ON "PHPBB"."PHPBB_RANKS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_RANKS_ID_SEQ.NEXTVAL
+INTO :NEW.rank_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_smilies
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_SMILIES_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "SMILIES_ID" ON "PHPBB"."PHPBB_SMILIES"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_SMILIES_ID_SEQ.NEXTVAL
+INTO :NEW.smilies_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_themes
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_THEMES_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "THEMES_ID" ON "PHPBB"."PHPBB_THEMES"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_THEMES_ID_SEQ.NEXTVAL
+INTO :NEW.themes_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_topics
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_TOPICS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "TOPIC_ID" ON "PHPBB"."PHPBB_TOPICS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_TOPICS_ID_SEQ.NEXTVAL
+INTO :NEW.topic_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_users
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_USERS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "USER_ID" ON "PHPBB"."PHPBB_USERS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_USERS_ID_SEQ.NEXTVAL
+INTO :NEW.user_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_vote_desc
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_VOTE_DESC_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "VOTE_ID" ON "PHPBB"."PHPBB_VOTE_DESC"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_VOTE_DESC_ID_SEQ.NEXTVAL
+INTO :NEW.vote_id
+FROM DUAL;
+END;
+/
+
+/* --------------------------------------------------------
+ Trigger structure for table phpbb_words
+-------------------------------------------------------- */
+CREATE OR REPLACE TRIGGER "PHPBB"."SET_WORDS_ID_SEQ"
+BEFORE INSERT OR UPDATE OF "WORD_ID" ON "PHPBB"."PHPBB_WORDS"
+REFERENCING OLD AS OLD NEW AS NEW
+FOR EACH ROW
+BEGIN
+SELECT PHPBB_WORDS_ID_SEQ.NEXTVAL
+INTO :NEW.word_id
+FROM DUAL;
+END;
+/
+
+COMMIT;
diff --git a/phpBB/db/schemas/postgres_basic.sql b/phpBB/db/schemas/postgres_basic.sql
new file mode 100644
index 0000000000..1a6719fa63
--- /dev/null
+++ b/phpBB/db/schemas/postgres_basic.sql
@@ -0,0 +1,149 @@
+/*
+* Basic DB data for phpBB2 devel
+*
+* $Id$
+*/
+
+-- Config
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2postgres');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','900');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_admin_style','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
+
+
+-- Categories
+INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
+
+
+-- Forums
+INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 3, 3);
+
+
+-- Users
+INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_autologin_key, user_level, user_timezone, user_dateformat, user_style, user_lang, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify_pm, user_regdate, user_rank, user_avatar, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_posts, user_actkey, user_newpasswd, user_notify) VALUES (-1,1,'Anonymous','','','','','','','','','','',1,1,'','',1,'','','','','','','','','','','',NULL,'','','',60,'','','');
+
+-- username: admin password: admin (change this or remove it once everything is working!)
+INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES (2, 'Admin', 1, '', '21232f297a57a5a743894a0e4a801fc3', '', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, '', '', 0, 'd M Y h:i a', '', '', 0, 1);
+
+
+-- Ranks
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '-1', '1', '');
+
+
+-- Groups
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
+INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
+
+
+-- User -> Group
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
+INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
+
+
+-- Demo Topic
+INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, date_part('EPOCH', TIMESTAMP 'now'), 0, 0, 1, 0, 0, 1);
+
+
+-- Demo Post
+INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, date_part('EPOCH', TIMESTAMP 'now'), '', '7F000001');
+INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, '', 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
+
+
+-- Themes
+INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1,'subSilver','subSilver','','','E5E5E5','000000','006699','5584AA','FF9933','EDF2F2','EFEFEF','DEE3E7','c2cdd6','','','','CBD3D9','BCBCBC','1B7CAD','','','','AEBDC4','006699','FFFFFF','row1','row2','','Verdana,Arial,Helvetica,sans-serif','Verdana,Arial,Helvetica,sans-serif','courier','','','','004c75','004c75','004c75','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (2,'PSO [ Wheat ] ','PSO','','','FFFFFF','000000','002266','004411','','','','','','','','','001100','E5CCA5','D4A294','','','','EBE4D9','DAD1C4','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (3,'PSO [ Ocean ]','PSO','','','DFF5FF','000000','011001','2100cc','','','','','','','','','000000','A7C1CB','7897A8','','','','83D7CC','A0CCE0','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (4,'PSO [ Blue ]','PSO','','','FFFFFF','000000','417FB9','4E6172','0000AA','','','','','','','','000000','90BAE2','5195D4','','','','cde3f2','daedFd','','row1','row2','','verdana,serif','arial,helvetica','courier',1,2,3,'000000','','','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (5,'PSO [ Cool Midnight ]','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','','');
+INSERT INTO phpbb_themes (themes_id, style_name, template_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (6,'PSO [ Pastel Purple ]','PSO','','','FFFFFF','000000','445588','337744','','','','','','','','','CCCCDD','CCCCDD','DDDDEE','','','','EFEFEF','FEFEFE','','row1','row2','','Verdana,serif','Arial,Helvetica,sans-serif','courier',1,2,3,'','','0000EE','','','');
+
+
+-- Smilies
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '2', ':-D', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '3', ':grin:', 'icon_biggrin.gif', 'Very Happy');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '4', ':)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '5', ':-)', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '6', ':smile:', 'icon_smile.gif', 'Smile');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '7', ':(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '8', ':-(', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '9', ':sad:', 'icon_sad.gif', 'Sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '10', ':o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '11', ':-o', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '12', ':eek:', 'icon_eek.gif', 'Surprised');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '13', ':?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '14', ':-?', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '15', ':???:', 'icon_confused.gif', 'Confused');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '16', '8)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '17', '8-)', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '18', ':cool:', 'icon_cool.gif', 'Cool');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '19', ':lol:', 'icon_lol.gif', 'Laughing');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '20', ':x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '21', ':-x', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '22', ':mad:', 'icon_mad.gif', 'Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '23', ':P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '24', ':-P', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '25', ':razz:', 'icon_razz.gif', 'Razz');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '26', ':oops:', 'icon_redface.gif', 'Embarassed');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '27', ':cry:', 'icon_cry.gif', 'Crying or Very sad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '28', ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '29', ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '30', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '31', ':wink:', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '32', ';)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '33', ';-)', 'icon_wink.gif', 'Wink');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '34', ':!:', 'icon_exclaim.gif', 'Exclamation');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '35', ':?:', 'icon_question.gif', 'Question');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '36', ':idea:', 'icon_idea.gif', 'Idea');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', ':arrow:', 'icon_arrow.gif', 'Arrow');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':-|', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':neutral:', 'icon_neutral.gif', 'Neutral');
+INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '41', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
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