--
-- Table structure for table `eplogintype`
--

DROP TABLE IF EXISTS `eplogintype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eplogintype` (
  `CompanyID` int(11) NOT NULL DEFAULT '0',
  `LoginTypeID` int(11) NOT NULL DEFAULT '2147483647',
  `CompanyLoginTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `LoginTypeName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Entity` char(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `EmailAsLogin` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
  `ResetPasswordOnLogin` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
  `RequireLoginActivation` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
  `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
  `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `CreatedDateTime` datetime(6) NOT NULL,
  `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LastModifiedDateTime` datetime(6) NOT NULL,
  PRIMARY KEY (`LoginTypeID`,`CompanyID`),
  KEY `EPLoginType_AUTOINCR_Special` (`CompanyLoginTypeID`) COMMENT 'si_autoincr;'
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eplogintype` (changing instances of 'EPLoginType' to 'eplogintype' fixes the proplem- but
-- only for this part of the file)

LOCK TABLES `eplogintype` WRITE;
/*!40000 ALTER TABLE `eplogintype` DISABLE KEYS */;
INSERT INTO `eplogintype` VALUES (1,1,1,'Unrestricted External User','C','Unrestricted External User',1,1,0,_binary '¢','2019-03-14 20:57:13.959056','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2010-07-27 17:25:00.000000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-05-30 09:22:23.957000'),(2,1,5,'Unrestricted External User','C','Unrestricted External User',1,1,0,_binary 'ª','2019-03-14 20:55:14.406450','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2014-07-28 08:58:26.283000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-07-28 12:58:26.283000'),(2,7,7,'Sales Employee','E','Sales Employee',0,0,0,_binary 'ª','2019-03-14 20:55:14.406450','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.950000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:52.257000');
/*!40000 ALTER TABLE `eplogintype` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trig_bi_EPLoginType` BEFORE INSERT ON `EPLoginType` FOR EACH ROW^M
TriggerStart: BEGIN^M
IF new.LoginTypeID = 0x7FFFFFff THEN SET new.LoginTypeID = ident_current('EPLoginType'); END IF;^M
END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `eplogintypeallowsrole`
--

DROP TABLE IF EXISTS `eplogintypeallowsrole`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eplogintypeallowsrole` (
  `CompanyID` int(11) NOT NULL DEFAULT '0',
  `LoginTypeID` int(11) NOT NULL,
  `IsDefault` tinyint(1) DEFAULT NULL COMMENT 'sy_boolean;',
  `Rolename` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
  `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `CreatedDateTime` datetime(6) NOT NULL,
  `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LastModifiedDateTime` datetime(6) NOT NULL,
  PRIMARY KEY (`LoginTypeID`,`Rolename`,`CompanyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eplogintypeallowsrole`
--

LOCK TABLES `eplogintypeallowsrole` WRITE;
/*!40000 ALTER TABLE `eplogintypeallowsrole` DISABLE KEYS */;
INSERT INTO `eplogintypeallowsrole` VALUES (1,1,0,'Anonymous',_binary 'ª','2019-03-14 20:53:23.596302','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2010-07-27 17:25:00.000000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2010-07-27 17:25:00.000000'),(1,1,0,'Guest',_binary 'ª','2019-03-14 20:53:23.596302','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2010-07-27 17:25:00.000000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','00000000','2010-07-27 17:25:00.000000'),(1,1,0,'Portal User',_binary '¢','2019-03-14 20:57:13.974289','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-05-30 00:22:23.940000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-05-30 09:22:23.940000'),(2,1,1,'Portal User',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-07-28 08:58:26.180000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-07-28 12:58:26.180000'),(2,7,1,'BRANCH HQ',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.970000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.967000'),(2,7,0,'BRANCH VA',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.970000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.970000'),(2,7,1,'EMPLOYEE',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.960000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.960000'),(2,7,1,'Internal User',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.973000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.970000'),(2,7,1,'SALES',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.967000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.963000'),(2,7,0,'SALESMGR',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:36.970000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:36.967000'),(2,7,0,'Wiki Author',_binary 'ª','2019-03-14 20:55:14.441278','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 10:54:52.247000','b5344897-037e-4d58-b5c3-1bdfd0f47bf9','EP202500','2014-08-19 14:54:52.250000');
/*!40000 ALTER TABLE `eplogintypeallowsrole` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `epmanagedlogintype`
--

DROP TABLE IF EXISTS `epmanagedlogintype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `epmanagedlogintype` (
  `CompanyID` int(11) NOT NULL DEFAULT '0',
  `LoginTypeID` int(11) NOT NULL,
  `ParentLoginTypeID` int(11) NOT NULL,
  `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
  `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `CreatedDateTime` datetime(6) NOT NULL,
  `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LastModifiedDateTime` datetime(6) NOT NULL,
  PRIMARY KEY (`LoginTypeID`,`ParentLoginTypeID`,`CompanyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `epmanagedlogintype`
--

LOCK TABLES `epmanagedlogintype` WRITE;
/*!40000 ALTER TABLE `epmanagedlogintype` DISABLE KEYS */;
/*!40000 ALTER TABLE `epmanagedlogintype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `epnotification`
--

DROP TABLE IF EXISTS `epnotification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `epnotification` (
  `CompanyID` int(11) NOT NULL DEFAULT '0',
  `NotificationID` int(11) NOT NULL AUTO_INCREMENT,
  `Type` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `Bcc` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sy_boolean;',
  `Title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ContactID` int(11) DEFAULT NULL,
  `EmployeeID` int(11) DEFAULT NULL,
  `Format` char(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Disabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sy_boolean;',
  `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `CreatedDateTime` datetime(6) NOT NULL,
  `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LastModifiedDateTime` datetime(6) NOT NULL,
  `RefNoteID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  PRIMARY KEY (`NotificationID`,`CompanyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `epnotification`
--

LOCK TABLES `epnotification` WRITE;
/*!40000 ALTER TABLE `epnotification` DISABLE KEYS */;
/*!40000 ALTER TABLE `epnotification` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `epotherattendee`
--

DROP TABLE IF EXISTS `epotherattendee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `epotherattendee` (
  `CompanyID` int(11) NOT NULL DEFAULT '0',
  `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
  `EventNoteID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `AttendeeID` int(11) NOT NULL DEFAULT '2147483647',
  `CompanyAttendeeID` int(11) NOT NULL AUTO_INCREMENT,
  `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `CreatedDateTime` datetime(6) NOT NULL,
  `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
  `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LastModifiedDateTime` datetime(6) NOT NULL,
  `Email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Invitation` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`EventNoteID`,`AttendeeID`,`CompanyID`),
  KEY `EPOtherAttendee_AUTOINCR_Special` (`CompanyAttendeeID`) COMMENT 'si_autoincr;'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `epotherattendee`(this line is where the error message in DBeaver says the error occurred)
--

LOCK TABLES `epotherattendee` WRITE;

[more stuff here]