MySQL Schema

[anon]

Mysql schema update ( http://wiki.powerdns.com/trac/browser/trunk/pdns/pdns/dnssec.schema.mysql.sql)

For the table cryptokeys the column domain_id should be " domain_id INT NOT NULL," instead of "DEFAULT NULL", so we can put a foreign key in place.

In the create table of domainmetadata, cryptokeys should also be a

--

FOREIGN KEY (domain_id) REFERENCES domains(id) ON DELETE CASCADE

--

Kind regards, Gerald Gruenberger

[ahu]

fixed in commit 2225, thanks!