1 files changed, 18 insertions, 0 deletions
diff --git a/scripts/mk_sqlite_schema.sh b/scripts/mk_sqlite_schema.sh
new file mode 100755
index 0000000..7995af7
--- /dev/null
+++ b/scripts/mk_sqlite_schema.sh
@@ -0,0 +1,18 @@
+#! /usr/bin/env sh
+
+set -e
+
+root="$(dirname "$0")/.."
+db="${DATABASE_URL#sqlite://}"
+schema_file="$root/target/schema.dot"
+schema_svg="$root/target/schema.svg"
+
+mkdb.sh
+
+sqlite3 "$db" -init "$root/scripts/sqlite-schema-diagram.sql" "" > "$schema_file"
+dot -Tsvg "$schema_file" > "$schema_svg"
+
+imv "$schema_svg"
+
+
+# vim: ft=sh