CREATE TABLE [dbo].[ai_hfdef_prop]
(
[pubuuid] [uniqueidentifier] NOT NULL,
[hfuuid] [uniqueidentifier] NOT NULL,
[hfpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hfname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hfsp] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef_p__hfsp__48FC51B5] DEFAULT (' '),
[hfid] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef_p__hfid__49F075EE] DEFAULT (' '),
[hfver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef___hfver__4AE49A27] DEFAULT (' '),
[hfrel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef___hfrel__4BD8BE60] DEFAULT (' '),
[hfmod] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef___hfmod__4CCCE299] DEFAULT (' '),
[hfbld] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hfnote] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hflang] [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 CONSTRAINT [DF__ai_hfdef___lactd__4DC106D2] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_hfdef_prop] ADD CONSTRAINT [ai_hfdef_prop_pk] PRIMARY KEY CLUSTERED ([hfuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak8] ON [dbo].[ai_hfdef_prop] ([hfbld]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak4] ON [dbo].[ai_hfdef_prop] ([hfid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak7] ON [dbo].[ai_hfdef_prop] ([hfmod]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak2] ON [dbo].[ai_hfdef_prop] ([hfname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak1] ON [dbo].[ai_hfdef_prop] ([hfpub]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak6] ON [dbo].[ai_hfdef_prop] ([hfrel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak3] ON [dbo].[ai_hfdef_prop] ([hfsp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_ak5] ON [dbo].[ai_hfdef_prop] ([hfver]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hfdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hfdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hfdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hfdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hfdef_prop] TO [aipublic]
GO