ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
## <span style="color: red">!!注意:数据迁移过程中,不要登录系统,迁移完成再登录;</span> ``` ``` #### **【注意】微擎版根目录下的uploads文件迁移到独立版根目录下;** <span style="padding-left:67px">**1、微擎版根目录:/www/wwwroot/项目目录/addons/worldidc_scrm/scrm/public;**</span> <span style="padding-left:67px">**2、独立版根目录:/www/wwwroot/项目目录/public;**</span> ![](https://img.kancloud.cn/75/a4/75a4d99ff5a8fe1787dc2808bd191a15_1893x877.png) ![](https://img.kancloud.cn/72/b8/72b85a442851f3eb842e200d9b21f6fd_1884x801.png) </br><span style="color: red">**1、选择微擎数据库,点管理,查看crm的数据库;**</span>​ ![](https://img.kancloud.cn/c1/b6/c1b608f48b6c61d375f4334f29238b7b_1913x921.png) ​<br/><span style="color: red">**2、微擎版SCRM数据表导出方式选择:自定义;如下图,将scrm开头的表除了scrm\_node表全部勾选;**</span> <span style="color: red">**【注意】导出微擎数据库的时候不要选中scrm\_node表;**</span> ![](https://img.kancloud.cn/bf/ef/bfef9f192ca774e96afd36974a2ea05a_1820x936.png) ![](https://img.kancloud.cn/b7/39/b73921644120f607c1eac4b7e27925fa_1652x847.png) ​<br/>**3、新建的独立版数据库清空掉除了【scrm\_node】表的数据;** <span style="color: red">**【注意】清空独立版数据库的时候,不要清空【scrm\_node】表;**</span> ![](https://img.kancloud.cn/fc/3d/fc3de2d9963a32e13d25b2abcd6078c3_1900x929.png) ​<br/><span style="color: red">**4、选择安装独立版的数据库,点管理,查看crm数据库,点导入;**</span> #### 选择上一步导出的文件,「执行」导入即可; ![](https://img.kancloud.cn/f7/1d/f71d790d0f0434fe6c152e2fdde05b9c_1680x900.png) ​<br/><span style="color: red">**5、独立版数据库导入数据完成后,执行如下SQL语句;**</span> **【登陆独立版SCRM后台注意项】** **<span style="color: red">1、没有迁移微擎版SCRM数据库到独立版,独立版默认的系统登录账号密码:admin  123456</span>** **<span style="color: red">2、已迁移微擎版SCRM数据库到独立版:</span>**      (1)没有执行下面的数据库语句,除微擎总管理员账号密码,其他的微擎操作员账号密码都可以登录;</span>      (2)执行了下面的数据库语句,独立版默认的系统登录账号密码:admin  123456</span> <br>**以下是执行语句,语句较长,请复制完整;** ``` delete FROM `scrm_department_worker` where account='admin'; INSERT INTO `scrm_department_worker` (`account`,`password`,`user_name`,`department_num`,`state`,`role_id`,`customer_id`,`user_num`) VALUES ("admin","$2y$10$PFZIP.w797UC/5OJLRd6Y.Dfa2e0x5H.wHIlkbG809hBsbvfcuxM2","admin","world_1","1","99999",1,"world_1"); update `scrm_role` set `node_info` = '[{\"id\":44},{\"id\":45},{\"id\":304},{\"id\":46},{\"id\":47},{\"id\":48},{\"id\":49},{\"id\":50},{\"id\":51},{\"id\":52},{\"id\":53},{\"id\":54},{\"id\":55},{\"id\":56},{\"id\":57},{\"id\":58},{\"id\":59},{\"id\":60},{\"id\":61},{\"id\":62},{\"id\":63},{\"id\":64},{\"id\":65},{\"id\":66},{\"id\":67},{\"id\":68},{\"id\":69},{\"id\":70},{\"id\":71},{\"id\":74},{\"id\":75},{\"id\":76},{\"id\":77},{\"id\":78},{\"id\":79},{\"id\":81},{\"id\":82},{\"id\":83},{\"id\":84},{\"id\":85},{\"id\":86},{\"id\":87},{\"id\":88},{\"id\":89},{\"id\":90},{\"id\":92},{\"id\":93},{\"id\":94},{\"id\":95},{\"id\":96},{\"id\":97},{\"id\":98},{\"id\":99},{\"id\":100},{\"id\":101},{\"id\":102},{\"id\":124},{\"id\":125},{\"id\":163},{\"id\":164},{\"id\":165},{\"id\":166},{\"id\":167},{\"id\":168},{\"id\":169},{\"id\":170},{\"id\":171},{\"id\":173},{\"id\":174},{\"id\":175},{\"id\":176},{\"id\":177},{\"id\":178},{\"id\":179},{\"id\":180},{\"id\":181},{\"id\":182},{\"id\":184},{\"id\":185},{\"id\":186},{\"id\":187},{\"id\":188},{\"id\":189},{\"id\":190},{\"id\":191},{\"id\":192},{\"id\":193},{\"id\":194},{\"id\":195},{\"id\":196},{\"id\":197},{\"id\":198},{\"id\":199},{\"id\":200},{\"id\":201},{\"id\":202},{\"id\":203},{\"id\":204},{\"id\":205},{\"id\":206},{\"id\":207},{\"id\":208},{\"id\":209},{\"id\":210},{\"id\":211},{\"id\":212},{\"id\":213},{\"id\":214},{\"id\":215},{\"id\":216},{\"id\":217},{\"id\":218},{\"id\":219},{\"id\":220},{\"id\":221},{\"id\":222},{\"id\":223},{\"id\":224},{\"id\":225},{\"id\":226},{\"id\":227},{\"id\":228},{\"id\":229},{\"id\":230},{\"id\":231},{\"id\":232},{\"id\":233},{\"id\":234},{\"id\":235},{\"id\":236},{\"id\":237},{\"id\":238},{\"id\":239},{\"id\":240},{\"id\":241},{\"id\":242},{\"id\":243},{\"id\":244},{\"id\":245},{\"id\":246},{\"id\":247},{\"id\":248},{\"id\":249},{\"id\":250},{\"id\":251},{\"id\":252},{\"id\":253},{\"id\":254},{\"id\":255},{\"id\":256},{\"id\":257},{\"id\":258},{\"id\":259},{\"id\":260},{\"id\":261},{\"id\":262},{\"id\":263},{\"id\":264},{\"id\":265},{\"id\":266},{\"id\":267},{\"id\":268},{\"id\":269},{\"id\":270},{\"id\":271},{\"id\":272},{\"id\":273},{\"id\":274},{\"id\":275},{\"id\":276},{\"id\":277},{\"id\":278},{\"id\":279},{\"id\":280},{\"id\":281},{\"id\":282},{\"id\":283},{\"id\":284},{\"id\":285},{\"id\":286},{\"id\":287},{\"id\":288},{\"id\":289},{\"id\":290},{\"id\":291},{\"id\":292},{\"id\":293},{\"id\":294},{\"id\":295},{\"id\":296},{\"id\":297},{\"id\":298},{\"id\":299},{\"id\":300},{\"id\":301},{\"id\":302},{\"id\":303},{\"id\":305},{\"id\":308},{\"id\":309},{\"id\":310},{\"id\":311},{\"id\":312},{\"id\":314},{\"id\":315},{\"id\":316},{\"id\":317},{\"id\":318},{\"id\":319},{\"id\":320},{\"id\":321},{\"id\":322},{\"id\":323},{\"id\":324},{\"id\":325},{\"id\":326},{\"id\":327},{\"id\":328},{\"id\":329},{\"id\":330},{\"id\":331},{\"id\":332},{\"id\":333},{\"id\":334},{\"id\":335},{\"id\":336},{\"id\":337},{\"id\":338},{\"id\":339},{\"id\":340},{\"id\":341},{\"id\":342},{\"id\":343},{\"id\":344},{\"id\":345},{\"id\":346},{\"id\":347},{\"id\":364},{\"id\":365},{\"id\":366},{\"id\":367},{\"id\":370},{\"id\":371},{\"id\":372},{\"id\":373},{\"id\":374},{\"id\":375},{\"id\":376},{\"id\":377},{\"id\":378},{\"id\":379},{\"id\":380},{\"id\":381},{\"id\":382},{\"id\":383},{\"id\":384},{\"id\":385},{\"id\":386},{\"id\":387},{\"id\":388},{\"id\":389},{\"id\":390},{\"id\":391},{\"id\":392},{\"id\":393},{\"id\":394},{\"id\":395},{\"id\":396},{\"id\":397},{\"id\":398},{\"id\":399},{\"id\":400},{\"id\":401},{\"id\":402},{\"id\":403},{\"id\":404},{\"id\":405},{\"id\":406},{\"id\":407},{\"id\":408},{\"id\":409},{\"id\":410},{\"id\":411}]' where is_sys_role=1; ``` ![](https://img.kancloud.cn/3b/36/3b360b8670e998980f25a9b720b727e3_1908x566.png)