bugnet.data.sqldataprovider.sql

BugNET is an issue tracking and project issue management solution built using the ASP.NET web applic

SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
-- Permissions 
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (1, N'CLOSE_ISSUE', N'Close Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (2, N'ADD_ISSUE', N'Add Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (3, N'ASSIGN_ISSUE', N'Assign Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (4, N'EDIT_ISSUE', N'Edit Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (5, N'SUBSCRIBE_ISSUE', N'Subscribe Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (6, N'DELETE_ISSUE', N'Delete Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (7, N'ADD_COMMENT', N'Add Comment')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (8, N'EDIT_COMMENT', N'Edit Comment')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (9, N'DELETE_COMMENT', N'Delete Comment')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (10, N'ADD_ATTACHMENT', N'Add Attachment')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (11, N'DELETE_ATTACHMENT', N'Delete Attachment')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (12, N'ADD_RELATED', N'Add Related Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (13, N'DELETE_RELATED', N'Delete Related Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (14, N'REOPEN_ISSUE', N'Re-Open Issue')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (15, N'OWNER_EDIT_COMMENT', N'Edit Own Comments')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (16, N'EDIT_ISSUE_DESCRIPTION', N'Edit Issue Description')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (17, N'EDIT_ISSUE_TITLE', N'Edit Issue Title')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (18, N'ADMIN_EDIT_PROJECT', N'Admin Edit Project')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (19, N'ADD_TIME_ENTRY', N'Add Time Entry')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (20, N'DELETE_TIME_ENTRY', N'Delete Time Entry')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (21, N'ADMIN_CREATE_PROJECT', N'Admin Create Project')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (22, N'ADD_QUERY', N'Add Query')
INSERT INTO [BugNet_Permissions] ([PermissionId], [PermissionKey], [PermissionName]) VALUES (23, N'DELETE_QUERY', N'Delete Query')

-- Host Settings 
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'AdminNotificationUsername', N'admin')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'ADPassword', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'ADPath', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'ADUserName', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'AllowedFileExtensions', N'*.*')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'ApplicationTitle', N'BugNET Issue Tracker')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'DefaultUrl', N'http://localhost/BugNet/')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'DisableAnonymousAccess', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'DisableUserRegistration', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'EmailErrors', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'EnabledNotificationTypes', N'Email;MSN')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'EnableRepositoryCreation', N'True')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'ErrorLoggingEmailAddress', N'[e-mail]')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'FileSizeLimit', N'2024')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'HostEmailAddress', N'[e-mail]')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3BodyTemplate', N'<div >Sent by:{1} on: {2}<br>{0}</div>')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3DeleteAllMessages', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3InlineAttachedPictures', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3Interval', N'6000')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3Password', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3ReaderEnabled', N'True')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3ReportingUsername', N'Admin')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3Server', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Pop3Username', N'bugnetuser')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'RepositoryBackupPath', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'RepositoryRootPath', N'C:\SVN\')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'RepositoryRootUrl', N'svn://localhost/')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPAuthentication', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPPassword', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPPort', N'25')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPServer', N'localhost')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPUsername', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SMTPUseSSL', N'False')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SvnAdminEmailAddress', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'SvnHookPath', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'UserAccountSource', N'None')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'Version', N'')
INSERT INTO [BugNet_HostSettings] ([SettingName], [SettingValue]) VALUES (N'WelcomeMessage', N'Welcome to your new BugNET installation! Log in as <br/><br/> Username: admin <br/>Password: password')

-- Custom Field Types 
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'Text')
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'Drop Down List')
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'Date')
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'Rich Text')
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'Yes / No')
INSERT INTO [BugNet_ProjectCustomFieldTypes] ([CustomFieldTypeName]) VALUES (N'User List')

-- Required Field List
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'-- Select Field --', N'0')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Issue ID', N'IssueID')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Title', N'IssueTitle')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Category', N'IssueCategoryId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Priority', N'IssuePriorityId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Milestone', N'IssueMilestoneId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Status', N'IssueStatusId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Assigned', N'IssueAssignedId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Owner', N'IssueOwnerId')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Creator', N'IssueCreatorId')