CREATE TABLE `workorder_status` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` VARCHAR(4) NOT NULL,
  `description` VARCHAR(200) DEFAULT NULL,
  `initial` BIT(1) NOT NULL,
  `final` BIT(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_code` (`code`)
) ENGINE=INNODB
;

INSERT INTO workorder_status(`code`, description, initial, final)
VALUES
('0', 'Started', 1, 0),
('1', 'Created', 0, 0),
('4', 'Canceled',0, 1),
('5', 'Finished', 0, 1)
;

UPDATE `workorders` w 
JOIN `dblocations` l
	ON l.`id` = w.`iddblocation`
SET w.code = CONCAT(l.`code`, '-', RIGHT(CONCAT('00000000', w.`id`), 8))
WHERE IFNULL(w.code, '') = ''
;

SELECT 
CONCAT( (SELECT l.code FROM  dblocations l WHERE l.id = 1), '-',
 RIGHT( CONCAT('00000000',
 IFNULL(CONVERT(RIGHT(MAX(w.`code`), 8), DECIMAL(8,0)), 0) + 1 
 ),8)
 ) `code`
FROM `workorders` w WHERE w.iddblocation = 1
