Hi all,
I've got FB at version 1.0.1 but also with a few updates from SVN prior to 1.0.2 (if that makes sense) and realise that some of the SQL commands will fail as I already have some of the variables in my tables.
So I did a quick look to see what commands I do need to run to do the update to 1.0.3 and what ones I don't. For example, to alter jos_fb_categories I'm only going to have to run...
| Code: |
add column `headerdesc` text NOT NULL after `description`,
add column `class_sfx` varchar(20) NOT NULL after `headerdesc`,
add KEY `msg_id`(`id_last_msg`)
|
That last bit...the key, gets me slightly confused...as there is a key already there that has "id_last_msg" as its field, but it is called "msgid" (note no _ in the name).
Should I delete the existing key or rename it? Not sure how keys work.
Cheers, Phil
Favoured: 0
