19 lines
479 B
SQL
Executable File
19 lines
479 B
SQL
Executable File
-- 回滚：删除管理员表的医生相关字段
|
|
-- 警告：执行此脚本将删除这些字段的所有数据
|
|
|
|
-- 删除索引
|
|
ALTER TABLE `zyt_admin` DROP INDEX `idx_phone`;
|
|
ALTER TABLE `zyt_admin` DROP INDEX `idx_gender`;
|
|
|
|
-- 删除字段
|
|
ALTER TABLE `zyt_admin`
|
|
DROP COLUMN `gender`,
|
|
DROP COLUMN `age`,
|
|
DROP COLUMN `phone`,
|
|
DROP COLUMN `title`,
|
|
DROP COLUMN `department`,
|
|
DROP COLUMN `specialty`,
|
|
DROP COLUMN `education`,
|
|
DROP COLUMN `experience`,
|
|
DROP COLUMN `honors`;
|