CREATE TABLE[dbo].[UserLogin](
      [UserId] [int] IDENTITY(1,1) NOT NULL,
      [Name] [varchar](100) NOT NULL,
      [Password] [varchar](50) NULL,
      [CreatedOn] [datetime] NULL,
      [CreatedUserId] [int] NULL,
      [ModifiedOn] [datetime] NULL,
      [ModifiedUserId] [int] NULL,
      [Role] [varchar](50) NULL,
 CONSTRAINT[PK_UserLogin] PRIMARY KEYCLUSTERED 
(
      [UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON[PRIMARY]
GO
SET ANSI_PADDINGOFF
GO
SET IDENTITY_INSERT[dbo].[UserLogin] ON
INSERT [dbo].[UserLogin] ([UserId],[Name],[Password],[CreatedOn],[CreatedUserId], [ModifiedOn], [ModifiedUserId],[Role]) VALUES (1, N'Administrator', N'mohamed', NULL, NULL, CAST(0x0000A59A0156CF50AS DateTime), 1, N'A')
INSERT [dbo].[UserLogin] ([UserId],[Name],[Password],[CreatedOn],[CreatedUserId], [ModifiedOn], [ModifiedUserId],[Role]) VALUES (3, N'Abu',  N'abuthahir', NULL, NULL, CAST(0x0000A5AF0162240B ASDateTime), 1, N'V')
INSERT [dbo].[UserLogin] ([UserId],[Name],[Password],[CreatedOn],[CreatedUserId], [ModifiedOn], [ModifiedUserId],[Role]) VALUES (4, N'Thivan', N'mydeen', CAST(0x0000A5CE0016A230AS DateTime), 1, NULL, NULL, N'V')

SET IDENTITY_INSERT [dbo].[UserLogin] OFF