CREATE TABLE [dbo].[ai_usrdef_prop]
(
[samid] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_usrdef__samid__2FFB99C1] DEFAULT (' '),
[fn] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_usrdef_pr__fn__30EFBDFA] DEFAULT (' '),
[ln] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_usrdef_pr__ln__31E3E233] DEFAULT (' '),
[mgr] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[company] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dept] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[office] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[title] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[orgnm] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_usrdef_prop] ADD CONSTRAINT [ai_usrdef_prop_pk] PRIMARY KEY CLUSTERED ([samid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak4] ON [dbo].[ai_usrdef_prop] ([company]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak5] ON [dbo].[ai_usrdef_prop] ([dept]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak1] ON [dbo].[ai_usrdef_prop] ([fn]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak2] ON [dbo].[ai_usrdef_prop] ([ln]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak3] ON [dbo].[ai_usrdef_prop] ([mgr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak6] ON [dbo].[ai_usrdef_prop] ([office]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak8] ON [dbo].[ai_usrdef_prop] ([orgnm]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_prop_ak7] ON [dbo].[ai_usrdef_prop] ([title]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_usrdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_usrdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_usrdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_usrdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_usrdef_prop] TO [aipublic]
GO