From 9c5830df0ac1e45b2957d8a984ebec742ed8d3fe Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Tue, 15 Mar 2011 19:45:19 +0100
Subject: Add a database-backed page caching mechanism.

---
 schema.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'schema.sql')

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 (
-- 
cgit v1.2.1

