Automatic-School-Bell/Install script.sql at master · mirzaevolution/Automatic-School-Bell · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
USE MASTER
GO

IF DB_ID(N'SchoolBellDB') IS NULL
BEGIN
	CREATE DATABASE [SchoolBellDB];
END
GO

DECLARE @version_year INT;
SET @version_year = CAST(SUBSTRING(@@VERSION,PATINDEX(N'%20__%',@@VERSION),4) AS INT)

IF @version_year<2012
BEGIN
	EXEC sp_addsrvrolemember @loginame=N'NT AUTHORITY\SYSTEM', @rolename=N'sysadmin'
END
ELSE
BEGIN
	ALTER SERVER ROLE sysadmin ADD MEMBER [NT AUTHORITY\SYSTEM]
END


USE [SchoolBellDB]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF OBJECT_ID(N'dbo.Event',N'U') IS NULL
BEGIN
	CREATE TABLE [dbo].[Event](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Date] [datetime] NOT NULL,
		[StartTime] [time](7) NOT NULL,
		[Description] [nvarchar](250) NULL,
		[AudioLocation] [nvarchar](max) NOT NULL,
		[PlayerLocation] [nvarchar](max) NOT NULL,
	 CONSTRAINT [PK_dbo.Event] PRIMARY KEY CLUSTERED
	(
		[ID] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

END

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF OBJECT_ID(N'dbo.RepeatedSchedule',N'U') IS NULL
BEGIN
	CREATE TABLE [dbo].[RepeatedSchedule](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[StartDateTime] [datetime] NOT NULL,
		[Repetition] [int] NOT NULL,
		[Description] [nvarchar](250) NULL,
		[AudioLocation] [nvarchar](max) NOT NULL,
		[PlayerLocation] [nvarchar](max) NOT NULL,
	 CONSTRAINT [PK_dbo.RepeatedSchedule] PRIMARY KEY CLUSTERED
	(
		[ID] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

END

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF OBJECT_ID(N'dbo.Schedule',N'U') IS NULL
BEGIN
	CREATE TABLE [dbo].[Schedule](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Day] [int] NOT NULL,
		[StartTime] [time](7) NOT NULL,
		[Description] [nvarchar](250) NULL,
		[AudioLocation] [nvarchar](max) NOT NULL,
		[PlayerLocation] [nvarchar](max) NOT NULL,
	 CONSTRAINT [PK_dbo.Schedule] PRIMARY KEY CLUSTERED
	(
		[ID] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

END

GO