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

diff --git a/db/create.sql b/db/create.sql
deleted file mode 100644
index aa2f3ae1..00000000
--- a/db/create.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-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;