SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [{databaseOwner}].[{objectQualifier}usercomments](
 [moduleid] [int] null,
 [comment] [text] NULL,
 [date] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

---------------------------------
create procedure [{databaseOwner}].[sp_viewcomments]

@moduleid int
 
AS

BEGIN
SET NOCOUNT ON
 SELECT moduleid, comment, date from [{objectQualifier}usercomments] where moduleid=@moduleid
end
go

------------------------------
create PROCEDURE [{databaseOwner}].[sp_usercommentsinsert]
  
@moduleid int,
@comment text,
@commentdate datetime

AS
BEGIN
SET NOCOUNT ON;
 insert into [{databaseOwner}].[{objectQualifier}usercomments] (moduleid, comment, date) values (@moduleid, @comment, @commentdate) 
END
go
-- =============================================
create PROCEDURE [{databaseOwner}].[sp_countcomments]

@moduleid int
As
begin
 SELECT count(*) from [{databaseOwner}].[{objectQualifier}usercomments] where moduleid=@moduleid
end
go

DROP TABLE
 [{databaseOwner}].[{objectQualifier}usercomments]
GO

drop procedure [{databaseOwner}].[sp_usercommentsinsert]
go
GO

drop procedure [{databaseOwner}].[sp_viewcomments]
go
GO

drop procedure [{databaseOwner}].[sp_countcomments]
go