From 3cc6261cf370de0f3d14a722faffce0f04e1badf Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Sat, 8 Apr 2017 01:30:39 +0200 Subject: [PATCH] gmysql-backend: use a bigint for records.id --- modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql | 1 + modules/gmysqlbackend/Makefile.am | 1 + modules/gmysqlbackend/schema.mysql.sql | 2 +- 3 files changed, 3 insertions(+), 1 deletion(-) create mode 100644 modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql diff --git a/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql b/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql new file mode 100644 index 0000000000..a0987aac5a --- /dev/null +++ b/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql @@ -0,0 +1 @@ +ALTER TABLE records MODIFY id BIGINT AUTO_INCREMENT; diff --git a/modules/gmysqlbackend/Makefile.am b/modules/gmysqlbackend/Makefile.am index bf20160531..43c09c9042 100644 --- a/modules/gmysqlbackend/Makefile.am +++ b/modules/gmysqlbackend/Makefile.am @@ -12,6 +12,7 @@ EXTRA_DIST = \ dist_doc_DATA = \ dnssec-3.x_to_3.4.0_schema.mysql.sql \ nodnssec-3.x_to_3.4.0_schema.mysql.sql \ + 3.4.0_to_4.1.0_schema.mysql.sql \ schema.mysql.sql libgmysqlbackend_la_SOURCES = \ diff --git a/modules/gmysqlbackend/schema.mysql.sql b/modules/gmysqlbackend/schema.mysql.sql index 002fe928cc..7437f3f6e6 100644 --- a/modules/gmysqlbackend/schema.mysql.sql +++ b/modules/gmysqlbackend/schema.mysql.sql @@ -13,7 +13,7 @@ CREATE UNIQUE INDEX name_index ON domains(name); CREATE TABLE records ( - id INT AUTO_INCREMENT, + id BIGINT AUTO_INCREMENT, domain_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(10) DEFAULT NULL, -- 2.47.2