START TRANSACTION;

CREATE TABLE `tbltickets_status_static` (
  `ticketstatusid` bigint(20) UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL,
  `name` varchar(50) NOT NULL,
  `isdefault` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `statuscolor` varchar(7) DEFAULT NULL,
  `statusorder` bigint(20) UNSIGNED DEFAULT NULL
);

INSERT INTO `tbltickets_status_static` (`ticketstatusid`, `name`, `isdefault`, `statuscolor`, `statusorder`) VALUES
(1, 'Open', 1, '#ff2d42', 1),
(2, 'In progress', 1, '#84c529', 2),
(3, 'Answered', 1, '#0000ff', 3),
(4, 'On Hold', 1, '#c0c0c0', 4),
(5, 'Closed', 1, '#03a9f4', 5);

COMMIT;