Book Marx: Implement support for page-specific authentication tokens.

1 files changed, 8 insertions, 0 deletions

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)