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
   8 create table Problems (
   9     num integer primary key,
  10     added datetime,
  11     variant varchar,
  12     fen varchar,
  13     instructions text,
  14     solution text,
  15     foreign key (variant) references Variants(name)
  16 );
  17
  18 PRAGMA foreign_keys = ON;