CREATE TABLE [dbo].[provider_user]
(
[userid] [int] NOT NULL,
[provider_name] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[product_code] [int] NOT NULL,
[username] [char] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[password] [char] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[datetime_updated] [datetime] NOT NULL,
[provider_number] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[provider_user] ADD CONSTRAINT [XPKprovider_user] PRIMARY KEY CLUSTERED ([userid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [provider_user_idx_01] ON [dbo].[provider_user] ([provider_name], [product_code], [username], [provider_number]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[provider_user] TO [cmew_admin]
GRANT INSERT ON [dbo].[provider_user] TO [cmew_admin]
GRANT DELETE ON [dbo].[provider_user] TO [cmew_admin]
GRANT UPDATE ON [dbo].[provider_user] TO [cmew_admin]
GRANT SELECT ON [dbo].[provider_user] TO [cmew_rdr]
GO
[dbo].[provider_user]
