· 5 years ago · Mar 23, 2020, 05:12 PM
1--
2-- Table structure for table `eplogintype`
3--
4
5DROP TABLE IF EXISTS `eplogintype`;
6/*!40101 SET @saved_cs_client = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `eplogintype` (
9 `CompanyID` int(11) NOT NULL DEFAULT '0',
10 `LoginTypeID` int(11) NOT NULL DEFAULT '2147483647',
11 `CompanyLoginTypeID` int(11) NOT NULL AUTO_INCREMENT,
12 `LoginTypeName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
13 `Entity` char(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
14 `Description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
15 `EmailAsLogin` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
16 `ResetPasswordOnLogin` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
17 `RequireLoginActivation` tinyint(1) NOT NULL COMMENT 'sy_boolean;',
18 `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
19 `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
20 `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
21 `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
22 `CreatedDateTime` datetime(6) NOT NULL,
23 `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
24 `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
25 `LastModifiedDateTime` datetime(6) NOT NULL,
26 PRIMARY KEY (`LoginTypeID`,`CompanyID`),
27 KEY `EPLoginType_AUTOINCR_Special` (`CompanyLoginTypeID`) COMMENT 'si_autoincr;'
28) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
29/*!40101 SET character_set_client = @saved_cs_client */;
30
31--
32-- Dumping data for table `eplogintype` (changing instances of 'EPLoginType' to 'eplogintype' fixes the proplem- but
33-- only for this part of the file)
34
35LOCK TABLES `eplogintype` WRITE;
36/*!40000 ALTER TABLE `eplogintype` DISABLE KEYS */;
37INSERT 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');
38/*!40000 ALTER TABLE `eplogintype` ENABLE KEYS */;
39UNLOCK TABLES;
40/*!50003 SET @saved_cs_client = @@character_set_client */ ;
41/*!50003 SET @saved_cs_results = @@character_set_results */ ;
42/*!50003 SET @saved_col_connection = @@collation_connection */ ;
43/*!50003 SET character_set_client = utf8mb4 */ ;
44/*!50003 SET character_set_results = utf8mb4 */ ;
45/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
46/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
47/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
48DELIMITER ;;
49/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trig_bi_EPLoginType` BEFORE INSERT ON `EPLoginType` FOR EACH ROW^M
50TriggerStart: BEGIN^M
51IF new.LoginTypeID = 0x7FFFFFff THEN SET new.LoginTypeID = ident_current('EPLoginType'); END IF;^M
52END */;;
53DELIMITER ;
54/*!50003 SET sql_mode = @saved_sql_mode */ ;
55/*!50003 SET character_set_client = @saved_cs_client */ ;
56/*!50003 SET character_set_results = @saved_cs_results */ ;
57/*!50003 SET collation_connection = @saved_col_connection */ ;
58
59--
60-- Table structure for table `eplogintypeallowsrole`
61--
62
63DROP TABLE IF EXISTS `eplogintypeallowsrole`;
64/*!40101 SET @saved_cs_client = @@character_set_client */;
65/*!40101 SET character_set_client = utf8 */;
66CREATE TABLE `eplogintypeallowsrole` (
67 `CompanyID` int(11) NOT NULL DEFAULT '0',
68 `LoginTypeID` int(11) NOT NULL,
69 `IsDefault` tinyint(1) DEFAULT NULL COMMENT 'sy_boolean;',
70 `Rolename` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
71 `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
72 `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
73 `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
74 `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
75 `CreatedDateTime` datetime(6) NOT NULL,
76 `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
77 `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
78 `LastModifiedDateTime` datetime(6) NOT NULL,
79 PRIMARY KEY (`LoginTypeID`,`Rolename`,`CompanyID`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `eplogintypeallowsrole`
85--
86
87LOCK TABLES `eplogintypeallowsrole` WRITE;
88/*!40000 ALTER TABLE `eplogintypeallowsrole` DISABLE KEYS */;
89INSERT 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');
90/*!40000 ALTER TABLE `eplogintypeallowsrole` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `epmanagedlogintype`
95--
96
97DROP TABLE IF EXISTS `epmanagedlogintype`;
98/*!40101 SET @saved_cs_client = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `epmanagedlogintype` (
101 `CompanyID` int(11) NOT NULL DEFAULT '0',
102 `LoginTypeID` int(11) NOT NULL,
103 `ParentLoginTypeID` int(11) NOT NULL,
104 `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
105 `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
106 `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
107 `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
108 `CreatedDateTime` datetime(6) NOT NULL,
109 `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
110 `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
111 `LastModifiedDateTime` datetime(6) NOT NULL,
112 PRIMARY KEY (`LoginTypeID`,`ParentLoginTypeID`,`CompanyID`)
113) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `epmanagedlogintype`
118--
119
120LOCK TABLES `epmanagedlogintype` WRITE;
121/*!40000 ALTER TABLE `epmanagedlogintype` DISABLE KEYS */;
122/*!40000 ALTER TABLE `epmanagedlogintype` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `epnotification`
127--
128
129DROP TABLE IF EXISTS `epnotification`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `epnotification` (
133 `CompanyID` int(11) NOT NULL DEFAULT '0',
134 `NotificationID` int(11) NOT NULL AUTO_INCREMENT,
135 `Type` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
136 `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
137 `Bcc` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sy_boolean;',
138 `Title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
139 `ContactID` int(11) DEFAULT NULL,
140 `EmployeeID` int(11) DEFAULT NULL,
141 `Format` char(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
142 `Disabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sy_boolean;',
143 `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
144 `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
145 `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
146 `CreatedDateTime` datetime(6) NOT NULL,
147 `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
148 `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
149 `LastModifiedDateTime` datetime(6) NOT NULL,
150 `RefNoteID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
151 PRIMARY KEY (`NotificationID`,`CompanyID`)
152) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `epnotification`
157--
158
159LOCK TABLES `epnotification` WRITE;
160/*!40000 ALTER TABLE `epnotification` DISABLE KEYS */;
161/*!40000 ALTER TABLE `epnotification` ENABLE KEYS */;
162UNLOCK TABLES;
163
164--
165-- Table structure for table `epotherattendee`
166--
167
168DROP TABLE IF EXISTS `epotherattendee`;
169/*!40101 SET @saved_cs_client = @@character_set_client */;
170/*!40101 SET character_set_client = utf8 */;
171CREATE TABLE `epotherattendee` (
172 `CompanyID` int(11) NOT NULL DEFAULT '0',
173 `CompanyMask` varbinary(32) NOT NULL DEFAULT 'ª' COMMENT 'df_MaskAA;',
174 `EventNoteID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
175 `AttendeeID` int(11) NOT NULL DEFAULT '2147483647',
176 `CompanyAttendeeID` int(11) NOT NULL AUTO_INCREMENT,
177 `tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
178 `CreatedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
179 `CreatedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
180 `CreatedDateTime` datetime(6) NOT NULL,
181 `LastModifiedByID` char(36) CHARACTER SET ascii NOT NULL COMMENT 'sy_guid;',
182 `LastModifiedByScreenID` char(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
183 `LastModifiedDateTime` datetime(6) NOT NULL,
184 `Email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
185 `Name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
186 `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
187 `Invitation` int(11) NOT NULL DEFAULT '0',
188 PRIMARY KEY (`EventNoteID`,`AttendeeID`,`CompanyID`),
189 KEY `EPOtherAttendee_AUTOINCR_Special` (`CompanyAttendeeID`) COMMENT 'si_autoincr;'
190) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
191/*!40101 SET character_set_client = @saved_cs_client */;
192
193--
194-- Dumping data for table `epotherattendee`(this line is where the error message in DBeaver says the error occurred)
195--
196
197LOCK TABLES `epotherattendee` WRITE;
198
199[more stuff here]