From 5f0988efb1d2cfb997d842682a45f342aeb7a91e Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Thu, 26 Mar 2020 22:16:30 +0100 Subject: [PATCH] auth: remove beta2 schema files --- .../4.3.0-beta2_to_4.3.0_schema.mysql.sql | 1 - .../4.3.0-beta2_to_4.3.0_schema.pgsql.sql | 6 ------ .../4.3.0-beta2_to_4.3.0_schema.sqlite3.sql | 17 ----------------- ...ssec.4.3.0-beta2_to_4.3.0_schema.sqlite3.sql | 16 ---------------- 4 files changed, 40 deletions(-) delete mode 100644 modules/gmysqlbackend/4.3.0-beta2_to_4.3.0_schema.mysql.sql delete mode 100644 modules/gpgsqlbackend/4.3.0-beta2_to_4.3.0_schema.pgsql.sql delete mode 100644 modules/gsqlite3backend/4.3.0-beta2_to_4.3.0_schema.sqlite3.sql delete mode 100644 pdns/bind-dnssec.4.3.0-beta2_to_4.3.0_schema.sqlite3.sql diff --git a/modules/gmysqlbackend/4.3.0-beta2_to_4.3.0_schema.mysql.sql b/modules/gmysqlbackend/4.3.0-beta2_to_4.3.0_schema.mysql.sql deleted file mode 100644 index f84482254d..0000000000 --- a/modules/gmysqlbackend/4.3.0-beta2_to_4.3.0_schema.mysql.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE cryptokeys MODIFY published BOOL NULL DEFAULT 1 AFTER active; diff --git a/modules/gpgsqlbackend/4.3.0-beta2_to_4.3.0_schema.pgsql.sql b/modules/gpgsqlbackend/4.3.0-beta2_to_4.3.0_schema.pgsql.sql deleted file mode 100644 index 15228678ef..0000000000 --- a/modules/gpgsqlbackend/4.3.0-beta2_to_4.3.0_schema.pgsql.sql +++ /dev/null @@ -1,6 +0,0 @@ -BEGIN; - ALTER TABLE cryptokeys ADD COLUMN content_new TEXT; - UPDATE cryptokeys SET content_new = content; - ALTER TABLE cryptokeys DROP COLUMN content; - ALTER TABLE cryptokeys RENAME COLUMN content_new TO content; -COMMIT; diff --git a/modules/gsqlite3backend/4.3.0-beta2_to_4.3.0_schema.sqlite3.sql b/modules/gsqlite3backend/4.3.0-beta2_to_4.3.0_schema.sqlite3.sql deleted file mode 100644 index 693b4ea9f6..0000000000 --- a/modules/gsqlite3backend/4.3.0-beta2_to_4.3.0_schema.sqlite3.sql +++ /dev/null @@ -1,17 +0,0 @@ -BEGIN TRANSACTION; - CREATE TABLE cryptokeys_temp ( - id INTEGER PRIMARY KEY, - domain_id INT NOT NULL, - flags INT NOT NULL, - active BOOL, - published BOOL DEFAULT 1, - content TEXT, - FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE - ); - - INSERT INTO cryptokeys_temp SELECT id,domain_id,flags,active,published,content FROM cryptokeys; - DROP TABLE cryptokeys; - ALTER TABLE cryptokeys_temp RENAME TO cryptokeys; - - CREATE INDEX domainidindex ON cryptokeys(domain_id); -COMMIT; diff --git a/pdns/bind-dnssec.4.3.0-beta2_to_4.3.0_schema.sqlite3.sql b/pdns/bind-dnssec.4.3.0-beta2_to_4.3.0_schema.sqlite3.sql deleted file mode 100644 index ddd5d0500c..0000000000 --- a/pdns/bind-dnssec.4.3.0-beta2_to_4.3.0_schema.sqlite3.sql +++ /dev/null @@ -1,16 +0,0 @@ -BEGIN TRANSACTION; - CREATE TABLE cryptokeys_temp ( - id INTEGER PRIMARY KEY, - domain VARCHAR(255) COLLATE NOCASE, - flags INT NOT NULL, - active BOOL, - published BOOL DEFAULT 1, - content TEXT - ); - - INSERT INTO cryptokeys_temp SELECT id,domain,flags,active,published,content FROM cryptokeys; - DROP TABLE cryptokeys; - ALTER TABLE cryptokeys_temp RENAME TO cryptokeys; - - CREATE INDEX domainnameindex ON cryptokeys(domain); -COMMIT; -- 2.47.2