summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2021-05-01 00:48:49 +0200
committerTor Andersson <tor@ccxvii.net>2021-05-04 19:08:34 +0200
commitb46d86c9ad10c6c5f7a8db16155f52e80999b7d3 (patch)
tree6fdf7f6804d7441d1d50f414589f28f3e581862d
parent8c5bd98c55bddb7709a958cc272983e61f953af3 (diff)
downloadserver-b46d86c9ad10c6c5f7a8db16155f52e80999b7d3.tar.gz
richard: Import Richard III.
-rw-r--r--tools/sql/data-richard.txt3
-rw-r--r--views/index.ejs1
2 files changed, 4 insertions, 0 deletions
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>