cash-register_blank.sql

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.28 : Database - cash-register
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cash-register` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `cash-register`;

/*Table structure for table `authorization_code` */

DROP TABLE IF EXISTS `authorization_code`;

CREATE TABLE `authorization_code` (
  `code` varchar(128) NOT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已使用，0：未使用，1：已使用',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='密钥表';

/*Data for the table `authorization_code` */

insert  into `authorization_code`(`code`,`is_used`,`gmt_update`,`gmt_create`) values ('010bae12866eccec28a6d1ba3413f8733e26bf5434ef995b1bc9f3a5b2b03d93c51b883f20f3e7444821a35bdd9ff04ddc3bb5d18e94f053caa05163496b5f1f',1,'2018-05-20 17:13:24','2018-05-20 17:07:13'),('0116ad8a29c0a8bbb953c90064da82c041b1ff139ffeba41beb6821482ee2d93ecf7cc19e6363787c14e82bc58642656da6a27dd3e2b466d29321f776e16b444',1,'2018-05-20 17:13:40','2018-05-20 17:07:13'),('0138d63bf5106b4e6d7b788da8497079e6f33993ee52658e37eae15084a9e273f339e71968c58a4ca4868f4d597fea58d11590a68894346f09d1e9932fb27cc7',0,'2018-05-20 17:13:41','2018-05-20 17:07:12'),('021c775e55d5077de05ae01214f3d478340563d87a5e90d19e157534c76f9df8d87043b9da62f97d7e88a9d60c64df254e00c474ea42a369b41f69703110734d',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('0254bbb2825e92cbcc47182c79d6699ed3a049ade601e96d019f79b23ba26082deee8de595eebd4a914da4a30c0ff01a69c49acf94b20e96a5b908a801ea6986',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('02a485b29f1bd4d452c0dc719d637f640f0d911d81ff58d6fb18ff2288338430db4c6526e7057697504c4740b0449a8be975a051fe9ef30834f05d61e8472eda',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('030b60bbe0473d8ff09b83c56764202e0a5d19c158c0864e7c158bb16dd5cb7530883b8d7ec40fe5f8d0ec096105df878f45fc1c189060f71dd5575be4fd69fb',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('034340c5ff640af4315169cbd667e3147de2316a8b89dbb7e770dd300b59cdfa1b71d62113afb012a561226bc82e49c4dfcafad32971e3f879d538c24877c140',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('03a34af3dba073b434f653d5e3e67127d61f3d6bc13b7d850bbaae2b2771fe3eecfec98083218a7e6ef46d6f849b18ccf65feff85d46b9ea45b59cdafd8d3b2e',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('03fcb7ac16cbb24ff0378792057ebaf0b8834f9518a61b4690d5169781c0d242a0a84635b806985b6415f7bfd129e0153e31599c14cbf3f32c0edc14db2e4eba',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('04175a5e36c5f8f75d57d53b5ffe573388db806edf5971236a750eee75beebd436fef445718b1e59ead1926c298b0643f1cec7701899821556202887e9bc0fce',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('05ab61ab165cc2ef3d0c0731a1ff211de522bf8b44e1489dedbdb7d53435a8dbfc14fb6752d59ef92d90f55d792f3e5e625b0e0e861b623ba1318ba7e319d0d5',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('0657e24229f15bbbd0cad02874f30d2112711003e8f9dbfdca9538e841524f20d9eb8871b7e5660eba32242fc23a51838e7d2b517579044bad2da1ad71fb9227',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('06afca3fd7850c9b3c9b17ce1f4af2a3a99f540fe3251d2f3c6b113cc0efa3ac75782136f5afa42bf2070d8e54e3c2d19812b32527008b67dafca1cc2de3b5f4',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('07764d0fcadad6db19c0f6447364feacd7767d9989c4676458dd68eb5221c39ce9261cf6af2391475739693e89e06688b1ffe7d103e665c45eaa8ebe6838b2fd',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('08a867777baa7c54e247ab4bfe6b0532ad8c56395f063fbfbc9aba8c088bfb4de1db9e310b927ca7c3938fa596f4ce3a3c7ad8ca0e406ec04e1e9496c7b430db',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('0a806a65a9b39ca6ee1e779ad4be48dcfd42678ea9f71e954fafc9c99a518aff667d9b201b39a15adfc760d2cf18eb2de6126e9844737159b24128b5235572c9',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('0b9725c04ad15de32f03914df12c374a40b7303d23a06b896d1168775a04ce16766454e29e33b5092074aa1538eaad7d84300f753ac47406a21935d1fa93dda3',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('0b9e46a15b3dca784748542f25d555d0e53759c1bd5009ecb28d76673d2a1ce792928628936a4f49a754786bce004f641df91590ec67a89a1a4d11d9d5d7657d',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('0be9b30d6e4cc65afd11bf627ae4ccf005df7749c23edbb6a3062a44365208d2caac047dbc45aa3b9adf5aebbf9b90949a8179a9ff459237328fb61edeab6e26',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('0bee91ec03f31745006e590353466ea8a953e2c307da4cd2376f1aef348a2f2b2397cc7e9d797c71f8db04ff50588b06a7707ebfc8502ef88469153d6518ea84',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('0c9b8864ea1c828026366f058c8a84d6236ebc9a520d521017ea3b781a9ba2d55b29a92d8adef48cd63ca8cf9efb4b484ec586b708e13010f9cd682f3dac8682',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('0cd7c9a55b8aaf6b09a203b6ece5254d244ff3d37255cecb319ae35994bdf0409daf25f67300e9e402968226fbd42c571ed8bda47bbe7f3f6c401a5a79609771',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('0d8b56cfe076db176567992fdf60f36a52fdfc2c5da82678077636d919f0f16d25977f0bb025cc5aefd5b4a77db2bd573b2902238b94d63202760cb1cd7345bb',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('0da17ee6f5e5b0a2e6d4c2caea152a1db57aee68f7f88ea14c78a0defb33730a0fc37a9d92f2bcce7f148e5bc7f9a05fc5101c9c8b213546137f1d831078dd2d',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('0e1abff4961f39b12564d00857aed2b7389d201a1fa5b75e4ebc43cb712fef55b6439bf92f60c89b081b63955e64065c28fa6757e76852bdee3e65a13d6181ed',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('0f2b6820c1380776f072ac416cb62b02a6dfd947cdea092c1bf3e9fae4e2f040d4c0677ae61cbe20df3d1ef0e71b6723fee74e882b553547679a2fb71ff2864c',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('0f6b0bf03028caea71c376f9e98fd7a1c1c01f43e457578216737c34a5cad460726fc65a2caa41289bef47e5599143c88e34e62e554bfae8d9029dacb74e3402',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('0f736fae82e9bb3499a3fed83a99f1baf7c10cbfc67bebc9a26687d999ca481a144deba4d5db41eb8a6a064731bec8c72835bd1b4f62fbd0426d4f514beaab29',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('0f7a4db53a677410de3729acfa908587cb1af8433fa424c97626fbc8bed73b679739a4a79ae81a096ac3621bac429234923e5cded1fab626fc76fe4090cf349f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('104bb3749e8c0631a9530025cedb624a750db8baed0597a854bc71b5be6a95a15b2dbe20233d144c00a3de2c00f7837aedf1478344810d19e9f87561501b5a24',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('10af825fa64bc9b5ec124a64778678efb0331dcd460a9afc807a648cdf4439019c3524aa08ef9885e01780ff0e2421baa2ae36420e5bfe6a609ab0dedfa16986',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('10fc1d5ed7352f06357f7c04d2eed1f75d9d7269bb6b97895bae99564f2e612094282c1515589224fdc653d6ec13bd02aee96e3973f949ab24b2012b378bcc64',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('121018a29a1c7b181fdbfba9a9e31554872fe6f72b5c333b719b0c9c1be1699ccac224a6ec99c31aa4a23c3792f66338c6eceab25d351ff8882d89d23bbba479',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('12a68033cf4238fb5998b3c341e92847eb6c139ae2dc0c0577f3ee6700d42a8aa0fe062112d3391fea09c4969f99514be84e0d441ccf408395da44a0895f1334',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('1506dd77f3b328182b35e115716dedf158cc84f1740f6bcc63c2c0d8c8695827020f38e2abac3d0d71e7410fb05d79e8fdd657974136f33719a2c1ba840b1907',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('170c0e44437596a53059a5194fa7ebc2a51de10815fd565beefa1a0de18777a944276a4cc24f454862c8ab49cd3b909bd5db05b160cbfabd4ef50ac8f16f46d3',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('170f869d00519ff127c1eef6205cf19235b5d3840148800c6ab198db2cebb576b1835f3fc9169668765b3c98438f37c2c731f1c7272ce5ce53c7e54b25d2a439',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('17882411b71b0c7dd6e1f708518ce3f9d6eb0ab8a1e65f3b712b402d1c551b97f0a328609a45eeede28a5011caeca2f359a14f9e01797923c7d37f6fea476977',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('17b71484caa284243053c09c65b4642d773db8a7ec756ebd39e0f9370ea278d02d3f1770ecdadb6722510e77cbe9ca5b75bcaddeccd748034855a427cb822468',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('1897904fd9d8b5bf3cebdc2fdca8022fa10984d58a09c2ce5500b8ba45cbc780a1f2d15cb79576c7279e1256e981c1199ed01a94b50aa0c9fb2889ff1f296171',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('190e79e6e6dd516c1d6600cefb697b5354792036b3de0e5f6342f2b66876d754c4594a08dbe8f17335900a39743e908929b4f6a7f975453ac453dec2c979fb5f',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('19288f265ab4787f63560430bebe8b1abbcdad0eccec26889daef15d4f6dbce9184e25e8d638936caf1bf70c5f062010a6cfdf81141902f929cf860b30c92cfe',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('196a5f039bcaa892dadbecd351c6605a3b7436f7ac4adfe9b73faa5707d2eba65a75c15ded8eadd796d024f65b7401b2d805aa1f6815ab08f1c669e41d17b1ee',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('19a4c4dae4fd9ef5017450cac5d072e3484e330a1e6beebb8e5b140f411926fce625f0e080c4150506b32360a3f3ff0cd255aae5214b8adbd7baf6764d9747f7',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('1ad79da7376298b186ffab7e9221bdf862d62a59e96f1eca292c57797e92c6449654e4fb76c7d12f3ef7037c044b50e2d7051fbdda457c123b48c650021cc4fe',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('1ad7d03c98ee233967f6c4d0efffaeba9a76233f2b11d922a2851bd7cb9e98384ab89bd664d4c8b29fe42a0baec6aac7cd79cd01dfa92068e27a13234657ca65',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('1b1cb7e1d971556dda7bc8ae72a1d52c88f496f9eadbc7a859bc7ecbb381dae8f05bde68eb1d0ba2e8302692436d51698b6bf731bed7402eb152dfb894a0db3f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('1bea87f24fae4f1ba9aeca86d6ea4f8d234c99d410911daca21193126f9cc82cd0a8eb5ecfabe86284ca0a1fbe6e6511b74f7c8d4c0e61666f692629638370e6',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('1c714b6c76c55c8618578634a55c41023111d7d70b3cf3a1b4db095bc28ae35dc49f1a504f3cef5f95c92467d82d56054572e95420d2850108439be6baafdaf2',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('1cd2ba3b40e4f64ab78080ce8570c6e7803c7ee1fa51794437d214938d150f8b683f1e6a972892488eacc9ae35a145bded4e602cdaedd303b8477fa7f3a47e96',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('1df3c0becf45cc712ada25aced8433cd0ef2b812223574b3f36ea4e90880007ac74bb381cf08d67e51bd4eb5831aa6fbe78ea64e0fa481887c77a7c98045328f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('1f66391d2bf8e0079494cd411fccf1a81c48244567b84c72a2936f6afb3f0dde5ddfd3b20c0d8af8b824e9667d35cab610bc68ff6f9b8424ad230f81f5e1292b',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('2040ec45b8edf49eca303f8715b4a619740ee9578429b01b73e85bd9cb9050a922e40655eff66a421957260858d034dafaa0516eb04cf59fd51e8ffec457530d',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('2073ad61cafdb2fe2716f0b27e5bbcf0272e0cbf22a3c73faeeeae3dec10cdaf47aceec4b4bb951705ea81e2a64a89ce296623fdd31dc0fd8f2537740f447cea',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('210617e40fed9301d7216e77041d8d53beef3842168007e4a5dab47bd97dc2ec50a03eefc8882c87c680bfc15f17c157c4e07b0426afd8b6c0ef449072c57a2a',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('216f1cf9fc6fe7034ff1cf25bf9182a17a5506ac69e2cd1f488898d8963f0e66834b08f2d01caa05ac377b989e543a4940a740b2c90b78bc3d3b1aabead1438a',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('21b55011e22c4c309153084206fa1ff26f77bd1c297b96f9272fe9fd1bfa1239e6634691156366eb60baf7e21c44ea62abcf2dc91191afe259fe5a85356bc6a1',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('21c90ed258fd2128749cd0021efc99f27f8e7529d88720f9fee125bda19e48d1d5659327ba3b692b0169dfe15294ea2a4366b4ef31e4930bf902a80ed991f231',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('22730c49466d881733ff89decb207bcf85ebe649227e47dc8ce63c744572585a7c2f67894ec6253b7a9a5588067ff807c430a34329bb9a67ffbedd3e9b93e008',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('24ccb3eba84dd466ab6aabf59caf75120bfcde42ca957e8a40f8d272a5544d97f09c2efecc8220b2051f1150c3cf9773a4d12faec960f26123240d95fe6dcf18',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('251775509612b9d676268e92c9e016ea8aafe96de72e5d96304d8367c78fe6bea82962d40cbcf06a42fed9219a362e374491aaa3ca51573230598c8e484d245d',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('25cb814910e0112077bfcea8752fa35c3559093d57e7e8e0fe3302351f4c3460c41ba62281dc6e75273c5b703ecb0cf589251c213f7d7a8f85b22124e8090631',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('25eafa26b752906a9992eb139e82a709ffdc47b0adefd028e77346e8c3b68b93e3a593fb78be4878dd098b24321bffd96bcfbc7df081ede957654433005c6f9e',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('25f3b409d259293e11f6672395a8ae90eff12d2dec78c4f89d9f70ad4defef715447d2d3e4ef502f5bc1c354f83e286a371a395374f578bdbcfa7bd0bff49a93',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('2600e057e0ee6f8dad157971b7b4b4f7674458838d114da58c0aea33b111ad668537ff380fc5eafbc9a484ba82328fe395980aa7b22c07fb0e19524d7108f3fb',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('2609c2cad111c5eb61652cf2a166d08653a692e8dd3c566139c96ffe46afcb68078f394013d7f30adb98ab5f45b3b1e423788cabae87f9eb3554546dce2414ec',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('260bd1cba2705673168175f636f370abc446b2880d5ab963d30936757e204d33067247a76e59d11df45b5e95301d50f12dace1be534be139b69632c8364e505f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('267722af3ae4144f4576ace90b2c77f1788b43f008935661efcbba95ea8fb62d63cf3cc1a700bf174e70a438e20005bb53cc4f22679f83ed22e7a58c8f5e0c8c',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('2a724fbb24ee6c08fabe6b9fab5d734b863854db64f7ca8368ff66ac471e0958cd0c1a92d8978527ddac52638b720c59cd1a5ed97fe999800c1b4d7352c7d931',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('2a9cde5c000721f8c73bb5d3dc379432877000ad86c603f284d80246e2b738c1fcb6d0850ef9047d3e0b178b66318f124594f88a34a0ad8f8c901e8e8467243c',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('2ac0542fc7d6bba2dc58798aa490385c3342daa326872e67fbc7dcda7f23ff5a859acf3fc674179906aceb8ff152329ce3753d7a9d15d855297d4037838a3010',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('2ac4b205fa27167f6ae753b7f44bde16451e3c45d36c6626f6f0fad42ed97185339118463741b1466e6f26446aa8d3a2f94c0a1da1289c74446dce49e4d32d9f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('2b8dab15b1a0cfb20327f8bf339a0ec9e6a9cdd09452c9a1544c59d399b274e61e2cb8b23c25c2360929c734df7ff55f7aaaba1d35f7c4dc064c38f2f20deb62',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('2c3d3a7d03682e8d0827d8279cfe9910918e25073ac46022c0e85a6d55f6eda42d59f2ff468aa1a6353bd3c9de63fc414c4f91369cf6f4b408376a5cd5c50272',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('2ce293bafd64f714a0a8e185051d2838b4ea8aff925742d6075a41635d094cb90c7cd92ad692ed9bd8048242d1db410529a4e51d93e910679f5be6fafe7aba6f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('2cffb7e2fa1aa5caaefc69099d19b94258aec8e8c0f4f8bef442f62d65a4474f35f188a98e76fea5ec39a750e8d4109fdb7aeb7d5dbe24289b409335065f14de',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('2d0afc5e6d869e02ceb9376154bf23211fdbb1bf3aeaf55022d1c2ce6f9c2eaa26943f758c87ca2ea13b828695fd2889afe195a2ef6bf3a8306a8684742e63c6',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('2e6c7815ab7dde3e38f5fb06f12a4feeee39a21d350d3a341442bd4095953ef4c0abe228184d98a58697f018ad94e05c68841751a5e6fad153ba3b1c20b4bfda',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('2f827f6e0dac58635e82fcca1bf37f1c36f987533edbbafcb4978f9576ec5082731581636a0b7953edecb9e18646f77e97f505333b234c39509e27252acd8ae5',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('2ff7cb0aabc1061b6f1ebc54e20128645723b4b3d2c428f41bd0779d845dd236d0c2e4232ecba843aae6d20c81a707f75967e1b223c085892c7f8880a9b25806',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('3083560b9ba56c4b517976892ca7c933d5e24fd263f0582f0517ea72546cdf64bc82b9c080d41643b099a38f0235be69ea7bee3d5c0389ebd2231c56a3675893',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('314e44d047b4cc083bfd1da0aac61a7858b487a63bd37252b5f8a32a6d0dac20ee19ad5ae610d97a630bd7ca1423a6ace6644842a7dc356e05bc9873c98041ac',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('31f51ff6a60738f88064daf1542875a816ceb0d984fff4a9403ca82caf9bb664fb3ebf35875141df8028e393eaf3eefefeda9fc7ee9a598d69a38857482cd4ea',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('322a147c0d9cdc7aed2bd06ebf8f0a1d959667eb23c366cdc9da733e2b34987cc91e56ac78f4963547314f2571c9712b80990fbf250d971b7f7c31ee25991812',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('32cd997134ded4db062b93197cf8f4e7b5ac3bd76d021f134ff4f5b9282c76f6ba67979d6225de39cc1d2fb16a0677e2046809d2dff4e11b1e53287e12cd7682',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('32eff9f818a52980a6c144d5a64a2ad52c8de21f58fe3759c407388b5cdcb0f7a7a3dcf524ddfb9853c60427b4c0d92df45eacb5bf3fcb0f5927e85476e75167',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('32f4cac7587545fe479739d6e6d8bc18d72bc466948fa54b863590ed72d7a7ccf44aefc39e6f34bc355133780c0aa1812010b3b5d6bdd780b5d7d8af8b6ef7f3',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('33aa1c8487f9379c7c141c26eaba5188391c6613276c33cd9e25953e1c8d355415ff6e3c0e147bd6502f1d464c0644ce9010a27248eb93c8aec601a4f55278b6',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('33f93322b3f2b9099bbd1b44fb72c5fc53a770824d6578f2d47794ab2fc6e94e4acefb02bf64cba687f4be01aa76c60a1002c54db9a8fb648559507aac7e51c0',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('343c52524e95f99cd0d76cc64e5bbc917e96172c8b5b3d190ed49f9e1834d1e7d4032a0f25cbef1e4ab98f42e20f1383dfd9369d5a4abb235ef735c278603d1c',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('34519a1a4954f125e91229fe2a33623fc4fb8d9e494ceaec39750c9f324657ad8abdc3c45031c1eaa8e417f51cbb3ce00fe9680a8e140eebe33f178d8622650e',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('34b6d79e63b4782864cffa540ffcc99255a6a26d94530ace4a5ecac12d3111f55e78d94ba3b6ac409f9c647f222427120476c9e84fd45c5e686c912536472578',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('353e8b2dc0e44cec2cdfcf45c578728fc5c02ca0395d3c5c1e0873a668999fa2be398773657ad567a60da1ca22ce75792840c06b0f6502e7f256ac5c7cc968b8',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('36220ea66f405b4343fa78a735d6bd3e7fb19bb23104abe70cf3c14bc334974992108928fc5074281a20f8f5a3840095a2baea3d60ada9023f711b3b2d050ca3',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('36c52eedfceb0a3b88e52c4d46a4c1955a13d77c1cb5a0072ec29efca2205fefd87c358b0bc2e0839541c8cf07d97354c4a2ce2ae3a8cd551fcdee9e0d98300b',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('37b414c923e4220ba7a86fe34f360ddf95bde24b98e1ab5793e5a2ff306d5711f4da9769d57c26028f6687f78a1c8a72c5105d8aa142af4645fd45a4d167a55a',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('37c4113134ab18e44f92acac120579d54ddc428f8a8a0b5975b99258901682a210b590a9a4e50ecc9acc34c1d441132bbacc1c9a0cccc41263beddd4e47f528e',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('384eef43e0021d882b35df7266f666c1cec08627354f9681411490de60577cade56fbf12ba1ec8704e4eb1c135d90b6df60e67b9fd8986c17ce7341bab04f946',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('384efd99dfacb4972011291b389070ca60450304d006acd4f0b3b4ea16063aa518c2a9a22e1a915df28028b5a80f80138b703926e9ff94c6180b45e635f4cd66',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('387e502943eae31aa4d12b809471b0d09c153273756122e401caedbc938b0d086176d6aa169f618f7fb4dc0a83bcc67531a923e6bc203dd5e0677035d5cd08e2',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('392b512a7c21e6d082cbf62bf1b9d06d46d8e3f6e5e4f51735fe8193e254cbd8cd9ee0cd21b82959de0ea5e1c46a9b4b93077dea7497519efad8ca287f0eac84',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('3947040d573273a52fcc16399a908979fa8ff8d34f430926b50c396a800f19609c1d31dad1956a7657d0158e23e865a04fb1a24c2e1203ff8114cf55d4c63bd6',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3a650cb6b29952a60ff9857ace3eec28ad78b48f531c4c32b231117e4cb07e698c84770dbecda8b413d12653d44e2f9028e44e38a32fa362058d58fbaef461b7',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3b4459b77863fd546aabcb3b59e5d4ec8a21667db6db6228b6c5459a34c91dd49dfdb56beea0dd960182dca51046fa7d0dc1a81361b06c1e416e0cf0a4b93774',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('3b9ca1d2d96359aa34e513cb3ef973c8ee818a76b797b9f6919f00110229974ab1b4419f37b74a78f1d2dcbc0ffc0bf2239fb285e9ddd5501311f31819eded6c',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('3cc0aafaf1d51bd8f657fed472dd17d32abb79660627174669d2a6c29f9340f7720d826a8ecbed6361013ad2fb8b2270b072404335e157ede348a0fc5c5a1126',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3d693dace4d0e7e94fe0f2f6920c75dff005f818bdde4f511b4171dcd430e5819f8955f5d4e6c84186c322e1e220edf824930cb04873593c0e3db0e7e2a9c39b',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('3e4ab2faa89fea34c094c74e0f944ed87dde543a8093e5bf188bfb498bfd74516d68f89e42b46398983bcdf7b8a8c0d8e3a62db8ded92bc91660aec06c8b9806',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3f17f1dd0f7a3d7373a936b78bd9d453169568bb026299f6f6d8598e52c326977dccf676793da1f372c7b9adb4cf03730e8f33ebf1d1465b2cb5894e6e8ff4e8',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3fa35a49cfd2e8f9e0ff1f79d0c5100e075e1640db5437af5a22d8f89161a3a40240c58f7997fe79e15c0a55bff319a0a72338e86187cc58e32ff7ff6d101594',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('3fc36e2f7f6a8de3f6f22ef6eb9ca59e38c3e65085a648fc040da18b2dd3274887fd932dfdc8c6d1d651fc987a35a5b3b3e79928d289fd71cb01940c6d54dc22',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('410edf01b4e17db9c76666e31428719543ea9d3d9582db14721630f7bcd8cb2290eaee25a092dcbab0761b9c9e4d5eb0645eec54e5d2c404a057df2625ea7cff',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('4129b17336c93174d10d50f8bef1145bf915bed7db60910c855524318d443dbfe13fb960fabc35d4c275851cd01de40dbb7c8fead7dc709267a5a5b119ae4d02',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('4151a412c5630aa79692569d4dadb82d0e0f67ad17f459541ee5ff1ff6243699a9338ee7653be791d475325a1c3bc5a87a4747da9ea54b5ee975f8b2b7c5b626',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('4166ed759aba08d1ef236e038dd9d6a6689b7cf36a707968beb55cff2fa7efe695e759039fc784991c40d766ef3f6ca9de2babfff905b2b91aae5f5a1f6c4808',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('41d744a95cf648fbd9d97ec58eebcd30d61ad396c139d583e28d9e616d05d2d6676ca8b24aaf5be3f2726d421eb12d205d14d7bc9f8a7c259626e77aeff1df5d',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('41dd00bba6de8fdc612bfb2947d595549762ab27cfdb440aec8e501d415e356c65099e553305865b158115c82af0c26717bcd783bdb4d27a6cfea0c8f4b50176',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('42935a728d0e5b63d5e5d93e8997713ae07746782e576854de41ca734b4931935172568a34cfa08f45e596ea591a6bf9cf853e438f5b49e00b6d861cff608597',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('42bafc398b9cc6a8c557f86d13d5681a708bfa2a2f53a9658c80478318f6080adb786db27cf5c834e01f52e250dbad338db66892d8377eac8a01abb200c0b00f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('42bff3421a2985625e17a2e5620d8f818b1d89ed56eca3c9ddcb48e49ec2394c8aca74b2826f69d08fe2a75faa5fda820fefef61f64ac47a08d4e1f3b73a749e',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('43fedc63b3eed91362925b2aec66b05cd2c7bb3b1a3cd6315660277703a97071ece9c7d6c7efd00392fa99af3b7c3343b7349f11fe1e9812f8ce3409a604f146',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('44b4c87cee92b5ec0d30048a94a09039921bd61440237904d879a52102b99f4c5dd5507a7fc6a28b206b94812f94b21c6750cf5d57838b48ffa5bdf35dec17c3',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('44cfada209005d5f0d4eb8320dcc00d21a35a9f171abba426f7708734a4a4736f7cfd8659462628e2ad33b0e348d4e4051ffc0471c3c0d01fc765d83a218fe39',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('44eae5de8533c2d13a79c2f921d3761d1b726c1642c654d4d3effb688c6e47ef27d162c8f5a5e908167b7981c06ea24555e73c68d349398bf6c5b10f9a4057f5',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('456d47ddbb8f29a5d127241a1bc37c865c5ccfca5a5549c1ad086c35f5f113c5d195fa4b25372df005bafcb7f378f2ab33e8cc3af5d832b655255bb34d9aa46b',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('4573cca2fb51dc95d5ac5e34a7051520aa8f14365499f09d9ec2355903455db1f866d87966abf5f74c2473baadb0953b8169f8403e8e24579372b5661900bcbf',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('46659e0a96b9244f667d646fe773bf66bb896b0675cf84eb30b17d91b012182ebbe88ee415d273a04c002d2328ba4b67f0b4807ef3eba2415044b784b2ec51de',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('46f0baa855c3f1c12174e96c1e8e4addbd0ec16f31c55aa8be83ed139774eb8f85e808498ff744f6362e576444a509cd3e52435e3d63b0cb29f000a6cb165872',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('4788480466c72202e93adfb7777f059e94680f9201963135966051b40c771bd5939ecc0f988a05b74fd1f5eac5d2e96533916c709746bb238c0414999b215c47',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('497f0d115d462be36093ed6e2c3cf0e4b99357631e49f78bcca069818eb3ca98e2f16e6b1460eb7674ba23644087e66c726187bb70800e3bb1e4483c4301e697',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('49edb32decdc60e7b940d5ee6dc84c2e3fed85037d457151fc8f5e7fefaec273b147b390514b09ce68e166be0d37850924f604ac565f445048e9ecc0d4a5686e',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('4abd80da459ab873e33c63d145cfc1eaebcf89a96889d97b3da82b39b519323e99051e36db5d3a7c52ed77df5825dacc82d2321148839b57c1802a4c43137a9d',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('4adbbcdee45ca40de3cc1be5432d497ba2aa7cb67032facd8ab312a6728f5cd94f13d36e9e4ba05bab344d7b285939b87bf51bca5d722369ee84b86634e64c09',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('4b2488935c1d0a83046911e56b47f7fc629e44ef43afbba60cbb4f7b6cbd6c8719dcea0b2e206aaca4a04f31c668318ef88eb21b32d6acb6e85bea187a0ab9e1',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('4b6acc86887e5cedac6d169c927fd684ff3215f642e1c478fe15c9124f3c25c3a2958543f258368420907bc90adaffeb6a694cc3e044d9cf12119ae9e856946f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('4ba24a636e2305612739a189249f6cb672f095efe5d0cada0253f942cd0977eef945c24fa432c20b985de16f2315539015596cef9ce3f1ba8904e6361c6ff669',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('4bbfa4679b452c807103d37600d16e39415c4ada53f07507623dac56ba8acba871b6f0e33700ce3d94c7416cebef5709cf573d8b88ecb013aaca4f434d04480d',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('4d9c3ae20c400cba7aac3882414876dec3a05309a59a3638d28cace847cef022414529bb36a69203b57c4b57bf45ff4b07c668de9e9de0b20f3981e8625474e6',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('4e17d61ddd7e9056a3f08207cc83ecf7a7b3ab7b3daa481b5171aa87090a3fcf71d3d4f9ad6bac5b39c62afb580d83b00455f7f6d66426c9cb1e78735a813b63',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('4e3df0a9a1ae81a56f57ddeea92aa912ec0ff29fc2dbc892cc75766d34d44dfbf82333fb267a3b2fa15c70b9dcda41c211b5037ba51bfda711262989f353bc6d',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('4ec3a37ac12f5ef57f1f84d3577c3db88f9b96498ba4fca2baad896c40b31f5c3e66d30bbc34a7ce328c3d90c6e9e241ba83cff4aba593e20c418d6290f42565',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('4f01d68b9f65beeea3bc7a0973c4e968eebd690b46714bc57769c830a27ce22b930947b49e75e8929ca209058f80bdf8e49df76dff01637af586e39f086c5bbd',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('4f2d2844c3ac33836fa8105ad20c816669015fa7f8c3577e2e83ef7d75ef14cb1e12ad1a4942828a43c9ee126fdfc6a1736bb54fe5ca0e7ad6facef5f9214f65',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('4f52f981287f4820ae2231720f250e85c4600cd44de1d6a0c32e198769c440576db50a920d9ab392f9403e008550c6c445d5128f2aec33a54c1648cf137ae393',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('4f5537e019b3d1b168a3595a12bc4a64e71763d96e653d1ec8642f80b20925adf3777b366081dc18db95d409115ff45eecf1c6ceaaa1768670c7c60b0fe4df59',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('4f63aceb6f4575421f3146ebbba3bef7fb490cd59050a95787484f03942fa3c41dfddac8761985da0021734d7671689f656ded547ab6df7292daa67e6db8487b',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('4fad81a5adfa1ccc85d0db7190ab991b8eea3153a519a5f163bfae79f4b21a193d1a3c2d423c604aa864d37516dd6bce47a23bf791fa74c576e2a96d5751b2ad',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('5098a148f4982cb5e8ac9bb305f16250fb7b89fdbfec629580b0c2e0f09e026bf3865d89ffbc00ad5924c85ceeaebfee94ff761aa137433f325adc35e7f84c5a',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('50b90b797c7420e39d38b961bbaebdc19ea99abcfcf95a2c39319fc22afeb0e642d6d78682340f56ce0ed749daec4d18a375f46c84eaf1a20f642b4c118b9629',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('50c8512302c8d907a5cdd7659b3aaf4a010d3eaae45a4bedc8a20c3567f26e513e925c59f064af929e2dca0382701cf003f8d53735db2373f1a533c246728a73',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('5265b1f589705dc7117f4d8832dedee8a9329ab6dd35eae2714c67d9b6244246feb476beaee4295fd268752bf661da3c8bf3280e8974f77fb9854e72fa27fbdf',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('526e6d04b223e8789a77a8c956c3996d7799c3c126cd163f642f85d6d45f9a44b6efa7f56e6547c4faabe610526f10339e6580cf799b84b3f3dfb1af6ac1c4db',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('5350736e20f99ed94d7b33757e1091f8f3a28e25b8941150e0739e0c4309138c0d147fdd1100cdb2f41eae46f773cbd315581a857d526477dd994379fb857912',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('5417a6cd2b06630f00576328844cdd578cda33d04fcc41e3bfe606ee5bcabd574ce932f1c5eec7dec5f665e5f5ff908f0051f061a8cbb10124ad3fddd7d7c0e2',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('54d85d01da81bf3c3121a84d3a07225abc2f79dded4a3b790c98174a174689940a6538ac12ccfc40f64c0d9bf72fcfbf11bb91c19d8fad3dc9bdf8219d6bbbfa',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('551ede16d0b8505b55a84fe5811a6f72816eb4fc9c47a2026dd6ddeb1980683958a05cb49fb4802e95a6797908788f05dc13d3c81645f4d6baccecd2113fb866',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('56df51aef3009f5d4916cd2876bf92938b369b513295c020f7863b00e615ab9898c8627783fe61805b5f06154eb7cf48b7da013c8a23df8848252b815b34a23c',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('573c708e68496cb9b05eb3477496918d23c9002946893d98de7b75048fa94a5f61d99a7f28db885cc8596eb214e837043a686b6c2c4944c0a856f510af7d4691',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('57f3f56959db39d54569b768d6bb3147cf7a9aa44df02bd470c8d822bb6b42439fa8e746ccd6d5f83142d88d3f1a34a7c3c186e9e88144ca44d818161afe91e1',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('5928136ce1f1eee4fc8032d07a5924692997858924f88162fd3eff59f36a15f7227c8f0a8897c25acb9d56683705e097e3142605f894e472737f5c65a3b9d1b3',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('599b745089299eab6f271f75ede4732e3616cde39008abc21dd04fb11dac492c323e45d5e18455cd8d1f1d5473e5816b6a2aa4e8337435c7257e441f4aa7530f',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('59c5049170208a1e28a54db38f63968c99dd3f07426d9cd096a7997cff7b2af5b67ac25401b3a3c6ae1e653775f09d0a5db0816040ee04beca6255adf078ce54',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('5ab607994109da567559cb189b7d79c538a5b6613d1e4ebd7ab116ad34102035a0b3a33fd41b638a98b52866a65e4fc0d1420e51c41e7e21713265d9a8d545ac',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('5c59d54a19c48d144d1caaaa53f3476da000841a7f216c8438e57df3976c0d1485a32dbfe2a20e6926273a59438d59ab3fcfdf9d296aefe598dd1e41baf03a11',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('5c9b75689e27fc2f7fde95de7ec7e84f78a129755c8fef63bfa551f6532bc9c898e566e93ef56f6db2efb915e488e511e8772aa5e72c019c33f087706d54fad6',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('5ca865dc86d453a901cf07b262258713ad3667028991834c1c2a7b2391b6ba0c4f87450546e4c5225033502240a42bf8e28c3fb59ac113078bfed644a7a4c75b',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('5cbfe7e2466bcad9ec9d96296a132a2184281eae0127fb50960ba4e6113d5848db4740667d628fe093e8f2f95c0f31ed6f07c9950f065db0078c34b8f79649a4',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('5d154d30875bd905ea09e4d246251ca6c04421fe1df9ce08b3e567acaa7d6e9f49887808e718836a9accb4e1b3b7931a2555a947cbf5bd724fda4c638c8a4ab0',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('5d6110feb1af6f1c58beef25663fa60be2928a415509cd5cb7685529d6b257ae42fd148180f4d444bafcf71382c68ece12f40d05661d32428545577253b10621',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('5d71a25f27c1e91860292076335ffa1ddfc2a6de91cf8332a4da7fd37dbb7f74599d78263135d540ff2eaa71458a3b98e1fb03b56519840818d660bb98bdc758',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('5e3b08f804a631d0117d611d1df948e22db3e5ffca39815b51c69d057cdd48f25292eb8707b00cf4d0332bd59aebeeccbc4f3f1c3cea98737c5d0caecd24851e',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('5f0d3800e2413e5770e364edbf2e300fb83b9c52aa013baa7cc8e4fe992128903bc6f831ccde5ffa4517bdd032e106d63d5b2da0b7a569a46f3aa48888f558bc',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('5f94df2ca17b88d49a4f7fc7d04b08a6214c0c5dced2acc22a3e6c07423926d2784a4338f8043c20f04fdab91c381ee2d23c32ea202010b977a89c6c2d3d6da7',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('5fa4a578b51936959d5c8f18a6bf595d1ff7119b53ff18244b061bd5b4acd2e4e8733a82d9ba1b040959a682432c5481c346285476cef423c151401f9fb83a0a',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('60255b016cc833c610904aa10a2b9c4cf0a079cdd2388686bce2ebff7e21c7d5cf2369078788bbb939b63d300f25463cc4bd90c53df0d374d2df7f07a6504072',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('6088ef75f1c3453d2573335d34f560a4f6c822645072b3c53ee6a724baaa5b2a64e29906a42cf0251d9f373c0ac64b7ed203744f02fc41d280afecc1345c83eb',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('60ab97236352fb7c6ddbddc54dcf4d98d38751bb88e9b987aed7a5419b5b115f80df5ca2a01d12af27a8625322b59c636b8d993081e51f351162b0a8865c23f0',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('60ccf2902052b1ea7658f6490732bfbbe084dca2ee80186000c92cd6df52ab02adc22283ff81f1a9fdb80a271f6ba605911a34e09d4516351737aacfd9ffe1d2',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('61916bc1b8ae13787091d19b77d6babb4962fe8cca085a9e117536620ed167d9a1c2e384709ee68bbeb9e8674fa102891d787ced9f70debee5bd6ae67480bcb4',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('62153e79a0b0d079cb5bc79b05d0cf6c29f6d3adcc2119d980cb6f481780585320220783f811e9367f6f16f52a9184877443bdf620aef8f3699734008e5b6a8c',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('625d344712baf3610691b3da66f7b4cfd052411f08a3235f54740f5533ea21810b018a579e9375cc02d3f25980b8779c80c25b3fb37ce5c4eb23ce34446895a3',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('631d54355403f1461d9423cb2aaead39141be7a6e1fc6a91f06f4d6ec824a231b4755d6ef184a66d1a39fbb7761967d9f41eb149b05671e4d7385126a8e7b70e',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('634b7911cd4e42618311f4ac0d596d9198d98953b40d0ae8e1e91597e359518aae1c1bb85a2c13b824e5cd8c3578708a77261c4a928b394df407c2460b8a9b0c',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('645d5ad924b41437af509c3d349793f537498da52faee598d07cdb4351c62e26d2ed14c2f5183180d7e485aea12f1f147d816b5305caba5fdb15054b715e6808',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('64e5c6434d9a9078eb4a58bf8021839a92a28fe66b59601b0516ddfcf7bbb2102dbebb007be457e2314f4b5ac23ee95e97b4a197c901dc460836b85ca8901378',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('6528f6fc2f44248aada14787dd9a9c93d719d20fa6bc38b561d67016ff775612459da519cff444d1a51eadf775f18387a8b7d34914f4b13eb7dce7d001e10ac6',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('6529fdb44d623d3014323ac7070ed2e37f897f9ce4188fbea61c23e906e8e4575ece88b0d2040d04465286394425524fbef0e6f55765b87b9fe74bcf526cbf45',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('65ebfc6a63515fc7929472e698dcc33aea976298b8e56531cbd2a231f66807232f21bea0546ffc14e2752a1347a85abddc6c8c2deaaa3b9c3e4a8c024d41ae03',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('6622e3bf68b52379068a2f7932b288c457574b61805bd1ff00ba6013ba95cc96156cf8243b846ee5fe2048324e3ab3b03971af76865c4e087cffdd045b0744c0',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('66262959d98f213cd06a6683b43d0985db0de923100e01b393379c13822c1b10c184c8c1894522b791faeaa2f12561db90466837f63bd05b8e40424658c73049',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('66559f420abc04a484591110fa58fd6ce4298924354813c7f10576114c7a5202345e7911311a8b7bb550261e9114f27340e62e96a21857cc1275780de4f18a3c',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('67c41eb40664ec94b0074c224c3be885c2b9e10d207d3c39d30c2d2c29e0b5c68ca4ee4e4ee74b7b7b958ba1fb3b489726803844b7947550705522c2c2af9dbb',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('68744b5e9ca316fac1449e2788ca7014e0b49f89892a7759d22a9806096a4ae97966fc4fc254952f11a7e4e9741d9a625da5a9157682c8b03b82846159ca1870',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('6910c31c4d1490247ded7a3d10268881041db90123f80af8cd1def6d47baa798bfab4a179540229d17160dd5b5388ed48c5c3fc4a97bcfe2894b636ecc153602',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('691d69e51a54b979219188e36a3f381aeeb0e53d003a2db653d8fcaaf8386695502ad9f1190d71ef633dadb7f1181d710d7ac05f5f6949f19d68526ae93515aa',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('696768e87c17fdda3783eb43ae886373b26fd0c41b61c4e2e4d202f042f6f9ec1a297c33d4bf01ee5c2547b68a1dde07907abe84217ac7c63613567efb972ff3',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('6984aa7de95723bde7f0061824a301a0a44b14e3ad3d5fbe7ef5815c16f39576532e6be8afb8e108a14904351f69ea37937c926eea6eb81f63b5a73cd3c51e9a',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('698eda3f654336e2f7d4220da145d5bf5ad485f662985f33fdf497a0243f6b1f432e21dead3f88865ebde075e1c5df98e8c7cea92cd9121c05fb5f347358aa59',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('69ad9c8a55aaba3692ed12258e891fbe98757fa84671647790dd4060a73c9fc75665ba0b125862bb92fb6c3936da821311028bea922fcbf3bab269a261cdce60',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('69cabf6482fa7306c035689c8c1db8f003b54e416b38daf8777e12d6a5de2bf5bd4c46026e416ab0392b184548e2164ff7c54af4b43e70849d08e2298e5c193e',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6a68b1f97ec18feeb0c4b81e5395642e303799556a20be32c4d4fce77dfd370725ac5771a581b088c31e8bb3e3cf22d83b8ed727430411b486db52f5f353f9f2',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('6a9bfcf36d0a82576f284ff5167182563f408d0417264bf00520cbc76bb1e26ef4d663defdfb5b5ea9a2acba66315c9eb2b92b18d489f1ba02c498f72e8f29a5',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('6ab63f237017bb82f1332cfe259046f142a26b09ce9d8e9e5328cd3227891221b7e3163832a29c0669965ee95ff8be313684a9d1c842465f1e4648d9380f4c60',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('6ae5fd6d4814127269dc1edfe46cf927837cb9e70c0c3323909d523f87de1378e5d1ce9d82fc2090af7ffd52ea765cd463587679a3a88b473589ddb7f963daad',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6b17dd2526320b1ad1255c5bd986fa76b6805777bae6c107f28866852df7ebbcb71892a30c7323aefc8a14f549cea90c6c2149a4d41b3396742dfbf0db2218b3',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('6b84a4782f10e174ea7d530b1a27ab8546843aa882a1aade92691867b583f34d809958637da2eb790797a1fa0f46b49854079ab9bfe73fff9460a8c3101ea15b',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('6be3f256c11ccf199726e9aa87fdc06a8c4a05a331788e8ec04e933508d36443b91a4f091201ca5115cb0141cf7136e1a82089653f5693aa2ef67f308d29fa23',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6c034952667670134ccda1a8d275ef49216f412f86a6da1af6121ba866fb368593f8318baf08885c33ebfb604137dcb94a4e4858d3dc635061f03f591993c717',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6c411f39f535d762e3ebb6c17da24cf815170e33047753f3653563ccf140f2f6bd6d6e7702318357be9615629a998732bd3967ec288900fdc4dd170ee5b6c759',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6c60961ffa0c0aa5ade925a853cca7fc35094c65812391b23e493da3f56b4fa5bbe112130b2cedc3328efb8dbbe2dc117ff4e8cbbef7ab26ea16e812f1259d63',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('6dfad0802a90dfde42e0c9918f44c1aef706fcb7630920855aed23ee5bdf47dbd777866f25f2a19c930784f4ff894b02b5c778747c67b9a292db6aa1f9c2e881',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('6eda875b71e5efd361cf1a1f4095c28b2aa0d0bb47d34bf1be63282a316e7a19ea1b64ee11a992a5abc70e3ecedeaadbcfc9ca07b0ed6d2db3c6f6fc6ea2ddc4',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('6f9f891b2a8979f76469bac66868d200ab4b882a775ae8556021f66c08b198fd2c125f29803f303db51ca1bdf6fec5ee10e8c566fcd1fe18b85208ba4c6674f1',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('702400e3fc44bf9e42e492e388519d943bd1c831701d9461f32ba5214a7daee0c4b08c99fe02ad4b6c0be94732ee2935893a6993a5f417e36f58c8e67ee7889d',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('70937526311b8bc196d6903276a2b2b6bb065282aecafcfaddd873019c04385f66b50be1eb6af82e44c5ec5cfd5ea6f02160376c93b9433750b3dc1acfda1dcd',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('7096b99fa7f2d37a81c3b8499e8464da5e4b3b801fc54741c0b7496589ec625e95d341df8fdb9bca63e9302e32079be5aeeec24589cd45f1e84c20e5f5bfb343',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('712139788ae6652d17b389459295df5fd953b2d7aa165351128658102503ac61beaa14f2b19e2e7aacff7c8160c2df367935b7f4aa0caee0a7945279350a789c',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('71809db00b489575005bdf941b8000993620d9a80d62b2bd9e5e1792def44491c1ceeaea53a9d18b3e84f1e1bdf6a007bd3b0cbd4604d30f9dc4abc631900030',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('71e4da36b378a2afc87d61a36bff8fe643c3e4969c2997c240b4704ad18528b63a2cee242100b90b2440e31fcba00af517b3cb035e96e6c528e4532e440cc531',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('726413650f60b4314fc5575d3868621df634d242c069069d1ea2b8c926b34ad9a312b9953cdf85140eca19975c7d0c830be4f005ea10ae9da337ccb604f6b11d',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('736d7da81e46e4e018916c702721744fcf73cdfeb6ac6aa3d2a58e0ab760637c4c2126e2ffad90799663eb9fe4017e855d8a372c84cd63d0ae541e5bddd142a7',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('73d424e2b48e44cbdfa4b1460346038a0e2d8e826b39cc21b73055555e54a9efdf289449a08305578076f9a9a34c447626c10004dbc51c0e8f2403afb2b366da',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('73e73ce72e8c3f50ab4c709c95633b8143a774694593add0641f03018035bb5f5865750d6e3bba6c5a3248f903b64aa15b7bcf34f806cc4a4f9dd1e95f2f49a2',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('74669672dacd98382082e6d7b935b75cfe41b6654a1dac4fad1aab408eb0c466a95979762b1d4bf29629ebe6c0be0ac324e93500653a9bc912e1d2c823c77be6',0,'2018-05-20 17:07:11','2018-05-20 17:07:10'),('749c35561531e35a2821ba66a6c5719cfd21cd5ee23d1d8a39a4cd852642ec822400cb36ef35d36ad674167b23f707861dfbba96ecc6c1984e4f8bc6da7393cb',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('757fa26841d9bc77cb7af4664ff0d557869573662a63a9de844f91fabce731b9355da00608f588aeb99b186719571766eb7f436e96937f7957cfbabb42cbac12',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('75e96caa7cd13fc479603ade5c04895e791c9a71de7aa70f8e75663321b0d9db03afd2d104265635bc35faa82cd3e9af12de499c800b115467d360749cf9c7af',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('7630be2b45b2a74a2479f5941532b0f089b1656672fe44c2fa6238b2f7399e0418486497bd9335ac9af9bfac726b2b51b7d38fa88017ceea293460c776b0e910',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('77c8553de8cd38d341a501b5b1fd9ac20459ffe55ca920053e167f85151d065527d2e979e16039d9ba2dac8a7019cb47b4edb8a89a3d50cbd9570f09bd9f5af5',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('77f51a16b086cd19d1bec8e8d1268c650fe86c8c0372c1972af0f48b791d3db777e7d544a4d5a469c564b1a993e73b92a463b644659cea34b29cc682b5356a9e',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('78170a98b9fafca5ae37f3ee3cae9e22d85cdf0719182a09c78a3cb0bbcd6c48d889b0242aabbb84d7dbcd9536376c2ca24011810972ef295825d892dfdbb09a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('7831b6a6c2f16b00d23b218e14d1edee912eabf75969137f55c0cfed2e15971e2c7e09712a92eb946cf4a7817a944c8ef73a88c6295addfe8dae562390a79c4f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('78cccb2ceae3c64e2ba9003b0ece5073036b8f31a685372761bd465a41af5766f4dce029b47f1e90c5ab0c3549083fa569b920ec375f787715a175319648ec83',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('78e3be0e47bf147caf8e89d59841362157dfb2f59d441d72528c0cfa4b72cdeac8beafeca7a35729cf3b829619103d9109430c308f3ccc85bf00872cf540c30c',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('7906d7805f9fe3fe87c52926c8533b8c21c89308415ae604ca9cb23c9fbaa471ab925745458b78fe729ef8714c22bf40ebe016319e17d5693c6e6736fcec8beb',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('792fee24aad2d2cdb72d4bd9056056baed912a5694b250b3596348b66e13ceee170350a8dfd3abe555db4ab161b73ef5cedcc8a01ad35e2ee8b3c45a85fddb93',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('798eb087a4807dffe63b7b9f18ae17a0b3b3b4270e90fc08e571133433740896e1fc03a5da1b208ffe88895af82ae89d1213a76d5075f97469ead45372403048',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('79c7bfda8fdb710bd8f1ca69ec704f8075584161d9dd5eed39981e234e2da6d9ff33654257427cf86ba001dd974cbb0f5766db640e5329a1eafeaac104f66418',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('7a0366ae0d6d6a0b2bcd6e77654fcefcdde1666555489fb13cc7f0fa6a48a6b2923ac6f40370f920f89b2b3ed6b23c30fd10193daedc685c62b3fd64756bf7f6',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('7a5c34ecd5d94908858fe0dcf79e19077f7e50d9fb4e39faa79dd254d8cb46eed4565459ea241554faca567bc4267fe7dc8fedadf4d4735c408db35af194596f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('7b0330ad3aecc55ae823b47227e4e2f8c4e133c333c5b3da2754aabece12cd167dcf7c815708f0a2cd4e248cb9f599aeddc9f496fa26cc1cf60291aff3cc8883',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('7b73d87e3f16adb4cb6dc6c631367edfe92c4abdf2c57cb9b6a1781cfc7a99ae14cd2d35666ea52df46a48a71d86342bc609c12be3104013677e9babf494be6f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('7b9afef1c7e35315aab05144ec34bc600c77bbcea4465b17f0f7c774ea002bfc9b4f3ee62e70825b07572a5a8e793ee594f8116a44f50692ff2279d773978b8f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('7bdd7f96ac9b2bd808c9fa0fc2c4122b9cbc1d19bdcc45c809ac36dd0db101dcd7db097119bd134aa68aac9a8155aab8d089fcbf3f91f8f80803822289d6fad6',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('7d3353c603dc4dd87491f0bd7c9ac5324a042b3f51e74068044a6175aa2901f28dfd1b490df5ff0fee7115c9a48fe7290253f9a7c3f11507e2c0326f5839d9d3',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('7e6010df6ad3fa77b867b091abecd597284c7625b950a99e0bf44d4ef6a6befcb23eef107486682fd92ffe383b23ea862a38446a767c91f5e3b6339c3504cea9',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('7eccb0aae0a35535016933c87aa0aeb2699d0e82d66eca31aef2a8ad49d6c428b8ac6e700e446d3c4589adaeaa3cd4221cff750801ef9c85558d506d67055028',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('7fea511baf26906e0e6b832458870b0d580c005ce6385659e897a8a01575f3910b4ea13070e0c4c4be8f12cc3ed87f7a495837b798ae568c87bd3e83f725fd7d',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('8072a0a59407461d9619634a7e16ed2984dc7e20aa0973dae68192413482f029a7b00e7e9680f6e53ff85aefc8ea3ab58b669b0b151f1fb87e18d1fa51b682ae',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('80745a2d44556d72b604deebc9e517d898ec53d8eee2d88e4c8e6c1814e6ca8526ff37bda9f935d1d65f471575c2668d34de9409bd9f3780911b82e7923dbc5d',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('8074f58e2d4cf66bdd976e943f1aaa9f19eda49a94c7c0508615d63972dfc3f5ec10bd4c7c3d9455f6dff3683607e8674108bca7252d67b9932bc7c30e401cff',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('807e3ef1e8811b61802ab31e4262d6fd81146a05e7ba8d968324aabea335edc0b86d29dd3fc197fb64f9ce657d19e2676a71361245679fba33adb6fc207abe26',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('80879b0cf7f686b03f6bdd710275a5e3bb30f12b79ed8e84770b7f5f593e37a43ac05b23323b6173664784d8a81e041c15407445af7160491df4eeb7d2fe6e3a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('815d36766451a3f33e5843358adedee33a0c0b9575386a05545d724112cd2097e3a11f7cffc562bfb906c4ef5c3bb060c47f7a2f1237341a1bbef1113af4fa05',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('81f90a333b82ac5d53c88343756496f04e66fd595754a4cba93798f8cf1f9f581056de412b8c6a4aab0c3fd71a26742ef6f56a7f248e8a765144fa4fa04cad1a',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('827607b9f49bd701da60c1ccdbbaff9902cdeb944cd400ab15491d97ade87a407a46f18090933cddbb74a7491a177af9fe2b3c18b290f832fc9ab8bfcca51d29',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('83511959e613a8e7d9615d12b5cfd85a4cbcc049e9f67d6210dfabd27a5c79634b0ec988ab0c27aca03ab77a8faa0717e93162ced6701d46b1d7ecdf5b40b304',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('836c2abd1e1992cc8300145eaf7f5dfd936aa3a46a0d701534be85f3e76e7cddba25436cf3afa6b4c00279f46d47028da85ff9e476d3a12f5db0f0a8fbf9711a',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('83ef7080f8acf6079bad82a6c2287aa58222b15001f0773d12a119ced84f778e35eb29cfbeb076f70e18dc7b101c0f337f6d5114c92948ece0b5858157963ec2',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('84351cdec6f241ee69c36e9a96bab620d53787a565f3d87c97634bc331eab6bd0824a81c0068ec49cdf84e86f74643a41b5d04525bc6ac7987a617f3c7779636',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('85d6bd1506a8bb2e11afdca5118e7078a7a2ee2ee3b5d4c38f691194f4b765d2786d9d55e28a2182a4fba6e154a31c0cfb64aa075a80bd5acce7fde2d54ca0a9',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('87a9b0a9565816d847c41f1f6882570f8717ca835edd4c80d5a8520cbbe52853fc44d9144eaeea7953f60414906179fca574d8352d5d7e2ffa06000bcdd3dd67',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('87bdb53f4ca25083354f45904059811beefbccaf8971278836588acfcfa645be5b4f267737d23888113bc3cd6fa535c26cc94067124b963feeff73f2b6531fa3',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('884f04ff01b9e75112f849c3b9e7085f1ab044adcfdb6345e87fa4acab19fa1672cfcbd992170e7a3d94473674cb7b037a64f4ffabc5912fc6914eaa31bec46c',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('885769ddf10913bf4d7550b40f98d12d0fde2ec3c02f75dbe9def86b1e2e353b97d3e4419dd788f4a57c0ba889b202dbde300e78bd150a36567ef484ad75a989',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('88b261e8450c3422c9a8bcd62190cd2638496140d8291717bf04651818b57317638b25fc032c77f1fff4921d0f51741982b49370f2de69fc3d6cb9ee7db30014',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('89656515addfe3cc2b6f2886348772ab5abe43bd63cef78feb78047e807a4fc4146d5f78c744eef07e75978685b1298d10e8007c9e9a14cf95e6b63cf91dd803',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('8a3872fa1c53d90ad0d626c18f1cf08b283f29635d276fc9e97c32dd8107a70c872ea7988bd92864a579f7d8de25bba939f42bb457bc4ee60a10183d537c44df',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('8a38880be09d5f548e163583886999de27a9c87e73c82c616ccd6f9cf5caa752b70caccb706635d9779196f9469cbdc989bdbae932b9b966fb94bfd307f3366a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8a4a770f8118a8a22d00a56b1f5f7a606142fc05401bfe594764791fd75180524c74e5d895baa8bcdf59d4dd8eaedf07e7a9677d63d23bd5da60d4a331a0216b',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('8a778476248294904467730630c01740c762132bbbc192b64255c6e72e581d8f932ad587edc914baa2ee12f5a1245c68ea42ed832dbfcbb9b888ee86829bb171',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8aa77a33c9bac68d4f40d82f3a03f10df82b87b3ef7b02bbd4aa10620869666bb8c42f1e5f296a6a1b03016476cf958ed4859390a854646e18e67c174425903c',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('8b0f3b2c73d94b8e45638cc083f728aae4b66b567422e1eba6472533bd687dfb9d5a89240f6fee800ac4c28fd9ceaac9c15e4b1ac4c44442b687c4d9a5857c35',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('8b1b959a2026cb35d738e704870ca6d3dbc1d857066fabd8d851f0b54ab9b91b55e5ce8924154ea861b98bfde7cbc3115b659f7a122ba1e6ddfa2a1b91d04fcb',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('8b25bd7d785217b246bf8f521d02bd3acbdb49cdc4e282ea0c39849900c7804a11de90d8f3152877d4de0c6b70c20beccbd2cbe3779e9102b99aa2a4150fe399',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8ba6d920100ed45239ae641a3b813c0ddddb042a492c5078a6e4444345d9c92d73025edad2c981fa6003f13654d7b72b7bcb1a969a573846e5e3a0c507558fc8',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('8c506c99c9b36616abb41c677f27184a80cb55d1e320c3e4b38ebd990a66c2f52ca5267765805358d87f1a0a7afbb9ca955d5b51ba300a0f6f7418562e3517a5',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8cf7bf39798509ed94aa590c8f093462199760c1fa65dc1bfbb56cca7dd8b00e300f493868580decca4f3b177ad6b3bc4ccd39234a155c9633a4cc2372248df0',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8d7520b3b9cc2e07d87fa23d960432e57a3aa45102f38602bf5a79ba8ac01ef566c113be7bce96b392ff3b6eb4d5342d5abf8ba2c48f29be83776850096f8c94',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('8e3e0e2bd354e19ba54f68cdae837bcc8783e8bce17ea308838726b4f868f6fb19af5510725261125d2d007def2c6af5d27ef37a4f5b5ce0eff3b3597f48bb8f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('8e828c3cc1068ab389b0e423e88b6014a54e7795638741687083901b5f89e9eb34d635a041d7406f8de8bd12a5eef3486a7a02d7428d5b55563ed52fbcc374b2',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('8fa1fbf83d296948e9055abce0222d93bc98cca6fb4fe9e137e6b6948a4363fc4390d9329f2013e5118af107f39671bd7eaee38b8e9a8e88aa1355d73619c3b5',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('8fb62d32dac4c124b09d78af9cb291824cbc7e1476abcba0db29baf720698e521cc0ffaf0ae9f51e0b605fec21e0a8ad72b156a5682134263d3c26dab24272a5',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('9084bf3d8e6c93ebfb15fd38b2df039d5a7710c0c7b7cc57fb0641132bc70040a77cca749c6f486391c4f764d729816c84650b5c45af98b961ca793fc2e0788a',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('9103811a2943f4f63571bb715c15a7a89769a2cb608d47db243f730ce1011ddb19e03a068fbfcf541fdf9392e24885214484ba92c83ee82d77b1a4d0591c7c96',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('923314d48c9d8b08978dcd8acaeca00b81e9f36e888c1ea491222b82d9590f9199c20cb459aa83c3b92178bbe9b9e75f4845347a591458319e49b04e945a62f4',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('92bd5519eedc5a84cfe56bc8fb389d5f7ab60d3154dca8553d12ac2e0f10a8a5a4ededece70b492037aace1bcdc081eafccc6921500849b7969aa086276335a5',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('9431897b9b1426121319a51d23ef2266b551812600315ac488f1d819633f2878c4970a915e3912113f99e02004903661e04cc7ce4fc5cf678ffe9b683136d7cf',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('958339c7f677288d6dea215ef13e125049479e0f60caba86a30e016543be9b63590aef2142241022d07b9f4e6325d2bb2798e32b2ef462c3b948ab4969ab390d',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('96f856edd62333032b9ff3ebb299aeb76d8f5ece6674e169bdf3ea5a1c2c6fec15d18004f450c8d63118bb500f3d5f7a96779816ea1f1977ad1681dd1daf9bb5',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('9733e6e16c72cbe7097540f6f4ffe2130577877e73d285b2d3af9e80570ae150ab95481421d7ee3319984f3c84c7892f91270d1b42e615a289802c8300b92182',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('975b0e5579c5e1990bcc302376a6f501e7cbb10afa0e3e607ded671e54ad0cfd632a604cb3a152d791a735d8ec61a7df349d5b860d16239370331f47721f6d8b',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('97979e626f6fe1f009a0a8e0643fe96235e1a0f6ac47f15eb747d1db12378367d789f231388f5d18e54fb8f5fa2d3b27517c2530b4208bbd2950e149278c04a6',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('97af520651e87497a66786a52107f2f005ddca3b8d5763eb15b1158858439fdb6a1808e2de7921b3d8da3ea7ff9cad37b39554b89d762db9082aa800051126e6',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('97b66b3e88786b8fab2582d0e11b94e5f3b7ef522cc08dc9bb2c41573aac9d90aa83b16fa59f274f968620fadab1d6232eb37b7e2e5e0feb0cc104eb1accb09f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('98083333d849af7c7af46ec1f0010390c8650ca6e96fe302fe6261cc0e9eced868b67584ebd1b741e247f972db69c58851cf79b991fe5139efa424efdf13ff27',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('99b5eb6846e4c03165de04aa80ba6a744c596f2c182aecad7eef2db14afb86c4fdfd5a02881c311f60f77abbc8d26daa436e88db74eee8bf09079b127a1c1549',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('99bb2d1da917079ffc3cfbdfb232ac72f6df9d5561385f03277f84ef264049ba63852d1f911693c53e1bc133a5f8630807ef1e136c0390cfa5b78e2dcbf8e81a',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('99c066013f1a99c030d6e7ec7a411c879a121ea9ca5a9071e319f3035f538f1a6a56fab0f4281b2ef1ee70613702a0567f6ef4fdcc5ad20b48daca4e2ea01c15',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('99c3ef7d575a5d4f0c021c7c7d402b7794cbc3e0034472691273ea44bd00e75266c7ad7e9c8f98dd2f766c5fc31cd4e389088b131d0e7586902ac5da453459d1',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('99eec40d04798b23748f26a0bfd2bbf2b506279953ecc2c5b9763e48543e1698040d0210c18ba0c3c6b8de28da8a4130e66ab7199e90e72408d404d2be74dab2',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('9a10313b60ef8cd7dfa3d82a4c4f931297cf63e265d8ed7fbbb55cb04eba0e49c56d3a85017fedcb0caae2bfd2c651a11670ad0930148551180b25b46a0b3fb5',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('9b48f0fc6c082b120c98eaae3c2c0a2a8266cbe745586f2a716c7e8182fcfd50ec1fd33c043de50709ee485f65e1d0caa21ddf8ec0a4ed7b9e500df13e33624a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('9b851dba7d509a709c1ba30ef0a6a14f40b70d7d715cef9088e02712f47183f977cf3c628278910831f9ebda738605fecc5ec9e66aa29972f336a64a2e16bc40',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('9b89ca0346cbed72f863d88601cf86666d58a1f3154b10633feb8ee0ec801bf57a7621ea7009ea7f53563d3bab1056848e10542a351956fec0e85b63fd1ffada',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('9b90b373e60bf7ea82e6caa99633a4692450b88a605a93d5e3d3d6fe6d8b990423e07cbe22812eeca0158e131a024cb8192f48021f230aa7223e0678af22d2bd',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('9cc11c208fd2663bb594c5462c15a169894d08cbaeefd72d3cfd69a2e56c897fb0c9ccb91cdada82d4332d6b46bef610f4306d2e15ed6b2a4d31a4ead2907dc1',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('9cc8ba2866e51b32b59a19e1c0e04eb19d4c4c915e06977890e5fcf63459b917287037f03f5537b2f112a4aa570b4d00ad69df6af3b622ace3d47d56e31cd4ae',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('9ce0f40ad95b0c3f4f854be59c4d083d4e4531eac66eaca0a8b2ef5860ab34308cb4804f550189eb6c664b078e4e5b094f152287032adc5709824a4a9bacd751',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('9d31e0cee0ecb5c961a4b1382e47d8c72c965cddb1100de480444a01270ee40af4d32ae66967f749d64d903b80696e2719126c57064458318ac18eaa4ba6c257',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('9e421e6e54aa43019063ccfe026386551ed84e86fc999987dc77d540d7ba7268f929fde925b2adc2906ed316aeb74c6d2a28ac07475cc0a62356166fee685f6e',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('9ea2a5ce99e34a103a21dd2e8cf14364d16d6c4619a118fbb0c1d2b706d248029282b71bcba6bc320b3aed0457e95b6cb8dda68df6c915a83af54fba4e87851d',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('9f072ee1633977dc76092b6fcbdbb916282e3ec60155fede522f47a2da5c7d1ad6d80050350dd1e25ac5f7a14f3d661d65bb9ea45421a48637e9ebb66a8d37f1',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('9f1ee2d57d82157156d39971fddf0fa35bea906d613e24a66c98a49afc5b788bcf0c72ef9c6d0d30a6fb59e2b7c12794ec99f43fc012ce018987148ab63494ac',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('9feeae33c699dd6d14628487aea2d3bf777bac2c0aa4dfdd3f0e98e216610ece9c1f4b47a87fb2427950973999f5594c6dd3525c5cc6d61135344c74a1c567d8',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('a026225ff783e06ead57353ae245c801f7801dfe14b032f06fa3e9a4df4149d8a849bbbd8812d8d776b3f094050d50f483cc581f41a67dcb34443848038088f1',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('a149833ed5710cefc017aea6ca88558ee16c52d6c91a0623a1fc8dd3b04b1e5e21a2092bef9c3010b46ea5d513cbfc67194ec5e48e498bd84e7f597395468177',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('a1e5c1cb71d119ab18b317fe8637a724aff750ce1ac63f4131d75435ccdb506f42b204cea26876cdf7a891322eea5097f6828a9489df65368a523bab528c3320',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a4a3d0384a4fdd0e2877948ca3a8a0730989bc8d25b9a116d11c463d5b9d053f1d66c774377ba50a1427c592752c7339a7645750c0df0f03ee08acabd5d8a6f0',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a4db9cb57b1d5d2a810f898e5ef88dfccfb7c7616061ce68ce184baa65bd7f5bfc3ab390386dc420f345a727760386e2fdb4b84b40f5278af0aa67b0301142a1',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a55ab8b2c59a2a7a003d8cc866b0a947b4938ef71663363a4b71126739f20b14d3f8f2c83513b8295cbd8ef271926c700fca26b0f6fc3af796e7e2e1fdd51974',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a569f943360bd3d892b81feaea3d495f6bfb9bbafdc3a7b9e2ca4c61f95d5983add97570e565fb84c552538cf2410c4504c4b91476cc90c697b0375e03b562a0',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('a594f76e97e31796dced60790feb87c2762823d54f7deb2f7e119c5a9cb06bbb1e0b607b2fa3ddf85836722a700c5ad07f811c8b1587719c54bf268c5d469127',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('a6fd16124cd680b313990f992de14526f0c8eb68d8dbdc846870cce0a291aa3c9bd1810af23bbb625bf90390f8b7365d6bde6de395c984a7c2cbfd8f86235998',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a73c96c8bede43cea4d027f6454a49cbb4f276825d3c8e8e1a3395b700da24615027354eff710493e0b13207873f4d0eb9fa3dcbae5b7e6e9a6b838e83872988',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('a76054d105410a7b72af6b8422329d0232f3d77e54b7710562b10c5f6290ae13bb45eedbc14496f0d5ba7bf376af97e3d0bd5b826ea524af8313b631c1e74b8f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('a80fae3e5a112c2311115c5895a37fc0aabbcc643798c78ec6d0ef02d0143487d2240ecd7ad9495260c459c698d1af867a061be19fea98d439d3f6d3d79a88ba',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('aa3abb6d0f2d10adea2e508cfd444a19d7ea99234c54b69b87848cb12efffba6ee63237823bb2588e58f824ff2c2afe14ce80831e40fc7f2441cfe7a29663195',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('aa3fe9a6e656d8085cab088a2b97332f1e1cebae0468529816a9c0cecd18ea3ee7cd32e61bb91135abb863fef7427b070459fe6e2c054c1a19193d163be57988',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('aa76647dd1e6db21e202770b6a6764d79e5a636b85784a95796c4675044cc41287d3f3e366f5fa50379c459e6406324a1a18b8023dabef35c32ab1ba6a8418c5',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('aa89c02ba0e01f190ced3ed4da4387182718a6f0af0c7c53169e9a0455660a80de30afde6ffa0e4a785a9d30df67f5351368b1c70ba8e3ec5435183456bd345b',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('ab528053886e109a87075772b3cf7a53d5580b1772c41431157ebe01885e51a8540dc4e50508bfea81678509a24aec540bb4c751509ba76ece91ca2e0098d9c0',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('ab589183625da109da837c41ceb362c4bf7d1cbbc501afeaa4bfe7f26f991f79ce51b9e9a673741b17607c51d5d3d008e38d5fc3bc19658eb4259c3d08f4ea12',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('aba3a3daf685a66e60142535877e125463a03cf3b1ea576c2f90bb0a1b9b393385e94f2875d87d4184b5bdc5a8e0b66b54f4edb26d0fcd6366b8adc2eef9d530',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('acaeb1ddb1472ccd0dcda24163fbaf001d1d08a03ac0c328bf9f4889190110782cdc0870dbe8f3586cfac80e764a07e917850de85bbaa1746d7acd8aae6d4bee',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('ad4bafd7251a1e137ed3c9097ec6802e3d2b633d96e4ef69f23980f93c9b8f33e0ae8f2ee6ccac96ee5fe7e0f5b5e7b76fa71be699fc598b5af1518cd4f1627c',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('ad9a268ebe13e7e22975d3afe8e88e53ac5fa33b1f390498b50ce3d96f2b95f28a407bd854686cfe3178d53bd02a302f3eb52066c642049d2aa96bf6fae2ab5a',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('adb2afb70f3d179ae6f288664dc9028eaadc8adec3f84a7cf0e859d65dc83c90fd80a3e10bd39f5d9b6bd4bdddc0971d96dd98e651ee672a11022373c99dab3c',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('ae832e77023312a33eaac6843039eb2f7b01ad4155d93bd03be7ccaccbae8b2f1b5d6e3897fbe8d5cde9583c48b9fe058eb579568f9ec8a6074beb999e79310b',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('aed5fff018f7c91a1f12904fadc51f5ee3e74ab634b28abda53419ed82c80fdf5de67145b8a0419ffccf9be034a11a9ab19377f0bacb3893eacf41166368f8b7',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('aef618e957e4d00e5ce84d0b998854f3a70794fab79d4bca16e5ec9f8d54e6ecff3842ef2df22d4007066818d02d354e7857126e36c0485ff5683e98c7b16f86',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('b01ebaa72b96431af236e30c23d6c55a634a9b36edb89f768122d52186a1f112c2ae17a863fcc346a56c1ddac56bb6641eabd9d1a8475b68f750713313d4b2ad',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b05524d61c81fd118591e752aca020cc09ef592b1532f27baa2406f595f5a8e2ddf8caa8a4a00f7de2cd6faa00d88a8f47ccff3ac2a328a359b24106868e831a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('b0a5fcb9284959e00bb90d88fdb82ec002ee4dab1073b3a292486bbee7e7ee78c7576b7dbc869c27ed6621bfccdc39688bc3a40599a9f7bf52c547595c4b7382',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b0b187c2dc0dcc51a45d8c8d57c32c3a1aa877d63170ea44c10d7db66067a98b4acb9804d961ea6111302460b6e891a265d3245b037567e19890cae92203ec89',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b0e4295be41d698cce06d2cc665c2699427e3b5d76b513076366b0b8370b7a66425ce5bc37f1a0d830617e4b8f7ca71f75df0d0d16015dedb03b6a76b1b29446',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b124a9190e09955ff55ea066a99c53fc20f47e7e3c219731027e49a4de9270ba641f2e49824464916ca9affeefa8e23c5e820723eda5060ef3b54e9699f799ef',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b15955a7fc774a898e47c3fe8c62d002654eff40562a9e71263e1e6689feae02e2760515703da6d24c572238c45abd3fd9f704f9259603949722591c33b3a835',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('b18275d4154ec49b2adeda740b73a4d4889cd33f2d1d89b3daa6b4bc62c95f67c260e548f9364667fdb13d7b13d0c110f49bd1343cb663d657fa1902be1a333b',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b1c02f2380037349707968e116ebb359d0346b23f0c1e92c860dce00fa0f06fcbbd65776fc84855bdb933fd5f25a96f427746f53d7159dc80459d16f5b4ac1b2',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b2b45545aa2a4bbd1e8f793dd14fd50287607eadb702a15fcefb8afab55d33c1008f5f1e8430440c60b6b4b5b175eadb4eb64153145712fa62deaa2d54e56dac',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('b2cebaf219de7f92b159db9a1b03265a4008b7021c7d183f116719cedb297425f4bb9eb799e3469e3130c13f10a9f3f88d4bb02c25c8e979064fb7514fcc3572',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('b39a8c9387eb6f712d40956ff4e3e067f4eff2d64dd9f91965fb021b0afbf4c146aef680ff7242dc02ff16ece6864f4ce1b294724b7427353ca5e9a8651d3d7c',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('b4016f449f57fb948fa900d23a09d44ccf9a398328f6e9934508ab339c823c0ae57444ab7d9c34ff59e870775952c56eb57533a527857c737073092221035f19',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b53e0b08ac62d855c3569b2726b851b63da730f233eb3746ba342e799502b3d49729c6d22a84109ec36931daa74d368683805cee036f3c2732457295d19c8c98',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('b611da35f1e531d6bffe0ec1d1ac4bf883afe3816f7fd8b4b81a4aefe6561bd098dcfb3709573c570c78e5569c1f53830afb4e71a6895b897069938de6ddaf80',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('b693d22c3ebf30433a2b7ee13ecb6d032fb4fe0b5a344bb9128707765ee5d8793cd90dcf45e5301dbacb94e847ae2bc0042dfaa83fa409bc2dc9a9b705a4d9cc',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('b6f44998bbc6ce8890edf917f825fafc388873718a007c17cd42fd8034ff2f8d9c5c72e8428fa539c2958a075b3aa8958ebada3e7845ee2b31dc27b7ec2bfe61',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b6f91d28bd7f98e171a2bdb22b5b754bc9292d75a76aa0ba0e03ebf9e414678552b5328246d71b9db806b6b4d41a7b328caa935bbc2641486be72ecde5fd443e',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b7ada4ea138af6cf82d5749990c1cb135bf6ba1cb7971b64d68be9a442ca323de5d8dfe8a253088ec7c81ffb888d5019ef24e19a17ce913f3c5dc5a111756cb1',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b7d3af3ed340cb150a1c63825aca6e748375103d52792fe2464ceb4aa2325676e1dc4b21e047ad09a1bfc58f4f10d0b1983c0b9be53a2136af61226478167747',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('b7dbb7e0ec2b14b3da5368bfe60f9fc0a5844c3ac85d8511ecf105f7adabef4201078157fc4161a6a3522759b94c2a99a3dc24ed7f6777f49ad773bb18c933e0',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('b868ffd0cb197079914988e8d216ef8c445bcf9dfc3e3ffda1891534c2ae132d0191fd4d8faff92d3c12e043a4398f98dc89714dabd736fd273446d2af4f3318',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('b88b3320a8a3268db5dc5478964b6563bbe87d45c20a08be43c7d06d0b83364d85856ef36a51ee97d58a53ae4e24c6630a0c7245f23e9e24b438f61d696b45d5',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('b9114221f5bb9a3b671e72b044a3cfa08dd6b65e045861af2316c7da86d0cedf0bc9dc19e18c57bb4512ed2c8df84f258237ece329d55d30dbdad9c546706d60',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('b95db2115e633ee6f22a5a7eb0a8d43393ad9846c263f4aff6c9d1eab415e7c356779ce0fa10c9ccfcd11c1f2fcbe355af99818611085c94edd308e0074b36ed',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('b9cdc8715a33d44d2dd8f5077ce5c811816851f2e849a7c90d1e997e3d460e23ad9759c485883df18685405c17edb4b5977fafd96ac8bd643188d5715628dab0',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('ba3991d7a35cb847f31bf9a1cd564bda1fe378157fea81b724e5ff05893b8c9d8bcb8b5913643b380bc69f1ce0e09aab1062523c0b63b847ea37d80780d3b090',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ba56b8b7924502803e624dada0f00e0d6f3ca84aad9b86b2f6671aecd48a00db07eca0bed9a3e1e7cac961cdf2dc608ddd27de897f600356d62b35883a5dac73',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('bb7ca62d4c43ccd0cfdc580162e1162e4422f2e66ab0325fe77469641ebf0dd6239ed6740625e450b0e75a50f4f7593162dded26411065350a11b1ea5a2e4c42',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('bbaf109f523ce402a9f7ac8561b147f2e681b58bb30791b23bc6153a60d7ea5f763a38a9f978e3f286133dcbfe80bb5534bd84e30b03baa3f6e3c0897029a931',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('bbc07e78f9aee5c38b014ed32bbef91672d021ac168d03c79d7bfe2931ca62c8ba3ffddb3a7910e6c2ca1e1772be113c913d260d8517586659be18024e56122f',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('bbd6400d181f23bdadd2e8abc35a79d3eaf1fd9d92e933578e170168d5c74edaf72034247010de9489c62ed902ecdcc275fe54b7f463be08f69517ceb5ddbd3c',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('bbf019315b1233aa09cd4e24f5490b1946add12eb5ab54194fc00386e294780ca412c1c0aaa169e99948d2698300828a4647039739501f7657ac7d5dbc55207d',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('bc257401041c69eadd80480d41c2cf09422f145ed5b9f2cdae3f92d2c5ee360608a60384b6beb46a71d8dda747f891df40a9f5ea1fe7e5905d6c1043c16b248f',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('bcea29654a9366c8ee1134bec19cc7733c5089f867beb918ed4a6dfd501fabbd0cc8b623d0cf1233216e6aeb79771bd9ffec868ac56609d35955d4b127522305',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('bde5d86a3ae874e44c8831399670d12134a1b90f7794ebf8b450f7ffb19c2e5ed0f8631e5cf6d39de6fd7414a7a1f2b91997c1b554b7ca277e6e6a360e389a68',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('beaecd01914165c39f0c00518d5a284e71459299f5e0b50256f67064ae80af63e7a256b8758886b67ec833ce2936e6bbbc726ad33bfe2bca9bac84670561bb14',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('c179b44c92c160a7f21199c8c1285cd199727763f93d92a907d1a20c12ae7aec58f91d7750759a21082cc21426fde23133b8275d345ca9bfcf6c86f2587e9165',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('c3afeab302be54400b9e03c0b353fa42ef9b69b2c165b062950475590823184859d923fc7ce7f11d5520581edbfca6c215bac7ad54af778934252614f98038aa',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('c511933c7a871a76c8cdee0f9ef0d216ddbd1cc847cee1aaa34a9a583ec49ead622201cf7a6d702f4f71ad6e64a8370307f3be596fd71f0b219b895f7d4f8034',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('c5629e0e473dab96393b47b3edce18ebdf6752fb9505b58ae17ec440e150bc7d965b6136cf1f3b33a3422c3113c9e2b426d5a21f5206d52c48879feda18b1b24',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('c6d7276ec2be4007b9e6b3d3946cb9731888b0974f3d664ecae31333ea802c5afafb8460e7fdd99964cacdf00b5d95f76a16f4d2b39052838a2acbb971f7ef3f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('c7f2b8aeff5ad79e6228ba0fd92b519fb63c2735b92cd5c46a290f90613828b8d2ff2185bf83d1b8458d7b7fbb044de260ee80b3c2f36b41dce76210693b704f',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('c82048f847f1c06b9aa1b00a389c81e8ea75f84f67b4b3374198e27f39a55077d3eac09d034b9b5b982464f0dfea38ca4162dfc18dcf7fd231a27dba0ca1c371',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('c99de5a08ddaf91194e811d301bcacf33537e7308f7c017d9723b29b444fd5983561e22f41f7f545b10389e34d4346df9ff07c09ef3345c7dd5995a41b3c83d9',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('c9c9e20f24946f2d3bf867985d5a46b516a835f7c7d3ca2c9ea487f2103a0a4210406bed749430fca8a55d095aca2c619cdb77d6ef1ca4e7d4770df712b68ead',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('c9cf50bd4d7f5366d5af5b90c22a91d2becf4dc8d27def49d32abdf6885b88908de9d71d331103a58e483385442567f1fc1b5b366d077210b4456b5b903dc495',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ca5d0329b79d34bdd05234e2467d1ebdd1efa87b03165e96fd2d7cc571b37bfe98eee4f4a33d5054a48315caece41e2806ccd16373ad6075765d657fae6da426',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('cb8ec63609addcedfccbad301f7aafcd72ad6de15c77a44d0fa9115769b85148c1a87049b1be2ab46261efc988a6d45e5d8b7c5cccee31d58bd4e3c180b20c27',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('cbebfe3a26616a564a8646f77e298f00dea2a394e917182a7aec56bbe44cda21e09eb008bfe4239b0c7a3f33d7cc80b0b1a51099531532431d1992d23c6113ba',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('cc4b7388e31ff317fab75907904acafd632bf5f3a8a52ec9e2798d443938f3ef8014ef9d87e6889e37897ac21fb640e6591d36e5b345b48ffe08e81df2f20b4d',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('cc57eba3214aec45644f74300706c50272808c7568e3114e8f5a1dd50f46b5395257136f420259f089b5bb8ac6abbf567243c2d98e553c6b471ce576c6e9c4b4',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('cc6699063a2b5a43e1fe015cbfcdd55694f1a671e53daa40036e0e9bdb789084727e91f006043fc506b1ed5bb4b27e5a8129545a41a06d52bc6cec08137bb872',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('ccc91ffbd76ceb8d58afa991ca0d10b636553daf73aca4d01ae645caccc010414ee8e75478f2daf6158208c1babc185b4635b898cacef1a17e669057e92bd91b',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('cd37c6a54ec1ff2bac3e04caf8486ffd75f2349b631b2cbaf1beab10a1b2c49311aa33dd6ceb8b474875e0572ab9dc61c3e6fe6a97e0d4879ec06d6318d0d1c9',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('cd68cc86f17c2f23713042cfb74a9f9fa9347b6e6410702e67ebd09e4ffef6cf840120d4804a53d8c0036eae09a20a4a5557879748772f1fdbb48a5a76a74be5',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('cdd6c7bb5bf6213ea0d33cabba2ae64176a5fa5c56df12000b2739bf702952d6cc2e7eb3f426786f93df80268caa68e9da8815cf3c94b993a06f565f3b2c5392',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('cdfb60ae53bce4aa1b9f9a59780db5e2f0c3b95d124db77f776aacb3eba6b52cb513426357af021b53401b0ca2533aefe57c159cf3dbf0e52f05ba97ab314034',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('ce4e8956271fad71b9e935a7cbce5f8f72f00a236f181f075253728ba0924f7217a385460a0526c750a22d78404c503cb598785572e373aff4ee19f0852a2276',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('cf23c790dc58852880175b17b861f0f8533aeef37c7d782bd51e7538318d35dd0848f64320778ddd7572853fff99d920ebafdfae0596b4342d43a88f5b421413',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('cf2b5ff2b911b54dd66644da502d0241d9195659e8239a802ccdb93bcb27f7e56e9e00dc3af0239ead4b6034e5f93ec72e65f5e00157a365fd8f43c49cfc20c2',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('cf62c014bd6feb28d1cf835aa4957ad427d19116859a39ae068d0123fae2e5f7145dd000d9d287b01b2a69e579c52ccdbdbb161a784aed8399ece3f06cb67c88',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('d048363bd5c76728f84568c178aaa512f8f47eb1dcf551936f76667ae29f1e84210dee489f529506a7b0532ecf74004d03acefcb5cf9b66c32dacca488f5b2ea',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('d1065882c9017ae4a10e976c0e3a2e04fe8308e2f6941725030804d7da44716fb6dfa332de8c11e10dac050ccf809d27c7139d79dc87d9a364cbb9f1e313b077',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('d113157daff7c187a0186fbe64a671f882fe293de2523b13dc0d9070d668d4d1c51a8745106df03ce38f4ec8109f191e21fc856a2d8428bb722d686dd1016ac3',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('d138cf6805bbbec960342a15a32091151395056fb1f39119d4ab8337ae84c814d13b877dcb30bb92861a346df2cfa0168bc76831186dca72ae63f445ab924d44',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('d1f5b1accb1e29137494dc235eb694c12754b64afbc0e5f6265af1f3d4418042a7ad49b94b11a31686f909f9fb7cfa8a69dec4c18658e8bdb5df4a8b827813fe',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('d263823fea1a7438256e4363d18b9c2babab4b82ab8cf89de574803ff1df051105d6bb835deed6e349915fccff5dadd19f48741f0bc3b5af8cc2b97160f4fbdf',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d26790297565f311788662550affb9f32375c2402bff128e6c1b03dd6efff14a9aaf9b91f51729699eadd36511bbeb9864199381706a3ffca78878dcd35c3c91',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('d270cc1438651be777a82de784e8d87fcd94acd1179243179d64f64201f66ae09be843a8511bca6f0f85d7652dbaa204be29414a5fd41a186d31122b9f2ede75',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('d2a7f4d45c0b3f22b44b6d73a76467b23365d9ea08925608e81260c105d3c55c2c3b39541dd2e2dcd952071dfc1e602daa149bd7658dea8bac7c97c35054bbe2',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d2ce003ff9adaf82454bba37ba4fa892273931f623b84c3e0d8b5e5df8cd16b16c2ad56b8dda6116a03e27d673960625ade4c8ad9eb8e53c53a6bbac78177076',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('d2d692f93ae92b65a279dfa071e0f1b13cc20bcbe7dff7b878221249310f9b56d1464bea40086e8b8b14b29fe24e712bef977d2971c0a86501383af0ab37840e',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d3fc50571fc3af2b361a8df29e2d6a0d2b3d4b469a3ccf57b5756f883dc359ad72243b03eb960e9e560f4de95e374f31146b1e0103b105fd755b2321337bcf21',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d46e7091719dd46e3814384b2282da1e909caa90dd9b0494a212f20fcbdb304ed8cc69a47668749f24171fdf18bda779437922545ca84abc1795995a5f198e23',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('d517221e7e5372468d358603791593d86d199d2d23febb38b0b42b2455d7dc88ba92322af5fec56ee77ef93cd639a3ccd842c689eeb2346b022a38ac435bfda6',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('d5475c48d6111bfc53d16b301b7c8c7bfbd0e201d4c86e3cd1f73686b6c335b9ee1e2d675c9abc4e8b1f437c0a1a251445c77bd3b87379e1f88e8c8d390ad4bb',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d56ebe7521a4c8707dd4a9a24d6c63d68e4744a9710d89d84ae8aefd8c677f9a1fc6d14eb9364684d6663c1b239ef06fcbae27ff0c642e2c9457f1ae1b08e1e9',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('d5f3bbe057bc8b7b77c4c945f051acf6f02e9d2a130b7e1093dbce74b7766a9abfbcedd9e5a357c48273a56614041822309be6d8b86486910450ccea94f70be3',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d68589d69933e9e18024aecbcbec6425c69cac83e5a4a5a42e2af8d185d03b32f0288de8d6c99bfa6422d6d7c224db0e15de5c5b02706ad2ba013509bc49fd19',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('d9271dfda36b5d346fdfbd049da5cc52d97a28d14a7915697ebf4a0c1039b988eb037728ab981ca837a5ccf3afcc71fdf9e7bf89f941b88d39d1f77c649a544a',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('d9c499fd27a71f950c5c65f8ab96ed19b95030b1343a7ece1a2ceaa91f309381bab449a7f2675c414fdeb10447355bae3fbe62752aae8331208a3c8f24f00148',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('da71522348096a41a9c04fbe6a7d8eb5afd0a7578be339396d1c3e0ce8000e6ada36efd197773517e2a5c46dd2bedb0771f9bde0f7a10530ad4a98963878b557',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('daa41b0905368326b41f59a25cc718b7d8ec54c981583f93710eb02c1fb6e8681514f64f023e466d6ae30a18ced67fce4dccab2847ecb5230772a3dd818728e2',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('dab40594eb51600832eb8386c33015e4bcd74442ae85483087a1d13ac955abf73f0ee5b2b08016fd5511614aa9f426306b6f064757826775e03d61690344cb5f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('dadef5810051a52e47f1c2f2d5ba589bb1da93299711bc5fa7d1471351dbc803a3c4a61725f898b927d22170fdfe332a0b04e25d2edd38e784a4bf1cf4035a3f',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('db33117bb109c471dda96e76040a2ba8a14a51545f079c4195dcb51da513cc984ff6e8f3744d59b2036bcae2adc5e344098fdbb8ba651b656dde651d53f179fe',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('db4e0d91b0c16539545c6770daaa52999bd29dbe2e4a494db41222b627cafd396207a54d92d9806471710ab8c97c85a44687101843432dbbfb0241717010b272',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('dc19f539d4d570265bcdbdeeb05ead36e9c07428b8bd3e666f84d4ae329cf2406cc1575aacc0db81a323ea5be3170dd750cedd710dab6585717c4a8f9d1cce34',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('dcfaae6f1e2da09be978161be0a5a30e559be4b078095e904b47bf65fbc1bc5b10a93e5570be87f3fafa409216be08bc40171c6f33b24f56b73f9ea0dbc4f0fe',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('dfa37d86ac0677c9718ad13aa00c9e481957012871c0fa82e44f58d0f0eba96e247ae7f9e75f64a00e0a659978e5512c6fb987c7aaae75dbd7f149cf87a42357',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('dfd60ddfec455e350feb37f353190de49e90f7efdf6d8af98cf3bbd7981fd1fd3cc7a31304266cad1dcc020e18c04e92ca99afd8b5ca1c8f646b750c71a88e02',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('e0a23f77d6d1273c34885ef68a3c242061dfbb8ac9991196821d8eba1a9e002587a3e69d351f5a8874a4cc8af5fcc337617b7256c731dbd5e09adde8cca832fa',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('e116a2cdfc9b11397868471f6a55f700cc502bce87ade79bd1af5e39fc1e3726a5c3a3b9d4e7471e94be2b977151b9e1a227be176ec34321e7ed59ad0c2f3f10',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('e189594e61e95d4cab3f16f0abd7e77a3165ed6282c48afc7ce47b7b8c33aa90ae37377ac140e4ac065dde33dd86e3afb7f1aca643a7fd80f0fdd7eaf0d184c3',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('e1ad2f04d0f04651c73e16f760b61c666be747fc307c2a3dcaeb0053e86690976d42b756e27597ad75c2b140626935d966639278f9b6e681a7cadcac207e07a6',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('e20200e02f54b4e4a8f6dfe9df1ae9745f46d2d70398c121e4c7db1feaa6c8e7b5929976f2e65e03072ef096c0a492c536b41cf6eb88f22241600d12eff730b9',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('e202c914fab74b338bbf5c65e9a901653eb52477a96687b9e17d4c37ef46e4eb72fc9a113ab32fe3ac7007bb27c2732b6781d3127b6fe91ee8db74ecf3c353f4',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('e2923e723c2159860e4c33fd413260c95a34228dae4ddc09880e3ea611c8616a7718d1ce3364c835272454bb3c899f823416dbc9fd5ff4d775a0b6ba755eb590',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('e31fb8ccbb3f5181ce7357c35f8bb2bfc6ba8c0e68f0689cd798a4a886fc8b9c24d1926cdf8e4d964d61f6d0f0464a45b83bb24e388e6de2971261d01659b449',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('e399718d9a463fab0b7157f8c035fbf3c0284ca83daf8d4c990ec71624dabe40413295e3e51426615f372ddbe6b4f71a4a170a1c6d1102166ed0485e7eff046b',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('e47027944c449b98e7bb71a17fc23451d77550c4599e24d850ffc8f19c4e203f405ef9e85440e32818078f699d6a9e3fb270754287726cbae19832edc2cc4157',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('e5a93af0200211a17c9296b9f1601e1c0c29d50f4e7296eda24473969a9ad91a5b4e8f60d844b5763292d617861615ec6bf33ac397c4fa24ae9ba679dded3273',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('e5b32df7e1920c6721adf1fae555a5bd677b8ccd925bb959aa2ea3a963e9185708ef49ee4ac062fb461cb207be63ed9105abe63ff6712f820c9d9c9f47911475',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('e5f513e6cf2247420f8878e7767dd28302247e46b13248ad52baeb06b03ae45b23d5f0ef16ba697ad8e9111efded9359263ba377a1b3a7d140d970f0956281d6',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('e7167483acbadd3ec7f7713b8343983111d9cfec4b00fb706cf738040b7ed767e8ba19690c67ac240b5c742dc8beb7f1e94beef27bf2314441fc4e4467ea53c4',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('e7763c7b8b01ce918207c50ed0244cc4ef59d87e0d94ce658d6fd5f97b2d2fa3eba64778e31b118ccd4005589ffe388d8807326d36ddfd4bc67943cab10ff21a',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('e79ce3f55b98b7593299d947a215cebe7edbafd2b8a1ed262051f6024342344fc2e9adac2ca01d563710b852975664a1f0e6269cdd4d230e19d0f0c7a2ff0d5d',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('e8b8d37f61990cd7fdeadb9b7a09e48fe5d7faa53b9a27177bdffcaf6086a3c8e58643b9194f2acf5ffed64649564ac2849105ce78494960572f5997d18a23d4',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('e8c98936f4f59ca8991be45a0adbcf628587657552c85386a09a3ba16b7a03119f0edbab0cc6960be4fe54f1515d6ece6d128253a473a5892f930821ee2e52b7',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('e92ea633cbbb72980f4b3674ba5e21102c6c7853ed8db992ca41ce95b47e9b13b70c9c3cd7aa2b281152ef8e3375f7b793df51496fc879fbae4f3b107f3fe718',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('e938a58261b6557cd0de97e18cb9aa77c8d727f23061634ee1663a2115c9591260081ddf8f6589a37861aa31769b43ad3bead47bcc1051e7245fc38f611b1b5e',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('e95ad151a2836dfa814f4e7c2d45ce737d34413a15cef887eb417aacb8aea87ed50b11b6a45befc87d0700a0a529d44be8963ac430436e39558d390e2c3a8e96',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('e9634f6aee2344a446fdc6fb610514c0f71852daebf27e0a64e5537361d0d6d035a237ef1f7534b5ef9d1f6ce5d781f567ea7acf75f53ec7f750135e308dd692',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('e9a047afd7f1ccfc37fe6465aaef3980756ed93a112b46c2c1eca2825951b53b7fc4abd7131e1e3e5bfc7082b97f32adfebf3360b2db4b170199cdeda6374e0a',0,'2018-05-20 17:07:10','2018-05-20 17:07:09'),('ea0a303d32fbc06c28c88313235ccd79b3da12327ca074d562e23d5cb1db3213d4f7c57c82423d0aa8978bdd52c92ffe5f27a23826cf7b8c9da01e01d2237d1b',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('eab76f249eb41b0e4111724dc51df7828a16bbf8ac31c3aeed3af7f6d223000a8fab704224d0766e2222a08d0b1951ed0669740814477ec131df07363921bf3f',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ec539eb15f44fefd872d5ceaa37d24efb241936a5025526e297976189b028a19dd4ccfb8943c97a29c28e04e2088c90923a05621c2140b158a32b00353f5b948',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ec9d1350fa5979d8ae2aa758a94e90e0f60f7d51d7c50a8a5bdaacc86626c914ecfda240fb0c697f1f4c92335e1030c8281b9c9f809679c602adaac31f30ff1c',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('ed0d7f3695cf8ef9d4d865153408d4db4b1b1d0a7337c29b29fd586545d1916865c346c9ece39f1a1438a36fa7a316da8c33517bc85659c61695bc0b112b9f5d',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('ed56bf9493d6f49ade35738304fccb206f550b0cc1796e2a1383ae64119adc3d35e39e4f14b3dd44d97852abbd8824a07ecf703e03448315fa9700e754441b1d',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('eefd23520660db0d2ca0f21ba6bb473bcc77d4f7a6b3bbbad8204aa1cb4009442c802dc9c306383de17d5b2f43abf1d7a612fc38071a6e94105fecd65d6bd919',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('ef0be179b9281a26410dc8dd1e9cbaaec5160fc4b3c9c06f6f05da71ce9660630139f9f8f905ecaffb0733d64317172e55a44013f3b7bd0e0a3f35bc1d55096e',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('f038b0ffae2c5106f8413e71ba50d6b351cc61e812bd23da82505457c201642402a6e9aaf53500f57dffda6280cbc452afdd9b40a6be29f1ff43c1351ab70d80',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('f08b07a52455d2df1674e633a2dd1a3b4c38e86094f240f1ac93530c53462a0d5671b98dcd875abb65b9bd1e9805a626410e8915b6986464da3b92f35e0de39e',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('f0b7f2002e175c8b3ee688c55e96d60c39dfcf9ff7ad578f2a0b165586bb26bd31d7a9e1c00eb24144dd6447f604fd096447351fab2ecdf5d91033a167946b94',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('f158c1dd034d7ae415b2fce04515827a67f50a1a12bef0d6b18536f673019844f7184ac9f2ab7b4c4eca193bee32b653e16837f23460878947691b9962ce0114',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('f2d26978ae5e86a4e06107ee5af914c67b803aae8efafcb87bcab3d54a1be546684332cee8d5c2b4caf5ce30422e457fefd30bda7417ad69fafd9ae97cd02edc',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('f353be73b88f97bb95c12dfd61cf7a15790372f94808d6f80e1ce032f2c147e78e8d3d5ec3be4c3c15787b382c9b9f6cd301c92eb709bb7860a4f17c4159576a',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('f396f53753ef4c80b3bb1edbae11f5e726c1673939094035a5ebd334e4452d366eb5ff41a95a6bf96b75b34bb3035aa8452b7b7fc242e4e6dd9fce3bef4f8b9e',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('f3e42c87d735bb6c31433e929d47e1deadeac3afdbe6f6ed57180d27fe82efb199bd25cb182a4c834ba43a043888d920b33e3ff9faff609d5aa7c62abe4d4157',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('f3f722c2f1f8691727df0da3388c60661d167cb3fbc3415ce10e6c762b6a97a354a0706010d70bcfaf133817bc5b28c1b900e097a22f394cf2518e8a403d3322',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('f3fb8b1545d52b1040ab9bef5f464f15c331ea7da5733a21fe559d80110777df19101fbb7109f41ce24a8911483477cedf1b81525f22255e8222d92174a0b3d4',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('f47e397e79c3d2c90ed729c80e6d681e6373d4edb721726905333d5c66a6ff66fe93c50482bdd7a27972eec4c887fcd9587ef322d5c2841b25fbd63218fd2911',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('f5563c5c5aef22f9b1652aa80c3efe49a75e4282a21c63a444a8bb79716a944ba45df9173c91a131fdd18c1568bd00c209abd27e7033feba74c8b26ff657fb0a',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('f5629516ae7590880fda5e81db88881f072846ff16941dc20a9f39cb38c3b59c27000e6240e9574f9f9c1193d02bba79cc603fa88fad98b91e53a00b213a1d94',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('f570ac4f6ef4b9251577746d87f802d0d96bbce927ba23d03d72096208364865e153053a0a25b3cc98229055e60810ea80f02b5efa66759321014774893f74f8',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('f5846a2658c9a1020f45dfc9ed91c9de86c3e946b09b79b94b4d1725dbbeb1c38d2c483484e0b136cdd05c4723bee068fa6f0b376e82babdc92af403dfe7299f',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('f5b1656b46dbbfa4565bc707214233f2a011928be6ae1ca2617bc397f95e63a155785f1fc53023e53aafd71e15cef47d75a35d96653bd3d2547b5053bf48f881',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('f5e7c3cf14a65063ccbb3d373b6f1d3509f650051dc6255f5533eebb8b9af26c050dd8d4aced43124a068d791ea3a55248df15b52bd2137fa6b745e701cecc0d',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('f6283bcb893266b6454e8ad46e183cf1be1bb4a09dadbc0ef7c990f58e97c730cf5c2b98c562051938675af9fea947ef9fd04fe01c98c94e2966800e34c15ca2',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('f69ca4be161a6a8160cecfb331d099567e66d45835937e0a4d9468b5bbf724dc3e9f18b72b8e09b92499a2ca16e18e4915bd20e123e3559e2db2a291886a5fcc',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('f6e91a5d7b32a3530e09548f143ceec6617b97474430ef1ee5d1e1efe1ad6991a918f72c5f342a144472b02403fc22a76726a780927a862153586c6e1f89fe36',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('f705cb2e36f3cb82d7a4e9fbd2ffaecce0efd1eeb93ba2b6070aa90b1d38b0b0adc856e8be9eb9317083ca08d2b7488d714c94f4e761c5e95405a5e8c09db065',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('f9855076672d7e37f801e4b7873961e1e5ba25efc30e393d8ed6da84621362e347a92f82b11b585b711567c8125ef26a6cf12ed80251e72a29051da98cc3b8ed',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('f9f34c7b4923148f9250067be90d666fe395c1742d798dadc5ed7f8b6c9db20f9f92599e91f5622119d999475695a5845989508894a5b45863b17281c5f33b08',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('fa8438ff2b3d7aec5bcd81d61df64bd719bb526704d7f845bf291170ee469c233b01d3ccc2dcda714dfdd43edb11b3b8e7c5d5de726815f6ef10f5c834630070',0,'2018-05-20 17:07:11','2018-05-20 17:07:11'),('fa9bf3ae3a09c25fa2a5994ab839e13b4ed1a65501337b19e865bd1bcd084f5429932487fbc791a268b3d2175f422216c0000951881c4de03791839a96e63074',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('fad7541528a49ccd80c9b29c69069b9dcd28ac3b9dc2f8fcb708c825d374b536d98e6eb823be744d7e6c578e57c2bfc0e190714b53dec971f4a199edce7d04b4',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('fafc215f8746f8695c4acd4e547163a8bb6f1e5ababf3a47eb2fb2dc88d55a7c741593bfdeea64593a72d356775b540d18e739846befce4d4397227bdbcb6d4a',0,'2018-05-20 17:07:15','2018-05-20 17:07:15'),('fc44273f3beb49eecd8f9fbc92e027b252507297288ff926fc2b831dcce0c20e1fbed8c1561c8ff9550e0be32f36c59f499e69d56e839f0ca9ab5faa8f40c411',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('fc8de0fa79a14c8c55ff0150cc5b22793014f494ac36f5e2ee6fa550748a2c55ed48dd1bb440b13823a39d38f16975ce132ce6ec2617873bf570df356b5650df',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('fca42106648689199a9756ebdfec1784ed796815d7b2f7ce345f2399fdc5a714ec3b5e9db9f364795dcf4e9177dc925fd7e7f586ada1b3d1b5af1b99a507faf9',0,'2018-05-20 17:07:13','2018-05-20 17:07:13'),('fcf4e6f5e286470e0ae69240dfd531c37cf2001aa4e5e036e33e927dc7b6177210c1d460a6e6e44ac5afa78f6ca8f295bd750fb449f0cb30952b73833301485e',0,'2018-05-20 17:07:12','2018-05-20 17:07:12'),('fe09c1512acfcece71a44458c46e57839742521bc671b2f55c60faf5af6571cfe5a173a595b90315ba70534390b01f0a74d0b51ca27ee44c169a6c052ee21c87',0,'2018-05-20 17:07:10','2018-05-20 17:07:10'),('ff3fbc9695d3e7caa645552845f88b39a1abff4023770adcfad1ce9a50bf7b44a35c6cf737082779592861b706b1b7de15d3f4a58937a03823e39b5b2db4b108',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ff927ac3fa0ef8f3a3b16405a59143f5d891496ac655b74851e706fb89c39404dcf5b03c565633c906b06977a1521c370e49ff4270736cce58e528063c9ac325',0,'2018-05-20 17:07:14','2018-05-20 17:07:14'),('ffe40ac1ae61a3c3c6fd2b52087beb6af010d152b9992fe848d1685c3d08d66d223796623ae5ca8fdce69fea75752f097ee79668535f040d4622703ce79d2aa0',0,'2018-05-20 17:07:14','2018-05-20 17:07:14');

/*Table structure for table `exchange_job_detail` */

DROP TABLE IF EXISTS `exchange_job_detail`;

CREATE TABLE `exchange_job_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '结束时间',
  `seller_no` varchar(32) NOT NULL COMMENT '收银员编号',
  `checkout_total_amount` int(11) DEFAULT NULL COMMENT '收银总额，单位：分',
  `cash_amount` int(11) DEFAULT NULL COMMENT '现金支付总额，单位：分',
  `balance_amount` int(11) DEFAULT NULL COMMENT '用户余额支付,即储值卡支付,单位：分',
  `unionpay_amount` int(11) DEFAULT NULL COMMENT '银联支付，单位：分',
  `alipay_amount` int(11) DEFAULT NULL COMMENT '支付宝支付金额，单位：分',
  `wcpay_amount` int(11) DEFAULT NULL COMMENT '微信支付金额，单位：分',
  `petty_cash_amount` int(11) DEFAULT NULL COMMENT '备用金',
  `paid_amount` int(11) DEFAULT NULL COMMENT '备用，实缴金额',
  `isFinished` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已完成交接班，1：完成，0：未完成',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `exchange_job_detail` */

/*Table structure for table `goods_brand` */

DROP TABLE IF EXISTS `goods_brand`;

CREATE TABLE `goods_brand` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `brand_name` varchar(128) NOT NULL COMMENT '品牌名称',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_NAME` (`brand_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_brand` */

/*Table structure for table `goods_category` */

DROP TABLE IF EXISTS `goods_category`;

CREATE TABLE `goods_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `category_name` varchar(64) NOT NULL COMMENT '分类名称',
  `parent_id` bigint(20) NOT NULL COMMENT '父节点id',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_NAME_ID` (`category_name`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

/*Data for the table `goods_category` */

insert  into `goods_category`(`id`,`category_name`,`parent_id`,`gmt_update`,`gmt_create`) values (1,'root',0,'2018-04-18 11:42:14','2018-04-18 11:42:14');

/*Table structure for table `goods_color` */

DROP TABLE IF EXISTS `goods_color`;

CREATE TABLE `goods_color` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `color` varchar(64) NOT NULL COMMENT '颜色',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_color` */

/*Table structure for table `goods_image` */

DROP TABLE IF EXISTS `goods_image`;

CREATE TABLE `goods_image` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `goods_image` blob NOT NULL COMMENT '图片的二进制数据，大小限制为1MB',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_image` */

/*Table structure for table `goods_info` */

DROP TABLE IF EXISTS `goods_info`;

CREATE TABLE `goods_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `goods_image_id` bigint(20) DEFAULT NULL COMMENT '商品图片，外键id',
  `goods_name` varchar(128) NOT NULL COMMENT '商品名称',
  `bar_code` varchar(128) NOT NULL COMMENT '商品条码=商品货号+子条码，唯一标识一件商品',
  `product_number` varchar(128) NOT NULL COMMENT '商品货号,标识一类商品',
  `pinyin_code` varchar(128) DEFAULT NULL COMMENT '拼音码，即商品名称首字母组合',
  `category_name` varchar(128) NOT NULL COMMENT '商品分类名称',
  `goods_status` tinyint(1) DEFAULT NULL COMMENT '状态，1：启动，0：停用',
  `goods_brand` varchar(128) DEFAULT NULL COMMENT '商品品牌',
  `goods_color` varchar(64) DEFAULT NULL COMMENT '商品颜色',
  `goods_size` varchar(64) DEFAULT NULL COMMENT '商品尺码',
  `goods_tag` varchar(128) DEFAULT NULL COMMENT '商品标签，半角逗号分隔开',
  `goods_stock` int(20) NOT NULL COMMENT '商品库存',
  `quantity_unit` varchar(32) DEFAULT NULL COMMENT '库存单位。个，件，杯，瓶',
  `stock_upper_limit` int(11) DEFAULT NULL COMMENT '库存上限',
  `stock_lower_limit` int(11) DEFAULT NULL COMMENT '库存下限',
  `last_import_price` int(11) NOT NULL COMMENT '该商品最近一次进货价，单位：分',
  `average_import_price` int(11) NOT NULL COMMENT '加权平均进货价，页面进货价显示该值，单位：分',
  `sales_price` int(11) NOT NULL COMMENT '销售价，单位：分',
  `trade_price` int(11) DEFAULT NULL COMMENT '批发价，单位：分',
  `vip_price` int(11) DEFAULT NULL COMMENT '会员价，单位：分',
  `is_vip_discount` tinyint(1) NOT NULL DEFAULT '1' COMMENT '会员是否有折扣。1：是。0：否',
  `supplier_name` varchar(128) DEFAULT NULL COMMENT '供货商名称',
  `production_date` varchar(32) DEFAULT NULL COMMENT '生产日期，年-月-日',
  `quality_guarantee_period` int(11) DEFAULT NULL COMMENT '保质期，单位：天',
  `is_integral` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否积分，1：是。0：否',
  `royalty_type` varchar(64) NOT NULL DEFAULT '{"type":"0","value":"0"}' COMMENT 'JSON格式。提成方式。0：不提成。1：销售价*导购员提成百分比。2：利润*导购员提成百分比。3.固定金额。4.销售价*百分比。5.利润*百分比',
  `is_booked` tinyint(1) NOT NULL DEFAULT '0' COMMENT '能否预约，1：能。0：否',
  `is_gift` tinyint(1) NOT NULL DEFAULT '0' COMMENT '商品是否允许赠送，1：是。0：否',
  `is_weigh` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否称重，1：是。0：否',
  `is_fixed_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否固价，1：是。0：否。固价表示不参与任何折扣',
  `is_timeing_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否时价，1：是。0：否。时价表示根据当天情况定价',
  `is_hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否隐藏，1：是。0：否',
  `promotion_id` bigint(20) DEFAULT NULL COMMENT '关联promotion_detail表',
  `remark` varchar(1024) DEFAULT NULL COMMENT '商品备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_BAR_CODE` (`bar_code`),
  KEY `IDX_PINYIN_CODE` (`pinyin_code`),
  KEY `IDX_GOODS_NAME` (`goods_name`),
  KEY `IDX_GOODS_TAG` (`goods_tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_info` */

/*Table structure for table `goods_lose_info` */

DROP TABLE IF EXISTS `goods_lose_info`;

CREATE TABLE `goods_lose_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `shop_name` varchar(128) DEFAULT NULL COMMENT '报损门店',
  `goods_detail` varchar(2048) DEFAULT NULL COMMENT '报损商品信息详情',
  `total_lose_amount` int(11) NOT NULL COMMENT '报损金额。单位：分',
  `turnover_percent` double DEFAULT NULL COMMENT '预留，营业额占比',
  `operator_no` varchar(32) DEFAULT NULL COMMENT '操作员编号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品报损表';

/*Data for the table `goods_lose_info` */

/*Table structure for table `goods_lose_reason` */

DROP TABLE IF EXISTS `goods_lose_reason`;

CREATE TABLE `goods_lose_reason` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `reason` varchar(128) DEFAULT NULL COMMENT '报损原因',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_lose_reason` */

/*Table structure for table `goods_quantity_unit` */

DROP TABLE IF EXISTS `goods_quantity_unit`;

CREATE TABLE `goods_quantity_unit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `unit_name` varchar(32) NOT NULL COMMENT '单位名称',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_NAME` (`unit_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_quantity_unit` */

/*Table structure for table `goods_size` */

DROP TABLE IF EXISTS `goods_size`;

CREATE TABLE `goods_size` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `size_name` varchar(64) NOT NULL COMMENT '尺寸名称',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_size` */

/*Table structure for table `goods_stock_check` */

DROP TABLE IF EXISTS `goods_stock_check`;

CREATE TABLE `goods_stock_check` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `check_date` timestamp NULL DEFAULT NULL COMMENT '盘点时间',
  `seller_no` varchar(32) NOT NULL COMMENT '盘点人，即收银员编号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='盘点表';

/*Data for the table `goods_stock_check` */

/*Table structure for table `goods_stock_check_detail` */

DROP TABLE IF EXISTS `goods_stock_check_detail`;

CREATE TABLE `goods_stock_check_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `check_id` bigint(20) NOT NULL COMMENT '外键，关联goods_stock_check主键',
  `goods_name` varchar(128) NOT NULL COMMENT '商品名称',
  `bar_code` varchar(128) NOT NULL COMMENT '商品条码',
  `goods_color` varchar(64) DEFAULT NULL COMMENT '商品颜色',
  `goods_size` varchar(64) DEFAULT NULL COMMENT '商品尺寸',
  `product_number` varchar(128) NOT NULL COMMENT '货号',
  `primary_goods_stock` int(11) NOT NULL COMMENT '原库存',
  `checked_goods_stock` int(11) NOT NULL COMMENT '盘点库存',
  `stock_diff` int(11) NOT NULL COMMENT '库存差异=盘点库存-原库存。可能为负',
  `profit_loss_amount` int(11) DEFAULT NULL COMMENT '盈亏金额=库存差异*加权平均进货价，单位：分。可能为负',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_stock_check_detail` */

/*Table structure for table `goods_stock_flow` */

DROP TABLE IF EXISTS `goods_stock_flow`;

CREATE TABLE `goods_stock_flow` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `goods_name` varchar(128) DEFAULT NULL COMMENT '商品名称',
  `bar_code` varchar(128) NOT NULL COMMENT '商品条码',
  `flow_type` varchar(64) NOT NULL COMMENT '库存变动类型。商户退货、商品销售、货流进货、货流退货等等',
  `flow_count` int(11) NOT NULL COMMENT '库存变动数量',
  `check_count` int(11) DEFAULT NULL COMMENT '校正库存数量',
  `out_biz_no` varchar(64) DEFAULT NULL COMMENT '外部流水号。例如商品销售，则是交易订单号；进货则是进货单号',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_GOODS_NAME` (`goods_name`),
  KEY `IDX_BAR_CODE` (`bar_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='库存流水表';

/*Data for the table `goods_stock_flow` */

/*Table structure for table `goods_tag` */

DROP TABLE IF EXISTS `goods_tag`;

CREATE TABLE `goods_tag` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `tag_name` varchar(32) NOT NULL COMMENT '标签名称',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `goods_tag` */

/*Table structure for table `goods_traffic` */

DROP TABLE IF EXISTS `goods_traffic`;

CREATE TABLE `goods_traffic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `traffic_no` varchar(64) NOT NULL COMMENT '货流单号',
  `traffic_type` varchar(32) NOT NULL COMMENT '货流类型.in:进货,ordinaryOut:普通出库；supplierOut：退货给供货商',
  `status` tinyint(1) NOT NULL COMMENT '状态。1：已完成。0：处理中',
  `goods_name` varchar(128) NOT NULL COMMENT '商品名称',
  `bar_code` varchar(128) NOT NULL COMMENT '商品条码',
  `goods_color` varchar(64) DEFAULT NULL COMMENT '商品颜色',
  `goods_size` varchar(64) DEFAULT NULL COMMENT '商品尺寸',
  `supplier_name` varchar(128) DEFAULT NULL COMMENT '供货商名称',
  `goods_stock` int(11) NOT NULL COMMENT '商品库存',
  `in_count` int(11) DEFAULT NULL COMMENT '进货量',
  `in_amount` int(11) DEFAULT NULL COMMENT '进货价，单位：分',
  `free_count` int(11) DEFAULT NULL COMMENT '进货赠送量',
  `advance_payment_amount` int(11) DEFAULT NULL COMMENT '预付款，单位：分',
  `quantity_unit` varchar(32) DEFAULT NULL COMMENT '单位',
  `out_price_type` varchar(64) DEFAULT NULL COMMENT '出库价格类型。last_import_price：以最近进货价出库；average_import_price：以平均进货价出库；sales_price：以商品销售价；trade_price：以商品批发价',
  `out_amount` int(11) DEFAULT NULL COMMENT '出库价，单位：分',
  `out_count` int(11) DEFAULT NULL COMMENT '出库量',
  `total_amount` int(11) DEFAULT NULL COMMENT '小计。即进货总价或出库总价',
  `operator_no` varchar(64) DEFAULT NULL COMMENT '操作员编号',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_TRAFFIC_NO` (`traffic_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='货流表';

/*Data for the table `goods_traffic` */

/*Table structure for table `member_info` */

DROP TABLE IF EXISTS `member_info`;

CREATE TABLE `member_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用。1：启用。0：不启用',
  `member_no` varchar(64) NOT NULL COMMENT '会员编号',
  `member_name` varchar(64) NOT NULL COMMENT '会员姓名',
  `member_rank` varchar(64) NOT NULL COMMENT '会员等级',
  `member_discount` int(11) NOT NULL DEFAULT '100' COMMENT '会员折扣。默认100即不打折，8.5折填85',
  `member_integral` double DEFAULT '0' COMMENT '会员积分',
  `phone` varchar(32) DEFAULT NULL COMMENT '联系电话',
  `password` varchar(32) DEFAULT NULL COMMENT '会员密码',
  `birthday` varchar(32) DEFAULT NULL COMMENT '会员生日',
  `is_on_credit` tinyint(1) DEFAULT '0' COMMENT '是否允许赊账。1：允许。0：不允许',
  `qq_no` varchar(32) DEFAULT NULL COMMENT 'qq号码',
  `email` varchar(32) DEFAULT NULL COMMENT '邮箱地址',
  `address` varchar(128) DEFAULT NULL COMMENT '地址',
  `account_balance` int(11) DEFAULT '0' COMMENT '账户余额，单位:分',
  `shopper_name` varchar(64) DEFAULT NULL COMMENT '导购员',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_MEMBER_NO` (`member_no`),
  KEY `IDX_PHONE` (`phone`),
  KEY `IDX_MEMBER_NAME` (`member_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `member_info` */

/*Table structure for table `member_integral` */

DROP TABLE IF EXISTS `member_integral`;

CREATE TABLE `member_integral` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否启用。1：启用。0：停用',
  `integral_type` tinyint(1) DEFAULT NULL COMMENT '预留。积分方式.1:按金额积分。0：按商品积分',
  `integral_value` int(11) DEFAULT NULL COMMENT '每多少元积一分',
  `exchange_type` tinyint(1) DEFAULT NULL COMMENT '预留。积分兑换方式。1：兑换礼品。0：抵扣现金',
  `is_clear` tinyint(1) DEFAULT '0' COMMENT '是否清空积分。1：清空。0：不清空',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员积分方式表';

/*Data for the table `member_integral` */

/*Table structure for table `member_rank` */

DROP TABLE IF EXISTS `member_rank`;

CREATE TABLE `member_rank` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `rank_title` varchar(128) NOT NULL COMMENT '等级名称',
  `discount` int(11) NOT NULL DEFAULT '100' COMMENT '优惠折扣，整数，8.5折填85',
  `is_integral` tinyint(1) DEFAULT '1' COMMENT '是否积分。1：积分。0：不计分',
  `is_auto_upgrade` tinyint(1) DEFAULT '0' COMMENT '是否自动升级。1：是。0：否',
  `integral_to_upgrade` int(11) DEFAULT NULL COMMENT '当积分到达该值时自动升级到该等级',
  `rank_period` tinyint(1) DEFAULT '0' COMMENT '该等级有效期。1：1年。0：永久',
  `prepaid_card_no` varchar(64) DEFAULT NULL COMMENT '预留。储值卡卡号',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员等级表';

/*Data for the table `member_rank` */

/*Table structure for table `member_recharge_detail` */

DROP TABLE IF EXISTS `member_recharge_detail`;

CREATE TABLE `member_recharge_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `member_no` varchar(64) NOT NULL COMMENT '会员编号',
  `member_name` varchar(64) NOT NULL COMMENT '会员名称',
  `rank_title` varchar(64) NOT NULL COMMENT '会员等级',
  `seller_no` varchar(32) NOT NULL COMMENT '收银员编号',
  `shopper_no` varchar(32) DEFAULT NULL COMMENT '导购编号',
  `recharge_amount` int(11) NOT NULL COMMENT '实际充值金额，单位:分',
  `donation_amount` int(11) DEFAULT NULL COMMENT '赠送金额，单位:分',
  `total_amount` int(11) NOT NULL COMMENT '充值总金额，单位:分',
  `pay_chenal` varchar(256) NOT NULL COMMENT 'JSON格式，支付方式及该方式对应的金额。金额单位：元。有可能是混合支付',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `member_recharge_detail` */

/*Table structure for table `operation_log` */

DROP TABLE IF EXISTS `operation_log`;

CREATE TABLE `operation_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `log_source` varchar(64) NOT NULL COMMENT '日志来源，收银端或后台管理端',
  `sub_system_type` varchar(64) NOT NULL COMMENT '子系统类型',
  `operator` varchar(64) NOT NULL COMMENT '操作人账号',
  `log_content` varchar(256) DEFAULT NULL COMMENT '日志内容',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间,即操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `operation_log` */

/*Table structure for table `promotion_detail` */

DROP TABLE IF EXISTS `promotion_detail`;

CREATE TABLE `promotion_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `promotion_name` varchar(128) NOT NULL COMMENT '促销名称',
  `promotion_type` varchar(64) NOT NULL COMMENT '预留，促销种类',
  `is_member_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否会员专享，1：是，0：不是',
  `is_member_discount_twice` tinyint(1) NOT NULL DEFAULT '0' COMMENT '会员是否折上折。1：是，0：否',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '促销开始日期',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '促销结束日期',
  `status` tinyint(1) NOT NULL COMMENT '状态。1为有效，0为无效。当过了促销结束日期以后该状态为无效',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='促销活动表';

/*Data for the table `promotion_detail` */

/*Table structure for table `promotion_goods_detail` */

DROP TABLE IF EXISTS `promotion_goods_detail`;

CREATE TABLE `promotion_goods_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `promotion_id` bigint(20) NOT NULL COMMENT 'promotion_detail表主键',
  `goods_id` bigint(20) NOT NULL COMMENT 'goods_info表主键',
  `bar_code` varchar(128) NOT NULL COMMENT '商品条码',
  `category_name` varchar(128) NOT NULL COMMENT '商品分类名称',
  `discount` double NOT NULL COMMENT '商品折扣，85折填85',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `promotion_goods_detail` */

/*Table structure for table `seller_info` */

DROP TABLE IF EXISTS `seller_info`;

CREATE TABLE `seller_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `part_of_shop` varchar(128) NOT NULL COMMENT '所属门店名',
  `seller_no` varchar(32) NOT NULL COMMENT '收银员编号，可用作登录名',
  `name` varchar(64) NOT NULL COMMENT '姓名',
  `role` varchar(64) DEFAULT NULL COMMENT '角色名称',
  `password` varchar(32) DEFAULT NULL COMMENT '收银员登录密码，明文存储',
  `phone` varchar(32) DEFAULT NULL COMMENT '电话',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态，1表示启用，0表示禁用',
  `cash_permission` varchar(2048) DEFAULT '[]' COMMENT 'JSON格式，收银端权限代码集合',
  `background_permission` varchar(2048) DEFAULT '[]' COMMENT 'JSON格式，后台管理系统权限代码集合',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `UQ_SELLER_NO` (`seller_no`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

/*Data for the table `seller_info` */

insert  into `seller_info`(`id`,`part_of_shop`,`seller_no`,`name`,`role`,`password`,`phone`,`status`,`cash_permission`,`background_permission`,`gmt_update`,`gmt_create`) values (1,'小熊维尼的糖果店','1001','维尼','seller','123','88886666',0,'[]','[]','2018-05-21 21:27:56','2018-04-19 11:04:06');

/*Table structure for table `seller_permission_info` */

DROP TABLE IF EXISTS `seller_permission_info`;

CREATE TABLE `seller_permission_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `type` tinyint(1) NOT NULL COMMENT '权限种类，0：收银端，1：后台管理',
  `permission_code` varchar(32) NOT NULL COMMENT '权限代码',
  `permission_name` varchar(64) NOT NULL COMMENT '权限名称',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `seller_permission_info` */

/*Table structure for table `shopper_info` */

DROP TABLE IF EXISTS `shopper_info`;

CREATE TABLE `shopper_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `shopper_no` varchar(32) NOT NULL COMMENT '导购员编号',
  `name` varchar(64) NOT NULL COMMENT '导购姓名',
  `phone` varchar(32) DEFAULT NULL COMMENT '电话',
  `sales_percentage` double DEFAULT NULL COMMENT '销售提成。如5.3%则填5.3',
  `recharge_percentage` double DEFAULT NULL COMMENT '充值提成。如5.3%则填5.3',
  `shopping_card_percentage` double DEFAULT NULL COMMENT '购物卡提成。如5.3%则填5.3',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态.1：启用。0：停用',
  `royalty_type` varchar(128) DEFAULT NULL COMMENT '提成方式',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `UQ_SHOPPER_NO` (`shopper_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `shopper_info` */

/*Table structure for table `supplier_info` */

DROP TABLE IF EXISTS `supplier_info`;

CREATE TABLE `supplier_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `supplier_code` varchar(64) NOT NULL COMMENT '供货商编号',
  `supplier_name` varchar(128) NOT NULL COMMENT '供货商名称',
  `pinyin_code` varchar(128) DEFAULT NULL COMMENT '拼音码，即名称首字母组合',
  `contact_name` varchar(64) DEFAULT NULL COMMENT '联系人',
  `contact_phone` varchar(64) DEFAULT NULL COMMENT '联系电话',
  `contact_email` varchar(64) DEFAULT NULL COMMENT '联系邮箱',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态。1：启用，0：禁用',
  `delivery_rebate` double DEFAULT NULL COMMENT '配送费返点',
  `regular_rebate` double DEFAULT NULL COMMENT '固定返利点',
  `supplier_address` varchar(256) DEFAULT NULL COMMENT '地址',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_SUPPLIER_NAME` (`supplier_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `supplier_info` */

/*Table structure for table `system_parameter` */

DROP TABLE IF EXISTS `system_parameter`;

CREATE TABLE `system_parameter` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `param_code` varchar(64) NOT NULL COMMENT '参数代码',
  `param_value` varchar(128) DEFAULT NULL COMMENT '参数值',
  `description` varchar(128) DEFAULT NULL COMMENT '参数描述',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_PARAM_CODE` (`param_code`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

/*Data for the table `system_parameter` */

insert  into `system_parameter`(`id`,`param_code`,`param_value`,`description`,`gmt_update`,`gmt_create`) values (1,'SHOP_NAME',NULL,'商店名称','2018-05-27 17:04:21','2018-04-23 21:44:25'),(3,'PETTY_AMOUNT','false','备用金开关，true为启用,false为不启用','2018-05-23 10:32:08','2018-05-02 17:31:34'),(5,'REGISTER_TIME',NULL,'注册时间','2018-05-27 17:04:21','2018-05-18 14:39:26'),(6,'INVALID_TIME',NULL,'有效期截止时间','2018-05-27 17:04:21','2018-05-18 14:44:08'),(7,'RELATED_EMAIL',NULL,'绑定邮箱','2018-05-27 17:04:21','2018-05-18 14:45:42'),(8,'PHONE',NULL,'联系电话','2018-05-27 17:04:21','2018-05-18 14:48:47'),(9,'ADDRESS',NULL,'联系地址','2018-05-27 17:04:21','2018-05-18 14:49:33'),(10,'IS_AUTHORIZED','false','系统是否已授权，true为已授权，false为未授权','2018-05-22 10:45:34','2018-05-18 14:59:16'),(11,'IS_INIT','false','系统是否初始化，true为已初始化，false为未初始化','2018-05-27 17:04:21','2018-05-22 10:44:49'),(12,'RECEIPT_WIDTH','580','收银小票宽度，分为580和800两种','2018-05-26 15:11:21','0000-00-00 00:00:00');

/*Table structure for table `trade_detail` */

DROP TABLE IF EXISTS `trade_detail`;

CREATE TABLE `trade_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `trade_no` varchar(64) NOT NULL COMMENT '流水号，唯一确定一笔交易，规则为年月日时分秒毫秒',
  `trade_time` timestamp NULL DEFAULT NULL COMMENT '交易完成时间',
  `trade_type` varchar(32) NOT NULL COMMENT '交易类型。SALES：销售。REFUND：退款',
  `member_no` varchar(64) DEFAULT NULL COMMENT '会员编号',
  `member_name` varchar(64) DEFAULT NULL COMMENT '会员姓名',
  `goods_count` int(11) NOT NULL COMMENT '商品数量。退款为负',
  `total_amount` int(11) NOT NULL COMMENT '商品原价之和，单位：分。退款为负',
  `goods_discount` int(11) NOT NULL DEFAULT '100' COMMENT '商品折扣，如9.8折就填98.默认100即不打折',
  `total_actual_amount` int(11) NOT NULL COMMENT '商品实收之和，单位：分。退款为负',
  `profit_amount` int(11) NOT NULL COMMENT '利润，单位：分。退款为负',
  `seller_no` varchar(32) NOT NULL COMMENT '收银员编号',
  `shopper_no` varchar(64) DEFAULT NULL COMMENT '导购员编号',
  `goods_detail` varchar(2048) DEFAULT NULL COMMENT 'JSON格式，商品明细。包含商品名称、商品条码、颜色、尺寸、数量、原价、实收、利润、导购员字段',
  `pay_chenal` varchar(256) NOT NULL COMMENT 'JSON格式，支付方式及该方式对应的金额。金额单位：元。有可能是混合支付',
  `is_exchange_job` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否交接班。1：已交接。0：未交接',
  `exchange_job_id` bigint(20) DEFAULT NULL COMMENT '交接班序号，对应交接班表主键id',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改日期',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建日期',
  PRIMARY KEY (`id`),
  UNIQUE KEY `INX_TRADE_NO` (`trade_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `trade_detail` */

/*Table structure for table `trade_goods_detail` */

DROP TABLE IF EXISTS `trade_goods_detail`;

CREATE TABLE `trade_goods_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `trade_no` varchar(64) NOT NULL COMMENT '流水号，关联trade_detail表',
  `trade_time` timestamp NULL DEFAULT NULL COMMENT '交易完成时间',
  `trade_type` varchar(32) NOT NULL COMMENT '交易类型。sales：销售。refund：退款',
  `goods_name` varchar(256) DEFAULT NULL COMMENT '商品名称',
  `goods_brand` varchar(128) DEFAULT NULL COMMENT '商品品牌',
  `bar_code` varchar(128) DEFAULT NULL COMMENT '商品条码，唯一标识一件商品',
  `product_number` varchar(128) DEFAULT NULL COMMENT '商品货号',
  `goods_color` varchar(64) DEFAULT NULL COMMENT '商品颜色',
  `goods_size` varchar(64) DEFAULT NULL COMMENT '商品尺码',
  `goods_count` int(11) DEFAULT NULL COMMENT '商品数量，退款为负',
  `goods_tag` varchar(128) DEFAULT NULL COMMENT '商品标签，半角逗号分隔开',
  `category_name` varchar(128) DEFAULT NULL COMMENT '商品分类名称',
  `seller_no` varchar(32) DEFAULT NULL COMMENT '收银员编号',
  `shopper_no` varchar(64) DEFAULT NULL COMMENT '导购员编号',
  `supplier_name` varchar(128) DEFAULT NULL COMMENT '供货商名称',
  `total_amount` int(11) NOT NULL COMMENT '商品原价，单位：分。退款为负',
  `goods_discount` int(100) NOT NULL COMMENT '商品折扣，如9.8折就填98.默认100即不打折',
  `total_actual_amount` int(11) NOT NULL COMMENT '商品实收，单位：分。退款为负',
  `profit_amount` int(11) NOT NULL COMMENT '利润，单位：分。退款为负',
  `gmt_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `gmt_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_TRADE_NO` (`trade_no`),
  KEY `IDX_BAR_CODE` (`bar_code`),
  KEY `IDX_GOODS_TAG` (`goods_tag`),
  KEY `IDX_SELLER_NO` (`seller_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `trade_goods_detail` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;