- Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQL.sql
More file actions
Latest commit
188 lines (184 loc) · 12.8 KB
/
Copy pathSQL.sql
File metadata and controls
188 lines (184 loc) · 12.8 KB
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
USE [master]
GO
/****** Object: Database [Razer] Script Date: 8/19/2018 2:08:11 PM ******/
CREATEDATABASE [Razer]
CONTAINMENT =NONE
ONPRIMARY
( NAME=N'Razer', FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\Razer.mdf' , SIZE = 8192KB , MAXSIZE =UNLIMITED, FILEGROWTH = 65536KB )
LOGON
( NAME=N'Razer_log', FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\Razer_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTERDATABASE [Razer] SETCOMPATIBILITY_LEVEL=140
GO
IF (1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Razer].[dbo].[sp_fulltext_database] @action ='enable'
end
GO
ALTERDATABASE [Razer] SETANSI_NULL_DEFAULTOFF
GO
ALTERDATABASE [Razer] SETANSI_NULLSOFF
GO
ALTERDATABASE [Razer] SETANSI_PADDINGOFF
GO
ALTERDATABASE [Razer] SETANSI_WARNINGSOFF
GO
ALTERDATABASE [Razer] SETARITHABORTOFF
GO
ALTERDATABASE [Razer] SETAUTO_CLOSEOFF
GO
ALTERDATABASE [Razer] SETAUTO_SHRINKOFF
GO
ALTERDATABASE [Razer] SETAUTO_UPDATE_STATISTICSON
GO
ALTERDATABASE [Razer] SETCURSOR_CLOSE_ON_COMMITOFF
GO
ALTERDATABASE [Razer] SETCURSOR_DEFAULTGLOBAL
GO
ALTERDATABASE [Razer] SETCONCAT_NULL_YIELDS_NULLOFF
GO
ALTERDATABASE [Razer] SETNUMERIC_ROUNDABORTOFF
GO
ALTERDATABASE [Razer] SETQUOTED_IDENTIFIEROFF
GO
ALTERDATABASE [Razer] SETRECURSIVE_TRIGGERSOFF
GO
ALTERDATABASE [Razer] SETDISABLE_BROKER
GO
ALTERDATABASE [Razer] SETAUTO_UPDATE_STATISTICS_ASYNCOFF
GO
ALTERDATABASE [Razer] SETDATE_CORRELATION_OPTIMIZATIONOFF
GO
ALTERDATABASE [Razer] SETTRUSTWORTHYOFF
GO
ALTERDATABASE [Razer] SETALLOW_SNAPSHOT_ISOLATIONOFF
GO
ALTERDATABASE [Razer] SETPARAMETERIZATIONSIMPLE
GO
ALTERDATABASE [Razer] SETREAD_COMMITTED_SNAPSHOTOFF
GO
ALTERDATABASE [Razer] SET HONOR_BROKER_PRIORITY OFF
GO
ALTERDATABASE [Razer] SETRECOVERYSIMPLE
GO
ALTERDATABASE [Razer] SETMULTI_USER
GO
ALTERDATABASE [Razer] SETPAGE_VERIFYCHECKSUM
GO
ALTERDATABASE [Razer] SETDB_CHAININGOFF
GO
ALTERDATABASE [Razer] SETFILESTREAM( NON_TRANSACTED_ACCESS =OFF )
GO
ALTERDATABASE [Razer] SET TARGET_RECOVERY_TIME =60 SECONDS
GO
ALTERDATABASE [Razer] SETDELAYED_DURABILITY=DISABLED
GO
ALTERDATABASE [Razer] SETQUERY_STORE=OFF
GO
USE [Razer]
GO
ALTERDATABASESCOPEDCONFIGURATIONSET IDENTITY_CACHE =ON;
GO
ALTERDATABASESCOPEDCONFIGURATIONSETLEGACY_CARDINALITY_ESTIMATION=OFF;
GO
ALTERDATABASESCOPEDCONFIGURATION FOR SECONDARYSETLEGACY_CARDINALITY_ESTIMATION=PRIMARY;
GO
ALTERDATABASESCOPEDCONFIGURATIONSETMAXDOP=0;
GO
ALTERDATABASESCOPEDCONFIGURATION FOR SECONDARYSETMAXDOP=PRIMARY;
GO
ALTERDATABASESCOPEDCONFIGURATIONSETPARAMETER_SNIFFING=ON;
GO
ALTERDATABASESCOPEDCONFIGURATION FOR SECONDARYSETPARAMETER_SNIFFING=PRIMARY;
GO
ALTERDATABASESCOPEDCONFIGURATIONSETQUERY_OPTIMIZER_HOTFIXES=OFF;
GO
ALTERDATABASESCOPEDCONFIGURATION FOR SECONDARYSETQUERY_OPTIMIZER_HOTFIXES=PRIMARY;
GO
USE [Razer]
GO
/****** Object: Table [dbo].[ArtistTBL] Script Date: 8/19/2018 2:08:12 PM ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[ArtistTBL](
[ArtistID] [int] IDENTITY(1,1) NOTNULL,
[Title] [nvarchar](500) NULL,
[Description] [nvarchar](4000) NULL,
[Gender] [int] NULL,
[CoverPath] [nvarchar](500) NULL,
[DOB] [date] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[PlaylistTBL] Script Date: 8/19/2018 2:08:12 PM ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[PlaylistTBL](
[PlaylistID] [int] IDENTITY(1,1) NOTNULL,
[Private] [bit] NULL,
[Title] [nvarchar](500) NULL,
[UserID] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SongPlaylistTBL] Script Date: 8/19/2018 2:08:12 PM ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[SongPlaylistTBL](
[PlaylistID] [int] NOTNULL,
[SongID] [int] NOTNULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SongTBL] Script Date: 8/19/2018 2:08:12 PM ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[SongTBL](
[SongID] [int] IDENTITY(1,1) NOTNULL,
[ArtistID] [int] NULL,
[Title] [nvarchar](500) NULL,
[FilePath] [nvarchar](500) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[UserTBL] Script Date: 8/19/2018 2:08:12 PM ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[UserTBL](
[UserID] [int] IDENTITY(1,1) NOTNULL,
[Email] [nchar](200) NULL,
[Password] [nchar](100) NULL,
[Name] [nvarchar](50) NULL,
[Gender] [int] NULL,
[Phone] [nchar](12) NULL,
[Address] [nvarchar](1000) NULL,
[Admin] [bit] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[ArtistTBL] ON
INSERT [dbo].[ArtistTBL] ([ArtistID], [Title], [Description], [Gender], [CoverPath], [DOB]) VALUES (1, N'Hoàng Yến Chibi', N'1', 0, N'28424898_2016973008317025_1513751757060087978_o.jpg', CAST(N'2018-08-31'ASDate))
SET IDENTITY_INSERT [dbo].[ArtistTBL] OFF
SET IDENTITY_INSERT [dbo].[PlaylistTBL] ON
INSERT [dbo].[PlaylistTBL] ([PlaylistID], [Private], [Title], [UserID]) VALUES (5, 0, N'Old guds...! :"}', 1)
SET IDENTITY_INSERT [dbo].[PlaylistTBL] OFF
INSERT [dbo].[SongPlaylistTBL] ([PlaylistID], [SongID]) VALUES (7, 9)
SET IDENTITY_INSERT [dbo].[SongTBL] ON
INSERT [dbo].[SongTBL] ([SongID], [ArtistID], [Title], [FilePath]) VALUES (9, 1, N'Ngây ngô', N'NgayNgo-HoangYenChibi-2540994.mp3')
SET IDENTITY_INSERT [dbo].[SongTBL] OFF
SET IDENTITY_INSERT [dbo].[UserTBL] ON
INSERT [dbo].[UserTBL] ([UserID], [Email], [Password], [Name], [Gender], [Phone], [Address], [Admin]) VALUES (1, N'crustyrat271@gmail.com ', N'123456 ', N'Huy Hoang Phan', 1, N'0975000270 ', N'D302, FPT University', 1)
SET IDENTITY_INSERT [dbo].[UserTBL] OFF
ALTERTABLE [dbo].[UserTBL] ADDCONSTRAINT [DF_UserTBL_Admin] DEFAULT ((0)) FOR [Admin]
GO
EXECsys.sp_addextendedproperty @name=N'MS_Description', @value=N'PlaylistID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SongPlaylistTBL'
GO
USE [master]
GO
ALTERDATABASE [Razer] SETREAD_WRITE
GO