1 -- Database should be in this folder, and named 'vchess.sqlite'
3 create table Variants (
4 id integer primary key,
10 id integer primary key,
20 create table Problems (
21 id integer primary key,
28 foreign key (uid
) references Users(id),
29 foreign key (vid
) references Variants(id)
33 id integer primary key,
37 foreign key (uid
) references Users(id)
40 create table Challenges (
41 id integer primary key,
49 foreign key (uid
) references Users(id),
50 foreign key (vid
) references Variants(id)
54 id integer primary key,
56 fenStart
varchar, --initial state
57 fen
varchar, --current state
58 score
varchar default '*',
61 randomness
integer, --for rematch
63 drawOffer
character default '',
64 rematchOffer
character default '',
65 deletedByWhite
boolean,
66 deletedByBlack
boolean,
67 foreign key (vid
) references Variants(id)
77 -- Store informations about players in a corr game
78 create table Players (
82 foreign key (gid
) references Games(id),
83 foreign key (uid
) references Users(id)
88 squares
varchar, --description, appear/vanish/from/to
89 played datetime
, --when was this move played?
90 idx
integer, --index of the move in the game
91 foreign key (gid
) references Games(id)
94 pragma foreign_keys
= on;