From 7fe9f694d655b13dafd2417cfad02992a8ac2d57 Mon Sep 17 00:00:00 2001 From: Peter van Dijk Date: Tue, 23 Aug 2022 16:21:36 +0200 Subject: [PATCH] use TEXT consistently between pg schema and migration --- modules/gpgsqlbackend/schema.pgsql.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/modules/gpgsqlbackend/schema.pgsql.sql b/modules/gpgsqlbackend/schema.pgsql.sql index 9a2011213d..10f542c9f3 100644 --- a/modules/gpgsqlbackend/schema.pgsql.sql +++ b/modules/gpgsqlbackend/schema.pgsql.sql @@ -3,11 +3,11 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL, master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, - type VARCHAR(8) NOT NULL, + type TEXT NOT NULL, notified_serial BIGINT DEFAULT NULL, account VARCHAR(40) DEFAULT NULL, - options VARCHAR(65535) DEFAULT NULL, - catalog VARCHAR(255) DEFAULT NULL, + options TEXT DEFAULT NULL, + catalog TEXT DEFAULT NULL, CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))) ); -- 2.47.2