RECHARGE_DETAIL_ZZB_W18_UPDATE.sql 1.19 KB
ALTER TABLE lecuntao.`cus_recharge_detail`
ADD COLUMN `DATE_ID`  bigint(20) NULL COMMENT '日期转化的8位数字' AFTER `RECHARGE_STATUS`;

ALTER TABLE lecuntao.`cus_get_cashlist`
ADD COLUMN `DATE_ID`  bigint(20) NULL COMMENT 'paymentTime转化的8位日期' AFTER `FAIL_REASON`;

ALTER TABLE lecuntao.`cus_pd_detail`
ADD COLUMN `DATE_ID`  bigint(20) NULL COMMENT '变更时间转成8位数字' AFTER `SUMMARY`;

ALTER TABLE lecuntao.`cus_vourcher_detail`
ADD COLUMN `DATE_ID`  bigint(20) NULL COMMENT 'USER_TIME转化的8位纯数字' AFTER `SUMMARY`;

ALTER TABLE lecuntao.`cus_points_detail`
ADD COLUMN `DATE_ID`  bigint(20) NULL COMMENT '日期转化的8位数字' AFTER `SUMMARY`;
-------------------------------------------添加索引-------------------------------------------
ALTER TABLE membership.mem_member ADD INDEX SOURCE_ID (SOURCE_ID);
ALTER TABLE lecuntao.cus_recharge_detail  ADD INDEX MEMBER_ID (MEMBER_ID);
ALTER TABLE lecuntao.cus_get_cashlist  ADD INDEX MEMBER_ID (MEMBER_ID);
ALTER TABLE lecuntao.cus_pd_detail   ADD INDEX MEMBER_ID (MEMBER_ID);
ALTER TABLE lecuntao.cus_vourcher_detail ADD INDEX MEMBER_ID (MEMBER_ID);
ALTER TABLE lecuntao.cus_points_detail ADD INDEX MEMBER_ID (MEMBER_ID);