ports/129312: [maintainer-update] www/phprecipebook: update to 2.39

[Guido Falsi]

>Number:         129312
>Category:       ports
>Synopsis:       [maintainer-update] www/phprecipebook: update to 2.39
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Sun Nov 30 21:10:00 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     Guido Falsi
>Release:        FreeBSD 7.1-PRERELEASE i386
>Organization:
none
>Environment:
System: FreeBSD megatron.madpilot.net 7.1-PRERELEASE FreeBSD 7.1-PRERELEASE #12: Sun Nov 23 12:57:35 CET 2008 root at megatron.madpilot.net:/usr/obj/usr/src/sys/MEGATRON i386

>Description:

Update to 2.39.

Removed file:
files/patch-sql-recipedb.mysql

>How-To-Repeat:
>Fix:

diff -ruN phprecipebook.old/Makefile phprecipebook/Makefile
--- phprecipebook.old/Makefile	2008-11-30 21:39:24.000000000 +0100
+++ phprecipebook/Makefile	2008-11-30 21:40:32.000000000 +0100
@@ -6,7 +6,7 @@
 #
 
 PORTNAME=	phprecipebook
-PORTVERSION=	2.38
+PORTVERSION=	2.39
 CATEGORIES=	www deskutils
 MASTER_SITES=	SF
 
diff -ruN phprecipebook.old/distinfo phprecipebook/distinfo
--- phprecipebook.old/distinfo	2008-11-30 21:39:24.000000000 +0100
+++ phprecipebook/distinfo	2008-11-30 21:40:53.000000000 +0100
@@ -1,3 +1,3 @@
-MD5 (phprecipebook-2.38.tar.gz) = 864ae8fb66213c2796fdd4b7a58a053d
-SHA256 (phprecipebook-2.38.tar.gz) = c05d53f849ef84a0b6690c6d20e3f703e215a7ef0a0b1990354ffe14bd34d2b3
-SIZE (phprecipebook-2.38.tar.gz) = 556970
+MD5 (phprecipebook-2.39.tar.gz) = ca2d535f1d59440cb3b0ab1a4610f884
+SHA256 (phprecipebook-2.39.tar.gz) = c00aefe04cf99c6884c89a6e44b28062728c6007946e40fcd3fe93bdd86d0ecb
+SIZE (phprecipebook-2.39.tar.gz) = 589171
diff -ruN phprecipebook.old/files/patch-sql-recipedb.mysql phprecipebook/files/patch-sql-recipedb.mysql
--- phprecipebook.old/files/patch-sql-recipedb.mysql	2008-11-30 21:39:24.000000000 +0100
+++ phprecipebook/files/patch-sql-recipedb.mysql	1970-01-01 01:00:00.000000000 +0100
@@ -1,20 +0,0 @@
---- sql/recipedb.mysql.orig	2007-03-31 20:22:08.000000000 +0200
-+++ sql/recipedb.mysql	2007-09-27 17:10:02.000000000 +0200
-@@ -154,7 +154,7 @@
- 	PRIMARY KEY (meal_id));
- 
- CREATE TABLE recipe_mealplans (
--	mplan_date DATE NOT NULL DEFAULT 'now()',
-+	mplan_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- 	mplan_meal INT NOT NULL REFERENCES recipe_meals(meal_id) ON DELETE CASCADE,
- 	mplan_recipe INT NOT NULL REFERENCES recipe_recipes(recipe_id) ON DELETE CASCADE,
- 	mplan_servings INT NOT NULL DEFAULT 0,
-@@ -164,7 +164,7 @@
- CREATE TABLE recipe_reviews (
- 	review_recipe INT NOT NULL REFERENCES recipe_recipes(recipe_id) ON DELETE CASCADE,
- 	review_comments VARCHAR(255) NOT NULL,
--	review_date TIMESTAMP DEFAULT 'now()',
-+	review_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- 	review_owner VARCHAR(32) NOT NULL REFERENCES security_users(user_login) ON DELETE SET NULL ON UPDATE CASCADE,
- 	PRIMARY KEY (review_recipe,review_comments,review_owner));
- 
>Release-Note:
>Audit-Trail:
>Unformatted: