Manual lines in DNS zone file

[Blondak]

Hi,
i've created fast patch for ISPCP to support "user" data in DNS zone file.
You need to create table

CREATE TABLE IF NOT EXISTS `domain_dns` (
`domain_dns_id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL,
`alias_id` int(11) default NULL,
`domain_dns` varchar(50) NOT NULL,
`domain_class` enum('IN','CH','HS') NOT NULL default 'IN',
`domain_type` enum('A','AAAA','CERT','CNAME','DNAME','GPOS','KEY','KX','MX','NAPTR','NSAP','NS​','NXT','PTR','PX','SIG','SRV','TXT') NOT NULL default 'A',
`domain_text` varchar(128) NOT NULL,
PRIMARY KEY (`domain_dns_id`)
);

ALTER TABLE `domain` ADD `domain_dns` VARCHAR( 15 ) NOT NULL DEFAULT 'no';

This is first version that don't have GUI, admin must be carefull when playing with this!
If you want create record for domain leave alias_id = NULL, and if you want create entry for domain alias you must enter booth domain_id and alias_id

(0, 1, 1, 'adsl', 'IN', 'A', 'xxx.xxx.xxx.xxx') => will add line "adsl IN A xxx.xxx.xxx.xxx" in zone file
(0, 1, 1, 'crm', 'IN', 'CNAME', 'dmz.domain.cz.') => will add line "crm IN CNAME dmz.domain.cz." in zone file
(0, 2, NULL, '_jabber._tcp 86400', 'IN', 'SRV', '5 0 5269 jabber.domain.cz.') => will add line "_jabber._tcp 86400 IN SRV 5 0 5269 jabber.domain.cz."

I have plans to make GUI with validate checking, but this i need, because some of my users needs extra data in DNS and when user update domain, they disappear.
Add config option "Manual DNS support" for Hosting plan and domain (for later use, not done yet)

PS:
sorry for my bad english and sorry for my perl skills i don't know it.