From b46d86c9ad10c6c5f7a8db16155f52e80999b7d3 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sat, 1 May 2021 00:48:49 +0200
Subject: richard: Import Richard III.

---
 tools/sql/data-richard.txt | 3 +++
 views/index.ejs            | 1 +
 2 files changed, 4 insertions(+)
 create mode 100644 tools/sql/data-richard.txt

diff --git a/tools/sql/data-richard.txt b/tools/sql/data-richard.txt
new file mode 100644
index 0000000..ff0787c
--- /dev/null
+++ b/tools/sql/data-richard.txt
@@ -0,0 +1,3 @@
+INSERT OR REPLACE INTO titles VALUES ( 'richard-iii', 'Richard III', 25277 );
+INSERT OR REPLACE INTO roles VALUES ( 'richard-iii', 'York' );
+INSERT OR REPLACE INTO roles VALUES ( 'richard-iii', 'Lancaster' );
diff --git a/views/index.ejs b/views/index.ejs
index 1d545a3..95e7898 100644
--- a/views/index.ejs
+++ b/views/index.ejs
@@ -15,6 +15,7 @@ Registration and use is free, and there are no ads.
 <div class="list">
 <a href="/info/hammer-of-the-scots"><img src="/hammer-of-the-scots/cover.jpg"></a>
 <a href="/info/julius-caesar"><img src="/julius-caesar/cover.jpg"></a>
+<a href="/info/richard-iii"><img src="/richard-iii/cover.jpg"></a>
 </div>
 
 <p>
-- 
cgit v1.2.3