MYS1BfiX

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