X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fpopulate.sql;fp=db%2Fpopulate.sql;h=c577a6c25664f0d2eb7c19bedcb7ff98b44e6d98;hb=c326e657d451c90220edbaa6f09fcb991350524c;hp=0000000000000000000000000000000000000000;hpb=5188295933c6628a7f52473b8f61c93a0aaac179;p=vchess.git

diff --git a/db/populate.sql b/db/populate.sql
new file mode 100644
index 00000000..c577a6c2
--- /dev/null
+++ b/db/populate.sql
@@ -0,0 +1,21 @@
+-- Re-run this script after variants are added
+
+insert or ignore into Variants values
+	('Alice', 'Both sides of the mirror'),
+	('Antiking', 'Keep antiking in check'),
+	('Atomic', 'Explosive captures'),
+	('Baroque', 'Exotic captures'),
+	('Berolina', 'Pawns move diagonally'),
+	('Checkered', 'Shared pieces'),
+	('Chess960', 'Standard rules'),
+	('Crazyhouse', 'Captures reborn'),
+	('Dark', 'In the shadow'),
+	('Extinction', 'Capture all of a kind'),
+	('Grand', 'Big board'),
+	('Losers', 'Lose all pieces'),
+	('Magnetic', 'Laws of attraction'),
+	('Marseille', 'Move twice'),
+	('Switching', 'Exchange pieces positions'),
+	('Upsidedown', 'Walking on the hands'),
+	('Wildebeest', 'Balanced sliders & leapers'),
+	('Zen', 'Reverse captures');