INSERT INTO `role_permissions` (`role_id`, `menu`, `component`, `permission`, `created_at`, `updated_at`) VALUES
(2, 'ordercolletion', 'cliente_cancelar_solicitacao_coleta', 1, '2021-10-27 20:21:19', '2021-10-27 20:21:19'),
(13, 'ordercolletion', 'cliente_cancelar_solicitacao_coleta', 1, '2021-10-27 20:27:55', '2021-10-27 20:27:55');

INSERT INTO `role_permissions` (`role_id`, `menu`, `component`, `permission`, `created_at`, `updated_at`) VALUES
(1, 'ordercolletion', 'upload_arquivos', 1, '2021-10-27 20:21:19', '2021-10-27 20:21:19'),
(2, 'ordercollection', 'upload_arquivos', 1, '2021-10-27 20:27:55', '2021-10-27 20:27:55'),
(13, 'ordercollection', 'upload_arquivos', 1, '2021-10-27 20:21:19', '2021-10-27 20:21:19'),
(14, 'ordercollection', 'upload_arquivos', 1, '2021-10-27 20:27:55', '2021-10-27 20:27:55');

INSERT INTO `role_permissions` (`role_id`, `menu`, `component`, `permission`, `created_at`, `updated_at`) VALUES
(1, 'ordercollection', 'visualizacao_arquivos', 1, '2021-10-27 20:21:19', '2021-10-27 20:21:19'),
(2, 'ordercollection', 'visualizacao_arquivos', 1, '2021-10-27 20:27:55', '2021-10-27 20:27:55'),
(13, 'ordercollection', 'visualizacao_arquivos', 1, '2021-10-27 20:21:19', '2021-10-27 20:21:19'),
(14, 'ordercollection', 'visualizacao_arquivos', 1, '2021-10-27 20:27:55', '2021-10-27 20:27:55');

CREATE TABLE colletion_request_files (
  id int(11) NOT NULL AUTO_INCREMENT,
  colletion_request_id int(11) NOT NULL,
  path varchar(255) NOT NULL,
  name varchar(255) NOT NULL,
  title varchar(255) NOT NULL,
  created_at datetime NOT NULL,
  updated_at datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `colletion_request_files`
ADD CONSTRAINT `colletion_request_files_ibfk_1` FOREIGN KEY (`colletion_request_id`) REFERENCES `colletion_request` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;