saas_stkf_v1.sql 60 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Database: saas_stkf_v1
  4. # ************************************************************
  5. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  6. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  7. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  8. /*!40101 SET NAMES utf8 */;
  9. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  10. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  11. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  12. # Dump of table app_error_logs
  13. # ------------------------------------------------------------
  14. DROP TABLE IF EXISTS `app_error_logs`;
  15. CREATE TABLE `app_error_logs` (
  16. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  17. `app_name` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'app 名字',
  18. `request_uri` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '请求uri',
  19. `content` text CHARACTER SET utf8 NOT NULL COMMENT '日志内容',
  20. `ip` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',
  21. `ua` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ua信息',
  22. `cookies` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'cookie信息。如果有的话',
  23. `created_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '插入时间',
  24. PRIMARY KEY (`id`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='app错误日表';
  26. # Dump of table chat_history
  27. # ------------------------------------------------------------
  28. DROP TABLE IF EXISTS `chat_history`;
  29. CREATE TABLE `chat_history` (
  30. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  31. `cmd` varchar(20) NOT NULL COMMENT '指令',
  32. `f_name` varchar(32) NOT NULL DEFAULT '0' COMMENT '发送方昵称',
  33. `f_code` varchar(32) NOT NULL DEFAULT '' COMMENT '发送方code',
  34. `f_avatar` varchar(250) NOT NULL DEFAULT '' COMMENT '发送方头像',
  35. `to_name` varchar(32) NOT NULL DEFAULT '' COMMENT '接收方昵称',
  36. `to_code` varchar(32) NOT NULL DEFAULT '' COMMENT '接收方code',
  37. `to_avatar` varchar(250) NOT NULL DEFAULT '' COMMENT '接收方头像',
  38. `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '发送内容',
  39. `source` tinyint(3) NOT NULL DEFAULT '1' COMMENT '来源 1:访客 2:客服 3:系统',
  40. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  41. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  42. PRIMARY KEY (`id`)
  43. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  44. LOCK TABLES `chat_history` WRITE;
  45. /*!40000 ALTER TABLE `chat_history` DISABLE KEYS */;
  46. INSERT INTO `chat_history` (`id`, `cmd`, `f_name`, `f_code`, `f_avatar`, `to_name`, `to_code`, `to_avatar`, `content`, `source`, `updated_time`, `created_time`)
  47. VALUES
  48. (145,'chat','游客_1476','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556113951','','','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556113951','dff',1,'2019-04-24 21:52:36','2019-04-24 21:52:36'),
  49. (146,'chat','游客_8242','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556114858','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556114859','你好呀',1,'2019-04-24 22:07:48','2019-04-24 22:07:48'),
  50. (147,'chat','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556114870','游客_8242','0ad865ca4bdef9cbbddbf0b708c3bfda','','我很好',2,'2019-04-24 22:07:57','2019-04-24 22:07:57'),
  51. (148,'chat','游客_6199','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115149','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115150','客服在吗?',1,'2019-04-24 22:12:53','2019-04-24 22:12:53'),
  52. (149,'chat','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115147','游客_6199','0ad865ca4bdef9cbbddbf0b708c3bfda','','在的,你想咋地',2,'2019-04-24 22:13:00','2019-04-24 22:13:00'),
  53. (150,'chat','游客_4490','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115421','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115422','来了',1,'2019-04-24 22:17:05','2019-04-24 22:17:05'),
  54. (151,'chat','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115147','游客_6199','0ad865ca4bdef9cbbddbf0b708c3bfda','','你怎么又来了',2,'2019-04-24 22:17:12','2019-04-24 22:17:12'),
  55. (152,'chat','游客_4490','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115421','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115422','我也不想来了',1,'2019-04-24 22:17:22','2019-04-24 22:17:22'),
  56. (153,'chat','客服郭大爷','90f6d632','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115147','游客_6199','0ad865ca4bdef9cbbddbf0b708c3bfda','','那就886',2,'2019-04-24 22:17:28','2019-04-24 22:17:28');
  57. /*!40000 ALTER TABLE `chat_history` ENABLE KEYS */;
  58. UNLOCK TABLES;
  59. # Dump of table guest
  60. # ------------------------------------------------------------
  61. DROP TABLE IF EXISTS `guest`;
  62. CREATE TABLE `guest` (
  63. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  64. `f_name` varchar(32) NOT NULL DEFAULT '0' COMMENT '发送方昵称',
  65. `f_code` varchar(32) NOT NULL DEFAULT '' COMMENT '发送方code',
  66. `f_avatar` varchar(250) NOT NULL DEFAULT '' COMMENT '发送方头像',
  67. `f_clientid` varchar(32) NOT NULL DEFAULT '' COMMENT 'ws服务分配的客户端id',
  68. `kf_code` varchar(32) NOT NULL DEFAULT '' COMMENT '服务的客服sn',
  69. `online_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '在线状态 1:在线 0:不在线',
  70. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  71. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  72. PRIMARY KEY (`id`),
  73. UNIQUE KEY `uk_f_code` (`f_code`)
  74. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务过的客户或者来到我们页面的客户';
  75. LOCK TABLES `guest` WRITE;
  76. /*!40000 ALTER TABLE `guest` DISABLE KEYS */;
  77. INSERT INTO `guest` (`id`, `f_name`, `f_code`, `f_avatar`, `f_clientid`, `kf_code`, `online_status`, `updated_time`, `created_time`)
  78. VALUES
  79. (1,'访客','0ad865ca4bdef9cbbddbf0b708c3bfda','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556113782','7f0000010fa200000017','90f6d632',0,'2019-04-25 00:07:17','2019-04-24 21:49:42'),
  80. (2,'访客','eb6be14ec4e483ce7b4d8ce57fc2bbf3','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556116035','7f0000010fa100000002','',0,'2019-04-24 22:27:24','2019-04-24 22:27:15');
  81. /*!40000 ALTER TABLE `guest` ENABLE KEYS */;
  82. UNLOCK TABLES;
  83. # Dump of table guest_queue
  84. # ------------------------------------------------------------
  85. DROP TABLE IF EXISTS `guest_queue`;
  86. CREATE TABLE `guest_queue` (
  87. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  88. `f_name` varchar(32) NOT NULL DEFAULT '0' COMMENT '发送方昵称',
  89. `f_code` varchar(32) NOT NULL DEFAULT '' COMMENT '发送方code',
  90. `f_avatar` varchar(250) NOT NULL DEFAULT '' COMMENT '发送方头像',
  91. `f_clientid` varchar(32) NOT NULL DEFAULT '' COMMENT 'ws服务分配的客户端id',
  92. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  93. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  94. PRIMARY KEY (`id`),
  95. UNIQUE KEY `uk_merchant_id` (`f_code`),
  96. KEY `idx_f_client_id` (`f_clientid`)
  97. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户待服务';
  98. # Dump of table guest_service_log
  99. # ------------------------------------------------------------
  100. DROP TABLE IF EXISTS `guest_service_log`;
  101. CREATE TABLE `guest_service_log` (
  102. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  103. `guest_code` varchar(32) NOT NULL DEFAULT '' COMMENT '游客code',
  104. `guest_name` varchar(32) NOT NULL COMMENT '游客昵称',
  105. `guest_avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '游客头像',
  106. `guest_client_id` varchar(64) NOT NULL DEFAULT '' COMMENT '游客客服系统分配的客户端id',
  107. `guest_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '游客的ip',
  108. `kf_code` varchar(32) NOT NULL DEFAULT '' COMMENT '客服code',
  109. `begin_time` datetime DEFAULT NULL COMMENT '服务开始时间',
  110. `end_time` datetime DEFAULT NULL COMMENT '服务结束时间',
  111. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  112. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  113. PRIMARY KEY (`id`),
  114. KEY `idx_created_time` (`created_time`)
  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务客户历史表';
  116. LOCK TABLES `guest_service_log` WRITE;
  117. /*!40000 ALTER TABLE `guest_service_log` DISABLE KEYS */;
  118. INSERT INTO `guest_service_log` (`id`, `guest_code`, `guest_name`, `guest_avatar`, `guest_client_id`, `guest_ip`, `kf_code`, `begin_time`, `end_time`, `updated_time`, `created_time`)
  119. VALUES
  120. (129,'0ad865ca4bdef9cbbddbf0b708c3bfda','游客_8242','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556114858','7f0000010fa000000001','192.168.22.1','90f6d632','2019-04-24 22:07:39','2019-04-24 22:08:04','2019-04-24 22:08:04','2019-04-24 22:07:39'),
  121. (130,'0ad865ca4bdef9cbbddbf0b708c3bfda','游客_6199','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115149','7f0000010fa100000001','192.168.22.1','90f6d632','2019-04-24 22:12:30','2019-04-24 22:13:08','2019-04-24 22:13:08','2019-04-24 22:12:30'),
  122. (131,'0ad865ca4bdef9cbbddbf0b708c3bfda','游客_4490','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115421','7f0000010fa000000003','192.168.22.1','90f6d632','2019-04-24 22:17:02','2019-04-24 22:17:36','2019-04-24 22:17:36','2019-04-24 22:17:02'),
  123. (132,'0ad865ca4bdef9cbbddbf0b708c3bfda','游客_7287','http://v1.stkf.test/static/images/kf_default_avatar?ver=1556115461','7f0000010fa000000004','192.168.22.1','90f6d632','2019-04-24 22:17:42','2019-04-24 22:17:44','2019-04-24 22:17:44','2019-04-24 22:17:42');
  124. /*!40000 ALTER TABLE `guest_service_log` ENABLE KEYS */;
  125. UNLOCK TABLES;
  126. # Dump of table guest_servicing
  127. # ------------------------------------------------------------
  128. DROP TABLE IF EXISTS `guest_servicing`;
  129. CREATE TABLE `guest_servicing` (
  130. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  131. `guest_code` varchar(32) NOT NULL DEFAULT '' COMMENT '游客code',
  132. `guest_name` varchar(32) NOT NULL COMMENT '游客昵称',
  133. `guest_ip` varchar(20) NOT NULL COMMENT '游客ip',
  134. `guest_avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '游客头像',
  135. `guest_client_id` varchar(64) NOT NULL DEFAULT '' COMMENT '游客客服系统分配的客户端id',
  136. `kf_code` varchar(32) NOT NULL DEFAULT '' COMMENT '客服code',
  137. `service_log_id` int(11) NOT NULL DEFAULT '0' COMMENT '服务日志id',
  138. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  139. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  140. PRIMARY KEY (`id`),
  141. UNIQUE KEY `uk_merchant_guest_code` (`guest_code`),
  142. KEY `idx_kf_code` (`kf_code`)
  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='正在服务的客户';
  144. # Dump of table guest_trace
  145. # ------------------------------------------------------------
  146. DROP TABLE IF EXISTS `guest_trace`;
  147. CREATE TABLE `guest_trace` (
  148. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  149. `cmd` varchar(20) NOT NULL DEFAULT '' COMMENT '动作',
  150. `f_code` varchar(64) NOT NULL DEFAULT '' COMMENT '游客的uuid',
  151. `f_clientid` varchar(32) NOT NULL DEFAULT '' COMMENT '游客ws的clientid',
  152. `ua` varchar(500) NOT NULL DEFAULT '' COMMENT '浏览器UA',
  153. `ip` varchar(32) NOT NULL DEFAULT '' COMMENT '游客ip',
  154. `referer` varchar(1500) NOT NULL DEFAULT '' COMMENT '游客referer',
  155. `talk_url` varchar(500) NOT NULL DEFAULT '' COMMENT '浏览页面',
  156. `source` varchar(100) NOT NULL DEFAULT '' COMMENT '来源域名',
  157. `client_browser` varchar(50) NOT NULL DEFAULT '' COMMENT '浏览器',
  158. `client_browser_version` varchar(40) NOT NULL DEFAULT '' COMMENT '浏览器版本号',
  159. `client_os` varchar(20) NOT NULL DEFAULT '' COMMENT '客户端操作系统',
  160. `client_os_version` varchar(40) NOT NULL DEFAULT '' COMMENT '操作系统版本号',
  161. `client_device` varchar(20) NOT NULL DEFAULT '' COMMENT '客户端设备',
  162. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  163. PRIMARY KEY (`id`),
  164. KEY `idx_created_time` (`created_time`)
  165. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  166. LOCK TABLES `guest_trace` WRITE;
  167. /*!40000 ALTER TABLE `guest_trace` DISABLE KEYS */;
  168. INSERT INTO `guest_trace` (`id`, `cmd`, `f_code`, `f_clientid`, `ua`, `ip`, `referer`, `talk_url`, `source`, `client_browser`, `client_browser_version`, `client_os`, `client_os_version`, `client_device`, `created_time`)
  169. VALUES
  170. (2337,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:46:59'),
  171. (2338,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:49:42'),
  172. (2339,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:51:43'),
  173. (2340,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:52:31'),
  174. (2341,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:54:31'),
  175. (2342,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:54:36'),
  176. (2343,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 21:56:57'),
  177. (2344,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:01:06'),
  178. (2345,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:06:16'),
  179. (2346,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:07:09'),
  180. (2347,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:07:15'),
  181. (2348,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:07:39'),
  182. (2349,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:08:04'),
  183. (2350,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:10:17'),
  184. (2351,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:12:29'),
  185. (2352,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:13:14'),
  186. (2353,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:17:02'),
  187. (2354,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:17:42'),
  188. (2355,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:17:44'),
  189. (2356,'guest_in','eb6be14ec4e483ce7b4d8ce57fc2bbf3','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:66.0) Gecko/20100101 Firefox/66.0','192.168.22.1','http://v1.stkf.test/user/login','http://v1.stkf.test/','v1.stkf.test','Firefox','66.0','OS X','10.13','pc','2019-04-24 22:27:15'),
  190. (2357,'guest_in','eb6be14ec4e483ce7b4d8ce57fc2bbf3','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:66.0) Gecko/20100101 Firefox/66.0','192.168.22.1','http://v1.stkf.test/user/login','http://v1.stkf.test/','v1.stkf.test','Firefox','66.0','OS X','10.13','pc','2019-04-24 22:27:16'),
  191. (2358,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:29:43'),
  192. (2359,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:30:59'),
  193. (2360,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:02'),
  194. (2361,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:03'),
  195. (2362,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:06'),
  196. (2363,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:08'),
  197. (2364,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:11'),
  198. (2365,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:20'),
  199. (2366,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:30'),
  200. (2367,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:44'),
  201. (2368,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:51'),
  202. (2369,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:54'),
  203. (2370,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:31:58'),
  204. (2371,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:32:54'),
  205. (2372,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:33:03'),
  206. (2373,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:36:37'),
  207. (2374,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:39:37'),
  208. (2375,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:39:57'),
  209. (2376,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:40:17'),
  210. (2377,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:41:23'),
  211. (2378,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:41:29'),
  212. (2379,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:41:45'),
  213. (2380,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:42:10'),
  214. (2381,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:44:19'),
  215. (2382,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:44:35'),
  216. (2383,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:44:48'),
  217. (2384,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:44:51'),
  218. (2385,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:44:58'),
  219. (2386,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:52:35'),
  220. (2387,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:52:35'),
  221. (2388,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:53:49'),
  222. (2389,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:55:00'),
  223. (2390,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:55:09'),
  224. (2391,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:56:14'),
  225. (2392,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 22:56:24'),
  226. (2393,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:29'),
  227. (2394,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:30'),
  228. (2395,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:37'),
  229. (2396,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:38'),
  230. (2397,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:38'),
  231. (2398,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:40'),
  232. (2399,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:05:51'),
  233. (2400,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:06:32'),
  234. (2401,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:08:23'),
  235. (2402,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:11:48'),
  236. (2403,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:11:49'),
  237. (2404,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:13:25'),
  238. (2405,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:13:47'),
  239. (2406,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:14:41'),
  240. (2407,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:14:54'),
  241. (2408,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:15:07'),
  242. (2409,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:16:43'),
  243. (2410,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:21:30'),
  244. (2411,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:21:47'),
  245. (2412,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:26:50'),
  246. (2413,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:27:04'),
  247. (2414,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:27:25'),
  248. (2415,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:28:07'),
  249. (2416,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:29:01'),
  250. (2417,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:29:34'),
  251. (2418,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:30:04'),
  252. (2419,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:30:20'),
  253. (2420,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:30:47'),
  254. (2421,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:32:06'),
  255. (2422,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:32:17'),
  256. (2423,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:12'),
  257. (2424,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:14'),
  258. (2425,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:15'),
  259. (2426,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:15'),
  260. (2427,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:28'),
  261. (2428,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:28'),
  262. (2429,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:28'),
  263. (2430,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:34:28'),
  264. (2431,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:35:06'),
  265. (2432,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:35:24'),
  266. (2433,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:37:25'),
  267. (2434,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:37:34'),
  268. (2435,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:38:10'),
  269. (2436,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:38:18'),
  270. (2437,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:38:45'),
  271. (2438,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:39:15'),
  272. (2439,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:39:17'),
  273. (2440,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:39:25'),
  274. (2441,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:39:50'),
  275. (2442,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:40:28'),
  276. (2443,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:40:43'),
  277. (2444,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:41:17'),
  278. (2445,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:41:44'),
  279. (2446,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:41:44'),
  280. (2447,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:43:42'),
  281. (2448,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:44:37'),
  282. (2449,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:52:45'),
  283. (2450,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:52:47'),
  284. (2451,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:52:52'),
  285. (2452,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:53:14'),
  286. (2453,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-24 23:53:41'),
  287. (2454,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-25 00:04:10'),
  288. (2455,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-25 00:04:48'),
  289. (2456,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-25 00:05:02'),
  290. (2457,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-25 00:06:21'),
  291. (2458,'guest_in','0ad865ca4bdef9cbbddbf0b708c3bfda','','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','192.168.22.1','http://v1.stkf.test/merchant/stat/browser','http://v1.stkf.test/','v1.stkf.test','Chrome','73.0.3683.103','OS X','10.13.4','pc','2019-04-25 00:07:11');
  292. /*!40000 ALTER TABLE `guest_trace` ENABLE KEYS */;
  293. UNLOCK TABLES;
  294. # Dump of table merchant
  295. # ------------------------------------------------------------
  296. DROP TABLE IF EXISTS `merchant`;
  297. CREATE TABLE `merchant` (
  298. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  299. `login_name` varchar(30) NOT NULL DEFAULT '' COMMENT '登录用户名',
  300. `login_pwd` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  301. `login_salt` varchar(32) NOT NULL DEFAULT '' COMMENT '随机加密字符串',
  302. `sn` varchar(10) NOT NULL DEFAULT '' COMMENT '会员唯一编号',
  303. `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 1:有效 0:无效',
  304. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  305. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  306. PRIMARY KEY (`id`),
  307. UNIQUE KEY `uk_sn` (`sn`),
  308. KEY `uk_login_name` (`login_name`)
  309. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户表';
  310. LOCK TABLES `merchant` WRITE;
  311. /*!40000 ALTER TABLE `merchant` DISABLE KEYS */;
  312. INSERT INTO `merchant` (`id`, `login_name`, `login_pwd`, `login_salt`, `sn`, `status`, `updated_time`, `created_time`)
  313. VALUES
  314. (1,'54php.cn','88a1b06cdacc34317141ff427f24a4d0','zj6v@vgRE2sdqdQl','556d8bf3',1,'2019-04-24 15:49:59','2019-04-10 22:29:50');
  315. /*!40000 ALTER TABLE `merchant` ENABLE KEYS */;
  316. UNLOCK TABLES;
  317. # Dump of table merchant_staff
  318. # ------------------------------------------------------------
  319. DROP TABLE IF EXISTS `merchant_staff`;
  320. CREATE TABLE `merchant_staff` (
  321. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  322. `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '昵称',
  323. `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '标识',
  324. `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  325. `login_name` varchar(20) NOT NULL DEFAULT '' COMMENT '登录用户名',
  326. `login_pwd` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  327. `login_salt` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码随机码',
  328. `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态',
  329. `online_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '在线状态',
  330. `last_active_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后活跃时间',
  331. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  332. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
  333. PRIMARY KEY (`id`),
  334. UNIQUE KEY `uk_merchant_id_login_name` (`login_name`),
  335. KEY `uk_sn` (`sn`)
  336. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商服员工客服';
  337. LOCK TABLES `merchant_staff` WRITE;
  338. /*!40000 ALTER TABLE `merchant_staff` DISABLE KEYS */;
  339. INSERT INTO `merchant_staff` (`id`, `nickname`, `sn`, `avatar`, `login_name`, `login_pwd`, `login_salt`, `status`, `online_status`, `last_active_time`, `updated_time`, `created_time`)
  340. VALUES
  341. (3,'客服郭大爷','90f6d632','kf_default_avatar','54php.cn','65c7c4859c1e29190c752b31732100ce','Yis7@8i@NRK2EgKM',1,0,'2019-04-24 22:36:29','2019-04-24 22:36:29','2019-04-24 16:51:31');
  342. /*!40000 ALTER TABLE `merchant_staff` ENABLE KEYS */;
  343. UNLOCK TABLES;
  344. # Dump of table stat_daily_access_source
  345. # ------------------------------------------------------------
  346. DROP TABLE IF EXISTS `stat_daily_access_source`;
  347. CREATE TABLE `stat_daily_access_source` (
  348. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  349. `date` date NOT NULL COMMENT '日期',
  350. `source` varchar(50) NOT NULL COMMENT '来源',
  351. `total_number` int(11) NOT NULL DEFAULT '0' COMMENT '来源总次数',
  352. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
  353. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  354. PRIMARY KEY (`id`),
  355. UNIQUE KEY `uk_date_source` (`date`,`source`)
  356. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户访问来源日统计';
  357. LOCK TABLES `stat_daily_access_source` WRITE;
  358. /*!40000 ALTER TABLE `stat_daily_access_source` DISABLE KEYS */;
  359. INSERT INTO `stat_daily_access_source` (`id`, `date`, `source`, `total_number`, `updated_time`, `created_time`)
  360. VALUES
  361. (100,sysdate(),'v1.stkf.test',21,'2019-04-24 22:27:18','2019-04-24 22:26:23');
  362. /*!40000 ALTER TABLE `stat_daily_access_source` ENABLE KEYS */;
  363. UNLOCK TABLES;
  364. # Dump of table stat_daily_browser
  365. # ------------------------------------------------------------
  366. DROP TABLE IF EXISTS `stat_daily_browser`;
  367. CREATE TABLE `stat_daily_browser` (
  368. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  369. `date` date NOT NULL COMMENT '日期',
  370. `client_browser` varchar(50) NOT NULL DEFAULT '' COMMENT '浏览器名称',
  371. `total_number` int(11) NOT NULL DEFAULT '0' COMMENT '总次数',
  372. `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
  373. `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
  374. PRIMARY KEY (`id`),
  375. UNIQUE KEY `uk_date_browser` (`date`,`client_browser`)
  376. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户浏览器日统计';
  377. LOCK TABLES `stat_daily_browser` WRITE;
  378. /*!40000 ALTER TABLE `stat_daily_browser` DISABLE KEYS */;
  379. INSERT INTO `stat_daily_browser` (`id`, `date`, `client_browser`, `total_number`, `updated_time`, `created_time`)
  380. VALUES
  381. (72,sysdate(),'Chrome',19,'2019-04-24 22:27:18','2019-04-24 22:26:23'),
  382. (73,sysdate(),'Firefox',2,'2019-04-24 22:27:18','2019-04-24 22:27:18');
  383. /*!40000 ALTER TABLE `stat_daily_browser` ENABLE KEYS */;
  384. UNLOCK TABLES;
  385. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  386. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  387. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  388. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  389. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  390. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;