liquid_feedback_core
changeset 461:4c3522ba2552
Changed reference to "member_id" in two tables to INT4 (was INT8)
author | jbe |
---|---|
date | Thu Mar 17 03:12:19 2016 +0100 (2016-03-17) |
parents | 6d4e51332251 |
children | e9525f069607 |
files | core.sql |
line diff
1.1 --- a/core.sql Wed Mar 16 00:29:12 2016 +0100 1.2 +++ b/core.sql Thu Mar 17 03:12:19 2016 +0100 1.3 @@ -219,7 +219,7 @@ 1.4 1.5 CREATE TABLE "rendered_member_statement" ( 1.6 PRIMARY KEY ("member_id", "format"), 1.7 - "member_id" INT8 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.8 + "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.9 "format" TEXT, 1.10 "content" TEXT NOT NULL ); 1.11 1.12 @@ -323,7 +323,7 @@ 1.13 "ident" TEXT PRIMARY KEY, 1.14 "additional_secret" TEXT, 1.15 "expiry" TIMESTAMPTZ NOT NULL DEFAULT now() + '24 hours', 1.16 - "member_id" INT8 REFERENCES "member" ("id") ON DELETE SET NULL, 1.17 + "member_id" INT4 REFERENCES "member" ("id") ON DELETE SET NULL, 1.18 "authority" TEXT, 1.19 "authority_uid" TEXT, 1.20 "authority_login" TEXT,