563477200101308cad28c57e5b6a47ccc9cb13da
[vchess.git] / server / db / populate.sql
1 -- Re-run this script after variants are added
2
3 insert or ignore into Variants (name, description, noProblems) values
4 ('Apocalypse', 'The end of the world', true),
5 ('Chakart', 'Capture the princess', true),
6 ('Dark', 'In the shadow', true),
7 ('Dice', 'Roll the dice', true),
8 ('Hidden', 'Unidentified pieces', true),
9 ('Hiddenqueen', 'Queen disguised as a pawn', true),
10 ('Synchrone1', 'Play at the same time (v1)', true),
11 ('Synchrone2', 'Play at the same time (v2)', true);
12
13 insert or ignore into Variants (name, description) values
14 ('Absorption', 'Absorb powers'),
15 ('Alapo', 'Geometric Chess'),
16 ('Alice', 'Both sides of the mirror'),
17 ('Align4', 'Align four pawns'),
18 ('Allmate1', 'Mate any piece (v1)'),
19 ('Allmate2', 'Mate any piece (v2)'),
20 ('Ambiguous', 'Play opponent''s pieces'),
21 ('Antiking1', 'Keep antiking in check (v1)'),
22 ('Antiking2', 'Keep antiking in check (v2)'),
23 ('Antimatter', 'Dangerous collisions'),
24 ('Arena', 'Middle battle'),
25 ('Atarigo', 'First capture wins'),
26 ('Atomic1', 'Explosive captures (v1)'),
27 ('Atomic2', 'Explosive captures (v2)'),
28 ('Avalam1', 'Build towers (v1)'),
29 ('Avalam2', 'Build towers (v2)'),
30 ('Avalanche', 'Pawnfalls'),
31 ('Ball', 'Score a goal'),
32 ('Balaklava', 'Meet the Mammoth'),
33 ('Bario', 'A quantum story'),
34 ('Baroque', 'Exotic captures'),
35 ('Benedict', 'Change colors'),
36 ('Berolina', 'Pawns move diagonally'),
37 ('Bicolour', 'Harassed kings'),
38 ('Bishopawns', 'Bishop versus pawns'),
39 ('Brotherhood', 'Friendly pieces'),
40 ('Cannibal', 'Capture powers'),
41 ('Capablanca', 'Capablanca Chess'),
42 ('Capture', 'Mandatory captures'),
43 ('Castle', 'Win by castling long'),
44 ('Checkered1', 'Shared pieces (v1)'),
45 ('Checkered2', 'Shared pieces (v2)'),
46 ('Checkless', 'No-check mode'),
47 ('Chess960', 'Standard rules'),
48 ('Circular', 'Run forward'),
49 ('Clorange', 'A Clockwork Orange'),
50 ('Colorbound', 'The colorbound clobberers'),
51 ('Convert', 'Convert enemy pieces'),
52 ('Copycat', 'Borrow powers'),
53 ('Coregal', 'Two royal pieces'),
54 ('Coronation', 'Long live the Queen'),
55 ('Crazyhouse', 'Captures reborn'),
56 ('Crossing', 'Cross the river'),
57 ('Cylinder', 'Neverending rows'),
58 ('Diamond', 'Rotating board'),
59 ('Discoduel', 'Enter the disco'),
60 ('Dobutsu', 'Let''s catch the Lion!'),
61 ('Doublearmy', '64 pieces on the board'),
62 ('Doublemove1', 'Double moves (v1)'),
63 ('Doublemove2', 'Double moves (v2)'),
64 ('Dynamo', 'Push and pull'),
65 ('Eightpieces', 'Each piece is unique'),
66 ('Emergo', 'Stacking Checkers variant'),
67 ('Empire', 'Empire versus Kingdom'),
68 ('Enpassant', 'Capture en passant'),
69 ('Evolution', 'Faster development'),
70 ('Extinction', 'Capture all of a kind'),
71 ('Fanorona', 'Malagasy Draughts'),
72 ('Football', 'Score a goal'),
73 ('Forward', 'Moving forward'),
74 ('Freecapture', 'Capture both colors'),
75 ('Fugue', 'Baroque Music'),
76 ('Fullcavalry', 'Lancers everywhere'),
77 ('Fusion', 'Fusion pieces (v1)'),
78 ('Gomoku', 'Align five stones'),
79 ('Grand', 'Big board'),
80 ('Grasshopper', 'Long jumps over pieces'),
81 ('Gridolina', 'Jump the borders'),
82 ('Hamilton', 'Walk on a graph'),
83 ('Hoppelpoppel', 'Knibis and Bisknis'),
84 ('Horde', 'A pawns cloud'),
85 ('Hypnotic', 'Mind control (v1)'),
86 ('Iceage', 'Ice Age is coming!'),
87 ('Interweave', 'Interweaved colorbound teams'),
88 ('Isardam', 'No paralyzed pieces'),
89 ('Janggi', 'Korean Chess'),
90 ('Joker', 'Replace pieces'),
91 ('Karouk', 'Thai Chess (v3)'),
92 ('Kinglet', 'Protect your pawns'),
93 ('Kingsmaker', 'Promote into kings'),
94 ('Knightmate', 'Mate the knight'),
95 ('Knightpawns', 'Knight versus pawns'),
96 ('Knightrelay1', 'Move like a knight (v1)'),
97 ('Knightrelay2', 'Move like a knight (v2)'),
98 ('Konane', 'Hawaiian Checkers'),
99 ('Koopa', 'Stun & kick pieces'),
100 ('Koth', 'King of the Hill'),
101 ('Losers', 'Get strong at self-mate'),
102 ('Madhouse', 'Rearrange enemy pieces'),
103 ('Madrasi', 'Paralyzed pieces'),
104 ('Magnetic', 'Laws of attraction'),
105 ('Maharajah', 'Augmented Queens'),
106 ('Makpong', 'Thai Chess (v2)'),
107 ('Makruk', 'Thai Chess (v1)'),
108 ('Maxima', 'Occupy the enemy palace'),
109 ('Mesmer', 'Mind control (v2)'),
110 ('Minishogi', 'Shogi 5 x 5'),
111 ('Minixiangqi', 'Xiangqi 7 x 7'),
112 ('Monochrome', 'All of the same color'),
113 ('Monster', 'White move twice'),
114 ('Musketeer', 'New fairy pieces'),
115 ('Omega', 'A wizard in the corner'),
116 ('Orda', 'Mongolian Horde (v1)'),
117 ('Ordamirror', 'Mongolian Horde (v2)'),
118 ('Otage', 'Capture and release hostages'),
119 ('Pacifist1', 'Convert & support (v1)'),
120 ('Pacifist2', 'Convert & support (v2)'),
121 ('Pacosako', 'Dance with the King'),
122 ('Pandemonium', 'Noise and confusion'),
123 ('Parachute', 'Landing on the board'),
124 ('Pawnmassacre', 'Pieces upside down'),
125 ('Pawns', 'Reach the last rank (v1)'),
126 ('Pawnsking', 'Reach the last rank (v2)'),
127 ('Perfect', 'Powerful pieces'),
128 ('Pocketknight', 'Knight in pocket'),
129 ('Progressive1', 'Play more and more moves (v1)'),
130 ('Progressive2', 'Play more and more moves (v2)'),
131 ('Queenpawns', 'Queen versus pawns'),
132 ('Racingkings', 'Kings cross the 8x8 board'),
133 ('Rampage', 'Move under cover'),
134 ('Relayup', 'Upgrade pieces'),
135 ('Rifle', 'Shoot pieces'),
136 ('Recycle', 'Reuse pieces'),
137 ('Refusal1', 'Do not play that! (v1)'),
138 ('Refusal2', 'Do not play that! (v2)'),
139 ('Rollerball', 'As in the movie'),
140 ('Rococo', 'Capture on the edge'),
141 ('Rookpawns', 'Rook versus pawns'),
142 ('Royalrace', 'Kings cross the 11x11 board'),
143 ('Rugby', 'Transform an essay'),
144 ('Schess', 'Seirawan-Harper Chess'),
145 ('Screen', 'Free initial setup'),
146 ('Selfabsorb', 'Fusion pieces (v2)'),
147 ('Shako', 'Non-conformism and utopia'),
148 ('Shatranj', 'Ancient rules'),
149 ('Shogi', 'Japanese Chess'),
150 ('Shogun', 'General''s Chess'),
151 ('Sittuyin', 'Burmese Chess'),
152 ('Spartan', 'Spartan versus Persians'),
153 ('Squatter1', 'Squat last rank (v1)'),
154 ('Squatter2', 'Squat last rank (v2)'),
155 ('Suicide', 'Lose all pieces'),
156 ('Suction', 'Attract opposite king'),
157 ('Swap', 'Dangerous captures'),
158 ('Switching', 'Exchange pieces'' positions'),
159 ('Synochess', 'Dynasty versus Kingdom'),
160 ('Takenmake', 'Prolongated captures'),
161 ('Teleport', 'Reposition pieces'),
162 ('Tencubed', 'Four new pieces'),
163 ('Threechecks', 'Give three checks'),
164 ('Titan', 'Extra bishops and knights'),
165 ('Twokings', 'Two kings'),
166 ('Upsidedown', 'Board upside down'),
167 ('Vchess', 'Pawns capture backward'),
168 ('Wildebeest', 'Balanced sliders & leapers'),
169 ('Wormhole1', 'Squares disappear (v1)'),
170 ('Wormhole2', 'Squares disappear (v2)'),
171 ('Xiangqi', 'Chinese Chess'),
172 ('Yote', 'African Draughts'),
173 ('Zen', 'Reverse captures');