CREATE TABLE [dbo].[ai_usrdef_orgtree_prop]
(
[pmf] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_usrdef_o__pmf__2C2B08DD] DEFAULT (' '),
[reportsto] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_usrdef__repor__2D1F2D16] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_usrdef_orgtree_prop] ADD CONSTRAINT [PK__ai_usrdef_orgtre__55167929] PRIMARY KEY CLUSTERED ([pmf]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_usrdef_orgtree_prop_ak1] ON [dbo].[ai_usrdef_orgtree_prop] ([reportsto], [pmf]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_usrdef_orgtree_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_usrdef_orgtree_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_usrdef_orgtree_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_usrdef_orgtree_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_usrdef_orgtree_prop] TO [aipublic]
GO