CREATE TABLE [dbo].[usm_db]
(
[db_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL,
[db_class] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_url] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[login_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[password] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[version] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[normalize_timestamps] [int] NULL CONSTRAINT [DF__usm_db__normaliz__5CF79213] DEFAULT ((0)),
[dst_id] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[host_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autocommit] [tinyint] NULL,
[time_zone_code] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_db] ADD CONSTRAINT [XPKusm_db] PRIMARY KEY CLUSTERED ([db_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_db] ADD CONSTRAINT [$usm_d_r0000223900000000] FOREIGN KEY ([time_zone_code]) REFERENCES [dbo].[ca_time_zone] ([time_zone_code])
GO
GRANT SELECT ON  [dbo].[usm_db] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_db] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_db] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_db] TO [usmgroup]
GO