This was not in the download of 5.0, but I received it today from an admin.
[quote]** upgrade from 4.2.x to 5.0 ***
Step.1
Excute the following SQL queries:
ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id ),
KEY uid (uid ,stream_id )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id ),
KEY uid (uid ,stream_id )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE IF NOT EXISTS jcow_footer_pages (
id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL,
link_name varchar(255) NOT NULL,
content text NOT NULL,
weight int(11) NOT NULL,
PRIMARY KEY (id )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;[/quote]
I can't get my phpMyAdmin to accept this update, so any help would be appreciated. GREATLY appreciated!
|