INSERT INTO ConfigurationAdmin VALUES ('Topic_SortOrder', 'la_Text_Topics', 'la_topic_sortfield_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.01, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_SortField', 'la_Text_Topics', 'la_topic_sortfield_prompt', 'select', '', 'TopicText=la_Topic_Text,Posts=la_Number_of_Posts,CreatedOn=la_CreatedOn,LastPostDate=la_LastUpdate,Views=la_Topic_Views,CachedRating=la_Rating,LastPoser=la_Poster,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 3) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_SortField2', 'la_Text_Topics', 'la_topic_sortfield2_prompt', 'select', '', 'TopicText=la_Topic_Text,Posts=la_Number_of_Posts,CreatedOn=la_CreatedOn,LastPostDate=la_LastUpdate,Views=la_Topic_Views,CachedRating=la_Rating,LastPoser=la_Poster,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 3) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_NewDays', 'la_Text_Topics', 'la_topic_newdays_prompt', 'text', '', 'asc=la_common_ascending,desc=la_common_descending', 10.05, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_SortOrder2', 'la_Text_Topics', 'la_topic_sortfield2_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.02, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Topics', 'la_Text_Topics', 'la_topic_perpage_prompt', 'text', '', '', 10.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_MinPopRating', 'la_Text_Topics', 'la_fld_Topic_MinPopRating', 'text', '', '', 10.06, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_MaxHotNumber', 'la_Text_Topics', 'la_fld_Topic_MaxHotNumber', 'text', '', '', 10.08, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_EditorPicksAbove', 'la_Text_Topics', 'la_topic_editorpicksabove_prompt', 'checkbox', '', '', 10.09, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Postings', 'la_posts_subheading', 'la_posts_perpage_prompt', 'text', '', '', 20.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Posts_NewDays', 'la_posts_subheading', 'la_posts_newdays_prompt', 'text', '', '', 20.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Topic_MinPopVotes', 'la_Text_Topics', 'la_fld_Topic_MinPopVotes', 'text', '', '', 10.07, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Topics_Short', 'la_Text_Topics', 'la_topic_perpage_short_prompt', 'text', '', '', 10.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('topic_ReviewDelay_Value', 'la_Text_Topics', 'la_prompt_DupReviews', 'text', '', '', 10.1, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('topic_ReviewDelay_Interval', 'la_Text_Topics', 'la_prompt_DupReviews', 'select', '', '1=la_Text_Second,60=la_Text_Minute,3600=la_Text_Hour,86400=la_Text_Day,604800=la_Text_Week,2419200=la_Text_Month,29030400=la_text_Year', 10.1, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('topic_RatingDelay_Value', 'la_Text_Topics', 'la_prompt_DupRating', 'text', '', '', 10.11, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('topic_RatingDelay_Interval', 'la_Text_Topics', 'la_prompt_DupRating', 'select', '', '1=la_Text_Second,60=la_Text_Minute,3600=la_Text_Hour,86400=la_Text_Day,604800=la_Text_Week,2419200=la_Text_Month,29030400=la_text_Year', 10.11, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('AutoTopicLockPosts', 'la_Text_Topics', 'la_prompt_PostsToLock', 'text', NULL, NULL, 10.12, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_TopicReviews', 'la_Text_Reviews', 'la_review_perpage_prompt', 'text', NULL, NULL, 30.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('bb_CategoryTemplate', 'la_section_Templates', 'la_fld_CategoryTemplate', 'text', '', '', 40.01, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('bb_ItemTemplate', 'la_section_Templates', 'la_fld_ItemTemplate', 'text', '', '', 40.02, 0, 0);

INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Keyword_topics', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Pop_topics', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Rating_topics', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Increase_topics', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_ShowMultiple_topics', 'la_config_ShowMultiple', 'la_Text_MultipleShow', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_PrivateMessages', 'la_text_PrivateMessages', 'la_text_PrivateMessages_PerPage', 'text', NULL, NULL, 0, 0, 1);

INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Postings', '25', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Topics', '5', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Posting_SortOrder', 'CreatedOn asc, PostingText', 'inportal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Posts_NewDays', '5', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Bulletin_TopCount', '2', 'inportal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Bulletin_CatNewDays', '10', 'inportal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Bulletin_Pick_First', '1', 'inportal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_SortOrder', 'desc', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_SortField', 'LastPostDate', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_SortOrder2', 'desc', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_SortField2', 'Posts', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_NewDays', '6', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_MinPopRating', '3', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_MaxHotNumber', '3', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_EditorPicksAbove', '1', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_MinPopVotes', '8', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_Root', '{TopicCatId}', 'In-Portal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Post_Sortfield', NULL, 'In-Bulletin', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Post_SortOrder', NULL, 'In-Bulletin', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'BBTags', 'b:;i:;u:;ul:type|align;font:color|face|size;url:href;img:src|border', 'In-Portal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Post_Background1', '#cccccc', 'In-Portal', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Post_Background2', '#bbbbbb', 'In-Portal', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_Background1', '#FAEBD7', 'In-Portal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_Background2', '#F5F5DC', 'In-Portal', '')
INSERT INTO ConfigurationValues VALUES (NULL, 'AutoTopicLockPosts', '0', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'bb_CategoryTemplate', 'inbulletin/index', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'bb_ItemTemplate', 'inbulletin/post_list', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_Highlight_OpenTag', '<span class="match">', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Topic_Highlight_CloseTag', '</span>', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Topics_Short', '3', 'In-Bulletin', 'in-bulletin:configuration_output')
INSERT INTO ConfigurationValues VALUES (NULL, 'topic_RatingDelay_Interval', '3600', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'topic_RatingDelay_Value', '1', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'topic_ReviewDelay_Interval', '60', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'topic_ReviewDelay_Value', '10', 'In-Bulletin', 'in-bulletin:configuration_output');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Increase_topics', '30', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Keyword_topics', '90', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Pop_topics', '5', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Rating_topics', '5', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Increase_posts', '30', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Keyword_posts', '90', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Pop_posts', '5', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Rating_posts', '5', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'Search_ShowMultiple_topics', '0', 'In-Bulletin', 'in-bulletin:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_PrivateMessages', '20', 'In-Bulletin', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_TopicReviews', '10', 'In-Bulletin', 'in-bulletin:configuration_output');

INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (1, 'Happy Smile', 0, ':)', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (2, 'Big Grin', 0, ':grin:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (3, 'Wink', 0, ';)', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (4, 'Scared', 0, ':scared:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (5, 'Teasing', 0, ':eek:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (6, 'Cool', 0, ':cool:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (7, 'Angry', 0, ':@', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (8, 'Squint', 0, ':squint:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (9, 'Oops', 0, ':o', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (10, 'Sad', 0, ':(', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (11, 'Cry', 0, ':cry:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (12, 'Smirk', 0, ';]', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (13, 'Happy sleep', 0, ':sleep:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (14, 'Very angry', 0, ':x', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (15, 'Geek', 0, ':geek:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (16, 'Upset', 0, ';(', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (17, 'LOL', 0, ':lol:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (18, 'Yawn', 0, ':O', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (19, 'Thinking', 0, ':hm:', 1);
INSERT INTO Emoticon (EmoticonId, Name, ImageId, KeyStroke, Enabled) VALUES (20, 'Secret', 0, ':|', 1);

INSERT INTO Events VALUES (1, 'TOPIC.ADD', 2, 0, 'In-Bulletin', 'la_event_topic.add', 1)
INSERT INTO Events VALUES (2, 'POST.ADD', 2, 0, 'In-Bulletin', 'la_event_post.add', 1)
INSERT INTO Events VALUES (3, 'POST.MODIFY', 2, 0, 'In-Bulletin', 'la_event_post.modify', 1)
INSERT INTO Events VALUES (4, 'POST.ADD', 1, 0, 'In-Bulletin', 'la_event_post.add', 0)
INSERT INTO Events VALUES (66, 'PM.ADD', 1, 0, 'In-Bulletin', 'la_event_pm.add', 0);

INSERT INTO ItemTypes VALUES (3, 'In-Bulletin', 'bb', 'Topic', 'TopicText', 'OwnerId', 'Views', 'CachedRating', 'la_ItemTab_Topics', 1, '', 'clsTopic', 'Topic');
INSERT INTO ItemTypes VALUES (30, 'In-Bulletin', 'posting', 'Posting', 'Subject', 'CreatedById', NULL, NULL, 'la_ItemTab_Posts', 0, '', '', 'Post');

INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.VIEW', 'lu_PermName_Topic.View_desc', 'lu_PermName_Topic.View_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.ADD', 'lu_PermName_Topic.Add_desc', 'lu_PermName_Topic.Add_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.ADD.PENDING', 'lu_PermName_Topic.Add.Pending_desc', 'lu_PermName_Topic.Add.Pending_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.DELETE', 'lu_PermName_Topic.Delete_desc', 'lu_PermName_Topic.Delete_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.MODIFY', 'lu_PermName_Topic.Modify_desc', 'lu_PermName_Topic.Modify_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.DELETE', 'lu_PermName_Topic.Reply.Delete_desc', 'lu_PermName_Topic.Reply.Delete_desc', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.VIEW', 'lu_PermName_Topic.Reply.View_desc', 'lu_PermName_Topic.Reply.View_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.ADD', 'lu_PermName_Topic.Reply.Add_desc', 'lu_PermName_Topic.Reply.Add_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.MODIFY', 'lu_PermName_Topic.Reply.Modify_desc', 'lu_PermName_Topic.Reply.Modify_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.RATE', 'lu_PermName_Topic.Rate_desc', 'lu_PermName_Topic.Rate_desc', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REVIEW', 'lu_PermName_Topic.Review_desc', 'lu_PermName_Topic.Review_desc', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.OWNER.MODIFY', 'lu_PermName_Topic.Reply.Owner.Modify_desc', 'lu_PermName_Topic.Reply.Owner.Modify_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.REPLY.OWNER.DELETE', 'lu_PermName_Topic.Reply.Owner.Delete_desc', 'lu_PermName_Topic.Reply.Owner.Delete_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.OWNER.DELETE', 'lu_PermName_Topic.Owner.Delete_desc', 'lu_PermName_Topic.Owner.Delete_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.MODIFY.PENDING', 'lu_PermName_Topic.Modify.Pending_desc', 'lu_PermName_Topic.Modify.Pending_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.OWNER.MODIFY.PENDING', 'lu_PermName_Topic.Owner.Modify.Pending_desc', 'lu_PermName_Topic.Owner.Modify.Pending_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.OWNER.MODIFY', 'lu_PermName_Topic.Owner.Modify_desc', 'lu_PermName_Topic.Owner.Modify_error', 'In-Bulletin');
INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('TOPIC.LOCK', 'lu_PermName_Topic.Lock_desc', 'lu_PermName_Topic.Lock_error', 'In-Bulletin');

INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT count(*) FROM <%prefix%>Topic WHERE Status=1', NULL, 'la_prompt_ActiveTopics', 0, 1);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS TotalTopics FROM <%prefix%>Topic', NULL, 'la_prompt_TopicsTotal', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS ActiveTopics FROM <%prefix%>Topic WHERE Status = 1', NULL, 'la_prompt_TopicsActive', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS PendingTopics FROM <%prefix%>Topic WHERE Status = 2', NULL, 'la_prompt_TopicsPending', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS DisabledTopics FROM <%prefix%>Topic WHERE Status = 0', NULL, 'la_prompt_TopicsDisabled', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS NewTopics FROM <%prefix%>Topic WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Topic_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewTopics', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) FROM <%prefix%>Topic WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickTopics', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS HotTopics FROM <%prefix%>Topic WHERE (HotItem = 1) OR (Posts >= <%m:config name="Topic_VotesToHot"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotTopics', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS PopularTopics FROM <%prefix%>Topic WHERE (PopItem = 1) OR ( (CachedRating >= <%topic:hit_count type="top"%>) AND <%topic:hit_count type="top"%> AND (PopItem = 2) )', NULL, '(*) la_prompt_PopularTopics', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Topic WHERE CachedRating > 0', NULL, 'la_prompt_TopicAverageRating', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT MAX(Views) AS MaxTopicHits FROM <%prefix%>Topic', NULL, 'la_prompt_MaxTopicHits', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT MAX(CachedVotesQty) AS MaxTopicVotes FROM <%prefix%>Topic', NULL, 'la_prompt_MaxTopicVotes', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Topic', NULL, 'la_prompt_NewestTopicDate', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="time"%> FROM <%prefix%>Topic', NULL, 'la_prompt_NewestTopicTime', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Topic', NULL, 'la_prompt_LastUpdatedTopicDate', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(Modified)" type="time"%> FROM <%prefix%>Topic', NULL, 'la_prompt_LastUpdatedTopicTime', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_TopicReviews', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT COUNT(*) AS TotalPosts FROM <%prefix%>Posting', NULL, 'la_prompt_PostsTotal', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Posting', NULL, 'la_prompt_NewestPostDate', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="time"%> FROM <%prefix%>Posting', NULL, 'la_prompt_NewestPostTime', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Posting', NULL, 'la_prompt_LastUpdatedPostDate', 0, 2);
INSERT INTO StatItem VALUES (0, 'In-Bulletin', 'SELECT <%m:post_format field="MAX(Modified)" type="time"%> FROM <%prefix%>Posting', NULL, 'la_prompt_LastUpdatedPostTime', 0, 2);

INSERT INTO SearchConfig VALUES ('Topic', 'NotifyOwnerOnChanges', 0, 1, 'lu_fielddesc_topic_notifyowneronchanges', 'lu_field_notifyowneronchanges', 'In-Bulletin', 'la_text_topic', 1, 0, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'TopicId', 0, 1, 'lu_fielddesc_topic_topicid', 'lu_field_topicid', 'In-Bulletin', 'la_text_topic', 0, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'Priority', 0, 1, 'lu_fielddesc_topic_priority', 'lu_field_priority', 'In-Bulletin', 'la_text_topic', 8, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'OwnerId', 0, 1, 'lu_fielddesc_topic_ownerid', 'lu_field_ownerid', 'In-Bulletin', 'la_text_topic', 9, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'Modified', 0, 1, 'lu_fielddesc_topic_modified', 'lu_field_modified', 'In-Bulletin', 'la_text_topic', 2, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'TopicText', 1, 1, 'lu_fielddesc_topic_topictext', 'lu_field_topictext', 'In-Bulletin', 'la_text_topic', 3, 0, 1, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'Posts', 0, 1, 'lu_fielddesc_topic_posts', 'lu_field_posts', 'In-Bulletin', 'la_text_topic', 4, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'Views', 0, 1, 'lu_fielddesc_topic_views', 'lu_field_views', 'In-Bulletin', 'la_text_topic', 5, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'EditorsPick', 0, 1, 'lu_fielddesc_topic_editorspick', 'lu_field_editorspick', 'In-Bulletin', 'la_text_topic', 6, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'Status', 0, 1, 'lu_fielddesc_topic_status', 'lu_field_status', 'In-Bulletin', 'la_text_topic', 7, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'ModifiedById', 0, 1, 'lu_fielddesc_topic_modifiedbyid', 'lu_field_modifiedbyid', 'In-Bulletin', 'la_text_topic', 10, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'ResourceId', 0, 1, 'lu_fielddesc_topic_resourceid', 'lu_field_resourceid', 'In-Bulletin', 'la_text_topic', 11, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'TopicType', 0, 1, 'lu_fielddesc_topic_topictype', 'lu_field_topictype', 'In-Bulletin', 'la_text_topic', 12, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'CreatedOn', 0, 1, 'lu_fielddesc_topic_createdon', 'lu_field_createdon', 'In-Bulletin', 'la_text_topic', 13, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'CachedReviewsQty', 0, 1, 'lu_fielddesc_topic_cachedreviewsqty', 'lu_field_cachedreviewsqty', 'In-Bulletin', 'la_text_topic', 14, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'CachedRating', 0, 1, 'lu_fielddesc_topic_cachedrating', 'lu_field_cachedrating', 'In-Bulletin', 'la_text_topic', 15, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'CachedVotesQty', 0, 1, 'lu_fielddesc_topic_cachedvotesqty', 'lu_field_cachedvotesqty', 'In-Bulletin', 'la_text_topic', 16, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'NewItem', 0, 1, 'lu_fielddesc_topic_newitem', 'lu_field_newitem', 'In-Bulletin', 'la_text_topic', 17, 0, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'PopItem', 0, 1, 'lu_fielddesc_topic_popitem', 'lu_field_popitem', 'In-Bulletin', 'la_text_topic', 18, 0, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'HotItem', 0, 1, 'lu_fielddesc_topic_hotitem', 'lu_field_hotitem', 'In-Bulletin', 'la_text_topic', 19, 0, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'PostedBy', 0, 1, 'lu_fielddesc_topic_postedby', 'lu_field_postedby', 'In-Bulletin', 'la_text_topic', 20, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'OrgId', 0, 1, 'lu_fielddesc_topic_orgid', 'lu_field_orgid', 'In-Bulletin', 'la_text_topic', 21, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO SearchConfig VALUES ('Topic', 'LastPostId', 0, 1, 'lu_fielddesc_topic_lastpostid', 'lu_field_lastpostid', 'In-Bulletin', 'la_text_topic', 22, 0, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.VIEW', 14, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.VIEW', 14, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.VIEW', 14, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.VIEW', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('FAVORITES', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.VIEW', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.VIEW', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.ADD', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.MODIFY', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.DELETE', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.DELETE', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.MODIFY.PENDING', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.MODIFY', 12, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.VIEW', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.ADD.PENDING', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('FAVORITES', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.VIEW', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.ADD', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.VIEW', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.ADD', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.RATE', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REVIEW', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.MODIFY', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.DELETE', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.MODIFY', 13, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.VIEW', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.ADD', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.DELETE', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('CATEGORY.MODIFY', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('FAVORITES', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.VIEW', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.ADD', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.DELETE', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.MODIFY', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.DELETE', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.VIEW', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.ADD', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.MODIFY', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.RATE', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REVIEW', 11, 1, 0, {TopicCatId});
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.VIEW', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.ADD', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.ADD.PENDING', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.DELETE', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.MODIFY', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.DELETE', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.VIEW', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.ADD', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.MODIFY', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.RATE', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REVIEW', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.MODIFY', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.REPLY.OWNER.DELETE', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.DELETE', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.MODIFY.PENDING', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.MODIFY.PENDING', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.OWNER.MODIFY', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('TOPIC.LOCK', 15, 0, 0, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:inbulletin_general.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:inbulletin_general.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_output.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_output.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_search.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_search.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_censorship.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_censorship.add', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_censorship.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_emoticon.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_emoticon.add', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_emoticon.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_email.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_email.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_custom.view', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_custom.add', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_custom.edit', 11, 1, 1, 0);
INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('in-bulletin:configuration_custom.delete', 11, 1, 1, 0);

INSERT INTO ImportScripts(is_string_id,is_Module,is_script,is_label,is_field_prefix,is_requred_fields,is_enabled,is_type) VALUES ('phpbb', 'In-Bulletin', 'phpbb_import', 'phpBB 2.x', 'phpBB', 'user_regular,init_cat', 1, 'db');

INSERT INTO CustomField (Type, FieldName, FieldLabel, Heading, Prompt, ElementType, ValueList, DisplayOrder, OnGeneralTab, IsSystem) VALUES (1, 'bb_ItemTemplate', 'bb_ItemTemplate', 'la_title_SystemCF', 'bb_ItemTemplate', 'text', NULL, 0, 0, 1);

INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Bulletin', 'in-bulletin/', 'bb', '1.2.1', 1, 3, 'inbulletin/', {TopicCatId}, '1054738405');