From 3336bc430f5a28afe37b9ce74a6f6ea86df48f66 Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Mon, 16 Jun 2014 18:46:10 +0200 Subject: [PATCH] remove unnecessary tsigkeys table alteration --- modules/gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql | 1 - modules/gpgsqlbackend/nodnssec-3.x_to_3.4_schema.pgsql.sql | 1 - 2 files changed, 2 deletions(-) diff --git a/modules/gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql b/modules/gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql index c5ce27f0b4..2a916f51f6 100644 --- a/modules/gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql +++ b/modules/gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql @@ -8,7 +8,6 @@ ALTER TABLE records ADD auth TINYINT(1) DEFAULT 1; ALTER TABLE records MODIFY type VARCHAR(10); ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); -ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50); CREATE INDEX recordorder ON records (domain_id, ordername); diff --git a/modules/gpgsqlbackend/nodnssec-3.x_to_3.4_schema.pgsql.sql b/modules/gpgsqlbackend/nodnssec-3.x_to_3.4_schema.pgsql.sql index d8571e9582..d8b7bbf319 100644 --- a/modules/gpgsqlbackend/nodnssec-3.x_to_3.4_schema.pgsql.sql +++ b/modules/gpgsqlbackend/nodnssec-3.x_to_3.4_schema.pgsql.sql @@ -8,7 +8,6 @@ ALTER TABLE records ADD auth BOOL DEFAULT 't'; ALTER TABLE records ALTER COLUMN type TYPE VARCHAR(10); ALTER TABLE supermasters ALTER COLUMN ip TYPE INET USING ip::INET; ALTER TABLE supermasters ADD CONSTRAINT supermasters_pkey PRIMARY KEY (ip, nameserver); -ALTER TABLE tsigkeys ALTER COLUMN algorithm TYPE VARCHAR(50); CREATE INDEX recordorder ON records (domain_id, ordername text_pattern_ops); -- 2.47.2