db/create.sql

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