X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=56ae4f19183da7a21a192689e9dcaa83ca082438;hb=HEAD;hp=36bda8aafebfbeb2aa7faf3c50eea6a011bbc8d3;hpb=86c9843cd04717d61f373ebaf3a1fdf21fd5a60f;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
deleted file mode 100644
index 36bda8aa..00000000
--- a/db/create.sql
+++ /dev/null
@@ -1,31 +0,0 @@
--- database should be in this folder, and named 'vchess.sqlite'
-
-create table Variants (
-	name varchar primary key,
-	description text
-);
-insert into Variants values
-	('Checkered', 'Shared pieces'),
-	('Zen', 'Reverse captures'),
-	('Atomic', 'Explosive captures'),
-	('Chess960', 'Standard rules'),
-	('Antiking', 'Keep antiking in check'),
-	('Magnetic', 'Laws of attraction'),
-	('Alice', 'Both sides of the mirror'),
-	('Grand', 'Big board'),
-	('Wildebeest', 'Balanced sliders & leapers'),
-	('Loser', 'Lose all pieces'),
-	('Crazyhouse', 'Captures reborn'),
-	('Switching', 'Exchange pieces positions'),
-	('Extinction', 'Capture all of a kind'),
-	('Ultima', 'Exotic captures');
-
-create table Problems (
-	added datetime,
-	variant varchar,
-	fen varchar,
-	instructions text,
-	solution text,
-	foreign key (variant) references Variants(name)
-);
---PRAGMA foreign_keys = ON;