[Pdns-users]

[Jeremy May]

That all looks right to me here is my tables i use

-- 
-- Table structure for table `domains`
-- 

CREATE TABLE domains (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  `master` varchar(20) default NULL,
  last_check int(11) default NULL,
  `type` varchar(6) NOT NULL default '',
  notified_serial int(11) default NULL,
  accountid int(15) default NULL,
  pool int(15) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY name_index (name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Power DNS Domains Table';

-- --------------------------------------------------------

-- 
-- Table structure for table `records`
-- 

CREATE TABLE records (
  id int(11) NOT NULL auto_increment,
  domain_id int(11) default NULL,
  name varchar(255) default NULL,
  `type` varchar(6) default NULL,
  content varchar(255) default NULL,
  ttl int(11) default NULL,
  prio int(11) default NULL,
  change_date int(11) default NULL,
  PRIMARY KEY  (id),
  KEY rec_name_index (name),
  KEY nametype_index (name,`type`),
  KEY domain_id (domain_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Power DNS Records Table';

now i have modified mine abit to allow for some other things to happen but
that is just me... what you have should work ...

-- Jeremy May
jeremy at rootservices.net
Root Services
http://www.rootservices.net



This communication is confidential and may be legally privileged. If you
are not the intended recipient, (i) please do not read or disclose
to others, (ii) please notify the sender by reply mail, and (iii) please
delete this communication from your system. Failure to follow this
process may be unlawful. Thank you for your cooperation.


-- Jeremy May
jeremy at rootservices.net
Root Services
Web hosting at an affordable price.
http://www.rootservices.net