24 lines
775 B
MySQL
24 lines
775 B
MySQL
|
-- =====================================================
|
|||
|
|
-- 数据库回滚脚本：normaltemperature表移除联络单号和件号字段
|
|||
|
|
-- 创建时间：2026-02-04
|
|||
|
|
-- 说明：如果升级出现问题，使用此脚本回滚
|
|||
|
|
-- =====================================================
|
|||
|
|
|
|||
|
|
USE fullautowaterpressure;
|
|||
|
|
|
|||
|
|
-- 1. 删除索引
|
|||
|
|
DROP INDEX IF EXISTS `idx_contact_number` ON `normaltemperature`;
|
|||
|
|
DROP INDEX IF EXISTS `idx_item_number` ON `normaltemperature`;
|
|||
|
|
|
|||
|
|
-- 2. 删除新增字段
|
|||
|
|
ALTER TABLE `normaltemperature`
|
|||
|
|
DROP COLUMN IF EXISTS `ContactNumber`,
|
|||
|
|
DROP COLUMN IF EXISTS `ItemNumber`;
|
|||
|
|
|
|||
|
|
-- 3. 验证回滚
|
|||
|
|
DESCRIBE normaltemperature;
|
|||
|
|
|
|||
|
|
-- =====================================================
|
|||
|
|
-- 回滚完成
|
|||
|
|
-- =====================================================
|