CREATE TABLE [dbo].[ai_swdef_prop]
(
[pubuuid] [uniqueidentifier] NOT NULL,
[swuuid] [uniqueidentifier] NOT NULL,
[swpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[swname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[swver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swver__21AD7A6A] DEFAULT (' '),
[swrel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swrel__22A19EA3] DEFAULT (' '),
[swmod] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swmod__2395C2DC] DEFAULT (' '),
[swbld] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swbld__2489E715] DEFAULT (' '),
[swnote] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swnot__257E0B4E] DEFAULT (' '),
[swlang] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swlan__26722F87] DEFAULT (' '),
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lactdate] [datetime] NOT NULL CONSTRAINT [DF__ai_swdef___lactd__276653C0] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_swdef_prop] ADD CONSTRAINT [ai_swdef_prop_pk] PRIMARY KEY CLUSTERED ([swuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak1] ON [dbo].[ai_swdef_prop] ([pubuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak7] ON [dbo].[ai_swdef_prop] ([swbld]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak9] ON [dbo].[ai_swdef_prop] ([swlang]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak6] ON [dbo].[ai_swdef_prop] ([swmod]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak3] ON [dbo].[ai_swdef_prop] ([swname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak8] ON [dbo].[ai_swdef_prop] ([swnote]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak2] ON [dbo].[ai_swdef_prop] ([swpub]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak5] ON [dbo].[ai_swdef_prop] ([swrel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_ak4] ON [dbo].[ai_swdef_prop] ([swver]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_swdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_swdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_swdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_swdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_swdef_prop] TO [aipublic]
GO