[dbo].[options]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	176
Created	11:07:23 AM Wednesday, March 07, 2007
Last Modified	9:08:56 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
	id	int	4
	persid	nvarchar(30)	60
	del	int	4
	option_name	nvarchar(30)	60
$Indexes options_x0: app_name\sym$	sym	nvarchar(60)	120
	sequence	int	4
	description	nvarchar(200)	400
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	action	int	4
	action_status	nvarchar(20)	40
$Indexes options_x0: app_name\sym$	app_name	nvarchar(30)	60
	install_script	nvarchar(200)	400
	deinstall_script	nvarchar(200)	400
	readme	nvarchar(200)	400
	value_active	int	4
	value	ntext	max
	default_value	nvarchar(100)	200
	validation	nvarchar(100)	200
	error_msg	nvarchar(100)	200

	Name	Columns	Unique
	XPKoptions	id
	options_x0	app_name, sym

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].[options]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[option_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sym] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sequence] [int] NULL,
[description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[action] [int] NULL,
[action_status] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[install_script] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[deinstall_script] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[readme] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[value_active] [int] NULL,
[value] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_value] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[validation] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[error_msg] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[options] ADD CONSTRAINT [XPKoptions] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [options_x0] ON [dbo].[options] ([app_name], [sym]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[options] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[options] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[options] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[options] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[options] TO [service_desk_ro_group]
GO