/
grail.sql
191 lines (186 loc) · 7.83 KB
/
grail.sql
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
189
190
191
-- The actor and character names are from IMDB (https://www.imdb.com/title/tt0071853/fullcredits).
-- Scene information is derived from the script at http://www.montypython.50webs.com/Holy_Grail_Scripts.htm.
-- It is not complete, and probably has errors.
INSERT INTO actors (id, name) VALUES
(1, 'Graham Chapman'),
(2, 'John Cleese'),
(3, 'Eric Idle'),
(4, 'Terry Gilliam'),
(5, 'Terry Jones'),
(6, 'Michael Palin'),
(7, 'Connie Booth'),
(8, 'Carol Cleveland'),
(9, 'Neil Innes'),
(10, 'Bee Duffell'),
(11, 'John Young'),
(12, 'Rita Davies'),
(13, 'Avril Stewart'),
(14, 'Sally Kinghorn'),
(15, 'Mark Zycon'),
(16, 'Elspeth Cameron'),
(17, 'Mitsuko Forstater'),
(18, 'Sandy Johnson'),
(19, 'Sandy Rose'),
(20, 'Romilly Squire'),
(21, 'Joni Flynn'),
(22, 'Alison Walker'),
(23, 'Loraine Ward'),
(24, 'Anna Lanski'),
(25, 'Sally Coombe'),
(26, 'Vivienne MacDonald'),
(27, 'Yvonne Dick'),
(28, 'Daphne Darling'),
(29, 'Fiona Gordon'),
(30, 'Gloria Graham'),
(31, 'Judy Lamb'),
(32, 'Tracy Sneddon'),
(33, 'Sylvia Taylor'),
(34, 'Joyce Pollner'),
(35, 'Mary Allen');
INSERT INTO characters (id, actor_id, name) VALUES
(1, 1, 'King Arthur'),
(2, 1, 'Voice of God'),
(3, 1, 'Middle Head'),
(4, 1, 'Hiccoughing Guard'),
(5, 2, 'Second Swallow-Savvy Guard'),
(6, 2, 'The Black Knight'),
(7, 2, 'Peasant 3'),
(8, 2, 'Sir Lancelot the Brave'),
(9, 2, 'Knight of Camelot'),
(10, 2, 'Taunting French Guard'),
(11, 2, 'Tim the Enchanter'),
(12, 3, 'Dead Collector'),
(13, 3, 'Peasant 1'),
(14, 3, 'Sir Robin the Not-Quite-So-Brave-as-Sir Launcelot'),
(15, 3, 'Knight of Camelot'),
(16, 3, 'First Swamp Castle Guard'),
(17, 3, 'Concorde'),
(18, 3, 'Roger the Shrubber'),
(19, 3, 'Brother Maynard'),
(20, 4, 'Patsy'),
(21, 4, 'Green Knight'),
(22, 4, 'Knight of Camelot'),
(23, 4, 'Old Man from Scene 24 (Bridgekeeper)'),
(24, 4, 'Sir Bors'),
(25, 4, 'Animator'),
(26, 4, 'Gorilla Hand'),
(27, 5, 'Dennis''s Mother'),
(28, 5, 'Sir Bedevere'),
(29, 5, 'Knight of Camelot'),
(30, 5, 'Left Head'),
(31, 5, 'Prince Herbert'),
(32, 5, 'Voice of Cartoon Scribe'),
(33, 6, 'First Swallow-Savvy Guard'),
(34, 6, 'Dennis'),
(35, 6, 'Peasant 2'),
(36, 6, 'Right Head'),
(37, 6, 'Sir Galahad the Pure'),
(38, 6, 'Knight of Camelot'),
(39, 6, 'Narrator'),
(40, 6, 'King of Swamp Castle'),
(41, 6, 'Brother Maynard''s Brother'),
(42, 6, 'Leader of The Knights Who Say Ni'),
(43, 7, 'The Witch'),
(44, 8, 'Zoot'),
(45, 8, 'Dingo'),
(46, 9, 'First Monk'),
(47, 9, 'Singing Minstrel'),
(48, 9, 'Page Crushed by the Rabbit'),
(49, 9, 'Peasant #4'),
(50, 10, 'Old Crone'),
(51, 11, 'Dead Body'),
(52, 11, 'Historian Frank'),
(53, 12, 'Historian''s Wife'),
(54, 13, 'Dr. Piglet'),
(55, 14, 'Dr. Winston'),
(56, 15, 'Prisoner'),
(57, 18, 'Knight of Ni'),
(58, 18, 'Villager at Witch Burning'),
(59, 18, 'Musician at Wedding'),
(60, 18, 'Monk'),
(61, 18, 'Knight in Battle'),
(62, 20, 'Musician at Wedding #4'),
(63, 10, 'Villager at Witch Burning'),
(64, 16, 'Girl in Castle Anthrax #1'),
(65, 17, 'Girl in Castle Anthrax #2'),
(66, 19, 'Girl in Castle Anthrax #3'),
(67, 21, 'Girl in Castle Anthrax #5'),
(68, 22, 'Girl in Castle Anthrax #6'),
(69, 23, 'Girl in Castle Anthrax #7'),
(70, 24, 'Girl in Castle Anthrax #8'),
(71, 25, 'Girl in Castle Anthrax #9'),
(72, 26, 'Girl in Castle Anthrax #10'),
(73, 27, 'Girl in Castle Anthrax #11'),
(74, 28, 'Girl in Castle Anthrax #12'),
(75, 29, 'Girl in Castle Anthrax #13'),
(76, 30, 'Girl in Castle Anthrax #14'),
(77, 31, 'Girl in Castle Anthrax #15'),
(78, 32, 'Girl in Castle Anthrax #16'),
(79, 33, 'Girl in Castle Anthrax #17'),
(80, 34, 'Girl in Castle Anthrax #18'),
(81, 35, 'Girl in Castle Anthrax #19');
INSERT INTO scenes (id, name) VALUES
(1, 'The Trouble With Swallows'),
(2, 'Just Die Already'),
(3, 'Repression is Nine Tenths of the Law?'),
(4, 'Arthur Meets a Brave Knight And Cuts His Limbs Off'),
(5, 'Witches and How To Build Bridges Out of Them'),
(6, 'Camelot is a Silly Place'),
(7, 'God Gives Arthur a Stern Talking To'),
(8, 'Why No One Likes The French'),
(9, 'Sir Robin''s Minstrels Turn Nasty'),
(10, 'The Oral Sects or Galahad Faces Peril Valiantly'),
(11, 'A Rather Silly Old Man Directs Arthur to an Enchanter'),
(12, 'Knights With A Repetitive Tendency to Repetitively Say Ni Repetitively'),
(13, 'Swamps Suck Castles'),
(14, 'Concorde Takes One For the Gipper'),
(15, 'Lancelot Saves a Beautiful and Melodious errr Prince?'),
(16, 'You Can''t Stop A errrr Prince?? From Singing'),
(17, 'How to Find that Perfect Shrubbery'),
(18, 'Shrubbery or Herring? That is the Question'),
(19, 'Tim the Enchanter Warns of Rabbit Peril'),
(20, 'Faced With a Killer Rabbit - Who''s Got the Grenade?'),
(21, 'Don''t Go Near the Castle Aarrggh'),
(22, 'The Bridge Keeper Doesn''t Swallow'),
(23, 'The French Fight Dirty or Why Everyone Hates the French');
-- This maps scenes and characters. It was derived from the script, so I know
-- it overlooks characters who didn't have lines in the scene. For example,
-- Patsy is in almost every scene with Arthur, but he only has one line in the
-- whole movie.
INSERT INTO scene_characters (scene_id, character_id) VALUES
(1, 1), (1, 5), (1, 20), (1, 32),
(2, 12), (2, 51),
(3, 1), (3, 20), (3, 27), (3, 34),
(4, 1), (4, 6), (4, 21),
(5, 1), (5, 7), (5, 13), (5, 26), (5, 28), (5, 35), (5, 39), (5, 43), (5, 46), (5, 49), (5, 58), (5, 60), (5, 63),
(6, 1), (6, 8), (6, 9), (6, 15), (6, 20), (6, 22), (6, 28), (6, 29), (6, 37), (6, 38), (6, 56),
(7, 1), (7, 2), (7, 8), (7, 37),
(8, 1), (8, 8), (8, 10), (8, 28), (8, 37), (8, 48),
(9, 3), (9, 14), (9, 27), (9, 30), (9, 32), (9, 34), (9, 36), (9, 39), (9, 47),
(10, 2), (10, 8), (10, 11), (10, 23), (10, 30), (10, 34), (10, 37), (10, 39), (10, 44), (10, 45), (10, 54), (10, 55), (10, 64), (10, 65), (10, 66), (10, 67), (10, 68), (10, 69), (10, 70), (10, 71), (10, 72), (10, 73), (10, 74), (10, 75), (10, 76), (10, 77), (10, 78), (10, 79), (10, 80), (10, 81),
(11, 1), (11, 23),
(12, 1), (12, 28), (12, 42), (12, 57),
(13, 16), (13, 31), (13, 39), (13, 40),
(14, 8), (14, 17),
(15, 8), (15, 16), (15, 31), (15, 40), (15, 59), (15, 62),
(16, 8), (16, 17), (16, 31), (16, 40), (16, 59), (16, 62),
(17, 1), (17, 18), (17, 28), (17, 50),
(18, 1), (18, 14), (18, 28), (18, 39), (18, 42), (18, 47), (18, 57),
(19, 1), (19, 11), (19, 14), (19, 28), (19, 37),
(20, 1), (20, 8), (20, 11), (20, 14), (20, 19), (20, 24), (20, 37), (20, 41), (20, 46), (20, 60),
(21, 1), (21, 8), (21, 19), (21, 25), (21, 28), (21, 37), (21, 39),
(22, 1), (22, 8), (22, 14), (22, 23), (22, 28), (22, 37),
(23, 1), (23, 10), (23, 28), (23, 53), (23, 61);
INSERT INTO quotes (character_id, scene_id, text) VALUES
(1, 1, 'It is I, Arthur, son of Uther Pendragon, from the castle of Camelot. King of the Britons, defeator of the Saxons, sovereign of all England!'),
(6, 1, 'Are you suggesting coconuts migrate?'),
(34, 3, 'Listen. Strange women lying in ponds distributing swords is no basis for a system of government. Supreme executive power derives from a mandate from the masses, not from some farcical aquatic ceremony.'),
(13, 5, 'If... she... weighs... the same as a duck,... she''s made of wood.'),
(1, 6, 'Well, on second thought, let''s not go to Camelot. It is a silly place.'),
(10, 8, 'I don''t wanna talk to you no more, you empty headed animal food trough wiper! I fart in your general direction! Your mother was a hamster and your father smelt of elderberries!'),
(42, 12, 'We shall say ''ni'' again to you if you do not appease us.'),
(18, 17, 'Oh, what sad times are these when passing ruffians can say ''ni'' at will to old ladies. There is a pestilence upon this land. Nothing is sacred. Even those who arrange and design shrubberies are under considerable economic stress at this period in history.'),
(1, 18, 'Cut down a tree with a herring? It can''t be done.'),
(11, 20, 'Look, that rabbit''s got a vicious streak a mile wide! It''s a killer!'),
(28, 6, 'And that, my liege, is how we know the earth to be banana-shaped.'),
(20, 6, 'It''s only a model.');