platform_b2b分离

最新推荐文章于 2024-04-24 09:47:33 发布

cuiliujue5300

最新推荐文章于 2024-04-24 09:47:33 发布

阅读量130

点赞数

3.rename_old_table
SET SERVEROUTPUT ON;
conn platform_dev/kingdee
SET SERVEROUTPUT ON;
show user;

alter table T_CORPORATION_BULLETIN rename to F_CORPORATION_BULLETIN;
alter table T_CORPORATION_BUSINESS_CARD rename to F_CORPORATION_BUSINESS_CARD;
alter table T_CORPORATION_CERTIFICATE rename to F_CORPORATION_CERTIFICATE;
alter table T_CORPORATION_KEYWORD rename to F_CORPORATION_KEYWORD;
alter table T_CORPORATION_LINKAGE rename to F_CORPORATION_LINKAGE;
alter table T_CORPORATION_MOBILE_KEYWORD rename to F_CORPORATION_MOBILE_KEYWORD;
alter table T_CORPORATION_PRODUCT rename to F_CORPORATION_PRODUCT;
alter table T_CORPORATION_RANK_IN_CATALOG rename to F_CORPORATION_RANK_IN_CATALOG;
alter table T_CORPORATION_RECOMMEND rename to F_CORPORATION_RECOMMEND;
alter table T_CORPORATION_SERVICE_SCOPE rename to F_CORPORATION_SERVICE_SCOPE;
alter table T_CORPORATION_STYLE. rename to F_CORPORATION_STYLE;
alter table T_CORPORATION_TRADE rename to F_CORPORATION_TRADE;
alter table T_DOMAIN_NAME rename to F_DOMAIN_NAME;
alter table T_FAVORITE rename to F_FAVORITE;
alter table T_PRODUCT rename to F_PRODUCT;
alter table T_PRODUCT_TYPE rename to F_PRODUCT_TYPE;
alter table T_RECOMMEND_INFO rename to F_RECOMMEND_INFO;
alter table T_PROVIDING_ESSENTIAL rename to F_PROVIDING_ESSENTIAL;
alter table T_PURCHASE_INFO rename to F_PURCHASE_INFO;
alter table T_PROVIDING_DETAIL rename to F_PROVIDING_DETAIL;
alter table T_PROVIDING_DESC rename to F_PROVIDING_DESC;
alter table T_PUBLISH_TASKS rename to F_PUBLISH_TASKS;
alter table T_RECOMMEND_COMPANY rename to F_RECOMMEND_COMPANY;
alter table T_SEARCH_LOGS rename to F_SEARCH_LOGS;
alter table T_CATALOG rename to F_CATALOG;
alter table T_CATALOG_HOT rename to F_CATALOG_HOT;
alter table T_GL_CASE rename to F_GL_CASE;
alter table T_GL_MESSAGE rename to F_GL_MESSAGE;
alter table T_GL_TEAM rename to F_GL_TEAM;
alter table T_GL_RECOMMEND_INFO rename to F_GL_RECOMMEND_INFO;
alter table T_GL_PERSON_EDUCATION_HISTORY rename to F_GL_PERSON_EDUCATION_HISTORY;
alter table T_GL_PERSON_WORK_HISTORY rename to F_GL_PERSON_WORK_HISTORY;
alter table T_GL_PRODUCT rename to F_GL_PRODUCT;
alter table T_OPERATION_LOG rename to F_OPERATION_LOG;
alter table T_SYS_EVENTLOG rename to F_SYS_EVENTLOG;

4.grant_to_platform

SET SERVEROUTPUT ON;
conn platform_b2b/kingdee
SET SERVEROUTPUT ON;
show user;

grant select,delete,insert,update on T_CORPORATION_BULLETIN to platform_dev;
grant select,delete,insert,update on T_CORPORATION_BUSINESS_CARD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_CERTIFICATE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_KEYWORD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_LINKAGE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_MOBILE_KEYWORD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_PRODUCT to platform_dev;
grant select,delete,insert,update on T_CORPORATION_RANK_IN_CATALOG to platform_dev;
grant select,delete,insert,update on T_CORPORATION_RECOMMEND to platform_dev;
grant select,delete,insert,update on T_CORPORATION_SERVICE_SCOPE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_STYLE. to platform_dev;
grant select,delete,insert,update on T_CORPORATION_TRADE to platform_dev;
grant select,delete,insert,update on T_DOMAIN_NAME to platform_dev;
grant select,delete,insert,update on T_FAVORITE to platform_dev;
grant select,delete,insert,update on T_PRODUCT to platform_dev;
grant select,delete,insert,update on T_PRODUCT_TYPE to platform_dev;
grant select,delete,insert,update on T_RECOMMEND_INFO to platform_dev;
grant select,delete,insert,update on T_PROVIDING_ESSENTIAL to platform_dev;
grant select,delete,insert,update on T_PURCHASE_INFO to platform_dev;
grant select,delete,insert,update on T_PROVIDING_DETAIL to platform_dev;
grant select,delete,insert,update on T_PROVIDING_DESC to platform_dev;
grant select,delete,insert,update on T_PUBLISH_TASKS to platform_dev;
grant select,delete,insert,update on T_RECOMMEND_COMPANY to platform_dev;
grant select,delete,insert,update on T_SEARCH_LOGS to platform_dev;
grant select,delete,insert,update on T_CATALOG to platform_dev;
grant select,delete,insert,update on T_CATALOG_HOT to platform_dev;
grant select,delete,insert,update on T_GL_CASE to platform_dev;
grant select,delete,insert,update on T_GL_MESSAGE to platform_dev;
grant select,delete,insert,update on T_GL_TEAM to platform_dev;
grant select,delete,insert,update on T_GL_RECOMMEND_INFO to platform_dev;
grant select,delete,insert,update on T_GL_PERSON_EDUCATION_HISTORY to platform_dev;
grant select,delete,insert,update on T_GL_PERSON_WORK_HISTORY to platform_dev;
grant select,delete,insert,update on T_GL_PRODUCT to platform_dev;
grant select,delete,insert,update on T_OPERATION_LOG to platform_dev;
grant select,delete,insert,update on T_SYS_EVENTLOG to platform_dev;

5.create_synonyn

SET SERVEROUTPUT ON;
conn platform_dev/kingdee
SET SERVEROUTPUT ON;
show user;

CREATE SYNONYM T_CORPORATION_BULLETIN FOR PLATFORM_B2B.T_CORPORATION_BULLETIN;
CREATE SYNONYM T_CORPORATION_BUSINESS_CARD FOR PLATFORM_B2B.T_CORPORATION_BUSINESS_CARD;
CREATE SYNONYM T_CORPORATION_CERTIFICATE FOR PLATFORM_B2B.T_CORPORATION_CERTIFICATE;
CREATE SYNONYM T_CORPORATION_KEYWORD FOR PLATFORM_B2B.T_CORPORATION_KEYWORD;
CREATE SYNONYM T_CORPORATION_LINKAGE FOR PLATFORM_B2B.T_CORPORATION_LINKAGE;
CREATE SYNONYM T_CORPORATION_MOBILE_KEYWORD FOR PLATFORM_B2B.T_CORPORATION_MOBILE_KEYWORD;
CREATE SYNONYM T_CORPORATION_PRODUCT FOR PLATFORM_B2B.T_CORPORATION_PRODUCT;
CREATE SYNONYM T_CORPORATION_RANK_IN_CATALOG FOR PLATFORM_B2B.T_CORPORATION_RANK_IN_CATALOG;
CREATE SYNONYM T_CORPORATION_RECOMMEND FOR PLATFORM_B2B.T_CORPORATION_RECOMMEND;
CREATE SYNONYM T_CORPORATION_SERVICE_SCOPE FOR PLATFORM_B2B.T_CORPORATION_SERVICE_SCOPE;
CREATE SYNONYM T_CORPORATION_STYLE. FOR PLATFORM_B2B.T_CORPORATION_STYLE;
CREATE SYNONYM T_CORPORATION_TRADE FOR PLATFORM_B2B.T_CORPORATION_TRADE;
CREATE SYNONYM T_DOMAIN_NAME FOR PLATFORM_B2B.T_DOMAIN_NAME;
CREATE SYNONYM T_FAVORITE FOR PLATFORM_B2B.T_FAVORITE;
CREATE SYNONYM T_PRODUCT FOR PLATFORM_B2B.T_PRODUCT;
CREATE SYNONYM T_PRODUCT_TYPE FOR PLATFORM_B2B.T_PRODUCT_TYPE;
CREATE SYNONYM T_RECOMMEND_INFO FOR PLATFORM_B2B.T_RECOMMEND_INFO;
CREATE SYNONYM T_PROVIDING_ESSENTIAL FOR PLATFORM_B2B.T_PROVIDING_ESSENTIAL;
CREATE SYNONYM T_PURCHASE_INFO FOR PLATFORM_B2B.T_PURCHASE_INFO;
CREATE SYNONYM T_PROVIDING_DETAIL FOR PLATFORM_B2B.T_PROVIDING_DETAIL;
CREATE SYNONYM T_PROVIDING_DESC FOR PLATFORM_B2B.T_PROVIDING_DESC;
CREATE SYNONYM T_PUBLISH_TASKS FOR PLATFORM_B2B.T_PUBLISH_TASKS;
CREATE SYNONYM T_RECOMMEND_COMPANY FOR PLATFORM_B2B.T_RECOMMEND_COMPANY;
CREATE SYNONYM T_SEARCH_LOGS FOR PLATFORM_B2B.T_SEARCH_LOGS;
CREATE SYNONYM T_CATALOG FOR PLATFORM_B2B.T_CATALOG;
CREATE SYNONYM T_CATALOG_HOT FOR PLATFORM_B2B.T_CATALOG_HOT;
CREATE SYNONYM T_GL_CASE FOR PLATFORM_B2B.T_GL_CASE;
CREATE SYNONYM T_GL_MESSAGE FOR PLATFORM_B2B.T_GL_MESSAGE;
CREATE SYNONYM T_GL_TEAM FOR PLATFORM_B2B.T_GL_TEAM;
CREATE SYNONYM T_GL_RECOMMEND_INFO FOR PLATFORM_B2B.T_GL_RECOMMEND_INFO;
CREATE SYNONYM T_GL_PERSON_EDUCATION_HISTORY FOR PLATFORM_B2B.T_GL_PERSON_EDUCATION_HISTORY;
CREATE SYNONYM T_GL_PERSON_WORK_HISTORY FOR PLATFORM_B2B.T_GL_PERSON_WORK_HISTORY;
CREATE SYNONYM T_GL_PRODUCT FOR PLATFORM_B2B.T_GL_PRODUCT;
CREATE SYNONYM T_OPERATION_LOG FOR PLATFORM_B2B.T_OPERATION_LOG;
CREATE SYNONYM T_SYS_EVENTLOG FOR PLATFORM_B2B.T_SYS_EVENTLOG;