[dbo].[si_kpi

Property	Value
Heap
Row Count	300
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	11:09:44 AM Wednesday, March 07, 2007

	Name	Data Type	Collation	Max Length (Bytes)
	uuid	binary(16)		16
$Indexes xak1si_kpi_prop: name\sequence$	sequence	int		4
$Indexes xak1si_kpi_prop: name\sequence$	name	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	grp	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	type	nvarchar(16)	SQL_Latin1_General_CP1_CS_AS	32
	query	ntext	SQL_Latin1_General_CP1_CI_AS	max
	loc	int		4
	phase	nvarchar(16)	SQL_Latin1_General_CP1_CS_AS	32

Name	Columns	Unique
baseidx_si_kpi_prop	uuid
xak1si_kpi_prop	name, sequence

Type	Action	Owning Principal
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	Delete	aiuser
Grant	Insert	aiuser
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic
Grant	Select	siadmins
Grant	Update	siadmins
Grant	Select	aiuser
Grant	Update	aiuser

SQL Script

CREATE TABLE [dbo].[si_kpi_prop]
(
[uuid] [binary] (16) NOT NULL,
[sequence] [int] NULL,
[name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[grp] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[query] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc] [int] NULL,
[phase] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xak1si_kpi_prop] ON [dbo].[si_kpi_prop] ([name], [sequence]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_si_kpi_prop] ON [dbo].[si_kpi_prop] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_kpi_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_kpi_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_kpi_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_kpi_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_kpi_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_kpi_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_kpi_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_kpi_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_kpi_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_kpi_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_kpi_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_kpi_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_kpi_prop] TO [siadmins]
GO