diff options
| author | Pav Lucistnik <pav@FreeBSD.org> | 2007-03-22 22:09:51 +0000 |
|---|---|---|
| committer | Pav Lucistnik <pav@FreeBSD.org> | 2007-03-22 22:09:51 +0000 |
| commit | 7385687c01d573d6bea118b4a4c80ca5ec8e3022 (patch) | |
| tree | 53a90678e2bcac7620e35fb302e0ded229ff7e90 /dns/powerdns-devel | |
| parent | 54e56216c9bf39220e810030b8a136870ce317d0 (diff) | |
| download | ports-7385687c01d573d6bea118b4a4c80ca5ec8e3022.tar.gz ports-7385687c01d573d6bea118b4a4c80ca5ec8e3022.zip | |
- Fix PostgreSQL schema
PR: ports/110546
Submitted by: Anish Mistry <amistry@am-productions.biz>
Approved by: Ralf van der Enden <Ralf.vdEnden@wldelft.nl> (maintainer)
Notes
Notes:
svn path=/head/; revision=188061
Diffstat (limited to 'dns/powerdns-devel')
| -rw-r--r-- | dns/powerdns-devel/Makefile | 2 | ||||
| -rw-r--r-- | dns/powerdns-devel/files/pdns_postgresql.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/dns/powerdns-devel/Makefile b/dns/powerdns-devel/Makefile index 36d63b713188..45b144c250c7 100644 --- a/dns/powerdns-devel/Makefile +++ b/dns/powerdns-devel/Makefile @@ -7,7 +7,7 @@ PORTNAME= powerdns PORTVERSION= 2.9.20 -PORTREVISION= 5 +PORTREVISION= 6 CATEGORIES= dns ipv6 MASTER_SITES= http://downloads.powerdns.com/releases/ \ http://mirrors.evolva.ro/powerdns.com/releases/ diff --git a/dns/powerdns-devel/files/pdns_postgresql.sql b/dns/powerdns-devel/files/pdns_postgresql.sql index 481cc98b21b6..afeff3a139e0 100644 --- a/dns/powerdns-devel/files/pdns_postgresql.sql +++ b/dns/powerdns-devel/files/pdns_postgresql.sql @@ -3,7 +3,7 @@ CREATE TABLE domains ( name VARCHAR(255) NOT NULL, type VARCHAR(6) NOT NULL, master VARCHAR(40) DEFAULT NULL, - account VARCHAR(40) DEFAULT NULL + account VARCHAR(40) DEFAULT NULL, notified_serial INT DEFAULT NULL, last_check INT DEFAULT NULL, CONSTRAINT pk_id @@ -22,7 +22,7 @@ CREATE TABLE records ( prio INT DEFAULT NULL, content VARCHAR(255) DEFAULT NULL, change_date INT DEFAULT NULL, -CONSTRAINT pk_id +CONSTRAINT pk_records_id PRIMARY KEY (id), CONSTRAINT fk_domainid FOREIGN KEY (domain_id) |