diff options
-rw-r--r-- | phpBB/db/mssql_schema.sql | bin | 0 -> 38912 bytes | |||
-rw-r--r-- | phpBB/db/mysql_basic.sql | 4 | ||||
-rw-r--r-- | phpBB/db/mysql_schema.sql | 5 | ||||
-rw-r--r-- | phpBB/db/postgres_schema.sql | 6 |
4 files changed, 13 insertions, 2 deletions
diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql Binary files differnew file mode 100644 index 0000000000..5ced86ed97 --- /dev/null +++ b/phpBB/db/mssql_schema.sql 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, |