text: -- phpMyAdmin SQL Dump
  -- version 4.8.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: 22-Set-2018 às 03:07
  -- Versão do servidor: 10.1.35-MariaDB
  -- versão do PHP: 7.2.9
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  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 */;
  
  --
  -- Database: `asvinici_sindojusac`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `address`
  --
  
  CREATE TABLE IF NOT EXISTS `address` (
    `addressid` int(11) NOT NULL AUTO_INCREMENT,
    `useraddress` int(11) NOT NULL,
    `street` varchar(50) NOT NULL,
    `number` varchar(10) NOT NULL,
    `district` varchar(30) NOT NULL,
    `city` varchar(30) NOT NULL,
    `state` varchar(30) NOT NULL,
    `cep` varchar(8) NOT NULL,
    `ref` text NOT NULL,
    PRIMARY KEY (`addressid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `ci_sessions`
  --
  
  CREATE TABLE IF NOT EXISTS `ci_sessions` (
    `id` varchar(40) COLLATE utf8_bin NOT NULL,
    `ip_address` varchar(45) COLLATE utf8_bin NOT NULL,
    `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
    `data` blob NOT NULL,
    KEY `ci_sessions_timestamp` (`timestamp`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  --
  -- Extraindo dados da tabela `ci_sessions`
  --
  
  INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
  ('3sa7dbt72o98fv3h5pv6ktr0d5hgdhp3', '192.168.0.14', 1537197036, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373139373033363b),
  ('cnab7k0u1qs3qakdcmj4ea7q59a76sdg', '192.168.0.14', 1537199318, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373139393331383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('uo6khlcfepv3jt5au33ekla93jkcssnp', '192.168.0.14', 1537206211, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373230363231313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('988f5l9qf41omvtqkvor73j4c2oappgm', '192.168.0.14', 1537211931, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231313933313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ut9o76sfkjnv9faq48ep7nlpc3uju26f', '192.168.0.14', 1537212240, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231323234303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('a9gr6cmkii86ur8703rkh4844or98tea', '192.168.0.14', 1537213187, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231333138373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('o5tj9iniie7qo7iqag2atvdkgm036d2k', '192.168.0.14', 1537213882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231333838323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('10rvbo4b9cnaqvf9fc7dcfiqjmc0lnqc', '192.168.0.14', 1537214185, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231343138353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('50gh9cbdkt90b4vurpegmutmta13ot9g', '192.168.0.14', 1537214557, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231343535373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('r6pn3j6m8umohuuj69598kiu0259ofj3', '192.168.0.14', 1537215412, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231353431323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('rltj2jesp49rm5ghr7jppkc8lh3gm5rl', '192.168.0.14', 1537215749, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231353734393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('8hdd5o3fr67gh0rmeht10tmp5rcp6avk', '192.168.0.14', 1537216120, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231363132303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('4nkuksgb5eaped8jdnej794nonv881ue', '192.168.0.14', 1537216468, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231363436383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('8jrfiveihaf5cspl5p3v7h1ssl6infj1', '192.168.0.14', 1537216808, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231363830383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('3q54am594h59bpq4j23237dkgmu7k8lf', '192.168.0.14', 1537217116, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231373131363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('hvelchnkjotfvs4k43qblk0vmn99sc6t', '192.168.0.14', 1537217419, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231373431393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('onorioqa0c2m2h6ecjjo0ngctb8gl9b4', '192.168.0.14', 1537217757, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231373735373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('fc7rg4qcog3fjlr0svmjoqgd47qudl1e', '192.168.0.14', 1537218119, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231383131393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('lmbhblf972g8gspsff1ih7rk427eatgh', '192.168.0.14', 1537218448, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231383434383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('eh20vms28dg912c2069a4almbejed1iq', '192.168.0.14', 1537219147, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231393134373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('6rf7b3o41jou9o6b93fnnb2gcq83rn1s', '192.168.0.14', 1537219449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231393434393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ghpchtj3c8igqa916j5rl4r6jb3u7bmm', '192.168.0.14', 1537219768, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373231393736383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('aesntvsr96ici8jdjfbjdrrajr7bd33p', '192.168.0.14', 1537220150, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232303135303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('dngqqp7tfdq6af9l7rtjfgc7hjlin4cf', '192.168.0.14', 1537220516, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232303531363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('u40suognhmjuauic7j2c5t4ei627oihn', '192.168.0.14', 1537220854, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232303835343b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('marocdvj34irtic1sljs4g4dg1ab5vuk', '192.168.0.14', 1537221172, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232313137323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('b3f0qq096oajkjk4fvgpucu4853qo9v9', '192.168.0.14', 1537223371, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232333337313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('mrd2icd9bu5u088vpb0rbe4shi8u47dr', '192.168.0.14', 1537223378, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373232333337383b),
  ('9remnvbsmmqa74sauigr0g59vapqnhl6', '192.168.0.14', 1537297003, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373239373030333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('a00bftml4ngvmia9lnmos44vctubjqrh', '192.168.0.14', 1537297546, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373239373534363b),
  ('ars3jcckq3lbb0mf397qjga9mc39jtn2', '192.168.0.14', 1537298340, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373239383334303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('arcfb0pgsc8t7q9njnfogf0i1bd77fun', '192.168.0.14', 1537298709, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373239383730393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('bhtqdv43an79k3uh7efcjao8dbtj4uii', '192.168.0.14', 1537299172, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373239393137323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('4a0banhbb2u1ca1lnpt251btsbt7cc2s', '192.168.0.14', 1537302429, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330323432393b),
  ('42sbijurcvssrs77jlm7u9q3pj63u12q', '192.168.0.14', 1537302891, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330323839313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('50vqa1j0hrbtnjm9ivrf153gr53ieadb', '192.168.0.14', 1537303211, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330333231313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('aintdr5ha74obq98p3nmrai1tjkf3kt2', '192.168.0.14', 1537303635, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330333633353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('97poununkmfock33fun0dc41lbgo82qp', '192.168.0.14', 1537304221, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330343232313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('itbg0bk7ld3e5sg35vmpqs0a4mopanv1', '192.168.0.14', 1537308316, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330383331363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('uevrsv34bu2nji4e63ij2f1a7frt227m', '192.168.0.14', 1537308633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330383633333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('vljg2rc4t51tqq5u0e3r13p44hk1kctd', '192.168.0.14', 1537308935, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330383933353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ekdotp43tg7i1v4rdt6t0cj1o62a6kcq', '192.168.0.14', 1537309245, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330393234353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('bo14oo2tsi5rdn1figr8d38hkrp8jmkc', '192.168.0.14', 1537309638, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373330393633383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('7n17hm23nqstp67f9a4tbdnvtmapkrck', '192.168.0.14', 1537310979, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373331303937393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('bt0han19hcpdd3jda2c8b6e167firrjo', '192.168.0.14', 1537312022, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373331323032323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('8k8g17qat84qump0s5kmbm990ptaa8fs', '192.168.0.14', 1537312416, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373331323431363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('kgq5n56dolkvgctohsqotphv9pg42s3c', '192.168.0.14', 1537312743, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373331323734333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('cnhico87ftptbnadbcfv1h5r7ue33a7b', '192.168.0.14', 1537312926, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373331323734333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ncmvrbc799skqj0vjv25phuukakump96', '192.168.0.14', 1537370220, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337303232303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('sem11agb86m4skoaoivn8207v0inquoi', '192.168.0.14', 1537370940, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337303934303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('roc95pcaeuh4hc6d44faa2rf5hc5lskg', '192.168.0.14', 1537371395, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337313339353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('gi8605gumqq65eciqpktoul2ch81bbjn', '192.168.0.14', 1537371832, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337313833323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('frm2l107fhbmrv13q87s2a0lmtd36nte', '192.168.0.14', 1537372651, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337323635313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('q1265u3jlo19u6mg04rs9scmdkg8hg5s', '192.168.0.14', 1537373280, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337333238303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('hk037159u4lp133qe8s9ei8b5dkh8svu', '192.168.0.14', 1537373623, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337333632333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('r5hfpe7uscame6dfdp2humpjqgi53ija', '192.168.0.14', 1537374097, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337343039373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('k44vmpdi53oo2mmmualetcdet0btvlec', '192.168.0.14', 1537374590, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337343539303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('0l2ub06ilbdolag6jgobu3kdd33dimuq', '192.168.0.14', 1537375029, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337353032393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('bmf3kl4dbc23j867rjdilnm3tvckfrqm', '192.168.0.14', 1537375474, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337353437343b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('e0snlujhhn6134pp4qtmasl62rqgeidf', '192.168.0.14', 1537376012, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337363031323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ue7m3gn9ruvqo0n6bojae262bclem57k', '192.168.0.14', 1537377292, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337373239323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('v4cnm1ona4jbvthbe78tki6s68p7ojni', '192.168.0.14', 1537377850, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337373835303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('fv4s7uqv0vbgc9ejbp8sdi2fn3lgu2bh', '192.168.0.14', 1537378395, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337383339353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('k489kdj2f3n4amcr8g1as1kqlk8kb2c1', '192.168.0.14', 1537378707, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337383730373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('cqr2u0g85vner5ogqo7kd5npmlec1533', '192.168.0.14', 1537379047, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373337393034373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('bn8ikmgjtish07piue6asntp2vgd1lgt', '192.168.0.14', 1537380675, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338303637353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('efbh787tv4ldri20r0ma1cfo5uhfqk0d', '192.168.0.14', 1537381008, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338313030383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('mup0vefdh9g6qak9bme4tpqq8rch14je', '192.168.0.14', 1537381541, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338313534313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('qet5pq6eh7gimvnt14dcdh2cp4llni55', '192.168.0.14', 1537381955, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338313935353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('oqhp6j6bdfeaa04ti4j5uav7fak9h8ud', '192.168.0.14', 1537382696, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338323639363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('ialskdltfkb90fmag91kvvgl0fvlc911', '192.168.0.14', 1537383235, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373338333233353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('buvdn156gus4mkoa57k7codpoql0ts0h', '192.168.0.14', 1537393110, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339333131303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('8gsu0c3ts9kf27cdkqdel1pnu5a1ahif', '192.168.0.14', 1537393458, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339333435383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('kqoovpuhn8b1sn0kia8dcas886mv90ql', '192.168.0.14', 1537394525, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339343532353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('0ac5gar4ogquv0qf9ifk2ojqvsiimka2', '192.168.0.14', 1537394835, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339343833353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('qdhq0388krsrsa2rasu6rlrhnm2ffhbl', '192.168.0.14', 1537396163, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339363136333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('nha71e8skek6qfo9lnidgdiolivca4st', '192.168.0.14', 1537397511, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339373531313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('v8g190bapjfh2mgavngngkc5npruu0rs', '192.168.0.14', 1537399026, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339393032363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('9nvmqjlbvo7gsvbi2qgg9shiaqche0sg', '192.168.0.14', 1537399338, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339393333383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('o8qod73pmh34jeioo09tkvof6d1fursr', '192.168.0.14', 1537399938, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373339393933383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('5ik79vuqb6a95e4cui5gog4cbr4sdk31', '192.168.0.14', 1537400257, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373430303235373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('41th63dgfn5b0hs8ge5h2btv207r5p4q', '192.168.0.14', 1537401882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373430313838323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('9rs9jdrg8mntgooj62rlcvcqv0ldet9f', '192.168.0.14', 1537401983, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373430313938333b),
  ('9v92tab6j5q0sjvuqj2sl6lsrr63dsaj', '192.168.0.14', 1537482975, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438323937353b),
  ('lq1mdhuu82og01hb6rj6p27aqksk0s06', '192.168.0.14', 1537486636, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438363633363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('o9gvbkmdvfcq3scgdt79rntqkv5tn8gm', '192.168.0.14', 1537486983, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438363938333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('5caeoj4vfp86cg20q155vhvr139jhiif', '192.168.0.14', 1537487881, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438373838313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('65l194quv6c0dd1vdqrev06aaemq2945', '192.168.0.14', 1537487361, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438373336313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('e67htd3drv1glj69sd4dh2fsbvo4bvai', '192.168.0.14', 1537489219, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438393231393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('8omunf1441t38mjn0j1v55hvtor3bqh7', '192.168.0.14', 1537489768, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373438393736383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('7ki0ef5ab53vt4so2g865v89delnutnq', '192.168.0.14', 1537490069, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373439303036393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('9gomnm1nv96vq9efvk6909k7o2osn3ub', '192.168.0.14', 1537490378, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373439303337383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('r04dk8u2o9ebcthjap36ufspm217m6nm', '192.168.0.14', 1537490378, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373439303337383b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('vhita4rbrd31l89cjqv6mquf1a0gsnbm', '192.168.0.14', 1537569461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373536393436313b),
  ('360ki8ov9b83g098ij3d9b2pfjg5e2gg', '192.168.0.14', 1537571461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537313436313b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('5rsf1tj6pfl6be64bpt6gn2cghav574k', '192.168.0.14', 1537573626, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537333632363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('kbc286pkag90cguh2qmir9d8ts7c325a', '192.168.0.14', 1537574106, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537343130363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('1vj3k30pfiv1sqkfunkrqki17a4k8mo5', '192.168.0.14', 1537574677, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537343637373b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('pbh8lniff6k1re5daia7fpi73estlsgc', '192.168.0.14', 1537574999, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537343939393b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('p3lb21k5icqbdduom87p3cb8jcai1m07', '192.168.0.14', 1537575405, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537353430353b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('de8sdnlpaart1s2l4p9tarvcqk0shd5u', '192.168.0.14', 1537575733, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537353733333b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('7lqhsu4jmu7p74imdv0eg459fll9hb08', '192.168.0.14', 1537576046, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537363034363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('7m25mprm6linlea0b2pnt05otukkamdu', '192.168.0.14', 1537576323, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373537363034363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('rcife24o3de40lbujudkgd1n7urljr6c', '192.168.0.14', 1537601472, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373630313437323b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('391frl2skhnbo6mksblrvaraae1nkfsr', '192.168.0.14', 1537601876, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373630313837363b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('e530rfg6e7sa1a5dno391mclk787rp4n', '192.168.0.14', 1537603540, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373630333534303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b),
  ('u5nmiic7564huduf2cgc5m1nfvkt7unr', '192.168.0.14', 1537603593, 0x5f5f63695f6c6173745f726567656e65726174657c693a313533373630333534303b7573657269647c733a313a2231223b6e616d657c733a32313a2256494e494349555320414e4a4f532053414e544f53223b726f6c657c733a313a2231223b6c6f676765647c623a313b);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `comment`
  --
  
  CREATE TABLE IF NOT EXISTS `comment` (
    `commentid` int(11) NOT NULL AUTO_INCREMENT,
    `news` int(11) NOT NULL,
    `author` varchar(255) NOT NULL,
    `emailauthor` varchar(255) NOT NULL,
    `message` text NOT NULL,
    `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `status` tinyint(2) NOT NULL,
    PRIMARY KEY (`commentid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `comment`
  --
  
  INSERT INTO `comment` (`commentid`, `news`, `author`, `emailauthor`, `message`, `date`, `status`) VALUES
  (5, 5, 'O grande testador', 'allydr9597@outlook.com', 'Apenas mais um comentário para testes', '2018-09-17 21:24:00', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `covenants`
  --
  
  CREATE TABLE IF NOT EXISTS `covenants` (
    `covenantsid` int(11) NOT NULL AUTO_INCREMENT,
    `company` varchar(50) NOT NULL,
    `covenantdescription` text NOT NULL,
    `covenantmain` varchar(50) NOT NULL,
    `covenantmini` varchar(50) NOT NULL,
    `signaturedate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `status` tinyint(2) NOT NULL,
    PRIMARY KEY (`covenantsid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `covenants`
  --
  
  INSERT INTO `covenants` (`covenantsid`, `company`, `covenantdescription`, `covenantmain`, `covenantmini`, `signaturedate`, `status`) VALUES
  (1, 'Lumia & Metro Theme', 'Empresa fictícia apenas em caráter de teste', 'e64e88ca56e59d8aa0494c0507c897dc.png', '0259d91e4becb8e062ce1a0e1409f8c1.png', '2018-09-19 22:31:00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `gallery`
  --
  
  CREATE TABLE IF NOT EXISTS `gallery` (
    `photoid` int(11) NOT NULL AUTO_INCREMENT,
    `phototitle` varchar(50) NOT NULL,
    `photodate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `photoaddress` varchar(50) NOT NULL,
    `status` tinyint(2) NOT NULL,
    PRIMARY KEY (`photoid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `gallery`
  --
  
  INSERT INTO `gallery` (`photoid`, `phototitle`, `photodate`, `photoaddress`, `status`) VALUES
  (1, 'Fundação do SINDOJUS-AC', '2017-12-08 05:00:00', 'b374e517deeee231f8a7d0456a4b416e.jpg', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `news`
  --
  
  CREATE TABLE IF NOT EXISTS `news` (
    `newsid` int(11) NOT NULL AUTO_INCREMENT,
    `type` tinyint(1) NOT NULL,
    `title` varchar(255) NOT NULL,
    `abstract` text NOT NULL,
    `content` text NOT NULL,
    `main` varchar(50) NOT NULL,
    `thumb` varchar(50) NOT NULL,
    `internal` varchar(50) NOT NULL,
    `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `status` tinyint(2) NOT NULL,
    PRIMARY KEY (`newsid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `news`
  --
  
  INSERT INTO `news` (`newsid`, `type`, `title`, `abstract`, `content`, `main`, `thumb`, `internal`, `date`, `status`) VALUES
  (1, 1, 'Fundação do SINDOJUS-AC', 'Em 8 de dezembro de 2017, reunidos em Assembleia Geral, os oficiais de Justiça do Acre fundaram o Sindojus-AC (Sindicato dos Oficiais de Justiça do Acre). O objetivo é a representação sindical específica da categoria dos Oficiais de Justiça no Estado do Acre. A Assembleia também elegeu a diretoria e o conselho fiscal da primeira gestão da organização. O primeiro presidente eleito é o oficial de Justiça James Cley Nascimento Borges e para vice foi eleito o oficial de Justiça Cleido Rodrigues da Silva e Silva.', '<p align=\"justify\">\r\n                                    Em 8 de dezembro de 2017, reunidos em Assembleia Geral, \r\n                                    os oficiais de Justiça do Acre fundaram o Sindojus-AC \r\n                                    (Sindicato dos Oficiais de Justiça do Acre). O objetivo \r\n                                    é a representação sindical específica da categoria dos \r\n                                    Oficiais de Justiça no Estado do Acre.\r\n                                    A Assembleia também elegeu a diretoria e o conselho fiscal \r\n                                    da primeira gestão da organização. O primeiro presidente \r\n                                    eleito é o oficial de Justiça James Cley Nascimento Borges \r\n                                    e para vice foi eleito o oficial de Justiça Cleido Rodrigues \r\n                                    da Silva e Silva.\r\n                                </p>', 'bg-1.jpg', 'bg-1thumb.jpg', 'bg-1intern.jpg', '2018-09-18 22:23:05', 1),
  (2, 1, 'SINDOJUS-AC presente na visita da FOJEBRA à PF', 'Representantes do SINDOJUS-AC estiveram juntos com dirigentes da FOJEBRA em reunião com a Dra. Silvana Borges, Diretora Executiva do DIREX, órgão auxiliar da Polícia Federal, e com o Dr. Tony Gean de Castro, Chefe da Divisão Nacional de Armas (DARM). \r\nO presidente da FOJEBRA, Edvaldo Lima, abriu a reunião apresentando a Federação, seus estados componentes, e fazendo um breve histórico do tema “Porte de Arma para os Oficiais de Justiça”.', '<p align=\"justify\">\r\n                                    Os dirigentes da FOJEBRA estiveram em reunião na terça-feira (13/03), \r\n                                    na parte da tarde, com a Dra. Silvana Borges, Diretora Executiva do DIREX, \r\n                                    órgão auxiliar da Polícia Federal, e com o Dr. Tony Gean de Castro, Chefe da \r\n                                    Divisão Nacional de Armas (DARM).\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    O presidente da FOJEBRA, Edvaldo Lima, abriu a reunião apresentando a Federação, \r\n                                    seus estados componentes, e fazendo um breve histórico do tema “Porte de Arma para \r\n                                    os Oficiais de Justiça”.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Oficiais de Justiça de 14 estados do Brasil estiveram presentes e expuseram as \r\n                                    dificuldades específicas encontradas em suas regiões no cumprimento das ordens \r\n                                    judicias. Os diretores da Polícia Federal afirmaram que a instituição está ciente \r\n                                    dessas dificuldades e salientaram que medidas já estão sendo adotadas pelo órgão, \r\n                                    inclusive o Direx já enviou ofício às superintendências regionais tratando do assunto.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Segundo a Dra. Silvana, a atividade dos Oficiais de Justiça “é uma das tarefas mais \r\n                                    difíceis do Poder Judiciário e entendo que o pedido é justo pela natureza do trabalho \r\n                                    que eu conheço muito bem”. A  delegada acrescentou também que o Diretor Geral da PF, \r\n                                    Dr. Rogério Augusto Viana Galloro, também é sensível ao pedido da categoria.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Já o Chefe da Divisão Nacional de Armas, Dr. Tony, elogiou o dossiê elaborado pela \r\n                                    Federação sobre crimes cometidos contra Oficiais de Justiça e afirmou que o \r\n                                    PLC 30/2007 ainda é o melhor caminho para a conquista do pleito pela categoria, \r\n                                    porque a Polícia Federal não pode suprir o papel do legislador, mas fez o que estava \r\n                                    ao alcance da instituição lançando o Ofício Circular 05/2017 através da DIREX.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Foi discutida, ainda, a possibilidade de alteração na Instrução Normativa 23/2005, \r\n                                    com o intuito de deixar o texto mais favorável a essa pretensão dos Oficiais de \r\n                                    Justiça, o que acabou parecendo a todos uma boa solução.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Aproveitando o gancho, o Diretor de Assuntos Legislativos da FOJEBRA, Joselito \r\n                                    Bandeira Vicente, ressaltou o alto índice de violência contra Oficiais de Justiça \r\n                                    no Brasil. “Desde o Estatuto do Desarmamento, tivemos 31 Oficiais mortos, um número \r\n                                    superior até às mortes de Policiais Federais, que foram 10”, disse o dirigente.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Demais presidentes de entidades fizeram suas colocações complementando as falas e \r\n                                    enriquecendo o debate.\r\n                                </p>\r\n                                <p align=\"justify\">\r\n                                    Na oportunidade, o Presidente da FOJEBRA, Edvaldo Lima, agradeceu a receptividade, \r\n                                    o empenho da PF, e se prontificou a ajudar no que for preciso.\r\n                                </p>', 'bg-2.jpg', 'bg-2.jpg', 'bg-2.jpg', '2018-09-13 22:44:40', 1),
  (3, 1, 'SINDOJUS-AC presente em assembléia da FOJEBRA em Brasília', 'Diretores das entidades sindicais de norte a sul do país, estiveram reunidos na sede da Fojebra em Brasília, para realização da assembleia extraordinária convocada para data do dia 09 de julho. Diversos pontos foram deliberados, inclusive medidas eficácias contra entidades sindicais que tentar inibir o trabalho realizado pela Fojebra, inclusive por questões políticas.', '<p align=\"justify\">\r\n                                    Diretores das entidades sindicais de norte a sul do país, estiveram reunidos \r\n                                    na sede da Fojebra em Brasília, para realização da assembleia extraordinária \r\n                                    convocada para data do dia 09 de julho. Diversos pontos foram deliberados, \r\n                                    inclusive medidas eficácias contra entidades sindicais que tentar inibir o \r\n                                    trabalho realizado pela Fojebra, inclusive por questões políticas. Tal postura \r\n                                    anti sindicais vem atrapalhando o desenvolvimento dos Oficiais de Justiça no \r\n                                    Brasil e no Estado referente a essas entidades. É preciso que os Oficiais de \r\n                                    Justiça de alguns Estados da Federação acompanhem o que seus diretores andam \r\n                                    fazendo, explicou Edvaldo Lima. A pedido de um dos coordenadores do “Conojus”, \r\n                                    foi colocado em votação a participação dos membros da Fojebra no referido \r\n                                    Congresso que acontecerá na cidade do Espírito Santo, por unanimidade os 16 \r\n                                    Estados votaram pela não participação no evento. A Fojebra ratifica seus \r\n                                    compromissos com a ética e moral e dentro dos seus quadros de filiados só \r\n                                    aceitará entidades que de fato tenham compromisso com a categoria dos Oficias \r\n                                    de Justiça e que zele pelo bom nome da justiça. Por fim, foi apresentado a \r\n                                    todos os participantes o novo aplicativo, desenvolvido pelo Sindojus-AL que \r\n                                    auxiliará o Oficial de Justiça na resolução dos conflitos. O presidente da \r\n                                    Federação agradeceu a confiança e participação de todos presentes.\r\n                                </p>', 'bg-3.jpg', 'bg-3.jpg', 'bg-3.jpg', '2018-09-13 22:44:44', 1),
  (5, 0, 'Notícia teste (ignore)', 'Noticia em caráter apenas de teste xau', 'Noticia em caráter apenas de teste, agora testando atualização com mudança de foto, veremos...', '392121669f89aaf7cd24d1955ecac381.jpg', '324e1475b6e33c4f9761ea3dab033e12.jpg', '7932b7a375a0927d8e9be2069edf15c3.jpg', '2018-09-13 22:44:49', 1),
  (7, 0, 'Notícia de teste de adaptação', 'Apenas um teste de adaptação do código', 'Apenas um teste de adaptação do código', '', '', '', '2018-09-18 19:27:00', 0),
  (8, 0, 'Outra notícia teste', 'Esta é mais uma notícia de teste de adaptação', 'Esta é mais uma notícia de teste de adaptação', '', '', '', '2018-09-19 15:44:00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `officer`
  --
  
  CREATE TABLE IF NOT EXISTS `officer` (
    `officerid` int(11) NOT NULL AUTO_INCREMENT,
    `userofficer` int(11) NOT NULL,
    `nationality` varchar(50) NOT NULL,
    `homestate` varchar(50) NOT NULL,
    `hometown` varchar(50) NOT NULL,
    `birth` date NOT NULL,
    `cpf` varchar(11) NOT NULL,
    `rg` varchar(11) NOT NULL,
    `marital` varchar(20) NOT NULL,
    `schooling` varchar(50) NOT NULL,
    `voterstitle` varchar(20) NOT NULL,
    `zone` varchar(10) NOT NULL,
    `section` varchar(10) NOT NULL,
    `registration` varchar(15) NOT NULL,
    `office` varchar(50) NOT NULL,
    `crowd` varchar(20) NOT NULL,
    `county` varchar(20) NOT NULL,
    `trustpos` tinyint(4) NOT NULL,
    PRIMARY KEY (`officerid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `partnerships`
  --
  
  CREATE TABLE IF NOT EXISTS `partnerships` (
    `partnershipsid` int(11) NOT NULL AUTO_INCREMENT,
    `partnername` varchar(50) NOT NULL,
    `partnerdescription` text NOT NULL,
    `partnermain` varchar(50) NOT NULL,
    `partnermini` varchar(50) NOT NULL,
    `signaturedate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `status` tinyint(2) NOT NULL,
    PRIMARY KEY (`partnershipsid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `partnerships`
  --
  
  INSERT INTO `partnerships` (`partnershipsid`, `partnername`, `partnerdescription`, `partnermain`, `partnermini`, `signaturedate`, `status`) VALUES
  (2, 'FOJEBRA', ' A Federação das Entidades Representativas dos Oficiais de Justiça Estaduais do Brasil - Fojebra, é a entidade nacional responsável por reunir todos os sindicatos e associações estaduais de Oficiais de Justiça do País. ', '1926ffb0c57d80e301271782720b66b7.png', '924a446ecae96b9e3c766864467a7372.png', '2018-09-19 16:44:00', 1),
  (3, 'TJAC', '   O Tribunal de Justiça do Acre (TJAC) tem como objetivo garantir os direitos do jurisdicionado no Estado do Acre, com justiça, agilidade e ética, promovendo o bem de toda a sociedade.   ', 'a7f13bad6c6ee2d44e32ab6241a3361e.png', '1c05ad3a8f7154199830904dd53f6922.png', '2018-09-19 17:39:00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `phone`
  --
  
  CREATE TABLE IF NOT EXISTS `phone` (
    `phoneid` int(11) NOT NULL AUTO_INCREMENT,
    `userphone` int(11) NOT NULL,
    `number` varchar(255) NOT NULL,
    PRIMARY KEY (`phoneid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `phone`
  --
  
  INSERT INTO `phone` (`phoneid`, `userphone`, `number`) VALUES
  (1, 1, '68992038448');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `user`
  --
  
  CREATE TABLE IF NOT EXISTS `user` (
    `userid` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `email` varchar(50) NOT NULL,
    `username` varchar(25) NOT NULL,
    `password` varchar(32) NOT NULL,
    `role` tinyint(1) NOT NULL,
    `status` tinyint(1) NOT NULL,
    PRIMARY KEY (`userid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Extraindo dados da tabela `user`
  --
  
  INSERT INTO `user` (`userid`, `name`, `email`, `username`, `password`, `role`, `status`) VALUES
  (1, 'VINICIUS ANJOS SANTOS', 'anjos.vinicius@hotmail.com', 'asvinicius', '5eb9d15d46050eaa888e15d8d143d2c8', 1, 1);
  COMMIT;
  
  /*!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 */;
  