[Pdns-users]

[Jeremy May]

i would say they look ok to me...

someone else may say differently but to me they look fine..

N. van Kooten said:
> Ok my tabels are ok?
>
> -----Oorspronkelijk bericht-----
> Van: Jeremy May [mailto:jeremy at rootservices.net]
> Verzonden: donderdag 26 januari 2006 18:04
> Aan: N. van Kooten
> Onderwerp: RE: [Pdns-users]
>
> 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
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.14.22/239 - Release Date: 24-1-2006
>
>
>

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