diff options
| author | pav <pav@FreeBSD.org> | 2007-03-23 06:09:51 +0800 |
|---|---|---|
| committer | pav <pav@FreeBSD.org> | 2007-03-23 06:09:51 +0800 |
| commit | b59d51ebbbb67f91661886cb24a8501f37b538ea (patch) | |
| tree | 345973833ee5bd35519272c8b3f19b9166ff3c18 | |
| parent | 85a81e3095b28bfe96989d157ae0b4f198afa08a (diff) | |
| download | freebsd-ports-gnome-b59d51ebbbb67f91661886cb24a8501f37b538ea.tar.gz freebsd-ports-gnome-b59d51ebbbb67f91661886cb24a8501f37b538ea.tar.zst freebsd-ports-gnome-b59d51ebbbb67f91661886cb24a8501f37b538ea.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)
| -rw-r--r-- | dns/powerdns-devel/Makefile | 2 | ||||
| -rw-r--r-- | dns/powerdns-devel/files/pdns_postgresql.sql | 4 | ||||
| -rw-r--r-- | dns/powerdns/Makefile | 2 | ||||
| -rw-r--r-- | dns/powerdns/files/pdns_postgresql.sql | 4 |
4 files changed, 6 insertions, 6 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) diff --git a/dns/powerdns/Makefile b/dns/powerdns/Makefile index 36d63b713188..45b144c250c7 100644 --- a/dns/powerdns/Makefile +++ b/dns/powerdns/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/files/pdns_postgresql.sql b/dns/powerdns/files/pdns_postgresql.sql index 481cc98b21b6..afeff3a139e0 100644 --- a/dns/powerdns/files/pdns_postgresql.sql +++ b/dns/powerdns/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) |