From a92edd1493c9c96a5efd2898c58a4b26faba241f Mon Sep 17 00:00:00 2001 From: Aki Tuomi Date: Mon, 9 Dec 2013 22:40:07 +0200 Subject: [PATCH] Add primary key to schemas --- modules/gmysqlbackend/no-dnssec.schema.mysql.sql | 3 ++- modules/goraclebackend/goracle-schema.sql | 3 ++- modules/gpgsqlbackend/no-dnssec.schema.pgsql.sql | 3 ++- modules/gsqlite3backend/no-dnssec.schema.sqlite3.sql | 2 ++ 4 files changed, 8 insertions(+), 3 deletions(-) diff --git a/modules/gmysqlbackend/no-dnssec.schema.mysql.sql b/modules/gmysqlbackend/no-dnssec.schema.mysql.sql index 86dfcfb3f3..acb31503be 100644 --- a/modules/gmysqlbackend/no-dnssec.schema.mysql.sql +++ b/modules/gmysqlbackend/no-dnssec.schema.mysql.sql @@ -29,5 +29,6 @@ CREATE INDEX domain_id ON records(domain_id); create table supermasters ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL, - account VARCHAR(40) DEFAULT NULL + account VARCHAR(40) DEFAULT NULL, + PRIMARY KEY (ip, nameserver) ) Engine=InnoDB; diff --git a/modules/goraclebackend/goracle-schema.sql b/modules/goraclebackend/goracle-schema.sql index 030c50bb0d..4d04c9dbb6 100644 --- a/modules/goraclebackend/goracle-schema.sql +++ b/modules/goraclebackend/goracle-schema.sql @@ -32,7 +32,8 @@ create sequence RECORDS_ID_SEQUENCE; create table supermasters ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL, - account VARCHAR(40) DEFAULT NULL + account VARCHAR(40) DEFAULT NULL, + PRIMARY KEY(ip, nameserver) ); create table domainmetadata ( diff --git a/modules/gpgsqlbackend/no-dnssec.schema.pgsql.sql b/modules/gpgsqlbackend/no-dnssec.schema.pgsql.sql index 319b015ba8..02c1e76339 100644 --- a/modules/gpgsqlbackend/no-dnssec.schema.pgsql.sql +++ b/modules/gpgsqlbackend/no-dnssec.schema.pgsql.sql @@ -32,7 +32,8 @@ CREATE INDEX domain_id ON records(domain_id); create table supermasters ( ip INET NOT NULL, nameserver VARCHAR(255) NOT NULL, - account VARCHAR(40) DEFAULT NULL + account VARCHAR(40) DEFAULT NULL, + PRIMARY KEY (ip, nameserver) ); -- GRANT SELECT ON supermasters TO pdns; diff --git a/modules/gsqlite3backend/no-dnssec.schema.sqlite3.sql b/modules/gsqlite3backend/no-dnssec.schema.sqlite3.sql index 7aa79122f1..6a77719878 100644 --- a/modules/gsqlite3backend/no-dnssec.schema.sqlite3.sql +++ b/modules/gsqlite3backend/no-dnssec.schema.sqlite3.sql @@ -30,3 +30,5 @@ create table supermasters ( nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, account VARCHAR(40) DEFAULT NULL ); + +CREATE UNIQUE INDEX ip_nameserver_pk ON supermasters(ip, nameserver); -- 2.47.3