· 5 years ago · Oct 21, 2020, 03:16 AM
1-- MySQL dump 10.17 Distrib 10.3.24-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: sciocorp_Analytics
4-- ------------------------------------------------------
5-- Server version 10.3.24-MariaDB-cll-lve
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `owa_action_fact`
20--
21
22DROP TABLE IF EXISTS `owa_action_fact`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `owa_action_fact` (
26 `id` bigint(20) NOT NULL,
27 `visitor_id` bigint(20) DEFAULT NULL,
28 `session_id` bigint(20) DEFAULT NULL,
29 `site_id` varchar(255) DEFAULT NULL,
30 `referer_id` bigint(20) DEFAULT NULL,
31 `ua_id` bigint(20) DEFAULT NULL,
32 `host_id` bigint(20) DEFAULT NULL,
33 `os_id` bigint(20) DEFAULT NULL,
34 `location_id` bigint(20) DEFAULT NULL,
35 `referring_search_term_id` bigint(20) DEFAULT NULL,
36 `timestamp` int(11) DEFAULT NULL,
37 `yyyymmdd` int(11) DEFAULT NULL,
38 `year` int(11) DEFAULT NULL,
39 `month` int(11) DEFAULT NULL,
40 `day` tinyint(2) DEFAULT NULL,
41 `dayofweek` varchar(10) DEFAULT NULL,
42 `dayofyear` int(11) DEFAULT NULL,
43 `weekofyear` int(11) DEFAULT NULL,
44 `last_req` bigint(20) DEFAULT NULL,
45 `ip_address` varchar(255) DEFAULT NULL,
46 `is_new_visitor` tinyint(1) DEFAULT NULL,
47 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
48 `language` varchar(255) DEFAULT NULL,
49 `days_since_prior_session` int(11) DEFAULT NULL,
50 `days_since_first_session` int(11) DEFAULT NULL,
51 `num_prior_sessions` int(11) DEFAULT NULL,
52 `medium` varchar(255) DEFAULT NULL,
53 `source_id` bigint(20) DEFAULT NULL,
54 `ad_id` bigint(20) DEFAULT NULL,
55 `campaign_id` bigint(20) DEFAULT NULL,
56 `user_name` varchar(255) DEFAULT NULL,
57 `cv1_name` varchar(255) DEFAULT NULL,
58 `cv1_value` varchar(255) DEFAULT NULL,
59 `cv2_name` varchar(255) DEFAULT NULL,
60 `cv2_value` varchar(255) DEFAULT NULL,
61 `cv3_name` varchar(255) DEFAULT NULL,
62 `cv3_value` varchar(255) DEFAULT NULL,
63 `cv4_name` varchar(255) DEFAULT NULL,
64 `cv4_value` varchar(255) DEFAULT NULL,
65 `cv5_name` varchar(255) DEFAULT NULL,
66 `cv5_value` varchar(255) DEFAULT NULL,
67 `document_id` bigint(20) DEFAULT NULL,
68 `action_name` varchar(255) DEFAULT NULL,
69 `action_label` varchar(255) DEFAULT NULL,
70 `action_group` varchar(255) DEFAULT NULL,
71 `numeric_value` int(11) DEFAULT NULL,
72 PRIMARY KEY (`id`),
73 KEY `session_id` (`session_id`),
74 KEY `site_id` (`site_id`),
75 KEY `yyyymmdd` (`yyyymmdd`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Dumping data for table `owa_action_fact`
81--
82
83LOCK TABLES `owa_action_fact` WRITE;
84/*!40000 ALTER TABLE `owa_action_fact` DISABLE KEYS */;
85set autocommit=0;
86/*!40000 ALTER TABLE `owa_action_fact` ENABLE KEYS */;
87UNLOCK TABLES;
88commit;
89
90--
91-- Table structure for table `owa_ad_dim`
92--
93
94DROP TABLE IF EXISTS `owa_ad_dim`;
95/*!40101 SET @saved_cs_client = @@character_set_client */;
96/*!40101 SET character_set_client = utf8 */;
97CREATE TABLE `owa_ad_dim` (
98 `id` bigint(20) NOT NULL,
99 `name` varchar(255) DEFAULT NULL,
100 `type` varchar(255) DEFAULT NULL,
101 PRIMARY KEY (`id`)
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `owa_ad_dim`
107--
108
109LOCK TABLES `owa_ad_dim` WRITE;
110/*!40000 ALTER TABLE `owa_ad_dim` DISABLE KEYS */;
111set autocommit=0;
112/*!40000 ALTER TABLE `owa_ad_dim` ENABLE KEYS */;
113UNLOCK TABLES;
114commit;
115
116--
117-- Table structure for table `owa_campaign_dim`
118--
119
120DROP TABLE IF EXISTS `owa_campaign_dim`;
121/*!40101 SET @saved_cs_client = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `owa_campaign_dim` (
124 `id` bigint(20) NOT NULL,
125 `name` varchar(255) DEFAULT NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `owa_campaign_dim`
132--
133
134LOCK TABLES `owa_campaign_dim` WRITE;
135/*!40000 ALTER TABLE `owa_campaign_dim` DISABLE KEYS */;
136set autocommit=0;
137/*!40000 ALTER TABLE `owa_campaign_dim` ENABLE KEYS */;
138UNLOCK TABLES;
139commit;
140
141--
142-- Table structure for table `owa_click`
143--
144
145DROP TABLE IF EXISTS `owa_click`;
146/*!40101 SET @saved_cs_client = @@character_set_client */;
147/*!40101 SET character_set_client = utf8 */;
148CREATE TABLE `owa_click` (
149 `id` bigint(20) NOT NULL,
150 `visitor_id` bigint(20) DEFAULT NULL,
151 `session_id` bigint(20) DEFAULT NULL,
152 `site_id` varchar(255) DEFAULT NULL,
153 `referer_id` bigint(20) DEFAULT NULL,
154 `ua_id` bigint(20) DEFAULT NULL,
155 `host_id` bigint(20) DEFAULT NULL,
156 `os_id` bigint(20) DEFAULT NULL,
157 `location_id` bigint(20) DEFAULT NULL,
158 `referring_search_term_id` bigint(20) DEFAULT NULL,
159 `timestamp` int(11) DEFAULT NULL,
160 `yyyymmdd` int(11) DEFAULT NULL,
161 `year` int(11) DEFAULT NULL,
162 `month` int(11) DEFAULT NULL,
163 `day` tinyint(2) DEFAULT NULL,
164 `dayofweek` varchar(10) DEFAULT NULL,
165 `dayofyear` int(11) DEFAULT NULL,
166 `weekofyear` int(11) DEFAULT NULL,
167 `last_req` bigint(20) DEFAULT NULL,
168 `ip_address` varchar(255) DEFAULT NULL,
169 `is_new_visitor` tinyint(1) DEFAULT NULL,
170 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
171 `language` varchar(255) DEFAULT NULL,
172 `days_since_prior_session` int(11) DEFAULT NULL,
173 `days_since_first_session` int(11) DEFAULT NULL,
174 `num_prior_sessions` int(11) DEFAULT NULL,
175 `medium` varchar(255) DEFAULT NULL,
176 `source_id` bigint(20) DEFAULT NULL,
177 `ad_id` bigint(20) DEFAULT NULL,
178 `campaign_id` bigint(20) DEFAULT NULL,
179 `user_name` varchar(255) DEFAULT NULL,
180 `cv1_name` varchar(255) DEFAULT NULL,
181 `cv1_value` varchar(255) DEFAULT NULL,
182 `cv2_name` varchar(255) DEFAULT NULL,
183 `cv2_value` varchar(255) DEFAULT NULL,
184 `cv3_name` varchar(255) DEFAULT NULL,
185 `cv3_value` varchar(255) DEFAULT NULL,
186 `cv4_name` varchar(255) DEFAULT NULL,
187 `cv4_value` varchar(255) DEFAULT NULL,
188 `cv5_name` varchar(255) DEFAULT NULL,
189 `cv5_value` varchar(255) DEFAULT NULL,
190 `last_impression_id` bigint(20) DEFAULT NULL,
191 `document_id` bigint(20) DEFAULT NULL,
192 `target_id` bigint(20) DEFAULT NULL,
193 `target_url` varchar(255) DEFAULT NULL,
194 `hour` tinyint(2) DEFAULT NULL,
195 `minute` tinyint(2) DEFAULT NULL,
196 `second` int(11) DEFAULT NULL,
197 `msec` varchar(255) DEFAULT NULL,
198 `click_x` int(11) DEFAULT NULL,
199 `click_y` int(11) DEFAULT NULL,
200 `page_width` int(11) DEFAULT NULL,
201 `page_height` int(11) DEFAULT NULL,
202 `position` int(11) DEFAULT NULL,
203 `approx_position` bigint(20) DEFAULT NULL,
204 `dom_element_x` int(11) DEFAULT NULL,
205 `dom_element_y` int(11) DEFAULT NULL,
206 `dom_element_name` varchar(255) DEFAULT NULL,
207 `dom_element_id` varchar(255) DEFAULT NULL,
208 `dom_element_value` varchar(255) DEFAULT NULL,
209 `dom_element_tag` varchar(255) DEFAULT NULL,
210 `dom_element_text` varchar(255) DEFAULT NULL,
211 `dom_element_class` varchar(255) DEFAULT NULL,
212 `dom_element_parent_id` varchar(255) DEFAULT NULL,
213 `tag_id` bigint(20) DEFAULT NULL,
214 `placement_id` bigint(20) DEFAULT NULL,
215 `ad_group_id` bigint(20) DEFAULT NULL,
216 `host` varchar(255) DEFAULT NULL,
217 PRIMARY KEY (`id`),
218 KEY `session_id` (`session_id`),
219 KEY `site_id` (`site_id`),
220 KEY `yyyymmdd` (`yyyymmdd`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222/*!40101 SET character_set_client = @saved_cs_client */;
223
224--
225-- Dumping data for table `owa_click`
226--
227
228LOCK TABLES `owa_click` WRITE;
229/*!40000 ALTER TABLE `owa_click` DISABLE KEYS */;
230set autocommit=0;
231INSERT INTO `owa_click` VALUES (1548343758271432299,1548343740938411687,1548343740971991026,'9eff8d709599b08f97dc4fa264587877',118221093,1518164971,3606322599,3823601051,259604063,118221093,1548343758,20190124,2019,201901,24,'Thu',23,4,1548343740,'190.28.168.204',0,1,'es-41',0,0,0,'direct',118221093,0,0,'admin','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,822541238,1209084722,'https://sciocorp.org/ucceduco/ojs_20190119/index.php/index/login',10,29,18,'0.57170100',1288,24,1517,641,128824,0,1258,16,'(not set)','(not set)','(not set)','A','\n Entrar\n ','nav-link','',0,0,0,'epm.net.co'),(1548343760924507299,1548343752772892233,1548343752790319953,'9eff8d709599b08f97dc4fa264587877',118221093,343073837,1379425799,2085328441,259604063,118221093,1548343760,20190124,2019,201901,24,'Thu',23,4,0,'201.244.40.19',0,0,'en-US',0,0,0,'direct',118221093,0,0,'(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,255651834,0,'',10,29,20,'0.35234400',1140,11,1295,626,114011,0,71,0,'(not set)','(not set)','(not set)','DIV','','container','',0,0,0,'etb.net.co');
232/*!40000 ALTER TABLE `owa_click` ENABLE KEYS */;
233UNLOCK TABLES;
234commit;
235
236--
237-- Table structure for table `owa_commerce_line_item_fact`
238--
239
240DROP TABLE IF EXISTS `owa_commerce_line_item_fact`;
241/*!40101 SET @saved_cs_client = @@character_set_client */;
242/*!40101 SET character_set_client = utf8 */;
243CREATE TABLE `owa_commerce_line_item_fact` (
244 `id` bigint(20) NOT NULL,
245 `visitor_id` bigint(20) DEFAULT NULL,
246 `session_id` bigint(20) DEFAULT NULL,
247 `site_id` varchar(255) DEFAULT NULL,
248 `referer_id` bigint(20) DEFAULT NULL,
249 `ua_id` bigint(20) DEFAULT NULL,
250 `host_id` bigint(20) DEFAULT NULL,
251 `os_id` bigint(20) DEFAULT NULL,
252 `location_id` bigint(20) DEFAULT NULL,
253 `referring_search_term_id` bigint(20) DEFAULT NULL,
254 `timestamp` int(11) DEFAULT NULL,
255 `yyyymmdd` int(11) DEFAULT NULL,
256 `year` int(11) DEFAULT NULL,
257 `month` int(11) DEFAULT NULL,
258 `day` tinyint(2) DEFAULT NULL,
259 `dayofweek` varchar(10) DEFAULT NULL,
260 `dayofyear` int(11) DEFAULT NULL,
261 `weekofyear` int(11) DEFAULT NULL,
262 `last_req` bigint(20) DEFAULT NULL,
263 `ip_address` varchar(255) DEFAULT NULL,
264 `is_new_visitor` tinyint(1) DEFAULT NULL,
265 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
266 `language` varchar(255) DEFAULT NULL,
267 `days_since_prior_session` int(11) DEFAULT NULL,
268 `days_since_first_session` int(11) DEFAULT NULL,
269 `num_prior_sessions` int(11) DEFAULT NULL,
270 `medium` varchar(255) DEFAULT NULL,
271 `source_id` bigint(20) DEFAULT NULL,
272 `ad_id` bigint(20) DEFAULT NULL,
273 `campaign_id` bigint(20) DEFAULT NULL,
274 `user_name` varchar(255) DEFAULT NULL,
275 `cv1_name` varchar(255) DEFAULT NULL,
276 `cv1_value` varchar(255) DEFAULT NULL,
277 `cv2_name` varchar(255) DEFAULT NULL,
278 `cv2_value` varchar(255) DEFAULT NULL,
279 `cv3_name` varchar(255) DEFAULT NULL,
280 `cv3_value` varchar(255) DEFAULT NULL,
281 `cv4_name` varchar(255) DEFAULT NULL,
282 `cv4_value` varchar(255) DEFAULT NULL,
283 `cv5_name` varchar(255) DEFAULT NULL,
284 `cv5_value` varchar(255) DEFAULT NULL,
285 `document_id` bigint(20) DEFAULT NULL,
286 `order_id` varchar(255) DEFAULT NULL,
287 `sku` varchar(255) DEFAULT NULL,
288 `product_name` varchar(255) DEFAULT NULL,
289 `category` varchar(255) DEFAULT NULL,
290 `unit_price` bigint(20) DEFAULT NULL,
291 `quantity` int(11) DEFAULT NULL,
292 `item_revenue` bigint(20) DEFAULT NULL,
293 PRIMARY KEY (`id`),
294 KEY `session_id` (`session_id`),
295 KEY `site_id` (`site_id`),
296 KEY `yyyymmdd` (`yyyymmdd`),
297 KEY `order_id` (`order_id`)
298) ENGINE=InnoDB DEFAULT CHARSET=utf8;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `owa_commerce_line_item_fact`
303--
304
305LOCK TABLES `owa_commerce_line_item_fact` WRITE;
306/*!40000 ALTER TABLE `owa_commerce_line_item_fact` DISABLE KEYS */;
307set autocommit=0;
308/*!40000 ALTER TABLE `owa_commerce_line_item_fact` ENABLE KEYS */;
309UNLOCK TABLES;
310commit;
311
312--
313-- Table structure for table `owa_commerce_transaction_fact`
314--
315
316DROP TABLE IF EXISTS `owa_commerce_transaction_fact`;
317/*!40101 SET @saved_cs_client = @@character_set_client */;
318/*!40101 SET character_set_client = utf8 */;
319CREATE TABLE `owa_commerce_transaction_fact` (
320 `id` bigint(20) NOT NULL,
321 `visitor_id` bigint(20) DEFAULT NULL,
322 `session_id` bigint(20) DEFAULT NULL,
323 `site_id` varchar(255) DEFAULT NULL,
324 `referer_id` bigint(20) DEFAULT NULL,
325 `ua_id` bigint(20) DEFAULT NULL,
326 `host_id` bigint(20) DEFAULT NULL,
327 `os_id` bigint(20) DEFAULT NULL,
328 `location_id` bigint(20) DEFAULT NULL,
329 `referring_search_term_id` bigint(20) DEFAULT NULL,
330 `timestamp` int(11) DEFAULT NULL,
331 `yyyymmdd` int(11) DEFAULT NULL,
332 `year` int(11) DEFAULT NULL,
333 `month` int(11) DEFAULT NULL,
334 `day` tinyint(2) DEFAULT NULL,
335 `dayofweek` varchar(10) DEFAULT NULL,
336 `dayofyear` int(11) DEFAULT NULL,
337 `weekofyear` int(11) DEFAULT NULL,
338 `last_req` bigint(20) DEFAULT NULL,
339 `ip_address` varchar(255) DEFAULT NULL,
340 `is_new_visitor` tinyint(1) DEFAULT NULL,
341 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
342 `language` varchar(255) DEFAULT NULL,
343 `days_since_prior_session` int(11) DEFAULT NULL,
344 `days_since_first_session` int(11) DEFAULT NULL,
345 `num_prior_sessions` int(11) DEFAULT NULL,
346 `medium` varchar(255) DEFAULT NULL,
347 `source_id` bigint(20) DEFAULT NULL,
348 `ad_id` bigint(20) DEFAULT NULL,
349 `campaign_id` bigint(20) DEFAULT NULL,
350 `user_name` varchar(255) DEFAULT NULL,
351 `cv1_name` varchar(255) DEFAULT NULL,
352 `cv1_value` varchar(255) DEFAULT NULL,
353 `cv2_name` varchar(255) DEFAULT NULL,
354 `cv2_value` varchar(255) DEFAULT NULL,
355 `cv3_name` varchar(255) DEFAULT NULL,
356 `cv3_value` varchar(255) DEFAULT NULL,
357 `cv4_name` varchar(255) DEFAULT NULL,
358 `cv4_value` varchar(255) DEFAULT NULL,
359 `cv5_name` varchar(255) DEFAULT NULL,
360 `cv5_value` varchar(255) DEFAULT NULL,
361 `document_id` bigint(20) DEFAULT NULL,
362 `order_id` varchar(255) DEFAULT NULL,
363 `order_source` varchar(255) DEFAULT NULL,
364 `gateway` varchar(255) DEFAULT NULL,
365 `total_revenue` bigint(20) DEFAULT NULL,
366 `tax_revenue` bigint(20) DEFAULT NULL,
367 `shipping_revenue` bigint(20) DEFAULT NULL,
368 PRIMARY KEY (`id`),
369 KEY `session_id` (`session_id`),
370 KEY `site_id` (`site_id`),
371 KEY `yyyymmdd` (`yyyymmdd`),
372 KEY `order_id` (`order_id`)
373) ENGINE=InnoDB DEFAULT CHARSET=utf8;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Dumping data for table `owa_commerce_transaction_fact`
378--
379
380LOCK TABLES `owa_commerce_transaction_fact` WRITE;
381/*!40000 ALTER TABLE `owa_commerce_transaction_fact` DISABLE KEYS */;
382set autocommit=0;
383/*!40000 ALTER TABLE `owa_commerce_transaction_fact` ENABLE KEYS */;
384UNLOCK TABLES;
385commit;
386
387--
388-- Table structure for table `owa_configuration`
389--
390
391DROP TABLE IF EXISTS `owa_configuration`;
392/*!40101 SET @saved_cs_client = @@character_set_client */;
393/*!40101 SET character_set_client = utf8 */;
394CREATE TABLE `owa_configuration` (
395 `id` bigint(20) NOT NULL,
396 `settings` blob DEFAULT NULL,
397 PRIMARY KEY (`id`)
398) ENGINE=InnoDB DEFAULT CHARSET=utf8;
399/*!40101 SET character_set_client = @saved_cs_client */;
400
401--
402-- Dumping data for table `owa_configuration`
403--
404
405LOCK TABLES `owa_configuration` WRITE;
406/*!40000 ALTER TABLE `owa_configuration` DISABLE KEYS */;
407set autocommit=0;
408INSERT INTO `owa_configuration` VALUES (1,'a:2:{s:4:\"base\";a:18:{s:14:\"schema_version\";i:9;s:9:\"is_active\";b:1;s:16:\"install_complete\";b:1;s:13:\"resolve_hosts\";s:1:\"1\";s:15:\"log_feedreaders\";s:1:\"1\";s:10:\"log_robots\";N;s:15:\"log_named_users\";s:1:\"1\";s:12:\"excluded_ips\";N;s:13:\"anonymize_ips\";N;s:24:\"fetch_refering_page_info\";s:1:\"1\";s:10:\"p3p_policy\";s:45:\"NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM\";s:20:\"query_string_filters\";N;s:17:\"announce_visitors\";N;s:12:\"notice_email\";N;s:18:\"geolocation_lookup\";s:1:\"1\";s:16:\"track_feed_links\";s:1:\"1\";s:13:\"async_log_dir\";s:51:\"/home/sciocorp/public_html/Analytics/owa-data/logs/\";s:8:\"timezone\";s:14:\"America/Bogota\";}s:11:\"remoteQueue\";a:2:{s:14:\"schema_version\";i:1;s:9:\"is_active\";b:1;}}');
409/*!40000 ALTER TABLE `owa_configuration` ENABLE KEYS */;
410UNLOCK TABLES;
411commit;
412
413--
414-- Table structure for table `owa_document`
415--
416
417DROP TABLE IF EXISTS `owa_document`;
418/*!40101 SET @saved_cs_client = @@character_set_client */;
419/*!40101 SET character_set_client = utf8 */;
420CREATE TABLE `owa_document` (
421 `id` bigint(20) NOT NULL,
422 `url` varchar(255) DEFAULT NULL,
423 `uri` varchar(255) DEFAULT NULL,
424 `page_title` varchar(255) DEFAULT NULL,
425 `page_type` varchar(255) DEFAULT NULL,
426 PRIMARY KEY (`id`)
427) ENGINE=InnoDB DEFAULT CHARSET=utf8;
428/*!40101 SET character_set_client = @saved_cs_client */;
429
430--
431-- Dumping data for table `owa_document`
432--
433
434LOCK TABLES `owa_document` WRITE;
435/*!40000 ALTER TABLE `owa_document` DISABLE KEYS */;
436set autocommit=0;
437INSERT INTO `owa_document` VALUES (255651834,'https://sciocorp.org/ucceduco/ojs_20190119/index.php/in/index','/ucceduco/ojs_20190119/index.php/in/index','Ingeniería solidaria','(not set)'),(822541238,'https://sciocorp.org/ucceduco/ojs_20190119','/ucceduco/ojs_20190119','Revistas de la Universidad Cooperativa de Colombia','(not set)'),(1209084722,'https://sciocorp.org/ucceduco/ojs_20190119/index.php/index/login','/ucceduco/ojs_20190119/index.php/index/login','Entrar','(not set)');
438/*!40000 ALTER TABLE `owa_document` ENABLE KEYS */;
439UNLOCK TABLES;
440commit;
441
442--
443-- Table structure for table `owa_domstream`
444--
445
446DROP TABLE IF EXISTS `owa_domstream`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!40101 SET character_set_client = utf8 */;
449CREATE TABLE `owa_domstream` (
450 `id` bigint(20) NOT NULL,
451 `visitor_id` bigint(20) DEFAULT NULL,
452 `session_id` bigint(20) DEFAULT NULL,
453 `site_id` varchar(255) DEFAULT NULL,
454 `referer_id` bigint(20) DEFAULT NULL,
455 `ua_id` bigint(20) DEFAULT NULL,
456 `host_id` bigint(20) DEFAULT NULL,
457 `os_id` bigint(20) DEFAULT NULL,
458 `location_id` bigint(20) DEFAULT NULL,
459 `referring_search_term_id` bigint(20) DEFAULT NULL,
460 `timestamp` int(11) DEFAULT NULL,
461 `yyyymmdd` int(11) DEFAULT NULL,
462 `year` int(11) DEFAULT NULL,
463 `month` int(11) DEFAULT NULL,
464 `day` tinyint(2) DEFAULT NULL,
465 `dayofweek` varchar(10) DEFAULT NULL,
466 `dayofyear` int(11) DEFAULT NULL,
467 `weekofyear` int(11) DEFAULT NULL,
468 `last_req` bigint(20) DEFAULT NULL,
469 `ip_address` varchar(255) DEFAULT NULL,
470 `is_new_visitor` tinyint(1) DEFAULT NULL,
471 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
472 `language` varchar(255) DEFAULT NULL,
473 `days_since_prior_session` int(11) DEFAULT NULL,
474 `days_since_first_session` int(11) DEFAULT NULL,
475 `num_prior_sessions` int(11) DEFAULT NULL,
476 `medium` varchar(255) DEFAULT NULL,
477 `source_id` bigint(20) DEFAULT NULL,
478 `ad_id` bigint(20) DEFAULT NULL,
479 `campaign_id` bigint(20) DEFAULT NULL,
480 `user_name` varchar(255) DEFAULT NULL,
481 `cv1_name` varchar(255) DEFAULT NULL,
482 `cv1_value` varchar(255) DEFAULT NULL,
483 `cv2_name` varchar(255) DEFAULT NULL,
484 `cv2_value` varchar(255) DEFAULT NULL,
485 `cv3_name` varchar(255) DEFAULT NULL,
486 `cv3_value` varchar(255) DEFAULT NULL,
487 `cv4_name` varchar(255) DEFAULT NULL,
488 `cv4_value` varchar(255) DEFAULT NULL,
489 `cv5_name` varchar(255) DEFAULT NULL,
490 `cv5_value` varchar(255) DEFAULT NULL,
491 `document_id` bigint(20) DEFAULT NULL,
492 `domstream_guid` bigint(20) DEFAULT NULL,
493 `events` blob DEFAULT NULL,
494 `duration` int(11) DEFAULT NULL,
495 `page_url` varchar(255) DEFAULT NULL,
496 PRIMARY KEY (`id`),
497 KEY `session_id` (`session_id`),
498 KEY `site_id` (`site_id`),
499 KEY `yyyymmdd` (`yyyymmdd`)
500) ENGINE=InnoDB DEFAULT CHARSET=utf8;
501/*!40101 SET character_set_client = @saved_cs_client */;
502
503--
504-- Dumping data for table `owa_domstream`
505--
506
507LOCK TABLES `owa_domstream` WRITE;
508/*!40000 ALTER TABLE `owa_domstream` DISABLE KEYS */;
509set autocommit=0;
510/*!40000 ALTER TABLE `owa_domstream` ENABLE KEYS */;
511UNLOCK TABLES;
512commit;
513
514--
515-- Table structure for table `owa_exit`
516--
517
518DROP TABLE IF EXISTS `owa_exit`;
519/*!40101 SET @saved_cs_client = @@character_set_client */;
520/*!40101 SET character_set_client = utf8 */;
521CREATE TABLE `owa_exit` (
522 `id` bigint(20) NOT NULL,
523 `url` varchar(255) DEFAULT NULL,
524 `site_name` varchar(255) DEFAULT NULL,
525 `site` varchar(255) DEFAULT NULL,
526 `anchortext` varchar(255) DEFAULT NULL,
527 `page_title` varchar(255) DEFAULT NULL,
528 PRIMARY KEY (`id`)
529) ENGINE=InnoDB DEFAULT CHARSET=utf8;
530/*!40101 SET character_set_client = @saved_cs_client */;
531
532--
533-- Dumping data for table `owa_exit`
534--
535
536LOCK TABLES `owa_exit` WRITE;
537/*!40000 ALTER TABLE `owa_exit` DISABLE KEYS */;
538set autocommit=0;
539/*!40000 ALTER TABLE `owa_exit` ENABLE KEYS */;
540UNLOCK TABLES;
541commit;
542
543--
544-- Table structure for table `owa_feed_request`
545--
546
547DROP TABLE IF EXISTS `owa_feed_request`;
548/*!40101 SET @saved_cs_client = @@character_set_client */;
549/*!40101 SET character_set_client = utf8 */;
550CREATE TABLE `owa_feed_request` (
551 `id` bigint(20) NOT NULL,
552 `visitor_id` bigint(20) DEFAULT NULL,
553 `session_id` bigint(20) DEFAULT NULL,
554 `document_id` bigint(20) DEFAULT NULL,
555 `site_id` varchar(255) DEFAULT NULL,
556 `ua_id` varchar(255) DEFAULT NULL,
557 `host_id` bigint(20) DEFAULT NULL,
558 `os_id` varchar(255) DEFAULT NULL,
559 `site` varchar(255) DEFAULT NULL,
560 `host` varchar(255) DEFAULT NULL,
561 `feed_reader_guid` varchar(255) DEFAULT NULL,
562 `subscription_id` bigint(20) DEFAULT NULL,
563 `timestamp` bigint(20) DEFAULT NULL,
564 `yyyymmdd` int(11) DEFAULT NULL,
565 `month` int(11) DEFAULT NULL,
566 `day` tinyint(2) DEFAULT NULL,
567 `dayofweek` varchar(10) DEFAULT NULL,
568 `dayofyear` int(11) DEFAULT NULL,
569 `weekofyear` int(11) DEFAULT NULL,
570 `year` int(11) DEFAULT NULL,
571 `hour` tinyint(2) DEFAULT NULL,
572 `minute` tinyint(2) DEFAULT NULL,
573 `second` tinyint(2) DEFAULT NULL,
574 `msec` int(11) DEFAULT NULL,
575 `last_req` bigint(20) DEFAULT NULL,
576 `feed_format` varchar(255) DEFAULT NULL,
577 `ip_address` varchar(255) DEFAULT NULL,
578 `os` varchar(255) DEFAULT NULL,
579 PRIMARY KEY (`id`),
580 KEY `yyyymmdd` (`yyyymmdd`)
581) ENGINE=InnoDB DEFAULT CHARSET=utf8;
582/*!40101 SET character_set_client = @saved_cs_client */;
583
584--
585-- Dumping data for table `owa_feed_request`
586--
587
588LOCK TABLES `owa_feed_request` WRITE;
589/*!40000 ALTER TABLE `owa_feed_request` DISABLE KEYS */;
590set autocommit=0;
591/*!40000 ALTER TABLE `owa_feed_request` ENABLE KEYS */;
592UNLOCK TABLES;
593commit;
594
595--
596-- Table structure for table `owa_host`
597--
598
599DROP TABLE IF EXISTS `owa_host`;
600/*!40101 SET @saved_cs_client = @@character_set_client */;
601/*!40101 SET character_set_client = utf8 */;
602CREATE TABLE `owa_host` (
603 `id` bigint(20) NOT NULL,
604 `ip_address` varchar(255) DEFAULT NULL,
605 `host` varchar(255) DEFAULT NULL,
606 `full_host` varchar(255) DEFAULT NULL,
607 `city` varchar(255) DEFAULT NULL,
608 `country` varchar(255) DEFAULT NULL,
609 `latitude` varchar(255) DEFAULT NULL,
610 `longitude` varchar(255) DEFAULT NULL,
611 PRIMARY KEY (`id`)
612) ENGINE=InnoDB DEFAULT CHARSET=utf8;
613/*!40101 SET character_set_client = @saved_cs_client */;
614
615--
616-- Dumping data for table `owa_host`
617--
618
619LOCK TABLES `owa_host` WRITE;
620/*!40000 ALTER TABLE `owa_host` DISABLE KEYS */;
621set autocommit=0;
622INSERT INTO `owa_host` VALUES (1379425799,'201.244.40.19','etb.net.co','dynamic-201-244-40-19.dynamic.etb.net.co','(not set)','(not set)','(not set)','(not set)'),(3606322599,'190.28.168.204','epm.net.co','adsl190-28-168-204.epm.net.co','(not set)','(not set)','(not set)','(not set)');
623/*!40000 ALTER TABLE `owa_host` ENABLE KEYS */;
624UNLOCK TABLES;
625commit;
626
627--
628-- Table structure for table `owa_impression`
629--
630
631DROP TABLE IF EXISTS `owa_impression`;
632/*!40101 SET @saved_cs_client = @@character_set_client */;
633/*!40101 SET character_set_client = utf8 */;
634CREATE TABLE `owa_impression` (
635 `id` bigint(20) NOT NULL,
636 `visitor_id` bigint(20) DEFAULT NULL,
637 `session_id` bigint(20) DEFAULT NULL,
638 `tag_id` bigint(20) DEFAULT NULL,
639 `placement_id` bigint(20) DEFAULT NULL,
640 `campaign_id` bigint(20) DEFAULT NULL,
641 `ad_group_id` bigint(20) DEFAULT NULL,
642 `ad_id` bigint(20) DEFAULT NULL,
643 `site_id` varchar(255) DEFAULT NULL,
644 `last_impression_id` bigint(20) DEFAULT NULL,
645 `last_impression_timestamp` bigint(20) DEFAULT NULL,
646 `timestamp` bigint(20) DEFAULT NULL,
647 `year` int(11) DEFAULT NULL,
648 `month` int(11) DEFAULT NULL,
649 `day` int(11) DEFAULT NULL,
650 `dayofyear` int(11) DEFAULT NULL,
651 `weekofyear` int(11) DEFAULT NULL,
652 `hour` tinyint(2) DEFAULT NULL,
653 `minute` tinyint(2) DEFAULT NULL,
654 `msec` bigint(20) DEFAULT NULL,
655 `url` varchar(255) DEFAULT NULL,
656 `ua_id` bigint(20) DEFAULT NULL,
657 `ip_address` varchar(255) DEFAULT NULL,
658 `host_id` varchar(255) DEFAULT NULL,
659 `host` varchar(255) DEFAULT NULL,
660 PRIMARY KEY (`id`)
661) ENGINE=InnoDB DEFAULT CHARSET=utf8;
662/*!40101 SET character_set_client = @saved_cs_client */;
663
664--
665-- Dumping data for table `owa_impression`
666--
667
668LOCK TABLES `owa_impression` WRITE;
669/*!40000 ALTER TABLE `owa_impression` DISABLE KEYS */;
670set autocommit=0;
671/*!40000 ALTER TABLE `owa_impression` ENABLE KEYS */;
672UNLOCK TABLES;
673commit;
674
675--
676-- Table structure for table `owa_location_dim`
677--
678
679DROP TABLE IF EXISTS `owa_location_dim`;
680/*!40101 SET @saved_cs_client = @@character_set_client */;
681/*!40101 SET character_set_client = utf8 */;
682CREATE TABLE `owa_location_dim` (
683 `id` bigint(20) NOT NULL,
684 `country` varchar(255) DEFAULT NULL,
685 `country_code` varchar(255) DEFAULT NULL,
686 `state` varchar(255) DEFAULT NULL,
687 `city` varchar(255) DEFAULT NULL,
688 `latitude` varchar(255) DEFAULT NULL,
689 `longitude` varchar(255) DEFAULT NULL,
690 PRIMARY KEY (`id`)
691) ENGINE=InnoDB DEFAULT CHARSET=utf8;
692/*!40101 SET character_set_client = @saved_cs_client */;
693
694--
695-- Dumping data for table `owa_location_dim`
696--
697
698LOCK TABLES `owa_location_dim` WRITE;
699/*!40000 ALTER TABLE `owa_location_dim` DISABLE KEYS */;
700set autocommit=0;
701INSERT INTO `owa_location_dim` VALUES (259604063,'(not set)','(not set)','(not set)','(not set)','(not set)','(not set)');
702/*!40000 ALTER TABLE `owa_location_dim` ENABLE KEYS */;
703UNLOCK TABLES;
704commit;
705
706--
707-- Table structure for table `owa_os`
708--
709
710DROP TABLE IF EXISTS `owa_os`;
711/*!40101 SET @saved_cs_client = @@character_set_client */;
712/*!40101 SET character_set_client = utf8 */;
713CREATE TABLE `owa_os` (
714 `id` bigint(20) NOT NULL,
715 `name` varchar(255) DEFAULT NULL,
716 PRIMARY KEY (`id`)
717) ENGINE=InnoDB DEFAULT CHARSET=utf8;
718/*!40101 SET character_set_client = @saved_cs_client */;
719
720--
721-- Dumping data for table `owa_os`
722--
723
724LOCK TABLES `owa_os` WRITE;
725/*!40000 ALTER TABLE `owa_os` DISABLE KEYS */;
726set autocommit=0;
727INSERT INTO `owa_os` VALUES (2085328441,'Ubuntu'),(3823601051,'Windows');
728/*!40000 ALTER TABLE `owa_os` ENABLE KEYS */;
729UNLOCK TABLES;
730commit;
731
732--
733-- Table structure for table `owa_queue_item`
734--
735
736DROP TABLE IF EXISTS `owa_queue_item`;
737/*!40101 SET @saved_cs_client = @@character_set_client */;
738/*!40101 SET character_set_client = utf8 */;
739CREATE TABLE `owa_queue_item` (
740 `id` bigint(20) NOT NULL,
741 `event_type` varchar(255) DEFAULT NULL,
742 `priority` int(11) DEFAULT NULL,
743 `status` varchar(255) DEFAULT NULL,
744 `event` blob DEFAULT NULL,
745 `insertion_datestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
746 `insertion_timestamp` int(11) DEFAULT NULL,
747 `handled_timestamp` int(11) DEFAULT NULL,
748 `last_attempt_timestamp` int(11) DEFAULT NULL,
749 `not_before_timestamp` int(11) DEFAULT NULL,
750 `failed_attempt_count` int(11) DEFAULT NULL,
751 `is_assigned` tinyint(1) DEFAULT NULL,
752 `last_error_msg` varchar(255) DEFAULT NULL,
753 `handled_by` varchar(255) DEFAULT NULL,
754 `handler_duration` int(11) DEFAULT NULL,
755 PRIMARY KEY (`id`)
756) ENGINE=InnoDB DEFAULT CHARSET=utf8;
757/*!40101 SET character_set_client = @saved_cs_client */;
758
759--
760-- Dumping data for table `owa_queue_item`
761--
762
763LOCK TABLES `owa_queue_item` WRITE;
764/*!40000 ALTER TABLE `owa_queue_item` DISABLE KEYS */;
765set autocommit=0;
766/*!40000 ALTER TABLE `owa_queue_item` ENABLE KEYS */;
767UNLOCK TABLES;
768commit;
769
770--
771-- Table structure for table `owa_referer`
772--
773
774DROP TABLE IF EXISTS `owa_referer`;
775/*!40101 SET @saved_cs_client = @@character_set_client */;
776/*!40101 SET character_set_client = utf8 */;
777CREATE TABLE `owa_referer` (
778 `id` bigint(20) NOT NULL,
779 `url` varchar(255) DEFAULT NULL,
780 `site_name` varchar(255) DEFAULT NULL,
781 `site` varchar(255) DEFAULT NULL,
782 `query_terms` varchar(255) DEFAULT NULL,
783 `refering_anchortext` varchar(255) DEFAULT NULL,
784 `page_title` varchar(255) DEFAULT NULL,
785 `snippet` mediumtext DEFAULT NULL,
786 `is_searchengine` tinyint(1) DEFAULT NULL,
787 PRIMARY KEY (`id`)
788) ENGINE=InnoDB DEFAULT CHARSET=utf8;
789/*!40101 SET character_set_client = @saved_cs_client */;
790
791--
792-- Dumping data for table `owa_referer`
793--
794
795LOCK TABLES `owa_referer` WRITE;
796/*!40000 ALTER TABLE `owa_referer` DISABLE KEYS */;
797set autocommit=0;
798INSERT INTO `owa_referer` VALUES (118221093,'(none)','','','','','(not set)','',0);
799/*!40000 ALTER TABLE `owa_referer` ENABLE KEYS */;
800UNLOCK TABLES;
801commit;
802
803--
804-- Table structure for table `owa_request`
805--
806
807DROP TABLE IF EXISTS `owa_request`;
808/*!40101 SET @saved_cs_client = @@character_set_client */;
809/*!40101 SET character_set_client = utf8 */;
810CREATE TABLE `owa_request` (
811 `id` bigint(20) NOT NULL,
812 `visitor_id` bigint(20) DEFAULT NULL,
813 `session_id` bigint(20) DEFAULT NULL,
814 `site_id` varchar(255) DEFAULT NULL,
815 `referer_id` bigint(20) DEFAULT NULL,
816 `ua_id` bigint(20) DEFAULT NULL,
817 `host_id` bigint(20) DEFAULT NULL,
818 `os_id` bigint(20) DEFAULT NULL,
819 `location_id` bigint(20) DEFAULT NULL,
820 `referring_search_term_id` bigint(20) DEFAULT NULL,
821 `timestamp` int(11) DEFAULT NULL,
822 `yyyymmdd` int(11) DEFAULT NULL,
823 `year` int(11) DEFAULT NULL,
824 `month` int(11) DEFAULT NULL,
825 `day` tinyint(2) DEFAULT NULL,
826 `dayofweek` varchar(10) DEFAULT NULL,
827 `dayofyear` int(11) DEFAULT NULL,
828 `weekofyear` int(11) DEFAULT NULL,
829 `last_req` bigint(20) DEFAULT NULL,
830 `ip_address` varchar(255) DEFAULT NULL,
831 `is_new_visitor` tinyint(1) DEFAULT NULL,
832 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
833 `language` varchar(255) DEFAULT NULL,
834 `days_since_prior_session` int(11) DEFAULT NULL,
835 `days_since_first_session` int(11) DEFAULT NULL,
836 `num_prior_sessions` int(11) DEFAULT NULL,
837 `medium` varchar(255) DEFAULT NULL,
838 `source_id` bigint(20) DEFAULT NULL,
839 `ad_id` bigint(20) DEFAULT NULL,
840 `campaign_id` bigint(20) DEFAULT NULL,
841 `user_name` varchar(255) DEFAULT NULL,
842 `cv1_name` varchar(255) DEFAULT NULL,
843 `cv1_value` varchar(255) DEFAULT NULL,
844 `cv2_name` varchar(255) DEFAULT NULL,
845 `cv2_value` varchar(255) DEFAULT NULL,
846 `cv3_name` varchar(255) DEFAULT NULL,
847 `cv3_value` varchar(255) DEFAULT NULL,
848 `cv4_name` varchar(255) DEFAULT NULL,
849 `cv4_value` varchar(255) DEFAULT NULL,
850 `cv5_name` varchar(255) DEFAULT NULL,
851 `cv5_value` varchar(255) DEFAULT NULL,
852 `inbound_visitor_id` bigint(20) DEFAULT NULL,
853 `inbound_session_id` bigint(20) DEFAULT NULL,
854 `feed_subscription_id` bigint(20) DEFAULT NULL,
855 `user_email` varchar(255) DEFAULT NULL,
856 `hour` tinyint(2) DEFAULT NULL,
857 `minute` tinyint(2) DEFAULT NULL,
858 `second` tinyint(2) DEFAULT NULL,
859 `msec` int(11) DEFAULT NULL,
860 `document_id` varchar(255) DEFAULT NULL,
861 `site` varchar(255) DEFAULT NULL,
862 `os` varchar(255) DEFAULT NULL,
863 `prior_document_id` bigint(20) DEFAULT NULL,
864 `is_comment` tinyint(1) DEFAULT NULL,
865 `is_entry_page` tinyint(1) DEFAULT NULL,
866 `is_browser` tinyint(1) DEFAULT NULL,
867 `is_robot` tinyint(1) DEFAULT NULL,
868 `is_feedreader` tinyint(1) DEFAULT NULL,
869 PRIMARY KEY (`id`),
870 KEY `session_id` (`session_id`),
871 KEY `site_id` (`site_id`),
872 KEY `yyyymmdd` (`yyyymmdd`)
873) ENGINE=InnoDB DEFAULT CHARSET=utf8;
874/*!40101 SET character_set_client = @saved_cs_client */;
875
876--
877-- Dumping data for table `owa_request`
878--
879
880LOCK TABLES `owa_request` WRITE;
881/*!40000 ALTER TABLE `owa_request` DISABLE KEYS */;
882set autocommit=0;
883INSERT INTO `owa_request` VALUES (1548343739169089295,1548343740938411687,1548343740971991026,'9eff8d709599b08f97dc4fa264587877',118221093,1518164971,3606322599,3823601051,259604063,118221093,1548343739,20190124,2019,201901,24,'Thu',23,4,0,'190.28.168.204',0,0,'es-41',0,0,0,'direct',118221093,0,0,'admin','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,0,0,'(not set)',10,28,59,0,'822541238','','Windows',0,0,1,1,0,0),(1548343749034405298,1548343740938411687,1548343740971991026,'9eff8d709599b08f97dc4fa264587877',118221093,1518164971,3606322599,3823601051,259604063,118221093,1548343749,20190124,2019,201901,24,'Thu',23,4,1548343740,'190.28.168.204',0,1,'es-41',0,0,0,'direct',118221093,0,0,'admin','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,0,0,'(not set)',10,29,9,0,'822541238','','Windows',0,0,0,1,0,0),(1548343750968681298,1548343752772892233,1548343752790319953,'9eff8d709599b08f97dc4fa264587877',118221093,343073837,1379425799,2085328441,259604063,118221093,1548343750,20190124,2019,201901,24,'Thu',23,4,0,'201.244.40.19',0,0,'en-US',0,0,0,'direct',118221093,0,0,'(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,0,0,'(not set)',10,29,10,1,'255651834','','Ubuntu',2916301847,0,1,1,0,0),(1548343759297301299,1548343740938411687,1548343740971991026,'9eff8d709599b08f97dc4fa264587877',118221093,1518164971,3606322599,3823601051,259604063,118221093,1548343759,20190124,2019,201901,24,'Thu',23,4,1548343750,'190.28.168.204',0,1,'es-41',0,0,0,'direct',118221093,0,0,'admin','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',0,0,0,'(not set)',10,29,19,0,'1209084722','','Windows',822541238,0,0,1,0,0);
884/*!40000 ALTER TABLE `owa_request` ENABLE KEYS */;
885UNLOCK TABLES;
886commit;
887
888--
889-- Table structure for table `owa_search_term_dim`
890--
891
892DROP TABLE IF EXISTS `owa_search_term_dim`;
893/*!40101 SET @saved_cs_client = @@character_set_client */;
894/*!40101 SET character_set_client = utf8 */;
895CREATE TABLE `owa_search_term_dim` (
896 `id` bigint(20) NOT NULL,
897 `terms` varchar(255) DEFAULT NULL,
898 `term_count` varchar(255) DEFAULT NULL,
899 PRIMARY KEY (`id`)
900) ENGINE=InnoDB DEFAULT CHARSET=utf8;
901/*!40101 SET character_set_client = @saved_cs_client */;
902
903--
904-- Dumping data for table `owa_search_term_dim`
905--
906
907LOCK TABLES `owa_search_term_dim` WRITE;
908/*!40000 ALTER TABLE `owa_search_term_dim` DISABLE KEYS */;
909set autocommit=0;
910INSERT INTO `owa_search_term_dim` VALUES (118221093,'(none)','0');
911/*!40000 ALTER TABLE `owa_search_term_dim` ENABLE KEYS */;
912UNLOCK TABLES;
913commit;
914
915--
916-- Table structure for table `owa_session`
917--
918
919DROP TABLE IF EXISTS `owa_session`;
920/*!40101 SET @saved_cs_client = @@character_set_client */;
921/*!40101 SET character_set_client = utf8 */;
922CREATE TABLE `owa_session` (
923 `id` bigint(20) NOT NULL,
924 `visitor_id` bigint(20) DEFAULT NULL,
925 `site_id` varchar(255) DEFAULT NULL,
926 `referer_id` bigint(20) DEFAULT NULL,
927 `ua_id` bigint(20) DEFAULT NULL,
928 `host_id` bigint(20) DEFAULT NULL,
929 `os_id` bigint(20) DEFAULT NULL,
930 `location_id` bigint(20) DEFAULT NULL,
931 `referring_search_term_id` bigint(20) DEFAULT NULL,
932 `timestamp` int(11) DEFAULT NULL,
933 `yyyymmdd` int(11) DEFAULT NULL,
934 `year` int(11) DEFAULT NULL,
935 `month` int(11) DEFAULT NULL,
936 `day` tinyint(2) DEFAULT NULL,
937 `dayofweek` varchar(10) DEFAULT NULL,
938 `dayofyear` int(11) DEFAULT NULL,
939 `weekofyear` int(11) DEFAULT NULL,
940 `last_req` bigint(20) DEFAULT NULL,
941 `ip_address` varchar(255) DEFAULT NULL,
942 `is_new_visitor` tinyint(1) DEFAULT NULL,
943 `is_repeat_visitor` tinyint(1) DEFAULT NULL,
944 `language` varchar(255) DEFAULT NULL,
945 `days_since_prior_session` int(11) DEFAULT NULL,
946 `days_since_first_session` int(11) DEFAULT NULL,
947 `num_prior_sessions` int(11) DEFAULT NULL,
948 `medium` varchar(255) DEFAULT NULL,
949 `source_id` bigint(20) DEFAULT NULL,
950 `ad_id` bigint(20) DEFAULT NULL,
951 `campaign_id` bigint(20) DEFAULT NULL,
952 `user_name` varchar(255) DEFAULT NULL,
953 `cv1_name` varchar(255) DEFAULT NULL,
954 `cv1_value` varchar(255) DEFAULT NULL,
955 `cv2_name` varchar(255) DEFAULT NULL,
956 `cv2_value` varchar(255) DEFAULT NULL,
957 `cv3_name` varchar(255) DEFAULT NULL,
958 `cv3_value` varchar(255) DEFAULT NULL,
959 `cv4_name` varchar(255) DEFAULT NULL,
960 `cv4_value` varchar(255) DEFAULT NULL,
961 `cv5_name` varchar(255) DEFAULT NULL,
962 `cv5_value` varchar(255) DEFAULT NULL,
963 `user_email` varchar(255) DEFAULT NULL,
964 `hour` tinyint(2) DEFAULT NULL,
965 `minute` tinyint(2) DEFAULT NULL,
966 `num_pageviews` int(11) DEFAULT NULL,
967 `num_comments` int(11) DEFAULT NULL,
968 `is_bounce` tinyint(1) DEFAULT NULL,
969 `prior_session_lastreq` bigint(20) DEFAULT NULL,
970 `prior_session_id` bigint(20) DEFAULT NULL,
971 `time_sinse_priorsession` int(11) DEFAULT NULL,
972 `prior_session_year` tinyint(4) DEFAULT NULL,
973 `prior_session_month` varchar(255) DEFAULT NULL,
974 `prior_session_day` tinyint(2) DEFAULT NULL,
975 `prior_session_dayofweek` int(11) DEFAULT NULL,
976 `prior_session_hour` tinyint(2) DEFAULT NULL,
977 `prior_session_minute` tinyint(2) DEFAULT NULL,
978 `os` varchar(255) DEFAULT NULL,
979 `first_page_id` bigint(20) DEFAULT NULL,
980 `last_page_id` bigint(20) DEFAULT NULL,
981 `host` varchar(255) DEFAULT NULL,
982 `city` varchar(255) DEFAULT NULL,
983 `country` varchar(255) DEFAULT NULL,
984 `site` varchar(255) DEFAULT NULL,
985 `is_robot` tinyint(1) DEFAULT NULL,
986 `is_browser` tinyint(1) DEFAULT NULL,
987 `is_feedreader` tinyint(1) DEFAULT NULL,
988 `latest_attributions` blob DEFAULT NULL,
989 `goal_1` tinyint(1) DEFAULT NULL,
990 `goal_1_start` tinyint(1) DEFAULT NULL,
991 `goal_1_value` bigint(20) DEFAULT NULL,
992 `goal_2` tinyint(1) DEFAULT NULL,
993 `goal_2_start` tinyint(1) DEFAULT NULL,
994 `goal_2_value` bigint(20) DEFAULT NULL,
995 `goal_3` tinyint(1) DEFAULT NULL,
996 `goal_3_start` tinyint(1) DEFAULT NULL,
997 `goal_3_value` bigint(20) DEFAULT NULL,
998 `goal_4` tinyint(1) DEFAULT NULL,
999 `goal_4_start` tinyint(1) DEFAULT NULL,
1000 `goal_4_value` bigint(20) DEFAULT NULL,
1001 `goal_5` tinyint(1) DEFAULT NULL,
1002 `goal_5_start` tinyint(1) DEFAULT NULL,
1003 `goal_5_value` bigint(20) DEFAULT NULL,
1004 `goal_6` tinyint(1) DEFAULT NULL,
1005 `goal_6_start` tinyint(1) DEFAULT NULL,
1006 `goal_6_value` bigint(20) DEFAULT NULL,
1007 `goal_7` tinyint(1) DEFAULT NULL,
1008 `goal_7_start` tinyint(1) DEFAULT NULL,
1009 `goal_7_value` bigint(20) DEFAULT NULL,
1010 `goal_8` tinyint(1) DEFAULT NULL,
1011 `goal_8_start` tinyint(1) DEFAULT NULL,
1012 `goal_8_value` bigint(20) DEFAULT NULL,
1013 `goal_9` tinyint(1) DEFAULT NULL,
1014 `goal_9_start` tinyint(1) DEFAULT NULL,
1015 `goal_9_value` bigint(20) DEFAULT NULL,
1016 `goal_10` tinyint(1) DEFAULT NULL,
1017 `goal_10_start` tinyint(1) DEFAULT NULL,
1018 `goal_10_value` bigint(20) DEFAULT NULL,
1019 `goal_11` tinyint(1) DEFAULT NULL,
1020 `goal_11_start` tinyint(1) DEFAULT NULL,
1021 `goal_11_value` bigint(20) DEFAULT NULL,
1022 `goal_12` tinyint(1) DEFAULT NULL,
1023 `goal_12_start` tinyint(1) DEFAULT NULL,
1024 `goal_12_value` bigint(20) DEFAULT NULL,
1025 `goal_13` tinyint(1) DEFAULT NULL,
1026 `goal_13_start` tinyint(1) DEFAULT NULL,
1027 `goal_13_value` bigint(20) DEFAULT NULL,
1028 `goal_14` tinyint(1) DEFAULT NULL,
1029 `goal_14_start` tinyint(1) DEFAULT NULL,
1030 `goal_14_value` bigint(20) DEFAULT NULL,
1031 `goal_15` tinyint(1) DEFAULT NULL,
1032 `goal_15_start` tinyint(1) DEFAULT NULL,
1033 `goal_15_value` bigint(20) DEFAULT NULL,
1034 `num_goals` tinyint(1) DEFAULT NULL,
1035 `num_goal_starts` tinyint(1) DEFAULT NULL,
1036 `goals_value` bigint(20) DEFAULT NULL,
1037 `commerce_trans_count` int(11) DEFAULT NULL,
1038 `commerce_trans_revenue` bigint(20) DEFAULT NULL,
1039 `commerce_items_revenue` bigint(20) DEFAULT NULL,
1040 `commerce_items_count` int(11) DEFAULT NULL,
1041 `commerce_items_quantity` int(11) DEFAULT NULL,
1042 `commerce_shipping_revenue` bigint(20) DEFAULT NULL,
1043 `commerce_tax_revenue` bigint(20) DEFAULT NULL,
1044 PRIMARY KEY (`id`),
1045 KEY `site_id` (`site_id`),
1046 KEY `yyyymmdd` (`yyyymmdd`)
1047) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1048/*!40101 SET character_set_client = @saved_cs_client */;
1049
1050--
1051-- Dumping data for table `owa_session`
1052--
1053
1054LOCK TABLES `owa_session` WRITE;
1055/*!40000 ALTER TABLE `owa_session` DISABLE KEYS */;
1056set autocommit=0;
1057INSERT INTO `owa_session` VALUES (1548343740971991026,1548343740938411687,'9eff8d709599b08f97dc4fa264587877',118221093,1518164971,3606322599,3823601051,259604063,118221093,1548343739,20190124,2019,201901,24,'Thu',23,4,1548343759,'190.28.168.204',0,0,'es-41',0,0,0,'direct',118221093,0,0,'admin','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',10,28,3,0,0,0,0,0,0,'',0,0,0,0,'Windows',822541238,1209084722,'epm.net.co','(not set)','(not set)','',0,1,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(1548343752790319953,1548343752772892233,'9eff8d709599b08f97dc4fa264587877',118221093,343073837,1379425799,2085328441,259604063,118221093,1548343750,20190124,2019,201901,24,'Thu',23,4,1548343750,'201.244.40.19',0,0,'en-US',0,0,0,'direct',118221093,0,0,'(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)','(not set)',10,29,1,0,1,0,0,0,0,'',0,0,0,0,'Ubuntu',255651834,255651834,'etb.net.co','(not set)','(not set)','',0,1,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
1058/*!40000 ALTER TABLE `owa_session` ENABLE KEYS */;
1059UNLOCK TABLES;
1060commit;
1061
1062--
1063-- Table structure for table `owa_site`
1064--
1065
1066DROP TABLE IF EXISTS `owa_site`;
1067/*!40101 SET @saved_cs_client = @@character_set_client */;
1068/*!40101 SET character_set_client = utf8 */;
1069CREATE TABLE `owa_site` (
1070 `id` bigint(20) NOT NULL,
1071 `site_id` varchar(255) DEFAULT NULL,
1072 `domain` varchar(255) DEFAULT NULL,
1073 `name` varchar(255) DEFAULT NULL,
1074 `description` mediumtext DEFAULT NULL,
1075 `site_family` varchar(255) DEFAULT NULL,
1076 `settings` blob DEFAULT NULL,
1077 PRIMARY KEY (`id`)
1078) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1079/*!40101 SET character_set_client = @saved_cs_client */;
1080
1081--
1082-- Dumping data for table `owa_site`
1083--
1084
1085LOCK TABLES `owa_site` WRITE;
1086/*!40000 ALTER TABLE `owa_site` DISABLE KEYS */;
1087set autocommit=0;
1088INSERT INTO `owa_site` VALUES (2695196352,'9eff8d709599b08f97dc4fa264587877','https://sciocorp.org/ucceduco/ojs_20190119','https://sciocorp.org/ucceduco/ojs_20190119','','','');
1089/*!40000 ALTER TABLE `owa_site` ENABLE KEYS */;
1090UNLOCK TABLES;
1091commit;
1092
1093--
1094-- Table structure for table `owa_site_user`
1095--
1096
1097DROP TABLE IF EXISTS `owa_site_user`;
1098/*!40101 SET @saved_cs_client = @@character_set_client */;
1099/*!40101 SET character_set_client = utf8 */;
1100CREATE TABLE `owa_site_user` (
1101 `site_id` bigint(20) DEFAULT NULL,
1102 `user_id` int(11) DEFAULT NULL
1103) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1104/*!40101 SET character_set_client = @saved_cs_client */;
1105
1106--
1107-- Dumping data for table `owa_site_user`
1108--
1109
1110LOCK TABLES `owa_site_user` WRITE;
1111/*!40000 ALTER TABLE `owa_site_user` DISABLE KEYS */;
1112set autocommit=0;
1113/*!40000 ALTER TABLE `owa_site_user` ENABLE KEYS */;
1114UNLOCK TABLES;
1115commit;
1116
1117--
1118-- Table structure for table `owa_source_dim`
1119--
1120
1121DROP TABLE IF EXISTS `owa_source_dim`;
1122/*!40101 SET @saved_cs_client = @@character_set_client */;
1123/*!40101 SET character_set_client = utf8 */;
1124CREATE TABLE `owa_source_dim` (
1125 `id` bigint(20) NOT NULL,
1126 `source_domain` varchar(255) DEFAULT NULL,
1127 PRIMARY KEY (`id`)
1128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1129/*!40101 SET character_set_client = @saved_cs_client */;
1130
1131--
1132-- Dumping data for table `owa_source_dim`
1133--
1134
1135LOCK TABLES `owa_source_dim` WRITE;
1136/*!40000 ALTER TABLE `owa_source_dim` DISABLE KEYS */;
1137set autocommit=0;
1138INSERT INTO `owa_source_dim` VALUES (118221093,'(none)');
1139/*!40000 ALTER TABLE `owa_source_dim` ENABLE KEYS */;
1140UNLOCK TABLES;
1141commit;
1142
1143--
1144-- Table structure for table `owa_ua`
1145--
1146
1147DROP TABLE IF EXISTS `owa_ua`;
1148/*!40101 SET @saved_cs_client = @@character_set_client */;
1149/*!40101 SET character_set_client = utf8 */;
1150CREATE TABLE `owa_ua` (
1151 `id` bigint(20) NOT NULL,
1152 `ua` varchar(255) DEFAULT NULL,
1153 `browser_type` varchar(255) DEFAULT NULL,
1154 `browser` varchar(255) DEFAULT NULL,
1155 PRIMARY KEY (`id`)
1156) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1157/*!40101 SET character_set_client = @saved_cs_client */;
1158
1159--
1160-- Dumping data for table `owa_ua`
1161--
1162
1163LOCK TABLES `owa_ua` WRITE;
1164/*!40000 ALTER TABLE `owa_ua` DISABLE KEYS */;
1165set autocommit=0;
1166INSERT INTO `owa_ua` VALUES (343073837,'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0','Firefox','57.0'),(1518164971,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36','Chrome','71.0.3578');
1167/*!40000 ALTER TABLE `owa_ua` ENABLE KEYS */;
1168UNLOCK TABLES;
1169commit;
1170
1171--
1172-- Table structure for table `owa_user`
1173--
1174
1175DROP TABLE IF EXISTS `owa_user`;
1176/*!40101 SET @saved_cs_client = @@character_set_client */;
1177/*!40101 SET character_set_client = utf8 */;
1178CREATE TABLE `owa_user` (
1179 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1180 `user_id` varchar(255) NOT NULL,
1181 `password` varchar(255) DEFAULT NULL,
1182 `role` varchar(255) DEFAULT NULL,
1183 `real_name` varchar(255) DEFAULT NULL,
1184 `email_address` varchar(255) DEFAULT NULL,
1185 `temp_passkey` varchar(255) DEFAULT NULL,
1186 `creation_date` bigint(20) DEFAULT NULL,
1187 `last_update_date` bigint(20) DEFAULT NULL,
1188 `api_key` varchar(255) DEFAULT NULL,
1189 PRIMARY KEY (`user_id`),
1190 UNIQUE KEY `id` (`id`)
1191) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1192/*!40101 SET character_set_client = @saved_cs_client */;
1193
1194--
1195-- Dumping data for table `owa_user`
1196--
1197
1198LOCK TABLES `owa_user` WRITE;
1199/*!40000 ALTER TABLE `owa_user` DISABLE KEYS */;
1200set autocommit=0;
1201INSERT INTO `owa_user` VALUES (1,'admin','152f18b81850745ad543a2e63fd9c50b','admin','','fabio310us@yahoo.com','0ba41d01226fba7192e0aa39bd65cf2e',1548341311,1548341311,'1936f38e4feea82aaeb036941189c17a');
1202/*!40000 ALTER TABLE `owa_user` ENABLE KEYS */;
1203UNLOCK TABLES;
1204commit;
1205
1206--
1207-- Table structure for table `owa_visitor`
1208--
1209
1210DROP TABLE IF EXISTS `owa_visitor`;
1211/*!40101 SET @saved_cs_client = @@character_set_client */;
1212/*!40101 SET character_set_client = utf8 */;
1213CREATE TABLE `owa_visitor` (
1214 `id` bigint(20) NOT NULL,
1215 `user_name` varchar(255) DEFAULT NULL,
1216 `user_email` varchar(255) DEFAULT NULL,
1217 `first_session_id` bigint(20) DEFAULT NULL,
1218 `first_session_year` int(11) DEFAULT NULL,
1219 `first_session_month` varchar(255) DEFAULT NULL,
1220 `first_session_day` int(11) DEFAULT NULL,
1221 `first_session_dayofyear` int(11) DEFAULT NULL,
1222 `first_session_timestamp` bigint(20) DEFAULT NULL,
1223 `first_session_yyyymmdd` bigint(20) DEFAULT NULL,
1224 `last_session_id` bigint(20) DEFAULT NULL,
1225 `last_session_year` int(11) DEFAULT NULL,
1226 `last_session_month` varchar(255) DEFAULT NULL,
1227 `last_session_day` int(11) DEFAULT NULL,
1228 `last_session_dayofyear` int(11) DEFAULT NULL,
1229 `num_prior_sessions` int(11) DEFAULT NULL,
1230 PRIMARY KEY (`id`)
1231) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1232/*!40101 SET character_set_client = @saved_cs_client */;
1233
1234--
1235-- Dumping data for table `owa_visitor`
1236--
1237
1238LOCK TABLES `owa_visitor` WRITE;
1239/*!40000 ALTER TABLE `owa_visitor` DISABLE KEYS */;
1240set autocommit=0;
1241INSERT INTO `owa_visitor` VALUES (1548343740938411687,'admin','(not set)',1548343740971991026,2019,'201901',24,23,1548343739,20190124,0,0,'',0,0,0),(1548343752772892233,'(not set)','(not set)',1548343752790319953,2019,'201901',24,23,1548343750,20190124,0,0,'',0,0,0);
1242/*!40000 ALTER TABLE `owa_visitor` ENABLE KEYS */;
1243UNLOCK TABLES;
1244commit;
1245/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1246
1247/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1248/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1249/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1250/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1251/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1252/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1253/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1254
1255-- Dump completed on 2020-10-19 19:31:41
1256