From 92585308f0b2e58b4844b05011cc6dc45905a8d8 Mon Sep 17 00:00:00 2001 From: Arsen Stasic Date: Mon, 12 Jun 2017 14:01:30 +0200 Subject: [PATCH] altered postgres schema to match mysql schema mysql uses BIGINT for records id field, with this patch postgres is going to use BIGINT (BIGSERIAL) too --- modules/gpgsqlbackend/schema.pgsql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/gpgsqlbackend/schema.pgsql.sql b/modules/gpgsqlbackend/schema.pgsql.sql index e14395b3d3..b105d87951 100644 --- a/modules/gpgsqlbackend/schema.pgsql.sql +++ b/modules/gpgsqlbackend/schema.pgsql.sql @@ -13,7 +13,7 @@ CREATE UNIQUE INDEX name_index ON domains(name); CREATE TABLE records ( - id SERIAL PRIMARY KEY, + id BIGSERIAL PRIMARY KEY, domain_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(10) DEFAULT NULL, -- 2.47.2