update_issue_codes.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 75 行

update it_issue
set project_id = 'SFA';

update it_issue
set system_id = 'SALES_INFO'
where it_issue.system_id = '100';

update it_issue
set system_id = 'INT_COMP'
where it_issue.system_id = '110';

update it_issue
set system_id = 'EXT_INT'
where it_issue.system_id = '120';

update it_issue
set system_id = 'GEN'
where it_issue.system_id = '130';

update it_issue
set procedure_id = 'ACCOUNTS'
where procedure_id = '100';

update it_issue
set procedure_id = 'ADMINISTRATION'
where procedure_id = '150';

update it_issue
set procedure_id = 'CONTACTS'
where procedure_id = '110';

update it_issue
set procedure_id = 'DASHBOARD'
where procedure_id = '160';

update it_issue
set procedure_id = 'EMP_RANK'
where procedure_id = '200';

update it_issue
set procedure_id = 'EMP_REC'
where procedure_id = '220';

update it_issue
set procedure_id = 'EMP_REV'
where procedure_id = '210';

update it_issue
set procedure_id = 'FORECASTS'
where procedure_id = '140';

update it_issue
set procedure_id = 'GENERAL_PROC'
where procedure_id = '240';

update it_issue
set procedure_id = 'GEN_PROC'
where procedure_id = '170';

update it_issue
set procedure_id = 'ISSUE_TRACKER'
where procedure_id = '250';

update it_issue
set procedure_id = 'LEAD_SOURCE'
where procedure_id = '230';

update it_issue
set procedure_id = 'OPPORTUNITIES'
where procedure_id = '120';

update it_issue
set procedure_id = 'QUOTA_BUILDER'
where procedure_id = '180';