From: Reedy <reedy@wikimedia.org>
Date: Wed, 29 Nov 2017 20:11:19 +0000 (+0000)
Subject: Remove DEFAULT '' from postgres ip_changes.ipc_rev_timestamp
X-Git-Tag: 1.31.0-rc.0~1362^2
X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=commitdiff_plain;h=47c378bb68251e987777d1cc97feb857c26eee81

Remove DEFAULT '' from postgres ip_changes.ipc_rev_timestamp

Follows-up Ic11c64813ee04e8520771bfa156f8e51404273e7

Bug: T181672
Change-Id: I58fe5edb1e7656773271634f702ed044c6036497
---

diff --git a/maintenance/postgres/archives/patch-ip_changes.sql b/maintenance/postgres/archives/patch-ip_changes.sql
index 231ea1afd5..64cc0d71fe 100644
--- a/maintenance/postgres/archives/patch-ip_changes.sql
+++ b/maintenance/postgres/archives/patch-ip_changes.sql
@@ -2,7 +2,7 @@ CREATE SEQUENCE ip_changes_ipc_rev_id_seq;
 
 CREATE TABLE ip_changes (
   ipc_rev_id        INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('ip_changes_ipc_rev_id_seq'),
-  ipc_rev_timestamp TIMESTAMPTZ NOT NULL DEFAULT '',
+  ipc_rev_timestamp TIMESTAMPTZ NOT NULL,
   ipc_hex           BYTEA NOT NULL DEFAULT ''
 );