From e9b8b4aafd5fa32f9e2ba186403783b711e86417 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期四, 27 八月 2026 17:07:37 +0800 Subject: [PATCH] docs: 记录数据库合并（同事全表导出导入，admin 密码恢复，MySQL8 客户端提醒） --- HANDOFF.md | 23 ++++++++++++++++------- 1 files changed, 16 insertions(+), 7 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 22e33a0..4660e1d 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -3,12 +3,21 @@ > **鐢ㄦ硶**锛氭柊瀵硅瘽寮�濮嬪悗锛屽厛璇绘湰鏂囦欢 + 椤圭洰鏍圭洰褰� `AGENTS.md`锛屽嵆鍙棤缂濇帴鍔涖�� > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� -## 涓�銆佸綋鍓嶇姸鎬侊紙2026-08-27 鍚堝苟鍚庯級 -- 鍓嶅悗绔�**杩愯涓�**锛�8090/8080 宸茬洃鍚紝start-dev.ps1 鍚姩锛夛紝鐧诲綍椤靛凡鎺ュ叆鐪熷疄璁よ瘉锛堟暟鎹簱鏍￠獙锛�+ 琛屼负楠岃瘉鐮併�� +## 涓�銆佸綋鍓嶇姸鎬侊紙2026-08-27 鍚堝苟鍚庯紝鎵撳寘閮ㄧ讲宸插畬鎴愶級 +- **寮�鍙戞湇鍔″凡鍋滄**锛堝墠鍚庣鍧囨湭杩愯锛夛紝鎵撳寘鐗堟祴璇�**楠屾敹閫氳繃**銆� +- **鎵撳寘閮ㄧ讲鏂规锛堝凡瀹氱锛�**锛歋pring Boot 鐩存帴鎵樼鍓嶇闈欐�佹枃浠讹紝鍗曠鍙� 8090锛�**涓嶉渶瑕� IIS/nginx**銆� + 閮ㄧ讲缁撴瀯 = jar 鍚岀骇 `web\`锛堝墠绔� dist 鍐呭锛�+ `docs\`锛堟ā鏉跨洰褰曪級锛沗java -jar app.jar` 鍚姩鍚庤闂� `http://<鏈嶅姟鍣�>:8090`銆� + 璇存槑鏂囨。锛歚docs/鎵撳寘閮ㄧ讲璇存槑.md` / `.docx`锛堝惈 nginx 澶囬�夋柟妗堛�両IS 鍙嶄唬绀轰緥 `docs/iis-web.config.example`锛夈�� +- **鏁版嵁搴撳凡鍚堝苟锛�2026-08-27 鏅氾級**锛氬悓浜� Navicat 鍏ㄨ〃瀵煎嚭 `traffic_audit.sql`锛�27 琛ㄣ�佺害 6 涓囪锛屾潵鑷叾 mysql80:3308锛夊凡鍏ㄩ噺瀵煎叆鏈満搴擄紙MySQL 8.0.29锛宭ocalhost:3305锛宺oot/root锛夈�� + 瀵煎叆鍓嶅凡澶囦唤鏈満搴� 鈫� `D:\03_鍏徃\02_椤圭洰\27_婀栧寳鐪侀亾璺繍杈撲簨涓氬彂灞曚腑蹇僜05_寮�鍙戞祴璇昞00_寮�鍙慭_db_backup_20260827.sql`銆� + `sys_user` 鐜版湁 4 璐﹀彿锛坅dmin + zhangsan/lisi/wangwu锛屽潎甯� modules锛夛紱admin 瀵嗙爜宸叉仮澶嶄负 BCrypt锛坅dmin/admin123锛夛紝鍏朵綑璐﹀彿瀵嗙爜涓哄悓浜嬪師 hash銆� + 鈿狅笍 **MySQL 瀹㈡埛绔敤 8.0**锛坄C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe`锛夛紝涓嶈鐢� 5.7 瀹㈡埛绔紙`D:\mysql\mysql-5.7.41-winx64`锛夈�� +- 鏈閰嶅鏀瑰姩锛歚SecurityConfig` 鏀捐闈欐�佽祫婧愶紙`/`銆乣/js/**` 绛夛級+ `application.yml` 鍔� + `spring.web.resources.static-locations: file:./web/`锛坅pplication.yml 涓嶅叆搴擄紝閲嶆墦鍖呮椂闇�淇濈暀璇ラ厤缃級銆� - **2026-08-27 瀹屾垚鍙屾柟寮�鍙戠粨鏋滃悎骞�**锛氫互瀵规柟锛堥儜鐜夋磥锛屽彟涓�寮�鍙戜汉鍛橈級鐨勪唬鐮佷负鍩虹锛屽苟鍏ユ垜鏂逛笁鏍锋敼鍔� 锛堟�佸娍鍥�/AI鍔╂墜鏋勬兂璁板綍銆佺櫥褰曡涓洪獙璇佺爜銆佺櫥鍑轰笌涓婁笅甯冨眬锛夈�傞獙璇佺爜閲囩敤**鎴戞柟瀹炵幇**锛圕aptcha3D + 鍚庣 captcha 鍖咃紝 鍐呭瓨瀛樺偍锛屾棤 Redis 渚濊禆锛夛紝瀵规柟鐙珛瀹炵幇鐨� ShapeCaptcha锛圕anvas+Redis锛夊凡寮冪敤銆佷笉鍏ュ簱銆� -- 鏂� git 浠撳簱杩佺Щ杩涜涓細鏃� Gitee 浠撳簱寮冪敤锛屽悎骞剁粨鏋滃皢鎻愪氦鍒版柊浠撳簱锛堝湴鍧�瑙佺涔濊妭锛屽緟鐢ㄦ埛鎻愪緵鍚庤ˉ鍏級銆� +- 鏂� git 浠撳簱杩佺Щ**宸插畬鎴�**锛氬悎骞剁粨鏋滃凡鎻愪氦鍒� Gitblit 鏍逛粨搴� `trafficAudit.git`锛堣绗節鑺傦級锛屾棫 Gitee 浠撳簱寮冪敤锛沗~xyc/trafficAudit.git` 涓存椂浠撳簱宸插垹銆� - 鏁版嵁搴撳凡琛ラ綈瀵规柟鏂板琛紙MySQL 8锛屽簱 traffic_audit锛屾湰鏈� 3305锛夛細h2031_enterprise_monthly銆乸assenger_*銆� h204_*銆乮nvestment_*銆乧ity_bus_monthly銆乧ity_taxi_monthly銆乧ity_taxi_auth銆乸assenger_individual_monthly銆乤udit_run锛� sys_user 宸插姞 modules 鍒楋紱admin 瀵嗙爜宸查噸缃负 BCrypt锛坅dmin/admin123锛夈�� @@ -74,10 +83,10 @@ 3. 璺ㄩ」鐩彲澶嶇敤缁忛獙娌夋穩鍒版満鍣ㄧ骇椤跺眰 AGENTS.md锛堟湰椤圭洰涓嶅啀閲嶅锛夈�� ## 涔濄�丟it 浠撳簱锛�2026-08-27 璧蜂娇鐢ㄦ柊浠撳簱 Gitblit锛� - **鏂颁粨搴擄紙鍦ㄧ敤锛�**锛欸itblit 鏈嶅姟鍣� `61.183.254.94:3000`锛圚TTP锛夛紝浠撳簱 **`trafficAudit.git`**锛堟牴鐩綍鍛藉悕绌洪棿锛岄潪 `~xyc/` 涓汉绌洪棿锛夈�� - - 鎺ㄩ�佸湴鍧�锛歚http://admin@61.183.254.94:3000/r/trafficAudit.git`锛堣处鍙� `admin`锛屽瘑鐮佸凡瀛樻湰鏈� GCM 鍑嵁绠＄悊鍣紝鐩存帴 `git push` 鍗冲彲锛夈�� - - 璇存槑锛氭牴浠撳簱鍘熺敱绠＄悊鍛樻寔鏈夛紝`xyc` 鏃犳帹閫佹潈闄愶紙`creation prohibited`锛夛紝鏁呮棩甯告帹閫佺敤 `admin`锛涘鍚庣画瑕佹敼鐢� `xyc`锛岄渶绠＄悊鍛樺湪 Gitblit Web锛坔ttp://61.183.254.94:3000锛夌粰璇ヤ粨搴撴坊鍔� xyc 鐨� RW+ 鏉冮檺銆� - - 鏃х殑 `~xyc/trafficAudit.git` 涓汉浠撳簱浠嶅湪鏈嶅姟鍣ㄤ笂锛堝凡寮冪敤锛屾湭鍒犻櫎锛夈�� - - 鏈満 remote锛歚origin` = HTTPS锛堟棩甯告帹閫佺敤锛夛紱`ssh-alt` = SSH 鍦板潃锛堝鐢級銆� + - 鎺ㄩ�佸湴鍧�锛歚http://xyc@61.183.254.94:3000/r/trafficAudit.git`锛堣处鍙� `xyc` 瀵嗙爜 `gitP@ssw0rd`锛屽凡瀛樻湰鏈� GCM 鍑嵁绠＄悊鍣紝鐩存帴 `git push` 鍗冲彲锛夈�� + - 璇存槑锛氱鐞嗗憳宸插湪 Gitblit Web锛坔ttp://61.183.254.94:3000锛夌粰 `xyc` 鎺堟潈璇ヤ粨搴撴帹閫侊紙RW+锛夛紝2026-08-27 宸查獙璇� `xyc` 鎺ㄩ�佹垚鍔燂紱鏃ュ父鎺ㄩ�佺敤 `xyc`銆� + - 鏃х殑 `~xyc/trafficAudit.git` 涓汉浠撳簱宸插垹闄わ紙2026-08-27锛宎dmin 鍦� Web 缂栬緫椤靛垹闄わ級銆� + - 鏈満 remote锛氫粎 `origin` = `http://xyc@61.183.254.94:3000/r/trafficAudit.git`锛堜笉鐢� SSH锛宻sh-alt 宸插垹锛夈�� - **鏃т粨搴擄紙寮冪敤锛�**锛欸itee https://gitee.com/jichengxiong/trafficAudit锛�2026-08-14 寤虹珛锛夆�斺�斾笉鍐嶄娇鐢紝鏈啀鎺ㄩ�併�� - 鍚堝苟鍘嗗彶锛歮ain 鍒嗘敮 = 鍘熷巻鍙� + 鎴戞柟 08-27 鎻愪氦锛坄715e9e1`锛�+ 瀵规柟寮�鍙戠粨鏋滃垎鏀紙`f713166`锛宲artner-work锛�+ 鍚堝苟鎻愪氦 `ec9b25a`锛涘鏂规湭鐢� git锛屽叾浠ｇ爜缁忕嫭绔嬪垎鏀悎鍏ャ�� - 鏁忔劅閰嶇疆涓嶅叆搴擄細`traffic-audit-server/src/main/resources/application.yml` 宸插湪 `.gitignore` 涓紝 -- Gitblit v1.9.1