-- Table structure for table `submission_search_objects`
--

CREATE TABLE `submission_search_objects` (
  `object_id` bigint NOT NULL AUTO_INCREMENT,
  `submission_id` bigint NOT NULL,
  `type` int NOT NULL,
  `assoc_id` bigint DEFAULT NULL,
  PRIMARY KEY (`object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2311 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submission_search_objects`
--

INSERT INTO `submission_search_objects` VALUES (1778,31,64,0),(1777,31,32,0),(1776,31,8,0),(1775,31,16,0),(1774,31,4,0),(1773,31,2,0),(1772,31,1,0),(2030,49,64,0),(2029,49,32,0),(2028,49,8,0),(2027,49,16,0),(2026,49,4,0),(2025,49,2,0),(2024,49,1,0),(2037,40,64,0),(2036,40,32,0),(2035,40,8,0),(2034,40,16,0),(2033,40,4,0),(2032,40,2,0),(2031,40,1,0),(2044,33,64,0),(2043,33,32,0),(2042,33,8,0),(2041,33,16,0),(2040,33,4,0),(2039,33,2,0),(2038,33,1,0),(1995,55,64,0),(1994,55,32,0),(1993,55,8,0),(1992,55,16,0),(1991,55,4,0),(1990,55,2,0),(1989,55,1,0),(2009,52,64,0),(2008,52,32,0),(2007,52,8,0),(2006,52,16,0),(2005,52,4,0),(2004,52,2,0),(2003,52,1,0),(2023,50,64,0),(2022,50,32,0),(2021,50,8,0),(2020,50,16,0),(2019,50,4,0),(2018,50,2,0),(2017,50,1,0),(1988,56,64,0),(1987,56,32,0),(1986,56,8,0),(1985,56,16,0),(1984,56,4,0),(1983,56,2,0),(1982,56,1,0),(2002,53,64,0),(2001,53,32,0),(2000,53,8,0),(1999,53,16,0),(1998,53,4,0),(1997,53,2,0),(1996,53,1,0),(2016,51,64,0),(2015,51,32,0),(2014,51,8,0),(2013,51,16,0),(2012,51,4,0),(2011,51,2,0),(2010,51,1,0),(1981,57,64,0),(1980,57,32,0),(1979,57,8,0),(1978,57,16,0),(1977,57,4,0),(1976,57,2,0),(1975,57,1,0),(2093,62,64,0),(2092,62,32,0),(2091,62,8,0),(2090,62,16,0),(2089,62,4,0),(2088,62,2,0),(2087,62,1,0),(2058,72,64,0),(2057,72,32,0),(2056,72,8,0),(2055,72,16,0),(2054,72,4,0),(2053,72,2,0),(2052,72,1,0),(2072,66,64,0),(2071,66,32,0),(2070,66,8,0),(2069,66,16,0),(2068,66,4,0),(2067,66,2,0),(2066,66,1,0),(2086,64,64,0),(2085,64,32,0),(2084,64,8,0),(2083,64,16,0),(2082,64,4,0),(2081,64,2,0),(2080,64,1,0),(2051,73,64,0),(2050,73,32,0),(2049,73,8,0),(2048,73,16,0),(2047,73,4,0),(2046,73,2,0),(2045,73,1,0),(2065,70,64,0),(2064,70,32,0),(2063,70,8,0),(2062,70,16,0),(2061,70,4,0),(2060,70,2,0),(2059,70,1,0),(2079,65,64,0),(2078,65,32,0),(2077,65,8,0),(2076,65,16,0),(2075,65,4,0),(2074,65,2,0),(2073,65,1,0),(1967,60,64,0),(1966,60,32,0),(1965,60,8,0),(1964,60,16,0),(1963,60,4,0),(1962,60,2,0),(1961,60,1,0),(1974,58,64,0),(1973,58,32,0),(1972,58,8,0),(1971,58,16,0),(1970,58,4,0),(1969,58,2,0),(1968,58,1,0),(1771,32,64,0),(1770,32,32,0),(1769,32,8,0),(1768,32,16,0),(1767,32,4,0),(1766,32,2,0),(1765,32,1,0),(1764,34,64,0),(1763,34,32,0),(1762,34,8,0),(1761,34,16,0),(1760,34,4,0),(1759,34,2,0),(1758,34,1,0),(1757,35,64,0),(1756,35,32,0),(1755,35,8,0),(1754,35,16,0),(1753,35,4,0),(1752,35,2,0),(1751,35,1,0),(1750,36,64,0),(1749,36,32,0),(1748,36,8,0),(1747,36,16,0),(1746,36,4,0),(1745,36,2,0),(1744,36,1,0),(1743,37,64,0),(1742,37,32,0),(1741,37,8,0),(1740,37,16,0),(1739,37,4,0),(1738,37,2,0),(1737,37,1,0),(1736,38,64,0),(1735,38,32,0),(1734,38,8,0),(1733,38,16,0),(1732,38,4,0),(1731,38,2,0),(1730,38,1,0),(1729,39,64,0),(1728,39,32,0),(1727,39,8,0),(1726,39,16,0),(1725,39,4,0),(1724,39,2,0),(1723,39,1,0),(1722,43,64,0),(1721,43,32,0),(1720,43,8,0),(1719,43,16,0),(1718,43,4,0),(1717,43,2,0),(1716,43,1,0),(1715,21,64,0),(1714,21,32,0),(1713,21,8,0),(1712,21,16,0),(1711,21,4,0),(1710,21,2,0),(1709,21,1,0),(1708,22,64,0),(1707,22,32,0),(1706,22,8,0),(1705,22,16,0),(1704,22,4,0),(1703,22,2,0),(1702,22,1,0),(1652,30,64,0),(1651,30,32,0),(1650,30,8,0),(1649,30,16,0),(1648,30,4,0),(1647,30,2,0),(1646,30,1,0),(1659,28,64,0),(1658,28,32,0),(1657,28,8,0),(1656,28,16,0),(1655,28,4,0),(1654,28,2,0),(1653,28,1,0),(1666,29,64,0),(1665,29,32,0),(1664,29,8,0),(1663,29,16,0),(1662,29,4,0),(1661,29,2,0),(1660,29,1,0),(1673,27,64,0),(1672,27,32,0),(1671,27,8,0),(1670,27,16,0),(1669,27,4,0),(1668,27,2,0),(1667,27,1,0),(1680,26,64,0),(1679,26,32,0),(1678,26,8,0),(1677,26,16,0),(1676,26,4,0),(1675,26,2,0),(1674,26,1,0),(1645,4,64,0),(1644,4,32,0),(1643,4,8,0),(1642,4,16,0),(1641,4,4,0),(1640,4,2,0),(1639,4,1,0),(1687,25,64,0),(1686,25,32,0),(1685,25,8,0),(1684,25,16,0),(1683,25,4,0),(1682,25,2,0),(1681,25,1,0),(1694,24,64,0),(1693,24,32,0),(1692,24,8,0),(1691,24,16,0),(1690,24,4,0),(1689,24,2,0),(1688,24,1,0),(1701,23,64,0),(1700,23,32,0),(1699,23,8,0),(1698,23,16,0),(1697,23,4,0),(1696,23,2,0),(1695,23,1,0),(1575,11,64,0),(1574,11,32,0),(1573,11,8,0),(1572,11,16,0),(1571,11,4,0),(1570,11,2,0),(1569,11,1,0),(1624,1,64,0),(1623,1,32,0),(1622,1,8,0),(1621,1,16,0),(1620,1,4,0),(1619,1,2,0),(1618,1,1,0),(1638,3,64,0),(1637,3,32,0),(1636,3,8,0),(1635,3,16,0),(1634,3,4,0),(1633,3,2,0),(1632,3,1,0),(1603,6,64,0),(1602,6,32,0),(1601,6,8,0),(1600,6,16,0),(1599,6,4,0),(1598,6,2,0),(1597,6,1,0),(1589,5,64,0),(1588,5,32,0),(1587,5,8,0),(1586,5,16,0),(1585,5,4,0),(1584,5,2,0),(1583,5,1,0),(1617,7,64,0),(1616,7,32,0),(1615,7,8,0),(1614,7,16,0),(1613,7,4,0),(1612,7,2,0),(1611,7,1,0),(1596,9,64,0),(1595,9,32,0),(1594,9,8,0),(1593,9,16,0),(1592,9,4,0),(1591,9,2,0),(1590,9,1,0),(1582,8,64,0),(1581,8,32,0),(1580,8,8,0),(1579,8,16,0),(1578,8,4,0),(1577,8,2,0),(1576,8,1,0),(1631,2,64,0),(1630,2,32,0),(1629,2,8,0),(1628,2,16,0),(1627,2,4,0),(1626,2,2,0),(1625,2,1,0),(1610,10,64,0),(1609,10,32,0),(1608,10,8,0),(1607,10,16,0),(1606,10,4,0),(1605,10,2,0),(1604,10,1,0),(1155,17,64,0),(1154,17,32,0),(1153,17,8,0),(1152,17,16,0),(1151,17,4,0),(1150,17,2,0),(1149,17,1,0),(1148,13,64,0),(1147,13,32,0),(1146,13,8,0),(1145,13,16,0),(1144,13,4,0),(1143,13,2,0),(1142,13,1,0),(1141,16,64,0),(1140,16,32,0),(1139,16,8,0),(1138,16,16,0),(1137,16,4,0),(1136,16,2,0),(1135,16,1,0),(1134,19,64,0),(1133,19,32,0),(1132,19,8,0),(1131,19,16,0),(1130,19,4,0),(1129,19,2,0),(1128,19,1,0),(1183,12,64,0),(1182,12,32,0),(1181,12,8,0),(1180,12,16,0),(1179,12,4,0),(1178,12,2,0),(1177,12,1,0),(1176,15,64,0),(1175,15,32,0),(1174,15,8,0),(1173,15,16,0),(1172,15,4,0),(1171,15,2,0),(1170,15,1,0),(1169,18,64,0),(1168,18,32,0),(1167,18,8,0),(1166,18,16,0),(1165,18,4,0),(1164,18,2,0),(1163,18,1,0),(1162,14,64,0),(1161,14,32,0),(1160,14,8,0),(1159,14,16,0),(1158,14,4,0),(1157,14,2,0),(1156,14,1,0),(1127,20,64,0),(1126,20,32,0),(1125,20,8,0),(1124,20,16,0),(1123,20,4,0),(1122,20,2,0),(1121,20,1,0),(2289,67,64,0),(2288,67,32,0),(2287,67,8,0),(2286,67,16,0),(2285,67,4,0),(2284,67,2,0),(2283,67,1,0),(2282,68,64,0),(2281,68,32,0),(2280,68,8,0),(2279,68,16,0),(2278,68,4,0),(2277,68,2,0),(2276,68,1,0),(2275,71,64,0),(2274,71,32,0),(2273,71,8,0),(2272,71,16,0),(2271,71,4,0),(2270,71,2,0),(2269,71,1,0),(2268,74,64,0),(2267,74,32,0),(2266,74,8,0),(2265,74,16,0),(2264,74,4,0),(2263,74,2,0),(2262,74,1,0),(2296,79,64,0),(2295,79,32,0),(2294,79,8,0),(2293,79,16,0),(2292,79,4,0),(2291,79,2,0),(2290,79,1,0),(2303,77,64,0),(2302,77,32,0),(2301,77,8,0),(2300,77,16,0),(2299,77,4,0),(2298,77,2,0),(2297,77,1,0),(2310,75,64,0),(2309,75,32,0),(2308,75,8,0),(2307,75,16,0),(2306,75,4,0),(2305,75,2,0),(2304,75,1,0);

--
-- Table structure for table `submission_settings`
--

CREATE TABLE `submission_settings` (
  `submission_id` bigint NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  UNIQUE KEY `submission_settings_pkey` (`submission_id`,`locale`,`setting_name`),
  KEY `submission_settings_submission_id` (`submission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submission_settings`
--

INSERT INTO `submission_settings` VALUES (62,'','crossref::batchId','_1703251553'),(79,'','crossref::status','registered'),(79,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.79'),(79,'','crossref::batchId','_1703881762'),(77,'','crossref::status','registered'),(77,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.77'),(77,'','crossref::batchId','_1703881766'),(75,'','crossref::status','registered'),(75,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.75'),(75,'','crossref::batchId','_1703881767'),(12,'','crossref::status','registered'),(12,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.12'),(12,'','crossref::batchId','_1715409011'),(62,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.62'),(62,'','crossref::status','registered'),(64,'','crossref::batchId','_1703251551'),(67,'','crossref::batchId','_1703251540'),(73,'','crossref::status','registered'),(73,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.73'),(73,'','crossref::batchId','_1703251542'),(72,'','crossref::status','registered'),(72,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.72'),(72,'','crossref::batchId','_1703251543'),(70,'','crossref::status','registered'),(70,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.70'),(70,'','crossref::batchId','_1703251546'),(66,'','crossref::status','registered'),(66,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.66'),(66,'','crossref::batchId','_1703251548'),(65,'','crossref::status','registered'),(65,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.65'),(65,'','crossref::batchId','_1703251550'),(64,'','crossref::status','registered'),(64,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.64'),(67,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.67'),(67,'','crossref::status','registered'),(68,'','crossref::batchId','_1703251537'),(68,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.68'),(74,'','crossref::batchId','_1703251534'),(68,'','crossref::status','registered'),(19,'','crossref::status','registered'),(19,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.19'),(19,'','crossref::batchId','_1639083922'),(18,'','crossref::status','registered'),(18,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.18'),(18,'','crossref::batchId','_1639083923'),(17,'','crossref::status','registered'),(17,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.17'),(17,'','crossref::batchId','_1639083925'),(16,'','crossref::status','registered'),(16,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.16'),(16,'','crossref::batchId','_1639083927'),(71,'','crossref::status','registered'),(71,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.71'),(71,'','crossref::batchId','_1701566782'),(74,'','crossref::status','registered'),(74,'','crossref::registeredDoi','10.53546/2674-5593.cog.2022.74'),(20,'','crossref::batchId','_1639083920'),(20,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.20'),(21,'','crossref::batchId','_1639083918'),(20,'','crossref::status','registered'),(25,'','crossref::batchId','_1639083910'),(24,'','crossref::status','registered'),(24,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.24'),(24,'','crossref::batchId','_1639083912'),(23,'','crossref::status','registered'),(23,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.23'),(23,'','crossref::batchId','_1639083914'),(22,'','crossref::status','registered'),(22,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.22'),(22,'','crossref::batchId','_1639083916'),(21,'','crossref::status','registered'),(21,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.21'),(25,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.25'),(25,'','crossref::status','registered'),(26,'','crossref::batchId','_1639083908'),(29,'','crossref::batchId','_1639083693'),(28,'','crossref::status','registered'),(28,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.28'),(28,'','crossref::batchId','_1639083695'),(27,'','crossref::status','registered'),(27,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.27'),(27,'','crossref::batchId','_1639083905'),(26,'','crossref::status','registered'),(26,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.26'),(29,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.29'),(29,'','crossref::status','registered'),(30,'','crossref::batchId','_1639083691'),(37,'','crossref::status','registered'),(37,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.37'),(37,'','crossref::batchId','_1639083680'),(36,'','crossref::status','registered'),(36,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.36'),(36,'','crossref::batchId','_1639083681'),(35,'','crossref::status','registered'),(35,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.35'),(35,'','crossref::batchId','_1639083683'),(34,'','crossref::status','registered'),(34,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.34'),(34,'','crossref::batchId','_1639083685'),(32,'','crossref::status','registered'),(32,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.32'),(32,'','crossref::batchId','_1639083687'),(31,'','crossref::status','registered'),(31,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.31'),(31,'','crossref::batchId','_1639083689'),(30,'','crossref::status','registered'),(30,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.30'),(38,'','crossref::batchId','_1639083677'),(38,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.38'),(50,'','crossref::batchId','_1630071803'),(49,'','crossref::status','registered'),(49,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.49'),(49,'','crossref::batchId','_1630071805'),(40,'','crossref::status','registered'),(40,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.40'),(40,'','crossref::batchId','_1630071806'),(33,'','crossref::status','registered'),(33,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.33'),(33,'','crossref::batchId','_1630071807'),(3,'','crossref::status','registered'),(3,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.3'),(3,'','crossref::batchId','_1639083671'),(43,'','crossref::status','registered'),(43,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.43'),(43,'','crossref::batchId','_1639083673'),(39,'','crossref::status','registered'),(39,'','crossref::registeredDoi','10.53546/2674-5593.rc.2020.39'),(39,'','crossref::batchId','_1639083676'),(38,'','crossref::status','registered'),(50,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.50'),(51,'','crossref::batchId','_1630071802'),(50,'','crossref::status','registered'),(51,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.51'),(57,'','crossref::status','registered'),(57,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.57'),(57,'','crossref::batchId','_1630071794'),(56,'','crossref::status','registered'),(56,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.56'),(56,'','crossref::batchId','_1630071796'),(55,'','crossref::status','registered'),(55,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.55'),(55,'','crossref::batchId','_1630071797'),(53,'','crossref::status','registered'),(53,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.53'),(53,'','crossref::batchId','_1630071799'),(52,'','crossref::status','registered'),(52,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.52'),(52,'','crossref::batchId','_1630071800'),(51,'','crossref::status','registered'),(58,'','crossref::batchId','_1630071791'),(58,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.58'),(60,'','crossref::batchId','_1630071788'),(58,'','crossref::status','registered'),(6,'','crossref::batchId','_1629483227'),(5,'','crossref::status','registered'),(5,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.5'),(5,'','crossref::batchId','_1629483228'),(4,'','crossref::status','registered'),(4,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.4'),(4,'','crossref::batchId','_1629483230'),(2,'','crossref::status','registered'),(2,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.2'),(2,'','crossref::batchId','_1629483231'),(1,'','crossref::status','registered'),(1,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.1'),(1,'','crossref::batchId','_1629483232'),(60,'','crossref::status','registered'),(60,'','crossref::registeredDoi','10.53546/2674-5593.cog.2021.60'),(6,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.6'),(6,'','crossref::status','registered'),(7,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.7'),(7,'','crossref::batchId','_1629483226'),(15,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.15'),(15,'','crossref::batchId','_1629483215'),(14,'','crossref::status','registered'),(14,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.14'),(14,'','crossref::batchId','_1629483216'),(13,'','crossref::status','registered'),(13,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.13'),(13,'','crossref::batchId','_1629483218'),(11,'','crossref::status','registered'),(11,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.11'),(11,'','crossref::batchId','_1629483219'),(10,'','crossref::status','registered'),(10,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.10'),(10,'','crossref::batchId','_1629483221'),(9,'','crossref::status','registered'),(9,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.9'),(9,'','crossref::batchId','_1629483223'),(8,'','crossref::status','registered'),(8,'','crossref::registeredDoi','10.53546/2674-5593.rc.2019.8'),(8,'','crossref::batchId','_1629483225'),(7,'','crossref::status','registered'),(15,'','crossref::status','registered');

--
-- Table structure for table `submission_supplementary_files`
--

CREATE TABLE `submission_supplementary_files` (
  `file_id` bigint NOT NULL,
  `revision` bigint NOT NULL,
  PRIMARY KEY (`file_id`,`revision`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submission_supplementary_files`
--

INSERT INTO `submission_supplementary_files` VALUES (181,1),(184,1),(214,1),(254,1),(256,1);

--
-- Table structure for table `submission_tombstones`
--

CREATE TABLE `submission_tombstones` (
  `tombstone_id` bigint NOT NULL AUTO_INCREMENT,
  `submission_id` bigint NOT NULL,
  `date_deleted` datetime NOT NULL,
  `journal_id` bigint NOT NULL,
  `section_id` bigint NOT NULL,
  `set_spec` varchar(255) NOT NULL,
  `set_name` varchar(255) NOT NULL,
  `oai_identifier` varchar(255) NOT NULL,
  PRIMARY KEY (`tombstone_id`),
  KEY `submission_tombstones_journal_id` (`journal_id`),
  KEY `submission_tombstones_submission_id` (`submission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submission_tombstones`
--


--
-- Table structure for table `submission_xml_galleys`
--

CREATE TABLE `submission_xml_galleys` (
  `xml_galley_id` bigint NOT NULL AUTO_INCREMENT,
  `galley_id` bigint NOT NULL,
  `submission_id` bigint NOT NULL,
  `label` varchar(32) NOT NULL,
  `galley_type` varchar(255) NOT NULL,
  `views` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`xml_galley_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submission_xml_galleys`
--


--
-- Table structure for table `submissions`
--

CREATE TABLE `submissions` (
  `submission_id` bigint NOT NULL AUTO_INCREMENT,
  `locale` varchar(14) DEFAULT NULL,
  `context_id` bigint NOT NULL,
  `section_id` bigint DEFAULT NULL,
  `date_submitted` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `submission_progress` tinyint NOT NULL DEFAULT '1',
  `current_publication_id` bigint DEFAULT NULL,
  `date_last_activity` datetime DEFAULT NULL,
  `stage_id` bigint NOT NULL DEFAULT '1',
  `work_type` tinyint DEFAULT '0',
  PRIMARY KEY (`submission_id`),
  KEY `submissions_context_id` (`context_id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submissions`
--

INSERT INTO `submissions` VALUES (1,'pt_BR',1,1,'2020-12-10 16:44:47','2020-12-10 16:44:47',3,0,1,'2022-10-11 10:31:38',1,0),(2,'pt_BR',1,1,'2020-12-10 16:44:47','2020-12-10 16:44:47',3,0,2,'2022-10-11 10:31:38',1,0),(3,'pt_BR',1,1,'2020-12-10 16:44:47','2020-12-10 16:44:47',3,0,63,'2022-10-11 10:31:39',5,0),(4,'pt_BR',1,1,'2020-12-10 16:44:47','2020-12-10 16:44:47',3,0,4,'2022-10-11 10:31:39',1,0),(5,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,5,'2022-10-11 10:31:38',1,0),(6,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,6,'2022-10-11 10:31:38',1,0),(7,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,7,'2022-10-11 10:31:38',1,0),(8,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,8,'2022-10-11 10:31:38',1,0),(9,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,9,'2022-10-11 10:31:38',1,0),(10,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,10,'2022-10-11 10:31:38',1,0),(11,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,11,'2022-10-11 10:31:38',1,0),(12,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,12,'2022-10-11 08:20:02',1,0),(13,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,13,'2022-10-11 08:20:01',1,0),(14,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,14,'2022-10-11 08:20:02',1,0),(15,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,15,'2022-10-11 08:20:02',1,0),(16,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,16,'2022-10-11 08:20:01',1,0),(17,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,17,'2022-10-11 08:20:01',1,0),(18,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,18,'2022-10-11 08:20:02',1,0),(19,'pt_BR',1,1,'2020-12-10 16:44:48','2020-12-10 16:44:48',3,0,19,'2022-10-11 08:20:01',1,0),(20,'pt_BR',1,1,'2020-12-10 16:44:49','2020-12-10 16:44:49',3,0,20,'2022-10-11 08:20:01',1,0),(21,NULL,1,NULL,'2021-01-26 17:27:41','2021-01-26 17:27:41',3,0,21,'2022-10-11 11:32:43',5,0),(22,NULL,1,NULL,'2021-01-26 17:55:26','2021-01-26 17:55:26',3,0,22,'2022-10-11 11:32:43',5,0),(23,NULL,1,NULL,'2021-01-26 19:40:22','2021-01-26 19:40:22',3,0,23,'2022-10-11 11:32:43',5,0),(24,NULL,1,NULL,'2021-01-27 10:45:48','2021-01-27 10:45:48',3,0,24,'2022-10-11 11:32:43',5,0),(25,NULL,1,NULL,'2021-01-27 11:16:33','2021-01-27 11:16:33',3,0,25,'2022-10-11 11:32:43',5,0),(26,NULL,1,NULL,'2021-01-27 16:41:36','2021-01-27 16:41:36',3,0,26,'2022-10-11 11:32:43',5,0),(27,NULL,1,NULL,'2021-01-27 16:53:53','2021-01-27 16:53:53',3,0,27,'2022-10-11 11:32:43',5,0),(28,NULL,1,NULL,'2021-01-27 20:21:36','2021-01-27 20:21:36',3,0,28,'2022-10-11 11:32:43',5,0),(29,NULL,1,NULL,'2021-01-27 17:25:58','2021-01-27 17:25:58',3,0,29,'2022-10-11 11:32:43',5,0),(30,NULL,1,NULL,'2021-01-28 10:05:17','2021-01-28 10:05:17',3,0,30,'2022-10-11 11:32:43',5,0),(31,NULL,1,NULL,'2021-01-28 15:41:45','2021-01-28 15:41:45',3,0,31,'2022-10-11 12:12:16',4,0),(32,NULL,1,NULL,'2021-01-28 15:47:16','2021-01-28 15:47:16',3,0,32,'2022-10-11 12:12:16',4,0),(33,NULL,1,NULL,'2021-01-28 15:53:32','2021-01-28 15:53:32',3,0,33,'2022-10-18 16:56:27',4,0),(34,NULL,1,NULL,'2021-01-28 16:05:06','2021-01-28 16:05:06',3,0,34,'2022-10-11 12:12:16',4,0),(35,NULL,1,NULL,'2021-01-28 16:12:49','2021-01-28 16:12:49',3,0,35,'2022-10-11 12:12:16',4,0),(36,NULL,1,NULL,'2021-01-28 16:20:17','2021-01-28 16:20:17',3,0,36,'2022-10-11 12:12:16',4,0),(37,NULL,1,NULL,'2021-01-28 16:27:25','2021-01-28 16:27:25',3,0,37,'2022-10-11 12:12:16',4,0),(38,NULL,1,NULL,'2021-01-28 16:33:41','2021-01-28 16:33:41',3,0,38,'2022-10-11 12:12:16',4,0),(39,NULL,1,NULL,'2021-01-28 16:39:37','2021-01-28 16:39:37',3,0,39,'2022-10-11 12:12:16',4,0),(40,NULL,1,NULL,'2021-01-31 11:38:10','2021-01-31 11:38:10',3,0,40,'2022-10-18 16:56:27',5,0),(43,NULL,1,NULL,'2021-02-02 14:59:58','2021-02-02 14:59:58',3,0,43,'2022-10-11 12:12:16',4,0),(50,NULL,1,NULL,'2021-04-15 10:36:32','2021-04-15 10:36:32',3,0,50,'2022-10-18 16:56:27',5,0),(49,NULL,1,NULL,'2021-03-20 09:08:31','2021-03-20 09:08:31',3,0,49,'2022-10-18 16:56:27',5,0),(51,NULL,1,NULL,'2021-04-26 21:11:31','2021-04-26 21:11:31',3,0,51,'2022-10-18 16:56:27',5,0),(52,NULL,1,NULL,'2021-05-31 12:51:53','2021-05-31 12:51:53',3,0,52,'2022-10-18 16:56:27',5,0),(53,NULL,1,NULL,'2021-06-15 16:49:53','2021-07-27 19:23:27',3,0,53,'2022-10-18 16:56:27',5,0),(62,NULL,1,NULL,'2022-01-07 22:05:59','2022-01-07 22:05:59',3,0,64,'2022-11-03 19:17:55',4,0),(55,NULL,1,NULL,'2021-07-09 17:37:45','2021-07-09 17:37:45',3,0,55,'2022-10-18 16:56:27',5,0),(56,NULL,1,NULL,'2021-07-11 18:49:54','2021-07-19 19:58:05',3,0,56,'2022-10-18 16:56:27',5,0),(57,NULL,1,NULL,'2021-07-11 19:02:57','2021-07-11 19:02:57',3,0,57,'2022-10-18 16:56:27',5,0),(58,NULL,1,NULL,'2021-07-11 22:07:56','2021-07-11 22:07:56',3,0,58,'2022-10-18 16:56:27',5,0),(75,NULL,1,NULL,'2022-12-13 15:20:21','2023-10-26 21:17:03',3,0,77,'2024-01-27 20:44:31',5,0),(60,NULL,1,NULL,'2021-07-26 22:31:48','2021-08-05 17:49:02',3,0,60,'2022-10-18 16:56:26',5,0),(79,NULL,1,NULL,'2023-12-29 16:55:55','2023-12-29 16:55:55',3,0,81,'2024-01-27 20:44:31',5,0),(74,NULL,1,NULL,'2022-09-28 14:59:51','2022-09-28 14:59:51',3,0,76,'2024-01-27 20:42:25',4,0),(64,NULL,1,NULL,'2022-02-26 17:35:52','2022-02-26 17:35:52',3,0,66,'2022-11-03 19:17:55',4,0),(65,NULL,1,NULL,'2022-02-26 20:12:30','2022-02-26 20:12:30',3,0,67,'2022-11-03 19:17:55',4,0),(66,NULL,1,NULL,'2022-03-15 17:31:45','2022-03-15 17:31:45',3,0,68,'2022-11-03 19:17:55',4,0),(67,NULL,1,NULL,'2022-03-23 13:20:59','2022-04-04 21:36:49',3,0,69,'2024-01-27 20:42:26',4,0),(68,NULL,1,NULL,'2022-04-23 14:28:43','2022-05-11 22:49:24',3,0,70,'2024-01-27 20:42:25',4,0),(76,NULL,1,NULL,NULL,'2023-11-26 16:11:17',1,2,78,'2023-11-26 16:11:17',1,0),(70,NULL,1,NULL,'2022-05-17 09:46:20','2022-05-17 09:46:20',3,0,72,'2022-11-03 19:17:55',4,0),(71,NULL,1,NULL,'2022-07-06 19:47:24','2022-07-06 19:47:24',3,0,73,'2024-01-27 20:42:25',4,0),(72,NULL,1,NULL,'2022-07-10 19:35:40','2022-07-10 19:35:40',3,0,74,'2022-11-03 19:17:55',5,0),(73,NULL,1,NULL,'2022-07-10 19:45:12','2022-07-10 19:45:12',3,0,75,'2022-11-03 19:17:55',4,0),(77,NULL,1,NULL,'2023-11-29 16:10:58','2023-11-29 16:10:58',3,0,79,'2024-01-27 20:44:31',5,0),(78,NULL,1,NULL,'2023-12-05 16:14:50','2024-01-09 16:21:19',5,0,80,'2024-07-09 17:32:07',4,0),(80,NULL,1,NULL,'2024-01-02 11:37:34','2024-01-02 11:37:34',5,0,82,'2024-07-09 17:38:54',5,0),(81,NULL,1,NULL,'2024-01-20 09:26:32','2024-01-20 09:26:32',5,0,83,'2024-07-09 17:35:57',5,0),(82,NULL,1,NULL,'2024-03-25 13:01:46','2024-05-16 12:44:47',1,0,84,'2024-07-09 13:59:22',3,0),(83,NULL,1,NULL,NULL,'2024-07-09 16:53:55',1,3,85,'2024-07-09 16:53:55',1,0),(84,NULL,1,NULL,'2024-05-16 18:26:22','2024-05-16 18:26:22',4,0,86,'2024-05-24 09:45:55',1,0),(85,NULL,1,NULL,'2024-07-12 16:59:35','2024-07-12 16:59:35',1,0,87,'2024-07-12 16:59:40',1,0);

--
-- Table structure for table `subscription_type_settings`
--

CREATE TABLE `subscription_type_settings` (
  `type_id` bigint NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  `setting_type` varchar(6) NOT NULL,
  UNIQUE KEY `subscription_type_settings_pkey` (`type_id`,`locale`,`setting_name`),
  KEY `subscription_type_settings_type_id` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscription_type_settings`
--


--
-- Table structure for table `subscription_types`
--

CREATE TABLE `subscription_types` (
  `type_id` bigint NOT NULL AUTO_INCREMENT,
  `journal_id` bigint NOT NULL,
  `cost` double NOT NULL,
  `currency_code_alpha` varchar(3) NOT NULL,
  `non_expiring` tinyint NOT NULL DEFAULT '0',
  `duration` smallint DEFAULT NULL,
  `format` smallint NOT NULL,
  `institutional` tinyint NOT NULL DEFAULT '0',
  `membership` tinyint NOT NULL DEFAULT '0',
  `disable_public_display` tinyint NOT NULL,
  `seq` double NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscription_types`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `subscription_id` bigint NOT NULL AUTO_INCREMENT,
  `journal_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `type_id` bigint NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `membership` varchar(40) DEFAULT NULL,
  `reference_number` varchar(40) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`subscription_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `temporary_files`
--

CREATE TABLE `temporary_files` (
  `file_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `file_name` varchar(90) NOT NULL,
  `file_type` varchar(255) DEFAULT NULL,
  `file_size` bigint NOT NULL,
  `original_file_name` varchar(127) DEFAULT NULL,
  `date_uploaded` datetime NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `temporary_files_user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temporary_files`
--


--
-- Table structure for table `theses`
--

CREATE TABLE `theses` (
  `thesis_id` bigint NOT NULL AUTO_INCREMENT,
  `journal_id` bigint NOT NULL,
  `status` smallint NOT NULL,
  `degree` smallint NOT NULL,
  `degree_name` varchar(255) DEFAULT NULL,
  `department` varchar(255) NOT NULL,
  `university` varchar(255) NOT NULL,
  `date_approved` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` mediumtext,
  `abstract` mediumtext,
  `comment` mediumtext,
  `student_first_name` varchar(40) NOT NULL,
  `student_middle_name` varchar(40) DEFAULT NULL,
  `student_last_name` varchar(90) NOT NULL,
  `student_email` varchar(90) NOT NULL,
  `student_email_publish` tinyint DEFAULT '0',
  `student_bio` mediumtext,
  `supervisor_first_name` varchar(40) NOT NULL,
  `supervisor_middle_name` varchar(40) DEFAULT NULL,
  `supervisor_last_name` varchar(90) NOT NULL,
  `supervisor_email` varchar(90) NOT NULL,
  `discipline` varchar(255) DEFAULT NULL,
  `subject_class` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `coverage_geo` varchar(255) DEFAULT NULL,
  `coverage_chron` varchar(255) DEFAULT NULL,
  `coverage_sample` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `language` varchar(10) DEFAULT 'en',
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`thesis_id`),
  KEY `theses_journal_id` (`journal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `theses`
--


--
-- Table structure for table `usage_stats_temporary_records`
--

CREATE TABLE `usage_stats_temporary_records` (
  `assoc_id` bigint NOT NULL,
  `assoc_type` bigint NOT NULL,
  `day` bigint NOT NULL,
  `metric` bigint NOT NULL DEFAULT '1',
  `country_id` varchar(2) DEFAULT NULL,
  `region` varchar(2) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `load_id` varchar(255) NOT NULL,
  `file_type` tinyint DEFAULT NULL,
  `entry_time` bigint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usage_stats_temporary_records`
--

INSERT INTO `usage_stats_temporary_records` VALUES (39,1048585,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616360470),(3,515,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',2,1616356895),(3,1048585,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616356793),(96,515,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',2,1616353851),(23,1048585,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616353846),(93,515,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',2,1616348831),(2,1048585,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616331483),(2,515,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',2,1616331030),(1,259,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616331017),(2,1048585,20210321,1,NULL,NULL,NULL,'usage_events_20210321.log',0,1616330922),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665528353),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665527326),(62,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524314),(66,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524311),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524296),(31,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524268),(31,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524256),(43,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524217),(39,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524213),(4,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665524184),(33,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523309),(5,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523304),(56,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523295),(5,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523292),(62,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523282),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665523279),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665522771),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665519367),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665519323),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665519291),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665519259),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665518185),(73,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511901),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511896),(62,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511882),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511879),(64,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511819),(231,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665511815),(6,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665511798),(19,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665509300),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665509292),(16,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665508619),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665508616),(13,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665508596),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665508590),(5,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665504492),(12,261,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665504457),(5,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665504442),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665504409),(225,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665503078),(40,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665503059),(60,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665503054),(56,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665503050),(5,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665503039),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501511),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501495),(86,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665501218),(37,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501209),(36,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501200),(32,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501185),(4,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665501176),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665498973),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665498961),(21,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665498839),(222,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665498809),(3,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665498792),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665497071),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665497053),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665496963),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665496860),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665496814),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665496537),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665496524),(18,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495206),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495198),(9,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495188),(7,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495180),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495152),(220,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665495141),(9,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495137),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665495130),(9,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665494441),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665494435),(1,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493538),(9,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493521),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493460),(9,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493272),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493263),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493055),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665493003),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492945),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492924),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492913),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492893),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492880),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492862),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492855),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492807),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492785),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492755),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492730),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492704),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492677),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492657),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492627),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492616),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492583),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492562),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492548),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492527),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492500),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492488),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492474),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492394),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492366),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492343),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665492318),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665491044),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665488087),(16,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665487280),(19,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665487272),(12,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665487264),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665487245),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665487210),(20,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486225),(19,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486223),(18,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486221),(17,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486219),(16,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486217),(15,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486216),(14,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486212),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486207),(13,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486196),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486192),(11,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486160),(10,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486156),(9,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486151),(8,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486144),(7,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486139),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486128),(6,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486123),(6,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486121),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486111),(5,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486106),(5,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486103),(4,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486095),(171,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486088),(4,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486086),(2,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486075),(2,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486062),(1,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665486015),(1,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665486007),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485979),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485862),(12,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485854),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485848),(95,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649274810),(157,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649274726),(18,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649274627),(18,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649274619),(160,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649270886),(93,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649270589),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649268933),(157,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649266627),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649265926),(85,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649265770),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649265312),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649264550),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649263645),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649263468),(21,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649263332),(10,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649261189),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649261026),(5,259,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649260818),(164,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649257592),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649256164),(2,259,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649256163),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649256152),(158,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649251899),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649251872),(92,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649251554),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649251282),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649251182),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649251039),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250898),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649250876),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250846),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250815),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649250791),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250736),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250641),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250543),(158,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250530),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649250527),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649250511),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649250464),(21,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649249825),(16,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649248998),(92,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649248390),(10,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649248128),(10,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649248106),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649248105),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649242062),(92,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649240837),(92,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649240825),(17,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649240042),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649239660),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649236538),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649235545),(164,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649234602),(50,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649234571),(92,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649234278),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649231688),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649230690),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649223689),(38,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649222486),(94,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649219385),(4,259,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649219198),(89,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649219176),(38,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649219005),(38,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649218995),(1,256,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649218893),(91,515,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',2,1649218712),(58,1048585,20220406,1,NULL,NULL,NULL,'usage_events_20220406.log',0,1649215844),(12,1048585,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485823),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485817),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665485793),(109,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484821),(19,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484808),(18,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484790),(17,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484779),(16,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484762),(15,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484749),(14,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484736),(13,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484712),(12,515,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',2,1665484662),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665484656),(2,259,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665484607),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665481134),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665476922),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665467319),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665463882),(1,256,20221011,1,NULL,NULL,NULL,'usage_events_20221011.log',0,1665459733);

--
-- Table structure for table `user_group_settings`
--

CREATE TABLE `user_group_settings` (
  `user_group_id` bigint NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  `setting_type` varchar(6) NOT NULL,
  UNIQUE KEY `user_group_settings_pkey` (`user_group_id`,`locale`,`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_settings`
--

INSERT INTO `user_group_settings` VALUES (2,'','nameLocaleKey','default.groups.name.manager','string'),(2,'','abbrevLocaleKey','default.groups.abbrev.manager','string'),(2,'pt_BR','name','Gerente da revista','string'),(2,'pt_BR','abbrev','GR','string'),(3,'','nameLocaleKey','default.groups.name.editor','string'),(3,'','abbrevLocaleKey','default.groups.abbrev.editor','string'),(3,'pt_BR','name','Editor da revista','string'),(3,'pt_BR','abbrev','ER','string'),(4,'','nameLocaleKey','default.groups.name.productionEditor','string'),(4,'','abbrevLocaleKey','default.groups.abbrev.productionEditor','string'),(4,'pt_BR','name','Editor de Leiaute','string'),(4,'pt_BR','abbrev','EP','string'),(5,'','nameLocaleKey','default.groups.name.sectionEditor','string'),(5,'','abbrevLocaleKey','default.groups.abbrev.sectionEditor','string'),(5,'pt_BR','name','Editor de seção','string'),(5,'pt_BR','abbrev','ESeç','string'),(6,'','nameLocaleKey','default.groups.name.guestEditor','string'),(6,'','abbrevLocaleKey','default.groups.abbrev.guestEditor','string'),(6,'pt_BR','name','Editor convidado','string'),(6,'pt_BR','abbrev','EConv','string'),(7,'','nameLocaleKey','default.groups.name.copyeditor','string'),(7,'','abbrevLocaleKey','default.groups.abbrev.copyeditor','string'),(7,'pt_BR','name','Editor de texto','string'),(7,'pt_BR','abbrev','ET','string'),(8,'','nameLocaleKey','default.groups.name.designer','string'),(8,'','abbrevLocaleKey','default.groups.abbrev.designer','string'),(8,'pt_BR','name','Designer','string'),(8,'pt_BR','abbrev','DE','string'),(9,'','nameLocaleKey','default.groups.name.funding','string'),(9,'','abbrevLocaleKey','default.groups.abbrev.funding','string'),(9,'pt_BR','name','Coordenador de Financiamento','string'),(9,'pt_BR','abbrev','CF','string'),(10,'','nameLocaleKey','default.groups.name.indexer','string'),(10,'','abbrevLocaleKey','default.groups.abbrev.indexer','string'),(10,'pt_BR','name','Indexador','string'),(10,'pt_BR','abbrev','IND','string'),(11,'','nameLocaleKey','default.groups.name.layoutEditor','string'),(11,'','abbrevLocaleKey','default.groups.abbrev.layoutEditor','string'),(11,'pt_BR','name','Editor de Leiaute','string'),(11,'pt_BR','abbrev','EL','string'),(12,'','nameLocaleKey','default.groups.name.marketing','string'),(12,'','abbrevLocaleKey','default.groups.abbrev.marketing','string'),(12,'pt_BR','name','Coordenador de Vendas e Marketing','string'),(12,'pt_BR','abbrev','CVM','string'),(13,'','nameLocaleKey','default.groups.name.proofreader','string'),(13,'','abbrevLocaleKey','default.groups.abbrev.proofreader','string'),(13,'pt_BR','name','Leitor de Prova','string'),(13,'pt_BR','abbrev','LP','string'),(14,'','nameLocaleKey','default.groups.name.author','string'),(14,'','abbrevLocaleKey','default.groups.abbrev.author','string'),(14,'pt_BR','name','Autor','string'),(14,'pt_BR','abbrev','AU','string'),(15,'','nameLocaleKey','default.groups.name.translator','string'),(15,'','abbrevLocaleKey','default.groups.abbrev.translator','string'),(15,'pt_BR','name','Tradutor','string'),(15,'pt_BR','abbrev','TR','string'),(16,'','nameLocaleKey','default.groups.name.externalReviewer','string'),(16,'','abbrevLocaleKey','default.groups.abbrev.externalReviewer','string'),(16,'pt_BR','name','Avaliador','string'),(16,'pt_BR','abbrev','A','string'),(17,'','nameLocaleKey','default.groups.name.reader','string'),(17,'','abbrevLocaleKey','default.groups.abbrev.reader','string'),(17,'pt_BR','name','Leitor','string'),(17,'pt_BR','abbrev','LE','string'),(18,'','nameLocaleKey','default.groups.name.subscriptionManager','string'),(18,'','abbrevLocaleKey','default.groups.abbrev.subscriptionManager','string'),(18,'pt_BR','name','Gerente de assinatura','string'),(18,'pt_BR','abbrev','GAssin','string'),(5,'','recommendOnly','0','bool');

--
-- Table structure for table `user_group_stage`
--

CREATE TABLE `user_group_stage` (
  `context_id` bigint NOT NULL,
  `user_group_id` bigint NOT NULL,
  `stage_id` bigint NOT NULL,
  UNIQUE KEY `user_group_stage_pkey` (`context_id`,`user_group_id`,`stage_id`),
  KEY `user_group_stage_context_id` (`context_id`),
  KEY `user_group_stage_user_group_id` (`user_group_id`),
  KEY `user_group_stage_stage_id` (`stage_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_stage`
--

INSERT INTO `user_group_stage` VALUES (1,3,1),(1,3,3),(1,3,4),(1,3,5),(1,4,4),(1,4,5),(1,5,3),(1,5,4),(1,5,5),(1,6,1),(1,6,3),(1,6,4),(1,6,5),(1,7,4),(1,8,5),(1,9,1),(1,9,3),(1,10,5),(1,11,5),(1,12,4),(1,13,5),(1,14,1),(1,14,3),(1,14,4),(1,15,1),(1,15,3),(1,15,4),(1,16,3);

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `user_group_id` bigint NOT NULL AUTO_INCREMENT,
  `context_id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `is_default` tinyint NOT NULL DEFAULT '0',
  `show_title` tinyint NOT NULL DEFAULT '1',
  `permit_self_registration` tinyint NOT NULL DEFAULT '0',
  `permit_metadata_edit` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_group_id`),
  KEY `user_groups_user_group_id` (`user_group_id`),
  KEY `user_groups_context_id` (`context_id`),
  KEY `user_groups_role_id` (`role_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` VALUES (1,0,1,1,1,0,0),(2,1,16,1,0,0,1),(3,1,16,1,0,0,1),(4,1,16,1,0,0,1),(5,1,17,1,0,0,1),(6,1,17,1,0,0,0),(7,1,4097,1,0,0,0),(8,1,4097,1,0,0,0),(9,1,4097,1,0,0,0),(10,1,4097,1,0,0,0),(11,1,4097,1,0,0,0),(12,1,4097,1,0,0,0),(13,1,4097,1,0,0,0),(14,1,65536,1,0,1,0),(15,1,65536,1,0,0,0),(16,1,4096,1,0,1,0),(17,1,1048576,1,0,1,0),(18,1,2097152,1,0,0,0);

--
-- Table structure for table `user_interests`
--

CREATE TABLE `user_interests` (
  `user_id` bigint NOT NULL,
  `controlled_vocab_entry_id` bigint NOT NULL,
  UNIQUE KEY `u_e_pkey` (`user_id`,`controlled_vocab_entry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_interests`
--

INSERT INTO `user_interests` VALUES (3,318),(5,317),(6,317),(7,317),(8,319),(9,320),(10,321),(10,322),(11,323),(12,322),(12,324),(13,325),(14,326),(15,322),(15,327),(16,328),(17,329),(18,330),(18,331),(19,332),(19,333),(20,334),(21,335),(21,336),(22,337),(23,317),(24,319),(25,338),(25,339),(26,340),(27,341),(27,342),(28,317),(29,317),(30,317),(31,317),(32,343),(32,344),(33,325),(33,345),(34,346),(35,331),(36,347),(36,348),(37,317),(38,322),(38,349),(39,350),(39,351),(40,335),(40,352),(41,353),(41,354),(42,335),(42,355),(43,356),(43,357),(44,328),(44,332),(45,351),(45,358),(46,359),(47,360),(48,361),(49,317),(50,317),(51,504),(51,505),(51,506),(52,507),(52,508),(52,509),(55,504),(56,504),(62,1637),(63,1643),(66,1664),(67,318),(67,1677),(69,1678),(69,1679),(69,1680),(73,504),(76,2344),(76,2345),(76,2346),(76,2347),(76,2348),(82,504),(85,318),(86,318),(87,318),(88,1678),(88,1679),(90,6853),(94,1678),(94,6992),(94,6993),(94,6994),(95,6995),(95,6996),(95,6997),(95,6998),(97,7002),(98,7294),(99,504),(99,7310),(99,7311),(99,7312),(99,7313),(99,7314),(99,7315),(99,7316),(99,7317),(99,7318),(108,7415);

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `user_id` bigint NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `assoc_type` bigint DEFAULT '0',
  `assoc_id` bigint DEFAULT '0',
  `setting_value` mediumtext,
  `setting_type` varchar(6) NOT NULL,
  UNIQUE KEY `user_settings_pkey` (`user_id`,`locale`,`setting_name`,`assoc_type`,`assoc_id`),
  KEY `user_settings_user_id` (`user_id`),
  KEY `user_settings_locale_setting_name_index` (`setting_name`,`locale`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_settings`
--

INSERT INTO `user_settings` VALUES (2,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(3,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(4,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(6,'pt_BR','affiliation',0,0,'ESLA','string'),(8,'pt_BR','biography',0,0,'Hello, I\'m Arielle, a 23 year old from Pemberton, Australia.\r\nMy hobbies include (but are not limited to) RC cars, Figure skating and watching How I Met Your Mother.','string'),(8,'pt_BR','signature',0,0,'My website: cialis on sale in usa','string'),(9,'pt_BR','biography',0,0,'Hello, dear friend! I am Roxana. I smile that I can unify to the entire world. I live in Poland, in the south region. I dream to see the various nations, to obtain acquainted with fascinating individuals.','string'),(9,'pt_BR','signature',0,0,'Also visit my website - block ads using dns server','string'),(10,'pt_BR','biography',0,0,'Hello, dear friend! I am Theresa. I am satisfied that I could unite to the entire world. I live in Great Britain, in the NA region. I dream to go to the different countries, to get acquainted with intriguing people.','string'),(10,'pt_BR','signature',0,0,'Also visit my blog - cara hemat baterai ios 11','string'),(11,'pt_BR','biography',0,0,'Name: Colleen Zielinski\r\nMy age: 33 years old\r\nCountry: Great Britain\r\nHome town: Morley Green \r\nPostal code: Sk9 7ng\r\nStreet: 55 Preston Rd','string'),(11,'pt_BR','signature',0,0,'Feel free to visit my web site; intip Wifi password','string'),(12,'pt_BR','biography',0,0,'Hello, I\'m Julienne, a 28 year old from Fort Mcmurray, Canada.\r\nMy hobbies include (but are not limited to) Paintball, Rock collecting and watching Supernatural.','string'),(12,'pt_BR','signature',0,0,'Check out my blog post; clear browser history','string'),(13,'pt_BR','biography',0,0,'I\'m Kristofer and was born on 14 October 1987. My hobbies are Baton twirling and Fishkeeping.','string'),(13,'pt_BR','signature',0,0,'Stop by my web-site; cialis','string'),(14,'pt_BR','biography',0,0,'I\'m Darci and I live with my husband and our three children in Helmeroth, in the RP south area. My hobbies are Gaming, Archery and Homebrewing.','string'),(14,'pt_BR','signature',0,0,'Here is my webpage: whatsapp tips dan tick','string'),(15,'pt_BR','biography',0,0,'My name: Bobbie Gruner\r\nAge: 31 years old\r\nCountry: Germany\r\nTown: Windbergen \r\nPostal code: 25729\r\nStreet: Kastanienallee 62','string'),(15,'pt_BR','signature',0,0,'Feel free to surf to my web blog cara hemat baterai menggunakan greenify (jurnal.untan.ac.id)','string'),(16,'pt_BR','biography',0,0,'Hi there! :) My name is Alexandra, I\'m a student studying Physical from Anniston, United States.','string'),(16,'pt_BR','signature',0,0,'Feel free to visit my blog tips blackberry berguna (revistamutatismutandis.com)','string'),(17,'pt_BR','biography',0,0,'Name: Ericka Northmore\r\nMy age: 27\r\nCountry: Netherlands\r\nHome town: Landgraaf \r\nZIP: 6373 Xb\r\nAddress: Achter De Heggen 2','string'),(17,'pt_BR','signature',0,0,'My blog - clear browser history','string'),(18,'pt_BR','biography',0,0,'My name is Tanya (29 years old) and my hobbies are Auto racing and Australian Football League.','string'),(18,'pt_BR','signature',0,0,'Here is my web page - mode hemat baterai oppo f7 (http://educacionyciencia.org)','string'),(19,'pt_BR','biography',0,0,'I\'m Shari and was born on 5 October 1973. My hobbies are Herpetoculture and Videophilia (Home theater).','string'),(19,'pt_BR','signature',0,0,'Visit my webpage :: whatsapp tips dan tick','string'),(20,'pt_BR','biography',0,0,'I\'m Indira (18) from Kiel, Germany. \r\nI\'m learning Hindi literature at a local high school and I\'m just about to graduate.\r\nI have a part time job in a post office.','string'),(20,'pt_BR','signature',0,0,'Also visit my web page ... tips blackberry berguna','string'),(21,'pt_BR','biography',0,0,'I\'m Jacob (18) from Porto Alegre, Brazil. \r\nI\'m learning Italian literature at a local high school and I\'m just about to graduate.\r\nI have a part time job in a university.','string'),(21,'pt_BR','signature',0,0,'Look at my web blog :: intip wifi password (http://educacionyciencia.org/index.php/educacionyciencia/article/view/274/456483)','string'),(22,'pt_BR','biography',0,0,'There is nothing to write about myself I think.\r\nI enjoy of finally being a member of this community.\r\nI really wish I\'m useful at all','string'),(22,'pt_BR','signature',0,0,'Here is my web blog; android facebook tips (revistamutatismutandis.com)','string'),(23,'pt_BR','signature',0,0,'Marcos Kruse\r\nBel Bel Theol, Economista, Bel e Doutorando em Direito pela UNLZ com tese sobre usura.','string'),(23,'pt_BR','affiliation',0,0,'Universidad Nacional Lomas de Zamora','string'),(24,'pt_BR','biography',0,0,'Hi there! :) My name is Freddie, I\'m a student studying Psychology from Deenethorpe, Great Britain.','string'),(24,'pt_BR','signature',0,0,'Check out my website; block ads using dns server','string'),(25,'pt_BR','biography',0,0,'Hello, I\'m Kristen, a 29 year old from Hafnir, Iceland.\r\nMy hobbies include (but are not limited to) Skateboarding, Gaming and watching Psych.','string'),(25,'pt_BR','signature',0,0,'My website: blokir iklan','string'),(26,'pt_BR','biography',0,0,'Hello! \r\nI\'m Swedish male :). \r\nI really love The Big Bang Theory!','string'),(26,'pt_BR','signature',0,0,'Feel free to visit my site :: tips for android nougat (ppct.caicyt.gov.ar)','string'),(27,'pt_BR','biography',0,0,'Not much to say about myself at all.\r\nFeels good to be a member of this site.\r\nI just hope Im useful at all','string'),(27,'pt_BR','signature',0,0,'Take a look at my homepage - android tips dan trik (http://revistas.ucm.es/index.php/TEKN/article/view/48224/4564456549446)','string'),(28,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(29,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(30,'pt_BR','affiliation',0,0,'Universidade Federal do Paraná','string'),(31,'pt_BR','affiliation',0,0,'Universidade Federal de Santa Catarina','string'),(32,'pt_BR','biography',0,0,'I\'m Don (21) from Soest, Netherlands. \r\nI\'m learning French literature at a local university and I\'m just about to graduate.\r\nI have a part time job in a the office.','string'),(32,'pt_BR','signature',0,0,'Have a look at my homepage block ads using dns server','string'),(33,'pt_BR','biography',0,0,'Hello! My name is Penney. I am delighted that I can unify to the entire globe. I live in Norway, in the NA region. I dream to visit the different nations, to look for acquainted with intriguing individuals.','string'),(33,'pt_BR','signature',0,0,'Visit my web page ... akun wifi','string'),(34,'pt_BR','biography',0,0,'Hello! \r\nI\'m Vietnamese male :). \r\nI really love Sons of Anarchy!','string'),(34,'pt_BR','signature',0,0,'my homepage: block ads using dns server','string'),(35,'pt_BR','biography',0,0,'Nothing to tell about me I think.\r\nYes! Im a member of fidelis.edu.br.\r\nI really wish I\'m useful in one way here.','string'),(35,'pt_BR','signature',0,0,'my webpage; block ads using dns server','string'),(36,'pt_BR','biography',0,0,'Nothing to write about myself at all.\r\nFeels good to be a part of fidelis.edu.br.\r\nI really hope I\'m useful at all','string'),(36,'pt_BR','signature',0,0,'Also visit my blog block ads using dns server','string'),(37,'pt_BR','biography',0,0,'<p><span>Escritora, professora, linguista, teóloga e tradutora, há mais de vinte anos envolvida no trabalho de produção de material e ensino tanto no Brasil quanto em Moçambique. Licenciada em Letras - Português-Inglês pela Pontifícia Universidade Católica do Paraná – PUC/PR. Bacharel em Teologia pela Faculdade Fidelis, Curitiba/PR. Mestre em Teologia pela Pontifícia Universidade Católica do Paraná – PUC/PR. Publicou três livros nas áreas de Ciências da Religião, Teologia e Letras. Associada à ABIB – Associação Brasileira de Pesquisa Bíblica e participante da AHDig – Associação das Humanidades Digitais. Leciona Ciências da Religião, Religiões Comparadas, Diálogo Inter-religioso, Educação Étnico-Racial: cultura indígena e afrobrasileira, Hebraico Bíblico Instrumental e Grego Bíblico Instrumental na Faculdade Fidelis e na Faculdade Luterana de Teologia. Promove debates e reuniões informais além de ministrar aulas particulares de português, hebraico e inglês, seminários e cursos livres nas áreas de linguística, tradução, educação, teologia e missiologia, e efetuar correções de textos em português. Mantém-se ensinando e escrevendo, tanto em verso quanto em prosa, ligada ao teatro e à pintura, com o desejo de prosseguir em suas pesquisas (nas áreas de educação, teologia e letras) e trabalhos interculturais. </span></p><p><span>Lattes: <a title=\"Endereço para acessar este CV:\" tabindex=\"212\" href=\"https://wwws.cnpq.br/cvlattesweb/PKG_MENU.menu?f_cod=F00B5CFC36A61CDF0A8BF9533AAC90C4\"><strong>http://lattes.cnpq.br/7903250329441047</strong></a></span></p>','string'),(37,'pt_BR','signature',0,0,'Angela Natel','string'),(37,'pt_BR','affiliation',0,0,'Associação Brasileira de Pesquisa Bíblica - ABIB','string'),(38,'pt_BR','biography',0,0,'Got nothing to write about myself I think.\r\nLovely to be a member of fidelis.edu.br.\r\nI just wish I am useful in some way .','string'),(38,'pt_BR','signature',0,0,'my blog post block ads using dns server','string'),(39,'pt_BR','biography',0,0,'Hi! \r\nMy name is Virgilio and I\'m a 23 years old boy from Delft.','string'),(39,'pt_BR','signature',0,0,'Here is my weblog: wifi password (http://edwardgeorge.com.au/_blog/Featured_Articles/post/Social_Media_Recruitment_for_the_Little_Guy/?page=24)','string'),(40,'pt_BR','biography',0,0,'Hello from Sweden. I\'m glad to came across you. My first name is Ethan. \r\nI live in a small city called Katrineholm in western Sweden.\r\nI was also born in Katrineholm 28 years ago. Married in September 2012. I\'m working at the the office.','string'),(40,'pt_BR','signature',0,0,'My web blog adi sucipto','string'),(41,'pt_BR','biography',0,0,'I\'m Sammie and I live in Urmitz. \r\nI\'m interested in Psychology, Leaf collecting and pressing and Hindi art. I like travelling and watching 2 Broke Girls.','string'),(41,'pt_BR','signature',0,0,'Also visit my homepage; triaskitchen (https://www.triaskitchen.web.id/)','string'),(42,'pt_BR','biography',0,0,'Name: Tyson Lalonde\r\nMy age: 40 years old\r\nCountry: France\r\nTown: Toulouse \r\nPost code: 31200\r\nStreet: 87 Rue Pierre De Coubertin','string'),(42,'pt_BR','signature',0,0,'Take a look at my web page; oktrik.com (arkitekturforskning.net)','string'),(43,'pt_BR','biography',0,0,'Hello, I\'m Opal, a 21 year old from Oratino, Italy.\r\nMy hobbies include (but are not limited to) Aircraft spotting, Poker and watching Doctor Who.','string'),(43,'pt_BR','signature',0,0,'My web-site lacak hp hilang - http://www.annalesumng.org/index.php/ssa/article/view/27/182263 -','string'),(44,'pt_BR','biography',0,0,'30 yr old Insurance Danger Surveyor Nicole from Owen Sound, likes garage saleing, How To Delete Your Browsing History In Google Chrome and films. May be inspired how large the globe is after going to Mausoleum of Khoja Ahmed Yasawi.','string'),(44,'pt_BR','signature',0,0,'Visit my weblog chrome history delete (www.ajhpe.org.za)','string'),(45,'pt_BR','biography',0,0,'Hello! \r\nI\'m Vietnamese female :). \r\nI really like Herpetoculture!','string'),(45,'pt_BR','signature',0,0,'My site - adi sucipto (https://www.adisucipto.web.id/)','string'),(46,'pt_BR','biography',0,0,'I\'m a 30 years old, married and study at the college (Graduate School).\r\nIn my free time I teach myself Hindi. I\'ve been  there and look forward to go there anytime soon. I love to read, preferably on my beloved Kindle. I really love to watch 2 Broke Girls and Psych as well as docus about anything geological. I enjoy Seaglass collecting.','string'),(46,'pt_BR','signature',0,0,'Look into my weblog trias Kitchen','string'),(47,'pt_BR','biography',0,0,'Hello, I\'m Sabina, a 26 year old from Rennes, France.\r\nMy hobbies include (but are not limited to) Insect collecting, Gardening and watching 2 Broke Girls.','string'),(47,'pt_BR','signature',0,0,'Here is my web site oke trik','string'),(49,'pt_BR','affiliation',0,0,'Faculdade ISULPAR.','string'),(50,'pt_BR','signature',0,0,'Heide Siebert Koop','string'),(50,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(1,'pt_BR','givenName',0,0,'lampiao','string'),(2,'pt_BR','givenName',0,0,'Katiane Janke','string'),(3,'pt_BR','givenName',0,0,'Clayton Lima de','string'),(4,'pt_BR','givenName',0,0,'Bruna Cristine','string'),(5,'pt_BR','givenName',0,0,'Udo','string'),(6,'pt_BR','givenName',0,0,'Paulo Sergio','string'),(7,'pt_BR','givenName',0,0,'Bruno','string'),(8,'pt_BR','givenName',0,0,'Arielle','string'),(9,'pt_BR','givenName',0,0,'Roxana','string'),(10,'pt_BR','givenName',0,0,'Theresa','string'),(11,'pt_BR','givenName',0,0,'Colleen','string'),(12,'pt_BR','givenName',0,0,'Julienne','string'),(13,'pt_BR','givenName',0,0,'Kristofer','string'),(14,'pt_BR','givenName',0,0,'Darci','string'),(15,'pt_BR','givenName',0,0,'Bobbie','string'),(16,'pt_BR','givenName',0,0,'Alexandra','string'),(17,'pt_BR','givenName',0,0,'Ericka','string'),(18,'pt_BR','givenName',0,0,'Tanya','string'),(19,'pt_BR','givenName',0,0,'Shari','string'),(20,'pt_BR','givenName',0,0,'Indira','string'),(21,'pt_BR','givenName',0,0,'Jacob','string'),(22,'pt_BR','givenName',0,0,'Bette','string'),(23,'pt_BR','givenName',0,0,'Marcos','string'),(24,'pt_BR','givenName',0,0,'Freddie','string'),(25,'pt_BR','givenName',0,0,'Kristen','string'),(26,'pt_BR','givenName',0,0,'Elbert','string'),(27,'pt_BR','givenName',0,0,'Maurine','string'),(28,'pt_BR','givenName',0,0,'Arthur Wesley','string'),(29,'pt_BR','givenName',0,0,'Angela Maria','string'),(30,'pt_BR','givenName',0,0,'Henrique Evaldo','string'),(31,'pt_BR','givenName',0,0,'Marcelo Sanches','string'),(32,'pt_BR','givenName',0,0,'Don','string'),(33,'pt_BR','givenName',0,0,'Penney','string'),(34,'pt_BR','givenName',0,0,'Kelley','string'),(35,'pt_BR','givenName',0,0,'Kirk','string'),(36,'pt_BR','givenName',0,0,'Chau','string'),(37,'pt_BR','givenName',0,0,'Angela','string'),(38,'pt_BR','givenName',0,0,'Vanita','string'),(39,'pt_BR','givenName',0,0,'Virgilio','string'),(40,'pt_BR','givenName',0,0,'Ethan','string'),(41,'pt_BR','givenName',0,0,'Sammie','string'),(42,'pt_BR','givenName',0,0,'Tyson','string'),(43,'pt_BR','givenName',0,0,'Opal','string'),(44,'pt_BR','givenName',0,0,'Hudson','string'),(45,'pt_BR','givenName',0,0,'Deandre','string'),(46,'pt_BR','givenName',0,0,'Katrice','string'),(47,'pt_BR','givenName',0,0,'Sabina','string'),(48,'pt_BR','givenName',0,0,'Luna','string'),(49,'pt_BR','givenName',0,0,'Zita Ana Lago','string'),(50,'pt_BR','givenName',0,0,'Heide Siebert','string'),(1,'pt_BR','familyName',0,0,'','string'),(2,'pt_BR','familyName',0,0,'Krainski','string'),(3,'pt_BR','familyName',0,0,'Souza','string'),(4,'pt_BR','familyName',0,0,'Pizzaia','string'),(5,'pt_BR','familyName',0,0,'Enns','string'),(6,'pt_BR','familyName',0,0,'Santos','string'),(7,'pt_BR','familyName',0,0,'Boldt','string'),(8,'pt_BR','familyName',0,0,'Dampier','string'),(9,'pt_BR','familyName',0,0,'Baumgaertner','string'),(10,'pt_BR','familyName',0,0,'Harton','string'),(11,'pt_BR','familyName',0,0,'Zielinski','string'),(12,'pt_BR','familyName',0,0,'Ernest','string'),(13,'pt_BR','familyName',0,0,'Wilmer','string'),(14,'pt_BR','familyName',0,0,'Loos','string'),(15,'pt_BR','familyName',0,0,'Gruner','string'),(16,'pt_BR','familyName',0,0,'Dahlen','string'),(17,'pt_BR','familyName',0,0,'Northmore','string'),(18,'pt_BR','familyName',0,0,'Driver','string'),(19,'pt_BR','familyName',0,0,'Pannell','string'),(20,'pt_BR','familyName',0,0,'Glynn','string'),(21,'pt_BR','familyName',0,0,'Culpin','string'),(22,'pt_BR','familyName',0,0,'Girardi','string'),(23,'pt_BR','familyName',0,0,'Kruse','string'),(24,'pt_BR','familyName',0,0,'Gloeckner','string'),(25,'pt_BR','familyName',0,0,'Baehr','string'),(26,'pt_BR','familyName',0,0,'Knorr','string'),(27,'pt_BR','familyName',0,0,'Hepp','string'),(28,'pt_BR','familyName',0,0,'Dück','string'),(29,'pt_BR','familyName',0,0,'Gomes','string'),(30,'pt_BR','familyName',0,0,'Janzen','string'),(31,'pt_BR','familyName',0,0,'Miranda','string'),(32,'pt_BR','familyName',0,0,'Campos','string'),(33,'pt_BR','familyName',0,0,'Gruber','string'),(34,'pt_BR','familyName',0,0,'Dudgeon','string'),(35,'pt_BR','familyName',0,0,'Mauro','string'),(36,'pt_BR','familyName',0,0,'Hawthorne','string'),(37,'pt_BR','familyName',0,0,'Natel','string'),(38,'pt_BR','familyName',0,0,'Groce','string'),(39,'pt_BR','familyName',0,0,'Schmidt','string'),(40,'pt_BR','familyName',0,0,'Ewart','string'),(41,'pt_BR','familyName',0,0,'Noriega','string'),(42,'pt_BR','familyName',0,0,'Lalonde','string'),(43,'pt_BR','familyName',0,0,'Martinez','string'),(44,'pt_BR','familyName',0,0,'Lockhart','string'),(45,'pt_BR','familyName',0,0,'Langlois','string'),(46,'pt_BR','familyName',0,0,'Erickson','string'),(47,'pt_BR','familyName',0,0,'Toll','string'),(48,'pt_BR','familyName',0,0,'Estrada','string'),(49,'pt_BR','familyName',0,0,'Rodrigues','string'),(50,'pt_BR','familyName',0,0,'Koop','string'),(5,'pt_BR','preferredPublicName',0,0,'Sr Udo Enns','string'),(6,'pt_BR','preferredPublicName',0,0,'Paulo Paulo Sergio Santos','string'),(23,'pt_BR','preferredPublicName',0,0,'Economista Marcos Kruse','string'),(37,'pt_BR','preferredPublicName',0,0,'Angela Angela Natel','string'),(50,'pt_BR','preferredPublicName',0,0,'Heide Heide Siebert Koop','string'),(2,'pt_BR','biography',0,0,'<p>Doutoranda em Psicologia, linha de pesquisa Avaliação e Reabilitação Neuropsicológica (2022-atual). Mestra em Psicologia (2022) e formação em Psicologia pela Universidade Federal do Paraná (2017). Coordenadora e docente do Curso de Graduação em Psicologia da Faculdade Fidelis (2022-atual). Coordenadora do Programa de Acompanhamento Psicopedagógico da Escola de Talentos do Instituto Principia (2022-atual).</p>','string'),(2,'pt_BR','signature',0,0,'','string'),(2,'pt_BR','preferredPublicName',0,0,'','string'),(2,'','orcid',0,0,'https://orcid.org/0000-0003-2043-2815','string'),(4,'pt_BR','biography',0,0,'','string'),(4,'pt_BR','signature',0,0,'','string'),(4,'pt_BR','preferredPublicName',0,0,'','string'),(4,'','orcid',0,0,'','string'),(51,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(51,'pt_BR','givenName',0,0,'Thiciane','string'),(51,'pt_BR','familyName',0,0,'Pieczarka','string'),(52,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(52,'pt_BR','givenName',0,0,'Ingrid','string'),(52,'pt_BR','familyName',0,0,'Adam','string'),(53,'pt_BR','affiliation',0,0,'Fideliz','string'),(53,'pt_BR','givenName',0,0,'Jamile','string'),(53,'pt_BR','familyName',0,0,'Nascimento','string'),(53,'pt_BR','preferredPublicName',0,0,'','string'),(54,'pt_BR','biography',0,0,'','string'),(54,'pt_BR','signature',0,0,'','string'),(54,'pt_BR','affiliation',0,0,'','string'),(54,'pt_BR','givenName',0,0,'Teste','string'),(54,'pt_BR','familyName',0,0,'','string'),(54,'pt_BR','preferredPublicName',0,0,'','string'),(54,'','orcid',0,0,'','string'),(55,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(55,'pt_BR','givenName',0,0,'Edith','string'),(55,'pt_BR','familyName',0,0,'Siebert','string'),(56,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(56,'pt_BR','givenName',0,0,'daniela','string'),(56,'pt_BR','familyName',0,0,'pedroso','string'),(57,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(57,'pt_BR','givenName',0,0,'Clarice','string'),(57,'pt_BR','familyName',0,0,'Dauernheimer Born','string'),(58,'pt_BR','affiliation',0,0,'Faculdade Fidélis','string'),(58,'pt_BR','givenName',0,0,'Renata Maria de','string'),(58,'pt_BR','familyName',0,0,'Schimitz','string'),(59,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(59,'pt_BR','givenName',0,0,'CLAYTON','string'),(59,'pt_BR','familyName',0,0,'LIMA DE SOUZA','string'),(60,'pt_BR','affiliation',0,0,'Universidade Estadual do Centro Oeste','string'),(60,'pt_BR','givenName',0,0,'Larissa das Graças','string'),(60,'pt_BR','familyName',0,0,'Choida','string'),(61,'pt_BR','affiliation',0,0,'Universidade Estadual do Centro-Oeste','string'),(61,'pt_BR','givenName',0,0,'Júlia','string'),(61,'pt_BR','familyName',0,0,'Schultz Pusch','string'),(62,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(62,'pt_BR','givenName',0,0,'Mariluce Emerim de Melo','string'),(62,'pt_BR','familyName',0,0,'August','string'),(63,'pt_BR','affiliation',0,0,'Fidelis','string'),(63,'pt_BR','givenName',0,0,'kasprzak','string'),(63,'pt_BR','familyName',0,0,'Wellington, Marcelo','string'),(64,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(64,'pt_BR','givenName',0,0,'Bruno','string'),(64,'pt_BR','familyName',0,0,'Miara','string'),(64,'','orcid',0,0,'','string'),(55,'pt_BR','biography',0,0,'','string'),(55,'pt_BR','signature',0,0,'','string'),(55,'pt_BR','preferredPublicName',0,0,'','string'),(55,'','orcid',0,0,'','string'),(65,'pt_BR','affiliation',0,0,'Associação +1 Capelania Empresarial no Brasil','string'),(65,'pt_BR','givenName',0,0,'Edilaney','string'),(65,'pt_BR','familyName',0,0,'Duarte Gonçalves','string'),(65,'','orcid',0,0,'','string'),(66,'pt_BR','affiliation',0,0,'Associação +1 Capelania Empresarial no Brasil','string'),(66,'pt_BR','givenName',0,0,'JARED','string'),(66,'pt_BR','familyName',0,0,'SANTOS','string'),(66,'','orcid',0,0,'','string'),(66,'pt_BR','biography',0,0,'','string'),(66,'pt_BR','signature',0,0,'','string'),(66,'pt_BR','preferredPublicName',0,0,'','string'),(67,'pt_BR','affiliation',0,0,'UMESP','string'),(67,'pt_BR','givenName',0,0,'Samuel','string'),(67,'pt_BR','familyName',0,0,'Pereira Valério','string'),(67,'','orcid',0,0,'','string'),(67,'pt_BR','preferredPublicName',0,0,'','string'),(68,'pt_BR','affiliation',0,0,'Fidelis','string'),(68,'pt_BR','givenName',0,0,'claudio marcio','string'),(68,'pt_BR','familyName',0,0,'Lachman','string'),(68,'','orcid',0,0,'','string'),(68,'pt_BR','biography',0,0,'','string'),(68,'pt_BR','signature',0,0,'','string'),(68,'pt_BR','preferredPublicName',0,0,'','string'),(69,'pt_BR','affiliation',0,0,'INSTITUTO SEDES SAPIENTIAE','string'),(69,'pt_BR','givenName',0,0,'GESIMARY','string'),(69,'pt_BR','familyName',0,0,'DE SANTI AZEVEDO','string'),(69,'','orcid',0,0,'','string'),(69,'pt_BR','preferredPublicName',0,0,'Gesi','string'),(70,'pt_BR','affiliation',0,0,'Uniasselvi','string'),(70,'pt_BR','givenName',0,0,'Maribel Emerim de','string'),(70,'pt_BR','familyName',0,0,'Melo','string'),(70,'','orcid',0,0,'','string'),(71,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(71,'pt_BR','givenName',0,0,'Allan','string'),(71,'pt_BR','familyName',0,0,'Costa Araújo','string'),(71,'','orcid',0,0,'','string'),(72,'pt_BR','affiliation',0,0,'s','string'),(72,'pt_BR','givenName',0,0,'s','string'),(72,'pt_BR','familyName',0,0,'s','string'),(72,'','orcid',0,0,'','string'),(73,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(73,'pt_BR','givenName',0,0,'Michele','string'),(73,'pt_BR','familyName',0,0,'Sampaio da Silva','string'),(73,'','orcid',0,0,'','string'),(74,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(74,'pt_BR','givenName',0,0,'Kallyne Kelly','string'),(74,'pt_BR','familyName',0,0,'Araújo Silva','string'),(74,'','orcid',0,0,'','string'),(74,'pt_BR','preferredPublicName',0,0,'','string'),(75,'pt_BR','affiliation',0,0,'\"LU - Lucent University (TX / USA)\"','string'),(75,'pt_BR','biography',0,0,'<p>Doutorando em Filosofia pela Selinus University of Science and Literature (UNISELINOS – Londres / Inglaterra). Mestre em Filosofia pela Universidade Gama Filho (UGF - RJ). Mestre em Teologia pela Lucent University (LU – TX / USA). Pós-Graduado Lato Sensu em Ensino de Filosofia no Ensino Médio pela Universidade Federal de São Paulo (UNIFESP - SP). Pós-Graduado Lato Sensu em Filosofia pela Universidade Gama Filho (UGF - RJ). Pós-Graduado Lato Sensu em Ciências da Religião pela Universidade Cândido Mendes (UCAM - RJ). Bacharel em Teologia pelo Universidade Estácio de Sá (UNESA - RJ) e pela Faculdade Batista de Minas Gerais (FBMG/MG). Licenciado em Filosofia pelo Centro Universitário Claretiano de Batatais (CEUCLAR - SP). Professor de Filosofia na E. E. Profa. Maria Aparecida Félix Porto (SEDUC/SP), Pesquisador no Mariano Da Rosa Research Institute (MDRRI - TX / USA) e Professor-Pesquisador na ONG EPZ/SP - Espaço Politikón Zôon - Educação, Arte e Cultura (São Paulo/Brasil). Editor na PZP/SP - Politikón Zôon Publicações (São Paulo/Brasil), no Philosophy International Journal - PhIJ (ISSN: 2641-9130) - Medwin Publishers (Michigan/USA), e na Mariano Da Rosa Academic Editions (MDRAE - TX / USA).</p>','string'),(75,'pt_BR','givenName',0,0,'Luiz Carlos','string'),(75,'pt_BR','familyName',0,0,'Mariano Da Rosa','string'),(75,'','orcid',0,0,'','string'),(75,'pt_BR','signature',0,0,'','string'),(76,'pt_BR','affiliation',0,0,'FACULDADE FIDELIS','string'),(76,'pt_BR','givenName',0,0,'CRISTIANO','string'),(76,'pt_BR','familyName',0,0,'NICKEL JUNIOR','string'),(76,'','orcid',0,0,'','string'),(76,'pt_BR','biography',0,0,'','string'),(76,'pt_BR','signature',0,0,'','string'),(76,'pt_BR','preferredPublicName',0,0,'','string'),(77,'pt_BR','affiliation',0,0,'Escola de Design - UEMG','string'),(77,'pt_BR','givenName',0,0,'Thuany Thayna da','string'),(77,'pt_BR','familyName',0,0,'Gomes','string'),(77,'','orcid',0,0,'','string'),(78,'pt_BR','affiliation',0,0,'Escola Superior de Educação Almeida Garrett / Universidade Lusófona de Lisboa','string'),(78,'pt_BR','givenName',0,0,'Fernando','string'),(78,'pt_BR','familyName',0,0,'Oliveira Pereira','string'),(78,'','orcid',0,0,'','string'),(78,'pt_BR','preferredPublicName',0,0,'Fernando Oliveira Pereira','string'),(79,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(79,'pt_BR','givenName',0,0,'benedito','string'),(79,'pt_BR','familyName',0,0,'bueno','string'),(79,'','orcid',0,0,'','string'),(80,'pt_BR','affiliation',0,0,'FFAEL','string'),(80,'pt_BR','givenName',0,0,'KARINNE','string'),(80,'pt_BR','familyName',0,0,'AMARAL','string'),(80,'','orcid',0,0,'','string'),(98,'pt_BR','affiliation',0,0,'PUCPR','string'),(98,'pt_BR','givenName',0,0,'Ana Paula','string'),(98,'pt_BR','familyName',0,0,'Rossetin','string'),(98,'','orcid',0,0,'','string'),(99,'pt_BR','affiliation',0,0,'Universidad Tecnológica Intercontinental - UTIC','string'),(99,'pt_BR','givenName',0,0,'João Fernando','string'),(99,'pt_BR','familyName',0,0,'Costa Júnior','string'),(99,'','orcid',0,0,'','string'),(99,'pt_BR','signature',0,0,'<p>Professor Universitário e consultor em tecnologias educacionais e EAD. Doutorando em Ciências da Educação, Mestre em Ciências da Educação, Especialista em Informática em Educação, Gestão de EAD, Educação à Distância 4.0 e Docência no Ensino Superior e Técnico. Licenciado em Pedagogia e Bacharel em Administração. Editor-chefe da Revista Internacional de Estudos Científicos - RIEC e Revista Espírito Livre. Editor executivo do Fondo Editorial Universidad Politécnica Territorial de los Valles del Tuy. Vice-coordenador do Grupo de Pesquisa Educação Transversal CNPq/UFES. Integrante dos comitês científicos/editoriais da Revista Brasileira de Ensino e Aprendizagem - Rebena e também da Revista Convergências: estudos em Humanidades Digitais (CONEHD). Participante dos Grupos de Pesquisa CNPQ Texto Livre: Semiótica e Tecnologia (UFMG) e do Grupo de Pesquisa em Mídias, Tecnologias e História - MITECHIS (UFT).</p>','string'),(81,'pt_BR','affiliation',0,0,'Escola Superior de Guerra (ESG)','string'),(81,'pt_BR','givenName',0,0,'Niltongomes','string'),(81,'pt_BR','familyName',0,0,'','string'),(81,'','orcid',0,0,'','string'),(82,'pt_BR','affiliation',0,0,'SEDUC','string'),(82,'pt_BR','givenName',0,0,'LOURISMAR','string'),(82,'pt_BR','familyName',0,0,'BARROSO','string'),(82,'','orcid',0,0,'','string'),(82,'pt_BR','preferredPublicName',0,0,'Lourismar Barroso','string'),(83,'pt_BR','affiliation',0,0,'FANAP','string'),(83,'pt_BR','givenName',0,0,'Matheus Phelipe','string'),(83,'pt_BR','familyName',0,0,'Barros','string'),(83,'','orcid',0,0,'','string'),(84,'pt_BR','affiliation',0,0,'1','string'),(84,'pt_BR','givenName',0,0,'botRDVAY','string'),(84,'pt_BR','familyName',0,0,'botRDVAY','string'),(84,'','orcid',0,0,'1','string'),(1,'pt_BR','biography',0,0,'','string'),(1,'pt_BR','signature',0,0,'','string'),(1,'pt_BR','affiliation',0,0,'','string'),(1,'pt_BR','preferredPublicName',0,0,'','string'),(1,'','orcid',0,0,'','string'),(85,'pt_BR','affiliation',0,0,'','string'),(85,'pt_BR','givenName',0,0,'Paulo Marins','string'),(85,'pt_BR','familyName',0,0,'Gomes','string'),(86,'pt_BR','affiliation',0,0,'Igreja Presbiteriana Renovada','string'),(86,'pt_BR','givenName',0,0,'Bruno','string'),(86,'pt_BR','familyName',0,0,'Fernando Dal Médico Mendes','string'),(86,'','orcid',0,0,'','string'),(87,'pt_BR','affiliation',0,0,'Universidade Federal do Paraná','string'),(87,'pt_BR','givenName',0,0,'Paulo','string'),(87,'pt_BR','familyName',0,0,'Marins Gomes','string'),(87,'','orcid',0,0,'','string'),(88,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(88,'pt_BR','givenName',0,0,'Kalebe','string'),(88,'pt_BR','familyName',0,0,'dos Anjos Felix','string'),(88,'','orcid',0,0,'','string'),(89,'pt_BR','affiliation',0,0,'Unifacid wyden','string'),(89,'pt_BR','givenName',0,0,'Albilene','string'),(89,'pt_BR','familyName',0,0,'Dos Santos Silva','string'),(89,'','orcid',0,0,'','string'),(90,'pt_BR','affiliation',0,0,'ABPMP Brazil','string'),(90,'pt_BR','givenName',0,0,'Paulo Rogers','string'),(90,'pt_BR','familyName',0,0,'Helrighel','string'),(90,'','orcid',0,0,'','string'),(91,'pt_BR','affiliation',0,0,'Universidade de Passo Fundo','string'),(91,'pt_BR','givenName',0,0,'Bruna','string'),(91,'pt_BR','familyName',0,0,'Agador','string'),(91,'','orcid',0,0,'','string'),(91,'pt_BR','signature',0,0,'<p>Bruna Agador, estudante de psicologia da Universidade de Passo fundo.&nbsp;</p>\r\n<p>https://orcid.org/0009-0006-7186-2945</p>','string'),(92,'pt_BR','affiliation',0,0,'UNEMAT','string'),(92,'pt_BR','givenName',0,0,'Elisangela','string'),(92,'pt_BR','familyName',0,0,'Francisca da Silva','string'),(92,'','orcid',0,0,'','string'),(93,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(93,'pt_BR','givenName',0,0,'Bruno Henrique dos','string'),(93,'pt_BR','familyName',0,0,' Santos Pereira','string'),(94,'pt_BR','affiliation',0,0,'Faculdade Fidelis','string'),(94,'pt_BR','givenName',0,0,'Bruno','string'),(94,'pt_BR','familyName',0,0,'Henrique Dos Santos Pereira','string'),(94,'','orcid',0,0,'','string'),(95,'pt_BR','affiliation',0,0,'Instituto Federal do Pará','string'),(95,'pt_BR','givenName',0,0,'Ismael','string'),(95,'pt_BR','familyName',0,0,'FucKner','string'),(95,'','orcid',0,0,'','string'),(96,'pt_BR','affiliation',0,0,'Faculdade Fidélis','string'),(96,'pt_BR','givenName',0,0,'JONATAS','string'),(96,'pt_BR','familyName',0,0,'CABRAL','string'),(96,'','orcid',0,0,'','string'),(97,'pt_BR','affiliation',0,0,'Faculdade Teologia e Ciências Humanas (FATECH)','string'),(97,'pt_BR','givenName',0,0,'Mauro Gutenbergue','string'),(97,'pt_BR','familyName',0,0,'Branch','string'),(97,'','orcid',0,0,'','string'),(100,'pt_BR','affiliation',0,0,'Unilavras','string'),(100,'pt_BR','givenName',0,0,'Guilherme','string'),(100,'pt_BR','familyName',0,0,'Resende Matos','string'),(100,'','orcid',0,0,'','string'),(101,'pt_BR','affiliation',0,0,'Universidade Anhanguera','string'),(101,'pt_BR','givenName',0,0,'Weslei','string'),(101,'pt_BR','familyName',0,0,'Leandro Quaresma Alves','string'),(101,'','orcid',0,0,'','string'),(102,'pt_BR','affiliation',0,0,'adminojs','string'),(102,'pt_BR','givenName',0,0,'adminojs','string'),(102,'pt_BR','familyName',0,0,'adminojs','string'),(102,'','orcid',0,0,'','string'),(98,'pt_BR','biography',0,0,'','string'),(98,'pt_BR','signature',0,0,'','string'),(98,'pt_BR','preferredPublicName',0,0,'','string'),(103,'pt_BR','affiliation',0,0,'Universidade Federal Fluminense','string'),(103,'pt_BR','givenName',0,0,'Priscila','string'),(103,'pt_BR','familyName',0,0,'Vieira','string'),(103,'','orcid',0,0,'','string'),(104,'pt_BR','affiliation',0,0,'Universidade de São Paulo','string'),(104,'pt_BR','givenName',0,0,'Bianca','string'),(104,'pt_BR','familyName',0,0,'Viana','string'),(104,'','orcid',0,0,'','string'),(73,'pt_BR','biography',0,0,'','string'),(73,'pt_BR','signature',0,0,'','string'),(73,'pt_BR','preferredPublicName',0,0,'','string'),(105,'pt_BR','affiliation',0,0,'FMU','string'),(105,'pt_BR','givenName',0,0,'Anne Karine de','string'),(105,'pt_BR','familyName',0,0,'Brito Silva','string'),(105,'','orcid',0,0,'','string'),(105,'pt_BR','preferredPublicName',0,0,'','string'),(106,'pt_BR','affiliation',0,0,'Unicesumar','string'),(106,'pt_BR','givenName',0,0,'mauricio','string'),(106,'pt_BR','familyName',0,0,'cunha','string'),(106,'','orcid',0,0,'','string'),(107,'pt_BR','affiliation',0,0,'UFPR','string'),(107,'pt_BR','givenName',0,0,'Katiane','string'),(107,'pt_BR','familyName',0,0,'Janke Krainski','string'),(107,'','orcid',0,0,'','string'),(108,'pt_BR','affiliation',0,0,'Fidelis','string'),(108,'pt_BR','givenName',0,0,'Patrícia','string'),(108,'pt_BR','familyName',0,0,'Cardoso Campos Nogueira','string'),(108,'','orcid',0,0,'','string');

--
-- Table structure for table `user_user_groups`
--

CREATE TABLE `user_user_groups` (
  `user_group_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  UNIQUE KEY `user_user_groups_pkey` (`user_group_id`,`user_id`),
  KEY `user_user_groups_user_group_id` (`user_group_id`),
  KEY `user_user_groups_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_user_groups`
--

INSERT INTO `user_user_groups` VALUES (1,1),(2,1),(2,2),(2,54),(3,2),(4,2),(5,2),(5,3),(5,4),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(14,23),(14,37),(14,51),(14,52),(14,53),(14,56),(14,57),(14,58),(14,59),(14,62),(14,64),(14,65),(14,70),(14,71),(14,72),(14,73),(14,74),(14,75),(14,76),(14,78),(14,87),(14,90),(14,91),(14,96),(14,98),(14,101),(14,103),(15,2),(16,1),(16,2),(16,3),(16,28),(16,29),(16,30),(16,31),(16,51),(16,52),(16,56),(16,59),(16,62),(16,63),(16,66),(16,67),(16,69),(16,71),(16,73),(16,76),(16,80),(16,82),(16,84),(16,85),(16,86),(16,87),(16,88),(16,90),(16,93),(16,94),(16,95),(16,97),(16,98),(16,99),(16,102),(16,105),(16,107),(16,108),(17,2),(17,5),(17,6),(17,7),(17,8),(17,9),(17,10),(17,11),(17,12),(17,13),(17,14),(17,15),(17,16),(17,17),(17,18),(17,19),(17,20),(17,21),(17,22),(17,23),(17,24),(17,25),(17,26),(17,27),(17,32),(17,33),(17,34),(17,35),(17,36),(17,37),(17,38),(17,39),(17,40),(17,41),(17,42),(17,43),(17,44),(17,45),(17,46),(17,47),(17,48),(17,49),(17,53),(17,57),(17,58),(17,60),(17,61),(17,64),(17,65),(17,68),(17,70),(17,72),(17,74),(17,75),(17,76),(17,77),(17,78),(17,79),(17,81),(17,83),(17,87),(17,89),(17,91),(17,92),(17,95),(17,96),(17,100),(17,101),(17,103),(17,104),(17,106),(18,2);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `url` varchar(2047) DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `billing_address` varchar(255) DEFAULT NULL,
  `country` varchar(90) DEFAULT NULL,
  `locales` varchar(255) DEFAULT NULL,
  `date_last_email` datetime DEFAULT NULL,
  `date_registered` datetime NOT NULL,
  `date_validated` datetime DEFAULT NULL,
  `date_last_login` datetime NOT NULL,
  `must_change_password` tinyint DEFAULT NULL,
  `auth_id` bigint DEFAULT NULL,
  `auth_str` varchar(255) DEFAULT NULL,
  `disabled` tinyint NOT NULL DEFAULT '0',
  `disabled_reason` mediumtext,
  `inline_help` tinyint DEFAULT NULL,
  `gossip` mediumtext,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `users_username` (`username`),
  UNIQUE KEY `users_email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'lampiao','$2y$10$YIrC7U3q/Ae3XGLCcAocvOJJma3MlGzKDlfYV0KtTSTquI2ruKYn.','psicologia@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:43:35',NULL,'2024-08-21 15:28:13',0,NULL,NULL,0,NULL,0,NULL),(2,'hkoop','$2y$10$a0C6rM6cgc6LOMs212jH7O4FB60o1tJEeSuh3CimkfolfmlZFnmHW','cognito@fidelis.edu.br','http://lattes.cnpq.br/1571505328685019','','',NULL,'BR','',NULL,'2020-12-10 16:46:11',NULL,'2024-08-13 17:06:14',0,NULL,NULL,0,NULL,0,'<p>senha: hkoop-123</p>'),(3,'csouza','$2y$10$nkFvMoPDX4F1gc.mBs6s7.oM.XewUm.OYR14slSvzaYNlHT1J.SAS','teologia@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(4,'bpizzaia','$2y$10$q8hs0obKSQxf0AeqPsHiP.rc6VfdjhQy9/r5XmPn2/O21VIRJPiBe','bruna.pizzaia@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(5,'udo','$2y$10$pmIYm48RaH/6BjsSQUOFuerLC2vlsl28DruagBjBIhFbRMZMZ8v/G','udoenns@gmail.com','','41995978782','',NULL,'BR','pt_BR',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(6,'paulo_ro-2019','$2y$10$YPA4rGEp/l.mNfoMH18IP.3IWKOUM6F6z8nfjZRU0xPJLz4yxDdGC','coordpaul@gmail.com','','11 982672361','',NULL,'BR','pt_BR',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(7,'bruno','$2y$10$6bIDiFbnE2b5bQzg.ti.D.2r0DCe52.pQp9XowQp8ICh6xUC8Fac2','adbruno@hotmail.com','','','Rua Rio Volga,275 - Iguaçu - Fazenda Rio Grande',NULL,'BR','pt_BR',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(8,'arielledam','$2y$10$IRdgil/MOcfTefphK76fmO2nYXKaxsyO/mGM.LEC4Pn7EgZ8lRABm','arielledampier@gmail.com','http://costofcial.com','(08) 9050 6752','arielledampier@gmail.com',NULL,'HT','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(9,'roxana8396','$2y$10$ZWkeXFZ9ikipXr5BPxo4N.2ryZV5XiAhzYs95grtpya5EakgGrcjS','roxanabaumgaertner@inbox.com','http://jurnal.untan.ac.id/index.php/jcskommipa/article/view/6344/75676580345','78 617 22 94','roxanabaumgaertner@inbox.com',NULL,'TF','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(10,'theresahar','$2y$10$K9yAwlLBrHfu8us6I4In.uunbkylvem4BbHxVwwJTmYrwhGO.RBQy','theresa.harton@googlemail.com','http://op.niscair.res.in/index.php/IJCT/article/view/3821/465464961','077 0118 9943','theresa.harton@googlemail.com',NULL,'AE','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(11,'colleen50r','$2y$10$K6kRIb9N078XfpLTDCRX1ODDyhzV3TWier3tW.XfOZOVmpCDORL6m','colleenzielinski@aol.com','http://jurnal.untan.ac.id/index.php/justin/article/view/12326/75676580944','070 1300 9049','colleenzielinski@aol.com',NULL,'HR','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(12,'julienne93','$2y$10$Sgo2sk6UsdRIT9By717t0OYK4V65rR9b1.D3BaJ3gJHh1xpOFH5Wq','julienne.ernest@gawab.com','http://www.jocr.co.in/wp/wp-content/uploads/01.-225O-0685.5404.pdf','780-742-9328','julienne.ernest@gawab.com',NULL,'GL','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(13,'kristoferg','$2y$10$4ZUpzlfbAaBX49JAbCFMpOtlxOj01AGBJIoS9Ff1s5Vo8niIA2vXi','kristoferwilmer@inbox.com','http://costofcial.com','(07) 5338 8913','kristoferwilmer@inbox.com',NULL,'DE','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(14,'darciloos','$2y$10$8ZUn618EGD5Sch.1SaKS9.XWIEVYPTGWqhNMQ1Y1Fgv6vdpLLwUFa','darciloos@gmail.com','http://jurnal.untan.ac.id/index.php/jcskommipa/article/view/14120/75676580346','02682 63 27 57','darciloos@gmail.com',NULL,'UG','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(15,'bobbie2470','$2y$10$XlN8DTwnliZa2iJmCFUyS.eCy0REIEOqufFM.apZiIPpex1bmlKmC','bobbie_gruner@bigstring.com','http://jurnal.untan.ac.id/index.php/jcskommipa/article/view/9568/75676580330','04859 48 09 62','bobbie_gruner@bigstring.com',NULL,'EE','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(16,'alexandrad','$2y$10$DsIj2GgB4CkowEhcH0k1WOp/B2PO9Pj0iMNZtOZqYfNniV2zzir0i','alexandra_dahlen@freenet.de','http://revistamutatismutandis.com/index.php/mutatismutandis/article/view/4/6754603','256-848-5657','alexandra_dahlen@freenet.de',NULL,'HM','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(17,'erickanort','$2y$10$DLyFD7pw1209FwWHQHkHLeL/X5oXJlbJ9GiMoRkMnpR1yLxOsjdEm','ericka_northmore@hotmail.de','http://www.jocr.co.in/wp/wp-content/uploads/01.-225O-0685.5404.pdf','06-25376311','ericka_northmore@hotmail.de',NULL,'GH','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(18,'tanyadrive','$2y$10$MhXTvYQTF4ifD1hF0Bur5O3jNqSgoUZz4jeK86rgFliL0DVr2uooi','tanyadriver@gmx.de','http://educacionyciencia.org/index.php/educacionyciencia/article/view/267/456479','','tanyadriver@gmx.de',NULL,'BN','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(19,'sharipanne','$2y$10$HA7Sq2VY3hYeqPqnwjZHLueL35B2V05c.WKZPkypHGX9vJZvaoCfS','sharipannell@bigstring.com','http://op.niscair.res.in/index.php/IJCT/article/view/4869/465464963','(21) 6563-3219','sharipannell@bigstring.com',NULL,'PL','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(20,'indiraglyn','$2y$10$zH0P9QrZxRFgx9XoR6Hs0OfcA3ipU6/5EK9JUYpzZRgE3A.UmPeWa','indiraglynn@web.de','http://educacionyciencia.org/index.php/educacionyciencia/article/view/103/456482','0431 33 68 92','indiraglynn@web.de',NULL,'KH','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(21,'jacobculpi','$2y$10$TtDLS6pYYrB.Pze3xKfQauoKsEu2zaifEAfq8k9msptnMKyHSyZka','jacob.culpin@zoho.com','http://educacionyciencia.org/index.php/educacionyciencia/article/view/274/456483','(51) 3514-7438','jacob.culpin@zoho.com',NULL,'KR','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(22,'bettegirar','$2y$10$hal5VRvTainfaOSh4NXF.eWyhn1/VDBIJpyojT59hgrm7OxJCfTk.','bette_girardi@yahoo.com','http://revistamutatismutandis.com/index.php/mutatismutandis/article/view/6/6754601','031 284 51 78','bette_girardi@yahoo.com',NULL,'ET','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(23,'mkruse','$2y$10$7E8biezZJ2vn4ZPtqepoQe7yPIRVih2gbkvU8JY.T9yKHbe48.5Bu','mkruse@mkruse.com.br','http://orcid.org/0000-0002-9459-5644','+55 44 999100886','<p>Rua Estrada Acopiara, 25E</p><p>Maringá - PR</p><p><span class=\"desktop-title-subcontent\">87035-275</span></p>',NULL,'BR','pt_BR',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(24,'freddieglo','$2y$10$g1gYTlrHm7BTAv0yZ3cIeeVAcR4WQ.PpvAknV2MXF9NMyHWoiQrcq','freddiegloeckner@inbox.com','http://vjs.ac.vn/index.php/jcc/article/view/2379/103810382946','077 5035 7591','freddiegloeckner@inbox.com',NULL,'MG','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(25,'kristenapq','$2y$10$C5.nwhgfduIQrQHn3bn68O00hhWltybpDNAud7cb9EboVRb0TzPta','kristen.baehr@gmail.com','https://planet-risk.org/index.php/pr/article/view/96/429','421 9104','kristen.baehr@gmail.com',NULL,'KY','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(26,'elbertknor','$2y$10$YyTwqBG9ZeZNYf4p6APFw.hhbJ7/lts3CB29UKtivVHHiPyxv1Dt2','elbertknorr@freenet.de','http://ppct.caicyt.gov.ar/index.php/ics/article/view/236/45454575767607','483 71 229','elbertknorr@freenet.de',NULL,'CM','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(27,'maurinehep','$2y$10$BUI6dEYI8CO6sHWw6jZDReEa/ELgjRL24bWshacCa14GwgBdVTzi2','maurinehepp@yahoo.de','http://revistas.ucm.es/index.php/TEKN/article/view/48224/4564456549446','0311 2699520','maurinehepp@yahoo.de',NULL,'NO','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(28,'adck','$2y$10$MFDXL4T0CVjEzGKP3sOsZ.XCLeWGIMlq7Bu57PlebEhk2AZ4kLBhO','arthur.duck@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(29,'agomes','$2y$10$l9hLGfi1tHfhXbqRe12gFOW1YtnfacKxio1.DW9U4fJJ7FOZ8cEZ.','angela@fidelis.com.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(30,'hjanzen','$2y$10$zXhyErrSXfdcoGa7K9i1V..Q7GawzOJKevCj3m1jYq6VQiNT0yr3m','henrique@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(31,'mmiranda','$2y$10$1m2K88WpxAWsmVofxabw8e8k44pOLpL4QUvU6G8JiOzdGD1ATYyE.','marcelo@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(32,'doncampos','$2y$10$36rQrgggF2ZZ6PWuqfeSQuxJUtJ.ovFdaSJjLuo850pLVLXW4T.HG','don.campos@freenet.de','https://planet-risk.org/index.php/pr/article/view/96/429','06-85291292','don.campos@freenet.de',NULL,'ML','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(33,'penneygrub','$2y$10$FsD2oFRMLb4QxiPT9f3LUudMsHr1tlFlErVeBF4pV94/bYHSFwQU.','penneygruber@yahoo.com','http://revistas.ucm.es/index.php/TEKN/article/view/48223/4564456549462','462 93 775','penneygruber@yahoo.com',NULL,'SM','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(34,'kelley29p','$2y$10$sFO.l2XgVsVLxGLtkrikqu7OIoqe/mMjHctqWCe3HQN6Tqrs54VQu','kelleydudgeon@bigstring.com','https://planet-risk.org/index.php/pr/article/view/96/429','','kelleydudgeon@bigstring.com',NULL,'CX','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(35,'kirkmauro3','$2y$10$SR9HjM7ShjWU1tnKAAEtUeMld9J0uGPTelAritJt5njO8MfiNt2Fq','kirkmauro@googlemail.com','http://www.ajhpe.org.za/index.php/ajhpe/article/view/950/616232','945 63 455','kirkmauro@googlemail.com',NULL,'CH','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(36,'chauhawtho','$2y$10$N/q7I1PhYm7Oc.meWmdpn.7PeiGiu8ZxOvsVA61tGB7biZPnZUQc.','chau_hawthorne@gmail.com','http://jurnal.untan.ac.id/index.php/jcskommipa/article/view/6344/75676580345','077 0296 0185','chau_hawthorne@gmail.com',NULL,'SN','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(37,'angelanatel','$2y$10$vvCxNpWZRAy/r2QdEwDSI.BbeI7d3YaocBHkrfa4ALeYUdK5rJ.Te','eetown@gmail.com','https://independent.academia.edu/AngelaNatel','41998454376','<p>Caixa Postal 21030</p><p>Curitiba - PR</p><p>81720-981</p>',NULL,'BR','pt_BR',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(38,'vanitagroc','$2y$10$n1RA1WK4oQFaxQdPzCm8D.tk71yAKKl3HeCLvMzEdVXwqtPXPwD5u','vanitagroce@gawab.com','https://cubedroute01.worldsecuresystems.com/_blog/From_the_Blog/post/Ignoring_FaceBook_The_world_is_obsessed_see_for_yourself/?page=16','078 8340 8754','vanitagroce@gawab.com',NULL,'BR','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(39,'virgiliosc','$2y$10$HBfq6azIP4V0d2IR3/xLouY19PQ2CJDrYfz.H6TAM/UunOmeVtnuy','virgilioschmidt@aol.com','http://edwardgeorge.com.au/_blog/Featured_Articles/post/Social_Media_Recruitment_for_the_Little_Guy/?page=24','06-61644411','virgilioschmidt@aol.com',NULL,'VC','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(40,'ethanoar2','$2y$10$QJ92VR0ZHB.nTgbldu8AHupUZROVhV58kbeYjv.XNBFydrVKBPuwC','ethanewart@gmail.com','https://www.adisucipto.web.id/','0150-3725277','ethanewart@gmail.com',NULL,'TF','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(41,'sammienori','$2y$10$8APfA2bwjkXJowii8JLoB.jvSuC2nd1qJrSaN5AVzNBYZ9NZieVai','sammienoriega@aol.com','https://www.triaskitchen.web.id/','02630 81 03 10','sammienoriega@aol.com',NULL,'GY','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(42,'tysonlalon','$2y$10$Ha3AUPlxQNGet3Nyk4iae.1WQ6KeDHw6v2u81rru/FQWTe3Fuymam','tysonlalonde@gmx.net','http://arkitekturforskning.net/na/article/view/393/654933','05.78.73.45.03','tysonlalonde@gmx.net',NULL,'GF','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(43,'opalmartin','$2y$10$Y2WhgDBt4g8BJDqXN99aGerUYe2QSE2fzLORHpqIAj0B3m2QdmAT.','opal_martinez@gmx.de','http://www.annalesumng.org/index.php/ssa/article/view/27/182263','0372 3244355','opal_martinez@gmx.de',NULL,'AU','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(44,'hudsonlock','$2y$10$d0nEyUynIz4RFvyQkhZgEOlpuIKqw1alDdM.RJd4uD8Nv/u/2Vn9.','hudsonlockhart@yahoo.com','http://www.ajhpe.org.za/index.php/ajhpe/article/view/43/616237','090-6084902','hudsonlockhart@yahoo.com',NULL,'SI','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(45,'deandrelan','$2y$10$sw2lGLG4Eygls9sLL8sPbuxIjfKKpP9Lug5.hnc96cx5ynDYsMQX.','deandrelanglois@googlemail.com','https://www.adisucipto.web.id/','01.41.21.83.02','deandrelanglois@googlemail.com',NULL,'GF','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(46,'katriceeri','$2y$10$IW2tRkj5BVt64V5.KnYM7O.ANyyHm.XU0zZzXXm2y8Q5WPHmFuMGS','katrice.erickson@live.com','https://www.triaskitchen.web.id/','905-650-1914','katrice.erickson@live.com',NULL,'SH','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(47,'sabina51k4','$2y$10$LMyxIHiA46SxMeHBJE.eDu6wp4y3rMLm6kY8E21kvKz3v3QSHwA1W','sabinatoll@aol.com','http://op.niscair.res.in/index.php/IJCT/article/view/2944/465464960','02.46.25.27.61','sabinatoll@aol.com',NULL,'GF','',NULL,'2020-12-10 16:46:11',NULL,'2020-12-10 16:46:11',0,NULL,NULL,0,NULL,0,NULL),(48,'agustinacasanova6218','$2y$10$QEH5CJS6LQ4ho8o5P5yP/.Dmw7QrbZN2Xz55i6YPVpsn4wUgfT7RC','pcvf.00+agustinacasanova6218@gmail.com','','','',NULL,'','',NULL,'2020-12-10 17:31:26',NULL,'2020-12-10 17:31:26',0,NULL,NULL,0,NULL,0,NULL),(49,'zrodrigues','$2y$10$oL24AvM3ShEsx3HjBsIGVOCUQ2YyjVhFarH/gu3txSWAOVhs0rNiS','pedagogia@fidelis.edu.br','','','',NULL,'','',NULL,'2020-12-10 17:31:26',NULL,'2020-12-10 17:31:26',0,NULL,NULL,0,NULL,0,NULL),(50,'editor','$2y$10$DZ6Ak9gdDtV9AYYIPHXM0eA6Uj9kkbB7Oi28pb57yfNzP82xRrMXy','vicedirecao@fidelis.edu.br','','41033764566','',NULL,'BR','pt_BR',NULL,'2020-12-10 17:31:26',NULL,'2020-12-10 17:31:26',0,NULL,NULL,0,NULL,0,NULL),(51,'thiciane','$2y$10$tKZoBUeJ.jRlUgxXNmcOQOjXnJiYLts7J1X46BRF.tGKuIanaHCpq','thiciane.pieczarka@fidelis.edu.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-01-28 16:59:37',NULL,'2022-07-12 19:03:05',0,NULL,NULL,0,NULL,1,NULL),(52,'ingrid_adam','$2y$10$JU9KUf9kcYgJHcyqa15WN.6lxs79Qdi28B1w5HuQmtxUKBApzfBRS','ingrid.adam@fidelis.edu.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-01-31 11:20:13',NULL,'2021-04-06 14:13:42',0,NULL,NULL,0,NULL,1,NULL),(53,'jamile','$2y$10$0JCmdvoXGrzhICEaoiZzHuS0UFppbqfMDwxwy/sax/tf0j9GY5dyO','jamile.nasci@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-02-05 15:19:37',NULL,'2021-03-15 22:46:36',0,NULL,NULL,0,NULL,1,NULL),(54,'teste01','$2y$10$eI4EaDFTkiK3TDsLuxMe/uyowmApF.TM8FqQ8v0q4X7vquzlXqMmq','woier@krutt.org','','','',NULL,'','',NULL,'2021-02-26 16:59:12',NULL,'2021-02-26 16:59:12',0,NULL,NULL,0,NULL,1,NULL),(55,'edith','$2y$10$Sx0WaWyPbDYF1avk6KKRKeCR910NPiZBlFfewiLoLXFgIlEkW8ise','heideskoop@gmail.com','','','',NULL,'BR','',NULL,'2021-03-01 10:20:03',NULL,'2021-03-12 09:35:14',1,NULL,NULL,0,NULL,1,''),(56,'danielapedroso','$2y$10$h.QF8WSL4.clI606e6do1Oj1ClMVM4jx/eyCQVxF6ad5pQqzZhbN2','daniela.pedroso@fidelis.edu.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-03-12 10:37:17',NULL,'2021-07-23 20:07:17',0,NULL,NULL,0,NULL,1,NULL),(57,'clariceborn','$2y$10$6FmSawB33otJHm8iVmGuKOanTGjmJcHgR7cDg9KS/4174WRV3wVa6','clariceborn@yahoo.com.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-03-22 20:28:52',NULL,'2021-04-26 20:53:22',0,NULL,NULL,0,NULL,1,NULL),(58,'reschimitz','$2y$10$XNZujIG.3Flp5YGUOMuE6OBh6tp9F3B1aOwmwuaMSUkDefJS52Ytm','re.schimitz@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-04-08 18:50:57',NULL,'2021-04-13 13:17:39',0,NULL,NULL,0,NULL,1,NULL),(59,'clayton72','$2y$10$yLj0GrhWGFBu0FbkFn5DDeUT.cJjQyP1V3Gl0pFWCteiHzvsnjlA.','claytondesouza@outlook.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-04-15 10:23:29',NULL,'2021-04-15 10:23:29',0,NULL,NULL,0,NULL,1,NULL),(60,'lari_choida','$2y$10$mU5y/dL61dOg66I6rYeIeufWr4wRjTzroMMMArGaWITIf70sC7uSy','larissadgchoida@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-05-26 12:02:19',NULL,'2021-05-26 12:02:19',0,NULL,NULL,0,NULL,1,NULL),(61,'juliapusch','$2y$10$/n.MGBwbONIcM4CUBraZx.DuhPp7SBbbyzliQXzD8xIL94bPJgHGG','juliapusch@outlook.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-05-27 01:54:46',NULL,'2021-05-27 01:54:46',0,NULL,NULL,0,NULL,1,NULL),(62,'mariluce_august','$2y$10$KdqYSnrE6XVwLUygN9axle7TwNh33D002As4OQIc7a8qw5ZYTWm52','marilucearq@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-06-15 15:09:47',NULL,'2024-07-12 16:40:32',0,NULL,NULL,0,NULL,1,NULL),(63,'kasprzak','$2y$10$EW7xAkKMHQqbhjdNgZ2M5Ok3FADzbIRFC9yg9Raj2JC/BInfn.iz6','kasprzak@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-07-07 16:08:29',NULL,'2021-08-06 15:50:14',0,NULL,NULL,0,NULL,1,NULL),(64,'brunom','$2y$10$k7Vvsj2ynhPs8rhgJLT/fe5socI9BUfRBpZIZuo.oGEXSeXWjQDAK','brunomiara@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-07-09 16:14:54',NULL,'2021-07-09 17:19:54',0,NULL,NULL,0,NULL,1,NULL),(65,'edilaney','$2y$10$G954QrDefhOPbEPsxWAbg.bW1Oadul7KuaJ1NYsKiNMo7I1CbS6JW','edilaneydg@yahoo.com.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-07-15 21:13:39',NULL,'2021-07-15 21:13:39',0,NULL,NULL,0,NULL,1,NULL),(66,'jared','$2y$10$six.ajKOqrLGZi2M5AxtW.CVrw0Bz2WxRm.5BkcuRPNRMOxV2gf3S','dimi.treinamentos@gmail.com','','','',NULL,'BR','',NULL,'2021-07-19 14:18:08',NULL,'2021-07-25 15:32:05',0,NULL,NULL,0,NULL,1,''),(67,'samuelvalerio','$2y$10$2Efqu47FmJhLBjzap/v2xOPusmeElDwWjiSdYE1GpOc7t1cn8NyWy','samuelpvalerio@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-07-27 09:54:07',NULL,'2021-07-28 10:51:35',0,NULL,NULL,0,NULL,1,NULL),(68,'claudiolachman','$2y$10$Zbcs3NhtmQR0.5I65xLN9OzY7g7as6zTk4vuzjYD8d73Bd5vJnKsO','claudiolachman45@gmail.com','','','',NULL,'BR','',NULL,'2021-07-29 22:35:13',NULL,'2021-07-29 22:35:13',0,NULL,NULL,0,NULL,1,NULL),(69,'gesimary','$2y$10$T645aaFzE6E5COr5Vmc7z.jRhtMDfWnBYGAg5igpd.TI3nKkTquJS','gesimarydesanti@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-08-05 14:12:59',NULL,'2021-08-12 18:41:35',0,NULL,NULL,0,NULL,1,NULL),(70,'maribel-melo','$2y$10$8EON82szzylR7S7vguQiYeyD4chaVydzeZHmjqMsVIyXNqMcA5KkO','maribel-melo@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2021-08-16 17:28:37',NULL,'2021-08-23 14:41:18',0,NULL,NULL,0,NULL,1,NULL),(71,'allan','$2y$10$HnwN7kmvi1/bKDPBhpeb2uGQsK43bCIswfPFsCjv7Kd3Zf0NPFTZG','allan-guitar@live.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2022-01-07 21:38:39',NULL,'2022-01-07 21:38:39',0,NULL,NULL,0,NULL,1,NULL),(72,'shblaka','$2y$10$Gixz9L13xwRhmYP7neGXwus/M9CJqVyMHsGoWHl3l2ccxnCypjQCe','vcbcmwleq@midiharmonica.com',NULL,NULL,NULL,NULL,'AL','',NULL,'2022-02-21 08:18:21',NULL,'2022-02-21 08:18:22',0,NULL,NULL,0,NULL,1,NULL),(73,'michelesampaio83','$2y$10$C8D6qwU.jdV3Qwe.YmTcR.NQbS5Ej87ebafirnuTfjMApZc9kQlem','michele.sampaio@gmail.com','','','',NULL,'BR','',NULL,'2022-03-14 07:25:48',NULL,'2024-05-30 18:49:25',0,NULL,NULL,0,NULL,1,''),(74,'kallyne_araujoh','$2y$10$lE9lkwMfY8TQM8sNFYiWP.Kfvi4D24dtYLcAroP0N4CbOGNlQyARG','kallyne93@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2022-03-15 17:12:29',NULL,'2022-03-15 17:12:29',0,NULL,NULL,0,NULL,1,NULL),(75,'marianodarosa','$2y$10$g8HTec6C2ESC/CcaK0eSOuVg1TktDf0hHdDdKvbgAJm8s7lHFYatG','marianodarosaletras@gmail.com','http://lattes.cnpq.br/0084141477309738','+1 806-808-4040','<p>1009 Jupiter Rd, Plano, TX 75074, Estados Unidos</p>',NULL,'US','',NULL,'2022-03-23 13:18:42',NULL,'2022-12-23 21:26:28',0,NULL,NULL,0,NULL,1,NULL),(76,'nickelcnj','$2y$10$kx4gWeKnVAIHMSKyyaJS2.UAkSjRmTV9xn84FNJcX8XGjVNvfisdS','cristiano.nickel@fidelis.edu.br','','','',NULL,'BR','',NULL,'2022-04-04 18:37:20',NULL,'2024-08-08 01:12:22',0,NULL,NULL,0,NULL,1,''),(77,'thuany-gomes','$2y$10$y1JFIADDMFvEmVex2CpKkuOvmwr4jp68YZeJDHJiLS6QOYArZcnpW','thuanyt@yahoo.com.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2022-04-12 13:38:13',NULL,'2022-04-12 13:38:13',0,NULL,NULL,0,NULL,1,NULL),(78,'fernandopereira','$2y$10$I21hhVFuwY1vzyMiDE/pKu.xJYojvOeZ25UELI4CMs4C4obOXGQF2','fopereira@sapo.pt',NULL,NULL,NULL,NULL,'PT','',NULL,'2022-04-22 20:16:35',NULL,'2023-07-31 18:46:07',0,NULL,NULL,0,NULL,1,NULL),(79,'benedito','$2y$10$iU5KOhcdK8lOsRsZqPKMC.ny8r7jLzxMnUNIAwjaRyegz0RRCzjzG','gesualdosgt@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2022-09-09 09:11:36',NULL,'2022-09-13 09:25:24',0,NULL,NULL,0,NULL,1,NULL),(80,'karinne','$2y$10$ZzJfvOBJJShTV.kQSBXo4OTPhTSNj6Ny07wvTxl/brANWyPKahxSi','karinneamaral@outlook.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2022-09-22 20:18:35',NULL,'2022-09-22 20:19:28',0,NULL,NULL,0,NULL,1,NULL),(81,'nilton6','$2y$10$d9alITcPoc8w1ghBMUMNwenxwMFGT6JUjEmYM2Vb2KIjUyMkX81c6','niltonlsgomes@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-04-24 20:27:33',NULL,'2023-04-24 20:27:33',0,NULL,NULL,0,NULL,1,NULL),(82,'barroso-123','$2y$10$6wEdUo5jL20NzQl8teevKukhqFK3rqxI0ppwyYMjvD1//Y9r8AbRO','barrosolourismar@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-07-17 10:53:55',NULL,'2023-07-17 10:53:55',0,NULL,NULL,0,NULL,1,NULL),(83,'matheus_180520','$2y$10$L5Id2dqy9/hjrogOBpY7oeRSE0VIRMnD0JqrepQMFsWxO37PNIJ0u','matheusphbarros2711@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-09-05 13:03:46',NULL,'2023-09-05 13:04:05',0,NULL,NULL,0,NULL,1,NULL),(84,'register','$2y$10$F112QR33oa9H8bPhyz..7eEsZGQnKVg1OB3.VqucZPPlSJXU9.A72','testing@example.com',NULL,NULL,NULL,NULL,'AL','',NULL,'2023-10-06 02:53:34',NULL,'2023-10-06 02:53:34',0,NULL,NULL,0,NULL,1,NULL),(85,'paulogomes','$2y$10$DKG8A5B.F.FC1Y/s1TsoeO4Fa4i6zd05bmtFqGC4A5UbTbIgUaqDK','paulomarinsgomes@gmail.com',NULL,NULL,NULL,NULL,NULL,'',NULL,'2023-10-20 19:27:39',NULL,'2023-10-20 19:27:39',1,NULL,NULL,0,NULL,1,NULL),(86,'bruno_10011985','$2y$10$p8O9kxEkCOJU0bAKLQ5kyuJKIEYQWMS2a0j0kJ5LJ1rm0VwVodKBy','brunodalmedico@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-10-22 10:50:31',NULL,'2023-10-22 10:50:31',0,NULL,NULL,0,NULL,1,NULL),(87,'paulomarinsgomes','$2y$10$98QSrj7kt7RrkqhzyG3Vv.KlhNeKaIi4xmtWdmUQ3n/FvQb54bfgG','cadastrodopaulo@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-10-23 09:46:39',NULL,'2023-11-16 20:57:40',0,NULL,NULL,0,NULL,1,NULL),(88,'kalebe07','$2y$10$zUpZHv6E5GHr5DvM52T2gefntNaiArnMPRJleFMaeaaXHURM2z3QS','kalebe07@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-11-01 11:38:18',NULL,'2023-11-01 15:07:58',0,NULL,NULL,0,NULL,1,NULL),(89,'al_bi-05','$2y$10$dPbC7ymdZNDOM4sF.bK7I.SfQz4W6RUekpuR4i/kGDUCEakovCOzK','albilenesjp55@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-11-17 19:13:28',NULL,'2023-11-17 19:13:28',0,NULL,NULL,0,NULL,1,NULL),(90,'rog3rs','$2y$10$QLBu4MfTszzc5YOjcB8u8OZhLtywxu/3tuY20WLHs/fREqnNserWi','rogers.abpmp.org.br@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-11-26 11:51:06',NULL,'2023-11-26 16:10:22',0,NULL,NULL,0,NULL,1,NULL),(91,'bruna_agador-05','$2y$10$t4nRThzRU7EPNikg3uJaFewlgKlR1bf7TcGqEtg3zGa6F6ttk4lPa','brunaagador@hotmail.com',NULL,'','',NULL,'BR','',NULL,'2023-12-05 14:55:36',NULL,'2023-12-05 14:55:40',0,NULL,NULL,0,NULL,1,NULL),(92,'elisangela','$2y$10$PKitp4yWdbpMWLCBplathONwFRI6HmTOue7SZwiCPSVDoF1SY/J0e','elisangela.francisca@unemat.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2023-12-15 11:36:03',NULL,'2023-12-15 11:36:03',0,NULL,NULL,0,NULL,1,NULL),(93,'bsantospereira','$2y$10$9dcHvqpmu28nA0tIaZy8Y.RBLdezspiOOEl4hGi8Ado2JtiwfW/nC','bruno.pereira@fidelis.edu.br',NULL,NULL,NULL,NULL,NULL,'',NULL,'2023-12-22 08:02:25',NULL,'2023-12-22 08:02:25',1,NULL,NULL,0,NULL,1,NULL),(94,'sha27kir','$2y$10$8deXm65ojEyTe4ItCukASOlp5wqDjvYxlwYmJVvsOolN7XmKNxA/i','psi.brunosantos@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-01-08 22:15:20',NULL,'2024-01-30 22:04:24',0,NULL,NULL,0,NULL,1,NULL),(95,'ifuckner','$2y$10$ky6cVW3uwbUYzj6Zuqitv.6.DoQaalUBsSfUjfVX8eLkx2SzTh7Gm','ismaelfucner@yahoo.com.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-01-11 21:33:53',NULL,'2024-01-11 21:33:53',0,NULL,NULL,0,NULL,1,NULL),(96,'jotacabral1980','$2y$10$6VLzVE7gFGZn2gMkaAgpMe3DikngFC7jY3Lbv7.hbkSNiZDGaTRgq','jonatas.s.cabral@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-01-20 09:15:30',NULL,'2024-01-20 09:15:31',0,NULL,NULL,0,NULL,1,NULL),(97,'mauro72','$2y$10$Iq8Yz69is6kSjrwRTPRpteCLso/7Mb7H9uIO8mF5gErcPiNlSMpzm','maurobranch@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-01-26 22:33:05',NULL,'2024-01-26 22:33:06',0,NULL,NULL,0,NULL,1,NULL),(98,'anarossetin','$2y$10$mZQ48n3Myoe3H2LRXTtVh.4TSXb/kZIDuHQ5Z5gGSQKwIVFTAtfjC','anapdrossetin@hotmail.com','','','',NULL,'BR','',NULL,'2024-02-26 20:15:50',NULL,'2024-05-16 13:42:39',0,NULL,NULL,0,NULL,1,''),(99,'joaofernandocosta','$2y$10$QaxEaZUoP77wrIV4jK3or.pagQkOZ0BTWedGzMAw63vpWDVC4iPUC','joaofernando@espiritolivre.org',NULL,'+5531982279126','',NULL,'BR','',NULL,'2024-03-04 11:28:48',NULL,'2024-03-04 11:28:49',0,NULL,NULL,0,NULL,1,NULL),(100,'guilherme24','$2y$10$9cX0XWxml2ds9.4ziWdrNuQYsCN8rSy7KRHvNf.mi11eTgIhq4vli','guilhermewrtt@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-03-10 05:11:00',NULL,'2024-03-10 05:11:01',0,NULL,NULL,0,NULL,1,NULL),(101,'wes123','$2y$10$RD69BjkeUODjfYjoHXSIQOlWKIrWkFzZRVYbAmNdwVVfHU0XwPjSK','weslei_leandro@hotmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-03-17 16:11:11',NULL,'2024-08-11 08:33:35',0,NULL,NULL,0,NULL,1,NULL),(102,'adminojs','$2y$10$V7zS4ocsZrvfWVmodlVH/er.eziBg09dGkVxBZMdzTBQrxRZSDe1S','gov@gov.gov',NULL,NULL,NULL,NULL,'ES','',NULL,'2024-04-03 13:33:34',NULL,'2024-04-03 13:33:34',0,NULL,NULL,0,NULL,1,NULL),(103,'priscila','$2y$10$Lgzt5ANP7QjChQihxonkLO1WpBT7Xbmhrmj1qNfx9pLqS1kpIC2N2','priscilavieirasilva@id.uff.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-05-16 18:15:31',NULL,'2024-05-16 18:15:31',0,NULL,NULL,0,NULL,1,NULL),(104,'bianca_ocv','$2y$10$Qu2k9NMn9BDKF7JiTdKP1.BSUE1Nq6BUR5WLtj/TM3snD2cAACnMW','bianca.ocv@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-05-23 17:11:51',NULL,'2024-05-23 17:11:52',0,NULL,NULL,0,NULL,1,NULL),(105,'k_95','$2y$10$9eGmwlFf3OF4NL/GXCRkqe1vedfCWAlCxsIybMfJdmKvVf43ZpZIO','karinekawy2010@hotmail.com.br',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-05-31 12:11:44',NULL,'2024-05-31 12:11:44',0,NULL,NULL,0,NULL,1,NULL),(106,'mauricio','$2y$10$XDe3wrLF3jODaI4HRvU0TuBCQMTec1OIYcuHKYvWTLKLV3G4ua7Da','cunha33d@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-06-22 14:01:23',NULL,'2024-06-22 14:01:23',0,NULL,NULL,0,NULL,1,NULL),(107,'katianejanke','$2y$10$ChZ5pzFBCd58t9KwGgdo/OANh2M.5e8YcKKfJpoVwXuVynplM8oCC','katiane.janke@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-07-09 18:02:02',NULL,'2024-07-09 18:02:02',0,NULL,NULL,0,NULL,1,NULL),(108,'patricianogueira','$2y$10$0OBujvV/ysQtoYUUlDk0deEy0Q.bf4g.1O9bYjq9e8IDyOmPnEO7W','pattycamposnogueira@gmail.com',NULL,NULL,NULL,NULL,'BR','',NULL,'2024-08-13 19:35:26',NULL,'2024-08-13 19:35:26',0,NULL,NULL,0,NULL,1,NULL);

--
-- Table structure for table `versions`
--

CREATE TABLE `versions` (
  `major` int NOT NULL DEFAULT '0',
  `minor` int NOT NULL DEFAULT '0',
  `revision` int NOT NULL DEFAULT '0',
  `build` int NOT NULL DEFAULT '0',
  `date_installed` datetime NOT NULL,
  `current` tinyint NOT NULL DEFAULT '0',
  `product_type` varchar(30) DEFAULT NULL,
  `product` varchar(30) DEFAULT NULL,
  `product_class_name` varchar(80) DEFAULT NULL,
  `lazy_load` tinyint NOT NULL DEFAULT '0',
  `sitewide` tinyint NOT NULL DEFAULT '0',
  UNIQUE KEY `versions_pkey` (`product_type`,`product`,`major`,`minor`,`revision`,`build`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `versions`
--

INSERT INTO `versions` VALUES (1,0,0,0,'2020-12-10 16:43:35',1,'plugins.metadata','nlm30','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.metadata','openurl10','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.metadata','mods34','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.metadata','dc11','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.auth','ldap','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','user','UserBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',0,'plugins.blocks','subscription','SubscriptionBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','keywordCloud','KeywordCloudBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','notification','NotificationBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','readingTools','ReadingToolsBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','information','InformationBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','navigation','NavigationBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','relatedItems','RelatedItemsBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','role','RoleBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','authorBios','AuthorBiosBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','help','HelpBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','donation','DonationBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','developedBy','DevelopedByBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','languageToggle','LanguageToggleBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.blocks','fontSize','FontSizeBlockPlugin',1,0),(1,0,1,0,'2020-12-10 14:52:28',1,'plugins.blocks','browse','BrowseBlockPlugin',1,0),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.generic','recommendByAuthor','RecommendByAuthorPlugin',1,1),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.generic','dublinCoreMeta','DublinCoreMetaPlugin',1,0),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.generic','htmlArticleGalley','HtmlArticleGalleyPlugin',1,0),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.blocks','makeSubmission','MakeSubmissionBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationLookup','crossref','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationLookup','isbndb','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationLookup','pubmed','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationLookup','worldcat','',0,0),(1,1,0,0,'2020-12-10 14:52:28',1,'plugins.blocks','subscription','SubscriptionBlockPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationParser','parscit','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationParser','freecite','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationParser','regex','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.citationParser','paracite','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.gateways','resolver','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.gateways','metsGateway','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','thesis','ThesisPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','thesisFeed','ThesisFeedPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','usageStats','UsageStatsPlugin',0,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','backup','BackupPlugin',1,0),(1,1,1,0,'2020-12-10 16:43:35',1,'plugins.generic','dataverse','DataversePlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','sehl','SehlPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','referral','ReferralPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','browse','BrowsePlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','piwik','PiwikPlugin',1,0),(1,2,0,0,'2020-12-10 16:43:35',1,'plugins.generic','staticPages','StaticPagesPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','googleAnalytics','GoogleAnalyticsPlugin',1,0),(1,1,0,0,'2020-12-10 16:43:35',1,'plugins.generic','openAIRE','OpenAIREPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','driver','DRIVERPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','xmlGalley','XmlGalleyPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','sword','SwordPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','tinymce','TinyMCEPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',0,'plugins.generic','pdfJsViewer','PdfJsViewerPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','stopForumSpam','StopForumSpamPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','objectsForReview','ObjectsForReviewPlugin',1,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','googleViewer','GoogleViewerPlugin',1,0),(1,2,0,0,'2020-12-10 16:43:35',1,'plugins.generic','pln','PLNPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','usageEvent','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','roundedCorners','RoundedCornersPlugin',1,0),(1,1,0,0,'2020-12-10 16:43:35',0,'plugins.generic','customBlockManager','CustomBlockManagerPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','externalFeed','ExternalFeedPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','booksForReview','BooksForReviewPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','translator','TranslatorPlugin',1,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','webFeed','WebFeedPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','customLocale','CustomLocalePlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','lucene','LucenePlugin',1,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','announcementFeed','AnnouncementFeedPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','phpMyVisites','PhpMyVisitesPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.generic','coins','CoinsPlugin',1,0),(1,1,0,0,'2020-12-10 16:43:35',0,'plugins.generic','acron','AcronPlugin',1,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.implicitAuth','shibboleth','',0,1),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','native','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','users','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','erudit','',0,0),(1,0,0,0,'2020-12-10 16:43:35',0,'plugins.importexport','doaj','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','duracloud','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','pubIds','',0,0),(1,0,0,0,'2020-12-10 16:43:35',0,'plugins.importexport','datacite','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','quickSubmit','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','mets','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.importexport','pubmed','',0,0),(1,0,0,0,'2020-12-10 16:43:35',0,'plugins.importexport','medra','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.oaiMetadataFormats','dc','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.oaiMetadataFormats','rfc1807','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.oaiMetadataFormats','nlm','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.oaiMetadataFormats','marc','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.oaiMetadataFormats','marcxml','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.paymethod','paypal','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.paymethod','manual','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.pubIds','urn','URNPubIdPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.pubIds','doi','DOIPubIdPlugin',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.reports','reviews','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.reports','articles','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.reports','views','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.reports','subscriptions','',0,0),(1,1,0,0,'2020-12-10 16:43:35',1,'plugins.reports','counterReport','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.reports','timedViewReport','',0,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','uncommon','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','night','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','redbar','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','classicNavy','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','classicBrown','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','custom','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','steel','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','blueSteel','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','classicBlue','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','classicGreen','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','vanilla','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','lilac','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','classicRed','',1,0),(1,0,0,0,'2020-12-10 16:43:35',1,'plugins.themes','desert','',1,0),(2,4,8,3,'2020-12-10 16:43:26',0,'core','ojs2','',0,1),(1,0,1,0,'2020-12-10 14:52:28',1,'plugins.generic','pdfJsViewer','PdfJsViewerPlugin',1,0),(1,2,0,0,'2020-12-10 14:52:28',1,'plugins.generic','customBlockManager','CustomBlockManagerPlugin',1,0),(1,1,2,4,'2020-12-10 14:52:28',1,'plugins.generic','orcidProfile','OrcidProfilePlugin',1,0),(1,1,0,0,'2020-12-10 14:52:28',1,'plugins.generic','googleScholar','GoogleScholarPlugin',1,0),(1,2,0,0,'2020-12-10 14:52:28',1,'plugins.generic','acron','AcronPlugin',1,1),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.generic','recommendBySimilarity','RecommendBySimilarityPlugin',1,1),(0,1,0,0,'2020-12-10 14:52:28',1,'plugins.generic','citationStyleLanguage','CitationStyleLanguagePlugin',1,0),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.generic','lensGalley','LensGalleyPlugin',1,0),(2,1,0,0,'2020-12-10 14:52:28',1,'plugins.importexport','crossref','',0,0),(1,1,0,0,'2020-12-10 14:52:28',1,'plugins.importexport','doaj','',0,0),(2,0,0,0,'2020-12-10 14:52:28',1,'plugins.importexport','datacite','',0,0),(2,0,0,0,'2020-12-10 14:52:28',1,'plugins.importexport','medra','',0,0),(2,0,0,0,'2020-12-10 14:52:28',1,'plugins.reports','reviewReport','',0,0),(1,0,0,0,'2020-12-10 14:52:28',1,'plugins.themes','default','DefaultThemePlugin',1,0),(3,2,1,1,'2020-12-10 14:51:48',1,'core','ojs2','',0,1);


