From 7d9af26046bed38e1846b49adfc16294db64d325 Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Tue, 11 Mar 2014 21:35:53 +0100 Subject: [PATCH] fix gmysql upgrade schema --- .../gmysqlbackend/nodnssec-3.x_to_3.4_schema.mysql.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 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 a34aca990d..5852d9d3a8 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 @@ -1,7 +1,9 @@ -ALTER TABLE records ADD disabled TINYINT(1) DEFAULT 0, -ALTER TABLE records ADD ordername VARCHAR(255) BINARY DEFAULT NULL, -ALTER TABLE records ADD auth TINYINT(1) DEFAULT 1, +ALTER TABLE domains CHANGE COLUMN type TYPE VARCHAR(6); +ALTER TABLE records ADD disabled TINYINT(1) DEFAULT 0; +ALTER TABLE records ADD ordername VARCHAR(255) BINARY DEFAULT NULL; +ALTER TABLE records ADD auth TINYINT(1) DEFAULT 1; ALTER TABLE records CHANGE COLUMN type TYPE VARCHAR(10); +ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); CREATE INDEX recordorder ON records (domain_id, ordername); -- 2.47.2