ports/110546: dns/powerdns Postgresql database init errors

[Anish Mistry]

>Number:         110546
>Category:       ports
>Synopsis:       dns/powerdns Postgresql database init errors
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Mar 19 23:40:01 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator:     Anish Mistry
>Release:        FreeBSD 6.2-RELEASE i386
>Organization:
AM Productions 
>Environment:


System: FreeBSD 6.2-RELEASE #0: Thu Feb  1 01:53:22 EST 2007
    amistry at bigguy.am-productions.biz:/usr/home/amistry/storage/temp/usr/home/amistry/windows-share/build/src/sys/BIGGUY



>Description:


The postgresql database init script contains errors.  Fixed attached.


>How-To-Repeat:





>Fix:


--- pdns_postgresql.sql.patch begins here ---
--- pdns_postgresql.sql.orig	Mon Mar 19 19:14:57 2007
+++ pdns_postgresql.sql	Mon Mar 19 19:22:32 2007
@@ -3,7 +3,7 @@
 	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 @@
 	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)
--- pdns_postgresql.sql.patch ends here ---



>Release-Note:
>Audit-Trail:
>Unformatted: