bugnet.data.sqldataprovider.sql

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

INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Date Created', N'DateCreated')
INSERT INTO [BugNet_RequiredFieldList] ([FieldName], [FieldValue]) VALUES (N'Custom Fields', N'CustomFieldName')

-- Roles and Permissions 
PRINT 'Add Default Roles & Permissions'
EXEC BugNet_Role_CreateNewRole @ProjectId = NULL, @RoleName = 'Super Users', @RoleDescription = 'A role for project super users', @AutoAssign = 0

-- String Resources
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'AssgnedTo', N'Assigned To')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Assigned', N'Assigned')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Cancel', N'Cancel')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Category', N'Category')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'ChangePassword', N'Change Password')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'ConfirmPassword', N'Confirm Password:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'ConfirmPasswordErrorMessage', N'The passsword and confirmation password must match.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Created', N'Created')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Creator', N'Creator')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Delete', N'Delete')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Description', N'Description')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'DisplayName', N'Display Name:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'DueDate', N'Due Date')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Edit', N'Edit')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Email', N'Email:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Estimation', N'Estimation')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms ', N'en ', N'EstimationHours', N'Estimation (hrs)')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'FirstName', N'First Name:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Id', N'Id')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'IssueHeader', N'Issue (click title to view details)')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'IssueId', N'Issue Id:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'LastName', N'Last Name:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'LastUpdate', N'Last Update')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'LastUpdateUser', N'Last Update User')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Milestone', N'Milestone')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'NoIssueResults', N'There are no issues that match your criteria.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Of', N'of')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Owner', N'Owner')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Page', N'Page')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Password', N'Password:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Priority', N'Priority')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Private', N'Private')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Progress', N'Progress')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Required', N'(required)')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Resolution', N'Resolution')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Return', N'Return')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Save', N'Save')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Status', N'Status')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Submit', N'Submit')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'TimeLogged', N'Time Logged')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'TimeLoggedHours', N'Time Logged (hrs)')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Title', N'Title')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Type', N'Type')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'Username', N'Username:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'CommonTerms', N'en', N'UsernameRequired.ErrorMessage', N'Username is required.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.CreateUserText', N'Register')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.FailureText', N'Your login attempt was not successful. Please try again.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.LoginButtonText', N'Log in')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.PasswordRecoveryText', N'Forgot your password?')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.RememberMeText', N'Remember me next time.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.Text', N'Log In')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'LoginControl.TitleText', N'Login')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'en', N'Page.Title', N'Home')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Default.aspx', N'fr-FR', N'Page.Title', N'This is testing the localization features ')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ErrorMessages', N'en', N'InvalidFileType', N'{0} does not meet the allowed file types.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ErrorMessages', N'en', N'UploadPathNotDefined', N'Project upload path has not been defined for project {0}.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ErrorMessages', N'en ', N'UploadPathNotFound', N'Upload directory {0} can not be found. Please check with the administrator that the directory exists on the web server.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'CapchaTest.ControlMessage', N'Enter the code you see:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'CodeIncorrectError', N'The code you entered was incorrect.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'EmailPasswordReminderError', N'An error occured sending the password reminder.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'lblInstructions.Text', N'Enter your username to receive your password.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'lblTitle.Text', N'Forgot Your Password?')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'Page.Title', N'Forgot Password')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'PasswordReminderSuccess', N'Your password has been emailed to you successfully.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'ForgotPassword.aspx', N'en', N'UserNotFoundError', N'The user you entered was not found.')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'btnAdd.Text', N'Create New Issue')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'InLabel.Text', N'in')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ListItem1.Text', N'Relevant to You')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ListItem2.Text', N'Assigned to You')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ListItem3.Text', N'Owned by You')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ListItem4.Text', N'Created by You')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ListItem5.Text', N'All Issues')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'Page.Title', N'Issue List')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'IssueList.aspx', N'en', N'ViewIssuesLabel.Text', N'View Issues')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'AssignedToLabel.Text', N'Assigned To:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'ByLabel.Text', N'By:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'CategoryLabel.Text', N'Category:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'DateCreatedLabel.Text', N'Date Created:')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'DeleteIssue', N'Are you sure you want to delete this issue?')
INSERT INTO [BugNet_StringResources] ([resourceType], [cultureCode], [resourceKey], [resourceValue]) VALUES (N'Issues/IssueDetail.aspx', N'en', N'DetailsLabel.Text', N'Details')