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