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

/*PATCHHERE*/
alter table binaries modify name VARCHAR(512) NOT NULL DEFAULT '' ; 
alter table binaries modify xref VARCHAR(512) NOT NULL DEFAULT '' ; 

alter table consoleinfo modify title VARCHAR(255) NOT NULL ; 
alter table consoleinfo modify review VARCHAR(3000) DEFAULT NULL ; 

alter table movieinfo modify genre varchar(255) NOT NULL;
alter table movieinfo modify actors VARCHAR(2000) NOT NULL;

alter table musicinfo modify title VARCHAR(255) NOT NULL ; 
alter table musicinfo modify review VARCHAR(3000) DEFAULT NULL ; 
alter table musicinfo modify tracks VARCHAR(3000) DEFAULT NULL ; 

alter table bookinfo modify title VARCHAR(255) NOT NULL ; 
alter table bookinfo modify review VARCHAR(3000) DEFAULT NULL ; 

alter table anidb modify title varchar(255) NOT NULL;