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