From b2f3d1b699154e61c5b3c9e962c995cbee0dbe91 Mon Sep 17 00:00:00 2001 From: Peter van Dijk Date: Tue, 30 Jul 2019 15:44:07 +0200 Subject: [PATCH] adjust gpgsql schema for advisory 2019-06 --- modules/gpgsqlbackend/4.0.8_to_4.0.9.schema.pgsql.sql | 1 + modules/gpgsqlbackend/schema.pgsql.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 modules/gpgsqlbackend/4.0.8_to_4.0.9.schema.pgsql.sql diff --git a/modules/gpgsqlbackend/4.0.8_to_4.0.9.schema.pgsql.sql b/modules/gpgsqlbackend/4.0.8_to_4.0.9.schema.pgsql.sql new file mode 100644 index 000000000..b0c2ee1ef --- /dev/null +++ b/modules/gpgsqlbackend/4.0.8_to_4.0.9.schema.pgsql.sql @@ -0,0 +1 @@ +ALTER TABLE domains ALTER notified_serial TYPE bigint USING CASE WHEN notified_serial >= 0 THEN notified_serial::bigint END; diff --git a/modules/gpgsqlbackend/schema.pgsql.sql b/modules/gpgsqlbackend/schema.pgsql.sql index e14395b3d..ddc68f8d2 100644 --- a/modules/gpgsqlbackend/schema.pgsql.sql +++ b/modules/gpgsqlbackend/schema.pgsql.sql @@ -4,7 +4,7 @@ CREATE TABLE domains ( master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, type VARCHAR(6) NOT NULL, - notified_serial INT DEFAULT NULL, + notified_serial BIGINT DEFAULT NULL, account VARCHAR(40) DEFAULT NULL, CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))) ); -- 2.49.0