/*UPDATEREVISION*/
INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('dbversion', '$Rev: 3272 $', now()) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), updateddate=now();

/*PATCHHERE*/
alter table upcoming add title varchar(255) null;

update upcoming set title = 'Box Office' where typeID = 1;
update upcoming set title = 'In Theatre' where typeID = 2;
update upcoming set title = 'Opening' where typeID = 3;
update upcoming set title = 'Upcoming' where typeID = 4;
update upcoming set title = 'DVD Releases' where typeID = 5;
update menu set title = 'Movie Lists' where title = 'In Theatres';

update upcoming set source = 'Rotten Tomato' where source = 'rottentomato';

INSERT IGNORE INTO `site` (`ID` , `setting` , `value` , `updateddate` )
  VALUES ( NULL ,  'flistkey',  'aefa1439a4f3b0e5c23af74fe3ee0e96', NOW( ));