INSERT INTO `oneyn_system`.`pmc_common_dic` (
`DIC_ID`,
`DIC_PID`,
`DICATEGORY_CODE`,
`DIC_CODE`,
`DIC_NAME`,
`DIC_REMARK`,
`DIC_SORT`,
`DIC_ENABLE`,
`COMPANY_ID`,
`PROJECT_ID`,
`DIC_EXT1`,
`DIC_EXT2`,
`DIC_EXT3`,
`DIC_EXT4`,
`DIC_EXT5`,
`DIC_EXT6`
) SELECT
UUID( ),
`DIC_PID`,
`DICATEGORY_CODE`,
`DIC_CODE`,
`DIC_NAME`,
`DIC_REMARK`,
`DIC_SORT`,
`DIC_ENABLE`,
`COMPANY_ID`,
'037eba3b10a947f9b3034cfa64289e63',
`DIC_EXT1`,
`DIC_EXT2`,
`DIC_EXT3`,
`DIC_EXT4`,
`DIC_EXT5`,
`DIC_EXT6`
FROM
`pmc_common_dic`
WHERE
PROJECT_ID = 'f52e367b34104eaf954c5652522ebccd'
AND COMPANY_ID = '084931cc8405470383e3f4e5bca5bb0d'
AND ( DICATEGORY_CODE = 'PIPE_TECH_MEDIUM' OR DICATEGORY_CODE = 'PIPE_MRANK' )