diff options
author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-03-03 08:54:02 +0100 |
---|---|---|
committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-03-03 08:54:02 +0100 |
commit | cab91f42d5b6d62a33380abc2b1a670e70c21e05 (patch) | |
tree | 060a2118a864a2185d7dea6e2ee0cf5c9beb4bdf | |
parent | 4853842b5f8ae85f6331f7361b6cc69d9390767a (diff) |
Schema: Fix PRIMARY KEY constraint on page_keys table.
-rw-r--r-- | schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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 ); |