From d1318d147297161691f5048e1f2cb4e516159144 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 14 Nov 2021 17:17:49 +0100 Subject: Add 'hidden' column to titles for beta-testing games. --- tools/sql/data.txt | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 tools/sql/data.txt (limited to 'tools/sql/data.txt') diff --git a/tools/sql/data.txt b/tools/sql/data.txt new file mode 100644 index 0000000..7268acc --- /dev/null +++ b/tools/sql/data.txt @@ -0,0 +1,29 @@ +PRAGMA foreign_keys=0; + +INSERT OR REPLACE INTO titles VALUES ( '300-earth-and-water', '300: Earth & Water', 267058, 0 ); +INSERT OR REPLACE INTO roles VALUES ( '300-earth-and-water', 'Persia' ); +INSERT OR REPLACE INTO roles VALUES ( '300-earth-and-water', 'Greece' ); + +INSERT OR REPLACE INTO titles VALUES ( 'crusader-rex', 'Crusader Rex', 8481, 0 ); +INSERT OR REPLACE INTO roles VALUES ( 'crusader-rex', 'Franks' ); +INSERT OR REPLACE INTO roles VALUES ( 'crusader-rex', 'Saracens' ); + +INSERT OR REPLACE INTO titles VALUES ( 'julius-caesar', 'Julius Caesar', 37836, 0 ); +INSERT OR REPLACE INTO roles VALUES ( 'julius-caesar', 'Caesar' ); +INSERT OR REPLACE INTO roles VALUES ( 'julius-caesar', 'Pompeius' ); + +INSERT OR REPLACE INTO titles VALUES ( 'hammer-of-the-scots', 'Hammer of the Scots', 3685, 0 ); +INSERT OR REPLACE INTO roles VALUES ( 'hammer-of-the-scots', 'England' ); +INSERT OR REPLACE INTO roles VALUES ( 'hammer-of-the-scots', 'Scotland' ); + +INSERT OR REPLACE INTO titles VALUES ( 'richard-iii', 'Richard III', 25277, 0 ); +INSERT OR REPLACE INTO roles VALUES ( 'richard-iii', 'York' ); +INSERT OR REPLACE INTO roles VALUES ( 'richard-iii', 'Lancaster' ); + +INSERT OR REPLACE INTO titles VALUES ( 'shores-of-tripoli', 'The Shores of Tripoli', 237860, 0 ); +INSERT OR REPLACE INTO roles VALUES ( 'shores-of-tripoli', 'Tripolitania' ); +INSERT OR REPLACE INTO roles VALUES ( 'shores-of-tripoli', 'United States' ); + +INSERT OR REPLACE INTO titles VALUES ( 'wilderness-war', 'Wilderness War', 1822, 1 ); +INSERT OR REPLACE INTO roles VALUES ( 'wilderness-war', 'French' ); +INSERT OR REPLACE INTO roles VALUES ( 'wilderness-war', 'British' ); -- cgit v1.2.3