· 10 years ago · Sep 18, 2016, 05:42 AM
1USE [erm_nsu_dev]
2GO
3IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_AcademicSetup_DocumentType_CreatedTime]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] DROP CONSTRAINT [DF_NSU_Main_AcademicSetup_DocumentType_CreatedTime]
6END
7
8GO
9IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_AcademicSetup_DocumentType_Status]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] DROP CONSTRAINT [DF_NSU_Main_AcademicSetup_DocumentType_Status]
12END
13
14GO
15IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForAd__4BF72343]') AND type = 'D')
16BEGIN
17ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] DROP CONSTRAINT [DF__NSU_Main___ForAd__4BF72343]
18END
19
20GO
21IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForEm__4B02FF0A]') AND type = 'D')
22BEGIN
23ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] DROP CONSTRAINT [DF__NSU_Main___ForEm__4B02FF0A]
24END
25
26GO
27IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForSt__4A0EDAD1]') AND type = 'D')
28BEGIN
29ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] DROP CONSTRAINT [DF__NSU_Main___ForSt__4A0EDAD1]
30END
31
32GO
33/****** Object: Table [dbo].[NSU_Main_AcademicSetup_DocumentType] Script Date: 9/18/2016 11:39:39 AM ******/
34IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_AcademicSetup_DocumentType]') AND type in (N'U'))
35DROP TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType]
36GO
37/****** Object: Table [dbo].[NSU_Main_AcademicSetup_DocumentType] Script Date: 9/18/2016 11:39:39 AM ******/
38SET ANSI_NULLS ON
39GO
40SET QUOTED_IDENTIFIER ON
41GO
42IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_AcademicSetup_DocumentType]') AND type in (N'U'))
43BEGIN
44CREATE TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType](
45 [DocumentTypeId] [int] IDENTITY(1,1) NOT NULL,
46 [DocumentTypeName] [nvarchar](150) NULL,
47 [DocumentTypeCode] [nvarchar](50) NULL,
48 [ForStudent] [bit] NULL,
49 [ForEmployee] [bit] NULL,
50 [ForAdmission] [bit] NULL,
51 [Status] [bit] NULL,
52 [CreatedBy] [bigint] NULL,
53 [CreatedTime] [datetime] NULL,
54 [ModifiedBy] [bigint] NULL,
55 [ModifiedTime] [datetime] NULL,
56 CONSTRAINT [PK_NSU_Main_AcademicSetup_DocumentType] PRIMARY KEY CLUSTERED
57(
58 [DocumentTypeId] ASC
59)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
60) ON [PRIMARY]
61END
62GO
63IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForSt__4A0EDAD1]') AND type = 'D')
64BEGIN
65ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] ADD CONSTRAINT [DF__NSU_Main___ForSt__4A0EDAD1] DEFAULT ((0)) FOR [ForStudent]
66END
67
68GO
69IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForEm__4B02FF0A]') AND type = 'D')
70BEGIN
71ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] ADD CONSTRAINT [DF__NSU_Main___ForEm__4B02FF0A] DEFAULT ((0)) FOR [ForEmployee]
72END
73
74GO
75IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__NSU_Main___ForAd__4BF72343]') AND type = 'D')
76BEGIN
77ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] ADD CONSTRAINT [DF__NSU_Main___ForAd__4BF72343] DEFAULT ((0)) FOR [ForAdmission]
78END
79
80GO
81IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_AcademicSetup_DocumentType_Status]') AND type = 'D')
82BEGIN
83ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] ADD CONSTRAINT [DF_NSU_Main_AcademicSetup_DocumentType_Status] DEFAULT ((0)) FOR [Status]
84END
85
86GO
87IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_AcademicSetup_DocumentType_CreatedTime]') AND type = 'D')
88BEGIN
89ALTER TABLE [dbo].[NSU_Main_AcademicSetup_DocumentType] ADD CONSTRAINT [DF_NSU_Main_AcademicSetup_DocumentType_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
90END
91
92GO