From 67db1cd3f0e97e00c2e789b3ef4c039290fe2646 Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Mon, 27 Jun 2022 13:16:22 +0200 Subject: [PATCH] auth: extend type length to 8 characters (PRODUCER / CONSUMER) --- modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql | 1 + modules/gmysqlbackend/schema.mysql.sql | 2 +- modules/godbcbackend/4.3.0_to_4.7.0_schema.mssql.sql | 1 + modules/godbcbackend/schema.mssql.sql | 2 +- modules/gpgsqlbackend/4.3.0_to_4.7.0_schema.pgsql.sql | 2 ++ modules/gpgsqlbackend/schema.pgsql.sql | 2 +- modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql | 2 +- modules/gsqlite3backend/schema.sqlite3.sql | 2 +- 8 files changed, 9 insertions(+), 5 deletions(-) diff --git a/modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql b/modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql index bb0956d0b7..e71a0eb9ef 100644 --- a/modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql +++ b/modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql @@ -1,4 +1,5 @@ ALTER TABLE domains ADD options VARCHAR(64000) DEFAULT NULL AFTER notified_serial; ALTER TABLE domains ADD catalog VARCHAR(255) DEFAULT NULL AFTER options; +ALTER TABLE domains MODIFY type VARCHAR(8) NOT NULL; CREATE INDEX catalog_idx ON domains(catalog); diff --git a/modules/gmysqlbackend/schema.mysql.sql b/modules/gmysqlbackend/schema.mysql.sql index 554786aee1..a58c81d43f 100644 --- a/modules/gmysqlbackend/schema.mysql.sql +++ b/modules/gmysqlbackend/schema.mysql.sql @@ -3,7 +3,7 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL, master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, - type VARCHAR(6) NOT NULL, + type VARCHAR(8) NOT NULL, notified_serial INT UNSIGNED DEFAULT NULL, options VARCHAR(64000) DEFAULT NULL, catalog VARCHAR(255) DEFAULT NULL, diff --git a/modules/godbcbackend/4.3.0_to_4.7.0_schema.mssql.sql b/modules/godbcbackend/4.3.0_to_4.7.0_schema.mssql.sql index b874edf348..c0cd3d579c 100644 --- a/modules/godbcbackend/4.3.0_to_4.7.0_schema.mssql.sql +++ b/modules/godbcbackend/4.3.0_to_4.7.0_schema.mssql.sql @@ -1,4 +1,5 @@ ALTER TABLE domains ADD COLUMN options VARCHAR(MAX) DEFAULT NULL; ALTER TABLE domains ADD COLUMN catalog VARCHAR(255) DEFAULT NULL; +ALTER TABLE domains ALTER COLUMN type VARCHAR(8) NOT NULL; CREATE INDEX catalog_idx ON domains(catalog); diff --git a/modules/godbcbackend/schema.mssql.sql b/modules/godbcbackend/schema.mssql.sql index 14e4212370..8f5d55d9e1 100644 --- a/modules/godbcbackend/schema.mssql.sql +++ b/modules/godbcbackend/schema.mssql.sql @@ -3,7 +3,7 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL, master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, - type VARCHAR(6) NOT NULL, + type VARCHAR(8) NOT NULL, notified_serial INT DEFAULT NULL, options VARCHAR(MAX) DEFAULT NULL, catalog VARCHAR(255) DEFAULT NULL, diff --git a/modules/gpgsqlbackend/4.3.0_to_4.7.0_schema.pgsql.sql b/modules/gpgsqlbackend/4.3.0_to_4.7.0_schema.pgsql.sql index 420ec1d79a..bb9a07a5fc 100644 --- a/modules/gpgsqlbackend/4.3.0_to_4.7.0_schema.pgsql.sql +++ b/modules/gpgsqlbackend/4.3.0_to_4.7.0_schema.pgsql.sql @@ -7,5 +7,7 @@ BEGIN; ALTER TABLE domains DROP COLUMN account; ALTER TABLE domains RENAME COLUMN account_new TO account; + ALTER TABLE domains ALTER type VARCHAR(8) NOT NULL; + CREATE INDEX catalog_idx ON domains(catalog); COMMIT; diff --git a/modules/gpgsqlbackend/schema.pgsql.sql b/modules/gpgsqlbackend/schema.pgsql.sql index 535328998b..4f1489c5b6 100644 --- a/modules/gpgsqlbackend/schema.pgsql.sql +++ b/modules/gpgsqlbackend/schema.pgsql.sql @@ -3,7 +3,7 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL, master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, - type VARCHAR(6) NOT NULL, + type VARCHAR(8) NOT NULL, notified_serial BIGINT DEFAULT NULL, options VARCHAR(65535) DEFAULT NULL, catalog VARCHAR(255) DEFAULT NULL, diff --git a/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql b/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql index b48071ff55..a71c3e482d 100644 --- a/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql @@ -6,7 +6,7 @@ BEGIN TRANSACTION; name VARCHAR(255) NOT NULL COLLATE NOCASE, master VARCHAR(128) DEFAULT NULL, last_check INTEGER DEFAULT NULL, - type VARCHAR(6) NOT NULL, + type VARCHAR(8) NOT NULL, notified_serial INTEGER DEFAULT NULL, options VARCHAR(65535) DEFAULT NULL, catalog VARCHAR(255) DEFAULT NULL, diff --git a/modules/gsqlite3backend/schema.sqlite3.sql b/modules/gsqlite3backend/schema.sqlite3.sql index d1663b28a9..0f2c94b53d 100644 --- a/modules/gsqlite3backend/schema.sqlite3.sql +++ b/modules/gsqlite3backend/schema.sqlite3.sql @@ -5,7 +5,7 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL COLLATE NOCASE, master VARCHAR(128) DEFAULT NULL, last_check INTEGER DEFAULT NULL, - type VARCHAR(6) NOT NULL, + type VARCHAR(8) NOT NULL, options VARCHAR(65535) DEFAULT NULL, catalog VARCHAR(255) DEFAULT NULL, notified_serial INTEGER DEFAULT NULL, -- 2.47.2