--
-- Create table `module_helpdesk_quiz_cat`
--
DROP TABLE IF EXISTS `module_helpdesk_tickets_cat`;
CREATE TABLE `module_helpdesk_tickets_cat` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `default` tinyint(1) DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `title` VARCHAR(100),
    `description` VARCHAR(200) ,
    `icon` VARCHAR(100), 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB  AUTO_INCREMENT=1  DEFAULT CHARSET=utf8; 


DROP TABLE IF EXISTS `module_helpdesk_tickets_priority`;
CREATE TABLE `module_helpdesk_tickets_priority` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `default` tinyint(1) DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `name` VARCHAR(100),
   PRIMARY KEY (`id`)
) ENGINE=InnoDB  AUTO_INCREMENT=1  DEFAULT CHARSET=utf8; 


ALTER TABLE `module_helpdesk_tickets_priority` 
ADD COLUMN `sorder` INT NULL AFTER `name`;



DROP TABLE IF EXISTS `module_helpdesk_tickets_treatment_type`;
CREATE TABLE `module_helpdesk_tickets_treatment_type` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `default` tinyint(1) DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `name` VARCHAR(100),
   PRIMARY KEY (`id`)
) ENGINE=InnoDB  AUTO_INCREMENT=1  DEFAULT CHARSET=utf8; 


ALTER TABLE `module_helpdesk_tickets_treatment_type` 
ADD COLUMN `sorder` INT NULL AFTER `name`;




DROP TABLE IF EXISTS `module_helpdesk_tickets`;
CREATE TABLE `module_helpdesk_tickets` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `default` tinyint(1) DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `requester_id` int(11) ,
    `client_id` int(11) ,
    `product_cat_id` int(11) ,
    `product_id` int(11) ,
    `responsible_id` int(11) ,
    `module_helpdesk_tickets_treatment_type_id` int(11) ,
    `status` ENUM('Open','Closed') ,
    `module_helpdesk_tickets_priority_id` int(11) ,
    `description` mediumtext, 
     module_helpdesk_tickets_cat_id int,
   PRIMARY KEY (`id`)
)  ENGINE=InnoDB  AUTO_INCREMENT=1  DEFAULT CHARSET=utf8; 



CREATE TABLE `module_helpdesk_tickets_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `src` varchar(100) DEFAULT NULL,
  `name` text DEFAULT NULL,
  `module_helpdesk_tickets_id` int(11) DEFAULT NULL,
  user_id  int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

ALTER TABLE `module_helpdesk_tickets` 
CHANGE COLUMN `status` `status` ENUM('Open', 'Closed', 'Atendence') NULL DEFAULT NULL ;


ALTER TABLE `module_helpdesk_tickets` 
CHANGE COLUMN `default` `deleted_at` TIMESTAMP NULL DEFAULT NULL ;



DELETE FROM `module_helpdesk_tickets_priority` WHERE `id`>='1';
INSERT INTO `module_helpdesk_tickets_priority` (`id`, `default`, `name`) VALUES ('1', '1','module_helpdesk priority Functional');
INSERT INTO `module_helpdesk_tickets_priority` (`id`, `default`, `name`) VALUES ('2', '1', 'module_helpdesk priority Partially stopped');
INSERT INTO `module_helpdesk_tickets_priority` (`id`, `default`, `name`) VALUES ('3', '1', 'module_helpdesk priority Stopped');


CREATE TABLE `module_helpdesk_tickets_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_cat_id` int(11) ,
  `product_id` int(11) ,
  `module_helpdesk_tickets_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;


ALTER TABLE `module_helpdesk_tickets` 
DROP COLUMN `product_id`,
DROP COLUMN `product_cat_id`;


DELETE FROM `module_helpdesk_tickets_treatment_type` WHERE `id`>='1';
INSERT INTO `module_helpdesk_tickets_treatment_type` (`id`, `default`, `name`) VALUES ('1', '1', 'module_helpdesk type remote');
INSERT INTO `module_helpdesk_tickets_treatment_type` (`id`, `default`, `name`) VALUES ('2', '1', 'module_helpdesk type presential');
INSERT INTO `module_helpdesk_tickets_treatment_type` (`id`, `default`, `name`) VALUES ('3', '1', 'module_helpdesk send equipament');

ALTER TABLE `module_helpdesk_tickets` 
ADD COLUMN `treatment_type_local` VARCHAR(45) NULL;

CREATE TABLE `module_helpdesk_tickets_type_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `src` varchar(100) DEFAULT NULL,
  `name` text DEFAULT NULL,
  `module_helpdesk_tickets_id` int(11) DEFAULT NULL,
  user_id  int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;