shanxia/crm/sql/add_contract_template_field.sql

-- 添加合同模版字段
ALTER TABLE crm_contract ADD COLUMN contract_template VARCHAR(50) DEFAULT 'shanxia' COMMENT '合同模版(shanxia-山峡模版/customer-客户模版)' AFTER template_id;

-- 插入字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES (NEXT VALUE FOR sys_dict_type_seq, '000000', '合同模版', 'crm_contract_template', 103, 1, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, '合同模版字典');

-- 插入字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES 
(NEXT VALUE FOR sys_dict_data_seq, '000000', 1, '山峡模版', 'shanxia', 'crm_contract_template', '', 'primary', 'Y', 103, 1, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, '使用山峡标准合同模版'),
(NEXT VALUE FOR sys_dict_data_seq, '000000', 2, '客户模版', 'customer', 'crm_contract_template', '', 'info', 'N', 103, 1, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, '使用客户提供的合同模版');