INSERT INTO `orderitem` (`id`, `order_id`, `goods`, `goods_name`, `selling`, `unit`, `amount`, `actual`, `actual_unit`, `is_replenish`, `remark`) VALUES
(4221, 714, 314, '菜心本地', '0.00', '斤', 10.0, 10.00, '斤', 0, ''),
(4222, 714, 122, '长白菜', '0.00', '斤', 2.0, 2.00, '斤', 0, ''),
(4223, 714, 111, '芥菜', '0.00', '斤', 15.0, 15.00, '斤', 0, ''),
(4224, 714, 42, '芹菜', '0.00', '斤', 64.0, 64.00, '斤', 0, ''),
(4225, 714, 642, '土芹', '0.00', '斤', 70.0, 70.00, '斤', 0, ''),
(4226, 714, 114, '香菜', '0.00', '斤', 9.0, 9.00, '斤', 0, ''),
(4227, 714, 115, '小白菜', '0.00', '斤', 113.0, 113.00, '斤', 0, ''),
(4228, 714, 117, '油麦菜', '0.00', '斤', 137.0, 137.00, '斤', 0, ''),
(4229, 715, 740, '萝卜丁', '1.50', '斤', 4.0, 4.00, '斤', 0, ''),
(4230, 715, 576, '萝卜干', '1.50', '斤', 9.0, 9.00, '斤', 0, ''),
(4231, 715, 1096, '泡椒黄色', '3.50', '斤', 2.0, 2.00, '斤', 0, ''),
(4232, 715, 578, '酸菜', '1.30', '斤', 64.0, 74.00, '斤', 0, ''),
(4233, 715, 581, '酸豆角', '2.20', '斤', 24.0, 24.00, '斤', 0, ''),
(4234, 715, 696, '酸芥菜', '1.30', '斤', 40.0, 40.00, '斤', 0, ''),
(4235, 715, 601, '酸辣椒', '3.50', '斤', 7.0, 7.00, '斤', 0, ''),
(4236, 715, 602, '酸萝卜', '1.50', '斤', 10.0, 10.00, '斤', 0, ''),
(4237, 715, 615, '酸笋', '2.00', '斤', 31.0, 26.00, '斤', 0, ''),
(4238, 715, 634, '甜笋', '2.00', '斤', 25.0, 30.00, '斤', 0, ''),
(4239, 702, 331, '牛肉', '33.00', '斤', 1.0, 1.00, '斤', 1, ''),
(4240, 716, 118, '菠菜', '2.00', '斤', 18.0, 18.00, '斤', 0, ''),
(4241, 716, 43, '菜花', '0.60', '斤', 575.0, 575.00, '斤', 0, ''),
(4242, 716, 314, '菜心本地', '0.90', '斤', 10.0, 10.00, '斤', 0, ''),
(4243, 716, 122, '长白菜', '1.20', '斤', 2.0, 3.00, '斤', 0, ''),
(4244, 716, 111, '芥菜', '2.50', '斤', 15.0, 15.00, '斤', 0, ''),
(4245, 716, 42, '芹菜', '0.00', '斤', 64.0, 64.00, '斤', 0, ''),
(4246, 716, 642, '土芹', '2.20', '斤', 70.0, 137.00, '斤', 0, ''),
(4247, 716, 114, '香菜', '4.50', '斤', 9.0, 12.50, '斤', 0, ''),
(4248, 716, 115, '小白菜', '0.70', '斤', 113.0, 113.00, '斤', 0, ''),
(4249, 716, 117, '油麦菜', '1.30', '斤', 137.0, 137.00, '斤', 0, ''),
(4250, 716, 1097, '补单芥菜', '2.50', '斤', 4.0, 4.00, '斤', 0, ''),
(4251, 716, 1098, '补单老菜', '0.90', '斤', 10.0, 10.00, '斤', 0, ''),
(4252, 713, 535, '金针菇', '3.50', '斤', 15.0, 15.00, '斤', 1, ''),
(4253, 717, 352, '部队腿肉', '10.50', '斤', 8.0, 8.00, '斤', 0, ''),
(4254, 717, 353, '部队五花', '10.50', '斤', 115.0, 115.00, '斤', 0, ''),
(4255, 717, 359, '部队肉片', '11.00', '斤', 23.0, 23.00, '斤', 0, ''),
(4256, 717, 401, '部队肉末', '11.00', '斤', 30.0, 30.00, '斤', 0, ''),
(4257, 717, 356, '部队里脊', '12.00', '斤', 2.0, 2.00, '斤', 0, ''),
(4258, 717, 375, '部队猪脚', '10.80', '斤', 122.0, 122.00, '斤', 0, ''),
(4259, 717, 358, '部队肉丝', '11.00', '斤', 4.0, 4.00, '斤', 0, ''),
(4260, 717, 360, '部队肥肉', '7.00', '斤', 2.0, 2.00, '斤', 0, ''),
(4261, 717, 543, '部队筒骨', '10.00', '斤', 1.0, 1.00, '斤', 0, ''),
(4262, 717, 362, '师大瘦肉', '11.06', '斤', 185.0, 185.00, '斤', 0, ''),
(4263, 717, 363, '师大五花', '10.21', '斤', 71.5, 71.50, '斤', 0, ''),
(4264, 717, 364, '师大里脊', '11.06', '斤', 91.0, 91.00, '斤', 0, ''),
(4265, 717, 373, '师大腿肉', '10.21', '斤', 5.0, 5.00, '斤', 0, ''),
(4266, 717, 367, '师大血口', '5.96', '斤', 22.5, 22.50, '斤', 0, ''),
(4267, 717, 365, '师大碎排', '8.00', '斤', 20.0, 20.00, '斤', 0, ''),
(4268, 717, 366, '师大猪脚', '10.21', '斤', 21.5, 21.50, '斤', 0, ''),
(4269, 717, 368, '师大猪肝', '11.91', '斤', 11.0, 11.00, '斤', 0, ''),
(4270, 717, 369, '师大大肠', '6.81', '斤', 13.0, 13.00, '斤', 0, ''),
(4271, 717, 919, '师大二股肠', '8.00', '斤', 10.0, 10.00, '斤', 0, ''),
(4272, 717, 370, '师大小肠', '6.81', '斤', 2.0, 2.00, '斤', 0, ''),
(4273, 717, 371, '师大猪肺', '5.11', '斤', 4.0, 4.00, '斤', 0, ''),
(4274, 717, 469, '师大肉末', '11.00', '斤', 3.0, 3.00, '斤', 0, ''),
(4275, 703, 198, '去皮甘蔗', '0.00', '斤', 15.0, 15.00, '斤', 0, ''),
(4276, 718, 1099, '大桶生抽', '80.00', '件', 4.0, 4.00, '件', 0, ''),
(4277, 718, 1042, '大桶耗油', '70.00', '件', 4.0, 4.00, '件', 0, ''),
(4278, 718, 1100, '袋装生抽', '48.00', '件', 3.0, 3.00, '件', 0, ''),
(4279, 718, 99, '洗洁精', '25.00', '桶', 2.0, 2.00, '桶', 0, ''),
(4280, 718, 1101, '挂面', '75.00', '件', 1.0, 1.00, '件', 0, ''),
(4281, 718, 1102, '大袋盐', '65.00', '件', 1.0, 1.00, '件', 0, ''),
(4282, 717, 355, '部队子排', '17.50', '斤', 4.0, 4.00, '斤', 0, ''),
(4304, 722, 610, '莲藕', '2.00', '斤', 3.0, 3.00, '斤', 0, ''),
(4305, 722, 1118, '小盒酸奶', '12.50', '排', 3.0, 3.00, '排', 0, ''),
(4306, 722, 74, '千张', '5.00', '斤', 4.0, 4.00, '斤', 0, ''),
(4307, 722, 1090, '豆腐', '0.70', '块', 200.0, 200.00, '块', 0, ''),
(4308, 722, 340, '老婆饼', '5.00', '斤', 2.0, 7.00, '盒', 0, ''),
(4309, 722, 1119, '四季豆腐丝', '4.00', '斤', 4.0, 4.00, '斤', 0, ''),
(4310, 722, 710, '五香豆腐', '2.50', '斤', 44.0, 44.00, '斤', 0, ''),
(4311, 722, 66, '水豆腐', '16.00', '板', 6.5, 6.50, '板', 0, ''),
(4312, 722, 66, '水豆腐', '0.30', '块', 40.0, 40.00, '块', 0, ''),
(4313, 722, 1120, '豆腐脑', '20.00', '盒', 1.0, 1.00, '盒', 0, ''),
(4314, 706, 1121, '补单大红椒', '4.00', '斤', 22.0, 22.00, '斤', 0, ''),
(4315, 706, 1122, '补单子姜', '3.50', '斤', 11.0, 11.00, '斤', 0, '');

-- --------------------------------------------------------

--
-- 表的结构 `purchasingorder`
--

CREATE TABLE `purchasingorder` (
  `id` int(11) NOT NULL,
  `seller` int(11) NOT NULL COMMENT '卖家',
  `buyer` int(11) NOT NULL COMMENT '买家',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态:0-订单取消,1-下单成功,2-报价完成',
  `trade_no` varchar(20) NOT NULL COMMENT '订单号',
  `wid` int(11) NOT NULL COMMENT '下单人',
  `total` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
  `amount` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总数',
  `remark` varchar(88) NOT NULL COMMENT '特别叮嘱',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `delivery_date` date DEFAULT NULL COMMENT '配送时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单';

--
-- 转存表中的数据 `purchasingorder`
--

INSERT INTO `purchasingorder` (`id`, `seller`, `buyer`, `status`, `trade_no`, `wid`, `total`, `amount`, `remark`, `create_time`, `delivery_date`) VALUES
(1, 1, 1, 4, 'DC04927472510315', 9, '524.00', 6, '手写一份配送单', '2017-12-04 21:05:47', '2017-12-05'),
(2, 4, 1, 2, 'DC04928051663860', 9, '2700.00', 3, '手写一份配送单', '2017-12-04 21:06:45', '2017-12-05'),
(4, 2, 1, 2, 'DC05276541162418', 9, '44.00', 2, '', '2017-12-05 06:47:34', '2017-12-05'),
(8, 8, 1, 2, 'DC05824462858179', 5, '125.80', 6, '魔芋豆腐10+5。香干3+6。千张4+4。', '2017-12-05 22:00:46', '2017-12-06'),
(9, 9, 1, 2, 'DC05825068059442', 9, '339.50', 3, '', '2017-12-05 22:01:46', '2017-12-06'),
(10, 4, 1, 2, 'DC05825369840111', 9, '2530.00', 1, '', '2017-12-05 22:02:16', '2017-12-06'),
(11, 1, 1, 4, 'DC05825859379789', 9, '850.00', 2, '桂龙大碗面', '2017-12-05 22:03:05', '2017-12-06'),
(12, 3, 1, 2, 'DC05826233950560', 9, '190.00', 1, '', '2017-12-05 22:03:43', '2017-12-06'),
(13, 8, 1, 2, 'DC05859088482289', 5, '28.00', 1, '', '2017-12-05 22:58:28', '2017-12-01'),
(14, 8, 1, 2, 'DC05860130907257', 5, '46.50', 4, '', '2017-12-05 23:00:13', '2017-12-02'),
(15, 8, 1, 2, 'DC05860705640499', 5, '66.50', 3, '', '2017-12-05 23:01:10', '2017-12-03'),
(16, 8, 1, 2, 'DC05861247826016', 5, '86.00', 3, '', '2017-12-05 23:02:04', '2017-12-04'),
(17, 8, 1, 2, 'DC05862046079688', 5, '441.50', 4, '', '2017-12-05 23:03:24', '2017-12-05'),
(18, 9, 1, 2, 'DC05866374614472', 5, '301.00', 3, '', '2017-12-05 23:10:37', '2017-12-02'),
(19, 9, 1, 2, 'DC05867238285602', 5, '308.00', 3, '', '2017-12-05 23:12:03', '2017-12-03'),
(20, 9, 1, 2, 'DC05867876016039', 5, '304.50', 3, '', '2017-12-05 23:13:07', '2017-12-04'),
(21, 9, 1, 2, 'DC05868683306920', 5, '304.50', 3, '', '2017-12-05 23:14:28', '2017-12-05'),
(22, 1, 1, 2, 'DC05872803184912', 5, '170.00', 2, '', '2017-12-05 23:21:20', '2017-12-01'),
(23, 1, 1, 2, 'DC05873999145473', 5, '2980.00', 2, '', '2017-12-05 23:23:19', '2017-12-02'),
(24, 1, 1, 2, 'DC05875137427638', 5, '308.00', 4, '', '2017-12-05 23:25:13', '2017-12-03'),
(25, 1, 1, 2, 'DC05876783136399', 5, '216.00', 3, '', '2017-12-05 23:27:58', '2017-12-03'),
(26, 1, 1, 2, 'DC06653240534790', 9, '295.00', 3, '蒸肉粉是粉蒸肉粉', '2017-12-06 21:02:04', '2017-12-07'),
(27, 8, 1, 2, 'DC06654111871262', 9, '70.00', 2, '千张是3+5。    香干是5+2+2+3', '2017-12-06 21:03:31', '2017-12-07'),
(28, 9, 1, 2, 'DC06654377837198', 9, '360.50', 3, '饺子皮是7+2。云吞皮是40+4', '2017-12-06 21:03:57', '2017-12-07'),
(30, 4, 1, 2, 'DC06656290320894', 9, '405.00', 2, '', '2017-12-06 21:07:09', '2017-12-07'),
(31, 2, 1, 2, 'DC07971902097977', 9, '90.00', 1, '2+2+2+2+2', '2017-12-07 05:53:10', '2017-12-07'),
(36, 1, 1, 4, 'DC07471080292204', 9, '530.00', 3, '', '2017-12-07 19:45:08', '2017-12-08'),
(37, 9, 1, 2, 'DC07471605656021', 9, '23.50', 2, '', '2017-12-07 19:46:00', '2017-12-08'),
(38, 8, 1, 2, 'DC07472039588967', 9, '69.00', 5, '', '2017-12-07 19:46:43', '2017-12-08'),
(39, 2, 1, 2, 'DC08862228774322', 9, '35.00', 1, '', '2017-12-08 06:37:02', '2017-12-08'),
(44, 1, 1, 2, 'DC08343464414046', 9, '110.00', 2, '', '2017-12-08 19:59:06', '2017-12-09'),
(45, 8, 1, 4, 'DC08343986233368', 9, '59.00', 5, '', '2017-12-08 19:59:58', '2017-12-09'),
(46, 10, 1, 2, 'DC08356308277928', 9, '2400.10', 9, '', '2017-12-08 20:20:30', '2017-12-01'),
(47, 10, 1, 2, 'DC08364551285280', 9, '1728.40', 12, '', '2017-12-08 20:34:15', '2017-12-02'),
(48, 10, 1, 2, 'DC08371001636426', 9, '1723.20', 11, '', '2017-12-08 20:45:00', '2017-12-03'),
(49, 10, 1, 2, 'DC08402629424986', 9, '2269.75', 12, '', '2017-12-08 21:37:42', '2017-12-04'),
(50, 10, 1, 2, 'DC08405401580151', 9, '2497.20', 11, '', '2017-12-08 21:42:20', '2017-12-05'),
(51, 10, 1, 2, 'DC08409172964031', 9, '2438.60', 11, '', '2017-12-08 21:48:37', '2017-12-06'),
(52, 10, 1, 2, 'DC08411966282829', 9, '2220.40', 10, '', '2017-12-08 21:53:16', '2017-12-07'),
(53, 10, 1, 2, 'DC08414479063949', 9, '2345.10', 11, '', '2017-12-08 21:57:27', '2017-12-08'),
(54, 10, 1, 4, 'DC08440109598198', 9, '1822.70', 15, '', '2017-12-08 22:40:10', '2017-12-09'),
(55, 2, 1, 2, 'DC08454384623371', 9, '42.00', 2, '', '2017-12-08 23:03:58', '2017-12-09'),
(57, 0, 1, 2, 'DC09846158291859', 10, '180.00', 1, '', '2017-12-09 09:56:55', '2017-12-09'),
(58, 3, 1, 2, 'DC09054913019847', 9, '1390.00', 2, '', '2017-12-09 15:44:51', '2017-12-02'),
(59, 3, 1, 2, 'DC09055665915455', 9, '265.00', 2, '', '2017-12-09 15:46:06', '2017-12-04'),
(60, 3, 1, 2, 'DC09058425235721', 9, '70.00', 1, '', '2017-12-09 15:50:42', '2017-12-01'),
(62, 0, 1, 2, 'DC09066733213686', 10, '22.00', 2, '', '2017-12-09 16:04:33', '2017-12-01'),
(63, 0, 1, 4, 'DC09069531904332', 10, '65.40', 5, '', '2017-12-09 16:09:13', '2017-12-03'),
(64, 0, 1, 2, 'DC09072872876115', 10, '299.00', 9, '', '2017-12-09 16:14:47', '2017-12-04'),
(65, 0, 1, 4, 'DC09075298464676', 10, '806.00', 10, '', '2017-12-09 16:18:49', '2017-12-05'),
(66, 0, 1, 2, 'DC09076950709384', 10, '60.50', 3, '', '2017-12-09 16:21:35', '2017-12-06'),
(67, 0, 1, 2, 'DC09082807160499', 10, '44.50', 3, '', '2017-12-09 16:31:20', '2017-12-07'),
(68, 0, 1, 2, 'DC09084111663486', 10, '94.00', 6, '', '2017-12-09 16:33:31', '2017-12-08'),
(69, 8, 1, 2, 'DC09332608495824', 9, '20.00', 2, '', '2017-12-09 23:27:40', '2017-12-10'),
(70, 10, 1, 2, 'DC09336280516335', 9, '1898.10', 11, '早点送货，主意质量！', '2017-12-09 23:33:48', '2017-12-10'),
(71, 8, 1, 2, 'DC10182190746418', 9, '64.25', 3, '', '2017-12-10 23:03:39', '2017-12-11'),
(72, 1, 1, 2, 'DC10182841152537', 9, '3875.00', 3, '', '2017-12-10 23:04:44', '2017-12-11'),
(73, 10, 1, 2, 'DC10185972949477', 9, '2241.30', 12, '时间提早一些，主意供应菜的质量', '2017-12-10 23:09:57', '2017-12-11'),
(74, 2, 1, 2, 'DC11489761136893', 9, '88.00', 4, '', '2017-12-11 07:36:16', '2017-12-11'),
(75, 0, 1, 2, 'DC11505075724574', 10, '24.00', 1, '', '2017-12-11 08:01:47', '2017-12-10'),
(76, 0, 1, 2, 'DC11513445132890', 10, '141.00', 8, '', '2017-12-11 08:15:44', '2017-12-11'),
(89, 14, 1, 2, 'DC11986743600057', 9, '272.00', 5, '', '2017-12-11 21:24:34', '2017-12-01'),
(90, 14, 1, 2, 'DC11991153182762', 9, '75.00', 1, '', '2017-12-11 21:31:55', '2017-12-02'),
(91, 14, 1, 2, 'DC11996102470725', 9, '93.80', 4, '', '2017-12-11 21:40:10', '2017-12-03'),
(92, 14, 1, 2, 'DC11998875758029', 9, '180.20', 7, '', '2017-12-11 21:44:47', '2017-12-04'),
(93, 14, 1, 2, 'DC11001855795753', 9, '110.80', 3, '', '2017-12-11 21:49:45', '2017-12-05'),
(94, 14, 1, 2, 'DC11003844392447', 9, '242.40', 4, '', '2017-12-11 21:53:04', '2017-12-06'),
(95, 13, 1, 2, 'DC11003892152443', 8, '101.80', 6, '', '2017-12-11 21:53:09', '2017-12-01'),
(96, 14, 1, 2, 'DC11007028597447', 9, '28.00', 1, '', '2017-12-11 21:58:22', '2017-12-07'),
(97, 13, 1, 2, 'DC11007343632981', 8, '260.10', 8, '', '2017-12-11 21:58:54', '2017-12-03'),
(98, 11, 2, 2, 'DC11008203237273', 26, '990.95', 5, '', '2017-12-11 22:00:20', '2017-12-12'),
(99, 14, 1, 2, 'DC11008659573892', 9, '151.80', 4, '', '2017-12-11 22:01:05', '2017-12-08'),
(100, 13, 1, 2, 'DC11010817137117', 8, '327.90', 10, '', '2017-12-11 22:04:41', '2017-12-04'),
(101, 14, 1, 2, 'DC11011443288636', 9, '80.20', 3, '', '2017-12-11 22:05:44', '2017-12-09'),
(102, 13, 1, 2, 'DC11012299892784', 8, '117.50', 6, '', '2017-12-11 22:07:09', '2017-12-05'),
(103, 13, 1, 4, 'DC11014748780167', 8, '290.50', 10, '放516车', '2017-12-11 22:11:14', '2017-12-07'),
(104, 14, 1, 2, 'DC11015691669943', 9, '131.20', 3, '', '2017-12-11 22:12:49', '2017-12-10'),
(105, 14, 1, 2, 'DC11017591012541', 9, '170.60', 3, '', '2017-12-11 22:15:59', '2017-12-11'),
(106, 13, 1, 2, 'DC11022597110793', 8, '240.50', 10, '放516车', '2017-12-11 22:24:19', '2017-12-08'),
(107, 13, 1, 2, 'DC11023782004821', 8, '101.20', 4, '放516车', '2017-12-11 22:26:18', '2017-12-09'),
(108, 13, 1, 2, 'DC11027100809621', 8, '214.70', 4, '放516车', '2017-12-11 22:31:50', '2017-12-10'),
(109, 13, 1, 2, 'DC11028372538326', 8, '234.10', 10, '', '2017-12-11 22:33:57', '2017-12-11'),
(110, 14, 1, 2, 'DC11036935457672', 9, '172.00', 3, '', '2017-12-11 22:48:13', '2017-12-12'),
(111, 13, 1, 2, 'DC11038595486819', 9, '57.00', 2, '', '2017-12-11 22:50:59', '2017-12-12'),
(112, 10, 1, 4, 'DC11046027470284', 9, '2330.30', 10, '', '2017-12-11 23:03:22', '2017-12-12'),
(113, 13, 1, 2, 'DC11052973104324', 9, '240.75', 6, '', '2017-12-11 23:14:57', '2017-12-06'),
(114, 8, 1, 2, 'DC11056599000384', 9, '336.75', 5, '', '2017-12-11 23:20:59', '2017-12-12'),
(115, 3, 1, 2, 'DC11057322269555', 9, '140.00', 1, '', '2017-12-11 23:22:12', '2017-12-12'),
(116, 0, 1, 3, 'DC12364743303946', 23, '163.80', 2, '', '2017-12-12 07:54:34', '2017-12-01'),
(117, 0, 1, 2, 'DC12367648386280', 23, '19.50', 1, '', '2017-12-12 07:59:24', '2017-12-02'),
(118, 0, 1, 2, 'DC12367975068611', 23, '160.50', 3, '', '2017-12-12 07:59:57', '2017-12-03'),
(119, 0, 1, 2, 'DC12371388559118', 23, '359.20', 2, '', '2017-12-12 08:05:38', '2017-12-09'),
(120, 0, 1, 4, 'DC12375641837696', 10, '416.50', 6, '', '2017-12-12 08:12:44', '2017-12-12'),
(121, 0, 1, 2, 'DC12375990161678', 23, '338.80', 1, '', '2017-12-12 08:13:19', '2017-12-10'),
(122, 0, 1, 2, 'DC12376710677531', 10, '0.00', 1, '', '2017-12-12 08:14:31', '2017-12-12'),
(124, 17, 1, 2, 'DC12724511759133', 9, '550.00', 1, '', '2017-12-12 17:54:11', '2017-12-02'),
(125, 17, 1, 2, 'DC12725030808924', 9, '65.00', 1, '', '2017-12-12 17:55:03', '2017-12-03'),
(126, 17, 1, 2, 'DC12725450014401', 9, '175.00', 2, '', '2017-12-12 17:55:45', '2017-12-05'),
(127, 17, 1, 2, 'DC12726183185806', 9, '1410.00', 3, '', '2017-12-12 17:56:58', '2017-12-07'),
(128, 17, 1, 2, 'DC12726563815107', 9, '240.00', 1, '', '2017-12-12 17:57:36', '2017-12-10'),
(129, 17, 1, 2, 'DC12726890519692', 9, '1200.00', 1, '', '2017-12-12 17:58:09', '2017-12-11'),
(130, 18, 1, 2, 'DC12737771244778', 9, '1457.00', 3, '', '2017-12-12 18:16:17', '2017-12-01'),
(131, 18, 1, 2, 'DC12741951966033', 9, '242.50', 3, '', '2017-12-12 18:23:15', '2017-12-02'),
(132, 18, 1, 2, 'DC12743560952103', 9, '480.00', 3, '', '2017-12-12 18:25:56', '2017-12-03'),
(133, 18, 1, 2, 'DC12752696196458', 9, '232.10', 3, '', '2017-12-12 18:41:09', '2017-12-04'),
(134, 18, 1, 2, 'DC12759705479768', 5, '89.00', 4, '机场部队', '2017-12-12 18:52:50', '2017-12-05'),
(135, 15, 1, 2, 'DC12760043105648', 9, '2172.95', 10, '', '2017-12-12 18:53:24', '2017-12-01'),
(136, 18, 1, 2, 'DC12762036929642', 5, '135.50', 3, '', '2017-12-12 18:56:43', '2017-12-07'),
(137, 18, 1, 2, 'DC12765432134692', 5, '988.50', 6, '', '2017-12-12 19:02:23', '2017-12-09'),
(138, 18, 1, 2, 'DC12766045952910', 5, '56.00', 2, '', '2017-12-12 19:03:24', '2017-12-10'),
(139, 15, 1, 2, 'DC12766398173874', 9, '82.50', 1, '', '2017-12-12 19:03:59', '2017-12-02'),
(140, 18, 1, 2, 'DC12766610620469', 5, '95.00', 2, '', '2017-12-12 19:04:21', '2017-12-11'),
(141, 15, 1, 2, 'DC12768998391786', 9, '848.00', 8, '', '2017-12-12 19:08:19', '2017-12-03'),
(142, 15, 1, 2, 'DC12777012816983', 9, '609.50', 5, '', '2017-12-12 19:21:41', '2017-12-04'),
(143, 15, 1, 2, 'DC12780771468576', 9, '1735.50', 8, '', '2017-12-12 19:27:57', '2017-12-05'),
(144, 15, 1, 2, 'DC12783815777546', 9, '480.75', 3, '', '2017-12-12 19:33:01', '2017-12-06'),
(145, 15, 1, 2, 'DC12787807361642', 9, '1952.00', 5, '', '2017-12-12 19:39:40', '2017-12-07'),
(146, 4, 1, 2, 'DC12787907441777', 5, '3925.00', 2, '', '2017-12-12 19:39:50', '2017-12-13'),
(147, 15, 1, 2, 'DC12792004264436', 9, '1315.50', 7, '', '2017-12-12 19:46:40', '2017-12-08'),
(148, 1, 1, 4, 'DC12792149312847', 5, '589.00', 9, '', '2017-12-12 19:46:54', '2017-12-13'),
(149, 3, 1, 2, 'DC12792820537831', 5, '1180.00', 3, '', '2017-12-12 19:48:02', '2017-12-13'),
(150, 8, 1, 2, 'DC12794826706341', 5, '114.00', 5, '', '2017-12-12 19:51:22', '2017-12-13'),
(151, 15, 1, 2, 'DC12795510278929', 9, '978.00', 6, '', '2017-12-12 19:52:31', '2017-12-09'),
(152, 15, 1, 2, 'DC12798515515134', 9, '567.00', 5, '', '2017-12-12 19:57:31', '2017-12-10'),
(153, 15, 1, 2, 'DC12802302388000', 9, '1460.50', 5, '', '2017-12-12 20:03:50', '2017-12-11'),
(154, 15, 1, 2, 'DC12805297274865', 9, '1360.00', 9, '', '2017-12-12 20:08:49', '2017-12-12'),
(155, 18, 1, 2, 'DC12809944964340', 9, '1685.00', 2, '早点送到', '2017-12-12 20:16:34', '2017-12-13'),
(156, 16, 1, 2, 'DC12815419379883', 9, '784.50', 3, '控制好质量', '2017-12-12 20:25:41', '2017-12-13'),
(157, 15, 1, 2, 'DC12817889940563', 5, '733.20', 9, '', '2017-12-12 20:29:48', '2017-12-13'),
(158, 18, 1, 2, 'DC12819274841921', 9, '364.50', 2, '', '2017-12-12 20:32:07', '2017-12-12'),
(159, 19, 1, 2, 'DC12822486468135', 5, '1461.00', 7, '', '2017-12-12 20:37:28', '2017-12-13'),
(160, 14, 1, 2, 'DC12825952110906', 5, '3279.60', 4, '', '2017-12-12 20:43:15', '2017-12-13'),
(161, 13, 1, 2, 'DC12826416127996', 9, '338.50', 9, '', '2017-12-12 20:44:01', '2017-12-13'),
(162, 11, 2, 2, 'DC12851030328541', 26, '1094.20', 4, '', '2017-12-12 21:25:03', '2017-12-13'),
(163, 10, 1, 2, 'DC12930278243441', 9, '714.80', 9, '', '2017-12-12 23:37:07', '2017-12-13'),
(164, 0, 1, 2, 'DC13296113591659', 10, '223.70', 14, '', '2017-12-13 09:46:51', '2017-12-13'),
(165, 16, 1, 2, 'DC13363949059330', 9, '916.80', 2, '', '2017-12-13 11:39:54', '2017-12-01'),
(166, 16, 1, 2, 'DC13366588412304', 9, '1767.94', 5, '', '2017-12-13 11:44:18', '2017-12-02'),
(167, 16, 1, 2, 'DC13384479171708', 9, '1680.98', 4, '', '2017-12-13 12:14:07', '2017-12-03'),
(168, 16, 1, 2, 'DC13385086910771', 9, '1900.24', 4, '', '2017-12-13 12:15:08', '2017-12-04'),
(169, 16, 1, 2, 'DC13385943769709', 9, '1660.19', 4, '', '2017-12-13 12:16:34', '2017-12-05'),
(170, 16, 1, 2, 'DC13393264552140', 9, '1109.30', 5, '', '2017-12-13 12:28:46', '2017-12-06'),
(171, 16, 1, 2, 'DC13393575795140', 9, '195.50', 1, '', '2017-12-13 12:29:17', '2017-12-07'),
(172, 16, 1, 2, 'DC13393941344262', 9, '641.00', 2, '', '2017-12-13 12:29:54', '2017-12-08'),
(173, 16, 1, 2, 'DC13394293012076', 9, '337.40', 2, '', '2017-12-13 12:30:29', '2017-12-09'),
(174, 16, 1, 2, 'DC13394807997964', 9, '325.50', 2, '', '2017-12-13 12:31:20', '2017-12-10'),
(175, 16, 1, 2, 'DC13395440395126', 9, '665.00', 3, '', '2017-12-13 12:32:24', '2017-12-11'),
(176, 16, 1, 2, 'DC13395928164613', 9, '347.20', 2, '', '2017-12-13 12:33:12', '2017-12-12'),
(177, 19, 1, 2, 'DC13402160624316', 9, '471.00', 3, '', '2017-12-13 12:43:36', '2017-12-01'),
(178, 19, 1, 2, 'DC13404661841067', 9, '1498.00', 6, '', '2017-12-13 12:47:46', '2017-12-02'),
(179, 19, 1, 2, 'DC13406656562557', 9, '624.00', 4, '', '2017-12-13 12:51:05', '2017-12-03'),
(180, 19, 1, 2, 'DC13477326435881', 9, '474.00', 6, '', '2017-12-13 14:48:52', '2017-12-04'),
(181, 19, 1, 2, 'DC13480270855592', 9, '1060.00', 5, '', '2017-12-13 14:53:47', '2017-12-05'),
(182, 19, 1, 2, 'DC13481485208726', 9, '925.00', 5, '', '2017-12-13 14:55:48', '2017-12-06'),
(183, 19, 1, 2, 'DC13482116336574', 9, '264.00', 5, '', '2017-12-13 14:56:51', '2017-12-07'),
(184, 19, 1, 2, 'DC13482949825504', 9, '1052.00', 5, '', '2017-12-13 14:58:14', '2017-12-08'),
(185, 19, 1, 2, 'DC13483250725708', 9, '389.00', 2, '', '2017-12-13 14:58:45', '2017-12-09'),
(186, 19, 1, 2, 'DC13483492278093', 9, '128.00', 1, '', '2017-12-13 14:59:09', '2017-12-10'),
(187, 19, 1, 2, 'DC13483796176493', 9, '244.00', 2, '', '2017-12-13 14:59:39', '2017-12-11'),
(188, 19, 1, 2, 'DC13486262629515', 9, '336.00', 3, '', '2017-12-13 15:03:46', '2017-12-12'),
(189, 1, 1, 2, 'DC13666756366033', 10, '626.00', 6, '把规格写在后面', '2017-12-13 20:04:35', '2017-12-14'),
(190, 8, 1, 2, 'DC13674510328872', 5, '94.00', 5, '', '2017-12-13 20:17:31', '2017-12-14'),
(191, 11, 2, 2, 'DC13700790983430', 26, '660.76', 4, '', '2017-12-13 21:01:19', '2017-12-14'),
(192, 14, 1, 2, 'DC13710447552488', 23, '274.60', 6, '', '2017-12-13 21:17:24', '2017-12-14'),
(193, 13, 1, 2, 'DC13714011567877', 23, '221.00', 9, '', '2017-12-13 21:23:21', '2017-12-14'),
(194, 19, 1, 2, 'DC13725081287855', 9, '512.00', 1, '', '2017-12-13 21:41:48', '2017-12-14'),
(195, 18, 1, 2, 'DC13726347361041', 9, '559.00', 4, '', '2017-12-13 21:43:54', '2017-12-14'),
(196, 16, 1, 2, 'DC13732816195832', 5, '344.50', 3, '', '2017-12-13 21:54:41', '2017-12-14'),
(197, 15, 1, 2, 'DC13745907772392', 5, '1102.50', 7, '', '2017-12-13 22:16:30', '2017-12-14'),
(198, 10, 1, 2, 'DC14830609693992', 9, '827.60', 7, '', '2017-12-14 00:37:40', '2017-12-14'),
(201, 12, 1, 2, 'DC14199153993879', 9, '8103.30', 21, '', '2017-12-14 10:51:55', '2017-12-14'),
(202, 12, 1, 2, 'DC14344890639740', 9, '7947.66', 22, '', '2017-12-14 14:54:49', '2017-12-13'),
(203, 0, 1, 4, 'DC14487272579146', 23, '25.00', 2, '', '2017-12-14 18:52:07', '2017-12-14'),
(204, 11, 2, 2, 'DC14498814672068', 26, '931.00', 4, '', '2017-12-14 19:11:21', '2017-12-15'),
(206, 18, 1, 2, 'DC14562008440029', 9, '268.50', 8, '', '2017-12-14 20:56:40', '2017-12-15'),
(208, 15, 1, 2, 'DC14570950825250', 9, '1561.00', 15, '', '2017-12-14 21:11:35', '2017-12-15'),
(209, 16, 1, 2, 'DC14574134755839', 9, '198.50', 4, '', '2017-12-14 21:16:53', '2017-12-15'),
(210, 10, 1, 4, 'DC14599554682190', 9, '918.15', 10, '', '2017-12-14 21:59:15', '2017-12-15'),
(212, 14, 1, 2, 'DC14613536310195', 9, '66.00', 3, '', '2017-12-14 22:22:33', '2017-12-15'),
(213, 13, 1, 2, 'DC14613842494997', 9, '17.50', 2, '', '2017-12-14 22:23:04', '2017-12-15'),
(214, 8, 1, 2, 'DC14639467832302', 10, '38.00', 3, '', '2017-12-14 23:05:46', '2017-12-15'),
(215, 1, 1, 2, 'DC14640392127227', 10, '35.00', 1, '', '2017-12-14 23:07:19', '2017-12-15'),
(216, 9, 1, 2, 'DC15838629851702', 10, '21.00', 1, '', '2017-12-15 04:37:42', '2017-12-16'),
(217, 0, 1, 2, 'DC15866424057454', 10, '719.00', 6, '', '2017-12-15 05:24:02', '2017-12-14'),
(218, 12, 1, 2, 'DC15964813268745', 9, '7104.05', 25, '', '2017-12-15 08:08:01', '2017-12-15'),
(220, 0, 1, 4, 'DC15026948208695', 10, '274.00', 6, '', '2017-12-15 09:51:34', '2017-12-15'),
(221, 0, 1, 4, 'DC15103703058817', 28, '154.50', 5, '', '2017-12-15 11:59:30', '2017-12-15'),
(223, 17, 1, 2, 'DC15319500232298', 23, '240.00', 1, '', '2017-12-15 17:59:10', '2017-12-16'),
(224, 14, 1, 2, 'DC15397995631539', 23, '60.00', 1, '', '2017-12-15 20:09:59', '2017-12-16'),
(225, 15, 1, 2, 'DC15400353502052', 28, '548.00', 8, '', '2017-12-15 20:13:55', '2017-12-16'),
(226, 16, 1, 2, 'DC15401097691008', 28, '114.00', 1, '搞好点', '2017-12-15 20:15:09', '2017-12-16'),
(227, 18, 1, 2, 'DC15402779663851', 28, '334.50', 9, '', '2017-12-15 20:17:57', '2017-12-16'),
(228, 19, 1, 2, 'DC15403578577153', 28, '715.00', 5, '', '2017-12-15 20:19:17', '2017-12-16'),
(229, 1, 1, 2, 'DC15409987338901', 10, '516.00', 2, '', '2017-12-15 20:29:58', '2017-12-16'),
(230, 9, 1, 2, 'DC15410288900363', 10, '7.00', 1, '', '2017-12-15 20:30:28', '2017-12-16'),
(231, 4, 1, 2, 'DC15410610904123', 10, '135.00', 1, '', '2017-12-15 20:31:01', '2017-12-16'),
(232, 8, 1, 2, 'DC15411089843694', 10, '25.00', 2, '', '2017-12-15 20:31:48', '2017-12-16'),
(233, 13, 1, 2, 'DC15414718865243', 23, '180.00', 8, '', '2017-12-15 20:37:51', '2017-12-16'),
(234, 11, 2, 2, 'DC15499181484986', 26, '720.20', 3, '', '2017-12-15 22:58:38', '2017-12-16'),
(235, 10, 1, 2, 'DC15501404139479', 9, '511.20', 8, '', '2017-12-15 23:02:20', '2017-12-16'),
(236, 21, 1, 4, 'DC16555228086009', 5, '2953.00', 18, '', '2017-12-16 00:32:02', '2017-12-16'),
(237, 12, 1, 2, 'DC16555766539581', 9, '6951.95', 26, '', '2017-12-16 00:32:56', '2017-12-01'),
(238, 12, 1, 2, 'DC16794260494889', 9, '9703.07', 47, '', '2017-12-16 07:10:26', '2017-12-02'),
(239, 0, 1, 2, 'DC16809277253016', 10, '78.60', 5, '', '2017-12-16 07:35:27', '2017-12-16'),
(240, 0, 1, 2, 'DC16877358529330', 23, '120.40', 3, '', '2017-12-16 09:28:55', '2017-12-16'),
(242, 0, 1, 2, 'DC16122196601972', 28, '33.00', 1, '', '2017-12-16 16:16:59', '2017-12-16'),
(243, 3, 1, 2, 'DC16247651765554', 10, '580.00', 1, '', '2017-12-16 19:46:05', '2017-12-17'),
(244, 15, 1, 2, 'DC16275838708179', 28, '1047.00', 13, '', '2017-12-16 20:33:03', '2017-12-17'),
(245, 16, 1, 2, 'DC16276906559623', 28, '269.00', 3, '', '2017-12-16 20:34:50', '2017-12-17'),
(246, 18, 1, 2, 'DC16278365035836', 28, '350.00', 5, '', '2017-12-16 20:37:16', '2017-12-17'),
(247, 19, 1, 2, 'DC16279040256164', 28, '577.00', 4, '', '2017-12-16 20:38:24', '2017-12-17'),
(248, 1, 1, 2, 'DC16279229924897', 10, '159.00', 3, '', '2017-12-16 20:38:42', '2017-12-17'),
(249, 8, 1, 2, 'DC16280037654706', 10, '21.25', 2, '', '2017-12-16 20:40:03', '2017-12-17'),
(250, 14, 1, 2, 'DC16284338671297', 23, '133.60', 3, '', '2017-12-16 20:47:13', '2017-12-17'),
(251, 13, 1, 2, 'DC16285813160955', 23, '237.85', 9, '', '2017-12-16 20:49:41', '2017-12-17'),
(252, 11, 2, 2, 'DC16337947688717', 26, '771.20', 3, '', '2017-12-16 22:16:34', '2017-12-17'),
(253, 0, 1, 4, 'DC17672526001744', 23, '254.00', 3, '', '2017-12-17 07:34:12', '2017-12-17'),
(254, 0, 1, 2, 'DC17680352834948', 10, '324.00', 6, '', '2017-12-17 07:47:15', '2017-12-17'),
(255, 0, 1, 2, 'DC17837781179608', 28, '55.00', 1, '', '2017-12-17 12:09:38', '2017-12-17'),
(256, 26, 1, 2, 'DC17978734349551', 9, '1134.00', 8, '', '2017-12-17 16:04:33', '2017-12-02'),
(258, 12, 1, 2, 'DC17013973370038', 9, '5366.41', 20, '', '2017-12-17 17:03:17', '2017-12-16'),
(259, 12, 1, 2, 'DC17023214598534', 9, '6381.95', 24, '', '2017-12-17 17:18:41', '2017-12-17'),
(260, 12, 1, 2, 'DC17038899539657', 9, '10660.90', 36, '', '2017-12-17 17:44:49', '2017-12-03'),
(261, 12, 1, 2, 'DC17055192259507', 9, '17399.91', 35, '', '2017-12-17 18:11:59', '2017-12-04'),
(263, 24, 1, 2, 'DC17063057385880', 9, '389.60', 4, '', '2017-12-17 18:25:05', '2017-12-17'),
(264, 24, 1, 2, 'DC17064087065248', 9, '249.80', 3, '', '2017-12-17 18:26:48', '2017-12-16'),
(265, 12, 1, 2, 'DC17081048339467', 9, '10940.06', 34, '', '2017-12-17 18:55:04', '2017-12-05'),
(266, 12, 1, 2, 'DC17096019102638', 9, '8594.48', 37, '', '2017-12-17 19:20:01', '2017-12-06'),
(267, 23, 1, 2, 'DC17107450299884', 5, '599.90', 7, '', '2017-12-17 19:39:05', '2017-12-01'),
(268, 15, 1, 2, 'DC17132654019649', 28, '1148.00', 13, '破肚子不用砍', '2017-12-17 20:21:05', '2017-12-18'),
(269, 8, 1, 2, 'DC17132818870428', 10, '77.00', 4, '', '2017-12-17 20:21:21', '2017-12-18'),
(270, 16, 1, 2, 'DC17133118939494', 28, '294.50', 2, '', '2017-12-17 20:21:51', '2017-12-18'),
(271, 18, 1, 2, 'DC17133552199059', 28, '202.00', 2, '', '2017-12-17 20:22:35', '2017-12-18'),
(272, 19, 1, 4, 'DC17133900459904', 28, '128.00', 2, '', '2017-12-17 20:23:10', '2017-12-18'),
(273, 1, 1, 2, 'DC17134858372441', 10, '522.00', 6, '', '2017-12-17 20:24:45', '2017-12-18'),
(274, 9, 1, 2, 'DC17135067828002', 10, '10.50', 1, '', '2017-12-17 20:25:06', '2017-12-18'),
(275, 0, 1, 2, 'DC17140829963157', 28, '150.00', 1, '', '2017-12-17 20:34:42', '2017-12-18'),
(276, 14, 1, 2, 'DC17158746964189', 23, '30.00', 2, '', '2017-12-17 21:04:34', '2017-12-18'),
(277, 13, 1, 2, 'DC17159844745009', 23, '299.37', 6, '', '2017-12-17 21:06:24', '2017-12-18'),
(278, 23, 1, 2, 'DC17204487180004', 5, '758.10', 9, '', '2017-12-17 22:20:48', '2017-12-02'),
(279, 22, 1, 2, 'DC17205271788350', 9, '228.75', 2, '', '2017-12-17 22:22:07', '2017-12-18'),
(280, 24, 1, 2, 'DC17206068085813', 9, '457.00', 2, '', '2017-12-17 22:23:26', '2017-12-18'),
(281, 26, 1, 4, 'DC17211430681728', 9, '1560.95', 8, '', '2017-12-17 22:32:23', '2017-12-18'),
(282, 28, 1, 2, 'DC17212554520373', 9, '326.00', 4, '', '2017-12-17 22:34:15', '2017-12-18'),
(283, 10, 1, 2, 'DC17214486098902', 9, '827.85', 8, '', '2017-12-17 22:37:28', '2017-12-18'),
(284, 23, 1, 2, 'DC17214659596540', 5, '655.35', 9, '', '2017-12-17 22:37:45', '2017-12-03'),
(285, 25, 1, 2, 'DC17215117192234', 9, '77.00', 2, '', '2017-12-17 22:38:31', '2017-12-18'),
(286, 23, 1, 2, 'DC17215971239743', 5, '929.60', 8, '', '2017-12-17 22:39:57', '2017-12-04'),
(287, 23, 1, 2, 'DC17217569571618', 5, '696.45', 8, '', '2017-12-17 22:42:36', '2017-12-05'),
(288, 11, 2, 2, 'DC17219283721675', 26, '635.80', 3, '', '2017-12-17 22:45:28', '2017-12-18'),
(289, 23, 1, 2, 'DC17220551734825', 5, '737.80', 8, '', '2017-12-17 22:47:35', '2017-12-06'),
(290, 23, 1, 2, 'DC17221377182206', 5, '673.80', 7, '', '2017-12-17 22:48:57', '2017-12-07'),
(291, 23, 1, 2, 'DC17222787003360', 5, '712.60', 8, '', '2017-12-17 22:51:18', '2017-12-08'),
(292, 23, 1, 2, 'DC17223978814148', 5, '562.90', 6, '', '2017-12-17 22:53:17', '2017-12-09'),
(293, 23, 1, 2, 'DC17224508862998', 5, '544.85', 7, '', '2017-12-17 22:54:10', '2017-12-10'),
(294, 21, 1, 2, 'DC17224553905627', 9, '5487.50', 26, '', '2017-12-17 22:54:15', '2017-12-18'),
(295, 23, 1, 2, 'DC17225413301134', 5, '657.80', 7, '', '2017-12-17 22:55:41', '2017-12-11'),
(296, 23, 1, 2, 'DC17227148768864', 5, '762.00', 8, '', '2017-12-17 22:58:34', '2017-12-12'),
(297, 23, 1, 2, 'DC17228609148918', 5, '703.55', 6, '', '2017-12-17 23:01:00', '2017-12-13'),
(298, 28, 1, 2, 'DC17228728379550', 9, '283.00', 2, '', '2017-12-17 23:01:12', '2017-12-01'),
(299, 28, 1, 2, 'DC17229770283650', 9, '332.00', 2, '', '2017-12-17 23:02:57', '2017-12-02'),
(300, 23, 1, 2, 'DC17230183148722', 5, '759.90', 8, '', '2017-12-17 23:03:38', '2017-12-14'),
(301, 28, 1, 2, 'DC17230280247788', 9, '286.00', 2, '', '2017-12-17 23:03:48', '2017-12-03'),
(302, 28, 1, 2, 'DC17230950744527', 9, '345.50', 3, '', '2017-12-17 23:04:55', '2017-12-04'),
(303, 23, 1, 2, 'DC17231087431166', 5, '644.70', 8, '', '2017-12-17 23:05:08', '2017-12-15'),
(304, 28, 1, 2, 'DC17231893055909', 9, '434.00', 2, '', '2017-12-17 23:06:29', '2017-12-05'),
(305, 28, 1, 2, 'DC17232487182893', 9, '306.50', 2, '', '2017-12-17 23:07:28', '2017-12-06'),
(306, 28, 1, 2, 'DC17233072270095', 9, '394.00', 2, '', '2017-12-17 23:08:27', '2017-12-07'),
(307, 28, 1, 2, 'DC17233401907502', 9, '377.00', 2, '', '2017-12-17 23:09:00', '2017-12-08'),
(308, 28, 1, 2, 'DC17233889116538', 9, '283.50', 1, '', '2017-12-17 23:09:48', '2017-12-09'),
(309, 28, 1, 2, 'DC17234177919565', 9, '275.50', 2, '', '2017-12-17 23:10:17', '2017-12-10'),
(310, 28, 1, 2, 'DC17242645287975', 9, '315.50', 4, '', '2017-12-17 23:24:24', '2017-12-11'),
(311, 28, 1, 2, 'DC17243567962462', 9, '465.00', 2, '', '2017-12-17 23:25:56', '2017-12-12'),
(312, 28, 1, 2, 'DC17244088929164', 9, '298.00', 2, '', '2017-12-17 23:26:48', '2017-12-13'),
(313, 28, 1, 2, 'DC17244449191301', 9, '288.00', 2, '', '2017-12-17 23:27:24', '2017-12-14'),
(314, 28, 1, 2, 'DC17245997016651', 9, '311.00', 2, '', '2017-12-17 23:29:59', '2017-12-15'),
(315, 28, 1, 2, 'DC17246253971145', 9, '406.50', 1, '', '2017-12-17 23:30:25', '2017-12-16'),
(316, 28, 1, 2, 'DC17246873858498', 9, '267.50', 2, '', '2017-12-17 23:31:27', '2017-12-17'),
(317, 25, 1, 2, 'DC17247143455107', 5, '94.00', 1, '', '2017-12-17 23:31:54', '2017-12-01'),
(318, 25, 1, 2, 'DC17247798746605', 5, '71.00', 1, '', '2017-12-17 23:32:59', '2017-12-02'),
(319, 25, 1, 2, 'DC17248330060632', 5, '56.00', 1, '', '2017-12-17 23:33:53', '2017-12-03'),
(320, 25, 1, 2, 'DC17248681033001', 5, '96.00', 1, '', '2017-12-17 23:34:28', '2017-12-04'),
(321, 25, 1, 2, 'DC17249064847982', 5, '73.00', 1, '', '2017-12-17 23:35:06', '2017-12-05'),
(322, 25, 1, 2, 'DC17249319835031', 5, '79.00', 1, '', '2017-12-17 23:35:31', '2017-12-06'),
(323, 25, 1, 2, 'DC17249597817701', 5, '77.00', 1, '', '2017-12-17 23:35:59', '2017-12-07'),
(324, 25, 1, 2, 'DC17249727629397', 5, '81.00', 1, '', '2017-12-17 23:36:12', '2017-12-08'),
(325, 25, 1, 2, 'DC17249901143235', 5, '55.00', 1, '', '2017-12-17 23:36:30', '2017-12-09'),
(326, 25, 1, 2, 'DC17250590835581', 5, '20.00', 1, '', '2017-12-17 23:37:39', '2017-12-10'),
(327, 25, 1, 2, 'DC17250923594699', 5, '70.00', 1, '', '2017-12-17 23:38:12', '2017-12-11'),
(328, 25, 1, 2, 'DC17251111387018', 5, '79.00', 1, '', '2017-12-17 23:38:31', '2017-12-12'),
(329, 25, 1, 2, 'DC17251314850752', 5, '113.00', 1, '', '2017-12-17 23:38:51', '2017-12-13'),
(330, 25, 1, 2, 'DC17251581213846', 5, '73.00', 1, '', '2017-12-17 23:39:18', '2017-12-14'),
(331, 23, 1, 2, 'DC17254579863694', 9, '717.95', 15, '', '2017-12-17 23:44:17', '2017-12-18'),
(332, 21, 1, 2, 'DC18282061987127', 9, '2406.80', 18, '', '2017-12-18 00:30:06', '2017-12-01'),
(333, 21, 1, 2, 'DC18286526886445', 9, '2834.90', 18, '', '2017-12-18 00:37:32', '2017-12-02'),
(334, 21, 1, 2, 'DC18298388741890', 9, '3507.30', 17, '', '2017-12-18 00:57:18', '2017-12-03'),
(335, 0, 1, 4, 'DC18548175319274', 23, '192.50', 4, '', '2017-12-18 07:53:37', '2017-12-18'),
(336, 12, 1, 4, 'DC18568244466202', 9, '8650.36', 20, '', '2017-12-18 08:27:04', '2017-12-18'),
(337, 19, 1, 2, 'DC18572521971732', 28, '156.00', 3, '', '2017-12-18 08:34:12', '2017-12-18'),
(340, 21, 1, 2, 'DC18578011129176', 9, '2982.20', 21, '', '2017-12-18 08:43:21', '2017-12-17'),
(341, 21, 1, 2, 'DC18597681225206', 9, '5442.50', 24, '', '2017-12-18 09:16:08', '2017-12-04'),
(342, 0, 1, 4, 'DC18794660709674', 10, '606.00', 9, '矿泉水1件', '2017-12-18 14:44:26', '2017-12-18'),
(343, 10, 1, 4, 'DC18819537578460', 9, '1567.60', 9, '', '2017-12-18 15:25:53', '2017-12-17'),
(344, 25, 1, 2, 'DC18824119761800', 9, '83.00', 1, '', '2017-12-18 15:33:31', '2017-12-15'),
(345, 25, 1, 2, 'DC18824421375777', 9, '35.00', 1, '', '2017-12-18 15:34:02', '2017-12-16'),
(346, 25, 1, 2, 'DC18824818482581', 9, '64.00', 1, '', '2017-12-18 15:34:41', '2017-12-17'),
(347, 21, 1, 2, 'DC18832243466850', 9, '3955.90', 15, '', '2017-12-18 15:47:04', '2017-12-05'),
(348, 15, 1, 2, 'DC18007531446349', 28, '1152.00', 12, '机场鱼头分开装', '2017-12-18 20:39:13', '2017-12-19'),
(349, 16, 1, 2, 'DC18008546576965', 28, '779.00', 7, '', '2017-12-18 20:40:54', '2017-12-19'),
(350, 11, 2, 2, 'DC18009524839011', 26, '1078.60', 4, '', '2017-12-18 20:42:32', '2017-12-19'),
(351, 18, 1, 2, 'DC18009654659585', 28, '553.75', 7, '', '2017-12-18 20:42:45', '2017-12-19'),
(352, 19, 1, 2, 'DC18010050994742', 28, '242.00', 2, '', '2017-12-18 20:43:25', '2017-12-19'),
(353, 13, 1, 2, 'DC18096460397861', 23, '177.10', 7, '', '2017-12-18 23:07:26', '2017-12-19'),
(354, 14, 1, 2, 'DC18100742534207', 23, '244.80', 4, '', '2017-12-18 23:14:34', '2017-12-19'),
(355, 29, 1, 2, 'DC18126170159905', 9, '660.00', 1, '', '2017-12-18 23:56:57', '2017-12-19'),
(356, 24, 1, 2, 'DC19128295431846', 9, '365.70', 1, '', '2017-12-19 00:00:29', '2017-12-19'),
(357, 22, 1, 2, 'DC19129287835192', 9, '305.25', 2, '', '2017-12-19 00:02:08', '2017-12-19'),
(358, 26, 1, 2, 'DC19131700661312', 9, '1546.65', 7, '', '2017-12-19 00:06:10', '2017-12-19'),
(359, 10, 1, 2, 'DC19133167107461', 9, '948.10', 9, '', '2017-12-19 00:08:36', '2017-12-19'),
(360, 25, 1, 2, 'DC19134871883669', 9, '71.00', 1, '', '2017-12-19 00:11:27', '2017-12-19'),
(361, 28, 1, 2, 'DC19135861221696', 9, '329.00', 4, '', '2017-12-19 00:13:06', '2017-12-19'),
(362, 23, 1, 2, 'DC19138393576543', 9, '905.90', 12, '', '2017-12-19 00:17:19', '2017-12-19'),
(363, 21, 1, 2, 'DC19141373390483', 9, '3111.30', 19, '', '2017-12-19 00:22:17', '2017-12-19'),
(364, 21, 1, 2, 'DC19151500659775', 9, '3129.30', 20, '', '2017-12-19 00:39:10', '2017-12-06'),
(365, 1, 1, 2, 'DC19226307575514', 10, '877.50', 8, '', '2017-12-19 02:43:50', '2017-12-19'),
(366, 3, 1, 2, 'DC19226553096561', 10, '140.00', 1, '', '2017-12-19 02:44:15', '2017-12-19'),
(367, 8, 1, 2, 'DC19227918250552', 10, '26.00', 2, '', '2017-12-19 02:46:31', '2017-12-19'),
(368, 9, 1, 2, 'DC19229681560108', 10, '14.00', 1, '', '2017-12-19 02:49:28', '2017-12-19'),
(369, 0, 1, 4, 'DC19385444883549', 23, '436.00', 10, '', '2017-12-19 07:09:04', '2017-12-19'),
(370, 12, 1, 2, 'DC19699241438802', 9, '10461.64', 23, '', '2017-12-19 15:52:04', '2017-12-19'),
(371, 21, 1, 2, 'DC19705437847655', 9, '3872.70', 19, '', '2017-12-19 16:02:23', '2017-12-07'),
(372, 21, 1, 2, 'DC19713453372054', 9, '2252.50', 15, '', '2017-12-19 16:15:45', '2017-12-08'),
(373, 21, 1, 2, 'DC19717398790010', 9, '2383.00', 11, '', '2017-12-19 16:22:19', '2017-12-09'),
(374, 12, 1, 2, 'DC19732769311117', 9, '6972.07', 23, '', '2017-12-19 16:47:56', '2017-12-07'),
(375, 4, 1, 4, 'DC19828186755798', 10, '2945.00', 3, '', '2017-12-19 19:26:58', '2017-12-20'),
(376, 3, 1, 2, 'DC19829476176893', 10, '405.00', 2, '', '2017-12-19 19:29:07', '2017-12-20'),
(377, 1, 1, 4, 'DC19829991519753', 10, '709.00', 5, '', '2017-12-19 19:29:59', '2017-12-20'),
(378, 15, 1, 2, 'DC19861286390686', 28, '1566.00', 12, '', '2017-12-19 20:22:08', '2017-12-20'),
(379, 18, 1, 2, 'DC19864060413754', 28, '1052.00', 14, '旅直的鸡爪给白净点肉厚点，部队领导要求的', '2017-12-19 20:26:46', '2017-12-20'),
(380, 19, 1, 2, 'DC19864412896080', 28, '80.00', 1, '', '2017-12-19 20:27:21', '2017-12-20'),
(381, 13, 1, 2, 'DC19866154820371', 23, '100.00', 6, '', '2017-12-19 20:30:15', '2017-12-20'),
(382, 11, 2, 2, 'DC19879831716505', 26, '1089.10', 4, '', '2017-12-19 20:53:03', '2017-12-20'),
(383, 14, 1, 4, 'DC19895013933270', 23, '158.00', 4, '', '2017-12-19 21:18:21', '2017-12-20'),
(384, 21, 1, 2, 'DC19966343604727', 9, '2428.70', 14, '质量好点', '2017-12-19 23:17:14', '2017-12-20'),
(385, 23, 1, 2, 'DC19968421984079', 9, '740.45', 8, '', '2017-12-19 23:20:42', '2017-12-20'),
(386, 28, 1, 2, 'DC19969295904703', 9, '338.00', 4, '', '2017-12-19 23:22:09', '2017-12-20'),
(387, 10, 1, 4, 'DC19971799017522', 9, '1967.20', 11, '', '2017-12-19 23:26:19', '2017-12-20'),
(388, 22, 1, 2, 'DC19974652887615', 9, '340.13', 2, '', '2017-12-19 23:31:05', '2017-12-20'),
(389, 19, 1, 0, 'DC19975117940738', 9, '0.00', 1, '', '2017-12-19 23:31:51', '2017-12-20'),
(390, 24, 1, 4, 'DC19975703158692', 9, '428.50', 3, '', '2017-12-19 23:32:50', '2017-12-20'),
(391, 26, 1, 2, 'DC19978999544583', 9, '1672.45', 8, '', '2017-12-19 23:38:19', '2017-12-20'),
(392, 25, 1, 2, 'DC19980742274502', 9, '89.00', 2, '', '2017-12-19 23:41:14', '2017-12-20'),
(393, 12, 1, 2, 'DC19985694788058', 9, '7637.55', 29, '', '2017-12-19 23:49:29', '2017-12-08'),
(394, 12, 1, 2, 'DC20002207451341', 9, '12339.31', 27, '', '2017-12-20 00:17:00', '2017-12-09'),
(395, 12, 1, 2, 'DC20303687556662', 9, '8107.45', 20, '', '2017-12-20 08:39:28', '2017-12-20'),
(396, 12, 1, 2, 'DC20309757655474', 9, '7157.93', 22, '', '2017-12-20 08:49:35', '2017-12-10'),
(397, 12, 1, 2, 'DC20314868602113', 9, '3482.96', 21, '', '2017-12-20 08:58:06', '2017-12-11'),
(398, 12, 1, 2, 'DC20318174458905', 9, '7633.20', 28, '', '2017-12-20 09:03:37', '2017-12-12'),
(399, 0, 1, 2, 'DC20390254095266', 23, '180.70', 9, '', '2017-12-20 11:03:45', '2017-12-20'),
(400, 15, 1, 2, 'DC20730507774881', 28, '797.50', 10, '机场的大草鱼每条5-6斤', '2017-12-20 20:30:50', '2017-12-21'),
(401, 16, 1, 2, 'DC20732143233836', 28, '1468.60', 6, '', '2017-12-20 20:33:34', '2017-12-21'),
(402, 19, 1, 2, 'DC20733688528575', 28, '1206.00', 10, '', '2017-12-20 20:36:08', '2017-12-21'),
(403, 1, 1, 4, 'DC20755156865346', 10, '528.00', 7, '', '2017-12-20 21:11:55', '2017-12-21'),
(404, 8, 1, 2, 'DC20756053265863', 10, '96.00', 3, '', '2017-12-20 21:13:25', '2017-12-21'),
(405, 14, 1, 4, 'DC20766169251985', 23, '41.00', 2, '', '2017-12-20 21:30:16', '2017-12-21'),
(406, 13, 1, 2, 'DC20767166484125', 23, '164.00', 4, '', '2017-12-20 21:31:56', '2017-12-21'),
(407, 0, 1, 2, 'DC20774325242356', 10, '74.00', 4, '', '2017-12-20 21:43:52', '2017-12-20'),
(408, 0, 1, 2, 'DC20777509603788', 10, '1299.00', 16, '', '2017-12-20 21:49:10', '2017-12-19'),
(409, 11, 2, 2, 'DC20798392764199', 26, '989.80', 4, '', '2017-12-20 22:23:59', '2017-12-21'),
(410, 26, 1, 2, 'DC20840551010779', 9, '1632.70', 8, '', '2017-12-20 23:34:15', '2017-12-21'),
(411, 10, 1, 2, 'DC20843136156411', 9, '1854.45', 11, '', '2017-12-20 23:38:33', '2017-12-21'),
(412, 25, 1, 2, 'DC20843822030612', 9, '87.00', 2, '', '2017-12-20 23:39:42', '2017-12-21'),
(413, 24, 1, 4, 'DC20844152862215', 9, '470.40', 3, '', '2017-12-20 23:40:15', '2017-12-21'),
(414, 21, 1, 2, 'DC20848277323222', 9, '1867.70', 13, '', '2017-12-20 23:47:07', '2017-12-21'),
(415, 23, 1, 2, 'DC20850021608631', 9, '692.85', 9, '', '2017-12-20 23:50:02', '2017-12-21'),
(416, 22, 1, 2, 'DC20850742471637', 9, '354.75', 2, '', '2017-12-20 23:51:14', '2017-12-21'),
(417, 28, 1, 2, 'DC20851436624491', 9, '432.50', 4, '', '2017-12-20 23:52:23', '2017-12-21'),
(418, 31, 1, 2, 'DC20853436800299', 9, '168.75', 1, '', '2017-12-20 23:55:43', '2017-12-21'),
(419, 0, 1, 4, 'DC21109149842956', 23, '229.60', 4, '', '2017-12-21 07:01:54', '2017-12-21'),
(420, 12, 1, 2, 'DC21327007949763', 9, '8567.13', 30, '', '2017-12-21 13:05:00', '2017-12-21'),
(421, 0, 1, 2, 'DC21331813418452', 28, '33.00', 1, '', '2017-12-21 13:13:01', '2017-12-21'),
(422, 31, 1, 2, 'DC21573529367636', 9, '234.40', 1, '', '2017-12-21 19:55:52', '2017-12-01'),
(423, 31, 1, 2, 'DC21573790228384', 9, '229.60', 1, '', '2017-12-21 19:56:19', '2017-12-02'),
(424, 31, 1, 2, 'DC21574123449955', 9, '196.00', 1, '', '2017-12-21 19:56:52', '2017-12-03'),
(425, 31, 1, 2, 'DC21574389251855', 9, '300.00', 1, '', '2017-12-21 19:57:18', '2017-12-04'),
(426, 31, 1, 2, 'DC21575065343131', 9, '222.40', 1, '', '2017-12-21 19:58:26', '2017-12-05'),
(427, 31, 1, 2, 'DC21575606048375', 9, '244.00', 1, '', '2017-12-21 19:59:20', '2017-12-06'),
(428, 31, 1, 2, 'DC21576073806575', 9, '263.20', 1, '', '2017-12-21 20:00:07', '2017-12-07'),
(429, 31, 1, 2, 'DC21578560249367', 9, '180.80', 1, '', '2017-12-21 20:04:16', '2017-12-08'),
(430, 31, 1, 2, 'DC21578767566887', 9, '192.00', 1, '', '2017-12-21 20:04:36', '2017-12-09'),
(431, 31, 1, 2, 'DC21579179731294', 9, '226.40', 1, '', '2017-12-21 20:05:17', '2017-12-11'),
(432, 31, 1, 2, 'DC21580533193138', 9, '183.20', 1, '', '2017-12-21 20:07:33', '2017-12-10'),
(433, 31, 1, 2, 'DC21582510384883', 9, '244.00', 1, '', '2017-12-21 20:10:51', '2017-12-12'),
(434, 31, 1, 2, 'DC21582726071191', 9, '188.80', 1, '', '2017-12-21 20:11:12', '2017-12-13'),
(435, 23, 1, 2, 'DC21582807435794', 5, '708.60', 9, '', '2017-12-21 20:11:20', '2017-12-16'),
(436, 31, 1, 2, 'DC21582980144975', 9, '224.70', 1, '', '2017-12-21 20:11:38', '2017-12-14'),
(437, 31, 1, 2, 'DC21583415970646', 9, '243.60', 1, '', '2017-12-21 20:12:21', '2017-12-15'),
(438, 31, 1, 2, 'DC21583782189381', 9, '125.30', 1, '', '2017-12-21 20:12:58', '2017-12-16'),
(439, 31, 1, 2, 'DC21583986147549', 9, '151.90', 1, '', '2017-12-21 20:13:18', '2017-12-17'),
(440, 31, 1, 2, 'DC21584146132628', 9, '135.80', 1, '', '2017-12-21 20:13:34', '2017-12-18'),
(441, 31, 1, 2, 'DC21584402403662', 9, '175.50', 1, '', '2017-12-21 20:14:00', '2017-12-19'),
(442, 23, 1, 2, 'DC21585320362143', 5, '644.90', 7, '', '2017-12-21 20:15:32', '2017-12-17'),
(443, 1, 1, 2, 'DC21590053204510', 10, '345.00', 4, '', '2017-12-21 20:23:25', '2017-12-22'),
(444, 3, 1, 2, 'DC21590204733290', 10, '190.00', 1, '', '2017-12-21 20:23:40', '2017-12-22'),
(445, 31, 1, 2, 'DC21590574048619', 9, '175.50', 1, '', '2017-12-21 20:24:17', '2017-12-20'),
(446, 8, 1, 4, 'DC21590965336058', 10, '123.50', 7, '', '2017-12-21 20:24:56', '2017-12-22'),
(447, 22, 1, 2, 'DC21598151756250', 5, '394.50', 1, '', '2017-12-21 20:36:55', '2017-12-01'),
(448, 22, 1, 2, 'DC21598465185124', 5, '312.75', 1, '', '2017-12-21 20:37:26', '2017-12-02'),
(449, 22, 1, 2, 'DC21598968784590', 5, '297.00', 1, '', '2017-12-21 20:38:16', '2017-12-03'),
(450, 15, 1, 2, 'DC21606532307158', 28, '1245.00', 11, '', '2017-12-21 20:50:53', '2017-12-22'),
(451, 16, 1, 2, 'DC21607052156171', 28, '190.00', 2, '', '2017-12-21 20:51:45', '2017-12-22'),
(452, 18, 1, 2, 'DC21608069638074', 28, '747.00', 9, '', '2017-12-21 20:53:26', '2017-12-22'),
(453, 11, 2, 2, 'DC21664957235923', 26, '1018.15', 6, '', '2017-12-21 22:28:15', '2017-12-22'),
(454, 22, 1, 2, 'DC22754605950304', 9, '294.75', 2, '', '2017-12-22 00:57:40', '2017-12-22'),
(455, 23, 1, 2, 'DC22756796640409', 9, '518.40', 7, '', '2017-12-22 01:01:19', '2017-12-22'),
(456, 25, 1, 2, 'DC22757311706245', 9, '88.00', 1, '', '2017-12-22 01:02:11', '2017-12-22'),
(457, 24, 1, 2, 'DC22757914473106', 9, '542.90', 4, '', '2017-12-22 01:03:11', '2017-12-22'),
(458, 26, 1, 2, 'DC22759580991388', 9, '1616.75', 7, '', '2017-12-22 01:05:58', '2017-12-22'),
(459, 10, 1, 2, 'DC22763061615040', 9, '1840.10', 12, '', '2017-12-22 01:11:46', '2017-12-22'),
(460, 31, 1, 2, 'DC22763757877803', 9, '171.00', 1, '', '2017-12-22 01:12:55', '2017-12-22'),
(461, 28, 1, 2, 'DC22764478956296', 9, '319.50', 4, '', '2017-12-22 01:14:07', '2017-12-22'),
(462, 21, 1, 2, 'DC22768147543724', 9, '3767.20', 22, '', '2017-12-22 01:20:14', '2017-12-22'),
(463, 12, 1, 2, 'DC22108540384451', 9, '8681.58', 24, '', '2017-12-22 10:47:34', '2017-12-22'),
(465, 15, 1, 2, 'DC22458996233426', 28, '637.40', 11, '', '2017-12-22 20:31:39', '2017-12-23'),
(466, 16, 1, 2, 'DC22460080521655', 28, '675.00', 9, '', '2017-12-22 20:33:28', '2017-12-23'),
(467, 11, 2, 2, 'DC22460621806253', 26, '479.40', 2, '', '2017-12-22 20:34:22', '2017-12-23'),
(468, 18, 1, 2, 'DC22461865479535', 28, '966.00', 8, '', '2017-12-22 20:36:26', '2017-12-23'),
(469, 19, 1, 4, 'DC22462235815724', 28, '112.00', 2, '', '2017-12-22 20:37:03', '2017-12-23'),
(470, 0, 1, 2, 'DC22513752075242', 23, '90.00', 1, '', '2017-12-22 22:02:55', '2017-12-22'),
(471, 13, 1, 2, 'DC22516579094942', 23, '364.00', 11, '', '2017-12-22 22:07:37', '2017-12-22'),
(472, 14, 1, 2, 'DC22523483510952', 23, '244.80', 4, '', '2017-12-22 22:19:08', '2017-12-22'),
(473, 13, 1, 2, 'DC22531086323854', 23, '103.00', 6, '', '2017-12-22 22:31:48', '2017-12-23'),
(474, 14, 1, 2, 'DC22531505709648', 23, '21.00', 1, '', '2017-12-22 22:32:30', '2017-12-23'),
(475, 10, 1, 2, 'DC23854708197673', 9, '1451.60', 10, '', '2017-12-23 07:31:10', '2017-12-23'),
(476, 26, 1, 2, 'DC23856164139315', 9, '1334.50', 6, '', '2017-12-23 07:33:36', '2017-12-23'),
(477, 23, 1, 2, 'DC23857848969571', 9, '694.70', 11, '', '2017-12-23 07:36:24', '2017-12-23'),
(478, 28, 1, 2, 'DC23857821436827', 9, '336.00', 1, '', '2017-12-23 07:36:22', '2017-12-23'),
(479, 25, 1, 2, 'DC23858138292760', 9, '76.00', 2, '', '2017-12-23 07:36:53', '2017-12-23'),
(480, 31, 1, 2, 'DC23858662717392', 9, '136.50', 1, '', '2017-12-23 07:37:46', '2017-12-23'),
(481, 24, 1, 2, 'DC23859249455311', 9, '271.40', 2, '', '2017-12-23 07:38:44', '2017-12-23'),
(482, 22, 1, 2, 'DC23859840926782', 9, '197.25', 2, '', '2017-12-23 07:39:44', '2017-12-23'),
(483, 21, 1, 2, 'DC23861926996188', 9, '1843.30', 16, '', '2017-12-23 07:43:12', '2017-12-23'),
(484, 12, 1, 2, 'DC23865226074320', 9, '4665.26', 19, '', '2017-12-23 07:48:42', '2017-12-23'),
(485, 0, 1, 4, 'DC23887383818906', 23, '251.00', 7, '', '2017-12-23 08:25:38', '2017-12-23'),
(486, 1, 1, 2, 'DC23057071521918', 10, '415.00', 3, '', '2017-12-23 13:08:27', '2017-12-23'),
(487, 0, 1, 2, 'DC23282124835966', 10, '267.50', 11, '', '2017-12-23 19:23:32', '2017-12-21'),
(488, 0, 1, 2, 'DC23286148484219', 10, '408.00', 5, '', '2017-12-23 19:30:14', '2017-12-22'),
(489, 15, 1, 2, 'DC23326334627428', 28, '465.00', 8, '', '2017-12-23 20:37:13', '2017-12-24'),
(490, 16, 1, 2, 'DC23327466136656', 28, '383.50', 7, '', '2017-12-23 20:39:06', '2017-12-24'),
(491, 18, 1, 2, 'DC23329071181154', 28, '462.00', 12, '', '2017-12-23 20:41:47', '2017-12-24'),
(492, 14, 1, 2, 'DC23341747816568', 23, '194.20', 4, '', '2017-12-23 21:02:54', '2017-12-24'),
(493, 13, 1, 2, 'DC23342792314749', 23, '69.10', 5, '', '2017-12-23 21:04:39', '2017-12-24'),
(494, 11, 2, 2, 'DC23381880662639', 26, '698.80', 2, '', '2017-12-23 22:09:48', '2017-12-24'),
(495, 26, 1, 2, 'DC24699724187283', 9, '771.50', 5, '', '2017-12-24 06:59:32', '2017-12-24'),
(496, 10, 1, 2, 'DC24702700409261', 9, '2043.60', 14, '', '2017-12-24 07:04:30', '2017-12-24'),
(497, 24, 1, 2, 'DC24703542297874', 9, '815.20', 4, '', '2017-12-24 07:05:54', '2017-12-24'),
(498, 25, 1, 2, 'DC24703349640612', 9, '51.50', 2, '', '2017-12-24 07:05:34', '2017-12-24'),
(499, 31, 1, 2, 'DC24703788879441', 9, '125.25', 1, '', '2017-12-24 07:06:18', '2017-12-24'),
(500, 22, 1, 2, 'DC24704252560261', 9, '171.00', 2, '', '2017-12-24 07:07:05', '2017-12-24'),
(501, 28, 1, 2, 'DC24704679085310', 9, '226.00', 2, '', '2017-12-24 07:07:47', '2017-12-24'),
(502, 23, 1, 2, 'DC24706300882199', 9, '607.30', 12, '', '2017-12-24 07:10:30', '2017-12-24'),
(503, 21, 1, 2, 'DC24708145748905', 9, '3480.50', 13, '', '2017-12-24 07:13:34', '2017-12-24'),
(504, 0, 1, 4, 'DC24747692154556', 10, '227.50', 6, '', '2017-12-24 08:19:29', '2017-12-24'),
(505, 12, 1, 2, 'DC24172341415182', 9, '5189.25', 22, '', '2017-12-24 20:07:14', '2017-12-24'),
(506, 21, 1, 2, 'DC24175905388153', 9, '2857.55', 17, '', '2017-12-24 20:13:10', '2017-12-10'),
(507, 21, 1, 2, 'DC24177514728311', 9, '3475.50', 15, '', '2017-12-24 20:15:51', '2017-12-11'),
(508, 21, 1, 2, 'DC24178858527416', 9, '2468.90', 17, '', '2017-12-24 20:18:05', '2017-12-12'),
(509, 21, 1, 2, 'DC24180447078959', 9, '3546.40', 17, '', '2017-12-24 20:20:44', '2017-12-13'),
(510, 21, 1, 2, 'DC24182992996374', 9, '3591.00', 20, '', '2017-12-24 20:24:59', '2017-12-14'),
(511, 15, 1, 2, 'DC24185568125361', 28, '1661.00', 9, '', '2017-12-24 20:29:16', '2017-12-25'),
(512, 16, 1, 2, 'DC24186309592685', 28, '308.00', 4, '', '2017-12-24 20:30:30', '2017-12-25'),
(513, 18, 1, 2, 'DC24187224792018', 28, '366.00', 8, '', '2017-12-24 20:32:02', '2017-12-25'),
(514, 19, 1, 2, 'DC24187498539451', 28, '116.00', 2, '', '2017-12-24 20:32:29', '2017-12-25'),
(515, 11, 2, 2, 'DC24194559071433', 26, '1232.66', 5, '', '2017-12-24 20:44:15', '2017-12-26'),
(516, 1, 1, 2, 'DC24196663933146', 10, '275.00', 3, '', '2017-12-24 20:47:46', '2017-12-25'),
(517, 8, 1, 2, 'DC24197161479470', 10, '28.00', 2, '', '2017-12-24 20:48:36', '2017-12-25'),
(518, 9, 1, 2, 'DC24197561491814', 10, '14.00', 1, '', '2017-12-24 20:49:16', '2017-12-25'),
(519, 13, 1, 2, 'DC24228405925530', 23, '295.25', 11, '', '2017-12-24 21:40:40', '2017-12-25'),
(520, 14, 1, 2, 'DC24231843262028', 23, '2875.20', 4, '', '2017-12-24 21:46:24', '2017-12-25'),
(521, 3, 1, 2, 'DC25588739838264', 10, '1000.00', 2, '', '2017-12-25 07:41:13', '2017-12-26'),
(522, 0, 1, 4, 'DC25630563321277', 10, '476.00', 13, '', '2017-12-25 08:50:56', '2017-12-25'),
(523, 10, 1, 2, 'DC25706237297285', 9, '2578.70', 14, '', '2017-12-25 10:57:03', '2017-12-25'),
(524, 24, 1, 4, 'DC25706785804254', 9, '146.20', 3, '', '2017-12-25 10:57:58', '2017-12-25'),
(525, 25, 1, 2, 'DC25707119067085', 9, '102.00', 2, '', '2017-12-25 10:58:31', '2017-12-25'),
(526, 31, 1, 2, 'DC25707606821462', 9, '220.90', 2, '', '2017-12-25 10:59:20', '2017-12-25'),
(527, 23, 1, 2, 'DC25709473732160', 9, '727.70', 13, '', '2017-12-25 11:02:27', '2017-12-25'),
(528, 26, 1, 2, 'DC25710832786826', 9, '1439.25', 8, '', '2017-12-25 11:04:43', '2017-12-25'),
(529, 22, 1, 4, 'DC25710768548795', 9, '317.25', 3, '', '2017-12-25 11:04:36', '2017-12-25'),
(530, 21, 1, 2, 'DC25712535231053', 9, '3729.40', 16, '', '2017-12-25 11:07:33', '2017-12-25'),
(531, 28, 1, 2, 'DC25713527339473', 9, '350.00', 4, '', '2017-12-25 11:09:12', '2017-12-25'),
(532, 12, 1, 2, 'DC25936814501921', 9, '9414.19', 23, '', '2017-12-25 17:21:21', '2017-12-25'),
(533, 0, 1, 4, 'DC25010742382989', 23, '207.50', 2, '', '2017-12-25 19:24:34', '2017-12-25'),
(534, 15, 1, 2, 'DC25033578247014', 28, '1216.25', 12, '', '2017-12-25 20:02:37', '2017-12-26'),
(535, 16, 1, 2, 'DC25033452571179', 28, '123.50', 2, '', '2017-12-25 20:02:25', '2017-12-26'),
(536, 18, 1, 2, 'DC25034493742293', 28, '421.00', 10, '', '2017-12-25 20:04:09', '2017-12-26'),
(537, 1, 1, 2, 'DC25042030658685', 10, '85.00', 2, '', '2017-12-25 20:16:43', '2017-12-26'),
(538, 3, 1, 2, 'DC25043428683816', 10, '840.00', 4, '', '2017-12-25 20:19:02', '2017-12-26'),
(539, 4, 1, 2, 'DC25043281274179', 10, '3980.00', 2, '', '2017-12-25 20:18:48', '2017-12-26'),
(540, 8, 1, 1, 'DC25043633685251', 10, '0.00', 2, '', '2017-12-25 20:19:23', '2017-12-26'),
(541, 11, 2, 2, 'DC25067402128135', 26, '995.30', 4, '', '2017-12-25 20:59:00', '2017-12-26'),
(542, 13, 1, 2, 'DC25080193183418', 23, '145.50', 6, '', '2017-12-25 21:20:19', '2017-12-26'),
(543, 14, 1, 2, 'DC25083170300673', 23, '100.40', 4, '', '2017-12-25 21:25:17', '2017-12-26'),
(544, 0, 1, 2, 'DC26428688322719', 23, '236.00', 3, '', '2017-12-26 07:01:08', '2017-12-26'),
(545, 0, 1, 2, 'DC26462535253067', 28, '75.00', 1, '', '2017-12-26 07:57:33', '2017-12-26'),
(546, 0, 1, 4, 'DC26490208507046', 10, '529.00', 9, '', '2017-12-26 08:43:40', '2017-12-26'),
(547, 22, 1, 2, 'DC26894273362859', 9, '295.50', 2, '', '2017-12-26 19:57:07', '2017-12-26'),
(548, 21, 1, 2, 'DC26896110382362', 9, '2881.70', 15, '', '2017-12-26 20:00:11', '2017-12-26'),
(549, 15, 1, 2, 'DC26896315381057', 28, '425.00', 7, '', '2017-12-26 20:00:31', '2017-12-27'),
(550, 28, 1, 2, 'DC26896694909803', 9, '351.50', 4, '', '2017-12-26 20:01:09', '2017-12-26'),
(551, 31, 1, 2, 'DC26897205844179', 9, '187.60', 2, '', '2017-12-26 20:02:00', '2017-12-26'),
(552, 16, 1, 2, 'DC26897363968067', 28, '658.00', 8, '', '2017-12-26 20:02:16', '2017-12-27'),
(553, 25, 1, 2, 'DC26897518342106', 9, '46.00', 1, '', '2017-12-26 20:02:31', '2017-12-26'),
(554, 24, 1, 2, 'DC26897785527861', 9, '351.90', 2, '', '2017-12-26 20:02:58', '2017-12-26'),
(555, 18, 1, 2, 'DC26898323493144', 28, '376.00', 5, '', '2017-12-26 20:03:52', '2017-12-27'),
(556, 19, 1, 2, 'DC26899401611269', 28, '936.00', 8, '', '2017-12-26 20:05:40', '2017-12-27'),
(557, 10, 1, 2, 'DC26900497698013', 9, '2649.00', 15, '', '2017-12-26 20:07:29', '2017-12-26'),
(558, 26, 1, 2, 'DC26901820970828', 9, '1397.60', 8, '', '2017-12-26 20:09:42', '2017-12-26'),
(559, 1, 1, 2, 'DC26902270186699', 10, '1804.00', 7, '', '2017-12-26 20:10:27', '2017-12-27'),
(560, 23, 1, 2, 'DC26903210805654', 9, '614.25', 11, '', '2017-12-26 20:12:01', '2017-12-26'),
(561, 12, 1, 2, 'DC26905691727200', 9, '7486.71', 22, '', '2017-12-26 20:16:09', '2017-12-26'),
(562, 8, 1, 2, 'DC26907589371376', 10, '54.00', 2, '', '2017-12-26 20:19:18', '2017-12-27'),
(563, 11, 2, 2, 'DC26920231634255', 26, '938.90', 3, '', '2017-12-26 20:40:23', '2017-12-27'),
(564, 14, 1, 2, 'DC26940136742439', 23, '97.20', 4, '', '2017-12-26 21:13:33', '2017-12-27'),
(565, 13, 1, 2, 'DC26943601452141', 23, '169.50', 7, '', '2017-12-26 21:19:20', '2017-12-27'),
(566, 23, 1, 2, 'DC27076113507381', 9, '719.80', 7, '', '2017-12-27 01:00:11', '2017-12-27'),
(567, 26, 1, 2, 'DC27078578335340', 9, '1716.40', 8, '', '2017-12-27 01:04:17', '2017-12-27'),
(568, 10, 1, 4, 'DC27081456754393', 9, '2191.80', 15, '', '2017-12-27 01:09:05', '2017-12-27'),
(569, 25, 1, 2, 'DC27082512060186', 9, '66.00', 1, '', '2017-12-27 01:10:51', '2017-12-27'),
(570, 24, 1, 2, 'DC27082800339559', 9, '480.10', 2, '', '2017-12-27 01:11:20', '2017-12-27'),
(571, 21, 1, 2, 'DC27085012200342', 9, '3424.50', 18, '', '2017-12-27 01:15:01', '2017-12-27'),
(572, 28, 1, 2, 'DC27085542665749', 9, '445.00', 2, '', '2017-12-27 01:15:54', '2017-12-27'),
(573, 22, 1, 2, 'DC27086005637161', 9, '273.00', 2, '', '2017-12-27 01:16:40', '2017-12-27'),
(574, 31, 1, 2, 'DC27086488140120', 9, '196.70', 2, '', '2017-12-27 01:17:28', '2017-12-27'),
(575, 9, 1, 2, 'DC27289596913508', 10, '10.50', 1, '', '2017-12-27 06:55:59', '2017-12-27'),
(576, 12, 1, 2, 'DC27330977851026', 9, '5971.82', 20, '', '2017-12-27 08:04:57', '2017-12-27'),
(577, 17, 1, 1, 'DC27374338211555', 23, '1113.00', 4, '', '2017-12-27 09:17:13', '2017-12-27'),
(578, 4, 1, 2, 'DC27414976262737', 10, '180.00', 1, '', '2017-12-27 10:24:57', '2017-12-27'),
(579, 11, 2, 2, 'DC27743130079388', 26, '887.80', 5, '', '2017-12-27 19:31:53', '2017-12-28');
INSERT INTO `purchasingorder` (`id`, `seller`, `buyer`, `status`, `trade_no`, `wid`, `total`, `amount`, `remark`, `create_time`, `delivery_date`) VALUES
(580, 4, 1, 2, 'DC27753412710951', 10, '130.00', 1, '', '2017-12-27 19:49:01', '2017-12-28'),
(581, 8, 1, 2, 'DC27753894123316', 10, '52.50', 1, '', '2017-12-27 19:49:49', '2017-12-28'),
(582, 3, 1, 2, 'DC27754155376758', 10, '25.00', 1, '', '2017-12-27 19:50:15', '2017-12-28'),
(583, 9, 1, 2, 'DC27754423192658', 10, '21.00', 2, '', '2017-12-27 19:50:42', '2017-12-28'),
(584, 1, 1, 2, 'DC27754913355186', 10, '230.00', 3, '', '2017-12-27 19:51:31', '2017-12-28'),
(585, 15, 1, 2, 'DC27763415807764', 28, '1282.75', 12, '', '2017-12-27 20:05:41', '2017-12-28'),
(586, 16, 1, 2, 'DC27764313319210', 28, '1117.00', 7, '', '2017-12-27 20:07:11', '2017-12-28'),
(587, 18, 1, 2, 'DC27765054735009', 28, '154.50', 7, '', '2017-12-27 20:08:25', '2017-12-28'),
(588, 19, 1, 2, 'DC27765536772459', 28, '432.00', 3, '', '2017-12-27 20:09:13', '2017-12-28'),
(589, 0, 1, 2, 'DC27772125763024', 10, '1326.00', 11, '', '2017-12-27 20:20:12', '2017-12-27'),
(590, 23, 1, 2, 'DC28922601243111', 9, '514.40', 9, '', '2017-12-28 00:31:00', '2017-12-28'),
(591, 26, 1, 1, 'DC28923946729131', 9, '0.00', 5, '', '2017-12-28 00:33:14', '2017-12-28'),
(592, 10, 1, 4, 'DC28926002536670', 9, '1927.30', 15, '', '2017-12-28 00:36:40', '2017-12-28'),
(593, 25, 1, 2, 'DC28926385979024', 9, '73.00', 2, '', '2017-12-28 00:37:18', '2017-12-28'),
(594, 24, 1, 2, 'DC28926695670596', 9, '394.50', 2, '', '2017-12-28 00:37:49', '2017-12-28'),
(595, 31, 1, 2, 'DC28927578025553', 9, '240.00', 2, '', '2017-12-28 00:39:17', '2017-12-28'),
(596, 22, 1, 2, 'DC28928359129345', 9, '290.25', 2, '', '2017-12-28 00:40:35', '2017-12-28'),
(597, 28, 1, 2, 'DC28928979762203', 9, '366.50', 3, '', '2017-12-28 00:41:37', '2017-12-28'),
(598, 21, 1, 2, 'DC28930210871712', 9, '1673.50', 10, '', '2017-12-28 00:43:41', '2017-12-28'),
(599, 0, 1, 4, 'DC28143212971851', 23, '1050.00', 4, '', '2017-12-28 06:38:41', '2017-12-28'),
(600, 14, 1, 2, 'DC28144051560196', 23, '120.40', 2, '', '2017-12-28 06:40:05', '2017-12-28'),
(601, 13, 1, 2, 'DC28145120615887', 23, '333.50', 8, '', '2017-12-28 06:41:52', '2017-12-28'),
(602, 0, 1, 2, 'DC28150331832493', 23, '583.20', 1, '', '2017-12-28 06:50:33', '2017-12-27'),
(603, 0, 1, 2, 'DC28251812276780', 10, '747.50', 9, '', '2017-12-28 09:39:41', '2017-12-28'),
(604, 11, 2, 2, 'DC28657908938891', 26, '444.00', 3, '', '2017-12-28 20:56:30', '2017-12-29'),
(605, 15, 1, 2, 'DC28663629058472', 28, '3617.60', 28, '', '2017-12-28 21:06:02', '2017-12-29'),
(606, 16, 1, 2, 'DC28663746713967', 28, '962.50', 10, '', '2017-12-28 21:06:14', '2017-12-29'),
(607, 18, 1, 2, 'DC28663827494725', 28, '1360.75', 20, '', '2017-12-28 21:06:22', '2017-12-29'),
(608, 19, 1, 2, 'DC28663918119138', 28, '640.00', 3, '', '2017-12-28 21:06:31', '2017-12-29'),
(609, 8, 1, 2, 'DC28706742220066', 10, '183.00', 5, '', '2017-12-28 22:17:54', '2017-12-29'),
(610, 1, 1, 2, 'DC28707217685747', 10, '455.00', 3, '', '2017-12-28 22:18:41', '2017-12-29'),
(611, 4, 1, 2, 'DC28707531590025', 10, '2780.00', 2, '', '2017-12-28 22:19:13', '2017-12-29'),
(612, 21, 1, 2, 'DC29806267709944', 9, '1320.75', 11, '', '2017-12-29 01:03:46', '2017-12-29'),
(613, 31, 1, 2, 'DC29806868647472', 9, '207.60', 2, '', '2017-12-29 01:04:46', '2017-12-29'),
(614, 22, 1, 2, 'DC29807370522402', 9, '261.00', 3, '', '2017-12-29 01:05:37', '2017-12-29'),
(615, 28, 1, 2, 'DC29807976928605', 9, '217.00', 3, '', '2017-12-29 01:06:37', '2017-12-29'),
(616, 25, 1, 2, 'DC29808255053688', 9, '61.00', 1, '', '2017-12-29 01:07:05', '2017-12-29'),
(617, 24, 1, 2, 'DC29808657553649', 9, '442.30', 4, '', '2017-12-29 01:07:45', '2017-12-29'),
(618, 23, 1, 2, 'DC29810165522461', 9, '466.80', 8, '', '2017-12-29 01:10:16', '2017-12-29'),
(619, 26, 1, 1, 'DC29811293647487', 9, '0.00', 6, '', '2017-12-29 01:12:09', '2017-12-29'),
(620, 10, 1, 2, 'DC29821728178643', 9, '2059.90', 17, '', '2017-12-29 01:29:32', '2017-12-29'),
(621, 31, 1, 2, 'DC29822644741182', 9, '9.00', 1, '', '2017-12-29 01:31:04', '2017-12-29'),
(622, 13, 1, 4, 'DC29064390612796', 23, '553.45', 14, '', '2017-12-29 08:13:59', '2017-12-29'),
(623, 14, 1, 2, 'DC29066165200831', 23, '139.20', 5, '', '2017-12-29 08:16:56', '2017-12-29'),
(624, 3, 1, 2, 'DC29111501201303', 10, '50.00', 1, '', '2017-12-29 09:32:30', '2017-12-29'),
(625, 11, 2, 2, 'DC29461894924401', 26, '465.64', 4, '', '2017-12-29 19:16:29', '2017-12-30'),
(632, 0, 1, 2, 'DC29473559768281', 10, '532.00', 15, '', '2017-12-29 19:35:55', '2017-12-30'),
(633, 1, 1, 2, 'DC29484604455763', 10, '517.50', 3, '', '2017-12-29 19:54:20', '2017-12-30'),
(634, 15, 1, 2, 'DC29493372855520', 28, '389.50', 6, '', '2017-12-29 20:08:57', '2017-12-30'),
(635, 16, 1, 2, 'DC29494014413991', 28, '414.50', 5, '', '2017-12-29 20:10:01', '2017-12-30'),
(636, 18, 1, 2, 'DC29494557691794', 28, '75.00', 3, '', '2017-12-29 20:10:55', '2017-12-30'),
(637, 19, 1, 2, 'DC29494810346323', 28, '80.00', 1, '', '2017-12-29 20:11:21', '2017-12-30'),
(638, 13, 1, 2, 'DC29540605834597', 23, '71.00', 4, '', '2017-12-29 21:27:40', '2017-12-30'),
(639, 14, 1, 2, 'DC29540967238445', 23, '5.60', 1, '', '2017-12-29 21:28:16', '2017-12-30'),
(644, 21, 1, 2, 'DC30871923480760', 9, '1561.00', 8, '', '2017-12-30 06:39:52', '2017-12-31'),
(645, 31, 1, 2, 'DC30872627860250', 9, '116.70', 2, '', '2017-12-30 06:41:02', '2017-12-30'),
(646, 22, 1, 2, 'DC30872901768274', 9, '147.75', 2, '', '2017-12-30 06:41:30', '2017-12-30'),
(647, 28, 1, 2, 'DC30873244582980', 9, '322.00', 2, '', '2017-12-30 06:42:04', '2017-12-30'),
(648, 25, 1, 2, 'DC30873556616101', 9, '63.00', 2, '', '2017-12-30 06:42:35', '2017-12-30'),
(649, 24, 1, 2, 'DC30873848805563', 9, '249.90', 2, '', '2017-12-30 06:43:04', '2017-12-30'),
(650, 10, 1, 4, 'DC30875713348721', 9, '1167.00', 12, '', '2017-12-30 06:46:11', '2017-12-30'),
(651, 26, 1, 1, 'DC30876517416385', 9, '0.00', 5, '', '2017-12-30 06:47:31', '2017-12-30'),
(652, 23, 1, 2, 'DC30877384921995', 9, '358.70', 8, '', '2017-12-30 06:48:58', '2017-12-30'),
(653, 12, 1, 2, 'DC30926995452339', 9, '6529.37', 21, '', '2017-12-30 08:11:39', '2017-12-28'),
(654, 12, 1, 2, 'DC30929318250085', 9, '6357.29', 22, '', '2017-12-30 08:15:31', '2017-12-29'),
(655, 12, 1, 2, 'DC30930841834055', 9, '3973.32', 17, '', '2017-12-30 08:18:04', '2017-12-30'),
(656, 0, 4, 2, 'DC30202013067593', 59, '5.00', 1, '', '2017-12-30 15:50:01', '2017-12-31'),
(657, 11, 2, 2, 'DC30351604945714', 26, '350.50', 3, '', '2017-12-30 19:59:20', '2017-12-31'),
(658, 15, 1, 2, 'DC30371455199815', 28, '680.50', 6, '', '2017-12-30 20:32:25', '2017-12-31'),
(659, 16, 1, 2, 'DC30372653179659', 28, '416.00', 7, '', '2017-12-30 20:34:25', '2017-12-31'),
(660, 18, 1, 4, 'DC30373409585894', 28, '360.50', 9, '', '2017-12-30 20:35:40', '2017-12-31'),
(661, 19, 1, 2, 'DC30373586304691', 28, '39.00', 1, '', '2017-12-30 20:35:58', '2017-12-31'),
(662, 0, 1, 2, 'DC31871404509423', 28, '234.10', 3, '', '2017-12-31 10:25:40', '2017-12-31'),
(663, 12, 1, 2, 'DC31910565065854', 9, '3648.53', 15, '', '2017-12-31 11:30:56', '2017-12-31'),
(664, 21, 1, 1, 'DC31925225440743', 9, '0.00', 13, '', '2017-12-31 11:55:22', '2017-12-31'),
(665, 22, 1, 2, 'DC31925820905691', 9, '133.50', 2, '', '2017-12-31 11:56:22', '2017-12-31'),
(666, 31, 1, 2, 'DC31926252621688', 9, '82.80', 2, '', '2017-12-31 11:57:05', '2017-12-31'),
(667, 28, 1, 2, 'DC31926414964375', 9, '109.50', 1, '', '2017-12-31 11:57:21', '2017-12-31'),
(668, 25, 1, 2, 'DC31926882461363', 9, '57.00', 2, '', '2017-12-31 11:58:08', '2017-12-31'),
(669, 24, 1, 2, 'DC31927333708515', 9, '166.50', 3, '', '2017-12-31 11:58:53', '2017-12-31'),
(670, 10, 1, 2, 'DC31928695574751', 9, '1036.90', 10, '', '2017-12-31 12:01:09', '2017-12-31'),
(671, 26, 1, 1, 'DC31929396664056', 9, '0.00', 4, '', '2017-12-31 12:02:19', '2017-12-31'),
(672, 23, 1, 2, 'DC31931037747258', 9, '337.20', 11, '', '2017-12-31 12:05:03', '2017-12-31'),
(673, 15, 1, 2, 'DC31232490094980', 28, '780.40', 9, '', '2017-12-31 20:27:29', '2018-01-01'),
(674, 16, 1, 2, 'DC31233250871323', 28, '249.00', 5, '', '2017-12-31 20:28:45', '2018-01-01'),
(675, 18, 1, 2, 'DC31233935241935', 28, '77.50', 3, '', '2017-12-31 20:29:53', '2018-01-01'),
(676, 3, 1, 2, 'DC31241974096745', 10, '2850.00', 2, '', '2017-12-31 20:43:17', '2017-12-31'),
(677, 11, 2, 2, 'DC31247240000510', 26, '771.55', 4, '', '2017-12-31 20:52:04', '2018-01-01'),
(678, 31, 1, 2, 'E101549015294553', 9, '156.90', 3, '', '2018-01-01 05:15:01', '2018-01-01'),
(679, 28, 1, 2, 'E101550255302590', 9, '175.50', 1, '', '2018-01-01 05:17:05', '2018-01-01'),
(680, 24, 1, 0, 'E101550792337212', 9, '0.00', 2, '', '2018-01-01 05:17:59', '2018-01-01'),
(681, 24, 1, 2, 'E101552250002766', 9, '335.90', 3, '', '2018-01-01 05:20:25', '2018-01-01'),
(682, 22, 1, 2, 'E101557904570217', 9, '129.75', 2, '', '2018-01-01 05:29:50', '2018-01-01'),
(683, 10, 1, 2, 'E101559997552375', 9, '932.70', 14, '', '2018-01-01 05:33:19', '2018-01-01'),
(684, 26, 1, 2, 'E101561394280086', 9, '1015.00', 6, '', '2018-01-01 05:35:39', '2018-01-01'),
(685, 23, 1, 2, 'E101562978508910', 9, '268.80', 7, '', '2018-01-01 05:38:17', '2018-01-01'),
(686, 25, 1, 2, 'E101563354605145', 9, '18.00', 2, '', '2018-01-01 05:38:55', '2018-01-01'),
(687, 21, 1, 2, 'E101565737276667', 9, '1440.65', 15, '', '2018-01-01 05:42:53', '2018-01-01'),
(688, 14, 1, 2, 'E101701961464534', 23, '128.40', 3, '', '2018-01-01 09:29:56', '2017-12-31'),
(689, 13, 1, 2, 'E101703927296011', 23, '75.00', 4, '', '2018-01-01 09:33:12', '2017-12-31'),
(690, 0, 1, 2, 'E101707766613118', 23, '1930.71', 5, '', '2018-01-01 09:39:36', '2017-12-30'),
(691, 0, 1, 2, 'E101709850859280', 23, '244.75', 6, '', '2018-01-01 09:43:05', '2017-12-31'),
(692, 0, 1, 4, 'E101711546328095', 23, '253.00', 11, '', '2018-01-01 09:45:54', '2018-01-01'),
(693, 13, 1, 2, 'E101711958984249', 23, '29.50', 2, '', '2018-01-01 09:46:35', '2018-01-01'),
(694, 14, 1, 2, 'E101712515859222', 23, '162.60', 4, '', '2018-01-01 09:47:31', '2018-01-01'),
(695, 12, 1, 2, 'E101765499008395', 9, '3016.66', 17, '', '2018-01-01 11:15:49', '2018-01-01'),
(696, 32, 1, 2, 'E101772442245178', 9, '18.40', 1, '', '2018-01-01 11:27:24', '2018-01-01'),
(697, 0, 1, 4, 'E101790939405884', 28, '144.00', 5, '', '2018-01-01 11:58:13', '2018-01-01'),
(698, 15, 1, 2, 'E101071442218468', 28, '1681.50', 13, '', '2018-01-01 19:45:44', '2018-01-02'),
(699, 16, 1, 2, 'E101072315187136', 28, '635.00', 7, '', '2018-01-01 19:47:11', '2018-01-02'),
(700, 18, 1, 1, 'E101073355494376', 28, '1028.00', 8, '', '2018-01-01 19:48:55', '2018-01-02'),
(701, 19, 1, 2, 'E101073655023639', 28, '116.00', 2, '', '2018-01-01 19:49:25', '2018-01-02'),
(702, 0, 1, 4, 'E101073980021502', 28, '45.50', 2, '', '2018-01-01 19:49:58', '2018-01-02'),
(703, 13, 1, 1, 'E101113252864925', 23, '0.00', 7, '', '2018-01-01 20:55:25', '2018-01-02'),
(704, 14, 1, 1, 'E101114759876872', 23, '0.00', 4, '', '2018-01-01 20:57:55', '2018-01-02'),
(705, 11, 2, 2, 'E101115057060523', 26, '1512.05', 3, '', '2018-01-01 20:58:25', '2018-01-02'),
(706, 21, 1, 2, 'E101217282665622', 9, '1929.40', 17, '', '2018-01-01 23:48:48', '2018-01-02'),
(707, 22, 1, 1, 'E101221069228103', 9, '0.00', 3, '', '2018-01-01 23:55:06', '2018-01-02'),
(708, 31, 1, 1, 'E101222752665684', 9, '0.00', 2, '', '2018-01-01 23:57:55', '2018-01-02'),
(709, 28, 1, 1, 'E101223290009413', 9, '0.00', 3, '', '2018-01-01 23:58:49', '2018-01-02'),
(710, 25, 1, 1, 'E101223765634448', 9, '0.00', 2, '', '2018-01-01 23:59:36', '2018-01-02'),
(711, 32, 1, 2, 'E102224416884431', 9, '49.40', 3, '', '2018-01-02 00:00:41', '2018-01-02'),
(712, 24, 1, 2, 'E102224624071943', 9, '206.70', 1, '', '2018-01-02 00:01:02', '2018-01-02'),
(713, 26, 1, 4, 'E102226707665668', 9, '1658.50', 9, '', '2018-01-02 00:04:30', '2018-01-02'),
(714, 21, 1, 0, 'E102228384696906', 9, '0.00', 10, '', '2018-01-02 00:07:18', '2018-01-02'),
(715, 23, 1, 2, 'E102230159071958', 9, '379.00', 10, '', '2018-01-02 00:10:15', '2018-01-02'),
(716, 10, 1, 2, 'E102503796214607', 9, '1064.95', 12, '', '2018-01-02 07:46:19', '2018-01-02'),
(717, 12, 1, 2, 'E102567877020938', 9, '8067.94', 23, '', '2018-01-02 09:33:07', '2018-01-02'),
(718, 1, 1, 2, 'E102575065230892', 23, '934.00', 6, '', '2018-01-02 09:45:06', '2018-01-02'),
(722, 0, 1, 2, 'E102629751733794', 23, '500.50', 10, '', '2018-01-02 11:16:15', '2018-01-02');

-- --------------------------------------------------------

--
-- 表的结构 `role`
--

CREATE TABLE `role` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_name` varchar(50) NOT NULL COMMENT '角色名',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `remark` varchar(80) NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色';

--
-- 转存表中的数据 `role`
--

INSERT INTO `role` (`id`, `role_name`, `create_time`, `remark`) VALUES
(1, '超级管理员', '2017-12-05 07:57:07', '');

-- --------------------------------------------------------

--
-- 表的结构 `roleaccess`
--

CREATE TABLE `roleaccess` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL COMMENT '角色ID',
  `func_id` int(10) UNSIGNED NOT NULL COMMENT '原子功能ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限';

--
-- 转存表中的数据 `roleaccess`
--

INSERT INTO `roleaccess` (`id`, `role_id`, `func_id`) VALUES
(1, 1, 1),
(2, 1, 303),
(3, 1, 328),
(4, 1, 336),
(5, 1, 335),
(6, 1, 334),
(7, 1, 333),
(8, 1, 332),
(9, 1, 331),
(10, 1, 330),
(11, 1, 329),
(12, 1, 322),
(13, 1, 327),
(14, 1, 326),
(15, 1, 325),
(16, 1, 324),
(17, 1, 323),
(18, 1, 319),
(19, 1, 321),
(20, 1, 320),
(21, 1, 314),
(22, 1, 318),
(23, 1, 317),
(24, 1, 316),
(25, 1, 315),
(26, 1, 307),
(27, 1, 313),
(28, 1, 312),
(29, 1, 311),
(30, 1, 310),
(31, 1, 309),
(32, 1, 308),
(33, 1, 304),
(34, 1, 306),
(35, 1, 305),
(36, 1, 52),
(37, 1, 82),
(38, 1, 85),
(39, 1, 84),
(40, 1, 83),
(41, 1, 76),
(42, 1, 81),
(43, 1, 80),
(44, 1, 79),
(45, 1, 78),
(46, 1, 77),
(47, 1, 71),
(48, 1, 75),
(49, 1, 74),
(50, 1, 73),
(51, 1, 72),
(52, 1, 66),
(53, 1, 286),
(54, 1, 70),
(55, 1, 69),
(56, 1, 68),
(57, 1, 67),
(58, 1, 61),
(59, 1, 65),
(60, 1, 64),
(61, 1, 63),
(62, 1, 62),
(63, 1, 56),
(64, 1, 60),
(65, 1, 59),
(66, 1, 58),
(67, 1, 57),
(68, 1, 53),
(69, 1, 55),
(70, 1, 54),
(71, 1, 41),
(72, 1, 46),
(73, 1, 51),
(74, 1, 50),
(75, 1, 49),
(76, 1, 48),
(77, 1, 47),
(78, 1, 42),
(79, 1, 45),
(80, 1, 44),
(81, 1, 43),
(82, 1, 4),
(83, 1, 193),
(84, 1, 199),
(85, 1, 198),
(86, 1, 197),
(87, 1, 196),
(88, 1, 195),
(89, 1, 194),
(90, 1, 39),
(91, 1, 40),
(92, 1, 34),
(93, 1, 38),
(94, 1, 37),
(95, 1, 36),
(96, 1, 35),
(97, 1, 32),
(98, 1, 33),
(99, 1, 27),
(100, 1, 31),
(101, 1, 30),
(102, 1, 29),
(103, 1, 28),
(104, 1, 25),
(105, 1, 26),
(106, 1, 18),
(107, 1, 24),
(108, 1, 23),
(109, 1, 22),
(110, 1, 21),
(111, 1, 20),
(112, 1, 19),
(113, 1, 12),
(114, 1, 17),
(115, 1, 16),
(116, 1, 15),
(117, 1, 14),
(118, 1, 13),
(119, 1, 7),
(120, 1, 11),
(121, 1, 10),
(122, 1, 9),
(123, 1, 8);

-- --------------------------------------------------------

--
-- 表的结构 `seller`
--

CREATE TABLE `seller` (
  `id` int(11) NOT NULL COMMENT '卖家',
  `name` varchar(28) NOT NULL COMMENT '卖家名称',
  `description` varchar(88) NOT NULL COMMENT '卖家简介',
  `tel` varchar(80) DEFAULT '' COMMENT '联系电话',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态:0-吊销,1-营业',
  `rank` int(11) NOT NULL DEFAULT '0' COMMENT '公司排序',
  `tag` varchar(88) NOT NULL COMMENT '标签',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='卖家';

--
-- 转存表中的数据 `seller`
--

INSERT INTO `seller` (`id`, `name`, `description`, `tel`, `status`, `rank`, `tag`, `create_time`) VALUES
(1, '（五里店）小刘调料', '供货商简介', '18007877303', 1, 0, '', '2017-11-30 15:37:04'),
(2, '（西门）谭采购', '优秀、新鲜、快速送达', '18007877303', 1, 0, '', '2017-12-03 22:04:03'),
(3, '（汇东）龙干杂', '汇东', '', 1, 0, '', '2017-12-04 09:51:29'),
(4, '（五里店）老周蛋类', '五里店', '', 1, 0, '', '2017-12-04 09:51:49'),
(5, '（汇东）彭牛奶总代', '汇东', '', 1, 0, '', '2017-12-04 09:52:05'),
(6, '（五里店）小白干货辣椒', '五里店', '', 1, 0, '', '2017-12-04 09:52:49'),
(7, '测试账号', '测试订单，请勿点击', '', 1, 0, '', '2017-12-04 18:21:07'),
(8, '（七星农贸）向荣豆腐', '七星农贸', '', 1, 0, '', '2017-12-05 08:52:20'),
(9, '（七星农贸）陶面店', '七星农贸', '', 1, 0, '', '2017-12-05 09:01:57'),
(10, '（大圩）陈青菜', '大圩', '', 1, 0, '', '2017-12-08 08:58:41'),
(11, '（金鸡岭）鸡鸭秦', '康宏配送', '', 1, 0, '', '2017-12-11 09:14:35'),
(12, '（桂磨路）李猪肉', '猪肉销售', '', 1, 0, '', '2017-12-11 09:24:06'),
(13, '（汇东）鲜果行', '', '', 1, 0, '', '2017-12-11 10:28:37'),
(14, '（大风山）米粉', '米粉销售', '', 1, 0, '', '2017-12-11 21:07:18'),
(15, '（瓦窑）鱼羊狗', '肉类销售', '', 1, 0, '', '2017-12-11 21:10:24'),
(16, '（西门）左鸡鸭', '鸡鸭销售', '', 1, 0, '', '2017-12-11 21:14:08'),
(17, '（五里店）红薯', '红薯销售', '', 1, 0, '', '2017-12-12 17:49:58'),
(18, '（瓦窑）冻库', '冻品销售', '', 1, 0, '', '2017-12-12 18:06:32'),
(19, '（瓦窑）牛肉', '牛肉销售', '', 1, 0, '', '2017-12-12 19:16:14'),
(20, '（瓦窑）鸡鸭', '鸡鸭销售', '', 1, 0, '', '2017-12-13 20:21:16'),
(21, '（汇东）蔬菜章明', '蔬菜销售', '', 1, 0, '', '2017-12-16 00:17:55'),
(22, '（汇东）豆芽', '豆芽', '', 1, 0, '', '2017-12-16 00:40:09'),
(23, '（汇东）酸菜', '酸菜', '', 1, 0, '', '2017-12-16 00:41:23'),
(24, '（汇东）玉米', '玉米', '', 1, 0, '', '2017-12-16 09:32:04'),
(25, '（汇东）牛血', '牛血', '', 1, 0, '', '2017-12-16 09:36:29'),
(26, '（汇东）香菇', '香菇', '', 1, 0, '', '2017-12-16 10:09:58'),
(27, '香香果蔬', '蔬菜销售', '', 1, 0, '', '2017-12-17 21:39:04'),
(28, '（五里店）莲藕', '莲藕销售', '', 1, 0, '', '2017-12-17 22:27:10'),
(29, '（汇东）大白菜', '大白菜', '', 1, 0, '', '2017-12-18 23:55:58'),
(30, '灌阳土猪肉', '肉类销售', '', 1, 0, '', '2017-12-19 20:10:56'),
(31, '（汇东）葱花', '葱花销售', '', 1, 0, '', '2017-12-20 22:45:35'),
(32, '（汇东）青豆', '', '', 1, 0, '', '2018-01-01 11:18:34');

-- --------------------------------------------------------

--
-- 表的结构 `sellerbinding`
--

CREATE TABLE `sellerbinding` (
  `id` int(11) NOT NULL,
  `wid` int(11) NOT NULL COMMENT '用户ID',
  `seller` int(11) NOT NULL COMMENT '卖家'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='卖家绑定';

--
-- 转存表中的数据 `sellerbinding`
--

INSERT INTO `sellerbinding` (`id`, `wid`, `seller`) VALUES
(101, 1, 21),
(78, 4, 27),
(100, 5, 25),
(91, 8, 25),
(7, 11, 1),
(8, 12, 6),
(9, 13, 4),
(10, 14, 5),
(11, 15, 3),
(16, 17, 8),
(17, 18, 9),
(31, 21, 10),
(38, 24, 12),
(37, 25, 11),
(39, 27, 13),
(40, 29, 14),
(41, 30, 15),
(42, 31, 16),
(43, 32, 16),
(44, 33, 16),
(49, 34, 17),
(56, 35, 19),
(51, 36, 18),
(54, 37, 15),
(61, 41, 20),
(68, 44, 21),
(82, 45, 22),
(70, 46, 23),
(85, 47, 22),
(71, 48, 24),
(72, 49, 25),
(73, 50, 26),
(80, 52, 28),
(84, 53, 12),
(90, 54, 29),
(92, 56, 30),
(96, 57, 31),
(102, 60, 32);

-- --------------------------------------------------------

--
-- 表的结构 `sellerstatistic`
--

CREATE TABLE `sellerstatistic` (
  `id` int(10) UNSIGNED NOT NULL,
  `seller` int(11) NOT NULL COMMENT '卖家',
  `money` decimal(9,2) NOT NULL COMMENT '销售额',
  `order_amount` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单数',
  `date` date DEFAULT NULL COMMENT '日期'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='卖家统计';

--
-- 转存表中的数据 `sellerstatistic`
--

INSERT INTO `sellerstatistic` (`id`, `seller`, `money`, `order_amount`, `date`) VALUES
(1, 4, '2700.00', 1, '2017-12-05'),
(2, 1, '524.00', 1, '2017-12-05'),
(4, 2, '44.00', 1, '2017-12-05'),
(7, 1, '850.00', 1, '2017-12-06'),
(8, 4, '2530.00', 1, '2017-12-06'),
(9, 3, '190.00', 1, '2017-12-06'),
(10, 8, '28.00', 1, '2017-12-01'),
(11, 8, '46.50', 1, '2017-12-02'),
(13, 8, '86.00', 1, '2017-12-04'),
(14, 8, '441.50', 1, '2017-12-05'),
(15, 9, '301.00', 1, '2017-12-02'),
(16, 9, '308.00', 1, '2017-12-03'),
(17, 9, '304.50', 1, '2017-12-04'),
(18, 9, '304.50', 1, '2017-12-05'),
(19, 1, '170.00', 1, '2017-12-01'),
(20, 1, '2980.00', 1, '2017-12-02'),
(21, 1, '524.00', 2, '2017-12-03'),
(22, 9, '339.50', 1, '2017-12-06'),
(23, 8, '125.80', 1, '2017-12-06'),
(24, 8, '66.50', 1, '2017-12-03'),
(25, 1, '295.00', 1, '2017-12-07'),
(26, 8, '70.00', 1, '2017-12-07'),
(27, 4, '405.00', 1, '2017-12-07'),
(28, 2, '90.00', 1, '2017-12-07'),
(29, 9, '360.50', 1, '2017-12-07'),
(32, 1, '530.00', 1, '2017-12-08'),
(33, 9, '23.50', 1, '2017-12-08'),
(34, 2, '35.00', 1, '2017-12-08'),
(35, 8, '69.00', 1, '2017-12-08'),
(38, 1, '110.00', 1, '2017-12-09'),
(39, 10, '2400.10', 1, '2017-12-01'),
(40, 10, '1728.40', 1, '2017-12-02'),
(41, 8, '59.00', 1, '2017-12-09'),
(42, 10, '1723.20', 1, '2017-12-03'),
(43, 10, '2269.75', 1, '2017-12-04'),
(44, 10, '2497.20', 1, '2017-12-05'),
(45, 10, '2438.60', 1, '2017-12-06'),
(46, 10, '2220.40', 1, '2017-12-07'),
(47, 10, '2345.10', 1, '2017-12-08'),
(49, 0, '539.20', 3, '2017-12-09'),
(50, 10, '1822.70', 1, '2017-12-09'),
(51, 2, '42.00', 1, '2017-12-09'),
(52, 3, '265.00', 1, '2017-12-04'),
(53, 3, '1390.00', 1, '2017-12-02'),
(54, 3, '70.00', 1, '2017-12-01'),
(55, 0, '185.80', 2, '2017-12-01'),
(56, 0, '376.40', 3, '2017-12-03'),
(57, 0, '299.00', 1, '2017-12-04'),
(58, 0, '806.00', 1, '2017-12-05'),
(59, 0, '60.50', 1, '2017-12-06'),
(60, 0, '44.50', 1, '2017-12-07'),
(61, 0, '94.00', 1, '2017-12-08'),
(62, 8, '20.00', 1, '2017-12-10'),
(63, 10, '1898.10', 1, '2017-12-10'),
(64, 1, '3875.00', 1, '2017-12-11'),
(65, 2, '88.00', 1, '2017-12-11'),
(66, 0, '362.80', 2, '2017-12-10'),
(68, 10, '2241.30', 1, '2017-12-11'),
(72, 8, '64.25', 1, '2017-12-11'),
(73, 0, '141.00', 1, '2017-12-11'),
(74, 14, '272.00', 1, '2017-12-01'),
(75, 14, '75.00', 1, '2017-12-02'),
(76, 14, '93.80', 1, '2017-12-03'),
(77, 14, '180.20', 1, '2017-12-04'),
(78, 14, '110.80', 1, '2017-12-05'),
(79, 14, '242.40', 1, '2017-12-06'),
(80, 14, '28.00', 1, '2017-12-07'),
(81, 14, '151.80', 1, '2017-12-08'),
(82, 14, '80.20', 1, '2017-12-09'),
(83, 13, '260.10', 1, '2017-12-03'),
(84, 13, '101.80', 1, '2017-12-01'),
(85, 14, '131.20', 1, '2017-12-10'),
(86, 14, '170.60', 1, '2017-12-11'),
(87, 13, '327.90', 1, '2017-12-04'),
(88, 13, '117.50', 1, '2017-12-05'),
(89, 13, '240.75', 1, '2017-12-06'),
(90, 13, '290.50', 1, '2017-12-07'),
(91, 13, '234.10', 1, '2017-12-11'),
(92, 13, '214.70', 1, '2017-12-10'),
(93, 13, '101.20', 1, '2017-12-09'),
(94, 13, '240.50', 1, '2017-12-08'),
(95, 11, '990.95', 1, '2017-12-12'),
(96, 10, '2330.30', 1, '2017-12-12'),
(97, 0, '403.70', 3, '2017-12-13'),
(98, 0, '416.50', 2, '2017-12-12'),
(100, 13, '57.00', 1, '2017-12-12'),
(101, 14, '172.00', 1, '2017-12-12'),
(102, 8, '336.75', 1, '2017-12-12'),
(103, 3, '140.00', 1, '2017-12-12'),
(104, 17, '550.00', 1, '2017-12-02'),
(105, 17, '65.00', 1, '2017-12-03'),
(106, 17, '175.00', 1, '2017-12-05'),
(107, 17, '1410.00', 1, '2017-12-07'),
(108, 17, '240.00', 1, '2017-12-10'),
(109, 17, '1200.00', 1, '2017-12-11'),
(110, 0, '19.50', 1, '2017-12-02'),
(111, 18, '1457.00', 1, '2017-12-01'),
(112, 18, '242.50', 1, '2017-12-02'),
(113, 18, '480.00', 1, '2017-12-03'),
(114, 18, '232.10', 1, '2017-12-04'),
(115, 15, '2172.95', 1, '2017-12-01'),
(116, 15, '82.50', 1, '2017-12-02'),
(117, 18, '95.00', 1, '2017-12-11'),
(118, 18, '56.00', 1, '2017-12-10'),
(119, 18, '988.50', 1, '2017-12-09'),
(120, 18, '135.50', 1, '2017-12-07'),
(121, 18, '89.00', 1, '2017-12-05'),
(122, 15, '848.00', 1, '2017-12-03'),
(123, 15, '609.50', 1, '2017-12-04'),
(124, 15, '1735.50', 1, '2017-12-05'),
(125, 15, '480.75', 1, '2017-12-06'),
(126, 15, '1952.00', 1, '2017-12-07'),
(127, 4, '3925.00', 1, '2017-12-13'),
(128, 15, '1315.50', 1, '2017-12-08'),
(129, 15, '978.00', 1, '2017-12-09'),
(130, 15, '567.00', 1, '2017-12-10'),
(131, 15, '1460.50', 1, '2017-12-11'),
(132, 15, '1360.00', 1, '2017-12-12'),
(133, 18, '364.50', 1, '2017-12-12'),
(135, 16, '784.50', 1, '2017-12-13'),
(137, 18, '1685.00', 1, '2017-12-13'),
(138, 19, '1461.00', 1, '2017-12-13'),
(139, 1, '589.00', 1, '2017-12-13'),
(141, 8, '114.00', 1, '2017-12-13'),
(142, 11, '1094.20', 1, '2017-12-13'),
(143, 3, '1180.00', 1, '2017-12-13'),
(145, 15, '733.20', 1, '2017-12-13'),
(146, 14, '3279.60', 1, '2017-12-13'),
(147, 16, '916.80', 1, '2017-12-01'),
(148, 16, '1767.94', 1, '2017-12-02'),
(149, 16, '1680.98', 1, '2017-12-03'),
(150, 16, '1900.24', 1, '2017-12-04'),
(151, 16, '1660.19', 1, '2017-12-05'),
(152, 13, '338.50', 1, '2017-12-13'),
(153, 16, '1109.30', 1, '2017-12-06'),
(154, 16, '195.50', 1, '2017-12-07'),
(155, 16, '641.00', 1, '2017-12-08'),
(156, 16, '337.40', 1, '2017-12-09'),
(157, 16, '325.50', 1, '2017-12-10'),
(158, 16, '665.00', 1, '2017-12-11'),
(159, 16, '347.20', 1, '2017-12-12'),
(160, 19, '471.00', 1, '2017-12-01'),
(161, 19, '1498.00', 1, '2017-12-02'),
(162, 19, '624.00', 1, '2017-12-03'),
(163, 19, '474.00', 1, '2017-12-04'),
(164, 19, '1060.00', 1, '2017-12-05'),
(165, 19, '925.00', 1, '2017-12-06'),
(166, 19, '264.00', 1, '2017-12-07'),
(167, 19, '1052.00', 1, '2017-12-08'),
(168, 19, '389.00', 1, '2017-12-09'),
(169, 19, '128.00', 1, '2017-12-10'),
(170, 19, '244.00', 1, '2017-12-11'),
(171, 19, '336.00', 1, '2017-12-12'),
(173, 1, '626.00', 1, '2017-12-14'),
(174, 19, '512.00', 1, '2017-12-14'),
(175, 10, '714.80', 1, '2017-12-13'),
(176, 16, '344.50', 1, '2017-12-14'),
(177, 18, '559.00', 1, '2017-12-14'),
(178, 10, '827.60', 1, '2017-12-14'),
(179, 13, '221.00', 1, '2017-12-14'),
(180, 12, '8103.30', 1, '2017-12-14'),
(181, 15, '1102.50', 1, '2017-12-14'),
(182, 14, '274.60', 1, '2017-12-14'),
(183, 12, '7947.66', 1, '2017-12-13'),
(184, 8, '94.00', 1, '2017-12-14'),
(185, 0, '744.00', 2, '2017-12-14'),
(187, 16, '198.50', 1, '2017-12-15'),
(188, 13, '17.50', 1, '2017-12-15'),
(189, 1, '35.00', 1, '2017-12-15'),
(190, 9, '28.00', 2, '2017-12-16'),
(191, 11, '660.76', 1, '2017-12-14'),
(193, 12, '7104.05', 1, '2017-12-15'),
(194, 10, '918.15', 1, '2017-12-15'),
(196, 14, '66.00', 1, '2017-12-15'),
(197, 0, '428.50', 2, '2017-12-15'),
(198, 11, '931.00', 1, '2017-12-15'),
(199, 15, '1561.00', 1, '2017-12-15'),
(200, 16, '114.00', 1, '2017-12-16'),
(201, 19, '715.00', 1, '2017-12-16'),
(202, 14, '60.00', 1, '2017-12-16'),
(203, 1, '516.00', 1, '2017-12-16'),
(204, 8, '25.00', 1, '2017-12-16'),
(205, 4, '135.00', 1, '2017-12-16'),
(206, 18, '268.50', 1, '2017-12-15'),
(207, 12, '6951.95', 1, '2017-12-01'),
(208, 21, '2953.00', 1, '2017-12-16'),
(209, 18, '334.50', 1, '2017-12-16'),
(210, 13, '180.00', 1, '2017-12-16'),
(211, 10, '511.20', 1, '2017-12-16'),
(213, 15, '548.00', 1, '2017-12-16'),
(215, 8, '38.00', 1, '2017-12-15'),
(216, 0, '232.00', 3, '2017-12-16'),
(217, 17, '240.00', 1, '2017-12-16'),
(218, 14, '133.60', 1, '2017-12-17'),
(219, 19, '577.00', 1, '2017-12-17'),
(220, 3, '580.00', 1, '2017-12-17'),
(221, 18, '350.00', 1, '2017-12-17'),
(222, 0, '633.00', 3, '2017-12-17'),
(223, 11, '720.20', 1, '2017-12-16'),
(224, 11, '771.20', 1, '2017-12-17'),
(225, 1, '159.00', 1, '2017-12-17'),
(226, 13, '237.85', 1, '2017-12-17'),
(227, 16, '269.00', 1, '2017-12-17'),
(228, 15, '1047.00', 1, '2017-12-17'),
(229, 8, '21.25', 1, '2017-12-17'),
(230, 26, '1134.00', 1, '2017-12-02'),
(232, 12, '9703.07', 1, '2017-12-02'),
(233, 12, '5366.41', 1, '2017-12-16'),
(234, 12, '6381.95', 1, '2017-12-17'),
(235, 12, '10660.90', 1, '2017-12-03'),
(236, 12, '17399.91', 1, '2017-12-04'),
(237, 24, '389.60', 1, '2017-12-17'),
(238, 24, '249.80', 1, '2017-12-16'),
(239, 12, '10940.06', 1, '2017-12-05'),
(240, 12, '8594.48', 1, '2017-12-06'),
(241, 23, '599.90', 1, '2017-12-01'),
(242, 1, '522.00', 1, '2017-12-18'),
(243, 0, '948.50', 3, '2017-12-18'),
(244, 19, '284.00', 2, '2017-12-18'),
(245, 16, '294.50', 1, '2017-12-18'),
(246, 9, '10.50', 1, '2017-12-18'),
(247, 23, '758.10', 1, '2017-12-02'),
(248, 28, '326.00', 1, '2017-12-18'),
(249, 28, '283.00', 1, '2017-12-01'),
(250, 28, '332.00', 1, '2017-12-02'),
(251, 28, '286.00', 1, '2017-12-03'),
(252, 23, '644.70', 1, '2017-12-15'),
(253, 28, '345.50', 1, '2017-12-04'),
(254, 28, '434.00', 1, '2017-12-05'),
(255, 28, '306.50', 1, '2017-12-06'),
(256, 28, '394.00', 1, '2017-12-07'),
(257, 28, '377.00', 1, '2017-12-08'),
(258, 28, '283.50', 1, '2017-12-09'),
(259, 23, '759.90', 1, '2017-12-14'),
(260, 28, '275.50', 1, '2017-12-10'),
(261, 23, '703.55', 1, '2017-12-13'),
(262, 23, '655.35', 1, '2017-12-03'),
(263, 23, '696.45', 1, '2017-12-05'),
(264, 23, '737.80', 1, '2017-12-06'),
(265, 23, '673.80', 1, '2017-12-07'),
(266, 23, '712.60', 1, '2017-12-08'),
(267, 23, '562.90', 1, '2017-12-09'),
(268, 23, '544.85', 1, '2017-12-10'),
(269, 23, '657.80', 1, '2017-12-11'),
(270, 28, '315.50', 1, '2017-12-11'),
(271, 28, '465.00', 1, '2017-12-12'),
(272, 28, '298.00', 1, '2017-12-13'),
(273, 28, '311.00', 1, '2017-12-15'),
(274, 28, '406.50', 1, '2017-12-16'),
(275, 28, '267.50', 1, '2017-12-17'),
(276, 23, '762.00', 1, '2017-12-12'),
(277, 23, '929.60', 1, '2017-12-04'),
(278, 21, '2406.80', 1, '2017-12-01'),
(279, 21, '2834.90', 1, '2017-12-02'),
(280, 21, '7014.60', 2, '2017-12-03'),
(281, 14, '30.00', 1, '2017-12-18'),
(282, 24, '457.00', 1, '2017-12-18'),
(283, 18, '202.00', 1, '2017-12-18'),
(284, 11, '635.80', 1, '2017-12-18'),
(285, 13, '299.37', 1, '2017-12-18'),
(286, 22, '228.75', 1, '2017-12-18'),
(287, 12, '8650.36', 1, '2017-12-18'),
(288, 21, '2982.20', 1, '2017-12-17'),
(289, 21, '5442.50', 1, '2017-12-04'),
(290, 23, '2212.25', 3, '2017-12-18'),
(291, 10, '827.85', 1, '2017-12-18'),
(292, 15, '2296.00', 4, '2017-12-18'),
(293, 8, '77.00', 1, '2017-12-18'),
(294, 25, '77.00', 1, '2017-12-18'),
(295, 21, '3955.90', 1, '2017-12-05'),
(296, 26, '1560.95', 1, '2017-12-18'),
(297, 25, '64.00', 1, '2017-12-17'),
(298, 25, '35.00', 1, '2017-12-16'),
(299, 25, '83.00', 2, '2017-12-15'),
(300, 25, '73.00', 1, '2017-12-14'),
(301, 25, '113.00', 1, '2017-12-13'),
(302, 25, '79.00', 1, '2017-12-12'),
(303, 25, '70.00', 1, '2017-12-11'),
(304, 25, '94.00', 1, '2017-12-01'),
(305, 25, '20.00', 1, '2017-12-10'),
(306, 25, '55.00', 1, '2017-12-09'),
(307, 25, '71.00', 1, '2017-12-02'),
(308, 25, '56.00', 1, '2017-12-03'),
(309, 25, '96.00', 1, '2017-12-04'),
(310, 25, '73.00', 1, '2017-12-05'),
(311, 25, '79.00', 1, '2017-12-06'),
(312, 25, '77.00', 1, '2017-12-07'),
(313, 25, '81.00', 1, '2017-12-08'),
(314, 19, '242.00', 1, '2017-12-19'),
(315, 10, '1567.60', 1, '2017-12-17'),
(316, 16, '779.00', 1, '2017-12-19'),
(317, 28, '288.00', 1, '2017-12-14'),
(318, 21, '3129.30', 1, '2017-12-06'),
(319, 28, '329.00', 1, '2017-12-19'),
(320, 29, '660.00', 1, '2017-12-19'),
(321, 9, '14.00', 1, '2017-12-20'),
(322, 24, '365.70', 1, '2017-12-19'),
(323, 8, '26.00', 1, '2017-12-19'),
(324, 3, '140.00', 1, '2017-12-19'),
(325, 0, '1790.00', 2, '2017-12-19'),
(326, 11, '1078.60', 1, '2017-12-19'),
(327, 1, '877.50', 1, '2017-12-19'),
(328, 22, '305.25', 1, '2017-12-19'),
(329, 25, '71.00', 1, '2017-12-19'),
(330, 10, '948.10', 1, '2017-12-19'),
(331, 15, '1152.00', 1, '2017-12-19'),
(332, 18, '553.75', 1, '2017-12-19'),
(333, 13, '177.10', 1, '2017-12-19'),
(334, 26, '1546.65', 1, '2017-12-19'),
(335, 21, '2252.50', 1, '2017-12-08'),
(336, 21, '2383.00', 1, '2017-12-09'),
(337, 23, '905.90', 1, '2017-12-19'),
(338, 12, '10461.64', 1, '2017-12-19'),
(339, 12, '6972.07', 1, '2017-12-07'),
(340, 14, '244.80', 1, '2017-12-19'),
(341, 3, '405.00', 1, '2017-12-20'),
(342, 4, '3080.00', 1, '2017-12-20'),
(343, 9, '14.00', 1, '2017-12-19'),
(344, 1, '709.00', 1, '2017-12-20'),
(345, 14, '158.00', 1, '2017-12-20'),
(346, 19, '80.00', 1, '2017-12-20'),
(347, 28, '338.00', 1, '2017-12-20'),
(348, 12, '7637.55', 1, '2017-12-08'),
(349, 12, '12339.31', 1, '2017-12-09'),
(350, 24, '428.50', 1, '2017-12-20'),
(351, 26, '1672.45', 1, '2017-12-20'),
(352, 11, '1089.10', 1, '2017-12-20'),
(353, 21, '3111.30', 1, '2017-12-19'),
(354, 18, '1052.00', 1, '2017-12-20'),
(355, 21, '5487.50', 1, '2017-12-18'),
(356, 22, '340.13', 1, '2017-12-20'),
(357, 12, '8107.45', 1, '2017-12-20'),
(358, 12, '7157.93', 1, '2017-12-10'),
(359, 12, '3482.96', 1, '2017-12-11'),
(360, 12, '7633.20', 1, '2017-12-12'),
(361, 0, '254.70', 2, '2017-12-20'),
(362, 23, '740.45', 1, '2017-12-20'),
(363, 15, '1566.00', 1, '2017-12-20'),
(364, 13, '100.00', 1, '2017-12-20'),
(365, 25, '89.00', 1, '2017-12-20'),
(366, 16, '2836.10', 2, '2017-12-21'),
(367, 10, '1967.20', 1, '2017-12-20'),
(368, 19, '1206.00', 1, '2017-12-21'),
(369, 8, '96.00', 1, '2017-12-21'),
(370, 1, '528.00', 1, '2017-12-21'),
(371, 21, '2428.70', 1, '2017-12-20'),
(372, 21, '3872.70', 1, '2017-12-07'),
(373, 28, '432.50', 1, '2017-12-21'),
(374, 31, '168.75', 1, '2017-12-21'),
(375, 0, '530.10', 3, '2017-12-21'),
(376, 14, '41.00', 1, '2017-12-21'),
(377, 24, '470.40', 1, '2017-12-21'),
(378, 11, '989.80', 1, '2017-12-21'),
(379, 26, '1632.70', 1, '2017-12-21'),
(380, 15, '797.50', 1, '2017-12-21'),
(381, 25, '87.00', 1, '2017-12-21'),
(382, 13, '164.00', 1, '2017-12-21'),
(383, 10, '1854.45', 1, '2017-12-21'),
(384, 31, '234.40', 1, '2017-12-01'),
(385, 31, '263.20', 1, '2017-12-07'),
(386, 31, '229.60', 1, '2017-12-02'),
(387, 31, '196.00', 1, '2017-12-03'),
(388, 31, '300.00', 1, '2017-12-04'),
(389, 31, '222.40', 1, '2017-12-05'),
(390, 31, '244.00', 1, '2017-12-06'),
(391, 31, '180.80', 1, '2017-12-08'),
(392, 31, '192.00', 1, '2017-12-09'),
(393, 31, '183.20', 1, '2017-12-10'),
(394, 31, '226.40', 1, '2017-12-11'),
(395, 31, '244.00', 1, '2017-12-12'),
(396, 31, '188.80', 1, '2017-12-13'),
(397, 31, '224.70', 1, '2017-12-14'),
(398, 31, '243.60', 1, '2017-12-15'),
(399, 31, '125.30', 1, '2017-12-16'),
(400, 31, '151.90', 1, '2017-12-17'),
(401, 31, '135.80', 1, '2017-12-18'),
(402, 31, '175.50', 1, '2017-12-19'),
(403, 23, '644.90', 1, '2017-12-17'),
(404, 23, '708.60', 1, '2017-12-16'),
(405, 22, '354.75', 1, '2017-12-21'),
(406, 1, '345.00', 1, '2017-12-22'),
(407, 8, '123.50', 1, '2017-12-22'),
(408, 16, '190.00', 1, '2017-12-22'),
(409, 28, '319.50', 1, '2017-12-22'),
(410, 31, '175.50', 1, '2017-12-20'),
(411, 31, '171.00', 1, '2017-12-22'),
(412, 3, '190.00', 1, '2017-12-22'),
(413, 11, '1018.15', 1, '2017-12-22'),
(414, 25, '178.00', 2, '2017-12-22'),
(415, 24, '542.90', 1, '2017-12-22'),
(416, 18, '747.00', 1, '2017-12-22'),
(418, 15, '1245.00', 1, '2017-12-22'),
(419, 26, '1616.75', 1, '2017-12-22'),
(420, 22, '294.75', 1, '2017-12-22'),
(421, 19, '112.00', 1, '2017-12-23'),
(422, 16, '675.00', 1, '2017-12-23'),
(423, 10, '1840.10', 1, '2017-12-22'),
(424, 23, '518.40', 1, '2017-12-22'),
(425, 23, '692.85', 1, '2017-12-21'),
(426, 25, '76.00', 1, '2017-12-23'),
(427, 11, '479.40', 1, '2017-12-23'),
(428, 31, '136.50', 1, '2017-12-23'),
(429, 24, '271.40', 1, '2017-12-23'),
(430, 0, '251.00', 1, '2017-12-23'),
(431, 26, '1334.50', 1, '2017-12-23'),
(432, 14, '244.80', 1, '2017-12-22'),
(433, 14, '21.00', 1, '2017-12-23'),
(434, 18, '966.00', 1, '2017-12-23'),
(435, 15, '637.40', 1, '2017-12-23'),
(436, 1, '415.00', 1, '2017-12-23'),
(437, 28, '336.00', 1, '2017-12-23'),
(438, 0, '498.00', 2, '2017-12-22'),
(439, 10, '1451.60', 1, '2017-12-23'),
(440, 16, '383.50', 1, '2017-12-24'),
(441, 22, '312.75', 1, '2017-12-02'),
(442, 22, '394.50', 1, '2017-12-01'),
(443, 22, '297.00', 1, '2017-12-03'),
(444, 22, '197.25', 1, '2017-12-23'),
(445, 13, '364.00', 1, '2017-12-22'),
(446, 13, '103.00', 1, '2017-12-23'),
(447, 14, '194.20', 1, '2017-12-24'),
(448, 13, '69.10', 1, '2017-12-24'),
(449, 18, '462.00', 1, '2017-12-24'),
(450, 26, '771.50', 1, '2017-12-24'),
(451, 31, '125.25', 1, '2017-12-24'),
(452, 25, '51.50', 1, '2017-12-24'),
(453, 23, '694.70', 1, '2017-12-23'),
(454, 24, '815.20', 1, '2017-12-24'),
(455, 28, '226.00', 1, '2017-12-24'),
(456, 23, '607.30', 1, '2017-12-24'),
(457, 12, '4665.26', 1, '2017-12-23'),
(458, 12, '8681.58', 1, '2017-12-22'),
(459, 12, '8567.13', 1, '2017-12-21'),
(460, 11, '698.80', 1, '2017-12-24'),
(461, 0, '227.50', 1, '2017-12-24'),
(462, 15, '465.00', 1, '2017-12-24'),
(463, 19, '116.00', 1, '2017-12-25'),
(464, 8, '28.00', 1, '2017-12-25'),
(465, 16, '308.00', 1, '2017-12-25'),
(466, 10, '2043.60', 1, '2017-12-24'),
(467, 22, '171.00', 1, '2017-12-24'),
(468, 18, '366.00', 1, '2017-12-25'),
(469, 1, '275.00', 1, '2017-12-25'),
(470, 9, '14.00', 1, '2017-12-25'),
(471, 3, '1840.00', 2, '2017-12-26'),
(472, 11, '2227.96', 2, '2017-12-26'),
(473, 0, '683.50', 2, '2017-12-25'),
(474, 14, '2875.20', 1, '2017-12-25'),
(475, 22, '317.25', 1, '2017-12-25'),
(476, 25, '102.00', 1, '2017-12-25'),
(477, 12, '5189.25', 1, '2017-12-24'),
(478, 28, '350.00', 1, '2017-12-25'),
(479, 15, '1661.00', 1, '2017-12-25'),
(480, 13, '295.25', 1, '2017-12-25'),
(481, 4, '3980.00', 1, '2017-12-26'),
(482, 1, '85.00', 1, '2017-12-26'),
(483, 16, '123.50', 1, '2017-12-26'),
(484, 10, '2578.70', 1, '2017-12-25'),
(485, 31, '220.90', 1, '2017-12-25'),
(486, 0, '840.00', 3, '2017-12-26'),
(487, 14, '100.40', 1, '2017-12-26'),
(488, 13, '145.50', 1, '2017-12-26'),
(489, 12, '9414.19', 1, '2017-12-25'),
(490, 26, '1439.25', 1, '2017-12-25'),
(491, 15, '1216.25', 1, '2017-12-26'),
(492, 18, '421.00', 1, '2017-12-26'),
(493, 24, '146.20', 1, '2017-12-25'),
(494, 25, '46.00', 1, '2017-12-26'),
(495, 19, '936.00', 1, '2017-12-27'),
(496, 24, '351.90', 1, '2017-12-26'),
(497, 8, '54.00', 1, '2017-12-27'),
(498, 14, '97.20', 1, '2017-12-27'),
(499, 22, '295.50', 1, '2017-12-26'),
(500, 16, '658.00', 1, '2017-12-27'),
(501, 1, '1804.00', 1, '2017-12-27'),
(502, 28, '351.50', 1, '2017-12-26'),
(503, 28, '445.00', 1, '2017-12-27'),
(504, 18, '376.00', 1, '2017-12-27'),
(505, 24, '480.10', 1, '2017-12-27'),
(506, 9, '10.50', 1, '2017-12-27'),
(507, 23, '727.70', 1, '2017-12-25'),
(508, 23, '614.25', 1, '2017-12-26'),
(509, 23, '719.80', 1, '2017-12-27'),
(510, 31, '187.60', 1, '2017-12-26'),
(511, 31, '196.70', 1, '2017-12-27'),
(512, 15, '425.00', 1, '2017-12-27'),
(513, 12, '5971.82', 1, '2017-12-27'),
(514, 12, '7486.71', 1, '2017-12-26'),
(515, 26, '1397.60', 1, '2017-12-26'),
(516, 26, '1716.40', 1, '2017-12-27'),
(517, 13, '169.50', 1, '2017-12-27'),
(518, 3, '25.00', 1, '2017-12-28'),
(519, 9, '21.00', 1, '2017-12-28'),
(520, 19, '432.00', 1, '2017-12-28'),
(521, 0, '1909.20', 2, '2017-12-27'),
(522, 8, '52.50', 1, '2017-12-28'),
(523, 1, '230.00', 1, '2017-12-28'),
(524, 16, '1117.00', 1, '2017-12-28'),
(525, 10, '2649.00', 1, '2017-12-26'),
(526, 10, '2191.80', 1, '2017-12-27'),
(527, 4, '130.00', 1, '2017-12-28'),
(528, 28, '366.50', 1, '2017-12-28'),
(529, 24, '394.50', 1, '2017-12-28'),
(530, 0, '1847.50', 2, '2017-12-28'),
(531, 11, '938.90', 1, '2017-12-27'),
(532, 11, '887.80', 1, '2017-12-28'),
(533, 14, '120.40', 1, '2017-12-28'),
(534, 15, '1282.75', 1, '2017-12-28'),
(535, 13, '333.50', 1, '2017-12-28'),
(536, 10, '1927.30', 1, '2017-12-28'),
(537, 18, '154.50', 1, '2017-12-28'),
(538, 16, '962.50', 1, '2017-12-29'),
(539, 19, '640.00', 1, '2017-12-29'),
(540, 1, '455.00', 1, '2017-12-29'),
(541, 4, '2780.00', 1, '2017-12-29'),
(542, 31, '240.00', 1, '2017-12-28'),
(543, 31, '216.60', 2, '2017-12-29'),
(544, 28, '217.00', 1, '2017-12-29'),
(545, 23, '514.40', 1, '2017-12-28'),
(546, 23, '466.80', 1, '2017-12-29'),
(547, 11, '444.00', 1, '2017-12-29'),
(548, 24, '442.30', 1, '2017-12-29'),
(549, 14, '139.20', 1, '2017-12-29'),
(550, 3, '50.00', 1, '2017-12-29'),
(551, 13, '553.45', 1, '2017-12-29'),
(552, 8, '183.00', 1, '2017-12-29'),
(553, 15, '3617.60', 1, '2017-12-29'),
(554, 25, '66.00', 1, '2017-12-27'),
(555, 25, '73.00', 1, '2017-12-28'),
(556, 25, '61.00', 1, '2017-12-29'),
(557, 0, '2462.71', 2, '2017-12-30'),
(558, 19, '80.00', 1, '2017-12-30'),
(559, 18, '1360.75', 1, '2017-12-29'),
(560, 18, '75.00', 1, '2017-12-30'),
(561, 14, '5.60', 1, '2017-12-30'),
(562, 1, '517.50', 1, '2017-12-30'),
(563, 28, '322.00', 1, '2017-12-30'),
(564, 24, '249.90', 1, '2017-12-30'),
(565, 10, '1167.00', 1, '2017-12-30'),
(566, 10, '2059.90', 1, '2017-12-29'),
(567, 11, '465.64', 1, '2017-12-30'),
(568, 12, '6529.37', 1, '2017-12-28'),
(569, 12, '6357.29', 1, '2017-12-29'),
(570, 22, '147.75', 1, '2017-12-30'),
(571, 15, '389.50', 1, '2017-12-30'),
(572, 13, '71.00', 1, '2017-12-30'),
(573, 0, '483.85', 3, '2017-12-31'),
(574, 19, '39.00', 1, '2017-12-31'),
(575, 16, '414.50', 1, '2017-12-30'),
(576, 16, '416.00', 1, '2017-12-31'),
(577, 21, '2857.55', 1, '2017-12-10'),
(578, 21, '3475.50', 1, '2017-12-11'),
(579, 21, '2468.90', 1, '2017-12-12'),
(580, 21, '3546.40', 1, '2017-12-13'),
(581, 21, '3591.00', 1, '2017-12-14'),
(582, 21, '1867.70', 1, '2017-12-21'),
(583, 21, '3767.20', 1, '2017-12-22'),
(584, 21, '1843.30', 1, '2017-12-23'),
(585, 21, '3480.50', 1, '2017-12-24'),
(586, 21, '3729.40', 1, '2017-12-25'),
(587, 21, '2881.70', 1, '2017-12-26'),
(588, 21, '3424.50', 1, '2017-12-27'),
(589, 21, '1673.50', 1, '2017-12-28'),
(590, 21, '1320.75', 1, '2017-12-29'),
(591, 21, '1561.00', 1, '2017-12-31'),
(592, 12, '3973.32', 1, '2017-12-30'),
(593, 18, '360.50', 1, '2017-12-31'),
(594, 25, '63.00', 1, '2017-12-30'),
(595, 15, '680.50', 1, '2017-12-31'),
(596, 12, '3648.53', 1, '2017-12-31'),
(597, 28, '109.50', 1, '2017-12-31'),
(598, 3, '2850.00', 1, '2017-12-31'),
(599, 10, '1036.90', 1, '2017-12-31'),
(600, 22, '261.00', 1, '2017-12-29'),
(601, 22, '133.50', 1, '2017-12-31'),
(602, 22, '290.25', 1, '2017-12-28'),
(603, 22, '273.00', 1, '2017-12-27'),
(604, 11, '350.50', 1, '2017-12-31'),
(605, 31, '116.70', 1, '2017-12-30'),
(606, 28, '175.50', 1, '2018-01-01'),
(607, 31, '82.80', 1, '2017-12-31'),
(608, 31, '156.90', 1, '2018-01-01'),
(609, 25, '18.00', 1, '2018-01-01'),
(610, 25, '57.00', 1, '2017-12-31'),
(611, 11, '771.55', 1, '2018-01-01'),
(612, 16, '249.00', 1, '2018-01-01'),
(613, 4, '180.00', 1, '2017-12-27'),
(614, 23, '268.80', 1, '2018-01-01'),
(615, 23, '337.20', 1, '2017-12-31'),
(616, 18, '77.50', 1, '2018-01-01'),
(617, 14, '128.40', 1, '2017-12-31'),
(618, 0, '411.00', 2, '2018-01-01'),
(619, 23, '358.70', 1, '2017-12-30'),
(620, 22, '129.75', 1, '2018-01-01'),
(621, 10, '932.70', 1, '2018-01-01'),
(622, 24, '166.50', 1, '2017-12-31'),
(623, 15, '780.40', 1, '2018-01-01'),
(624, 14, '162.60', 1, '2018-01-01'),
(625, 24, '335.90', 1, '2018-01-01'),
(626, 26, '1015.00', 1, '2018-01-01'),
(627, 12, '3016.66', 1, '2018-01-01'),
(628, 16, '635.00', 1, '2018-01-02'),
(629, 19, '116.00', 1, '2018-01-02'),
(630, 13, '75.00', 1, '2017-12-31'),
(631, 13, '29.50', 1, '2018-01-01'),
(632, 24, '206.70', 1, '2018-01-02'),
(633, 21, '1440.65', 1, '2018-01-01'),
(634, 0, '546.00', 2, '2018-01-02'),
(635, 26, '1658.50', 1, '2018-01-02'),
(636, 11, '1512.05', 1, '2018-01-02'),
(637, 10, '1064.95', 1, '2018-01-02'),
(638, 23, '379.00', 1, '2018-01-02'),
(639, 1, '934.00', 1, '2018-01-02'),
(640, 15, '1681.50', 1, '2018-01-02'),
(641, 32, '49.40', 1, '2018-01-02'),
(642, 32, '18.40', 1, '2018-01-01'),
(643, 21, '1929.40', 1, '2018-01-02'),
(644, 12, '8067.94', 1, '2018-01-02');

-- --------------------------------------------------------

--
-- 表的结构 `userinfo`
--

CREATE TABLE `userinfo` (
  `id` int(11) NOT NULL,
  `wid` int(11) NOT NULL COMMENT '用户ID',
  `openid` varchar(100) NOT NULL COMMENT '用户标识',
  `phone` varchar(300) DEFAULT '' COMMENT '电话',
  `name` varchar(100) DEFAULT '' COMMENT '姓名',
  `code` varchar(5) DEFAULT '' COMMENT '验证码',
  `inform_flag` tinyint(4) DEFAULT '1' COMMENT '接收通知:0-否,1-是'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信用户';

--
-- 转存表中的数据 `userinfo`
--

INSERT INTO `userinfo` (`id`, `wid`, `openid`, `phone`, `name`, `code`, `inform_flag`) VALUES
(1, 1, 'o6EX5wxoagFqQYam58J8fRz6pLdU', '', '谭毅', '022', 1),
(2, 2, 'o6EX5w8dwFuOEgcMuEAGUvrMaGkY', '', '', '774', 1),
(3, 3, 'o6EX5w0GHs0bgEu_f9WbSbnoSyuA', '', '', 'ce3', 1),
(4, 4, 'o6EX5wwRkZGXkdkehkDQKDVgzHKc', '', '', '5db', 1),
(5, 5, 'o6EX5w60NdE4PwKGuzYpegoaxuyg', '', '系统开发小何', '8e3', 1),
(6, 6, 'o6EX5w5GXmMze5iepMEEGtrtoJzM', '', '', 'ae1', 1),
(8, 8, 'o6EX5w_R4g7IPm9FG0bq0GK1PyeM', '', '小何', '62d', 1),
(9, 9, 'o6EX5w-Z1c8sJychRP3VUWWH9t_Q', '', '谭毅', 'bc2', 1),
(10, 10, 'o6EX5w1Kpqoi8Xf0n4rNFrrHAtGI', '', '周文', '633', 1),
(11, 11, 'o6EX5w41qQ7m7HvkL_WEJ_Vat_lQ', '', '', '90b', 1),
(12, 12, 'o6EX5w-zFHVawgPRM8bUOX6IosuM', '', '', '726', 1),
(13, 13, 'o6EX5w3GqO8X_cLNP-RhKm75tdC0', '', '', 'b74', 1),
(14, 14, 'o6EX5w_g7IqLhi0IrDzZtrgmOOhM', '', '', 'eed', 1),
(15, 15, 'o6EX5w3Fw_6HYG2V_hIl3mlW5J0c', '', '', '62a', 1),
(16, 16, 'o6EX5w9g817p720WF46EVivwuagk', '', '', '3d2', 1),
(17, 17, 'o6EX5w60ku80ZPSBo_IpXTSkmNcM', '', '', '544', 1),
(18, 18, 'o6EX5w-yjOkaxJxE55uPwsbCaSRA', '', '', 'f8b', 1),
(19, 19, 'o6EX5w5fr0pjqLokG2w_wArBOqC4', '', '万禾江主管', 'a0f', 1),
(20, 20, 'o6EX5wxMnmb6rkOGso68_bWOS5oM', '', '汪夫珍', 'de1', 1),
(21, 21, 'o6EX5w8dpMDQJUquFFeOH90X8P1Q', '', '', '1a9', 1),
(22, 22, 'o6EX5w_iDx6EWPqZKDrAZHeSDZ_s', '', '', 'fae', 1),
(23, 23, 'o6EX5wzAUnTlmz537hDJeMyly2m8', '', '赵小广', '58a', 1),
(24, 24, 'o6EX5w0ldSpdLyg84wc0Gvs-mTjE', '', '', '147', 1),
(25, 25, 'o6EX5w_wqE6RGbJ4Zz0L3Jcrd7Ik', '', '', 'f8f', 1),
(26, 26, 'o6EX5w4ApjG3TagXNVtwth2q-6Og', '', '王杰-采购主管', '053', 1),
(27, 27, 'o6EX5w8qAs-J-XY0691eZ5TW1CWA', '', '', '451', 1),
(28, 28, 'o6EX5w8_OmIslotUSDXuHeh9Tq4Y', '', '刘志辉', 'c92', 1),
(29, 29, 'o6EX5w26iSRMETFwhcoHWcBKzkzM', '', '', '7fb', 1),
(30, 30, 'o6EX5wyLfkSwWlyv0mLs1cYk1_D8', '', '', '977', 1),
(31, 31, 'o6EX5w16-D6bnYWvJmJZ_T-v5oIc', '', '', '05d', 1),
(32, 32, 'o6EX5wwqAG7XWTHYpgR6b7WQGV2A', '', '', '956', 1),
(33, 33, 'o6EX5w5pNtZfnotADIyHyuUaWBz4', '', '', 'ab4', 1),
(34, 34, 'o6EX5w8imGhtHVaMEG69_kT7sfdU', '', '', 'ff1', 1),
(35, 35, 'o6EX5w7rQGo96hmhZ2gpaVb-eoDM', '', '', '33a', 1),
(36, 36, 'o6EX5w93oebN20OpqU0HbOpP2gDg', '', '', '77e', 1),
(37, 37, 'o6EX5w-DkiPOv1FV-PSEkLIrEO7c', '', '吕治辉', '4d7', 1),
(38, 38, 'o6EX5w68NDfZoILXNGRDjrdtWQQw', '', '', 'efe', 1),
(39, 39, 'o6EX5w5nFeHI-3Osizhx6AKjrO08', '', '', 'e0c', 1),
(40, 40, 'o6EX5wwq1iiZpoH8gzDmU-2sV1Bg', '', '', '384', 1),
(41, 41, 'o6EX5w-spUnrqf38oKR3Hk2PDZzc', '', '', '3da', 1),
(42, 42, 'o6EX5wxGKUq8G6vXMm9n_BI4A68A', '', '', '0c9', 1),
(43, 43, 'o6EX5w9ZyF_oxODC3-umVSHffW50', '', '', 'bad', 1),
(44, 44, 'o6EX5w00Xc8teuhuz5h3a8cSDMIo', '', '', 'd0d', 1),
(45, 45, 'o6EX5w8wKriB8MnZctf9dzTgDvoQ', '', '', '7c9', 1),
(46, 46, 'o6EX5w9YBMsFaU_YwqhSEBFr41uk', '', '', '18c', 1),
(47, 47, 'o6EX5wyuc0nBZkSHNJKP8xNYfVLo', '', '', 'dd2', 1),
(48, 48, 'o6EX5w8h7ihJBthKvNsa3k1zAkl8', '', '', '2b2', 1),
(49, 49, 'o6EX5w8IPEVa-49LbucpltduSsnY', '', '', 'bf9', 1),
(50, 50, 'o6EX5w578hnCScbP6DAhjhq-cS8s', '', '李桂华', '52a', 1),
(51, 51, 'o6EX5wxO9TWmH1pavYbZlu3lmPjU', '', '邓志成', 'ec5', 1),
(52, 52, 'o6EX5w8t_bKJxSPkw9AheUPMQ4Z0', '', '', '23b', 1),
(53, 53, 'o6EX5wzO885dpbh6YSvH5lu7EOxU', '', '', 'a76', 1),
(54, 54, 'o6EX5wyj_-wi1Kt6csDKhqrPNFc8', '', '', '081', 1),
(55, 55, 'o6EX5w5Ha-PhwNLi6DsxMNC40gY0', '', '财务', 'd0f', 1),
(56, 56, 'o6EX5w24nS7yBFTy9Z50IzZbUsdg', '', '', '074', 1),
(57, 57, 'o6EX5wygSMUH8TqZtoCH_bYOjmj0', '', '', '0d8', 1),
(58, 58, 'o6EX5w2UPML51gg0YT2TqoEFrjgM', '', '', 'a77', 1),
(59, 59, 'o6EX5w9ah34mqWQXDAoyS_MLhSm4', '', '', 'f7e', 1),
(60, 60, 'o6EX5w_qo7ivRrWOY9wt6oyhwK1I', '', '', 'd10', 1);

-- --------------------------------------------------------

--
-- 表的结构 `usertag`
--

CREATE TABLE `usertag` (
  `id` int(10) UNSIGNED NOT NULL,
  `tid` int(10) UNSIGNED DEFAULT '0' COMMENT '标签ID',
  `uid` int(10) UNSIGNED DEFAULT '0' COMMENT '用户ID'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户标签关联表';

-- --------------------------------------------------------

--
-- 表的结构 `wechatmenu`
--

CREATE TABLE `wechatmenu` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` varchar(10) NOT NULL COMMENT '响应类型',
  `temp_type` varchar(10) NOT NULL COMMENT '临时类型',
  `name` varchar(10) NOT NULL COMMENT '标题',
  `k` varchar(128) NOT NULL COMMENT '推送值',
  `url` varchar(300) NOT NULL COMMENT '跳转链接',
  `media_id` varchar(100) NOT NULL COMMENT '素材ID',
  `pid` int(10) UNSIGNED DEFAULT '0' COMMENT '父ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信菜单';

--
-- 转存表中的数据 `wechatmenu`
--

INSERT INTO `wechatmenu` (`id`, `type`, `temp_type`, `name`, `k`, `url`, `media_id`, `pid`, `create_time`, `update_time`) VALUES
(1, 'view', '', '供应商管理', '', 'http://yxs.ganlongjt.com/Wechat.php', '', 0, '2017-11-27 20:08:05', '2017-11-30 07:40:48'),
(2, 'view', '', '配送系统', '', 'http://yxs.ganlongjt.com/Ag/Wechat.php/Front/Home/index', '', 0, '2017-11-30 15:40:11', '2017-12-03 13:53:33'),
(3, 'view', '', '保密协议', '', 'http://yxs.ganlongjt.com/Wechat.php/Front/Document/detail?id=1', '', 0, '2017-12-29 14:52:24', '2017-12-29 06:52:24');

-- --------------------------------------------------------

--
-- 表的结构 `wechatreply`
--

CREATE TABLE `wechatreply` (
  `id` int(11) NOT NULL,
  `type` varchar(10) NOT NULL COMMENT '响应类型',
  `keywords` varchar(128) NOT NULL COMMENT '关键字',
  `reply` varchar(128) DEFAULT '' COMMENT '返回信息',
  `media_id` varchar(100) DEFAULT '' COMMENT '素材ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信菜单';

--
-- 转存表中的数据 `wechatreply`
--

INSERT INTO `wechatreply` (`id`, `type`, `keywords`, `reply`, `media_id`, `create_time`, `update_time`) VALUES
(-1, 'text', '关注回复', '感谢关注本公众号!', '', '2017-11-21 03:52:51', '2017-11-21 02:52:51'),
(-2, 'text', '默认回复', '感谢您的支持!', '', '2017-11-21 03:52:51', '2017-11-21 02:52:51');

-- --------------------------------------------------------

--
-- 表的结构 `wechattag`
--

CREATE TABLE `wechattag` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(30) NOT NULL COMMENT '标签名称',
  `tagid` int(10) UNSIGNED DEFAULT '0' COMMENT '标签ID'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信标签管理';

-- --------------------------------------------------------

--
-- 表的结构 `wechatuser`
--

CREATE TABLE `wechatuser` (
  `id` int(10) UNSIGNED NOT NULL,
  `subscribe` tinyint(1) DEFAULT '1' COMMENT '是否订阅:1-是,0-否',
  `openid` varchar(100) NOT NULL COMMENT '用户的标识',
  `nickname` varchar(100) NOT NULL COMMENT '用户的昵称',
  `sex` tinyint(1) DEFAULT '0' COMMENT '性别:0-未知,1-男,2-女',
  `country` varchar(15) DEFAULT '' COMMENT '所在国家',
  `province` varchar(15) DEFAULT '' COMMENT '所在省份',
  `city` varchar(15) DEFAULT '' COMMENT '所在城市',
  `language` varchar(10) DEFAULT '' COMMENT '语言',
  `headimgurl` varchar(150) DEFAULT '' COMMENT '头像',
  `groupid` int(11) NOT NULL DEFAULT '0' COMMENT '管理地区',
  `subscribe_time` int(10) UNSIGNED NOT NULL COMMENT '关注时间',
  `unionid` varchar(100) DEFAULT '' COMMENT '开放平台ID',
  `remark` varchar(50) DEFAULT '' COMMENT '备注'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信用户';

--
-- 转存表中的数据 `wechatuser`
--

INSERT INTO `wechatuser` (`id`, `subscribe`, `openid`, `nickname`, `sex`, `country`, `province`, `city`, `language`, `headimgurl`, `groupid`, `subscribe_time`, `unionid`, `remark`) VALUES
(1, 1, 'o6EX5wxoagFqQYam58J8fRz6pLdU', '万（谭）', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLBYIlHq7H7UKJdAmE9ZG6ibib3aSSKQzWSbRIbLy6p1G8gzquia6akp5rFpGYYV0lTSCJDLPuAlLP8Dg/0', 0, 1508499091, '', ''),
(2, 1, 'o6EX5w8dwFuOEgcMuEAGUvrMaGkY', '爱船说 王浩宇', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvxRPfxW6w3TShAzvn1bmabqnkX1N5RQDXibe0onDTf3YbRMlMzZ0OyDDXK5yV4rY7Sdp8SwVk5GNsLIIM55uibxA/0', 0, 1511788911, '', ''),
(3, 1, 'o6EX5w0GHs0bgEu_f9WbSbnoSyuA', '凡人', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLCNK5KV57eZqgVFdhCFM42nP52usI3fyIVPB4zicXToVTqP5gI86NHHHOvafWgn9XhMg1KbAFkX0pQ/0', 2, 1508656167, '', ''),
(4, 1, 'o6EX5wwRkZGXkdkehkDQKDVgzHKc', '相思雨', 2, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/0yOibuhvkGF8VEwR1b1hPaHm82GeCUPfgHvFFJJzRLQfhAuNCKWN9voGVZBTUa8MYsxypxvicCgH2yQhQmI4mevw/0', 2, 1508656071, '', ''),
(5, 1, 'o6EX5w60NdE4PwKGuzYpegoaxuyg', 'Walter Bishop', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIsdjicAFKAueYFtMiakK5yLbuDAExHsib38F8IB2J2yzEyoZNNiabdWcAq6mk1ic6OTEmKgib1qaTnV4w3icEH8fZzjFAib/0', 0, 1508497761, '', ''),
(6, 1, 'o6EX5w5GXmMze5iepMEEGtrtoJzM', 'づ墨小黑', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSVqbAUkrvWd2BFDerGf9phicnsVCGRheMichYXt71BkUT2txiazFxMJgRbcZKcicJuM5Xvibc8a0DLQSzuicwMpdiaNISic/0', 0, 1511788890, '', ''),
(9, 1, 'o6EX5w-Z1c8sJychRP3VUWWH9t_Q', '优鲜送', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSViaynAaqWwxh7OBKRMG1LKwNTXVmJFA6r6RUoJpDjWyyVldwys4lXFkrI5G6nUgNDZGSoULia97G94gTBvWLymWs/0', 0, 1512309544, '', ''),
(8, 1, 'o6EX5w_R4g7IPm9FG0bq0GK1PyeM', '源科动力', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/AFT5OJ1ejFicn5qR0icN3eHoqRRvPlIDnC9QS6n7Og7OyPoyK6KnddqCqjOq32y0Drr6jkrQs8hccbeY1zdoHibGibbcp6D8BD8E/0', 0, 1512027488, '', ''),
(10, 1, 'o6EX5w1Kpqoi8Xf0n4rNFrrHAtGI', '物是人非????', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSWdLj18Hc1D0toWDk2RAMYwoSzCNZ3sLrr1SbcxkV01ObNNEAIRGNkicV6Z018UubpR3rJwuLS3AuuK39cV8ibtsZ/0', 0, 1512351039, '', ''),
(11, 1, 'o6EX5w41qQ7m7HvkL_WEJ_Vat_lQ', '凯^o^歌', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSVicR7wjn2oK7MtxNhJ2uiceMnWgqOaWeuXY7Jz76FTPYw7DOJGxT5UFCQoIpZjeasCL0ibpr4LWpozelico99HqtGP/0', 0, 1512353952, '', ''),
(12, 1, 'o6EX5w-zFHVawgPRM8bUOX6IosuM', '白云飞', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58icxcib8fT8WA82ZgDbWgbJ59dfhicEFRmIpWhqQYpLXBnNHW1aE7iabHXQO968E8XFz01OcbGRfiaUw0EicGTKB2DJUz/0', 0, 1512354965, '', ''),
(13, 1, 'o6EX5w3GqO8X_cLNP-RhKm75tdC0', '素君', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLDSl3oQf4EdlxJHJq1GcqaDLFHZNsicV3XiaxQlhjEKn19njUSFWcAN5qFVeT39oicL0LqE6BhK9TC1pXXM7ib0kejcwlJp3Ryicjag/0', 0, 1512355701, '', ''),
(14, 1, 'o6EX5w_g7IqLhi0IrDzZtrgmOOhM', ' 彭秋琼', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58ibF8icsbwmThBL6oEFD5IRtxjwly6lMQEnqxiaRd3bAQ5mILqf5S0IREiciccH3nne0vADPoK4e6vOFN0JoiaNHwusZe/0', 0, 1512357443, '', ''),
(15, 1, 'o6EX5w3Fw_6HYG2V_hIl3mlW5J0c', '小龙凉拌菜2535168', 0, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58ibr2Bsu0M1WbQAErYIunnkbFJbmukuO0Blf8bWia5j2syEOLhsvia5NaZicxNxFM3MHZKIzO1ZicD4FuLgIdS18MREQ/0', 0, 1512361034, '', ''),
(16, 1, 'o6EX5w9g817p720WF46EVivwuagk', 'EFFER', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/AFT5OJ1ejFicn5qR0icN3eHrhgF73FFlgG13uDdWXFfZ3ZI7C0mvzDVgp8xZCx9mF6OCVmgm6tdERNTzWrkC8KkMXAakayN1ca/0', 0, 1512382755, '', ''),
(17, 1, 'o6EX5w60ku80ZPSBo_IpXTSkmNcM', '糖粿の菋噵', 2, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/hSLDPrbWHSz8H6JnKxU1Ue7Fnol0jQOD0rn2TRAmGJ0EYvJeucZrUyiaF30VgyCuaQoAkkID7Ue9LywibenibCvxoFxssXFMtmd/0', 0, 1512435020, '', ''),
(18, 1, 'o6EX5w-yjOkaxJxE55uPwsbCaSRA', '鲜面店陶子维国', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSUPEMz3yqBzGE1uBml6ibMhJ6yYeuWvSic8Ab7gl3Eu1debAvU0dduSKquyZ9wqEjXLoII9Hje5WqPnQWicIsgTfgU/0', 0, 1512435556, '', ''),
(19, 1, 'o6EX5w5fr0pjqLokG2w_wArBOqC4', '爬树上青天', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvxRPfxW6w3TYAVVtq2ebzRO324DicHuDjxoqwUQXjoRGiamKIF5EYibB4uz85KAdwJSD9QeA0WESrbexybiaPBxVVQ/0', 0, 1512448135, '', ''),
(20, 1, 'o6EX5wxMnmb6rkOGso68_bWOS5oM', '小汪', 1, 'China', 'Guangxi', 'Nanning', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLDSl3oQf4EdlxJHJq1GcqaDtNu1sqxOiaH8gGwjADVegjXpgAIqae4MiaIbH0S4RDz2VUMAsmicQ82nicVrB1XxiaB94nTuPjUG3RYw/0', 0, 1512692595, '', ''),
(21, 1, 'o6EX5w8dpMDQJUquFFeOH90X8P1Q', '绿荫', 1, 'Ireland', 'Donegal', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSVsEvYJglTkmxLk6jCZiay2qzibv07FCT8PUot9tF79b7kPdPXACuUQ2icjm1w3E26LDNiaoQXp4QoyY6q4M37gDsLy/0', 0, 1512694308, '', ''),
(22, 1, 'o6EX5w_iDx6EWPqZKDrAZHeSDZ_s', '崇拜你像个英雄', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/8mGib21PtCcCpricXtUvj75mBr6YIkRUwmBzrAf3GYf6yaCQ683x5CO16BicDc8ptv81gIBEdQsc4icsQn9LT6ZiaxehA8dnPLLmt/0', 0, 1512826391, '', ''),
(23, 1, 'o6EX5wzAUnTlmz537hDJeMyly2m8', '零下6度', 1, 'Madagascar', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLDA4P7H9MvhibHS1hLR2ZZH3VoJ8O6ficEhoNgUjVrcbeqgYhqnmeImIwjlojOHvjeicnXyCtE5zCWd4p6Vlnn2e9FQkA0ibkiauzQQ/0', 0, 1512948553, '', ''),
(24, 1, 'o6EX5w0ldSpdLyg84wc0Gvs-mTjE', '平淡低调', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU589icn6Jze0xBG5fMs8HVoq16ibQib3zpZEuhibkU0YePicpp2TdK54kaP4CCjRokO3nqth8m5DXcrXKhwgzqOxZ9qtZv/0', 0, 1512950786, '', ''),
(25, 1, 'o6EX5w_wqE6RGbJ4Zz0L3Jcrd7Ik', '秦田诸', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSXhbNmVjhqoddJNjbHGGxR5Nc1eQHMFRxE22icQr0nCXtI6gLJwrMcXkLn72RV7kibyennsUXl5J6x2fIXlOdygNT/0', 0, 1512954419, '', ''),
(26, 1, 'o6EX5w4ApjG3TagXNVtwth2q-6Og', 'J大坏蛋', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU589Zl6vvGpuHyAicEcODY5e7O8DUrfnicN9xZ4LwbmNAU6uHrYo4F2rDPZc85WPA4IWrTALib1jomZJuvncf0NegR6ia/0', 0, 1512954909, '', ''),
(27, 1, 'o6EX5w8qAs-J-XY0691eZ5TW1CWA', '鲜果行', 2, 'Austria', 'Burgenland', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/0yOibuhvkGFicMnpbCqvWGDfFkkuYSBdIaQDW0LibfFkbaLQ0NUupY4ZoYlQnYQ2VVPXJPJ9N8OJ87micia77lz6ILRI5sxibaYMBl/0', 0, 1512958652, '', ''),
(28, 1, 'o6EX5w8_OmIslotUSDXuHeh9Tq4Y', 'AA刘志辉15994674912', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvxRPfxW6w3TYbXmS5TYSAV4tOOZd4zxHy0CyQvaFHtqa7RYOR5CPsnBTcb7XgAt74aKbPtLMcse1V4r4hd2suj/0', 0, 1512960867, '', ''),
(29, 1, 'o6EX5w26iSRMETFwhcoHWcBKzkzM', '小王', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSX3HuyynGUVQeoL8gpbiauwGnu37XiamehHBHzLY80yM0PApcWyICgdBze9sUiatpt5qBtodItUKMvlBv0mHuibibThQ/0', 0, 1512977806, '', ''),
(30, 1, 'o6EX5wyLfkSwWlyv0mLs1cYk1_D8', '毛毛虫', 2, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU589v69km2lqHW4aGDHaGseoEAzjZHLYHjDYOrLJibZlRDb98H9yJkrG3Ub6X8BjxQiayyuYyKG0aK2ZDKfS3SHquS2/0', 0, 1512985327, '', ''),
(31, 1, 'o6EX5w16-D6bnYWvJmJZ_T-v5oIc', '大唐家禽18007878659', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU589icn6Jze0xBG5YlU2Dt4XoPuAbZEKcArmOibGatGJhd7FYXjIkwSbWsrwu1A65aU6yqkLWfEoQafzicMDwWxxKd4f/0', 0, 1512988856, '', ''),
(32, 1, 'o6EX5wwqAG7XWTHYpgR6b7WQGV2A', '俩宝妈', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLDSl3oQf4EdlxJHJq1GcqaDwXp2IuAicbac6I2YOLktiaHknJ2xCibmfLFHEiba5D8COYgxBCbmiazYOaQeSNUP8cajpTWcOBwlTkLs/0', 0, 1512990080, '', ''),
(33, 1, 'o6EX5w5pNtZfnotADIyHyuUaWBz4', '十一哥左宗良', 1, 'China', 'Guangdong', 'Shaoguan', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSXoWCYliaBo8Mjic4nYe5VOK0k8BPFheWbbyTlSnB0DI4okfgUjzRqSicU9cLZicnZInBXfg5hzhyDUrXmbWFpVOmfZ/0', 0, 1512990292, '', ''),
(34, 1, 'o6EX5w8imGhtHVaMEG69_kT7sfdU', '陈', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvxRPfxW6w3TdWSqXXAkXOVn8icB0oGYEWwVXYENPxjDbue9XRdUldux9TcMOCym7YNEcGPiakZOtXmcZkLkpjUSa/0', 0, 1513037916, '', ''),
(35, 1, 'o6EX5w7rQGo96hmhZ2gpaVb-eoDM', '过好每一天', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvVBAWibibFVSn5A67kFjrLXBSLpG5ibeKR1awgyxAd8Dmyj0MicLZMcNKbCOIl6UZ7OCTNWKbBuRc7C1CHjXORs1V2/0', 0, 1513040659, '', ''),
(36, 1, 'o6EX5w93oebN20OpqU0HbOpP2gDg', '老潘泓宇车业', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIu7pGMx08pfXbmoibxkauzrTwHk6eTXJxgt7FsReNUWOVfQcT9NNRDDYBDfnQLChBTjvh17iaDcR9pyCrnNHQtAUF/0', 0, 1513041100, '', ''),
(37, 1, 'o6EX5w-DkiPOv1FV-PSEkLIrEO7c', '吕治辉', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/Q3auHgzwzM5tWtelogMZavJthY51o5UmgwZicZABvXU6NTMrMrgQCicHHTAhyoz2sFSAbgnEdWW1icw2XJyKFfibicw/0', 0, 1513047509, '', ''),
(38, 1, 'o6EX5w68NDfZoILXNGRDjrdtWQQw', '莫明', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/AFT5OJ1ejFicn5qR0icN3eHu0GJk6UYdGY2qqPictJLHlNwadJWs6TnB2aE3rtxFpaH9O8EI3z9bIr8DvjsFKCnNHp2M8VqlHg0/0', 0, 1513070009, '', ''),
(39, 1, 'o6EX5w5nFeHI-3Osizhx6AKjrO08', '随缘', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSWyNWBZgREQFEBiaavCTlepcB41pbiaeYIOPHJJp2KdFqQRCYh8XXKDkcKfNl4R9Y2g8aibxaaToFCS2hG11fNZibbw/0', 0, 1513071135, '', ''),
(40, 1, 'o6EX5wwq1iiZpoH8gzDmU-2sV1Bg', '????萍', 2, 'Morocco', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/Q3auHgzwzM5Gb5EJINmx6dx7iaJUUK5vaF3HRBTBia6icVS31RZumeh2veFSM9kJJoyylf9yPTHx4bD3NqOibEQ276etoYO0QKkuvAphy9NVvW8/0', 0, 1513128940, '', ''),
(41, 1, 'o6EX5w-spUnrqf38oKR3Hk2PDZzc', 'The Gods Must Be Crazy', 1, 'China', 'Hong Kong', 'Wan Chai', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58icxqJI5ic6g1Q36kn5JsxcNDEB1LIOrFffw9jZgq8Ev5UvYhibe8LHk7jKH8HibE64BHLmUibyH53RPP13IHrXBBA7z/0', 0, 1513152684, '', ''),
(42, 1, 'o6EX5wxGKUq8G6vXMm9n_BI4A68A', '朴素', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU589icn6Jze0xBG7YibB7V2ThjcibpBnAIdib0dvVUFeSic45Ubl6fhn2zNibkEvicPGZ64NwpKh5ENG1Hhew0fPe8dP3vlg/0', 0, 1513164647, '', ''),
(43, 1, 'o6EX5w9ZyF_oxODC3-umVSHffW50', '咿呀咿呀哟????', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvpVgicI2oGTayM2LbUSvg0AOfX4MImYBRF8P1ZIut5GmPW1sibj4VibfqavOxG45rrvxIhbuR68eiaLCmYdbvOY2yU/0', 0, 1513212881, '', ''),
(44, 1, 'o6EX5w00Xc8teuhuz5h3a8cSDMIo', 'CC', 2, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSXBx11YaZcDKmbRT0CgicjkGAQ7wLYesg8IqLSQwYJId6NG7WE9PpfrTicBLdLmWdsp23ibazlibQiaqA3m7rAicibkIL9/0', 0, 1513298431, '', ''),
(45, 1, 'o6EX5w8wKriB8MnZctf9dzTgDvoQ', '扬帆远航', 2, 'Zambia', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58icxcib8fT8WA87H5YtqoHRibicicH5AaharhKzJvxSY4pWxNlVD1eQPj80Nwvx8RujCKFwTw2Id042ibXC1zrE1kdl1V/0', 0, 1513299341, '', ''),
(46, 1, 'o6EX5w9YBMsFaU_YwqhSEBFr41uk', '跟着感觉走', 2, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/kItx0oWGJW4Fia06bJiavZEicd6jUvjImgaOMFAJBoeyrrnW2UjplhlfSV46EaY9lDHfT0EBuQV7RlFnvibtZwGG7Oetyicyibn375/0', 0, 1513299610, '', ''),
(47, 1, 'o6EX5wyuc0nBZkSHNJKP8xNYfVLo', '小罗', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/0yOibuhvkGFibJsb3xy8gH6BTiasUC3dSDU7oX9qeE2drvhXsDJNejTNZqBD6R5I13aNOdUg0tZto51AL9tTbXGFfr6ZC0aEImY/0', 0, 1513308436, '', ''),
(48, 1, 'o6EX5w8h7ihJBthKvNsa3k1zAkl8', '玉米小刘', 0, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSU4Dlv29c6re17YIwc6HTHCIw2SCS20enal4OtMfOBxIv30IgAeTqwCOEMhTmBY7hCtFriaVuuiaOtCqMZY9PbA5f/0', 0, 1513385942, '', ''),
(49, 1, 'o6EX5w8IPEVa-49LbucpltduSsnY', '绝缘', 1, '', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/Q3auHgzwzM6p2pwYSb0mQ3bpeW5KEeDTstj5waEwCOFib2tPopKfyPTGibtJLKbfcfyEfEljqyjibzDKkjCE0ibvgT2e3o6eYqnHeqPOHyLBOibc/0', 0, 1513386835, '', ''),
(50, 1, 'o6EX5w578hnCScbP6DAhjhq-cS8s', '李桂华', 1, 'Eritrea', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58icybMSPwE3KE8iaWokFOh1aSwjS3Q3icIxFBQPflXepQoicFzib0OMNkgj0Mj9JLhkZSs5oIt0diby7ibEiahmAyYibyQEg/0', 0, 1513387895, '', ''),
(51, 1, 'o6EX5wxO9TWmH1pavYbZlu3lmPjU', '万禾、雷堆', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/fo6LdnuU58icFRnRSLzRTPGVarXica58capYcyCUuK48GcT8v1BCDJtRAzEqI8UkC3HzbTfWXsmt7FXMl9HhLWeVhIIJ6Jrf5E/0', 0, 1513396229, '', ''),
(52, 1, 'o6EX5w8t_bKJxSPkw9AheUPMQ4Z0', '軍歌嘹亮', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIvpVgicI2oGTa1DBcfOYEP3PIpkicNG94JoBWfibeBz6Sz4QKwibG3yLqCTtHUFCibhrQoSLAibWdbRIRcQ3Ra2KiaBXCR/0', 0, 1513411684, '', ''),
(53, 1, 'o6EX5wzO885dpbh6YSvH5lu7EOxU', 'Young????', 2, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/Q3auHgzwzM5FIhdaeB05bbUtskZT4pa9xibkN5PGJTY5qibibFXPDZyD3ibbTrTyk9V7qGkYB26I3UIs9icq0riabQSQ/0', 0, 1513582247, '', ''),
(54, 1, 'o6EX5wyj_-wi1Kt6csDKhqrPNFc8', '曾经拥有。', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/gnM7ibjZjSicpY6iahUEJdnJuzYKbomxddQxHPDkrlXqqTeLZVBVMxqicB7eo7EP8eXxy1C1aVDkVmYvpvqorNfod5WSPm9uyfKb/0', 0, 1513612377, '', ''),
(55, 1, 'o6EX5w5Ha-PhwNLi6DsxMNC40gY0', '秀', 2, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/J1JTpA6RQSVL4RpicXFBFKSPZ1fiaqZLRiaXWrEJV2CnYha33eTJhepKYiaak5btTQpuqXcEWkbPFFmsjcsKPTrJ3HTyP4ibrqk78/0', 0, 1513658311, '', ''),
(56, 1, 'o6EX5w24nS7yBFTy9Z50IzZbUsdg', '土猪肉配送、(许)', 1, 'China', '', '', 'zh_CN', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLCYEgm4vFK7Lp44p2jf6u0Uicvaj2AnpdsibZC8OwcvUXoRtkV9IQhDbyn3TJsm4fOrrIOpjOHC8uag/0', 0, 1513684466, '', ''),
(57, 1, 'o6EX5wygSMUH8TqZtoCH_bYOjmj0', '聪', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/Q3auHgzwzM6p2pwYSb0mQ3bpeW5KEeDTrNFL3aq7ekOqv8DdejxRqKLVTyXdzGCfMXWL4AFunoHJa76IxFbmEichDsbzeUXo3DNrnZE4gGGk/0', 0, 1513727815, '', ''),
(58, 1, 'o6EX5w2UPML51gg0YT2TqoEFrjgM', '米粉你超哥', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/9QCw5a6s22jpIdFey9KXq8KdYomqjlFpQVuCpQ7DHy9JDiadrobn3dGjCeNAoRvl610DAz4Wa35pG67nUE8nm9DZ0wsmgow82/0', 0, 1513849973, '', ''),
(59, 1, 'o6EX5w9ah34mqWQXDAoyS_MLhSm4', '粟雄', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIu7pGMx08pfXaF4zOgbHbgRYvDF4YPfkrvu2Ndh6eg2qia53SNefccXic0SpztqJj19Agowwn1HPPu4BsMBQ3LTibV/0', 0, 1514620063, '', ''),
(60, 1, 'o6EX5w_qo7ivRrWOY9wt6oyhwK1I', '赖', 1, 'China', 'Guangxi', 'Guilin', 'zh_CN', 'http://wx.qlogo.cn/mmopen/icMToSS3kxIu7pGMx08pfXe9cbBzYPmbWKJIyCgRvMvz53XjLibALs2V28C5Tp55yukJwfyiaYT5VeLElqDSmTAzZA55WiaBNQE9/0', 0, 1514769783, '', '');

--
-- Indexes for table `area`
--
ALTER TABLE `area`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `authlimit`
--
ALTER TABLE `authlimit`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `backup`
--
ALTER TABLE `backup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `buyer`
--
ALTER TABLE `buyer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_name` (`name`);

--
-- Indexes for table `buyerbinding`
--
ALTER TABLE `buyerbinding`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_wb` (`wid`,`buyer`);

--
-- Indexes for table `buyerstatistic`
--
ALTER TABLE `buyerstatistic`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `text` (`text`);

--
-- Indexes for table `document`
--
ALTER TABLE `document`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `title` (`title`);

--
-- Indexes for table `emailcode`
--
ALTER TABLE `emailcode`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `func`
--
ALTER TABLE `func`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `goods`
--
ALTER TABLE `goods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_name` (`name`);

--
-- Indexes for table `goodsalias`
--
ALTER TABLE `goodsalias`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_name` (`name`);

--
-- Indexes for table `goodscategory`
--
ALTER TABLE `goodscategory`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_name` (`name`);

--
-- Indexes for table `image`
--
ALTER TABLE `image`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `imagematerial`
--
ALTER TABLE `imagematerial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `text` (`text`,`level`,`pid`);

--
-- Indexes for table `myseller`
--
ALTER TABLE `myseller`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_buyer_seller` (`buyer`,`seller`);

--
-- Indexes for table `newsarticle`
--
ALTER TABLE `newsarticle`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsmaterial`
--
ALTER TABLE `newsmaterial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orderitem`
--
ALTER TABLE `orderitem`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchasingorder`
--
ALTER TABLE `purchasingorder`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roleaccess`
--
ALTER TABLE `roleaccess`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `seller`
--
ALTER TABLE `seller`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_name` (`name`);

--
-- Indexes for table `sellerbinding`
--
ALTER TABLE `sellerbinding`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_ws` (`wid`,`seller`);

--
-- Indexes for table `sellerstatistic`
--
ALTER TABLE `sellerstatistic`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `userinfo`
--
ALTER TABLE `userinfo`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `usertag`
--
ALTER TABLE `usertag`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wechatmenu`
--
ALTER TABLE `wechatmenu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wechatreply`
--
ALTER TABLE `wechatreply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wechattag`
--
ALTER TABLE `wechattag`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wechatuser`
--
ALTER TABLE `wechatuser`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `openid` (`openid`);
--
-- 使用表AUTO_INCREMENT `area`
--
ALTER TABLE `area`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3338;
--
-- 使用表AUTO_INCREMENT `authlimit`
--
ALTER TABLE `authlimit`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
--
-- 使用表AUTO_INCREMENT `backup`
--
ALTER TABLE `backup`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `buyer`
--
ALTER TABLE `buyer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '买家', AUTO_INCREMENT=5;
--
-- 使用表AUTO_INCREMENT `buyerbinding`
--
ALTER TABLE `buyerbinding`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
--
-- 使用表AUTO_INCREMENT `buyerstatistic`
--
ALTER TABLE `buyerstatistic`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- 使用表AUTO_INCREMENT `cart`
--
ALTER TABLE `cart`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4308;
--
-- 使用表AUTO_INCREMENT `category`
--
ALTER TABLE `category`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `document`
--
ALTER TABLE `document`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `emailcode`
--
ALTER TABLE `emailcode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `func`
--
ALTER TABLE `func`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=337;
--
-- 使用表AUTO_INCREMENT `goods`
--
ALTER TABLE `goods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物品', AUTO_INCREMENT=1123;
--
-- 使用表AUTO_INCREMENT `goodsalias`
--
ALTER TABLE `goodsalias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物品别名', AUTO_INCREMENT=22;
--
-- 使用表AUTO_INCREMENT `goodscategory`
--
ALTER TABLE `goodscategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID', AUTO_INCREMENT=9;
--
-- 使用表AUTO_INCREMENT `image`
--
ALTER TABLE `image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
--
-- 使用表AUTO_INCREMENT `imagematerial`
--
ALTER TABLE `imagematerial`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;
--
-- 使用表AUTO_INCREMENT `myseller`
--
ALTER TABLE `myseller`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '我的卖家', AUTO_INCREMENT=37;
--
-- 使用表AUTO_INCREMENT `newsarticle`
--
ALTER TABLE `newsarticle`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `newsmaterial`
--
ALTER TABLE `newsmaterial`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `orderitem`
--
ALTER TABLE `orderitem`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4316;
--
-- 使用表AUTO_INCREMENT `purchasingorder`
--
ALTER TABLE `purchasingorder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=723;
--
-- 使用表AUTO_INCREMENT `role`
--
ALTER TABLE `role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `roleaccess`
--
ALTER TABLE `roleaccess`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;
--
-- 使用表AUTO_INCREMENT `seller`
--
ALTER TABLE `seller`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '卖家', AUTO_INCREMENT=33;
--
-- 使用表AUTO_INCREMENT `sellerbinding`
--
ALTER TABLE `sellerbinding`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;
--
-- 使用表AUTO_INCREMENT `sellerstatistic`
--
ALTER TABLE `sellerstatistic`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=645;
--
-- 使用表AUTO_INCREMENT `userinfo`
--
ALTER TABLE `userinfo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
--
-- 使用表AUTO_INCREMENT `usertag`
--
ALTER TABLE `usertag`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `wechatmenu`
--
ALTER TABLE `wechatmenu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 使用表AUTO_INCREMENT `wechatreply`
--
ALTER TABLE `wechatreply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `wechattag`
--
ALTER TABLE `wechattag`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `wechatuser`
--
ALTER TABLE `wechatuser`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
