X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=blobdiff_plain;f=maintenance%2Fpostgres%2Farchives%2Fpatch-ip_changes.sql;h=64cc0d71fed0d4212e15665f2d9120c8029684f1;hp=231ea1afd55bb08ac03b7ab0ef29b09c9df1c924;hb=47c378bb68251e987777d1cc97feb857c26eee81;hpb=db51412f816f2f9c81636da8994db92cce1ca213 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 '' );