summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-03-03 08:54:02 +0100
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-03-03 08:54:02 +0100
commitcab91f42d5b6d62a33380abc2b1a670e70c21e05 (patch)
tree060a2118a864a2185d7dea6e2ee0cf5c9beb4bdf
parent4853842b5f8ae85f6331f7361b6cc69d9390767a (diff)
Schema: Fix PRIMARY KEY constraint on page_keys table.
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
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
);