/*

  Basic DB data for PNphpBB2 devel (MSSQL)

 $Id: pnphpbb2_mssql_basic.sql,v 1.2 2004/07/13 21:16:21 carls Exp $

*/

BEGIN TRANSACTION;

/*
  -- PNphpBB2 Module Config parms
*/
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_version', '1.2f');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_logo_on', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_quickreply', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_shorturls', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_post_confirm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_post_order', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_allow_full_page', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_full_page','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_pn_pm','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_template_compiler','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_members_online','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_members_online_annon','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_allow_sub_change','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_sub_forum','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_enable_announce','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_split_global_announce','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_announcement_duration','7');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_split_announce','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_split_sticky','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_post_images','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_forum_announce_exclude','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_pn_link', "");
INSERT INTO phpbb_config (config_name, config_value) VALUES ('pnphpbb2_pn_text', "");

/*
  -- eXtreme Styles mod
*/
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_cache_dir', 'cache');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_cache_dir_absolute', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_auto_compile', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_auto_recompile', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_use_cache', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_separator', '/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_php', "php");
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_def_template', 'PNTheme');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_use_isset', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('xs_check_switches', 1);

/*
	-- Topic and Post icons
*/
ALTER TABLE [phpbb_posts] ADD COLUMN [post_icon] [smallint] UNSIGNED DEFAULT '0' NOT NULL; 
ALTER TABLE [phpbb_topics] ADD COLUMN [topic_icon] [smallint] UNSIGNED DEFAULT '0' NOT NULL; 

/*
  -- Forum sub-categories
*/
ALTER TABLE [phpbb_categories] ADD [cat_main] [int] UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE [phpbb_categories] ADD [cat_desc] [varchar] (255) NOT NULL;

/*
  -- Forum sort options
*/
ALTER TABLE [phpbb_forums] ADD COLUMN [topic_sort_order] [smallint] DEFAULT '0' NOT NULL;
ALTER TABLE [phpbb_forums] ADD COLUMN [post_sort_order] [smallint] DEFAULT '0' NOT NULL;

COMMIT;