# HG changeset patch
# User jbe
# Date 1458180739 -3600
# Node ID 4c3522ba255220c522883e71f28e032809dd316a
# Parent  6d4e51332251e85788c8fc62266513627f63211b
Changed reference to "member_id" in two tables to INT4 (was INT8)

diff -r 6d4e51332251 -r 4c3522ba2552 core.sql
--- a/core.sql	Wed Mar 16 00:29:12 2016 +0100
+++ b/core.sql	Thu Mar 17 03:12:19 2016 +0100
@@ -219,7 +219,7 @@
 
 CREATE TABLE "rendered_member_statement" (
         PRIMARY KEY ("member_id", "format"),
-        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "format"                TEXT,
         "content"               TEXT            NOT NULL );
 
@@ -323,7 +323,7 @@
         "ident"                 TEXT            PRIMARY KEY,
         "additional_secret"     TEXT,
         "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
-        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
+        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE SET NULL,
         "authority"             TEXT,
         "authority_uid"         TEXT,
         "authority_login"       TEXT,