diff options
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/db/mssql_basic.sql | 89 | ||||
| -rw-r--r-- | phpBB/db/mssql_schema.sql | 8 | ||||
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 102 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 6 | ||||
| -rwxr-xr-x | phpBB/db/oracle_basic.sql | 71 | ||||
| -rwxr-xr-x | phpBB/db/oracle_schema.sql | 10 | ||||
| -rwxr-xr-x | phpBB/db/postgres_basic.sql | 70 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 30 |
8 files changed, 234 insertions, 152 deletions
diff --git a/phpBB/db/mssql_basic.sql b/phpBB/db/mssql_basic.sql index 3d301e97de..7bca229fa8 100644 --- a/phpBB/db/mssql_basic.sql +++ b/phpBB/db/mssql_basic.sql @@ -14,7 +14,7 @@ BEGIN TRANSACTION; 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','phpbb2mysql'); +INSERT INTO phpbb_config VALUES ('cookie_name','phpbb2mssql'); INSERT INTO phpbb_config VALUES ('cookie_path','/'); INSERT INTO phpbb_config VALUES ('cookie_domain',''); INSERT INTO phpbb_config VALUES ('cookie_secure','0'); @@ -29,27 +29,28 @@ 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_themes','0'); +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 ('email_sig','Thanks, The Management'); -INSERT INTO phpbb_config VALUES ('email_from','youraddress@yourdomain.com'); +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_theme','2'); +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','-8'); -INSERT INTO phpbb_config VALUES ('board_template','PSO'); +INSERT INTO phpbb_config VALUES ('board_timezone','0'); INSERT INTO phpbb_config VALUES ('prune_enable','1'); INSERT INTO phpbb_config VALUES ('gzip_compress','1'); @@ -132,12 +133,13 @@ SET IDENTITY_INSERT phpbb_posts OFF; */ SET IDENTITY_INSERT phpbb_themes ON; -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, 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, 'Default-Default', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'CCCCCC', 'DDDDDD', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); -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, 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-Default', '', '', '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, themes_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', '', '', '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, themes_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', '', '', '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, themes_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', '', '', '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, themes_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', '', '', '444444', 'ECECEC', 'EDF2F2', 'DDEDED', 'FFFFFF', 'EDF2F2', '', '', '', '', '', '', '000000', '80707F', '66555F', '', '', '', '60707D', '667A80', '', 'row1', 'row2', '', 'Verdana, serif', 'Arial, Helvetica, sans-serif', 'courier', '', '', '', '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 (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','','',''); SET IDENTITY_INSERT phpbb_themes OFF; @@ -194,44 +196,29 @@ SET IDENTITY_INSERT phpbb_smilies OFF; */ SET IDENTITY_INSERT phpbb_words ON; -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (1, 'bollocks', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (2, '*fuck*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (3, 'cunt*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (4, 'dick*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (5, '*shit*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (6, 'bitch', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (7, 'cock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (8, 'slut', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (9, 'pussy', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (10, 'prick', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (11, 'tits', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (12, 'piss*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (13, 'asshole', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (14, 'whore', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (15, 'cum', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (16, 'nutsack', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (17, 'clitsaq', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (18, '*wank*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (19, 'twat', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (20, 'c0ck', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (21, 'fuk*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (22, 'penis', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (23, 'fu(k', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (24, 'bastard', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (25, 'assram*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (26, 'dickweed', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (27, 'dickwad', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (28, 'frig*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (29, 'hore', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (30, 'fag*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (31, 'asswipe', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (32, 'asstool*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (33, '*cock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (34, 'b!tch', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (35, 'masturbation', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (36, 'dickhead', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (37, 'spunk', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES (38, '*crap*', '*beep*'); +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*'); SET IDENTITY_INSERT phpbb_words OFF; diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql index 48a9bbee58..f88c5fd914 100644 --- a/phpBB/db/mssql_schema.sql +++ b/phpBB/db/mssql_schema.sql @@ -302,7 +302,7 @@ GO CREATE TABLE [phpbb_themes] ( [themes_id] [int] IDENTITY (1, 1) NOT NULL , - [themes_name] [varchar] (50) NOT NULL , + [style_name] [varchar] (50) NOT NULL , [head_stylesheet] [varchar] (50) NULL , [body_background] [varchar] (50) NULL , [body_bgcolor] [char] (6) NULL , @@ -419,8 +419,7 @@ CREATE TABLE [phpbb_users] ( [user_posts] [int] NOT NULL , [user_timezone] [int] NOT NULL , [user_dateformat] [varchar] (15) NOT NULL , - [user_template] [varchar] (50) NULL , - [user_theme] [int] NULL , + [user_style] [int] NULL , [user_lang] [varchar] (50) NULL , [user_viewemail] [smallint] NULL , [user_attachsig] [smallint] NULL , @@ -439,7 +438,8 @@ CREATE TABLE [phpbb_users] ( [user_icq] [varchar] (15) NULL , [user_website] [varchar] (50) NULL , [user_from] [varchar] (200) NULL , - [user_sig] [varchar] (255) NULL , + [user_sig] [varchar] (255) NULL , + [user_sig_bbcode_uid] [char] (10) NULL, [user_aim] [varchar] (50) NULL , [user_yim] [varchar] (50) NULL , [user_msnm] [varchar] (50) NULL , diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 49254f5656..398f73db50 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -23,41 +23,46 @@ 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','0'); INSERT INTO phpbb_config VALUES ('allow_avatar_upload','0'); -INSERT INTO phpbb_config VALUES ('override_themes','0'); +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 ('email_sig','Thanks, The Management'); -INSERT INTO phpbb_config VALUES ('email_from','youraddress@yourdomain.com'); +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_theme','2'); +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','-8'); -INSERT INTO phpbb_config VALUES ('board_template','PSO'); +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, 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_theme, 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', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '0', '0', '1', '', '', '', '', '', '', '', '', '0', '0', ''); +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', '972086460', '', '', '', '', '', '', '', '', '', '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_theme, 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 ( '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', 'PSO'); +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', ''); @@ -66,37 +71,45 @@ INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, 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', '99999', '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_vote, topic_last_post_id) VALUES (1, 'Demo Topic', 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 the subject', 'This is a demo post in the demo topic, what do you think of it?'); + # -- Themes -INSERT INTO phpbb_themes (themes_id, themes_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,'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 (1,'Original default','Default','','','','','','','','','','','','','','','','','','','','','CCCCCC','DDDDDD','','','','','','','',NULL,NULL,NULL,'','','','','',''); -INSERT INTO phpbb_themes (themes_id, themes_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,'Default','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 (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, themes_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,'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 [ 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, themes_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,'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 [ 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, themes_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,'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 (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, themes_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,'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','','',''); # -- Smilies INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy'); @@ -140,41 +153,28 @@ INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', 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', 'bollocks', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '2', '*fuck*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '3', 'cunt*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '4', 'dick*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '5', '*shit*', '*beep*'); +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', 'cock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '8', 'slut', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '9', 'pussy', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '10', 'prick', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '11', 'tits', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '12', 'piss*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '13', 'asshole', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '14', 'whore', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '15', 'cum', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '16', 'nutsack', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '17', 'clitsaq', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '18', '*wank*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '19', 'twat', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '20', 'c0ck', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '21', 'fuk*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '22', 'penis', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '23', 'fu(k', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '24', 'bastard', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '25', 'assram*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '26', 'dickweed', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '27', 'dickwad', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '28', 'frig*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '29', 'hore', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '30', 'asswipe', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '31', 'asstool*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '32', '*cock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '33', 'b!tch', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '34', 'masturbat*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '35', 'dickhead', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '36', 'spunk', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '37', '*crap*', '*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*'); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index b61f071bde..c7a4ecd818 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -319,7 +319,7 @@ DROP TABLE IF EXISTS phpbb_themes; CREATE TABLE phpbb_themes ( themes_id int(11) NOT NULL auto_increment, template_name varchar(30) NOT NULL default '', - themes_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, @@ -457,8 +457,7 @@ CREATE TABLE phpbb_users ( user_posts int(11) DEFAULT '0' NOT NULL, user_timezone int(11) DEFAULT '0' NOT NULL, user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, - user_template varchar(50), - user_theme int(11), + user_style int(11), user_lang varchar(255), user_viewemail tinyint(1), user_attachsig tinyint(1), @@ -478,6 +477,7 @@ CREATE TABLE phpbb_users ( user_website varchar(100), user_from varchar(100), user_sig varchar(255), + user_sig_bbcode_uid char(10), user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), diff --git a/phpBB/db/oracle_basic.sql b/phpBB/db/oracle_basic.sql index 1424b08065..18a216f43c 100755 --- a/phpBB/db/oracle_basic.sql +++ b/phpBB/db/oracle_basic.sql @@ -8,7 +8,7 @@ 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','phpbb2mysql'); +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'); @@ -23,42 +23,47 @@ 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_themes','0'); +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 ('email_sig','Thanks, The Management'); -INSERT INTO phpbb_config VALUES ('email_from','youraddress@yourdomain.com'); +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_theme','2'); +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','-8'); -INSERT INTO phpbb_config VALUES ('board_template','PSO'); +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_theme, 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', ''); +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_theme, 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 ( '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', 'PSO'); +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', ''); @@ -67,36 +72,45 @@ INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, 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, themes_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,'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 (1,'Original default','Default','','','','','','','','','','','','','','','','','','','','','CCCCCC','DDDDDD','','','','','','','',NULL,NULL,NULL,'','','','','',''); -INSERT INTO phpbb_themes (themes_id, themes_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,'Default','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 (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, themes_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,'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 [ 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, themes_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,'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 [ 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, themes_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,'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 (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, themes_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,'Cool Midnight','PSO', '','','444444','ECECEC','EDF2F2','DDEDED','FFFFFF','EDF2F2','','','','','','','000000','80707F','66555F','','','','60707D','667A80','','row1','row2','','Verdana,serif','Helvetica,sans-serif','courier',NULL,NULL,NULL,'ECECEC','ECECEC','ECECEC','','',''); -- Smilies INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy'); @@ -140,4 +154,29 @@ INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', 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/oracle_schema.sql b/phpBB/db/oracle_schema.sql index 94fa2a6b0c..58f13740a4 100755 --- a/phpBB/db/oracle_schema.sql +++ b/phpBB/db/oracle_schema.sql @@ -15,7 +15,7 @@ /* CREATE TABLESPACE phpbb - DATAFILE '/path/to/oracle/oradata/SID/phpbb01.dbf' + DATAFILE 'E:/web/Oracle8i/ORADATA/phpbb01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 100M; @@ -298,7 +298,7 @@ CREATE TABLE phpbb_smilies ( -------------------------------------------------------- */ CREATE TABLE phpbb_themes ( themes_id number(4) NOT NULL, - themes_name varchar(30), + style_name varchar(30), template_name varchar(30) DEFAULT '' NOT NULL, head_stylesheet varchar(100), body_background varchar(100), @@ -443,7 +443,8 @@ CREATE TABLE phpbb_users ( user_from varchar(100), user_interests varchar(255), user_sig varchar(255), - user_theme number(4), + user_sig_bbcode_uid char(10), + user_style number(4), user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), @@ -460,7 +461,6 @@ CREATE TABLE phpbb_users ( user_avatar varchar(100), user_level number(4) DEFAULT '1', user_lang varchar(255), - user_template varchar(50), 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, @@ -516,4 +516,4 @@ CREATE TABLE phpbb_words ( CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id) ); -COMMIT;
\ No newline at end of file +COMMIT; diff --git a/phpBB/db/postgres_basic.sql b/phpBB/db/postgres_basic.sql index 995bb69436..9cd0a01283 100755 --- a/phpBB/db/postgres_basic.sql +++ b/phpBB/db/postgres_basic.sql @@ -8,7 +8,7 @@ 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','phpbb2mysql'); +INSERT INTO phpbb_config VALUES ('cookie_name','phpbb2postgres'); INSERT INTO phpbb_config VALUES ('cookie_path','/'); INSERT INTO phpbb_config VALUES ('cookie_domain',''); INSERT INTO phpbb_config VALUES ('cookie_secure','0'); @@ -23,41 +23,46 @@ 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_themes','0'); +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 ('email_sig','Thanks, The Management'); -INSERT INTO phpbb_config VALUES ('email_from','youraddress@yourdomain.com'); +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_theme','2'); +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','-8'); -INSERT INTO phpbb_config VALUES ('board_template','PSO'); +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_theme, 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', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '0', '0', '1', '', '', '', '', '', '', '', '', '0', '0', ''); +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', '972086460', '', '', '', '', '', '', '', '', '', '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_theme, 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 ( '2', 'Admin', '1', EXTRACT(EPOCH FROM TIMESTAMP 'now'), '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', 'PSO'); +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', EXTRACT(EPOCH FROM TIMESTAMP 'now'), '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', ''); @@ -66,36 +71,45 @@ INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, 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', '99999', '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, EXTRACT(EPOCH FROM 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, EXTRACT(EPOCH FROM TIMESTAMP 'now'), '', '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, themes_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,'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 (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, themes_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,'Default','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, themes_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,'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, themes_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,'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, themes_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,'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, themes_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,'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','','',''); -- Smilies INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '1', ':D', 'icon_biggrin.gif', 'Very Happy'); @@ -138,3 +152,29 @@ INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', 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*'); diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 0bbbb84e0a..6befe005ba 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -233,6 +233,18 @@ 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_sessions -------------------------------------------------------- */ CREATE TABLE phpbb_sessions ( @@ -267,7 +279,7 @@ CREATE TABLE phpbb_smilies ( -------------------------------------------------------- */ CREATE TABLE phpbb_themes ( themes_id int4 DEFAULT nextval('phpbb_themes_id_seq'::text) NOT NULL, - themes_name varchar(30), + style_name varchar(30), template_name varchar(30) NOT NULL default '', head_stylesheet varchar(100), body_background varchar(100), @@ -356,12 +368,12 @@ CREATE TABLE phpbb_themes_name ( -------------------------------------------------------- */ 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, - forum_id 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, @@ -369,8 +381,12 @@ CREATE TABLE phpbb_topics ( topic_last_post_id int4 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); +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); /* -------------------------------------------------------- @@ -381,8 +397,8 @@ CREATE TABLE phpbb_topics_watch ( user_id int4, notify_status int2 NOT NULL default '0' ); -CREATE INDEX _phpbb_topics_watch_index ON phpbb_topics_watch (topic_id, user_id); -CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); +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); /* -------------------------------------------------------- @@ -414,7 +430,8 @@ CREATE TABLE phpbb_users ( user_from varchar(100), user_interests varchar(255), user_sig varchar(255), - user_theme int4, + user_sig_bbcode_uid char(10), + user_style int4, user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), @@ -431,7 +448,6 @@ CREATE TABLE phpbb_users ( user_avatar varchar(100), user_level int4 DEFAULT '1', user_lang varchar(255), - user_template varchar(50), 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, |