CREATE TABLE [dbo].[Module](
[ModuleID] [nchar](2) NOT NULL,
[ModuleName] [nvarchar](50) NOT NULL,
[ModuleDescription] [ntext] NULL,
[SetDate] [datetime] NULL,
[UserName] [nvarchar](20) NULL,
CONSTRAINT [PK_Wing] PRIMARY KEY CLUSTERED
(
[ModuleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
DROP TABLE userlist
CREATE TABLE [dbo].[UserList](
[UsrUserID] [varchar](20) NOT NULL,
[UsrName] [varchar](35) NULL,
[UsrPassword] [varchar](500) NOT NULL,
[UsrModuleID] [varchar](50) NOT NULL,
[UsrEnabledYN] [bit] NOT NULL,
[UsrRemarks] [text] NULL,
[UsrCreateDate] [datetime] NULL,
[SetDate] [datetime] NOT NULL,
[UserName] [varchar](20) NULL,
[PwdChangedYN] [bit] NOT NULL,
[UsrPIN] [varchar](8) NULL,
[usrClassID] [tinyint] NOT NULL,
CONSTRAINT [PK_UserList] PRIMARY KEY NONCLUSTERED
(
[UsrUserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[UserList] ADD CONSTRAINT [DF_UserList_UsrEnabledYN] DEFAULT ((1)) FOR [UsrEnabledYN]
GO
ALTER TABLE [dbo].[UserList] ADD CONSTRAINT [DF_UserList_SetDate] DEFAULT (getdate()) FOR [SetDate]
GO
ALTER TABLE [dbo].[UserList] ADD CONSTRAINT [DF_UserList_PasswordChangedYN] DEFAULT ((0)) FOR [PwdChangedYN]