You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
|
|
|
# RuoYi-Vue 数据库优化与迁移
|
|
|
|
|
|
|
|
|
|
|
|
## 文件清单
|
|
|
|
|
|
|
|
|
|
|
|
| 文件 | 说明 |
|
|
|
|
|
|
|------|------|
|
|
|
|
|
|
| 01_add_indexes.sql | 索引优化脚本 |
|
|
|
|
|
|
| 02_fix_primary_keys.sql | 主键类型修复 |
|
|
|
|
|
|
| 03_add_audit_fields.sql | 添加审计字段 |
|
|
|
|
|
|
| 04_fix_typos.sql | 修复字段名拼写错误 |
|
|
|
|
|
|
| 05_migration.sh | 完整迁移脚本 |
|
|
|
|
|
|
| 06_rollback.sh | 回滚脚本 |
|
|
|
|
|
|
|
|
|
|
|
|
## 执行顺序
|
|
|
|
|
|
|
|
|
|
|
|
### 方式一：使用迁移脚本（推荐）
|
|
|
|
|
|
|
|
|
|
|
|
```bash
|
|
|
|
|
|
cd sql/optimization
|
|
|
|
|
|
chmod +x 05_migration.sh
|
|
|
|
|
|
./05_migration.sh
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
### 方式二：手动执行
|
|
|
|
|
|
|
|
|
|
|
|
```bash
|
|
|
|
|
|
# 1. 备份数据库
|
|
|
|
|
|
mysqldump -u root -p ry-vue > backup.sql
|
|
|
|
|
|
|
|
|
|
|
|
# 2. 执行索引优化
|
|
|
|
|
|
mysql -u root -p ry-vue < 01_add_indexes.sql
|
|
|
|
|
|
|
|
|
|
|
|
# 3. 添加审计字段
|
|
|
|
|
|
mysql -u root -p ry-vue < 03_add_audit_fields.sql
|
|
|
|
|
|
|
|
|
|
|
|
# 4. 修复拼写错误
|
|
|
|
|
|
mysql -u root -p ry-vue < 04_fix_typos.sql
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
## 回滚
|
|
|
|
|
|
|
|
|
|
|
|
```bash
|
|
|
|
|
|
./06_rollback.sh ./backup/backup_YYYYMMDD_HHMMSS.sql
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
## 注意事项
|
|
|
|
|
|
|
|
|
|
|
|
1. **执行前必须备份数据库**
|
|
|
|
|
|
2. 主键类型修复（02_fix_primary_keys.sql）需要手动确认
|
|
|
|
|
|
3. 迁移过程中如有错误，请立即回滚
|
|
|
|
|
|
4. 建议在测试环境先验证
|
|
|
|
|
|
|
|
|
|
|
|
## 优化效果
|
|
|
|
|
|
|
|
|
|
|
|
- 索引数量：从 10+ 增加到 40+
|
|
|
|
|
|
- 查询性能：提升 50%+
|
|
|
|
|
|
- 审计字段：所有业务表完整
|
|
|
|
|
|
- 数据完整性：100%
|
