From c4c4085705c25216050f4785d3191e3a72ed6a85 Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Fri, 3 Jan 2014 12:34:44 +0100 Subject: [PATCH] oracle backend schema/dropschema update --- modules/oraclebackend/dropschema.sql | 2 +- modules/oraclebackend/schema.sql | 7 +++++-- 2 files changed, 6 insertions(+), 3 deletions(-) diff --git a/modules/oraclebackend/dropschema.sql b/modules/oraclebackend/dropschema.sql index 10ec5d2209..1e4997f417 100644 --- a/modules/oraclebackend/dropschema.sql +++ b/modules/oraclebackend/dropschema.sql @@ -16,7 +16,7 @@ DROP TABLE ZoneMetadata; DROP TABLE Supermasters; DROP SEQUENCE supermasters_id_seq; DROP TABLE Zonemasters; -DROP TABLE ZoneAlsoNotifyHosts; +DROP TABLE ZoneAlsoNotify; DROP TABLE Zones; DROP SEQUENCE zones_id_seq; diff --git a/modules/oraclebackend/schema.sql b/modules/oraclebackend/schema.sql index 7a1005f4e5..de29fe0a00 100644 --- a/modules/oraclebackend/schema.sql +++ b/modules/oraclebackend/schema.sql @@ -84,9 +84,12 @@ CREATE INDEX zonednskeys_zone_ind ON ZoneDNSKeys (zone_id); CREATE TABLE TSIGKeys ( - name VARCHAR2(256) CONSTRAINT pkey_tsigkeys PRIMARY KEY, + name VARCHAR2(256), algorithm VARCHAR2(64) NOT NULL, - secret VARCHAR2(2048) NOT NULL + secret VARCHAR2(2048) NOT NULL, + CONSTRAINT chk_tsigkeys_name CHECK (name = lower(name)), + CONSTRAINT chk_tsigkeys_algorithm CHECK (algorithm = lower(algorithm)), + CONSTRAINT unq_tsigkeys_nav UNIQUE (name, algorithm, secret) ); -- 2.47.2