From cab91f42d5b6d62a33380abc2b1a670e70c21e05 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Sat, 3 Mar 2012 08:54:02 +0100
Subject: Schema: Fix PRIMARY KEY constraint on page_keys table.

---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 2bd308d..a12d549 100644
--- a/schema.sql
+++ b/schema.sql
@@ -25,7 +25,7 @@ CREATE TABLE page_keys(
   "user" INTEGER NOT NULL,
   page   VARCHAR NOT NULL,
   "key"  DECIMAL NOT NULL,   -- (~ NUMERIC DECIMAL)
-  PRIMARY KEY("user", page, "key"),
+  PRIMARY KEY(page, "key"),
   FOREIGN KEY("user") REFERENCES users
 );
 
-- 
cgit v1.2.3