9 lines
384 B
MySQL
9 lines
384 B
MySQL
|
ALTER TABLE vn.componentType
|
||
|
|
CHANGE code code varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL NULL AFTER id;
|
||
|
|
ALTER TABLE vn.componentType
|
||
|
|
CHANGE `type` name varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL;
|
||
|
|
UPDATE IGNORE vn.componentType
|
||
|
|
SET code = LOWER(code);
|
||
|
|
UPDATE IGNORE vn.componentType
|
||
|
|
SET code = 'other'
|
||
|
|
WHERE id = 12;
|