Domovská stránka Prehľadávať Pomoc
Registrovať Prihlásiť sa
lizhenghang
/
dev
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 4f971b3fae
Branche Tagy
dev
/
2020
/
2020-011(OK)
/
2020-011-wh-001.sql

2020-011-wh-001.sql 3.3 KB
História Raw

123456789101112 
  1. use dcp;
    2. 

  2. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='UNIT_COUNTRY_DICT'),'ӡ��','india','215','Y','','1',now(),'1',now() FROM DUAL);
    3. 

  3. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='UNIT_COUNTRY_DICT'),'�յ�','sudan','216','Y','','1',now(),'1',now() FROM DUAL); 
    4. 

  4. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='UNIT_COUNTRY_DICT'),'���','myanmar','217','Y','','1',now(),'1',now() FROM DUAL); 
    5. 

  5. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='UNIT_COUNTRY_DICT'),'�չ�(��)','congo (drc)','218','Y','','1',now(),'1',now() FROM DUAL); 
    6. 

  6. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='UNIT_COUNTRY_DICT'),'�չ�(��)','republic of congo','219','Y','','1',now(),'1',now() FROM DUAL); 
    7. 

  7. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='unit_country_dict_en'),'India','india','215','Y','','1',now(),'1',now() FROM DUAL); 
    8. 

  8. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='unit_country_dict_en'),'Sudan','sudan','216','Y','','1',now(),'1',now() FROM DUAL); 
    9. 

  9. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='unit_country_dict_en'),'Myanmar','myanmar','217','Y','','1',now(),'1',now() FROM DUAL); 
    10. 

  10. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='unit_country_dict_en'),'Congo (DRC)','congo (drc)','218','Y','','1',now(),'1',now() FROM DUAL); 
    11. 

  11. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='unit_country_dict_en'),'Republic of Congo','republic of congo','219','Y','','1',now(),'1',now() FROM DUAL); 
    12. 

  12. /*  2020-10-23 已在生产环境执行 */
    13.