--- 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));