text: -- phpMyAdmin SQL Dump
  -- version 4.6.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: basalto08.bireme.br
  -- Tempo de geração: 11/08/2016 às 13:43
  -- Versão do servidor: 5.7.13-0ubuntu0.16.04.2-log
  -- Versão do PHP: 5.6.23-2+deb.sury.org~precise+1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Banco de dados: `proethos_cst`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `configuration`
  --
  
  DROP TABLE IF EXISTS `configuration`;
  CREATE TABLE `configuration` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `value` longtext COLLATE utf8_unicode_ci,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `document`
  --
  
  DROP TABLE IF EXISTS `document`;
  CREATE TABLE `document` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `status` tinyint(1) NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext COLLATE utf8_unicode_ci NOT NULL,
    `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `filepath` varchar(1023) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `document_role`
  --
  
  DROP TABLE IF EXISTS `document_role`;
  CREATE TABLE `document_role` (
    `document_id` int(11) NOT NULL,
    `role_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `ext_translations`
  --
  
  DROP TABLE IF EXISTS `ext_translations`;
  CREATE TABLE `ext_translations` (
    `id` int(11) NOT NULL,
    `locale` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
    `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `field` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
    `foreign_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
    `content` longtext COLLATE utf8_unicode_ci
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `faq`
  --
  
  DROP TABLE IF EXISTS `faq`;
  CREATE TABLE `faq` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `status` tinyint(1) NOT NULL,
    `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `answer` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `help`
  --
  
  DROP TABLE IF EXISTS `help`;
  CREATE TABLE `help` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `status` tinyint(1) NOT NULL,
    `message` longtext COLLATE utf8_unicode_ci
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `help`
  --
  
  REPLACE INTO `help` (`id`, `created`, `updated`, `status`, `message`) VALUES
  (1, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (2, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (3, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (4, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (5, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (6, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (7, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (8, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (9, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (10, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (11, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (12, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (13, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 1, 'Is this submission a clinical trial?'),
  (14, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 1, 'Scientific title of the protocol'),
  (15, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 1, 'Public title of the protocolo'),
  (16, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 1, 'Does this protocol have an acronym?'),
  (17, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (18, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (19, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (20, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (21, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (22, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (23, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (24, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (25, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (26, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (27, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (28, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (29, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (30, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (31, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (32, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (33, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (34, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (35, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (36, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (37, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (38, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (39, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (40, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (41, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (42, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (43, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (44, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (45, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (46, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (47, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (48, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (49, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (50, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (51, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (52, '2016-06-16 14:11:28', '2016-06-16 14:11:28', 0, NULL),
  (53, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (54, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (55, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (56, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (57, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (58, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (59, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (60, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (61, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (62, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (63, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (64, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (65, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (66, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (67, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (68, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (69, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (70, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (71, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (72, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 1, 'Search for protocols by ID number, key word or investigator\'s name'),
  (73, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 1, 'Protocolo status'),
  (74, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (75, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (76, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (77, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (78, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (79, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (80, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (81, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (82, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (83, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (84, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (85, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (86, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (87, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (88, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (89, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (90, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (91, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (92, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (93, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (94, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (95, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (96, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (97, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (98, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (99, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (100, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (101, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (102, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (103, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (104, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (105, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (106, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (107, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (108, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (109, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (110, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (111, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (112, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (113, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (114, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (115, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (116, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (117, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (118, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (119, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (120, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (121, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (122, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (123, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (124, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (125, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (126, '2016-06-16 14:11:29', '2016-06-16 14:11:29', 0, NULL),
  (127, '2016-06-16 14:11:30', '2016-06-16 14:11:30', 0, NULL),
  (128, '2016-06-16 14:11:30', '2016-06-16 14:11:30', 0, NULL),
  (129, '2016-06-16 14:11:30', '2016-06-16 14:11:30', 0, NULL),
  (130, '2016-06-18 13:18:21', '2016-06-18 13:18:21', 0, NULL),
  (131, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (132, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (133, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (134, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (135, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (136, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (137, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (138, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (139, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (140, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (141, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (142, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (143, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (144, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (145, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (146, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (147, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (148, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (149, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (150, '2016-08-03 13:43:13', '2016-08-03 13:43:13', 0, NULL),
  (151, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (152, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (153, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (154, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (155, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (156, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (157, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (158, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (159, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (160, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (161, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (162, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (163, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (164, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (165, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (166, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (167, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (168, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (169, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (170, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (171, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (172, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (173, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (174, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (175, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (176, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (177, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (178, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (179, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (180, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (181, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (182, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (183, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (184, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL),
  (185, '2016-08-03 13:43:14', '2016-08-03 13:43:14', 0, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_clinical_trial_name`
  --
  
  DROP TABLE IF EXISTS `list_clinical_trial_name`;
  CREATE TABLE `list_clinical_trial_name` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_clinical_trial_name`
  --
  
  REPLACE INTO `list_clinical_trial_name` (`id`, `created`, `updated`, `name`, `slug`, `status`, `code`) VALUES
  (1, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Australian New Zealand Clinical Trials Registry', 'australian-new-zeland-clinical-trials-registry', 1, 'ANZCTR'),
  (2, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Chinese Clinical Trial Registry', 'chinese-clinical-trial-registry', 1, 'ChiCTR'),
  (3, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Clinical Trials Registry - India', 'clinical-trials-registry-india', 1, 'CTRI'),
  (4, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Clinical Trials.gov', 'clinical-trials-gov', 1, ''),
  (5, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Cuban Public Registry of Clinical Trials', 'cuban-public-registry-of-clinical-trials', 1, 'RPCEC'),
  (6, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'EU Clinical Trials Register', 'eu-clinical-trials-register', 1, ''),
  (7, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'German Clinical Trials Register', 'german-clinical-trials-register', 1, 'DRKS'),
  (8, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'International Standard Randomised Controlled Trial Number', 'ineternational-standard-randomised-controlled-trial-number', 1, 'ISRCTN.org'),
  (9, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Iranian Registry of Clinical Trials', 'iranian-registry-of-clinical-trials', 1, 'IRCT'),
  (10, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Japan Primary Registries Network', 'japan-primary-registries-network', 1, 'JPRN'),
  (11, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Netherlands National Trial Register', 'netherlands-national-trial-register', 1, 'NTR'),
  (12, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Pan African Clinical Trial Registry', 'pan-african-clinical-trial-registry', 1, 'PACTR'),
  (13, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Registro Brasileiro de Ensaios Clínicos', 'registro-brasileiro-de-ensaios-clínicos', 1, 'Rebec'),
  (14, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Registro Peruano de Ensayos Clínicos', 'registro-reruano-de-ensayos-clínicos', 1, 'REPEC'),
  (15, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Sri Lanka Clinical Trials Registry', 'sri-lanka-clinical-trials-registry', 1, 'SLCTR'),
  (16, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Universal Trial Number', 'universal-trial-number', 1, 'UTN');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_country`
  --
  
  DROP TABLE IF EXISTS `list_country`;
  CREATE TABLE `list_country` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_country`
  --
  
  REPLACE INTO `list_country` (`id`, `created`, `updated`, `code`, `name`) VALUES
  (1, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AF', 'Afghanistan'),
  (2, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AX', 'Åland Islands'),
  (3, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AL', 'Albania'),
  (4, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DZ', 'Algeria'),
  (5, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AS', 'American Samoa'),
  (6, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AD', 'Andorra'),
  (7, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AO', 'Angola'),
  (8, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AI', 'Anguilla'),
  (9, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AQ', 'Antarctica'),
  (10, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AG', 'Antigua & Barbuda'),
  (11, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AR', 'Argentina'),
  (12, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AM', 'Armenia'),
  (13, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AW', 'Aruba'),
  (14, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AC', 'Ascension Island'),
  (15, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AU', 'Australia'),
  (16, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AT', 'Austria'),
  (17, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AZ', 'Azerbaijan'),
  (18, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BS', 'Bahamas'),
  (19, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BH', 'Bahrain'),
  (20, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BD', 'Bangladesh'),
  (21, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BB', 'Barbados'),
  (22, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BY', 'Belarus'),
  (23, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BE', 'Belgium'),
  (24, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BZ', 'Belize'),
  (25, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BJ', 'Benin'),
  (26, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BM', 'Bermuda'),
  (27, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BT', 'Bhutan'),
  (28, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BO', 'Bolivia'),
  (29, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BA', 'Bosnia & Herzegovina'),
  (30, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BW', 'Botswana'),
  (31, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BR', 'Brazil'),
  (32, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IO', 'British Indian Ocean Territory'),
  (33, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VG', 'British Virgin Islands'),
  (34, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BN', 'Brunei'),
  (35, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BG', 'Bulgaria'),
  (36, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BF', 'Burkina Faso'),
  (37, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BI', 'Burundi'),
  (38, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KH', 'Cambodia'),
  (39, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CM', 'Cameroon'),
  (40, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CA', 'Canada'),
  (41, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IC', 'Canary Islands'),
  (42, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CV', 'Cape Verde'),
  (43, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BQ', 'Caribbean Netherlands'),
  (44, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KY', 'Cayman Islands'),
  (45, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CF', 'Central African Republic'),
  (46, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'EA', 'Ceuta & Melilla'),
  (47, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TD', 'Chad'),
  (48, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CL', 'Chile'),
  (49, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CN', 'China'),
  (50, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CX', 'Christmas Island'),
  (51, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CC', 'Cocos (Keeling) Islands'),
  (52, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CO', 'Colombia'),
  (53, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KM', 'Comoros'),
  (54, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CG', 'Congo - Brazzaville'),
  (55, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CD', 'Congo - Kinshasa'),
  (56, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CK', 'Cook Islands'),
  (57, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CR', 'Costa Rica'),
  (58, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CI', 'Côte d’Ivoire'),
  (59, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'HR', 'Croatia'),
  (60, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CU', 'Cuba'),
  (61, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CW', 'Curaçao'),
  (62, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CY', 'Cyprus'),
  (63, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CZ', 'Czech Republic'),
  (64, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DK', 'Denmark'),
  (65, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DG', 'Diego Garcia'),
  (66, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DJ', 'Djibouti'),
  (67, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DM', 'Dominica'),
  (68, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DO', 'Dominican Republic'),
  (69, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'EC', 'Ecuador'),
  (70, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'EG', 'Egypt'),
  (71, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SV', 'El Salvador'),
  (72, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GQ', 'Equatorial Guinea'),
  (73, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ER', 'Eritrea'),
  (74, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'EE', 'Estonia'),
  (75, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ET', 'Ethiopia'),
  (76, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FK', 'Falkland Islands'),
  (77, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FO', 'Faroe Islands'),
  (78, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FJ', 'Fiji'),
  (79, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FI', 'Finland'),
  (80, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FR', 'France'),
  (81, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GF', 'French Guiana'),
  (82, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PF', 'French Polynesia'),
  (83, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TF', 'French Southern Territories'),
  (84, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GA', 'Gabon'),
  (85, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GM', 'Gambia'),
  (86, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GE', 'Georgia'),
  (87, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'DE', 'Germany'),
  (88, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GH', 'Ghana'),
  (89, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GI', 'Gibraltar'),
  (90, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GR', 'Greece'),
  (91, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GL', 'Greenland'),
  (92, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GD', 'Grenada'),
  (93, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GP', 'Guadeloupe'),
  (94, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GU', 'Guam'),
  (95, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GT', 'Guatemala'),
  (96, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GG', 'Guernsey'),
  (97, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GN', 'Guinea'),
  (98, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GW', 'Guinea-Bissau'),
  (99, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GY', 'Guyana'),
  (100, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'HT', 'Haiti'),
  (101, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'HN', 'Honduras'),
  (102, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'HK', 'Hong Kong SAR China'),
  (103, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'HU', 'Hungary'),
  (104, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IS', 'Iceland'),
  (105, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IN', 'India'),
  (106, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ID', 'Indonesia'),
  (107, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IR', 'Iran'),
  (108, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IQ', 'Iraq'),
  (109, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IE', 'Ireland'),
  (110, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IM', 'Isle of Man'),
  (111, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IL', 'Israel'),
  (112, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'IT', 'Italy'),
  (113, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'JM', 'Jamaica'),
  (114, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'JP', 'Japan'),
  (115, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'JE', 'Jersey'),
  (116, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'JO', 'Jordan'),
  (117, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KZ', 'Kazakhstan'),
  (118, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KE', 'Kenya'),
  (119, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KI', 'Kiribati'),
  (120, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'XK', 'Kosovo'),
  (121, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KW', 'Kuwait'),
  (122, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KG', 'Kyrgyzstan'),
  (123, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LA', 'Laos'),
  (124, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LV', 'Latvia'),
  (125, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LB', 'Lebanon'),
  (126, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LS', 'Lesotho'),
  (127, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LR', 'Liberia'),
  (128, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LY', 'Libya'),
  (129, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LI', 'Liechtenstein'),
  (130, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LT', 'Lithuania'),
  (131, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LU', 'Luxembourg'),
  (132, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MO', 'Macau SAR China'),
  (133, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MK', 'Macedonia'),
  (134, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MG', 'Madagascar'),
  (135, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MW', 'Malawi'),
  (136, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MY', 'Malaysia'),
  (137, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MV', 'Maldives'),
  (138, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ML', 'Mali'),
  (139, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MT', 'Malta'),
  (140, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MH', 'Marshall Islands'),
  (141, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MQ', 'Martinique'),
  (142, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MR', 'Mauritania'),
  (143, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MU', 'Mauritius'),
  (144, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'YT', 'Mayotte'),
  (145, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MX', 'Mexico'),
  (146, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'FM', 'Micronesia'),
  (147, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MD', 'Moldova'),
  (148, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MC', 'Monaco'),
  (149, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MN', 'Mongolia'),
  (150, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ME', 'Montenegro'),
  (151, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MS', 'Montserrat'),
  (152, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MA', 'Morocco'),
  (153, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MZ', 'Mozambique'),
  (154, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MM', 'Myanmar (Burma)'),
  (155, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NA', 'Namibia'),
  (156, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NR', 'Nauru'),
  (157, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NP', 'Nepal'),
  (158, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NL', 'Netherlands'),
  (159, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NC', 'New Caledonia'),
  (160, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NZ', 'New Zealand'),
  (161, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NI', 'Nicaragua'),
  (162, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NE', 'Niger'),
  (163, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NG', 'Nigeria'),
  (164, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NU', 'Niue'),
  (165, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NF', 'Norfolk Island'),
  (166, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KP', 'North Korea'),
  (167, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MP', 'Northern Mariana Islands'),
  (168, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'NO', 'Norway'),
  (169, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'OM', 'Oman'),
  (170, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PK', 'Pakistan'),
  (171, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PW', 'Palau'),
  (172, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PS', 'Palestinian Territories'),
  (173, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PA', 'Panama'),
  (174, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PG', 'Papua New Guinea'),
  (175, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PY', 'Paraguay'),
  (176, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PE', 'Peru'),
  (177, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PH', 'Philippines'),
  (178, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PN', 'Pitcairn Islands'),
  (179, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PL', 'Poland'),
  (180, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PT', 'Portugal'),
  (181, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PR', 'Puerto Rico'),
  (182, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'QA', 'Qatar'),
  (183, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'RE', 'Réunion'),
  (184, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'RO', 'Romania'),
  (185, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'RU', 'Russia'),
  (186, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'RW', 'Rwanda'),
  (187, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'WS', 'Samoa'),
  (188, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SM', 'San Marino'),
  (189, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ST', 'São Tomé & Príncipe'),
  (190, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SA', 'Saudi Arabia'),
  (191, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SN', 'Senegal'),
  (192, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'RS', 'Serbia'),
  (193, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SC', 'Seychelles'),
  (194, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SL', 'Sierra Leone'),
  (195, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SG', 'Singapore'),
  (196, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SX', 'Sint Maarten'),
  (197, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SK', 'Slovakia'),
  (198, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SI', 'Slovenia'),
  (199, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SB', 'Solomon Islands'),
  (200, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SO', 'Somalia'),
  (201, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ZA', 'South Africa'),
  (202, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GS', 'South Georgia & South Sandwich Islands'),
  (203, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KR', 'South Korea'),
  (204, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SS', 'South Sudan'),
  (205, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ES', 'Spain'),
  (206, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LK', 'Sri Lanka'),
  (207, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'BL', 'St. Barthélemy'),
  (208, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SH', 'St. Helena'),
  (209, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'KN', 'St. Kitts & Nevis'),
  (210, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'LC', 'St. Lucia'),
  (211, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'MF', 'St. Martin'),
  (212, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'PM', 'St. Pierre & Miquelon'),
  (213, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VC', 'St. Vincent & Grenadines'),
  (214, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SD', 'Sudan'),
  (215, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SR', 'Suriname'),
  (216, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SJ', 'Svalbard & Jan Mayen'),
  (217, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SZ', 'Swaziland'),
  (218, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SE', 'Sweden'),
  (219, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'CH', 'Switzerland'),
  (220, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'SY', 'Syria'),
  (221, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TW', 'Taiwan'),
  (222, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TJ', 'Tajikistan'),
  (223, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TZ', 'Tanzania'),
  (224, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TH', 'Thailand'),
  (225, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TL', 'Timor-Leste'),
  (226, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TG', 'Togo'),
  (227, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TK', 'Tokelau'),
  (228, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TO', 'Tonga'),
  (229, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TT', 'Trinidad & Tobago'),
  (230, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TA', 'Tristan da Cunha'),
  (231, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TN', 'Tunisia'),
  (232, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TR', 'Turkey'),
  (233, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TM', 'Turkmenistan'),
  (234, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TC', 'Turks & Caicos Islands'),
  (235, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'TV', 'Tuvalu'),
  (236, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'UM', 'U.S. Outlying Islands'),
  (237, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VI', 'U.S. Virgin Islands'),
  (238, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'UG', 'Uganda'),
  (239, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'UA', 'Ukraine'),
  (240, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'AE', 'United Arab Emirates'),
  (241, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'GB', 'United Kingdom'),
  (242, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'US', 'United States'),
  (243, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'UY', 'Uruguay'),
  (244, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'UZ', 'Uzbekistan'),
  (245, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VU', 'Vanuatu'),
  (246, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VA', 'Vatican City'),
  (247, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VE', 'Venezuela'),
  (248, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'VN', 'Vietnam'),
  (249, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'WF', 'Wallis & Futuna'),
  (250, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'EH', 'Western Sahara'),
  (251, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'YE', 'Yemen'),
  (252, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ZM', 'Zambia'),
  (253, '2016-06-21 14:32:00', '2016-06-21 14:32:00', 'ZW', 'Zimbabwe'),
  (254, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GUF', 'French Guiana'),
  (258, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PYF', 'French Polynesia'),
  (260, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ATF', 'French Southern Territories'),
  (262, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'DJI', 'Djibouti'),
  (266, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GAB', 'Gabon'),
  (268, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GEO', 'Georgia'),
  (270, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GMB', 'Gambia'),
  (275, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PSE', 'Palestine, State of'),
  (276, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'DEU', 'Germany'),
  (288, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GHA', 'Ghana'),
  (292, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GIB', 'Gibraltar'),
  (296, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KIR', 'Kiribati'),
  (300, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GRC', 'Greece'),
  (304, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GRL', 'Greenland'),
  (308, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GRD', 'Grenada'),
  (312, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GLP', 'Guadeloupe'),
  (316, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GUM', 'Guam'),
  (320, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GTM', 'Guatemala'),
  (324, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GIN', 'Guinea'),
  (328, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GUY', 'Guyana'),
  (332, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'HTI', 'Haiti'),
  (334, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'HMD', 'Heard Island and McDonald Islands'),
  (336, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VAT', 'Holy See'),
  (340, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'HND', 'Honduras'),
  (344, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'HKG', 'Hong Kong'),
  (348, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'HUN', 'Hungary'),
  (352, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ISL', 'Iceland'),
  (356, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IND', 'India'),
  (360, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IDN', 'Indonesia'),
  (364, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IRN', 'Iran (Islamic Republic of)'),
  (368, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IRQ', 'Iraq'),
  (372, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IRL', 'Ireland'),
  (376, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ISR', 'Israel'),
  (380, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ITA', 'Italy'),
  (384, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'CIV', 'Côte d\'Ivoire'),
  (388, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'JAM', 'Jamaica'),
  (392, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'JPN', 'Japan'),
  (398, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KAZ', 'Kazakhstan'),
  (400, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'JOR', 'Jordan'),
  (404, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KEN', 'Kenya'),
  (408, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PRK', 'Korea (Democratic People\'s Republic of)'),
  (410, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KOR', 'Korea (Republic of)'),
  (414, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KWT', 'Kuwait'),
  (417, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KGZ', 'Kyrgyzstan'),
  (418, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LAO', 'Lao People\'s Democratic Republic'),
  (422, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LBN', 'Lebanon'),
  (426, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LSO', 'Lesotho'),
  (428, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LVA', 'Latvia'),
  (430, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LBR', 'Liberia'),
  (434, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LBY', 'Libya'),
  (438, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LIE', 'Liechtenstein'),
  (440, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LTU', 'Lithuania'),
  (442, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LUX', 'Luxembourg'),
  (446, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MAC', 'Macao'),
  (450, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MDG', 'Madagascar'),
  (454, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MWI', 'Malawi'),
  (458, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MYS', 'Malaysia'),
  (462, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MDV', 'Maldives'),
  (466, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MLI', 'Mali'),
  (470, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MLT', 'Malta'),
  (474, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MTQ', 'Martinique'),
  (478, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MRT', 'Mauritania'),
  (480, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MUS', 'Mauritius'),
  (484, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MEX', 'Mexico'),
  (492, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MCO', 'Monaco'),
  (496, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MNG', 'Mongolia'),
  (498, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MDA', 'Moldova (Republic of)'),
  (499, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MNE', 'Montenegro'),
  (500, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MSR', 'Montserrat'),
  (504, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MAR', 'Morocco'),
  (508, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MOZ', 'Mozambique'),
  (512, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'OMN', 'Oman'),
  (516, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NAM', 'Namibia'),
  (520, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NRU', 'Nauru'),
  (524, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NPL', 'Nepal'),
  (528, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NLD', 'Netherlands'),
  (531, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'CUW', 'Curaçao'),
  (533, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ABW', 'Aruba'),
  (534, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SXM', 'Sint Maarten (Dutch part)'),
  (535, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'BES', 'Bonaire, Sint Eustatius and Saba'),
  (540, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NCL', 'New Caledonia'),
  (548, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VUT', 'Vanuatu'),
  (554, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NZL', 'New Zealand'),
  (558, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NIC', 'Nicaragua'),
  (562, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NER', 'Niger'),
  (566, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NGA', 'Nigeria'),
  (570, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NIU', 'Niue'),
  (574, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NFK', 'Norfolk Island'),
  (578, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'NOR', 'Norway'),
  (580, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MNP', 'Northern Mariana Islands'),
  (581, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'UMI', 'United States Minor Outlying Islands'),
  (583, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'FSM', 'Micronesia (Federated States of)'),
  (584, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MHL', 'Marshall Islands'),
  (585, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PLW', 'Palau'),
  (586, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PAK', 'Pakistan'),
  (591, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PAN', 'Panama'),
  (598, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PNG', 'Papua New Guinea'),
  (600, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PRY', 'Paraguay'),
  (604, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PER', 'Peru'),
  (608, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PHL', 'Philippines'),
  (612, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PCN', 'Pitcairn'),
  (616, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'POL', 'Poland'),
  (620, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PRT', 'Portugal'),
  (624, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GNB', 'Guinea-Bissau'),
  (626, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TLS', 'Timor-Leste'),
  (630, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'PRI', 'Puerto Rico'),
  (634, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'QAT', 'Qatar'),
  (638, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'REU', 'Réunion'),
  (642, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ROU', 'Romania'),
  (643, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'RUS', 'Russian Federation'),
  (646, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'RWA', 'Rwanda'),
  (652, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'BLM', 'Saint Barthélemy'),
  (654, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SHN', 'Saint Helena, Ascension and Tristan da Cunha'),
  (659, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'KNA', 'Saint Kitts and Nevis'),
  (660, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'AIA', 'Anguilla'),
  (662, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'LCA', 'Saint Lucia'),
  (663, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MAF', 'Saint Martin (French part)'),
  (666, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SPM', 'Saint Pierre and Miquelon'),
  (670, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VCT', 'Saint Vincent and the Grenadines'),
  (674, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SMR', 'San Marino'),
  (678, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'STP', 'Sao Tome and Principe'),
  (682, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SAU', 'Saudi Arabia'),
  (686, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SEN', 'Senegal'),
  (688, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SRB', 'Serbia'),
  (690, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SYC', 'Seychelles'),
  (694, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SLE', 'Sierra Leone'),
  (702, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SGP', 'Singapore'),
  (703, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SVK', 'Slovakia'),
  (704, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VNM', 'Viet Nam'),
  (705, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SVN', 'Slovenia'),
  (706, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SOM', 'Somalia'),
  (710, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ZAF', 'South Africa'),
  (716, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ZWE', 'Zimbabwe'),
  (724, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ESP', 'Spain'),
  (728, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SSD', 'South Sudan'),
  (729, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SDN', 'Sudan'),
  (732, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ESH', 'Western Sahara'),
  (740, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SUR', 'Suriname'),
  (744, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SJM', 'Svalbard and Jan Mayen'),
  (748, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SWZ', 'Swaziland'),
  (752, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SWE', 'Sweden'),
  (756, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'CHE', 'Switzerland'),
  (760, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'SYR', 'Syrian Arab Republic'),
  (762, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TJK', 'Tajikistan'),
  (764, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'THA', 'Thailand'),
  (768, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TGO', 'Togo'),
  (772, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TKL', 'Tokelau'),
  (776, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TON', 'Tonga'),
  (780, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TTO', 'Trinidad and Tobago'),
  (784, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ARE', 'United Arab Emirates'),
  (788, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TUN', 'Tunisia'),
  (792, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TUR', 'Turkey'),
  (795, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TKM', 'Turkmenistan'),
  (796, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TCA', 'Turks and Caicos Islands'),
  (798, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TUV', 'Tuvalu'),
  (800, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'UGA', 'Uganda'),
  (804, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'UKR', 'Ukraine'),
  (807, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'MKD', 'Macedonia (the former Yugoslav Republic of)'),
  (818, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'EGY', 'Egypt'),
  (826, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GBR', 'United Kingdom of Great Britain and Northern Ireland'),
  (831, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'GGY', 'Guernsey'),
  (832, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'JEY', 'Jersey'),
  (833, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'IMN', 'Isle of Man'),
  (834, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'TZA', 'Tanzania, United Republic of'),
  (840, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'US', 'United States of America'),
  (850, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VIR', 'Virgin Islands (U.S.)'),
  (854, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'BFA', 'Burkina Faso'),
  (858, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'URY', 'Uruguay'),
  (860, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'UZB', 'Uzbekistan'),
  (862, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'VEN', 'Venezuela (Bolivarian Republic of)'),
  (876, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'WLF', 'Wallis and Futuna'),
  (882, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'WSM', 'Samoa'),
  (887, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'YEM', 'Yemen'),
  (894, '2016-05-20 11:29:00', '2016-05-20 11:29:00', 'ZMB', 'Zambia');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_gender`
  --
  
  DROP TABLE IF EXISTS `list_gender`;
  CREATE TABLE `list_gender` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_gender`
  --
  
  REPLACE INTO `list_gender` (`id`, `created`, `updated`, `name`, `slug`, `status`) VALUES
  (1, '2016-04-27 13:44:00', '2016-04-27 13:44:00', 'N/A', 'n-a', 1),
  (2, '2016-04-27 13:44:00', '2016-04-27 13:44:00', 'Male', 'hombre', 1),
  (3, '2016-04-27 13:44:00', '2016-04-27 13:44:00', 'Female', 'mujer', 1),
  (4, '2016-04-27 13:44:00', '2016-04-27 13:44:00', 'Both', 'ambos', 1),
  (5, '2016-06-21 16:30:11', '2016-06-21 16:30:11', 'Test', 'test', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_monitoring_action`
  --
  
  DROP TABLE IF EXISTS `list_monitoring_action`;
  CREATE TABLE `list_monitoring_action` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_monitoring_action`
  --
  
  REPLACE INTO `list_monitoring_action` (`id`, `created`, `updated`, `name`, `slug`, `status`) VALUES
  (1, '2016-06-02 11:58:04', '2016-06-02 11:58:04', 'Submit an amendment', 'submit-an-amendment', 1),
  (2, '2016-06-02 11:58:04', '2016-06-02 11:58:04', 'Adverse events report', 'adverse-events-report', 1),
  (3, '2016-06-02 11:58:04', '2016-06-02 11:58:04', 'Completion of Study', 'completion-of-study', 1),
  (4, '2016-06-02 11:58:04', '2016-06-02 11:58:04', 'Follow-up Report', 'follow-up-report', 1),
  (5, '2016-07-13 00:00:00', '2016-07-13 00:00:00', 'Discontinuation of Study', 'discontinuation-of-study', 1),
  (6, '2016-07-13 00:00:00', '2016-07-13 00:00:00', 'Submission of Other Documents', 'submission-of-other-documents', 1),
  (7, '2016-07-13 00:00:00', '2016-07-13 00:00:00', 'Request approval extension', 'request-approval-extension', 1),
  (8, '2016-07-13 00:00:00', '2016-07-13 00:00:00', 'Cancellation of Study', 'cancellation-of-study', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_recruitment_status`
  --
  
  DROP TABLE IF EXISTS `list_recruitment_status`;
  CREATE TABLE `list_recruitment_status` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_recruitment_status`
  --
  
  REPLACE INTO `list_recruitment_status` (`id`, `created`, `updated`, `name`, `slug`, `status`) VALUES
  (1, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Recruiting', 'recruiting', 1),
  (2, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Suspended', 'suspended', 1),
  (3, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Completed', 'completed', 1),
  (4, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Other', 'other', 1),
  (8, '2016-07-26 15:33:45', '2016-07-26 15:33:45', 'Pending', 'pending', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `list_role`
  --
  
  DROP TABLE IF EXISTS `list_role`;
  CREATE TABLE `list_role` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `list_role`
  --
  
  REPLACE INTO `list_role` (`id`, `created`, `updated`, `name`, `slug`, `status`) VALUES
  (1, '2016-04-28 17:44:32', '2016-04-28 17:44:32', 'Investigator', 'investigator', 1),
  (2, '2016-04-28 17:44:32', '2016-04-28 17:44:32', 'Secretary', 'secretary', 1),
  (3, '2016-04-28 17:44:32', '2016-04-28 17:44:32', 'Member of Committee', 'member-of-committee', 1),
  (4, '2016-04-28 17:44:32', '2016-04-28 17:44:32', 'Member ad-hoc', 'member-ad-hoc', 1),
  (5, '2016-06-16 00:00:00', '2016-06-16 00:00:00', 'Administrator', 'administrator', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `meeting`
  --
  
  DROP TABLE IF EXISTS `meeting`;
  CREATE TABLE `meeting` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `date` date NOT NULL,
    `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `content` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `protocol`
  --
  
  DROP TABLE IF EXISTS `protocol`;
  CREATE TABLE `protocol` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `owner_id` int(11) NOT NULL,
    `main_submission_id` int(11) DEFAULT NULL,
    `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
    `date_informed` datetime DEFAULT NULL,
    `reject_reason` longtext COLLATE utf8_unicode_ci,
    `code` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `committee_screening` longtext COLLATE utf8_unicode_ci,
    `opinion_required` int(11) DEFAULT NULL,
    `updated_in` datetime DEFAULT NULL,
    `meeting_id` int(11) DEFAULT NULL,
    `decision_in` datetime DEFAULT NULL,
    `revised_in` datetime DEFAULT NULL,
    `monitoring_action_id` int(11) DEFAULT NULL,
    `monitoring_action_next_date` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `protocol_comment`
  --
  
  DROP TABLE IF EXISTS `protocol_comment`;
  CREATE TABLE `protocol_comment` (
    `id` int(11) NOT NULL,
    `protocol_id` int(11) DEFAULT NULL,
    `user_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `message` longtext COLLATE utf8_unicode_ci NOT NULL,
    `is_confidential` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `protocol_history`
  --
  
  DROP TABLE IF EXISTS `protocol_history`;
  CREATE TABLE `protocol_history` (
    `id` int(11) NOT NULL,
    `protocol_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `protocol_revision`
  --
  
  DROP TABLE IF EXISTS `protocol_revision`;
  CREATE TABLE `protocol_revision` (
    `id` int(11) NOT NULL,
    `member_id` int(11) DEFAULT NULL,
    `protocol_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `answered` tinyint(1) NOT NULL,
    `is_final_revision` tinyint(1) NOT NULL,
    `decision` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `social_value` longtext COLLATE utf8_unicode_ci,
    `sscientific_validity` longtext COLLATE utf8_unicode_ci,
    `fair_participant_selection` longtext COLLATE utf8_unicode_ci,
    `favorable_balance` longtext COLLATE utf8_unicode_ci,
    `informed_consent` longtext COLLATE utf8_unicode_ci,
    `respect_for_participants` longtext COLLATE utf8_unicode_ci,
    `other_comments` longtext COLLATE utf8_unicode_ci,
    `suggestions` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission`
  --
  
  DROP TABLE IF EXISTS `submission`;
  CREATE TABLE `submission` (
    `id` int(11) NOT NULL,
    `protocol_id` int(11) DEFAULT NULL,
    `owner_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `public_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `is_clinical_trial` tinyint(1) NOT NULL,
    `abstract` longtext COLLATE utf8_unicode_ci,
    `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `introduction` longtext COLLATE utf8_unicode_ci,
    `justification` longtext COLLATE utf8_unicode_ci,
    `goals` longtext COLLATE utf8_unicode_ci,
    `study_design` longtext COLLATE utf8_unicode_ci,
    `health_condition` longtext COLLATE utf8_unicode_ci,
    `sample_size` int(11) DEFAULT NULL,
    `minimum_age` int(11) DEFAULT NULL,
    `maximum_age` int(11) DEFAULT NULL,
    `inclusion_criteria` longtext COLLATE utf8_unicode_ci,
    `exclusion_criteria` longtext COLLATE utf8_unicode_ci,
    `recruitment_init_date` date DEFAULT NULL,
    `interventions` longtext COLLATE utf8_unicode_ci,
    `primary_outcome` longtext COLLATE utf8_unicode_ci,
    `secondary_outcome` longtext COLLATE utf8_unicode_ci,
    `general_procedures` longtext COLLATE utf8_unicode_ci,
    `analysis_plan` longtext COLLATE utf8_unicode_ci,
    `ethical_considerations` longtext COLLATE utf8_unicode_ci,
    `funding_source` longtext COLLATE utf8_unicode_ci,
    `primary_sponsor` longtext COLLATE utf8_unicode_ci,
    `secondary_sponsor` longtext COLLATE utf8_unicode_ci,
    `bibliography` longtext COLLATE utf8_unicode_ci,
    `sscientific_contact` longtext COLLATE utf8_unicode_ci,
    `prior_ethical_approval` tinyint(1) DEFAULT NULL,
    `gender_id` int(11) DEFAULT NULL,
    `recruitment_status_id` int(11) DEFAULT NULL,
    `clinical_trial_secondary` longtext COLLATE utf8_unicode_ci,
    `is_sent` tinyint(1) NOT NULL,
    `number` int(11) NOT NULL,
    `scientific_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `title_acronym` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPRESSED;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_clinical_trial`
  --
  
  DROP TABLE IF EXISTS `submission_clinical_trial`;
  CREATE TABLE `submission_clinical_trial` (
    `id` int(11) NOT NULL,
    `clinical_trial_name_id` int(11) DEFAULT NULL,
    `submission_id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `number` int(11) NOT NULL,
    `date` date DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_cost`
  --
  
  DROP TABLE IF EXISTS `submission_cost`;
  CREATE TABLE `submission_cost` (
    `id` int(11) NOT NULL,
    `submission_id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `quantity` int(11) NOT NULL,
    `unit_cost` double NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_country`
  --
  
  DROP TABLE IF EXISTS `submission_country`;
  CREATE TABLE `submission_country` (
    `id` int(11) NOT NULL,
    `submission_id` int(11) NOT NULL,
    `country_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `participants` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_task`
  --
  
  DROP TABLE IF EXISTS `submission_task`;
  CREATE TABLE `submission_task` (
    `id` int(11) NOT NULL,
    `submission_id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `init` date NOT NULL,
    `end` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_upload`
  --
  
  DROP TABLE IF EXISTS `submission_upload`;
  CREATE TABLE `submission_upload` (
    `id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `submission_id` int(11) DEFAULT NULL,
    `upload_type_id` int(11) DEFAULT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `filepath` varchar(1023) COLLATE utf8_unicode_ci NOT NULL,
    `submission_number` int(11) NOT NULL,
    `is_monitoring_action` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `submission_user`
  --
  
  DROP TABLE IF EXISTS `submission_user`;
  CREATE TABLE `submission_user` (
    `submission_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `upload_type`
  --
  
  DROP TABLE IF EXISTS `upload_type`;
  CREATE TABLE `upload_type` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `upload_type`
  --
  
  REPLACE INTO `upload_type` (`id`, `created`, `updated`, `name`, `slug`, `status`) VALUES
  (1, '2016-04-22 00:00:00', '2016-04-22 00:00:00', 'Protocol', 'protocol', 1),
  (2, '2016-04-22 00:00:00', '2016-04-22 00:00:00', 'Others', 'others', 1),
  (3, '2016-05-12 00:00:00', '2016-05-12 00:00:00', 'Decision', 'decision', 1),
  (11, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Institutional Authorization ', 'institutional-authorization', 1),
  (27, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Scientific Support', 'scientific-support', 1),
  (28, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Bibliography', 'bibliography', 1),
  (29, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Questionnaire ', 'questionnaire', 1),
  (30, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Opinion', 'opinion', 1),
  (31, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Decision issued by another committee', 'decision-issued-by-another-committee', 1),
  (32, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Survey', 'survey', 1),
  (33, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Justification waiver of consent', 'justification-waiver-of-consent', 1),
  (34, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Material recruitment / participant information', 'material-recruitment-participant-information', 1),
  (35, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Insurance policy', 'insurance-policy', 1),
  (36, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Estimation', 'estimation', 1),
  (37, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Protocol with animals', 'protocol-with-animals', 1),
  (38, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Adverse event report', 'adverse-event-report', 1),
  (39, '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'Executive Summary', 'executive-summary', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `upload_type_extension`
  --
  
  DROP TABLE IF EXISTS `upload_type_extension`;
  CREATE TABLE `upload_type_extension` (
    `id` int(11) NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `extension` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `upload_type_upload_type_extension`
  --
  
  DROP TABLE IF EXISTS `upload_type_upload_type_extension`;
  CREATE TABLE `upload_type_upload_type_extension` (
    `uploadtype_id` int(11) NOT NULL,
    `uploadtypeextension_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `user`
  --
  
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(11) NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
    `username` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `institution` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `country_id` int(11) DEFAULT NULL,
    `first_access` tinyint(1) NOT NULL,
    `hashcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `user`
  --
  
  REPLACE INTO `user` (`id`, `email`, `password`, `username`, `is_active`, `name`, `created`, `updated`, `institution`, `country_id`, `first_access`, `hashcode`) VALUES
  (1, 'admin@proethos2.com', '$2y$13$FSoxdS5S4XKYa7C0la22YublIJPV3s8/bpqwreOsW5F1.ZYQxNKnC', 'admin', 1, 'Proethos2 Admin', '2016-01-01 00:00:00', '2016-01-01 00:00:00', 'BIREME', 31, 0, NULL),
  (41, 'florestan@paho.org', '$2y$13$/QTGsD4A8WtcgkOycZSh9.WR6mWkcj.9q2FPJG3m84ciCtR3z4oIG', 'tania', 1, 'Tania', '2016-08-11 13:32:58', '2016-08-11 13:32:58', 'PAHO', 242, 0, '85df11e5ee79fbb72a80d86e455012a4'),
  (43, 'murasaki@paho.org', '$2y$13$oQqeQ75MJ1C1md7nA6sZ/ebQa72bVs4NCvs1LisZeOflMjBRYWBsm', 'renato', 1, 'Renato', '2016-08-11 13:36:09', '2016-08-11 13:36:09', 'BIREME', 31, 0, '9bea071f61cbec5dcbbbac9e8b41515f');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura para tabela `user_role`
  --
  
  DROP TABLE IF EXISTS `user_role`;
  CREATE TABLE `user_role` (
    `user_id` int(11) NOT NULL,
    `role_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Fazendo dump de dados para tabela `user_role`
  --
  
  REPLACE INTO `user_role` (`user_id`, `role_id`) VALUES
  (1, 1),
  (1, 2),
  (1, 3),
  (1, 4),
  (1, 5),
  (41, 1),
  (41, 2),
  (41, 3),
  (41, 4),
  (41, 5),
  (43, 1),
  (43, 2),
  (43, 3),
  (43, 4),
  (43, 5);
  
  --
  -- Índices de tabelas apagadas
  --
  
  --
  -- Índices de tabela `configuration`
  --
  ALTER TABLE `configuration`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `document`
  --
  ALTER TABLE `document`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `document_role`
  --
  ALTER TABLE `document_role`
    ADD PRIMARY KEY (`document_id`,`role_id`),
    ADD KEY `IDX_F0DD06F9C33F7837` (`document_id`),
    ADD KEY `IDX_F0DD06F9D60322AC` (`role_id`);
  
  --
  -- Índices de tabela `ext_translations`
  --
  ALTER TABLE `ext_translations`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `lookup_unique_idx` (`locale`,`object_class`,`field`,`foreign_key`),
    ADD KEY `translations_lookup_idx` (`locale`,`object_class`,`foreign_key`);
  
  --
  -- Índices de tabela `faq`
  --
  ALTER TABLE `faq`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `help`
  --
  ALTER TABLE `help`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_clinical_trial_name`
  --
  ALTER TABLE `list_clinical_trial_name`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_country`
  --
  ALTER TABLE `list_country`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_gender`
  --
  ALTER TABLE `list_gender`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_monitoring_action`
  --
  ALTER TABLE `list_monitoring_action`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_recruitment_status`
  --
  ALTER TABLE `list_recruitment_status`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `list_role`
  --
  ALTER TABLE `list_role`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `meeting`
  --
  ALTER TABLE `meeting`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `protocol`
  --
  ALTER TABLE `protocol`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_C8C0BC4C7E3C61F9` (`owner_id`),
    ADD KEY `IDX_C8C0BC4C5359FAAE` (`main_submission_id`),
    ADD KEY `IDX_C8C0BC4C67433D9C` (`meeting_id`),
    ADD KEY `IDX_C8C0BC4C4608B388` (`monitoring_action_id`);
  
  --
  -- Índices de tabela `protocol_comment`
  --
  ALTER TABLE `protocol_comment`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_B156FCC9CCD59258` (`protocol_id`),
    ADD KEY `IDX_B156FCC9A76ED395` (`user_id`);
  
  --
  -- Índices de tabela `protocol_history`
  --
  ALTER TABLE `protocol_history`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_298DEEECCD59258` (`protocol_id`);
  
  --
  -- Índices de tabela `protocol_revision`
  --
  ALTER TABLE `protocol_revision`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_CBFA60057597D3FE` (`member_id`),
    ADD KEY `IDX_CBFA6005CCD59258` (`protocol_id`);
  
  --
  -- Índices de tabela `submission`
  --
  ALTER TABLE `submission`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_DB055AF3CCD59258` (`protocol_id`),
    ADD KEY `IDX_DB055AF37E3C61F9` (`owner_id`),
    ADD KEY `IDX_DB055AF3708A0E0` (`gender_id`),
    ADD KEY `IDX_DB055AF31767A288` (`recruitment_status_id`);
  
  --
  -- Índices de tabela `submission_clinical_trial`
  --
  ALTER TABLE `submission_clinical_trial`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_15E6724EC8B14B6` (`clinical_trial_name_id`),
    ADD KEY `IDX_15E6724EE1FD4933` (`submission_id`);
  
  --
  -- Índices de tabela `submission_cost`
  --
  ALTER TABLE `submission_cost`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_8A20FF93E1FD4933` (`submission_id`);
  
  --
  -- Índices de tabela `submission_country`
  --
  ALTER TABLE `submission_country`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_7F9252B0E1FD4933` (`submission_id`),
    ADD KEY `IDX_7F9252B0F92F3E70` (`country_id`);
  
  --
  -- Índices de tabela `submission_task`
  --
  ALTER TABLE `submission_task`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_C078B04AE1FD4933` (`submission_id`);
  
  --
  -- Índices de tabela `submission_upload`
  --
  ALTER TABLE `submission_upload`
    ADD PRIMARY KEY (`id`),
    ADD KEY `IDX_2FB8BBA1A76ED395` (`user_id`),
    ADD KEY `IDX_2FB8BBA1E1FD4933` (`submission_id`),
    ADD KEY `IDX_2FB8BBA17B967D` (`upload_type_id`);
  
  --
  -- Índices de tabela `submission_user`
  --
  ALTER TABLE `submission_user`
    ADD PRIMARY KEY (`submission_id`,`user_id`),
    ADD KEY `IDX_1F95BD26E1FD4933` (`submission_id`),
    ADD KEY `IDX_1F95BD26A76ED395` (`user_id`);
  
  --
  -- Índices de tabela `upload_type`
  --
  ALTER TABLE `upload_type`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `UNIQ_85AD050989D9B62` (`slug`);
  
  --
  -- Índices de tabela `upload_type_extension`
  --
  ALTER TABLE `upload_type_extension`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices de tabela `upload_type_upload_type_extension`
  --
  ALTER TABLE `upload_type_upload_type_extension`
    ADD PRIMARY KEY (`uploadtype_id`,`uploadtypeextension_id`),
    ADD KEY `IDX_BBBAE26FB15E3BA8` (`uploadtype_id`),
    ADD KEY `IDX_BBBAE26FD13F305` (`uploadtypeextension_id`);
  
  --
  -- Índices de tabela `user`
  --
  ALTER TABLE `user`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `UNIQ_8D93D649F85E0677` (`username`),
    ADD KEY `IDX_8D93D649F92F3E70` (`country_id`);
  
  --
  -- Índices de tabela `user_role`
  --
  ALTER TABLE `user_role`
    ADD PRIMARY KEY (`user_id`,`role_id`),
    ADD KEY `IDX_2DE8C6A3A76ED395` (`user_id`),
    ADD KEY `IDX_2DE8C6A3D60322AC` (`role_id`);
  
  --
  -- AUTO_INCREMENT de tabelas apagadas
  --
  
  --
  -- AUTO_INCREMENT de tabela `configuration`
  --
  ALTER TABLE `configuration`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `document`
  --
  ALTER TABLE `document`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `ext_translations`
  --
  ALTER TABLE `ext_translations`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `faq`
  --
  ALTER TABLE `faq`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `help`
  --
  ALTER TABLE `help`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=186;
  --
  -- AUTO_INCREMENT de tabela `list_clinical_trial_name`
  --
  ALTER TABLE `list_clinical_trial_name`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  --
  -- AUTO_INCREMENT de tabela `list_country`
  --
  ALTER TABLE `list_country`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=895;
  --
  -- AUTO_INCREMENT de tabela `list_gender`
  --
  ALTER TABLE `list_gender`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT de tabela `list_monitoring_action`
  --
  ALTER TABLE `list_monitoring_action`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  --
  -- AUTO_INCREMENT de tabela `list_recruitment_status`
  --
  ALTER TABLE `list_recruitment_status`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  --
  -- AUTO_INCREMENT de tabela `list_role`
  --
  ALTER TABLE `list_role`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT de tabela `meeting`
  --
  ALTER TABLE `meeting`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT de tabela `protocol`
  --
  ALTER TABLE `protocol`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  --
  -- AUTO_INCREMENT de tabela `protocol_comment`
  --
  ALTER TABLE `protocol_comment`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `protocol_history`
  --
  ALTER TABLE `protocol_history`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `protocol_revision`
  --
  ALTER TABLE `protocol_revision`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `submission`
  --
  ALTER TABLE `submission`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  --
  -- AUTO_INCREMENT de tabela `submission_clinical_trial`
  --
  ALTER TABLE `submission_clinical_trial`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `submission_cost`
  --
  ALTER TABLE `submission_cost`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `submission_country`
  --
  ALTER TABLE `submission_country`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `submission_task`
  --
  ALTER TABLE `submission_task`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `submission_upload`
  --
  ALTER TABLE `submission_upload`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `upload_type`
  --
  ALTER TABLE `upload_type`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
  --
  -- AUTO_INCREMENT de tabela `upload_type_extension`
  --
  ALTER TABLE `upload_type_extension`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT de tabela `user`
  --
  ALTER TABLE `user`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
  --
  -- Restrições para dumps de tabelas
  --
  
  --
  -- Restrições para tabelas `document_role`
  --
  ALTER TABLE `document_role`
    ADD CONSTRAINT `FK_F0DD06F9C33F7837` FOREIGN KEY (`document_id`) REFERENCES `document` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_F0DD06F9D60322AC` FOREIGN KEY (`role_id`) REFERENCES `list_role` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `protocol`
  --
  ALTER TABLE `protocol`
    ADD CONSTRAINT `FK_C8C0BC4C4608B388` FOREIGN KEY (`monitoring_action_id`) REFERENCES `list_monitoring_action` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_C8C0BC4C5359FAAE` FOREIGN KEY (`main_submission_id`) REFERENCES `submission` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_C8C0BC4C67433D9C` FOREIGN KEY (`meeting_id`) REFERENCES `meeting` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_C8C0BC4C7E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `protocol_comment`
  --
  ALTER TABLE `protocol_comment`
    ADD CONSTRAINT `FK_B156FCC9A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_B156FCC9CCD59258` FOREIGN KEY (`protocol_id`) REFERENCES `protocol` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `protocol_history`
  --
  ALTER TABLE `protocol_history`
    ADD CONSTRAINT `FK_298DEEECCD59258` FOREIGN KEY (`protocol_id`) REFERENCES `protocol` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `protocol_revision`
  --
  ALTER TABLE `protocol_revision`
    ADD CONSTRAINT `FK_CBFA60057597D3FE` FOREIGN KEY (`member_id`) REFERENCES `user` (`id`),
    ADD CONSTRAINT `FK_CBFA6005CCD59258` FOREIGN KEY (`protocol_id`) REFERENCES `protocol` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission`
  --
  ALTER TABLE `submission`
    ADD CONSTRAINT `FK_DB055AF31767A288` FOREIGN KEY (`recruitment_status_id`) REFERENCES `list_recruitment_status` (`id`),
    ADD CONSTRAINT `FK_DB055AF3708A0E0` FOREIGN KEY (`gender_id`) REFERENCES `list_gender` (`id`),
    ADD CONSTRAINT `FK_DB055AF37E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_DB055AF3CCD59258` FOREIGN KEY (`protocol_id`) REFERENCES `protocol` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission_clinical_trial`
  --
  ALTER TABLE `submission_clinical_trial`
    ADD CONSTRAINT `FK_15E6724EC8B14B6` FOREIGN KEY (`clinical_trial_name_id`) REFERENCES `list_clinical_trial_name` (`id`),
    ADD CONSTRAINT `FK_15E6724EE1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission_cost`
  --
  ALTER TABLE `submission_cost`
    ADD CONSTRAINT `FK_8A20FF93E1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission_country`
  --
  ALTER TABLE `submission_country`
    ADD CONSTRAINT `FK_7F9252B0E1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_7F9252B0F92F3E70` FOREIGN KEY (`country_id`) REFERENCES `list_country` (`id`) ON DELETE SET NULL;
  
  --
  -- Restrições para tabelas `submission_task`
  --
  ALTER TABLE `submission_task`
    ADD CONSTRAINT `FK_C078B04AE1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission_upload`
  --
  ALTER TABLE `submission_upload`
    ADD CONSTRAINT `FK_2FB8BBA17B967D` FOREIGN KEY (`upload_type_id`) REFERENCES `upload_type` (`id`),
    ADD CONSTRAINT `FK_2FB8BBA1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_2FB8BBA1E1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `submission_user`
  --
  ALTER TABLE `submission_user`
    ADD CONSTRAINT `FK_1F95BD26A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_1F95BD26E1FD4933` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `upload_type_upload_type_extension`
  --
  ALTER TABLE `upload_type_upload_type_extension`
    ADD CONSTRAINT `FK_BBBAE26FB15E3BA8` FOREIGN KEY (`uploadtype_id`) REFERENCES `upload_type` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_BBBAE26FD13F305` FOREIGN KEY (`uploadtypeextension_id`) REFERENCES `upload_type_extension` (`id`) ON DELETE CASCADE;
  
  --
  -- Restrições para tabelas `user`
  --
  ALTER TABLE `user`
    ADD CONSTRAINT `FK_8D93D649F92F3E70` FOREIGN KEY (`country_id`) REFERENCES `list_country` (`id`) ON DELETE SET NULL;
  
  --
  -- Restrições para tabelas `user_role`
  --
  ALTER TABLE `user_role`
    ADD CONSTRAINT `FK_2DE8C6A3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `FK_2DE8C6A3D60322AC` FOREIGN KEY (`role_id`) REFERENCES `list_role` (`id`) ON DELETE CASCADE;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  