Add Kinglet + a few fixes
[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
BA
6 ('Dark', 'In the shadow', true),
7 ('Hidden', 'Unidentified pieces', true),
8 ('Hiddenqueen', 'Queen disguised as a pawn', true),
9 ('Synchrone', 'Play at the same time', true);
10
11insert or ignore into Variants (name, description) values
107dc1bd 12 ('Absorption', 'Absorb powers'),
dac39588 13 ('Alice', 'Both sides of the mirror'),
9618937e
BA
14 ('Allmate1', 'Mate any piece (v1)'),
15 ('Allmate2', 'Mate any piece (v2)'),
5b958911 16 ('Ambiguous', 'Play opponent''s pieces'),
c583ef1c
BA
17 ('Antiking1', 'Keep antiking in check (v1)'),
18 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 19 ('Antimatter', 'Dangerous collisions'),
c3a86f01 20 ('Arena', 'Middle battle'),
dac39588 21 ('Atomic', 'Explosive captures'),
6f2f9437 22 ('Ball', 'Score a goal'),
dac39588 23 ('Baroque', 'Exotic captures'),
9bd6786b 24 ('Benedict', 'Change colors'),
dac39588 25 ('Berolina', 'Pawns move diagonally'),
107dc1bd 26 ('Bicolour', 'Harassed kings'),
dfc78263 27 ('Cannibal', 'Capture powers'),
6b7b2cf7 28 ('Capture', 'Mandatory captures'),
af34341d
BA
29 ('Checkered1', 'Shared pieces (v1)'),
30 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 31 ('Checkless', 'No-check mode'),
dac39588 32 ('Chess960', 'Standard rules'),
e3e2cc44 33 ('Circular', 'Run forward'),
801e2870 34 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 35 ('Coregal', 'Two royal pieces'),
107dc1bd 36 ('Coronation', 'Long live the Queen'),
dac39588 37 ('Crazyhouse', 'Captures reborn'),
71ef1664 38 ('Cylinder', 'Neverending rows'),
59e74176 39 ('Diamond', 'Rotating board'),
de3f5625 40 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
41 ('Doublemove1', 'Double moves (v1)'),
42 ('Doublemove2', 'Double moves (v2)'),
c7550017 43 ('Dynamo', 'Push and pull'),
90e814b6 44 ('Eightpieces', 'Each piece is unique'),
7d8bf63e 45 ('Enpassant', 'Capture en passant'),
dac39588 46 ('Extinction', 'Capture all of a kind'),
107dc1bd 47 ('Football', 'Score a goal'),
dac39588 48 ('Grand', 'Big board'),
a97bdbda 49 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 50 ('Gridolina', 'Jump the borders'),
22053c2c 51 ('Hamilton', 'Walk on a graph'),
f9385686 52 ('Horde', 'A pawns cloud'),
0b1405c4 53 ('Interweave', 'Interweaved colorbound teams'),
57078452 54 ('Kinglet', 'Protect your pawns'),
a97bdbda 55 ('Knightmate', 'Mate the knight'),
68e19a44
BA
56 ('Knightrelay1', 'Move like a knight (v1)'),
57 ('Knightrelay2', 'Move like a knight (v2)'),
236485b5 58 ('Koth', 'King of the Hill'),
6b7b2cf7 59 ('Losers', 'Get strong at self-mate'),
107dc1bd 60 ('Madrasi', 'Paralyzed pieces'),
dac39588 61 ('Magnetic', 'Laws of attraction'),
cd49e617 62 ('Makruk', 'Thai Chess'),
e90bafa8 63 ('Maxima', 'Occupy the enemy palace'),
e2f204ed 64 ('Minishogi', 'Shogi 5 x 5'),
665eed90 65 ('Monochrome', 'All of the same color'),
5e1bc651 66 ('Monster', 'White move twice'),
472c0c4f 67 ('Omega', 'A wizard in the corner'),
c7550017 68 ('Orda', 'Mongolian Horde'),
0d5335de 69 ('Parachute', 'Landing on the board'),
a6836242 70 ('Perfect', 'Powerful pieces'),
6b7b2cf7 71 ('Racingkings', 'Kings cross the 8x8 board'),
c3a86f01 72 ('Rifle', 'Shoot pieces'),
78d64531 73 ('Recycle', 'Reuse pieces'),
e90bafa8 74 ('Rococo', 'Capture on the edge'),
77691911 75 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 76 ('Rugby', 'Transform an essay'),
305ede7e 77 ('Schess', 'Seirawan-Harper Chess'),
cd49e617 78 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 79 ('Shatranj', 'Ancient rules'),
cd49e617 80 ('Shogi', 'Japanese Chess'),
b406466b 81 ('Sittuyin', 'Burmese chess'),
6b7b2cf7 82 ('Suicide', 'Lose all pieces'),
31e9e40a 83 ('Suction', 'Attract opposite king'),
0b1405c4 84 ('Takenmake', 'Prolongated captures'),
107dc1bd 85 ('Teleport', 'Reposition pieces'),
472c0c4f 86 ('Tencubed', 'Four new pieces'),
92240cf0 87 ('Threechecks', 'Give three checks'),
14c35dc6 88 ('Twokings', 'Two kings'),
602d6bef 89 ('Upsidedown', 'Board upside down'),
dac39588 90 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 91 ('Wormhole', 'Squares disappear'),
dac39588 92 ('Zen', 'Reverse captures');