From cab91f42d5b6d62a33380abc2b1a670e70c21e05 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard 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(-) 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