aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/db/mssql_schema.sqlbin0 -> 38912 bytes
-rw-r--r--phpBB/db/mysql_basic.sql4
-rw-r--r--phpBB/db/mysql_schema.sql5
-rw-r--r--phpBB/db/postgres_schema.sql6
4 files changed, 13 insertions, 2 deletions
diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql
new file mode 100644
index 0000000000..5ced86ed97
--- /dev/null
+++ b/phpBB/db/mssql_schema.sql
Binary files differ
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql
index 90f5284969..fd66c00452 100644
--- a/phpBB/db/mysql_basic.sql
+++ b/phpBB/db/mysql_basic.sql
@@ -4,7 +4,7 @@
# $Id$
# -- Config
-INSERT INTO phpbb_config (config_id, board_disable, sitename, allow_html, allow_bbcode, allow_smilies, allow_sig, allow_namechange, posts_per_page, hot_threshold, topics_per_page, flood_interval, allow_theme_create, override_themes, email_sig, email_from, default_theme, default_lang, default_dateformat, system_timezone, sys_template, avatar_filesize, avatar_path, allow_avatar_upload, avatar_max_width, avatar_max_height, allow_avatar_local, allow_avatar_remote) VALUES ( '1', '0', 'phpbb.com', '0', '1', '1', '1', '0', '10', '10', '25', '10', '0', '0', '', '', '1', 'english', 'd M Y H:i', '0', 'Default', '6144', 'images/avatars', '0', '70', '70', '0', '0');
+INSERT INTO phpbb_config (config_id, board_disable, sitename, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_bbcode, allow_smilies, allow_sig, allow_namechange, posts_per_page, hot_threshold, topics_per_page, flood_interval, allow_theme_create, override_themes, email_sig, email_from, default_theme, default_lang, default_dateformat, system_timezone, sys_template, avatar_filesize, avatar_path, allow_avatar_upload, avatar_max_width, avatar_max_height, allow_avatar_local, allow_avatar_remote) VALUES ( '1', '0', 'phpbb.com', 'phpbb2mysql', '/', '', '0', 600, '0', '1', '1', '1', '0', '10', '10', '25', '10', '0', '0', '', '', '1', 'english', 'd M Y H:i', '0', 'Default', '6144', 'images/avatars', '0', '70', '70', '0', '0');
# -- Categories
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1);
@@ -59,5 +59,5 @@ INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_col
INSERT INTO phpbb_themes (themes_id, themes_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, th_color1, th_color2, th_color3, td_color1, td_color2, td_color3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, img1, img2, img3, img4) VALUES ( '6', 'PSO-Blue', '', '', 'FFFFFF', '000000', '417FB9', '4E6172', '0000AA', '', '', '', '', '000000', '90BAE2', '518EC7', 'cde3f2', 'daedFd', '', 'verdana,serif', 'arial,helvetica', 'courier', '1', '2', '3', '000000', '', '', '', '', '', '');
INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, th_color1_name, th_color2_name, th_color3_name, td_color1_name, td_color2_name, td_color3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, img1_name, img2_name, img3_name, img4_name) VALUES ( '5', '', '', '', 'Table Background', 'Title Header', 'Category Header', 'Table background', 'Row Color 1', 'Row Color 2', 'Verdana,Serif', 'Arial,Sans-serif', 'Verdana,serif', 'Smallest', 'Typical', 'Largest', 'All text', '', '', '', '', '', '');
-INSERT INTO phpbb_themes (themes_id, themes_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, th_color1, th_color2, th_color3, td_color1, td_color2, td_color3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, img1, img2, img3, img4) VALUES ( '7', 'PSO-Dark-Pastels', '', '', '444444', 'ECECEC', 'EDF2F2', 'DDEDED', 'FFFFFF', 'EDF2F2', '', '', '', '000000', '80707F', '66555F', '60707D', '667A80', '', 'Verdana,serif', 'Arial,Helvetica,sans-serif', 'courier', '0', '0', '0', 'ECECEC', 'ECECEC', 'ECECEC', '', '', '', '');
+INSERT INTO phpbb_themes (themes_id, themes_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, th_color1, th_color2, th_color3, td_color1, td_color2, td_color3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, img1, img2, img3, img4) VALUES ( '7', 'PSO-Cool Midnight', '', '', '444444', 'ECECEC', 'EDF2F2', 'DDEDED', 'FFFFFF', 'EDF2F2', '', '', '', '000000', '80707F', '66555F', '60707D', '667A80', '', 'Verdana,serif', 'Arial,Helvetica,sans-serif', 'courier', '0', '0', '0', 'ECECEC', 'ECECEC', 'ECECEC', '', '', '', '');
INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, th_color1_name, th_color2_name, th_color3_name, td_color1_name, td_color2_name, td_color3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, img1_name, img2_name, img3_name, img4_name) VALUES ( '6', '', '', '', 'Table Background', 'Title Header', 'Category Header', 'Table background', 'Row Color 1', 'Row Color 2', 'Verdana,Serif', 'Arial,Sans-serif', 'Verdana,serif', 'Smallest', 'Typical', 'Largest', 'All text', '', '', '', '', '', '');
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index 1f78b7cfe3..10d23f8f7e 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -91,6 +91,11 @@ CREATE TABLE phpbb_config (
config_id int(10) NOT NULL auto_increment,
board_disable tinyint(1) DEFAULT '0' NOT NULL,
sitename varchar(100),
+ cookie_name char(20),
+ cookie_path char(25),
+ cookie_domain char(50),
+ cookie_secure tinyint(1),
+ session_length int(11),
allow_html tinyint(1),
allow_bbcode tinyint(1),
allow_smilies tinyint(1),
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index d6ddf134f7..54564671b0 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -88,6 +88,11 @@ CREATE TABLE phpbb_config (
config_id int2 NOT NULL,
board_disable int2 DEFAULT '0' NOT NULL,
sitename varchar(100) NOT NULL,
+ cookie_name char(20),
+ cookie_path char(25),
+ cookie_domain char(50),
+ cookie_secure int2,
+ session_length int4,
allow_html int2 NOT NULL,
allow_bbcode int2 NOT NULL,
allow_smilies int2 NOT NULL,
@@ -140,6 +145,7 @@ CREATE TABLE phpbb_forums (
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,