From d9627abe3775c203fdb85d6e4ada4e17d16042c2 Mon Sep 17 00:00:00 2001 From: Aki Tuomi Date: Tue, 9 Dec 2014 11:40:57 +0200 Subject: [PATCH] Sync schema with mydns-ng --- modules/mydnsbackend/schema.mydns.sql | 19 ++++++++++--------- 1 file changed, 10 insertions(+), 9 deletions(-) diff --git a/modules/mydnsbackend/schema.mydns.sql b/modules/mydnsbackend/schema.mydns.sql index f503b35548..0e6d403b89 100644 --- a/modules/mydnsbackend/schema.mydns.sql +++ b/modules/mydnsbackend/schema.mydns.sql @@ -1,6 +1,6 @@ -- --- Table layouts for mydns 1.1.0 (Mar 2012) --- Copyright (C) 2002-2005 Don Moore +-- Table layouts for mydns 1.2.8.31 (Dec 2014) +-- Copyright (C) 2002-2005 Don Moore 2007-2008 Howard Wilkinson -- -- You might create these tables with a command like: -- @@ -22,8 +22,9 @@ CREATE TABLE IF NOT EXISTS soa ( expire INT UNSIGNED NOT NULL default '604800', minimum INT UNSIGNED NOT NULL default '86400', ttl INT UNSIGNED NOT NULL default '86400', + active ENUM('Y', 'N') NOT NULL DEFAULT 'Y', UNIQUE KEY (origin) -); +) Engine=MyISAM; -- -- Table structure for table 'rr' (resource records) @@ -31,11 +32,11 @@ CREATE TABLE IF NOT EXISTS soa ( CREATE TABLE IF NOT EXISTS rr ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, zone INT UNSIGNED NOT NULL, - name CHAR(64) NOT NULL, - type ENUM('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT'), - data CHAR(128) NOT NULL, + name CHAR(200) NOT NULL, + data VARBINARY(128) NOT NULL, aux INT UNSIGNED NOT NULL, ttl INT UNSIGNED NOT NULL default '86400', - UNIQUE KEY rr (zone,name,type,data,aux) -); - + type ENUM('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT'), + active ENUM('Y', 'N') NOT NULL DEFAULT 'Y', + UNIQUE KEY rr (zone,name,type,data,active) +) Engine=MyISAM; -- 2.47.2