CREATE TABLE [cohesion].[cc_user]
(
[cendura_id] [int] NOT NULL,
[user_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[password] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user_state] [smallint] NULL CONSTRAINT [DF__cc_user__user_st__0F975522] DEFAULT ((1)),
[user_fname] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user_mname] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user_lname] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_login] [datetime] NULL,
[bad_attempts] [int] NULL,
[last_bad_attempt] [datetime] NULL,
[created_by] [int] NULL,
[creation_time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_user] ADD CONSTRAINT [PK__cc_user__0EA330E9] PRIMARY KEY CLUSTERED ([cendura_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK1cc_user] ON [cohesion].[cc_user] ([user_name]) ON [PRIMARY]
GO
[cohesion].[cc_user]
