27 lines
1.9 KiB
MySQL
27 lines
1.9 KiB
MySQL
|
ALTER TABLE vn.claimResponsible ADD code varchar(3) NOT NULL;
|
||
|
|
|
||
|
|
UPDATE vn.claimResponsible SET code='buy' WHERE `description` = "Compradores";
|
||
|
|
UPDATE vn.claimResponsible SET code='sup' WHERE `description` = "Proveedor";
|
||
|
|
UPDATE vn.claimResponsible SET code='ent' WHERE `description` = "Entradores";
|
||
|
|
UPDATE vn.claimResponsible SET code='bar' WHERE `description` = "Camareros";
|
||
|
|
UPDATE vn.claimResponsible SET code='pic' WHERE `description` = "Sacadores";
|
||
|
|
UPDATE vn.claimResponsible SET code='chk' WHERE `description` = "Revisadores";
|
||
|
|
UPDATE vn.claimResponsible SET code='qas' WHERE `description` = "Calidad general";
|
||
|
|
UPDATE vn.claimResponsible SET code='pck' WHERE `description` = "Encajadores";
|
||
|
|
UPDATE vn.claimResponsible SET code='wea' WHERE `description` = "Clima";
|
||
|
|
UPDATE vn.claimResponsible SET code='com' WHERE `description` = "Comerciales";
|
||
|
|
UPDATE vn.claimResponsible SET code='cli' WHERE `description` = "Clientes";
|
||
|
|
UPDATE vn.claimResponsible SET code='adm' WHERE `description` = "Administración";
|
||
|
|
UPDATE vn.claimResponsible SET code='age' WHERE `description` = "Agencia";
|
||
|
|
UPDATE vn.claimResponsible SET code='del' WHERE `description` = "Repartidores";
|
||
|
|
UPDATE vn.claimResponsible SET code='ite' WHERE `description` = "Informatica";
|
||
|
|
UPDATE vn.claimResponsible SET code='tra' WHERE `description` = "Transp.origen";
|
||
|
|
UPDATE vn.claimResponsible SET code='con' WHERE `description` = "Confeccion";
|
||
|
|
UPDATE vn.claimResponsible SET code='oth' WHERE `description` = "OTROS";
|
||
|
|
UPDATE vn.claimResponsible SET code='man' WHERE `description` = "Gerencia";
|
||
|
|
UPDATE vn.claimResponsible SET code='pal' WHERE `description` = "Paletizadores";
|
||
|
|
UPDATE vn.claimResponsible SET code='pre' WHERE `description` = "Preparación Previa";
|
||
|
|
UPDATE vn.claimResponsible SET code='war' WHERE `description` = "Almacén PCA";
|
||
|
|
UPDATE vn.claimResponsible SET code='str' WHERE `description` = "Huelga";
|
||
|
|
|
||
|
|
ALTER TABLE vn.claimResponsible ADD CONSTRAINT claimResponsible_UN UNIQUE KEY (code);
|