· 9 years ago · Oct 22, 2016, 10:20 AM
1USE [erm_nsu_dev]
2GO
3IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_NSU_Main_ResourseManagement_Buildings_CreatedTime]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_ResourceManagement_Buildings] DROP CONSTRAINT [DF_NSU_Main_ResourseManagement_Buildings_CreatedTime]
6END
7
8GO
9IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_NSU_Main_ResourseManagement_Buildings_Status]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_ResourceManagement_Buildings] DROP CONSTRAINT [DF_NSU_Main_ResourseManagement_Buildings_Status]
12END
13
14GO
15/****** Object: Table [dbo].[NSU_Main_ResourceManagement_Buildings] Script Date: 10/22/2016 4:14:56 PM ******/
16IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_ResourceManagement_Buildings]') AND type in (N'U'))
17DROP TABLE [dbo].[NSU_Main_ResourceManagement_Buildings]
18GO
19/****** Object: Table [dbo].[NSU_Main_ResourceManagement_Buildings] Script Date: 10/22/2016 4:14:56 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_ResourceManagement_Buildings]') AND type in (N'U'))
25BEGIN
26CREATE TABLE [dbo].[NSU_Main_ResourceManagement_Buildings](
27 [BuildingId] [int] IDENTITY(1,1) NOT NULL,
28 [BuildingName] [nvarchar](150) NULL,
29 [BuildingCode] [nvarchar](50) NULL,
30 [NumberOfFloors] [int] NULL,
31 [NumberOfBasements] [int] NULL,
32 [Status] [bit] NULL,
33 [CreatedBy] [bigint] NULL,
34 [CreatedTime] [datetime] NULL,
35 [ModifiedBy] [bigint] NULL,
36 [ModifiedTime] [datetime] NULL,
37 CONSTRAINT [PK_NSU_Main_ResourseManagement_Buildings] PRIMARY KEY CLUSTERED
38(
39 [BuildingId] ASC
40)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
41) ON [PRIMARY]
42END
43GO
44SET IDENTITY_INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ON
45
46GO
47INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, N'North Academic Compound', N'NAC', 4, 3, 0, NULL, CAST(N'2015-09-01T15:18:24.970' AS DateTime), 10004, CAST(N'2016-10-20T12:02:07.233' AS DateTime))
48GO
49INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (2, N'South Academic Compound', N'SAC', 2, 2, 0, NULL, CAST(N'2015-09-01T15:18:35.827' AS DateTime), 10004, CAST(N'2016-10-20T12:02:17.200' AS DateTime))
50GO
51INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (3, N'Library', N'LIB', 5, 3, 0, NULL, CAST(N'2015-09-01T15:18:53.900' AS DateTime), 10004, CAST(N'2016-10-20T12:04:34.560' AS DateTime))
52GO
53INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (4, N'Open Air Theatre', N'OAT', 4, 3, 0, NULL, CAST(N'2015-09-01T15:19:24.203' AS DateTime), 10004, CAST(N'2016-10-20T12:04:44.497' AS DateTime))
54GO
55INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (5, N'TAK', N'TA', 5, 4, 0, 10004, CAST(N'2015-10-07T15:04:50.327' AS DateTime), 10004, CAST(N'2016-10-20T12:04:49.907' AS DateTime))
56GO
57INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] ([BuildingId], [BuildingName], [BuildingCode], [NumberOfFloors], [NumberOfBasements], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1005, N'Plaza', N'PLZ', 10, 7, 0, 10004, CAST(N'2016-03-13T10:17:22.370' AS DateTime), 10004, CAST(N'2016-10-20T12:05:00.053' AS DateTime))
58GO
59SET IDENTITY_INSERT [dbo].[NSU_Main_ResourceManagement_Buildings] OFF
60GO
61IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_NSU_Main_ResourseManagement_Buildings_Status]') AND type = 'D')
62BEGIN
63ALTER TABLE [dbo].[NSU_Main_ResourceManagement_Buildings] ADD CONSTRAINT [DF_NSU_Main_ResourseManagement_Buildings_Status] DEFAULT ((0)) FOR [Status]
64END
65
66GO
67IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_NSU_Main_ResourseManagement_Buildings_CreatedTime]') AND type = 'D')
68BEGIN
69ALTER TABLE [dbo].[NSU_Main_ResourceManagement_Buildings] ADD CONSTRAINT [DF_NSU_Main_ResourseManagement_Buildings_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
70END
71
72GO