20260107_recycle.sql 687 B

1234567891011
  1. ALTER TABLE `cif`.`c_user`
  2. ADD COLUMN `total_number_of_win` int NOT NULL DEFAULT 0 COMMENT '总中奖次数' AFTER `has_order`,
  3. ADD COLUMN `total_number_of_recycle` INT NOT NULL DEFAULT 0 COMMENT '总回收次数' AFTER `total_number_of_win`;
  4. INSERT INTO operating.o_config (id,parent_id,name,code,viwe_type,value_info,seq)
  5. VALUES (36,NULL,'订单回收比例','recycle_proportion',1,'0.8',1);
  6. INSERT INTO operating.o_config (id,parent_id,name,code,viwe_type,value_info,seq)
  7. VALUES (37,NULL,'成功订单总数','success_total_order_num',1,'6',1);
  8. INSERT INTO operating.o_config (id,parent_id,name,code,viwe_type,value_info,seq)
  9. VALUES (38,NULL,'回收数量','recycle_num',1,'5',1);