From 9c5830df0ac1e45b2957d8a984ebec742ed8d3fe Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard 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.3