From 30515c14a029c140a82729962b06eecac1745f11 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Wed, 29 Feb 2012 22:45:24 +0100
Subject: Book Marx: Implement support for page-specific authentication tokens.

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

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index c94ffcf..2bd308d 100644
--- a/schema.sql
+++ b/schema.sql
@@ -21,6 +21,14 @@ CREATE TABLE openids(
   FOREIGN KEY("user") REFERENCES users
 );
 
+CREATE TABLE page_keys(
+  "user" INTEGER NOT NULL,
+  page   VARCHAR NOT NULL,
+  "key"  DECIMAL NOT NULL,   -- (~ NUMERIC DECIMAL)
+  PRIMARY KEY("user", page, "key"),
+  FOREIGN KEY("user") REFERENCES users
+);
+
 CREATE TABLE wiki_pages(
   id           SERIAL    NOT NULL,
   PRIMARY KEY(id)
-- 
cgit v1.2.3

