0.66.sqldataprovider.sql

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

drop procedure [dbo].[BugNet_Component_GetComponentsByProjectId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Environment_GetAllEnvironments]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Environment_GetAllEnvironments]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Environment_GetEnvironmentById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Environment_GetEnvironmentById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Hardware_GetAllHardware]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Hardware_GetAllHardware]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Hardware_GetHardwareById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Hardware_GetHardwareById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_History_CreateNewHistory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_History_CreateNewHistory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_History_GetHistoryByBugId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_History_GetHistoryByBugId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_HostSettings_GetHostSettings]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_HostSettings_GetHostSettings]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_HostSettings_UpdateHostSetting]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_HostSettings_UpdateHostSetting]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_OperatingSystem_GetAllOperatingSystems]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_OperatingSystem_GetAllOperatingSystems]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_OperatingSystem_GetOperatingSystemById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_OperatingSystem_GetOperatingSystemById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Permission_AddRolePermission]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Permission_AddRolePermission]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Permission_DeleteRolePermission]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Permission_DeleteRolePermission]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Permission_GetAllPermissions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Permission_GetAllPermissions]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Permission_GetPermissionsByRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Permission_GetPermissionsByRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Permission_GetRolePermission]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Permission_GetRolePermission]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Priority_GetAllPriorities]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Priority_GetAllPriorities]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Priority_GetPriorityById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Priority_GetPriorityById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_AddUserToProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_AddUserToProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_CreateNewProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_CreateNewProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_CreateProjectMailbox]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_CreateProjectMailbox]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_DeleteProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_DeleteProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_DeleteProjectMailbox]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_DeleteProjectMailbox]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetAllProjects]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetAllProjects]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetMailboxByProjectId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetMailboxByProjectId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetProjectByCode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetProjectByCode]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetProjectById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetProjectById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetProjectsByUserId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetProjectsByUserId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_GetPublicProjects]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_GetPublicProjects]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_RemoveUserFromProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_RemoveUserFromProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Project_UpdateProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Project_UpdateProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_RelatedBug_CreateNewRelatedBug]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_RelatedBug_CreateNewRelatedBug]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_RelatedBug_DeleteRelatedBug]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_RelatedBug_DeleteRelatedBug]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_RelatedBug_GetRelatedBugsByBugId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_RelatedBug_GetRelatedBugsByBugId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Resolution_GetAllResolutions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Resolution_GetAllResolutions]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Resolution_GetResolutionById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Resolution_GetResolutionById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_AddUserToRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_AddUserToRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_CreateNewRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_CreateNewRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_DeleteRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_DeleteRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_GetAllRoles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_GetAllRoles]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_GetRoleById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_GetRoleById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_GetRolesByProject]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_GetRolesByProject]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_GetRolesByUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_GetRolesByUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_GetRolesByUserId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_GetRolesByUserId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_IsUserInRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_IsUserInRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_RemoveUserFromRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_RemoveUserFromRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_RoleHasPermission]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_RoleHasPermission]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Role_UpdateRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Role_UpdateRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Status_GetAllStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Status_GetAllStatus]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Status_GetStatusById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Status_GetStatusById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_CreateNewTimeEntry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_CreateNewTimeEntry]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_DeleteTimeEntry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_DeleteTimeEntry]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_GetProjectWorkerWorkReport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_GetProjectWorkerWorkReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_GetWorkReportByBugId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_GetWorkReportByBugId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_GetWorkReportByProjectId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_GetWorkReportByProjectId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_TimeEntry_GetWorkerOverallWorkReportByWorkerId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_TimeEntry_GetWorkerOverallWorkReportByWorkerId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Type_GetAllTypes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Type_GetAllTypes]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Type_GetTypeById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Type_GetTypeById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_Authenticate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_Authenticate]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_CreateNewUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_CreateNewUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_GetAllUsers]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_GetAllUsers]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_GetUserById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_GetUserById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_GetUserByUsername]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_GetUserByUsername]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_GetUsersByProjectId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_GetUsersByProjectId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_IsProjectMember]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_IsProjectMember]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_User_UpdateUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_User_UpdateUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Version_CreateNewVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Version_CreateNewVersion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Version_DeleteVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Version_DeleteVersion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Version_GetVersionById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Version_GetVersionById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BugNet_Version_GetVersionByProjectId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[BugNet_Version_GetVersionByProjectId]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_Attachment_CreateNewAttachment
  @BugId int,
  @FileName nvarchar(100),
  @Description nvarchar(80),
  @FileSize Int,
  @ContentType nvarchar(50),
  @UploadedUserName nvarchar(100)
AS
-- Get Uploaded UserID
DECLARE @UploadedUserId Int
SELECT @UploadedUserId = UserId FROM Users WHERE Username = @UploadedUserName
	INSERT BugAttachment
	(
		BugID,
		FileName,
		Description,
		FileSize,
		Type,
		UploadedDate,
		UploadedUser
	)
	VALUES
	(
		@BugId,
		@FileName,
		@Description,
		@FileSize,
		@ContentType,
		GetDate(),
		@UploadedUserId
	)
	RETURN @@IDENTITY
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_Attachment_GetAttachmentById
 @AttachmentId INT
AS
SELECT
	BugAttachmentId,
	BugId,
	FileName,
	Description,
	FileSize,
	Type,
	UploadedDate,
	UploadedUser,
	Creators.UserName CreatorUserName,
	Creators.DisplayName CreatorDisplayName
FROM 
	BugAttachment
	INNER JOIN Users Creators ON Creators.UserId = BugAttachment.UploadedUser
WHERE
	BugAttachmentId = @AttachmentId
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_Attachment_GetAttachmentsByBugId
 @BugId INT
AS
SELECT
	BugAttachmentId,
	BugId,
	FileName,
	Description,
	FileSize,
	Type,
	UploadedDate,
	UploadedUser,
	Creators.UserName CreatorUserName,
	Creators.DisplayName CreatorDisplayName
FROM 
	BugAttachment
	INNER JOIN Users Creators ON Creators.UserId = BugAttachment.UploadedUser
WHERE
	BugId = @BugId
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_BugNotification_CreateNewBugNotification
	@BugId Int,
	@NotificationUsername NVarChar(255) 
AS
DECLARE @UserId Int
SELECT @UserId = UserId FROM Users WHERE Username = @NotificationUsername
IF NOT EXISTS( SELECT BugNotificationId FROM BugNotification WHERE UserId = @UserId AND BugId = @BugId)
BEGIN
	INSERT BugNotification
	(
		BugId,
		UserId
	)
	VALUES
	(
		@BugId,
		@UserId
	)
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_BugNotification_DeleteBugNotification
	@BugId Int,
	@Username NVarChar(255)
AS
DECLARE @UserId Int
SELECT @UserId = UserId FROM Users WHERE Username = @Username
DELETE 
	BugNotification
WHERE
	BugId = @BugId
	AND UserId = @UserId 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_BugNotification_GetBugNotificationsByBugId 
	@BugId Int
AS
SELECT 
	BugNotificationId,
	BugId,
	Username NotificationUsername,
	DisplayName NotificationDisplayName,
	Email NotificationEmail
FROM
	BugNotification
	INNER JOIN Users ON BugNotification.UserId = Users.UserId
WHERE
	BugId = @BugId
ORDER BY
	DisplayName

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_Bug_CreateNewBug
  @Summary nvarchar(500),
  @Description text,
  @Url nvarchar(500),
  @ProjectId Int,
  @ComponentId Int,
  @StatusId Int,
  @PriorityId Int,
  @VersionId Int,
  @HardwareId Int,
  @EnvironmentId int,
  @TypeId Int,
  @OperatingSystemId Int,
  @ResolutionId Int,
  @AssignedTo Int,
  @ReportedUser NVarChar(200)
AS
DECLARE @newIssueId Int
-- Get Reporter UserID
DECLARE @ReporterId Int
SELECT @ReporterId = UserId FROM Users WHERE Username = @ReportedUser
	INSERT Bug
	(
		Summary,
		Description,
		Url,
		ReportedUser,
		ReportedDate,
		StatusID,
		PriorityID,
		TypeId,
		EnvironmentID,
		ComponentID,
		AssignedTo,
		HardwareId,
		OperatingSystemId,
		ProjectId,
		ResolutionId,
		VersionId,
		LastUpdateUser,
		LastUpdate
	)
	VALUES
	(
		@Summary,
		@Description,
		@Url,
		@ReporterId,
		GetDate(),
		@StatusId,
		@PriorityId,
		@TypeId,
		@EnvironmentId,
		@ComponentId,
		@AssignedTo,
		@HardwareId,
		@OperatingSystemId,
		@ProjectId,
		@ResolutionId,
		@VersionId,
		@ReporterId,
		GetDate()
	)
RETURN scope_identity()
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE BugNet_Bug_GetBugById 
  @BugId Int
AS
SELECT 
	*
FROM 
	BugsView
WHERE
	BugId = @BugId

GO
SET QUOTED_IDENTIFIER OFF 
GO