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