Update TODO
[vchess.git] / db / create.sql
CommitLineData
c326e657 1-- Database should be in this folder, and named 'vchess.sqlite'
86c9843c 2
da06a6eb
BA
3create table Variants (
4 name varchar primary key,
5 description text
6);
da06a6eb
BA
7
8create table Problems (
643479f8 9 num integer primary key,
da06a6eb
BA
10 added datetime,
11 variant varchar,
12 fen varchar,
13 instructions text,
14 solution text,
15 foreign key (variant) references Variants(name)
16);
c326e657
BA
17
18PRAGMA foreign_keys = ON;