[vchess.git] / db / create.sql

-- Database should be in this folder, and named 'vchess.sqlite'

create table Variants (
	name varchar primary key,
	description text
);

create table Problems (
	num integer primary key,
	added datetime,
	variant varchar,
	fen varchar,
	instructions text,
	solution text,
	foreign key (variant) references Variants(name)
);

PRAGMA foreign_keys = ON;
Commit	Line	Data
	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;