ALTER TABLE `mediacache` CHANGE `FullFileMd5` `FullFileMd5` CHAR( 33 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,CHANGE `CacheDisk` `CacheDisk` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',CHANGE `HeaderInfo` `HeaderInfo` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;

 

ALTER TABLE `video_class_path` CHANGE `ServerGUID` `ServerGUID` CHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

 

ALTER TABLE `coll_playlist` CHANGE `VideoGUID` `VideoGUID` CHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

 

ALTER TABLE `video_class_type` CHANGE `BgColor` `BgColor` CHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'black',CHANGE `PaddingTop` `PaddingTop` CHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0';

 

 

增加修复和优化数据库命令 movieserver.exe -repairdb