ALTER TABLE `dblocations`   
  ADD COLUMN `status` ENUM('active','inactive') NOT NULL DEFAULT 'active';
ALTER TABLE `aboutus`   
  ADD COLUMN `status` ENUM('active','inactive') NOT NULL DEFAULT 'active';
ALTER TABLE `devicetypes`   
  ADD COLUMN `status` ENUM('active','inactive') NOT NULL DEFAULT 'active';

ALTER TABLE `dblocations`   
  DROP INDEX `ix_code`,
  ADD  UNIQUE INDEX `ix_code` (`code`);
  
 ALTER TABLE `dblocations`  ENGINE=INNODB;
ALTER TABLE `aboutus`  ENGINE=INNODB;
ALTER TABLE `devicetypes`  ENGINE=INNODB;
ALTER TABLE `user`  ENGINE=INNODB;
ALTER TABLE `workorders`  ENGINE=INNODB;

ALTER TABLE `workorders`
ADD  CONSTRAINT `fk_workorder_aboutus` FOREIGN KEY (`idaboutus`) REFERENCES `aboutus` (`id`),
ADD  CONSTRAINT `fk_workorder_dblocation` FOREIGN KEY (`iddblocation`) REFERENCES `dblocations` (`id`),
ADD  CONSTRAINT `fk_workorder_devicetype` FOREIGN KEY (`iddevicetype`) REFERENCES `devicetypes` (`id`);