ESON墨西哥所有菜單同步昆山廠 SQL

DELETE FROM DB_ESMX.BAS.DOMAIN_INFO;
INSERT INTO DB_ESMX.BAS.DOMAIN_INFO SELECT * FROM DB_ESON.BAS.DOMAIN_INFO;

 

DELETE FROM DB_ESMX.BAS.PACKAGE_INFO;
INSERT INTO DB_ESMX.BAS.PACKAGE_INFO SELECT * FROM DB_ESON.BAS.PACKAGE_INFO;

 

DELETE FROM DB_ESMX.BAS.PROGRAM_INFO;
INSERT INTO DB_ESMX.BAS.PROGRAM_INFO SELECT * FROM DB_ESON.BAS.PROGRAM_INFO;

 

DELETE FROM BAS.ROLE_USER WHERE ROLE_ID = 0 AND USER_ID < 10;
INSERT INTO BAS.ROLE_USER SELECT 0,USER_ID,'S',0,GETDATE() FROM BAS.USER_INFO WHERE USER_ID<10

 

DELETE FROM BAS.ROLE_DOMAIN WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_DOMAIN SELECT 0,DOMAIN_NO,'S',0,GETDATE() FROM BAS.DOMAIN_INFO;

 

DELETE FROM BAS.ROLE_PACK WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_PACK SELECT 0,PACK_NO,'S',0,GETDATE() FROM BAS.PACKAGE_INFO;

 

DELETE FROM BAS.ROLE_PROGRAM WHERE ROLE_ID = 0;
INSERT INTO BAS.ROLE_PROGRAM SELECT 0,PRO_NO,-1,'S',0,GETDATE() FROM BAS.PROGRAM_INFO;

 

DELETE FROM BAS.USER_PROGRAM WHERE USER_ID < 10;
INSERT INTO BAS.USER_PROGRAM SELECT USER_ID,PRO_NO,-1,'S',0,GETDATE() FROM BAS.PROGRAM_INFO,BAS.USER_INFO WHERE USER_ID<10;