日志
批量修改UCENTER数据库表名
热度 1 ||
通过PHPMYADMIN来修改比较方便, 操作前请自行备份数据库.
ALTER TABLE pre_ucenter_badwords rename to pre_ucenter_badwords;
ALTER TABLE pre_ucenter_domains rename to pre_ucenter_domains;
ALTER TABLE pre_ucenter_failedlogins rename to pre_ucenter_failedlogins;
ALTER TABLE pre_ucenter_feeds rename to pre_ucenter_feeds;
ALTER TABLE pre_ucenter_friends rename to pre_ucenter_friends;
ALTER TABLE pre_ucenter_mailqueue rename to pre_ucenter_mailqueue;
ALTER TABLE pre_ucenter_memberfields rename to pre_ucenter_memberfields;
ALTER TABLE pre_ucenter_members rename to pre_ucenter_members;
ALTER TABLE pre_ucenter_mergemembers rename to pre_ucenter_mergemembers;
ALTER TABLE pre_ucenter_newpm rename to pre_ucenter_newpm;
ALTER TABLE pre_ucenter_notelist rename to pre_ucenter_notelist;
ALTER TABLE pre_ucenter_pms rename to pre_ucenter_pms;
ALTER TABLE pre_ucenter_protectedmembers rename to pre_ucenter_protectedmembers;
ALTER TABLE pre_ucenter_settings rename to pre_ucenter_settings;
ALTER TABLE pre_ucenter_sqlcache rename to pre_ucenter_sqlcache;
ALTER TABLE pre_ucenter_tags rename to pre_ucenter_tags;
ALTER TABLE pre_ucenter_vars rename to pre_ucenter_vars;
反过来也可以:
ALTER TABLE uc_applications rename to pre_ucenter_applications;
ALTER TABLE uc_badwords rename to pre_ucenter_badwords;
ALTER TABLE uc_domains rename to pre_ucenter_domains;
ALTER TABLE uc_failedlogins rename to pre_ucenter_failedlogins;
ALTER TABLE uc_feeds rename to pre_ucenter_feeds;
ALTER TABLE uc_friends rename to pre_ucenter_friends;
ALTER TABLE uc_mailqueue rename to pre_ucenter_mailqueue;
ALTER TABLE uc_memberfields rename to pre_ucenter_memberfields;
ALTER TABLE uc_members rename to pre_ucenter_members;
ALTER TABLE uc_mergemembers rename to pre_ucenter_mergemembers;
ALTER TABLE uc_newpm rename to pre_ucenter_newpm;
ALTER TABLE uc_notelist rename to pre_ucenter_notelist;
ALTER TABLE uc_pms rename to pre_ucenter_pms;
ALTER TABLE uc_protectedmembers rename to pre_ucenter_protectedmembers;
ALTER TABLE uc_settings rename to pre_ucenter_settings;
ALTER TABLE uc_sqlcache rename to pre_ucenter_sqlcache;
ALTER TABLE uc_tags rename to pre_ucenter_tags;
ALTER TABLE uc_vars rename to pre_ucenter_vars;