-- 在报价单表中添加报价主体字段 ALTER TABLE `crm_quote` ADD COLUMN `supplier_id` bigint(20) DEFAULT NULL COMMENT '报价主体ID(关联crm_supplier_info表)' AFTER `owner_user_name`, ADD COLUMN `supplier_name` varchar(200) DEFAULT NULL COMMENT '报价主体名称(冗余字段)' AFTER `supplier_id`, ADD KEY `idx_supplier_id` (`supplier_id`);