Remove DEFAULT '' from postgres ip_changes.ipc_rev_timestamp
authorReedy <reedy@wikimedia.org>
Wed, 29 Nov 2017 20:11:19 +0000 (20:11 +0000)
committerReedy <reedy@wikimedia.org>
Wed, 29 Nov 2017 20:11:19 +0000 (20:11 +0000)
Follows-up Ic11c64813ee04e8520771bfa156f8e51404273e7

Bug: T181672
Change-Id: I58fe5edb1e7656773271634f702ed044c6036497

maintenance/postgres/archives/patch-ip_changes.sql

index 231ea1a..64cc0d7 100644 (file)
@@ -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 ''
 );