[dbo].[survey_statistics]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:07:32 AM Wednesday, March 07, 2007
Last Modified	9:09:03 PM Friday, December 05, 2008

Name	Data Type	Max Length (Bytes)
id	int	4
persid	nvarchar(30)	60
del	int	4
tplid	int	4
cycle	int	4
cyc_counter	int	4
eval_counter	int	4
sub_counter	int	4
tenant	binary(16)	16

	Name	Columns	Unique
	XPKsurvey_statistics	id
	survey_statistics_x1	tenant

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group

SQL Script

CREATE TABLE [dbo].[survey_statistics]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[tplid] [int] NULL,
[cycle] [int] NULL,
[cyc_counter] [int] NULL,
[eval_counter] [int] NULL,
[sub_counter] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[survey_statistics] ADD CONSTRAINT [XPKsurvey_statistics] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [survey_statistics_x1] ON [dbo].[survey_statistics] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[survey_statistics] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[survey_statistics] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[survey_statistics] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[survey_statistics] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[survey_statistics] TO [service_desk_ro_group]
GO