code-role_type_sfa.sql

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

-- 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 (
  'ROLE_TYPE_SFA'
 ,'Role Type - SFA'
 ,'Role Types for SFA Application'
 ,''
 ,'Y'
 ,''
 ,'2002-11-30 00:00:00.0'
 ,'10060'
 ,'2002-12-11 16:43:24.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 (
  'ROLE_TYPE_SFA'
 ,'SFA_ADMIN'
 ,''
 ,'Administrator'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,'2002-11-30 00:00:00.0'
 ,'10060'
 ,'2002-12-11 15:19:19.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 (
  'ROLE_TYPE_SFA'
 ,'SFA_LEADS_ADMIN'
 ,''
 ,'Leads Administrator'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,'2002-11-30 00:00:00.0'
 ,'10060'
 ,'2002-12-11 15:20:29.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 (
  'ROLE_TYPE_SFA'
 ,'SFA_LEADS_USER'
 ,''
 ,'Leads User'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,'2002-11-30 00:00:00.0'
 ,'10060'
 ,'2002-12-11 15:20:39.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 (
  'ROLE_TYPE_SFA'
 ,'SFA_USER'
 ,''
 ,'User'
 ,''
 ,''
 ,'Y'
 ,'Y'
 ,''
 ,''
 ,'10060'
 ,'2002-12-11 21:26:53.0'
);