code-opp_team_member_role.sql

国外的一套开源CRM

-- Insert CodeType
INSERT INTO CODE_TYPE (
  CODE_TYPE_ID
 ,CODE_TYPE_NAME
 ,CODE_TYPE_DESCRIPTION
 ,PARENT_CODE_TYPE_ID
 ,IS_VISIBLE
 ,CREATED_BY
 ,CREATED_DATE
 ,MODIFIED_BY
 ,MODIFIED_DATE
) VALUES (
  'OPP_TEAM_MEMBER_ROLE'
 ,'Opportunity Team Member Role'
 ,'The possible roles that can be assigned to an opportunity team member on the Opportunity Team tab.'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
);

-- Insert Code
INSERT INTO CODE (
  CODE_TYPE_ID
 ,CODE_ID
 ,CODE_DESCRIPTION
 ,CODE_VALUE
 ,PARENT_CODE_TYPE_ID
 ,PARENT_CODE_ID
 ,IS_VISIBLE
 ,IS_ACTIVE
 ,CREATED_BY
 ,CREATED_DATE
 ,MODIFIED_BY
 ,MODIFIED_DATE
) VALUES (
  'OPP_TEAM_MEMBER_ROLE'
 ,'BD'
 ,''
 ,'Business Development'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,''
 ,'10181'
 ,'2002-05-10 12:25:09.0'
);

-- Insert Code
INSERT INTO CODE (
  CODE_TYPE_ID
 ,CODE_ID
 ,CODE_DESCRIPTION
 ,CODE_VALUE
 ,PARENT_CODE_TYPE_ID
 ,PARENT_CODE_ID
 ,IS_VISIBLE
 ,IS_ACTIVE
 ,CREATED_BY
 ,CREATED_DATE
 ,MODIFIED_BY
 ,MODIFIED_DATE
) VALUES (
  'OPP_TEAM_MEMBER_ROLE'
 ,'PS'
 ,''
 ,'Pre-Sales'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,''
 ,'10181'
 ,'2002-05-10 12:29:36.0'
);

-- Insert Code
INSERT INTO CODE (
  CODE_TYPE_ID
 ,CODE_ID
 ,CODE_DESCRIPTION
 ,CODE_VALUE
 ,PARENT_CODE_TYPE_ID
 ,PARENT_CODE_ID
 ,IS_VISIBLE
 ,IS_ACTIVE
 ,CREATED_BY
 ,CREATED_DATE
 ,MODIFIED_BY
 ,MODIFIED_DATE
) VALUES (
  'OPP_TEAM_MEMBER_ROLE'
 ,'S'
 ,''
 ,'Sales'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,''
 ,'10181'
 ,'2002-05-10 12:25:23.0'
);