16 lines
629 B
MySQL
16 lines
629 B
MySQL
|
START TRANSACTION;
|
||
|
|
|
||
|
|
SET @isTriggerDisabled = TRUE;
|
||
|
|
|
||
|
|
ALTER TABLE vn.buy ADD groupingMode2 enum('grouping', 'packing') DEFAULT NULL NULL;
|
||
|
|
ALTER TABLE vn.buy CHANGE groupingMode2 groupingMode2 enum('grouping', 'packing') DEFAULT NULL NULL AFTER groupingMode;
|
||
|
|
|
||
|
|
UPDATE vn.buy SET groupingMode2 = 'packing' WHERE groupingMode = 2;
|
||
|
|
UPDATE vn.buy SET groupingMode2 = 'grouping' WHERE groupingMode = 1;
|
||
|
|
|
||
|
|
ALTER TABLE vn.buy DROP COLUMN groupingMode;
|
||
|
|
ALTER TABLE vn.buy CHANGE groupingMode2 groupingMode enum('grouping','packing') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL NULL;
|
||
|
|
|
||
|
|
SET @isTriggerDisabled = FALSE;
|
||
|
|
|
||
|
|
COMMIT;
|