129fa20810
- company-info.md：环境与 hapr191 配置要点 - company-data-imgration.md：库清理规则与保留用户范围 Made-with: Cursor
36 lines
1000 B
Markdown
36 lines
1000 B
Markdown
|
||
# 公司名称：淮安鹏然商贸
|
||
|
||
## mysql数据库配置信息
|
||
|
||
host ip: 114.55.232.191
|
||
datasource:
|
||
name: yangtangyoupin
|
||
username: yangtangyoupin
|
||
password: 5Fn8eWrbYFtAhCZw
|
||
|
||
## 数据删除任务
|
||
|
||
- 保留的**用户数据范围**：wa_users.id in (91956,92474,92540,92824,93208,92576,92809,93182,92905,93080,93099,93113,93132,93164,93133,93142,93194,93204,93111,93139,93100,93158,93161,93163,93176,92476,93123,93108,93193,93165,93162,93159)，删除其余用户数据
|
||
|
||
- wa_order
|
||
只保留“created_at >= 2026-03-31”并且user_id在用户数据范围的订单，删除其余数据
|
||
|
||
- wa_merchandise
|
||
只保留“created_at >= 2026-03-31”并且seller_id或buyer_id在用户数据范围的寄售商品，删除其余数据
|
||
|
||
|
||
- wa_selfbonus_log
|
||
|
||
- wa_sharebonus_log
|
||
|
||
|
||
|
||
- wa_coupon_log
|
||
|
||
- 新建hapr191分支，合并shjjy153分支的最新代码到该分支，并根据上述信息修改相关需要变更项，使符合该新公司项目环境
|
||
|
||
## 相关文件
|
||
|
||
- company-info.md
|