db/create.sql

   1 -- database should be in this folder, and named 'vchess.sqlite'
   2
   3 create table Variants (
   4     name varchar primary key,
   5     description text
   6 );
   7 insert into Variants values
   8     ('Checkered', 'Shared pieces'),
   9     ('Zen', 'Reverse captures'),
  10     ('Atomic', 'Explosive captures'),
  11     ('Chess960', 'Standard rules'),
  12     ('Antiking', 'Keep antiking in check'),
  13     ('Magnetic', 'Laws of attraction'),
  14     ('Alice', 'Both sides of the mirror'),
  15     ('Grand', 'Big board'),
  16     ('Wildebeest', 'Balanced sliders & leapers'),
  17     ('Loser', 'Lose all pieces'),
  18     ('Crazyhouse', 'Captures reborn'),
  19     ('Switching', 'Exchange pieces positions'),
  20     ('Extinction', 'Capture all of a kind'),
  21     ('Ultima', 'Exotic captures');
  22
  23 create table Problems (
  24     added datetime,
  25     variant varchar,
  26     fen varchar,
  27     instructions text,
  28     solution text,
  29     foreign key (variant) references Variants(name)
  30 );
  31 --PRAGMA foreign_keys = ON;