Add roadmap on TODO file
[vchess.git] / db / create.sql
... / ...
CommitLineData
1-- Database should be in this folder, and named 'vchess.sqlite'
2
3create table Variants (
4 name varchar primary key,
5 description text
6);
7
8create 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
18PRAGMA foreign_keys = ON;