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