CREATE TABLE [dbo].[ai_pubdef_prop]
(
[pubuuid] [uniqueidentifier] NOT NULL,
[pubname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lactdate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_pubdef_prop] ADD CONSTRAINT [ai_pubdef_prop_pk] PRIMARY KEY CLUSTERED ([pubuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_pubdef_prop_ak1] ON [dbo].[ai_pubdef_prop] ([pubname]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ai_pubdef_prop] TO [aiadmin]
GRANT INSERT ON [dbo].[ai_pubdef_prop] TO [aiadmin]
GRANT DELETE ON [dbo].[ai_pubdef_prop] TO [aiadmin]
GRANT UPDATE ON [dbo].[ai_pubdef_prop] TO [aiadmin]
GRANT SELECT ON [dbo].[ai_pubdef_prop] TO [aipublic]
GO
[dbo].[ai_pubdef_prop]
