数据库修改100条

laoliu

-- 51ALTER TABLE pre2_common_relatedlog RENAME TO pre_common_relatedlog;-- 52ALTER TABLE pre2_common_report RENAME TO pre_common_report;-- 53ALTER TABLE pre2_common_robot RENAME TO pre_common_robot;-- 54ALTER TABLE pre2_common_secques RENAME TO pre_common_secques;-- 55ALTER TABLE pre2_common_session RENAME TO pre_common_session;-- 56ALTER TABLE pre2_common_setting RENAME TO pre_common_setting;-- 57ALTER TABLE pre2_common_share RENAME TO pre_common_share;-- 58ALTER TABLE pre2_common_smiley RENAME TO pre_common_smiley;-- 59ALTER TABLE pre2_common_stat RENAME TO pre_common_stat;-- 60ALTER TABLE pre2_common_stats RENAME TO pre_common_stats;-- 61ALTER TABLE pre2_common_statuser RENAME TO pre_common_statuser;-- 62ALTER TABLE pre2_common_tag RENAME TO pre_common_tag;-- 63ALTER TABLE pre2_common_task RENAME TO pre_common_task;-- 64ALTER TABLE pre2_common_uccenter RENAME TO pre_common_uccenter;-- 65ALTER TABLE pre2_common_usergroup RENAME TO pre_common_usergroup;-- 66ALTER TABLE pre2_common_usergroup_field RENAME TO pre_common_usergroup_field;-- 67ALTER TABLE pre2_common_var RENAME TO pre_common_var;-- 68ALTER TABLE pre2_forum_attachment RENAME TO pre_forum_attachment;-- 69ALTER TABLE pre2_forum_attachment_0 RENAME TO pre_forum_attachment_0;-- 70ALTER TABLE pre2_forum_attachment_1 RENAME TO pre_forum_attachment_1;-- 71ALTER TABLE pre2_forum_attachment_2 RENAME TO pre_forum_attachment_2;-- 72ALTER TABLE pre2_forum_attachment_3 RENAME TO pre_forum_attachment_3;-- 73ALTER TABLE pre2_forum_attachment_unused RENAME TO pre_forum_attachment_unused;-- 74ALTER TABLE pre2_forum_bbcode RENAME TO pre_forum_bbcode;-- 75ALTER TABLE pre2_forum_bookmark RENAME TO pre_forum_bookmark;-- 76ALTER TABLE pre2_forum_collection RENAME TO pre_forum_collection;-- 77ALTER TABLE pre2_forum_comment RENAME TO pre_forum_comment;-- 78ALTER TABLE pre2_forum_debate RENAME TO pre_forum_debate;-- 79ALTER TABLE pre2_forum_debate_post RENAME TO pre_forum_debate_post;-- 80ALTER TABLE pre2_forum_debate_vote RENAME TO pre_forum_debate_vote;-- 81ALTER TABLE pre2_forum_field RENAME TO pre_forum_field;-- 82ALTER TABLE pre2_forum_forum RENAME TO pre_forum_forum;-- 83ALTER TABLE pre2_forum_forumfield RENAME TO pre_forum_forumfield;-- 84ALTER TABLE pre2_forum_group RENAME TO pre_forum_group;-- 85ALTER TABLE pre2_forum_groupuser RENAME TO pre_forum_groupuser;-- 86ALTER TABLE pre2_forum_hotreply RENAME TO pre_forum_hotreply;-- 87ALTER TABLE pre2_forum_medal RENAME TO pre_forum_medal;-- 88ALTER TABLE pre2_forum_memberphoto RENAME TO pre_forum_memberphoto;-- 89ALTER TABLE pre2_forum_merge RENAME TO pre_forum_merge;-- 90ALTER TABLE pre2_forum_modaction RENAME TO pre_forum_modaction;-- 91ALTER TABLE pre2_forum_modworks RENAME TO pre_forum_modworks;-- 92ALTER TABLE pre2_forum_newthread RENAME TO pre_forum_newthread;-- 93ALTER TABLE pre2_forum_onlinelist RENAME TO pre_forum_onlinelist;-- 94ALTER TABLE pre2_forum_poll RENAME TO pre_forum_poll;-- 95ALTER TABLE pre2_forum_pollvoter RENAME TO pre_forum_pollvoter;-- 96ALTER TABLE pre2_forum_post RENAME TO pre_forum_post;-- 97ALTER TABLE pre2_forum_postposition RENAME TO pre_forum_postposition;-- 98ALTER TABLE pre2_forum_poststick RENAME TO pre_forum_poststick;-- 99ALTER TABLE pre2_forum_rss RENAME TO pre_forum_rss;-- 100ALTER TABLE pre2_forum_statlog RENAME TO pre_forum_statlog;-- 101ALTER TABLE pre2_forum_thread RENAME TO pre_forum_thread;-- 102ALTER TABLE pre2_forum_thread_disable RENAME TO pre_forum_thread_disable;-- 103ALTER TABLE pre2_forum_thread_image RENAME TO pre_forum_thread_image;-- 104ALTER TABLE pre2_forum_thread_mod RENAME TO pre_forum_thread_mod;-- 105ALTER TABLE pre2_forum_thread_promotion RENAME TO pre_forum_thread_promotion;-- 106ALTER TABLE pre2_forum_thread_recommend RENAME TO pre_forum_thread_recommend;-- 107ALTER TABLE pre2_forum_threadtype RENAME TO pre_forum_threadtype;-- 108ALTER TABLE pre2_forum_trade RENAME TO pre_forum_trade;-- 109ALTER TABLE pre2_forum_trade_comment RENAME TO pre_forum_trade_comment;-- 110ALTER TABLE pre2_forum_trade_fee RENAME TO pre_forum_trade_fee;-- 111ALTER TABLE pre2_forum_trade_order RENAME TO pre_forum_trade_order;-- 112ALTER TABLE pre2_forum_typeoption RENAME TO pre_forum_typeoption;-- 113ALTER TABLE pre2_forum_warning RENAME TO pre_forum_warning;-- 114ALTER TABLE pre2_home_album RENAME TO pre_home_album;-- 115ALTER TABLE pre2_home_album_category RENAME TO pre_home_album_category;-- 116ALTER TABLE pre2_home_blog RENAME TO pre_home_blog;-- 117ALTER TABLE pre2_home_click RENAME TO pre_home_click;-- 118ALTER TABLE pre2_home_comment RENAME TO pre_home_comment;-- 119ALTER TABLE pre2_home_cover RENAME TO pre_home_cover;-- 120ALTER TABLE pre2_home_doing RENAME TO pre_home_doing;-- 121ALTER TABLE pre2_home_feed RENAME TO pre_home_feed;-- 122ALTER TABLE pre2_home_friend RENAME TO pre_home_friend;-- 123ALTER TABLE pre2_home_notification RENAME TO pre_home_notification;-- 124ALTER TABLE pre2_home_pic RENAME TO pre_home_pic;-- 125ALTER TABLE pre2_home_poke RENAME TO pre_home_poke;-- 126ALTER TABLE pre2_home_post RENAME TO pre_home_post;-- 127ALTER TABLE pre2_home_share RENAME TO pre_home_share;-- 128ALTER TABLE pre2_home_specialuser RENAME TO pre_home_specialuser;-- 129ALTER TABLE pre2_home_visitor RENAME TO pre_home_visitor;-- 130ALTER TABLE pre2_mobile_member RENAME TO pre_mobile_member;-- 131ALTER TABLE pre2_portal_article RENAME TO pre_portal_article;-- 132ALTER TABLE pre2_portal_article_category RENAME TO pre_portal_article_category;-- 133ALTER TABLE pre2_portal_article_count RENAME TO pre_portal_article_count;-- 134ALTER TABLE pre2_portal_article_data RENAME TO pre_portal_article_data;-- 135ALTER TABLE pre2_portal_category RENAME TO pre_portal_category;-- 136ALTER TABLE pre2_portal_comment RENAME TO pre_portal_comment;-- 137ALTER TABLE pre2_portal_topic RENAME TO pre_portal_topic;-- 138ALTER TABLE pre2_search_modkeywords RENAME TO pre_search_modkeywords;-- 139ALTER TABLE pre2_search_sphinx RENAME TO pre_search_sphinx;-- 140ALTER TABLE pre2_uchome_album RENAME TO pre_uchome_album;-- 141ALTER TABLE pre2_uchome_blog RENAME TO pre_uchome_blog;-- 142ALTER TABLE pre2_uchome_doing RENAME TO pre_uchome_doing;-- 143ALTER TABLE pre2_uchome_feed RENAME TO pre_uchome_feed;-- 144ALTER TABLE pre2_uchome_friend RENAME TO pre_uchome_friend;-- 145ALTER TABLE pre2_uchome_member RENAME TO pre_uchome_member;-- 146ALTER TABLE pre2_uchome_pic RENAME TO pre_uchome_pic;-- 147ALTER TABLE pre2_uchome_poke RENAME TO pre_uchome_poke;-- 148ALTER TABLE pre2_uchome_post RENAME TO pre_uchome_post;-- 149ALTER TABLE pre2_uchome_share RENAME TO pre_uchome_share;-- 150ALTER TABLE pre2_uchome_space RENAME TO pre_uchome_space;

怎么发不成功