Add Joker 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'),
9618937e
BA
17 ('Allmate1', 'Mate any piece (v1)'),
18 ('Allmate2', 'Mate any piece (v2)'),
5b958911 19 ('Ambiguous', 'Play opponent''s pieces'),
c583ef1c
BA
20 ('Antiking1', 'Keep antiking in check (v1)'),
21 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 22 ('Antimatter', 'Dangerous collisions'),
c3a86f01 23 ('Arena', 'Middle battle'),
0fb43db7
BA
24 ('Atomic1', 'Explosive captures (v1)'),
25 ('Atomic2', 'Explosive captures (v2)'),
4258b58c 26 ('Avalanche', 'Pawnfalls'),
6f2f9437 27 ('Ball', 'Score a goal'),
a0224b03 28 ('Balaklava', 'Meet the Mammoth'),
dac39588 29 ('Baroque', 'Exotic captures'),
9bd6786b 30 ('Benedict', 'Change colors'),
dac39588 31 ('Berolina', 'Pawns move diagonally'),
107dc1bd 32 ('Bicolour', 'Harassed kings'),
737a5daf 33 ('Bishopawns', 'Bishop versus pawns'),
6c00a6e5 34 ('Brotherhood', 'Friendly pieces'),
dfc78263 35 ('Cannibal', 'Capture powers'),
3208c667 36 ('Capablanca', 'Capablanca Chess'),
6b7b2cf7 37 ('Capture', 'Mandatory captures'),
2bb4666e 38 ('Castle', 'Win by castling long'),
af34341d
BA
39 ('Checkered1', 'Shared pieces (v1)'),
40 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 41 ('Checkless', 'No-check mode'),
dac39588 42 ('Chess960', 'Standard rules'),
e3e2cc44 43 ('Circular', 'Run forward'),
0b8bd121 44 ('Clorange', 'A Clockwork Orange'),
801e2870 45 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 46 ('Coregal', 'Two royal pieces'),
107dc1bd 47 ('Coronation', 'Long live the Queen'),
dac39588 48 ('Crazyhouse', 'Captures reborn'),
0f7762c1 49 ('Crossing', 'Cross the river'),
71ef1664 50 ('Cylinder', 'Neverending rows'),
59e74176 51 ('Diamond', 'Rotating board'),
737a5daf 52 ('Discoduel', 'Enter the disco'),
6c00a6e5 53 ('Dobutsu', 'Let''s catch the Lion!'),
de3f5625 54 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
55 ('Doublemove1', 'Double moves (v1)'),
56 ('Doublemove2', 'Double moves (v2)'),
c7550017 57 ('Dynamo', 'Push and pull'),
90e814b6 58 ('Eightpieces', 'Each piece is unique'),
1e8a8386 59 ('Empire', 'Empire versus Kingdom'),
7d8bf63e 60 ('Enpassant', 'Capture en passant'),
91565c63 61 ('Evolution', 'Faster development'),
dac39588 62 ('Extinction', 'Capture all of a kind'),
107dc1bd 63 ('Football', 'Score a goal'),
0b8bd121 64 ('Forward', 'Moving forward'),
e88d69a8 65 ('Freecapture', 'Capture both colors'),
0fb43db7 66 ('Fullcavalry', 'Lancers everywhere'),
dac39588 67 ('Grand', 'Big board'),
a97bdbda 68 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 69 ('Gridolina', 'Jump the borders'),
22053c2c 70 ('Hamilton', 'Walk on a graph'),
dbc79ee6 71 ('Hoppelpoppel', 'Knibis and Bisknis'),
f9385686 72 ('Horde', 'A pawns cloud'),
2fac4d67 73 ('Hypnotic', 'Mind control (v1)'),
0b1405c4 74 ('Interweave', 'Interweaved colorbound teams'),
059f0aa2 75 ('Isardam', 'No paralyzed pieces'),
fe887246 76 ('Janggi', 'Korean Chess'),
459edd58 77 ('Joker', 'Replace pieces'),
57078452 78 ('Kinglet', 'Protect your pawns'),
0f7762c1 79 ('Kingsmaker', 'Promote into kings'),
a97bdbda 80 ('Knightmate', 'Mate the knight'),
737a5daf 81 ('Knightpawns', 'Knight versus pawns'),
68e19a44
BA
82 ('Knightrelay1', 'Move like a knight (v1)'),
83 ('Knightrelay2', 'Move like a knight (v2)'),
e88d69a8 84 ('Koopa', 'Stun & kick pieces'),
236485b5 85 ('Koth', 'King of the Hill'),
6b7b2cf7 86 ('Losers', 'Get strong at self-mate'),
a9e1202b 87 ('Madhouse', 'Rearrange enemy pieces'),
107dc1bd 88 ('Madrasi', 'Paralyzed pieces'),
dac39588 89 ('Magnetic', 'Laws of attraction'),
6c00a6e5 90 ('Maharajah', 'Augmented Queens'),
dbc79ee6
BA
91 ('Makpong', 'Thai Chess (v2)'),
92 ('Makruk', 'Thai Chess (v1)'),
e90bafa8 93 ('Maxima', 'Occupy the enemy palace'),
2fac4d67 94 ('Mesmer', 'Mind control (v2)'),
e2f204ed 95 ('Minishogi', 'Shogi 5 x 5'),
2c947b3a 96 ('Minixiangqi', 'Xiangqi 7 x 7'),
665eed90 97 ('Monochrome', 'All of the same color'),
5e1bc651 98 ('Monster', 'White move twice'),
3208c667 99 ('Musketeer', 'New fairy pieces'),
472c0c4f 100 ('Omega', 'A wizard in the corner'),
0b8bd121 101 ('Orda', 'Mongolian Horde (v1)'),
e50a8025 102 ('Ordamirror', 'Mongolian Horde (v2)'),
9d15c433 103 ('Otage', 'Capture and release hostages'),
4fcb0c04
BA
104 ('Pacifist1', 'Convert & support (v1)'),
105 ('Pacifist2', 'Convert & support (v2)'),
173f11dc 106 ('Pacosako', 'Dance with the King'),
0d5335de 107 ('Parachute', 'Landing on the board'),
737a5daf
BA
108 ('Pawnmassacre', 'Pieces upside down'),
109 ('Pawns', 'Reach the last rank (v1)'),
110 ('Pawnsking', 'Reach the last rank (v2)'),
a6836242 111 ('Perfect', 'Powerful pieces'),
a9e1202b 112 ('Pocketknight', 'Knight in pocket'),
eaab401e
BA
113 ('Progressive1', 'Play more and more moves (v1)'),
114 ('Progressive2', 'Play more and more moves (v2)'),
9f88188c 115 ('Queenpawns', 'Queen versus pawns'),
6b7b2cf7 116 ('Racingkings', 'Kings cross the 8x8 board'),
35ff9d1b 117 ('Rampage', 'Move under cover'),
da9e846e 118 ('Relayup', 'Upgrade pieces'),
c3a86f01 119 ('Rifle', 'Shoot pieces'),
78d64531 120 ('Recycle', 'Reuse pieces'),
e90bafa8 121 ('Rococo', 'Capture on the edge'),
737a5daf 122 ('Rookpawns', 'Rook versus pawns'),
77691911 123 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 124 ('Rugby', 'Transform an essay'),
305ede7e 125 ('Schess', 'Seirawan-Harper Chess'),
39fe711a 126 ('Screen', 'Free initial setup'),
cd49e617 127 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 128 ('Shatranj', 'Ancient rules'),
cd49e617 129 ('Shogi', 'Japanese Chess'),
7e107b8f 130 ('Sittuyin', 'Burmese Chess'),
0f7762c1 131 ('Squatter', 'Squat last rank'),
6b7b2cf7 132 ('Suicide', 'Lose all pieces'),
31e9e40a 133 ('Suction', 'Attract opposite king'),
964eda04
BA
134 ('Swap', 'Dangerous captures'),
135 ('Switching', 'Exchange pieces'' positions'),
1e8a8386 136 ('Synochess', 'Dynasty versus Kingdom'),
0b1405c4 137 ('Takenmake', 'Prolongated captures'),
107dc1bd 138 ('Teleport', 'Reposition pieces'),
472c0c4f 139 ('Tencubed', 'Four new pieces'),
92240cf0 140 ('Threechecks', 'Give three checks'),
91565c63 141 ('Titan', 'Extra bishops and knights'),
14c35dc6 142 ('Twokings', 'Two kings'),
602d6bef 143 ('Upsidedown', 'Board upside down'),
b2b5a729 144 ('Vchess', 'Pawns capture backward'),
dac39588 145 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 146 ('Wormhole', 'Squares disappear'),
7e107b8f 147 ('Xiangqi', 'Chinese Chess'),
dac39588 148 ('Zen', 'Reverse captures');