Fix SQL query to get completed games

[vchess.git] / server / db / populate.sql

-- Re-run this script after variants are added

insert or ignore into Variants (name,description) values
  ('Alice', 'Both sides of the mirror'),
  ('Allmate1', 'Mate any piece (v1)'),
  ('Allmate2', 'Mate any piece (v2)'),
  ('Antiking', 'Keep antiking in check'),
  ('Antimatter', 'Dangerous collisions'),
  ('Arena', 'Middle battle'),
  ('Atomic', 'Explosive captures'),
  ('Baroque', 'Exotic captures'),
  ('Benedict', 'Change colors'),
  ('Berolina', 'Pawns move diagonally'),
  ('Capture', 'Mandatory captures'),
  ('Checkered', 'Shared pieces'),
  ('Chess960', 'Standard rules'),
  ('Circular', 'Run forward'),
  ('Crazyhouse', 'Captures reborn'),
  ('Cylinder', 'Neverending rows'),
  ('Dark', 'In the shadow'),
  ('Eightpieces', 'Each piece is unique'),
  ('Enpassant', 'Capture en passant'),
  ('Extinction', 'Capture all of a kind'),
  ('Grand', 'Big board'),
  ('Grasshopper', 'Long jumps over pieces'),
  ('Hidden', 'Unidentified pieces'),
  ('Hiddenqueen', 'Queen disguised as a pawn'),
  ('Knightmate', 'Mate the knight'),
  ('Knightrelay', 'The knight transfers its powers'),
  ('Losers', 'Get strong at self-mate'),
  ('Magnetic', 'Laws of attraction'),
  ('Marseille', 'Move twice'),
  ('Racingkings', 'Kings cross the 8x8 board'),
  ('Rifle', 'Shoot pieces'),
  ('Royalrace', 'Kings cross the 11x11 board'),
  ('Recycle', 'Reuse pieces'),
  ('Shatranj', 'Ancient rules'),
  ('Suicide', 'Lose all pieces'),
  ('Suction', 'Attract opposite king'),
  ('Threechecks', 'Give three checks'),
  ('Upsidedown', 'Board upside down'),
  ('Wildebeest', 'Balanced sliders & leapers'),
  ('Wormhole', 'Squares disappear'),
  ('Zen', 'Reverse captures');