Add a database-backed page caching mechanism.

1 files changed, 8 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index 1efe049..35bf0b5 100644
--- a/schema.sql
+++ b/schema.sql
@@ -172,6 +172,14 @@ CREATE TABLE used_transaction_keys(
 );
 CREATE SEQUENCE transaction_key_seq;
 
+CREATE TABLE cached_pages(
+  alias               VARCHAR   NOT NULL,
+  characteristic_hash INTEGER   NOT NULL,
+  date                TIMESTAMP NOT NULL DEFAULT now(),
+  content             VARCHAR   NOT NULL,
+  PRIMARY KEY(alias, characteristic_hash)
+);
+
 ----
 
 CREATE TYPE characteristic AS (