From 438b9f686390d0a1a1787788516bf18dfb0fae40 Mon Sep 17 00:00:00 2001 From: Stricted Date: Sat, 6 Jun 2015 23:54:21 +0200 Subject: [PATCH] change database structure --- database.sql | 5 +++-- lib/api/page/IndexPage.class.php | 2 +- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/database.sql b/database.sql index 5a80033..8682278 100644 --- a/database.sql +++ b/database.sql @@ -17,12 +17,13 @@ CREATE TABLE IF NOT EXISTS dns_rr ( id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, zone INT(10) NOT NULL, name VARCHAR(255) NOT NULL, - data VARCHAR(255) NOT NULL, + --- data VARCHAR(255) NOT NULL, + data TEXT, aux INT(10) NOT NULL, ttl INT(10) NOT NULL DEFAULT '86400', type enum('A', 'AAAA', 'CNAME', 'MX', 'PTR', 'SRV', 'TXT', 'TLSA', 'NS', 'DS') DEFAULT NULL, active boolean NOT NULL DEFAULT 1, - UNIQUE KEY dns_rr (zone, name, type, data) + --- UNIQUE KEY dns_rr (zone, name, type, data) ) ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS dns_sec ( diff --git a/lib/api/page/IndexPage.class.php b/lib/api/page/IndexPage.class.php index 4578f81..7f2d544 100644 --- a/lib/api/page/IndexPage.class.php +++ b/lib/api/page/IndexPage.class.php @@ -12,4 +12,4 @@ class IndexPage extends AbstractPage { /* we have no index page */ exit; } -} \ No newline at end of file +} -- 2.20.1