Closed (fixed)
Project:
Recipe
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
15 Dec 2004 at 04:46 UTC
Updated:
16 Mar 2005 at 03:15 UTC
This line is currently in the install MySql file and needs to be removed.
"ALTER TABLE `recipe` ADD `instructions` TEXT;"
If it is left in it will cause errors because the column already exsist.
See Original :
CREATE TABLE recipe (
nid int(10) unsigned NOT NULL,
source varchar(255),
yield varchar(255),
preptime int(10) DEFAULT '0',
notes text,
instructions text,
PRIMARY KEY (nid)
);
ALTER TABLE `recipe` ADD `instructions` TEXT;
CREATE TABLE recipe_ingredients (
iid int unsigned NOT NULL PRIMARY KEY auto_increment,
nid int(10) unsigned NOT NULL,
ingredient varchar(255),
weight tinyint DEFAULT '0'
);
Comments
Comment #1
moshe weitzman commentedfixed in HEAD
Comment #2
(not verified) commented