QFx3b8B1

1USE [erm_nsu_dev]
2GO
3IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Status]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Status]
6END
7
8GO
9IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Enable]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Enable]
12END
13
14GO
15/****** Object:  Table [dbo].[NSU_Main_Fees_FeesHeadBank]    Script Date: 10/5/2016 4:34:37 PM ******/
16IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesHeadBank]') AND type in (N'U'))
17DROP TABLE [dbo].[NSU_Main_Fees_FeesHeadBank]
18GO
19/****** Object:  Table [dbo].[NSU_Main_Fees_FeesHeadBank]    Script Date: 10/5/2016 4:34:37 PM ******/
20SET ANSI_NULLS ON
21GO
22SET QUOTED_IDENTIFIER ON
23GO
24IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesHeadBank]') AND type in (N'U'))
25BEGIN
26CREATE TABLE [dbo].[NSU_Main_Fees_FeesHeadBank](
27	[FeesHeadBankId] [bigint] IDENTITY(1,1) NOT NULL,
28	[FeesHeadName] [nvarchar](150) NULL,
29	[IsTuition] [bit] NULL,
30	[Enable] [bit] NULL,
31	[Status] [bit] NULL,
32	[CreatedBy] [bigint] NULL,
33	[CreatedTime] [datetime] NULL,
34	[ModifiedBy] [bigint] NULL,
35	[ModifiedTime] [datetime] NULL,
36 CONSTRAINT [PK_NSU_Main_Fees_FeesHeadBank] PRIMARY KEY CLUSTERED 
37(
38	[FeesHeadBankId] ASC
39)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
40) ON [PRIMARY]
41END
42GO
43SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ON 
44
45GO
46INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, N'Tuition Fee', 1, 1, 0, 1, CAST(0x0000A693011916CB AS DateTime), NULL, NULL)
47GO
48INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (2, N'Hostel Fee', 0, 1, 0, 1, CAST(0x0000A69301191F12 AS DateTime), NULL, NULL)
49GO
50INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (3, N'Lab Fee', 0, 1, 0, 1, CAST(0x0000A6930118BCDF AS DateTime), NULL, NULL)
51GO
52INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (4, N'Semester Fee', 0, 1, 0, NULL, NULL, NULL, NULL)
53GO
54INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (5, N'Sports Fee', 0, 1, 0, NULL, NULL, NULL, NULL)
55GO
56INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [IsTuition], [Enable], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (6, N'Club Fee', 0, 1, 0, NULL, NULL, NULL, NULL)
57GO
58SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] OFF
59GO
60IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Enable]') AND type = 'D')
61BEGIN
62ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] ADD  CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Enable]  DEFAULT ((1)) FOR [Enable]
63END
64
65GO
66IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Status]') AND type = 'D')
67BEGIN
68ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] ADD  CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Status]  DEFAULT ((0)) FOR [Status]
69END
70
71GO