[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
c326e657	1	-- Database should be in this folder, and named 'vchess.sqlite'
86c9843c	2
da06a6eb BA	3	create table Variants (
	4	name varchar primary key,
	5	description text
	6	);
da06a6eb BA	7
da06a6eb BA	8	create 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
c326e657 BA	18	PRAGMA foreign_keys = ON;