CREATE TABLE [dbo].[usm_user]
(
[user_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[common_name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[first_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[initials] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[city] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[state] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[country] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[postal_code] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[email] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[telephone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fax] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mobile] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pager] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[home_phone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[password] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[title] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL CONSTRAINT [DF__usm_user__status__3D9EE24B] DEFAULT ((1)),
[manager] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[employee_type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[employee_number] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[department_number] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[secretary] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[organization] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[organization_unit] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uid] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[car_licence] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[url] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_ou] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_dn] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_zone_code] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[locale_code] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[user_account_control] [int] NULL,
[useruid] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_user] ADD CONSTRAINT [XPKusm_user] PRIMARY KEY CLUSTERED ([user_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_user] ADD CONSTRAINT [$usm_u_r00002cbb00000000] FOREIGN KEY ([locale_code]) REFERENCES [dbo].[ca_locale] ([locale_code])
GO
ALTER TABLE [dbo].[usm_user] ADD CONSTRAINT [$usm_u_r00002cc500000000] FOREIGN KEY ([time_zone_code]) REFERENCES [dbo].[ca_time_zone] ([time_zone_code])
GO
ALTER TABLE [dbo].[usm_user] ADD CONSTRAINT [XFKusm_user1] FOREIGN KEY ([domain]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
GRANT SELECT ON  [dbo].[usm_user] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_user] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_user] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_user] TO [usmgroup]
GO