[Pdns-users] MySQL docs bug?

[Michael Fincham]

Aha yes, the documentation should probably mention that the constraint
needs to be appended to an alter or create!

On Wed, 2010-06-02 at 23:37 +1200, Michael wrote:
> On Wed, 02 Jun 2010 23:33:19 you wrote:
> > Hi Michael,
> >
> > On Wed, 2010-06-02 at 20:10 +1200, Michael wrote:
> > > The following does not work:
> > >
> > > CONSTRAINT `records_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES
> > > `domains` (`id`) ON DELETE CASCADE
> > > http://docs.powerdns.com/generic-mypgsql-backends.html
> >
> > Are you using an InnoDB or MyISAM table? MyISAM is the default on some
> > (all?) MySQL installations and doesn't support constraints like this.
> 
> InnoDB. I have found the answer - it needs an 'ALTER... something (can't 
> recall what it was) prefixed.
-- 
-Michael Fincham
System Administrator, Unleash
www.unleash.co.nz
Phone: 0800 750 250
DDI: 03 978 1223
Mobile: 027 666 4482