aboutsummaryrefslogtreecommitdiff
path: root/backend/database/insert/maps.sql
blob: f0235fa0c0195d9c225e71ef5ca7071cf69b503e (plain) (blame)
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
INSERT INTO maps(game_id, chapter_id, name, is_disabled, image) VALUES
-- Portal 2 Singleplayer
-- 1
(1,1,'Container Ride',true,''),
(1,1,'Portal Carousel',true,''),
(1,1,'Portal Gun',false,''),
(1,1,'Smooth Jazz',false,''),
(1,1,'Cube Momentum',false,''),
(1,1,'Future Starter',false,''),
(1,1,'Secret Panel',false,''),
(1,1,'Wakeup',true,''),
(1,1,'Incinerator',false,''),
-- 2
(1,2,'Laser Intro',false,''),
(1,2,'Laser Stairs',false,''),
(1,2,'Dual Lasers',false,''),
(1,2,'Laser Over Goo',false,''),
(1,2,'Catapult Intro',false,''),
(1,2,'Trust Fling',false,''),
(1,2,'Pit Flings',false,''),
(1,2,'Fizzler Intro',false,''),
-- 3
(1,3,'Ceiling Catapult',false,''),
(1,3,'Ricochet',false,''),
(1,3,'Bridge Intro',false,''),
(1,3,'Bridge The Gap',false,''),
(1,3,'Turret Intro',false,''),
(1,3,'Laser Relays',false,''),
(1,3,'Turret Blocker',false,''),
(1,3,'Laser vs Turret',false,''),
(1,3,'Pull The Rug',false,''),
-- 4
(1,4,'Column Blocker',false,''),
(1,4,'Laser Chaining',false,''),
(1,4,'Triple Laser',false,''),
(1,4,'Jail Break',false,''),
(1,4,'Escape',false,''),
-- 5
(1,5,'Turret Factory',false,''),
(1,5,'Turret Sabotage',false,''),
(1,5,'Neurotoxin Sabotage',false,''),
(1,5,'Core',false,''),
-- 6
(1,6,'Underground',false,''),
(1,6,'Cave Johnson',false,''),
(1,6,'Repulsion Intro',false,''),
(1,6,'Bomb Flings',false,''),
(1,6,'Crazy Box',false,''),
(1,6,'PotatOS',false,''),
-- 7
(1,7,'Propulsion Intro',false,''),
(1,7,'Propulsion Flings',false,''),
(1,7,'Conversion Intro',false,''),
(1,7,'Three Gels',false,''),
-- 8
(1,8,'Test',false,''),
(1,8,'Funnel Intro',false,''),
(1,8,'Ceiling Button',false,''),
(1,8,'Wall Button',false,''),
(1,8,'Polarity',false,''),
(1,8,'Funnel Catch',false,''),
(1,8,'Stop The Box',false,''),
(1,8,'Laser Catapult',false,''),
(1,8,'Laser Platform',false,''),
(1,8,'Propulsion Catch',false,''),
(1,8,'Repulsion Polarity',false,''),
-- 9
(1,9,'Finale 1',false,''),
(1,9,'Finale 2',false,''),
(1,9,'Finale 3',false,''),
(1,9,'Finale 4',false,''),
-- Portal 2 Cooperative
-- 0
(2,10,'Calibration',true,''),
(2,10,'Hub',true,''),
-- 1
(2,11,'Doors',false,''),
(2,11,'Buttons',false,''),
(2,11,'Lasers',false,''),
(2,11,'Rat Maze',false,''),
(2,11,'Laser Crusher',false,''),
(2,11,'Behind The Scenes',false,''),
-- 2
(2,12,'Flings',false,''),
(2,12,'Infinifling',false,''),
(2,12,'Team Retrieval',false,''),
(2,12,'Vertical Flings',false,''),
(2,12,'Catapults',false,''),
(2,12,'Multifling',false,''),
(2,12,'Fling Crushers',false,''),
(2,12,'Industrial Fan',false,''),
-- 3
(2,13,'Cooperative Bridges',false,''),
(2,13,'Bridge Swap',false,''),
(2,13,'Fling Block',false,''),
(2,13,'Catapult Block',false,''),
(2,13,'Bridge Fling',false,''),
(2,13,'Turret Walls',false,''),
(2,13,'Turret Assasin',false,''),
(2,13,'Bridge Testing',false,''),
-- 4
(2,14,'Cooperative Funnels',false,''),
(2,14,'Funnel Drill',false,''),
(2,14,'Funnel Catch',false,''),
(2,14,'Funnel Laser',false,''),
(2,14,'Cooperative Polarity',false,''),
(2,14,'Funnel Hop',false,''),
(2,14,'Advanced Polarity',false,''),
(2,14,'Funnel Maze',false,''),
(2,14,'Turret Warehouse',false,''),
-- 5
(2,15,'Repulsion Jumps',false,''),
(2,15,'Double Bounce',false,''),
(2,15,'Bridge Repulsion',false,''),
(2,15,'Wall Repulsion',false,''),
(2,15,'Propulsion Crushers',false,''),
(2,15,'Turret Ninja',false,''),
(2,15,'Propulsion Retrieval',false,''),
(2,15,'Vault Entrance',false,''),
-- 6
(2,16,'Separation',false,''),
(2,16,'Triple Axis',false,''),
(2,16,'Catapult Catch',false,''),
(2,16,'Bridge Gels',false,''),
(2,16,'Maintenance',false,''),
(2,16,'Bridge Catch',false,''),
(2,16,'Double Lift',false,''),
(2,16,'Gel Maze',false,''),
(2,16,'Crazier Box',false,'');