9 lines
907 B
MySQL
9 lines
907 B
MySQL
|
UPDATE bs.clientDied SET Aviso='first' WHERE Aviso like 'Primer Aviso';
|
||
|
|
UPDATE bs.clientDied SET Aviso='second' WHERE Aviso like 'Segundo Aviso';
|
||
|
|
UPDATE bs.clientDied SET Aviso='third' WHERE Aviso like 'Tercer Aviso';
|
||
|
|
|
||
|
|
ALTER TABLE bs.clientDied CHANGE id clientFk int(11) DEFAULT 0 NOT NULL;
|
||
|
|
ALTER TABLE bs.clientDied CHANGE Aviso warning ENUM('first', 'second','third') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL NULL;
|
||
|
|
ALTER TABLE bs.clientDied CHANGE workerCode workerCode__ varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '@deprecated 2023-10-15';
|
||
|
|
ALTER TABLE bs.clientDied CHANGE clientName clientName__ varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '@deprecated 2023-10-15';
|
||
|
|
ALTER TABLE bs.clientDied CHANGE Boss Boss__ varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '@deprecated 2023-10-15';
|