2 files changed, 29 insertions, 0 deletions

diff --git a/www/phprecipebook/files/patch-sql-recipedb.mysql b/www/phprecipebook/files/patch-sql-recipedb.mysql
new file mode 100644
index 000000000000..ed978aa1bd3c
--- /dev/null
+++ b/www/phprecipebook/files/patch-sql-recipedb.mysql
@@ -0,0 +1,20 @@
+--- 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));
+ 
diff --git a/www/phprecipebook/files/pkg-message.in b/www/phprecipebook/files/pkg-message.in
new file mode 100644
index 000000000000..8d894eb100b8
--- /dev/null
+++ b/www/phprecipebook/files/pkg-message.in
@@ -0,0 +1,9 @@
+* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
+Please read:
+
+%%RECIPEDIR%%/docs/INSTALL.UNIX
+
+If you are upgrading then read this too:
+
+%%RECIPEDIR%%/docs/UPGRADE.TXT
+* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *