tcwpXxhc

1ERROR: duplicate key value violates unique contraint "movies_pkey"
2DETAIL: key(movie_num)=20 already exists 
3     
4-- DROP'ping tables clear out any existing data
5DROP TABLE IF EXISTS movies;
6DROP TABLE IF EXISTS actors;
7
8-- CREATE the table, note that id has to be unique, and you must have a name
9CREATE TABLE actors(
10    id INTEGER PRIMARY KEY,
11    name VARCHAR(20) NOT  NULL
12);
13
14INSERT INTO actors(id, name) VALUES(
15    1,
16    'Sean Connery');
17INSERT INTO actors(id, name) VALUES(
18    2,
19    'George Lazenby');
20INSERT INTO actors(id, name) VALUES(
21    3,
22    'Roger Moore');
23INSERT INTO actors(id, name) VALUES(
24    4,
25    'Timothy Dalton');
26INSERT INTO actors(id, name) VALUES(
27    5,
28    'Pierce Brosnan');
29
30INSERT INTO actors(id, name) VALUES(
31    6,
32    'Daniel Craig');
33
34
35-- CREATE the table, note movie_num is unique and title and year are required fields, though the actor can be optionally empty
36CREATE TABLE movies(
37    movie_num INTEGER PRIMARY KEY,
38    title VARCHAR(35) NOT NULL,
39    actor INTEGER,
40    year INTEGER NOT NULL
41);
42
43INSERT INTO movies(movie_num, title, actor, year) 
44VALUES(
45    2,
46    'From Russia With Love',
47    1,
48    1963);
49INSERT INTO movies(movie_num, title, actor, year)
50VALUES(
51    3,
52    'Goldfinger',
53    1,
54    1964);
55INSERT INTO movies(movie_num, title, actor, year) VALUES(
56    4,
57    'Thunderball',
58    1,
59    1965);
60INSERT INTO movies(movie_num, title, actor, year) VALUES(
61    5,
62    'You Only Live Twice',
63    1,
64    1967);
65INSERT INTO movies(movie_num, title, actor, year) VALUES(
66    6,
67    'On Her Majesty''s Secret Service',
68    2,
69    1969);
70INSERT INTO movies(movie_num, title, actor, year) VALUES(
71    7,
72    'Diamonds Are Forever',
73    1,
74    1971);
75INSERT INTO movies(movie_num, title, actor, year) VALUES(
76    8,
77    'Live and Let Die',
78    3,
79    1973);
80INSERT INTO movies(movie_num, title, actor, year) VALUES(
81    9,
82    'The Man With The Golden Gun',
83    3,
84    1974);
85INSERT INTO movies(movie_num, title, actor, year) VALUES(
86    10,
87    'The Spy Who Loved Me',
88    3,
89    1977);
90INSERT INTO movies(movie_num, title, actor, year) VALUES(
91    11,
92    'Moonraker',
93    3,
94    1979);
95INSERT INTO movies(movie_num, title, actor, year) VALUES(
96    12,
97    'For Your Eyes Only',
98    3,
99    1981);
100INSERT INTO movies(movie_num, title, actor, year) VALUES(
101    14,
102    'A View To A Kill',
103    3,
104    1985);
105INSERT INTO movies(movie_num, title, actor, year) VALUES(
106    15,
107    'The Living Daylights',
108    4,
109    1987);
110INSERT INTO movies(movie_num, title, actor, year) VALUES(
111    16,
112    'License To Kill',
113    4,
114    1989);
115INSERT INTO movies(movie_num, title, actor, year) VALUES(
116    18,
117    'Tomorrow Never Dies',
118    5,
119    1997);
120INSERT INTO movies(movie_num, title, actor, year) VALUES(
121    20,
122    'Die Another Day',
123    5,
124    2003);
125INSERT INTO movies(movie_num, title, actor, year) VALUES(
126    1,
127    'Dr. No',
128    1,
129    1962);
130INSERT INTO movies(movie_num, title, actor, year) VALUES(
131    13,
132    'Octopussy',
133    3,
134    1983);
135INSERT INTO movies(movie_num, title, actor, year) VALUES(
136    17,
137    'Goldeneye',
138    5,
139    1995);
140INSERT INTO movies(movie_num, title, actor, year) VALUES(
141    19,
142    'The World Is Not Enough',
143    5,
144    1999);
145INSERT INTO movies(movie_num, title, actor, year) VALUES(
146    20,
147    'Casino Royale',
148    6,
149    2006);
150INSERT INTO movies(movie_num, title, actor, year) VALUES(
151    21,
152    'Quantum of Solace',
153    6,
154    2008);
155INSERT INTO movies(movie_num, title, actor, year) VALUES(
156    22,
157    'Skyfall',
158    6,
159    2012);
160INSERT INTO movies(movie_num, title, actor, year) VALUES(
161    23,
162    'Spectre',
163    6,
164    2015);