diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 8 |
1 files changed, 8 insertions, 0 deletions
@@ -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) |