forked from Gitlink/microservices
25 lines
656 B
SQL
25 lines
656 B
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
#将文章排序值更新为id
|
|
update `ruoyi-gitlink`.cms_doc
|
|
set sort=id;
|
|
#将合作伙伴排序值更新为id
|
|
update `ruoyi-gitlink`.zone_partners
|
|
set sort=id;
|
|
#将会员排序值更新为id
|
|
update `ruoyi-gitlink`.zone_member
|
|
set sort=id;
|
|
#将会员身份排序值更新为id
|
|
update `ruoyi-gitlink`.zone_member_level
|
|
set sort=id;
|
|
#将会员身份分类排序值更新为id
|
|
update `ruoyi-gitlink`.zone_member_type
|
|
set sort=id;
|
|
#将项目分类排序值更新为id
|
|
update `ruoyi-gitlink`.zone_project_type
|
|
set sort=id;
|
|
#将项目排序值更新为id
|
|
update `ruoyi-gitlink`.zone_project
|
|
set sort=id;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |