多个用户初始化改表名

第二跳 初始化数据到mysql 和postgresql 如多个用户则需改表名

POSTGRES下修改表名

alter table ARRANGE rename to AP_ARRANGE ;
alter table ORGDUMMY rename to AP_ORGDUMMY ;

alter table AFFICHEMGR rename to ARCHIVE_AFFICHEMGR ; 第一条需要手工执行
alter table ALLACTIVE rename to ARCHIVE_ALLACTIVE ;
alter table ALLACTIVESEARCHINFO rename to ARCHIVE_ALLACTIVESEARCHINFO ;
alter table ARRANGE rename to ARCHIVE_ARRANGE ;
alter table BUSINESSHISTORY rename to ARCHIVE_BUSINESSHISTORY ;
alter table CHANGENAME rename to ARCHIVE_CHANGENAME ;
alter table CLOSEACASE rename to ARCHIVE_CLOSEACASE ;
alter table CORRECTREGIST rename to ARCHIVE_CORRECTREGIST ;
alter table DISSENT rename to ARCHIVE_DISSENT ;
alter table HOMOLOGOUSBUILDING rename to ARCHIVE_HOMOLOGOUSBUILDING ;
alter table INVOICECREDENCEMGR rename to ARCHIVE_INVOICECREDENCEMGR ;
alter table PROPERTYMANAGE rename to ARCHIVE_PROPERTYMANAGE ;
alter table REALHIGHOTHERRIGHT rename to ARCHIVE_REALHIGHOTHERRIGHT ;
alter table REALNETSUBSCRIBE rename to ARCHIVE_REALNETSUBSCRIBE ;
alter table REALOTHERRIGHT rename to ARCHIVE_REALOTHERRIGHT ;
alter table REALOWNERSHIP rename to ARCHIVE_REALOWNERSHIP ;
alter table REALPROPERTY rename to ARCHIVE_REALPROPERTY ;
alter table REALPROPERTY_LO rename to ARCHIVE_REALPROPERTY_LO ;
alter table REALRELATEDRESOURCE rename to ARCHIVE_REALRELATEDRESOURCE ;
alter table REALSALESORDER rename to ARCHIVE_REALSALESORDER ;
alter table REALSERVITUDE rename to ARCHIVE_REALSERVITUDE ;
alter table REALUSE rename to ARCHIVE_REALUSE ;
alter table REALUSEDETAILS rename to ARCHIVE_REALUSEDETAILS ;
alter table REALUSEORDER rename to ARCHIVE_REALUSEORDER ;
alter table REALUSEORDERDETAILS rename to ARCHIVE_REALUSEORDERDETAILS ;
alter table REISSUEMGR rename to ARCHIVE_REISSUEMGR ;
alter table RESTRICT1 rename to ARCHIVE_RESTRICT1 ;
alter table TRADEISSUE rename to ARCHIVE_TRADEISSUE ;
alter table UNRELATEDRESOURCE rename to ARCHIVE_UNRELATEDRESOURCE ;
alter table VIRTUALNETSUBSCRIBE rename to ARCHIVE_VIRTUALNETSUBSCRIBE ;
alter table VIRTUALOTHERRIGHT rename to ARCHIVE_VIRTUALOTHERRIGHT ;
alter table VIRTUALOWNERSHIP rename to ARCHIVE_VIRTUALOWNERSHIP ;
alter table VIRTUALPROPERTY rename to ARCHIVE_VIRTUALPROPERTY ;
alter table VIRTUALPROPERTY_LO rename to ARCHIVE_VIRTUALPROPERTY_LO ;
alter table VIRTUALRELATEDRESOURCE rename to ARCHIVE_VIRTUALRELATEDRESOURCE ;
alter table VIRTUALSALESORDER rename to ARCHIVE_VIRTUALSALESORDER ;

alter table A rename to PUBR_A ;
alter table ADDRESS rename to PUBR_ADDRESS ;
alter table ALLACTIVE rename to PUBR_ALLACTIVE ;
alter table BLDCOMMON rename to PUBR_BLDCOMMON ;
alter table BLDFLOOR rename to PUBR_BLDFLOOR ;
alter table BLDROOM rename to PUBR_BLDROOM ;
alter table BLDUNIT rename to PUBR_BLDUNIT ;
alter table BUILDING rename to PUBR_BUILDING ;
alter table CONTACT rename to PUBR_CONTACT ;
alter table GOODSCATALOG rename to PUBR_GOODSCATALOG ;
alter table ORGORGANIZE rename to PUBR_ORGORGANIZE ;
alter table ORGPEOPLE rename to PUBR_ORGPEOPLE ;
alter table REALTYPE rename to PUBR_REALTYPE ;
alter table REGION rename to PUBR_REGION ;
alter table ROOMRIGHT rename to PUBR_ROOMRIGHT ;
alter table STANACTIVE rename to PUBR_STANACTIVE ;
alter table STANACTIVEDETAILURL rename to PUBR_STANACTIVEDETAILURL ;
alter table STANACTIVEROLE rename to PUBR_STANACTIVEROLE ;
alter table STANACTIVERULE rename to PUBR_STANACTIVERULE ;
alter table SUBSTANACTIVEDETAILURL rename to PUBR_SUBSTANACTIVEDETAILURL ;
alter table SVYLAND rename to PUBR_SVYLAND ;
alter table SW2DNEXUSDATA rename to PUBR_SW2DNEXUSDATA ;
alter table SW2DNEXUSTABLE rename to PUBR_SW2DNEXUSTABLE ;
alter table SW2DNEXUSTYPE rename to PUBR_SW2DNEXUSTYPE ;
alter table SW2DNEXUSTYPESORT rename to PUBR_SW2DNEXUSTYPESORT ;

alter table AFFICHEMGR rename to TT_AFFICHEMGR ;
alter table ALLACTIVESEARCHINFO rename to TT_ALLACTIVESEARCHINFO ;
alter table BLDCHANGETYPE rename to TT_BLDCHANGETYPE ;
alter table BUSINESSHISTORY rename to TT_BUSINESSHISTORY ;
alter table CERTPOSTIDSOURCE rename to TT_CERTPOSTIDSOURCE ;
alter table CERTTYPE rename to TT_CERTTYPE ;
alter table CHANGENAME rename to TT_CHANGENAME ;
alter table CLOSEACASE rename to TT_CLOSEACASE ;
alter table COMBINATIONREGIST rename to TT_COMBINATIONREGIST ;
alter table CORRECTREGIST rename to TT_CORRECTREGIST ;
alter table DISSENT rename to TT_DISSENT ;
alter table HOMOLOGOUSBUILDING rename to TT_HOMOLOGOUSBUILDING ;
alter table INVOICECREDENCEMGR rename to TT_INVOICECREDENCEMGR ;
alter table OTHERLOANOFREALOTHERRIGHT rename to TT_OTHERLOANOFREALOTHERRIGHT ;
alter table PROPERTYMANAGE rename to TT_PROPERTYMANAGE ;
alter table REALHIGHOTHERRIGHT rename to TT_REALHIGHOTHERRIGHT ;
alter table REALNETSUBSCRIBE rename to TT_REALNETSUBSCRIBE ;
alter table REALOTHERRIGHT rename to TT_REALOTHERRIGHT ;
alter table REALOWNERSHIP rename to TT_REALOWNERSHIP ;
alter table REALPROPERTY rename to TT_REALPROPERTY ;
alter table REALPROPERTY_LO rename to TT_REALPROPERTY_LO ;
alter table REALRELATEDRESOURCE rename to TT_REALRELATEDRESOURCE ;
alter table REALSALEPERMIT rename to TT_REALSALEPERMIT ;
alter table REALSALESORDER rename to TT_REALSALESORDER ;
alter table REALSERVITUDE rename to TT_REALSERVITUDE ;
alter table REALSERVITUDEDETAILS rename to TT_REALSERVITUDEDETAILS ;
alter table REALUSE rename to TT_REALUSE ;
alter table REALUSEDETAILS rename to TT_REALUSEDETAILS ;
alter table REALUSEORDER rename to TT_REALUSEORDER ;
alter table REALUSEORDERDETAILS rename to TT_REALUSEORDERDETAILS ;
alter table REGISTER_PEOPLEPRIV rename to TT_REGISTER_PEOPLEPRIV ;
alter table REGISTER_PRIV rename to TT_REGISTER_PRIV ;
alter table REISSUEMGR rename to TT_REISSUEMGR ;
alter table RESTRICT1 rename to TT_RESTRICT1 ;
alter table RIGHTCERT rename to TT_RIGHTCERT ;
alter table RIGHTCERT2OFRIGHTCERT3 rename to TT_RIGHTCERT2OFRIGHTCERT3 ;
alter table RIGHTCERTREFRES rename to TT_RIGHTCERTREFRES ;
alter table RIGHTCERTROOM rename to TT_RIGHTCERTROOM ;
alter table RIGHTTYPE rename to TT_RIGHTTYPE ;
alter table TRADEISSUE rename to TT_TRADEISSUE ;
alter table UNRELATEDRESOURCE rename to TT_UNRELATEDRESOURCE ;
alter table VIRTUALNETSUBSCRIBE rename to TT_VIRTUALNETSUBSCRIBE ;
alter table VIRTUALOTHERRIGHT rename to TT_VIRTUALOTHERRIGHT ;
alter table VIRTUALOWNERSHIP rename to TT_VIRTUALOWNERSHIP ;
alter table VIRTUALPROPERTY rename to TT_VIRTUALPROPERTY ;
alter table VIRTUALPROPERTY_LO rename to TT_VIRTUALPROPERTY_LO ;
alter table VIRTUALRELATEDRESOURCE rename to TT_VIRTUALRELATEDRESOURCE ;
alter table VIRTUALSALESORDER rename to TT_VIRTUALSALESORDER ;

声明: 除非转自他站（如有侵权，请联系处理）外，本文采用 BY-NC-SA 协议进行授权 | 智乐兔
转载请注明：转自《多个用户初始化改表名》
本文地址：https://www.zhiletu.com/archives-389.html
关注公众号：