· 8 years ago · Nov 21, 2017, 12:54 PM
1------------------------------------------------------------------------------------
2--- DATABASE ---
3------------------------------------------------------------------------------------
4IF NOT EXISTS (SELECT NAME FROM MASTER.SYS.DATABASES WHERE NAME = N'WatchList')
5 CREATE DATABASE WatchList
6GO
7
8USE WatchList
9GO
10
11
12------------------------------------------------------------------------------------
13--- CREATE TABLE GOT_MOVIE ---
14------------------------------------------------------------------------------------
15IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'GOT_MOVIE')
16BEGIN
17 CREATE TABLE GOT_MOVIE(
18 GOT_MOVIE_ID int IDENTITY(1,1) primary key
19 ,GOT_MOVIE_NAME nvarchar(255) NOT NULL
20 ,GOT_MOVIE_DESCRIPTION NVARCHAR(255) NOT NULL
21 ,GOT_MOVIE_CATEGORY NVARCHAR(255) NOT NULL
22 ,GOT_MOVIE_RATING TINYINT
23 ,GOT_MOVIE_ACTIVE TINYINT
24 )
25
26END
27
28IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'GOT_MOVIE')
29BEGIN
30 INSERT INTO GOT_MOVIE (GOT_MOVIE_NAME, GOT_MOVIE_DESCRIPTION, GOT_MOVIE_CATEGORY, GOT_MOVIE_RATING, GOT_MOVIE_ACTIVE)
31 VALUES (
32 'Thor: Ragnarok'
33 ,'Imprisoned, the almighty Thor finds himself in a lethal gladiatorial contest against the Hulk, his former ally. Thor must fight for survival and race against time to prevent the all-powerful Hela from destroying his home and the Asgardian civilization.'
34 ,'Action'
35 ,3
36 ,1
37 ),
38 (
39 'Wonder'
40 ,'Based on the New York Times bestseller, WONDER tells the incredibly inspiring and heartwarming story of August Pullman, a boy with facial differences who enters fifth grade, attending a mainstream elementary school for the first time'
41 ,'Drama'
42 ,2
43 ,1
44 ),
45 (
46 'Justice League'
47 ,'Fueled by his restored faith in humanity and inspired by Superman selfless act, Bruce Wayne enlists the help of his newfound ally, Diana Prince, to face an even greater enemy.'
48 ,'Adventure'
49 ,5
50 ,1
51 ),
52 (
53 'Darkest Hour'
54 ,'During the early days of World War II, the fate of Western Europe hangs on the newly-appointed British Prime Minister Winston Churchill, who must decide whether to negotiate with Hitler, or fight on against incredible odds.'
55 ,'History'
56 ,4
57 ,1
58 )
59END
60GO