From 4f4b91f5d030756f4b50634cdd978c97dd16bb8d Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Sat, 11 Aug 2007 08:42:22 -0400
Subject: [PATCH] Improved the DNS manager.
---
install/sql/ispconfig3.sql | 19 +++++++------------
1 files changed, 7 insertions(+), 12 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 1c5ad5c..61f7cd3 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -77,20 +77,17 @@
`sys_perm_user` varchar(5) NOT NULL,
`sys_perm_group` varchar(5) NOT NULL,
`sys_perm_other` varchar(5) NOT NULL,
+ `server_id` int(11) NOT NULL default '1',
`zone` int(10) unsigned NOT NULL,
`name` char(64) NOT NULL,
- `type` enum('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
+ `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
`data` char(128) NOT NULL,
- `aux` int(10) unsigned NOT NULL,
+ `aux` int(10) unsigned NOT NULL default '0',
`ttl` int(10) unsigned NOT NULL default '86400',
+ `active` enum('N','Y') NOT NULL default 'Y',
PRIMARY KEY (`id`),
UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
---
--- Daten f�r Tabelle `dns_rr`
---
-
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -105,6 +102,7 @@
`sys_perm_user` varchar(5) NOT NULL,
`sys_perm_group` varchar(5) NOT NULL,
`sys_perm_other` varchar(5) NOT NULL,
+ `server_id` int(11) NOT NULL default '1',
`origin` char(255) NOT NULL,
`ns` char(255) NOT NULL,
`mbox` char(255) NOT NULL,
@@ -119,11 +117,8 @@
PRIMARY KEY (`id`),
UNIQUE KEY `origin` (`origin`),
KEY `active` (`active`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
---
--- Daten f�r Tabelle `dns_soa`
---
-- --------------------------------------------------------
--
Gitblit v1.9.1