Eim91A6A

1USE [erm_nsu_sims_diagram]
2GO
3IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_CreatedTime]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] DROP CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_CreatedTime]
6END
7
8GO
9IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_Status]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] DROP CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_Status]
12END
13
14GO
15IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_LoginVerified]') AND type = 'D')
16BEGIN
17ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] DROP CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_LoginVerified]
18END
19
20GO
21/****** Object:  Table [dbo].[NSU_Main_Profile_Staffs_LoginInfo]    Script Date: 9/3/2016 12:11:59 PM ******/
22IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Profile_Staffs_LoginInfo]') AND type in (N'U'))
23DROP TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo]
24GO
25/****** Object:  Table [dbo].[NSU_Main_Profile_Staffs_LoginInfo]    Script Date: 9/3/2016 12:11:59 PM ******/
26SET ANSI_NULLS ON
27GO
28SET QUOTED_IDENTIFIER ON
29GO
30IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Profile_Staffs_LoginInfo]') AND type in (N'U'))
31BEGIN
32CREATE TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo](
33	[SerialId] [bigint] IDENTITY(1,1) NOT NULL,
34	[StaffSerialId] [bigint] NULL,
35	[Password] [nvarchar](150) NULL,
36	[Salt] [nvarchar](50) NULL,
37	[LoginVerified] [bit] NULL,
38	[Status] [bit] NULL,
39	[CreatedBy] [bigint] NULL,
40	[CreatedTime] [datetime] NULL,
41	[ModifiedBy] [bigint] NULL,
42	[ModifiedTime] [datetime] NULL,
43 CONSTRAINT [PK_NSU_Main_Profile_Staffs_LoginInfo_1] PRIMARY KEY CLUSTERED 
44(
45	[SerialId] ASC
46)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
47) ON [PRIMARY]
48END
49GO
50SET IDENTITY_INSERT [dbo].[NSU_Main_Profile_Staffs_LoginInfo] ON 
51
52GO
53INSERT [dbo].[NSU_Main_Profile_Staffs_LoginInfo] ([SerialId], [StaffSerialId], [Password], [Salt], [LoginVerified], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, 10004, N'55114825511015147167674622204155173217661261397819JJYP3924', N'JJYP3924', 1, 0, NULL, CAST(0x0000A67100D25DB6 AS DateTime), 0, CAST(0x0000A67100D84E63 AS DateTime))
54GO
55SET IDENTITY_INSERT [dbo].[NSU_Main_Profile_Staffs_LoginInfo] OFF
56GO
57IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_LoginVerified]') AND type = 'D')
58BEGIN
59ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] ADD  CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_LoginVerified]  DEFAULT ((0)) FOR [LoginVerified]
60END
61
62GO
63IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_Status]') AND type = 'D')
64BEGIN
65ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] ADD  CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_Status]  DEFAULT ((0)) FOR [Status]
66END
67
68GO
69IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Profile_Staffs_LoginInfo_CreatedTime]') AND type = 'D')
70BEGIN
71ALTER TABLE [dbo].[NSU_Main_Profile_Staffs_LoginInfo] ADD  CONSTRAINT [DF_NSU_Main_Profile_Staffs_LoginInfo_CreatedTime]  DEFAULT (getdate()) FOR [CreatedTime]
72END
73
74GO