处理需要耐心，小心
insert into vmms_example (seq_id,video_url,record_time,duration,example_name,example_preview_url,example_preview_wapurl,example_picture_url,tail_duration,tail_mat_url,state) values
('839','/data/movie/demo/40839.3gp',now(),'26','生活类——区别 ','/data/avatarpicture/preview/40839.jpg','/data/avatarpicture/preview/40839.jpg','/data/avatarpicture/preview/40839.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('840','/data/movie/demo/40840.3gp',now(),'25','食补食疗 ','/data/avatarpicture/preview/40840.jpg','/data/avatarpicture/preview/40840.jpg','/data/avatarpicture/preview/40840.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('841','/data/movie/demo/40841.3gp',now(),'30','赢的感悟 ','/data/avatarpicture/preview/40841.jpg','/data/avatarpicture/preview/40841.jpg','/data/avatarpicture/preview/40841.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('842','/data/movie/demo/40842.3gp',now(),'19','情感表达—相信 ','/data/avatarpicture/preview/40842.jpg','/data/avatarpicture/preview/40842.jpg','/data/avatarpicture/preview/40842.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('843','/data/movie/demo/40843.3gp',now(),'23','再来一瓶 ','/data/avatarpicture/preview/40843.jpg','/data/avatarpicture/preview/40843.jpg','/data/avatarpicture/preview/40843.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('844','/data/movie/demo/40844.3gp',now(),'31','生活小贴士-寿命 ','/data/avatarpicture/preview/40844.jpg','/data/avatarpicture/preview/40844.jpg','/data/avatarpicture/preview/40844.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('845','/data/movie/demo/40845.3gp',now(),'33','生活类——学习 ','/data/avatarpicture/preview/40845.jpg','/data/avatarpicture/preview/40845.jpg','/data/avatarpicture/preview/40845.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('846','/data/movie/demo/40846.3gp',now(),'14','校规 ','/data/avatarpicture/preview/40846.jpg','/data/avatarpicture/preview/40846.jpg','/data/avatarpicture/preview/40846.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('847','/data/movie/demo/40847.3gp',now(),'20','情感表达—心灵点滴 ','/data/avatarpicture/preview/40847.jpg','/data/avatarpicture/preview/40847.jpg','/data/avatarpicture/preview/40847.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('848','/data/movie/demo/40848.3gp',now(),'17','选举 ','/data/avatarpicture/preview/40848.jpg','/data/avatarpicture/preview/40848.jpg','/data/avatarpicture/preview/40848.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('849','/data/movie/demo/40849.3gp',now(),'35','女性养生 ','/data/avatarpicture/preview/40849.jpg','/data/avatarpicture/preview/40849.jpg','/data/avatarpicture/preview/40849.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('850','/data/movie/demo/40850.3gp',now(),'29','学会爱自己 ','/data/avatarpicture/preview/40850.jpg','/data/avatarpicture/preview/40850.jpg','/data/avatarpicture/preview/40850.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('851','/data/movie/demo/40851.3gp',now(),'27','分手 ','/data/avatarpicture/preview/40851.jpg','/data/avatarpicture/preview/40851.jpg','/data/avatarpicture/preview/40851.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('852','/data/movie/demo/40852.3gp',now(),'20','名人名言 ','/data/avatarpicture/preview/40852.jpg','/data/avatarpicture/preview/40852.jpg','/data/avatarpicture/preview/40852.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('853','/data/movie/demo/40853.3gp',now(),'23','情感表达—语录 ','/data/avatarpicture/preview/40853.jpg','/data/avatarpicture/preview/40853.jpg','/data/avatarpicture/preview/40853.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('854','/data/movie/demo/40854.3gp',now(),'26','错过了八个 ','/data/avatarpicture/preview/40854.jpg','/data/avatarpicture/preview/40854.jpg','/data/avatarpicture/preview/40854.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('855','/data/movie/demo/40855.3gp',now(),'28','买车 ','/data/avatarpicture/preview/40855.jpg','/data/avatarpicture/preview/40855.jpg','/data/avatarpicture/preview/40855.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('856','/data/movie/demo/40856.3gp',now(),'28','养生保健—年龄 ','/data/avatarpicture/preview/40856.jpg','/data/avatarpicture/preview/40856.jpg','/data/avatarpicture/preview/40856.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('857','/data/movie/demo/40857.3gp',now(),'21','狼 ','/data/avatarpicture/preview/40857.jpg','/data/avatarpicture/preview/40857.jpg','/data/avatarpicture/preview/40857.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('858','/data/movie/demo/40858.3gp',now(),'28','病情好转 ','/data/avatarpicture/preview/40858.jpg','/data/avatarpicture/preview/40858.jpg','/data/avatarpicture/preview/40858.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('859','/data/movie/demo/40859.3gp',now(),'34','公主征婚 ','/data/avatarpicture/preview/40859.jpg','/data/avatarpicture/preview/40859.jpg','/data/avatarpicture/preview/40859.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('860','/data/movie/demo/40860.3gp',now(),'27','牛肉面 ','/data/avatarpicture/preview/40860.jpg','/data/avatarpicture/preview/40860.jpg','/data/avatarpicture/preview/40860.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('861','/data/movie/demo/40861.3gp',now(),'27','作为什么 ','/data/avatarpicture/preview/40861.jpg','/data/avatarpicture/preview/40861.jpg','/data/avatarpicture/preview/40861.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('862','/data/movie/demo/40862.3gp',now(),'31','雷语 ','/data/avatarpicture/preview/40862.jpg','/data/avatarpicture/preview/40862.jpg','/data/avatarpicture/preview/40862.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('863','/data/movie/demo/40863.3gp',now(),'22','审视 ','/data/avatarpicture/preview/40863.jpg','/data/avatarpicture/preview/40863.jpg','/data/avatarpicture/preview/40863.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('864','/data/movie/demo/40864.3gp',now(),'18','夫妻吵架 ','/data/avatarpicture/preview/40864.jpg','/data/avatarpicture/preview/40864.jpg','/data/avatarpicture/preview/40864.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('865','/data/movie/demo/40865.3gp',now(),'19','卷面整洁分 ','/data/avatarpicture/preview/40865.jpg','/data/avatarpicture/preview/40865.jpg','/data/avatarpicture/preview/40865.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('866','/data/movie/demo/40866.3gp',now(),'20','食疗 ','/data/avatarpicture/preview/40866.jpg','/data/avatarpicture/preview/40866.jpg','/data/avatarpicture/preview/40866.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('867','/data/movie/demo/40867.3gp',now(),'21','关系 ','/data/avatarpicture/preview/40867.jpg','/data/avatarpicture/preview/40867.jpg','/data/avatarpicture/preview/40867.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('868','/data/movie/demo/40868.3gp',now(),'24','不老的秘方 ','/data/avatarpicture/preview/40868.jpg','/data/avatarpicture/preview/40868.jpg','/data/avatarpicture/preview/40868.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('869','/data/movie/demo/40869.3gp',now(),'19','善待自己 ','/data/avatarpicture/preview/40869.jpg','/data/avatarpicture/preview/40869.jpg','/data/avatarpicture/preview/40869.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('870','/data/movie/demo/40870.3gp',now(),'25','任务 ','/data/avatarpicture/preview/40870.jpg','/data/avatarpicture/preview/40870.jpg','/data/avatarpicture/preview/40870.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('871','/data/movie/demo/40871.3gp',now(),'27','未来老婆 ','/data/avatarpicture/preview/40871.jpg','/data/avatarpicture/preview/40871.jpg','/data/avatarpicture/preview/40871.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('872','/data/movie/demo/40872.3gp',now(),'25','自我介绍 ','/data/avatarpicture/preview/40872.jpg','/data/avatarpicture/preview/40872.jpg','/data/avatarpicture/preview/40872.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('873','/data/movie/demo/40873.3gp',now(),'21','报数 ','/data/avatarpicture/preview/40873.jpg','/data/avatarpicture/preview/40873.jpg','/data/avatarpicture/preview/40873.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('874','/data/movie/demo/40874.3gp',now(),'21','好好学习天天向上 ','/data/avatarpicture/preview/40874.jpg','/data/avatarpicture/preview/40874.jpg','/data/avatarpicture/preview/40874.jpg','5','/data/avatarpicture/tail/t6.gif','Y'),
('875','/data/movie/demo/40875.3gp',now(),'22','开学小愿望 ','/data/avatarpicture/preview/40875.jpg','/data/avatarpicture/preview/40875.jpg','/data/avatarpicture/preview/40875.jpg','5','/data/avatarpicture/tail/t6.gif','Y');
Demo添加语句
1、insert into vmms_example (seq_id,video_url,record_time,duration,example_name,example_preview_url,example_preview_wapurl,example_picture_url,tail_duration,tail_mat_url,state) values
('790','/data/movie/demo/40790.3gp',now(),'20','端午佳节到','/data/avatarpicture/preview/40790.jpg','/data/avatarpicture/preview/40790.jpg','/data/avatarpicture/preview/40790.jpg','5','/data/avatarpicture/tail/fc.gif','Y');
依据产品提供的“demo更新列表.xls”，编制上述语句：
790 序号
/data/movie/demo/40790.3gp demo的存放路径
20 demo长度
端午佳节到 标题
/data/avatarpicture/preview/40790.jpg 连续3个都是预览图片（有的节点用到，有的用不到，为了方便，都写上）
5 追尾图片的播放时间（这个追尾图片各节点不一样，有的有，有的还没有，没有的不写，默认就是0）
/data/avatarpicture/tail/fc.gif 追尾图片的存放路径
Y 线上还是线下（下线的时候，该字段置为N）
注意事项：
1、 首先要把对应的3gp\jpg文件传到正确的存放位置；
2、 拼装好的sql语句请务必检查，其次过长的sql语句应存放成文件，再将文件上传，然后再cat 文件 | mysql -u smsop -pvmmsuser vmms
3、 更新完毕记得重启disp程序才能生效，下线demo也是如此。
4、 请务必注意路径，有/data /data_fjlt类似这样的不同；
5、 在贵州移动更新好了，可以通过进行预览。
demomap
insert into vmms_example_type_map values
(null,'603','839'),
(null,'602','840'),
(null,'603','841'),
(null,'603','842'),
(null,'601','843'),
(null,'602','844'),
(null,'603','845'),
(null,'601','846'),
(null,'603','847'),
(null,'601','848'),
(null,'602','849'),
(null,'603','850'),
(null,'601','851'),
(null,'603','852'),
(null,'603','853'),
(null,'601','854'),
(null,'601','855'),
(null,'602','856'),
(null,'603','857'),
(null,'601','858'),
(null,'601','859'),
(null,'601','860'),
(null,'603','861'),
(null,'603','862'),
(null,'603','863'),
(null,'601','864'),
(null,'601','865'),
(null,'602','866'),
(null,'601','867'),
(null,'603','868'),
(null,'603','869'),
(null,'601','870'),
(null,'601','871'),
(null,'601','872'),
(null,'601','873'),
(null,'603','874'),
(null,'603','875');
2、甘肃移动、浙江联通额外需要指定demo的类型操作；
vmms.vmms_example_type里有：
| 601 | 新休闲娱乐 | 6 | 1 | 2010-12-16 23:18:37 |
| 602 | 新寓教于乐 | 6 | 2 | 2010-12-16 23:19:03 |
| 603 | 新社会人文 | 6 | 3 | 2010-12-16 23:19:42 |
类似这样的，我们需要在：
vmms_example_type_map里给新加的demo附上对应的类型属性，就是：
insert into vmms_example_type_map values (null,’603’,’790’);这样的即可。
对应的就是在vmms_try里点类型demo的时候用到。
