MySQL Schema #371

Closed
Habbie opened this Issue Apr 26, 2013 · 1 comment

Projects

None yet

1 participant

@Habbie
Member
Habbie commented Apr 26, 2013

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

@Habbie Habbie was assigned Apr 26, 2013
@Habbie Habbie closed this Apr 26, 2013
@Habbie
Member
Habbie commented Apr 26, 2013

Author: ahu
fixed in commit 2225, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment