CREATE TABLE [dbo].[urc_local_server]
(
[uid] [binary] (16) NOT NULL,
[uidparent] [binary] (16) NOT NULL,
[strname] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[strpath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[straddress] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[iisroot] [int] NOT NULL,
[uidconfigpolicy] [binary] (16) NOT NULL,
[strdescription] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[dateconfigpolicy] [int] NOT NULL,
[iinheritconfiguration] [int] NOT NULL,
[ipropagatechanges] [int] NOT NULL,
[ageofeventstopurge] [int] NOT NULL,
[datetopurgeevents] [int] NOT NULL,
[ageofsessionstopurge] [int] NOT NULL,
[datetopurgesessions] [int] NOT NULL,
[nexteventpurge] [int] NOT NULL,
[nextsessionpurge] [int] NOT NULL,
[periodtopurgeevents] [int] NOT NULL,
[periodtopurgesessions] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[urc_local_server] ADD CONSTRAINT [XPKurc_local_server] PRIMARY KEY CLUSTERED ([uid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[urc_local_server] TO [ams_group]
GRANT SELECT ON  [dbo].[urc_local_server] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[urc_local_server] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[urc_local_server] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[urc_local_server] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[urc_local_server] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[urc_local_server] TO [upmuser_group]
GO