# 更新员工表结构，添加description字段
|
Write-Host "开始更新员工表结构..."
|
|
# 显示需要执行的SQL语句
|
Write-Host "需要执行以下SQL语句来添加description字段："
|
Write-Host "================================"
|
if (Test-Path "add_description_column.sql") {
|
Get-Content "add_description_column.sql"
|
} else {
|
Write-Host "USE ryc;"
|
Write-Host "ALTER TABLE t_employee ADD COLUMN description varchar(255) AFTER role_code;"
|
Write-Host "DESCRIBE t_employee;"
|
}
|
Write-Host "================================"
|
|
Write-Host ""
|
Write-Host "由于MySQL连接器不可用，请手动执行上述SQL语句。"
|
Write-Host "您可以使用MySQL Workbench、phpMyAdmin或其他数据库管理工具。"
|
