Move 'anonymousCount' which was computed to a method in Hall. Seems more accurate
[vchess.git] / server / db / populate.sql
CommitLineData
c326e657
BA
1-- Re-run this script after variants are added
2
8d7e2786 3insert or ignore into Variants (name,description) values
dac39588 4 ('Alice', 'Both sides of the mirror'),
9618937e
BA
5 ('Allmate1', 'Mate any piece (v1)'),
6 ('Allmate2', 'Mate any piece (v2)'),
dac39588 7 ('Antiking', 'Keep antiking in check'),
8b405c81 8 ('Antimatter', 'Dangerous collisions'),
c3a86f01 9 ('Arena', 'Middle battle'),
dac39588
BA
10 ('Atomic', 'Explosive captures'),
11 ('Baroque', 'Exotic captures'),
9bd6786b 12 ('Benedict', 'Change colors'),
dac39588 13 ('Berolina', 'Pawns move diagonally'),
6b7b2cf7 14 ('Capture', 'Mandatory captures'),
dac39588
BA
15 ('Checkered', 'Shared pieces'),
16 ('Chess960', 'Standard rules'),
e3e2cc44 17 ('Circular', 'Run forward'),
dac39588 18 ('Crazyhouse', 'Captures reborn'),
71ef1664 19 ('Cylinder', 'Neverending rows'),
dac39588 20 ('Dark', 'In the shadow'),
90e814b6 21 ('Eightpieces', 'Each piece is unique'),
7d8bf63e 22 ('Enpassant', 'Capture en passant'),
dac39588
BA
23 ('Extinction', 'Capture all of a kind'),
24 ('Grand', 'Big board'),
a97bdbda 25 ('Grasshopper', 'Long jumps over pieces'),
241bf8f2 26 ('Hidden', 'Unidentified pieces'),
a97bdbda
BA
27 ('Hiddenqueen', 'Queen disguised as a pawn'),
28 ('Knightmate', 'Mate the knight'),
68e19a44
BA
29 ('Knightrelay1', 'Move like a knight (v1)'),
30 ('Knightrelay2', 'Move like a knight (v2)'),
6b7b2cf7 31 ('Losers', 'Get strong at self-mate'),
dac39588
BA
32 ('Magnetic', 'Laws of attraction'),
33 ('Marseille', 'Move twice'),
6b7b2cf7 34 ('Racingkings', 'Kings cross the 8x8 board'),
c3a86f01 35 ('Rifle', 'Shoot pieces'),
6b7b2cf7 36 ('Royalrace', 'Kings cross the 11x11 board'),
78d64531 37 ('Recycle', 'Reuse pieces'),
a4eca0dc 38 ('Shatranj', 'Ancient rules'),
6b7b2cf7 39 ('Suicide', 'Lose all pieces'),
31e9e40a 40 ('Suction', 'Attract opposite king'),
92240cf0 41 ('Threechecks', 'Give three checks'),
602d6bef 42 ('Upsidedown', 'Board upside down'),
dac39588 43 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 44 ('Wormhole', 'Squares disappear'),
dac39588 45 ('Zen', 'Reverse captures');