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