· 9 years ago · Oct 05, 2016, 11:08 AM
1USE [erm_nsu_dev]
2GO
3IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_CreatedTime]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_CreatedTime]
6END
7
8GO
9IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_Status]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_Status]
12END
13
14GO
15IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_DepandsOnCredits]') AND type = 'D')
16BEGIN
17ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_DepandsOnCredits]
18END
19
20GO
21IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_ForYear]') AND type = 'D')
22BEGIN
23ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_ForYear]
24END
25
26GO
27IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_ForAdmission]') AND type = 'D')
28BEGIN
29ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_ForAdmission]
30END
31
32GO
33IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_SessionId]') AND type = 'D')
34BEGIN
35ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_SessionId]
36END
37
38GO
39IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_AreaId]') AND type = 'D')
40BEGIN
41ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_AreaId]
42END
43
44GO
45IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeesStructure_ProgramId]') AND type = 'D')
46BEGIN
47ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_FeesStructure_ProgramId]
48END
49
50GO
51IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeesStructure_DepartmentId]') AND type = 'D')
52BEGIN
53ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_FeesStructure_DepartmentId]
54END
55
56GO
57IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_SchoolId]') AND type = 'D')
58BEGIN
59ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_SchoolId]
60END
61
62GO
63/****** Object: Table [dbo].[NSU_Main_Fees_FeesStructure] Script Date: 10/5/2016 5:05:44 PM ******/
64IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesStructure]') AND type in (N'U'))
65DROP TABLE [dbo].[NSU_Main_Fees_FeesStructure]
66GO
67/****** Object: Table [dbo].[NSU_Main_Fees_FeesStructure] Script Date: 10/5/2016 5:05:44 PM ******/
68SET ANSI_NULLS ON
69GO
70SET QUOTED_IDENTIFIER ON
71GO
72IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesStructure]') AND type in (N'U'))
73BEGIN
74CREATE TABLE [dbo].[NSU_Main_Fees_FeesStructure](
75 [FeesTypeId] [bigint] IDENTITY(1,1) NOT NULL,
76 [ModuleType] [nvarchar](50) NULL,
77 [FeesHeadBankId] [bigint] NULL,
78 [FeesTypeName] [nvarchar](150) NULL,
79 [DisplayName] [nvarchar](150) NULL,
80 [ProgramTypeId] [bigint] NULL,
81 [Parent] [bigint] NULL,
82 [SchoolId] [bigint] NULL,
83 [DepartmentId] [bigint] NULL,
84 [ProgramId] [bigint] NULL,
85 [AreaId] [bigint] NULL,
86 [SessionId] [bigint] NULL,
87 [Year] [nvarchar](50) NULL,
88 [Amount] [decimal](18, 2) NULL,
89 [ForAdmission] [bit] NULL,
90 [ForPerYear] [bit] NULL,
91 [DepandsOnCredits] [bit] NULL,
92 [CreditsCompleted] [decimal](18, 2) NULL,
93 [Status] [bit] NULL,
94 [CreatedBy] [bigint] NULL,
95 [CreatedTime] [datetime] NULL,
96 [ModifiedBy] [bigint] NULL,
97 [ModifiedTime] [datetime] NULL,
98 CONSTRAINT [PK_NSU_Main_Fees] PRIMARY KEY CLUSTERED
99(
100 [FeesTypeId] ASC
101)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
102) ON [PRIMARY]
103END
104GO
105SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesStructure] ON
106
107GO
108INSERT [dbo].[NSU_Main_Fees_FeesStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgramTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, N'Advising', 1, NULL, NULL, 2, 0, 1, 9, 6, 0, 20, N'2016', CAST(3000.00 AS Decimal(18, 2)), 1, 1, 1, CAST(50.00 AS Decimal(18, 2)), 0, 10004, CAST(0x0000A693011C1AF9 AS DateTime), 10004, CAST(0x0000A6950109473B AS DateTime))
109GO
110INSERT [dbo].[NSU_Main_Fees_FeesStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgramTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (2, N'Advising', 3, NULL, NULL, 2, 0, 1, 9, 6, 0, 20, N'2016', CAST(2000.00 AS Decimal(18, 2)), 1, 1, 1, CAST(100.00 AS Decimal(18, 2)), 0, 10004, CAST(0x0000A6930121344D AS DateTime), 10004, CAST(0x0000A69600BE0127 AS DateTime))
111GO
112INSERT [dbo].[NSU_Main_Fees_FeesStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgramTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (3, N'Advising', 3, NULL, NULL, 2, 0, 1, 9, 6, 0, 21, N'2016', CAST(1000.00 AS Decimal(18, 2)), 0, 1, 1, CAST(20.00 AS Decimal(18, 2)), 0, 10004, CAST(0x0000A6930130118D AS DateTime), 10004, CAST(0x0000A695010A18B7 AS DateTime))
113GO
114INSERT [dbo].[NSU_Main_Fees_FeesStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgramTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (10002, N'Advising', 4, NULL, NULL, 2, 0, 5, 9, 6, 0, 20, N'2016', CAST(20000.00 AS Decimal(18, 2)), 1, 1, 1, CAST(50.00 AS Decimal(18, 2)), 0, 10004, CAST(0x0000A69600BDC1F5 AS DateTime), NULL, NULL)
115GO
116INSERT [dbo].[NSU_Main_Fees_FeesStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgramTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (10003, N'Advising', 5, NULL, NULL, 2, 0, 5, 9, 6, 0, 21, N'2016', CAST(1000.00 AS Decimal(18, 2)), 0, 1, 1, CAST(20.00 AS Decimal(18, 2)), 0, 10004, CAST(0x0000A69600BDED5B AS DateTime), NULL, NULL)
117GO
118SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesStructure] OFF
119GO
120IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_SchoolId]') AND type = 'D')
121BEGIN
122ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_SchoolId] DEFAULT ((0)) FOR [SchoolId]
123END
124
125GO
126IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeesStructure_DepartmentId]') AND type = 'D')
127BEGIN
128ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_FeesStructure_DepartmentId] DEFAULT ((0)) FOR [DepartmentId]
129END
130
131GO
132IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeesStructure_ProgramId]') AND type = 'D')
133BEGIN
134ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_FeesStructure_ProgramId] DEFAULT ((0)) FOR [ProgramId]
135END
136
137GO
138IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_AreaId]') AND type = 'D')
139BEGIN
140ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_AreaId] DEFAULT ((0)) FOR [AreaId]
141END
142
143GO
144IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_SessionId]') AND type = 'D')
145BEGIN
146ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_SessionId] DEFAULT ((0)) FOR [SessionId]
147END
148
149GO
150IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_ForAdmission]') AND type = 'D')
151BEGIN
152ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_ForAdmission] DEFAULT ((0)) FOR [ForAdmission]
153END
154
155GO
156IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_ForYear]') AND type = 'D')
157BEGIN
158ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_ForYear] DEFAULT ((0)) FOR [ForPerYear]
159END
160
161GO
162IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesStructure_DepandsOnCredits]') AND type = 'D')
163BEGIN
164ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesStructure_DepandsOnCredits] DEFAULT ((0)) FOR [DepandsOnCredits]
165END
166
167GO
168IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_Status]') AND type = 'D')
169BEGIN
170ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_Status] DEFAULT ((0)) FOR [Status]
171END
172
173GO
174IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_CreatedTime]') AND type = 'D')
175BEGIN
176ALTER TABLE [dbo].[NSU_Main_Fees_FeesStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
177END
178
179GO