CREATE TABLE [dbo].[am_object_folder]
(
[folder_domain_id] [int] NOT NULL CONSTRAINT [DF__am_object__folde__17F790F9] DEFAULT ('0'),
[folder_id] [int] NOT NULL CONSTRAINT [DF__am_object__folde__18EBB532] DEFAULT ('0'),
[folder_parent_id] [int] NULL CONSTRAINT [DF__am_object__folde__19DFD96B] DEFAULT (NULL),
[folder_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__am_object__folde__1AD3FDA4] DEFAULT (NULL),
[object_type] [int] NULL CONSTRAINT [DF__am_object__objec__1BC821DD] DEFAULT (NULL),
[folder_filter] [int] NOT NULL CONSTRAINT [DF__am_object__folde__1CBC4616] DEFAULT ('0'),
[folder_id_type] [int] NOT NULL CONSTRAINT [DF__am_object__folde__1DB06A4F] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[am_object_folder] ADD CONSTRAINT [XPKam_object_folder] PRIMARY KEY CLUSTERED ([folder_domain_id], [folder_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[am_object_folder] TO [ams_group]
GRANT SELECT ON  [dbo].[am_object_folder] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[am_object_folder] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[am_object_folder] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[am_object_folder] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[am_object_folder] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[am_object_folder] TO [upmuser_group]
GO