diff options
Diffstat (limited to 'phpBB/db/mssql_basic.sql')
| -rw-r--r-- | phpBB/db/mssql_basic.sql | 89 |
1 files changed, 38 insertions, 51 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; |