497 Star 1.3K Fork 528

GVPeinsqing / wemall

Create your Gitee Account
Explore and code with more than 5 million developers,Free private repositories !:)
Sign up
Clone or download
wemall7.sql 159.84 KB
Copy Edit Web IDE Raw Blame History
einsqing authored 2020-06-16 21:42 . no message
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687
-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: 2017-05-27 10:28:39
-- 服务器版本: 5.5.42
-- PHP Version: 5.5.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `wemall7`
--
-- --------------------------------------------------------
--
-- 表的结构 `admin`
--
CREATE TABLE `admin` (
`id` int(10) unsigned NOT NULL COMMENT '用户ID',
`group_id` int(11) NOT NULL DEFAULT '1' COMMENT '用户组id',
`username` char(16) DEFAULT NULL COMMENT '用户名',
`password` char(32) DEFAULT NULL COMMENT '密码',
`email` char(32) DEFAULT NULL COMMENT '用户邮箱',
`mobile` char(15) DEFAULT NULL COMMENT '用户手机',
`reg_ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
`last_login_time` timestamp NULL DEFAULT NULL COMMENT '最后登录时间',
`last_login_ip` text COMMENT '最后登录IP',
`status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
`remark` text COMMENT '备注',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='后台用户表';
--
-- 转存表中的数据 `admin`
--
INSERT INTO `admin` (`id`, `group_id`, `username`, `password`, `email`, `mobile`, `reg_ip`, `last_login_time`, `last_login_ip`, `status`, `remark`, `created_at`, `updated_at`) VALUES
(1, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '296720094@qq.com', '18053449656', '0', '2017-05-27 01:45:05', '0.0.0.0', 1, '', '0000-00-00 00:00:00', '2017-05-27 01:45:05'),
(2, 1, '1', 'c4ca4238a0b923820dcc509a6f75849b', '1604583867@qq.com', '18538753627', '127.0.0.1', '0000-00-00 00:00:00', '2130706433', 1, '1', '0000-00-00 00:00:00', '2017-02-15 14:33:01'),
(3, 2, '2', '779d005fa526b871d424fcab8140582f', '1604583867@qq.com', '18538753627', '127.0.0.1', '0000-00-00 00:00:00', '0', 1, '1', '0000-00-00 00:00:00', '2017-01-17 01:25:23');
-- --------------------------------------------------------
--
-- 表的结构 `ads`
--
CREATE TABLE `ads` (
`id` int(10) unsigned NOT NULL,
`position_id` int(11) NOT NULL DEFAULT '0' COMMENT '广告位置',
`name` text,
`sub` text,
`file_id` int(11) NOT NULL DEFAULT '0',
`url` text,
`remark` text,
`rank` int(11) DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '1' COMMENT '1:开启0:关闭',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `ads`
--
INSERT INTO `ads` (`id`, `position_id`, `name`, `sub`, `file_id`, `url`, `remark`, `rank`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, '1', '1210', 108, '19', '1', 0, 1, '2015-11-06 06:58:06', '2017-03-03 03:11:27'),
(2, 2, '2', '', 98, '', '1', 0, 1, '2015-11-06 06:58:20', '2017-03-03 03:11:32'),
(3, 2, '3', '', 99, '', '1', 0, 1, '2015-11-06 06:58:30', '2017-03-03 03:11:35'),
(4, 2, '4', '', 100, '', '1', 333, 1, '2015-11-06 06:58:41', '2017-03-03 01:19:23'),
(6, 2, '广告测试', '2222', 97, '', '1', 222, 1, '2016-01-05 08:14:23', '2017-03-01 09:45:37'),
(7, 2, '111', '111', 95, '11', '111', 222, 1, '2017-03-02 08:35:42', '2017-03-03 03:11:19');
-- --------------------------------------------------------
--
-- 表的结构 `ads_position`
--
CREATE TABLE `ads_position` (
`id` int(11) unsigned NOT NULL,
`name` text,
`sub` text,
`status` tinyint(1) NOT NULL DEFAULT '1',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `ads_position`
--
INSERT INTO `ads_position` (`id`, `name`, `sub`, `status`, `created_at`, `updated_at`) VALUES
(1, '幻灯片', '', 1, '2016-12-15 14:42:54', '2017-02-13 02:23:00'),
(2, '首页广告', NULL, 1, '2017-02-17 03:27:55', '0000-00-00 00:00:00'),
(3, '快捷菜单', '', 1, '2017-03-15 07:46:10', '2017-03-15 07:46:10');
-- --------------------------------------------------------
--
-- 表的结构 `analysis`
--
CREATE TABLE `analysis` (
`id` int(10) unsigned NOT NULL,
`orders` int(11) NOT NULL DEFAULT '0',
`trades` float NOT NULL DEFAULT '0',
`registers` int(11) NOT NULL DEFAULT '0',
`users` int(11) NOT NULL DEFAULT '0' COMMENT '当天购买人数',
`date` text,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `analysis`
--
INSERT INTO `analysis` (`id`, `orders`, `trades`, `registers`, `users`, `date`, `created_at`, `updated_at`) VALUES
(1, 0, 0, 10, 23, '2017-01-03', '2015-11-15 21:57:10', '2016-08-16 15:56:59'),
(2, 3, 46, 12, 3, '2017-01-04', '2015-11-17 14:07:19', '2016-08-16 15:56:50'),
(3, 5, 180, 0, 5, '2016-08-07', '2015-11-18 11:05:35', '2016-08-16 15:56:47'),
(4, 9, 286, 0, 9, '2016-08-08', '2015-11-19 16:08:57', '2016-08-16 15:56:42'),
(5, 1, 36, 0, 1, '2016-08-09', '2015-11-22 15:06:03', '2016-08-16 15:56:37'),
(6, 2, 84, 0, 2, '2016-08-10', '2015-12-22 09:47:38', '2016-08-16 15:56:30'),
(7, 5, 90, 0, 5, '2016-08-11', '2015-12-23 10:49:23', '2016-08-16 15:56:25'),
(8, 65, 72, 0, 0, '2016-08-12', '2016-01-05 20:36:40', '2016-08-16 15:56:18'),
(9, 6, 48, 0, 0, '2016-08-13', '2016-01-06 14:45:39', '2016-08-16 15:56:14'),
(10, 2, 38, 0, 0, '2016-11-26', '2016-01-08 10:07:45', '2016-11-25 15:56:09'),
(11, 1, 24, 0, 0, '2016-11-28', '2016-01-17 11:41:34', '2016-11-27 15:56:04'),
(12, 12, 664, 5, 10, '2016-11-29', '2016-10-31 17:02:27', '2016-11-28 15:56:00'),
(13, 6, 404, 3, 0, '2016-11-30', '2016-08-17 17:02:09', '2016-11-29 11:55:58'),
(14, 0, 0, 0, 1, '2017-01-12', '2017-01-12 01:47:05', '2017-01-12 01:47:05'),
(15, 0, 0, 0, 1, '2017-01-13', '2017-01-12 19:35:11', '2017-01-12 19:35:11'),
(16, 0, 0, 0, 1, '2017-01-14', '2017-01-13 18:37:30', '2017-01-13 18:37:30'),
(17, 0, 0, 1, 1, '2017-01-16', '2017-01-15 18:40:55', '2017-01-16 00:51:10'),
(18, 0, 0, 1, 0, '2017-01-22', '2017-01-21 21:15:32', '2017-01-21 21:15:32'),
(19, 0, 0, 1, 1, '2017-02-08', '2017-02-07 22:37:37', '2017-02-08 05:55:10'),
(20, 0, 0, 0, 1, '2017-02-14', '2017-02-13 23:14:35', '2017-02-13 23:14:35'),
(21, 0, 0, 0, 1, '2017-02-16', '2017-02-15 17:11:59', '2017-02-15 17:11:59'),
(22, 0, 0, 1, 0, '2017-02-18', '2017-02-17 22:32:11', '2017-02-17 22:32:11'),
(23, 0, 0, 0, 1, '2017-02-21', '2017-02-21 03:35:45', '2017-02-21 03:35:45'),
(25, 0, 0, 1, 1, '2017-02-28', '2017-02-27 16:10:41', '2017-02-23 01:01:06'),
(26, 2, 3, 2, 3, '2017-03-01', '2017-02-28 21:12:38', '2017-02-24 02:45:18'),
(28, 5, 36, 0, 0, '2017-03-02', '2017-03-02 09:25:52', '2017-03-02 09:25:52'),
(29, 31, 2062, 0, 0, '2017-03-03', '2017-03-03 03:25:10', '2017-03-03 03:25:10'),
(30, 20, 1106, 4, 4, '2017-03-04', '2017-03-04 01:31:56', '2017-03-04 01:31:56'),
(31, 9, 577, 1, 9, '2017-03-06', '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(32, 50, 204.35, 1, 38, '2017-03-07', '2017-03-07 01:50:13', '2017-03-07 01:50:13'),
(33, 17, 0.17, 3, 5, '2017-03-08', '2017-03-08 01:11:27', '2017-03-08 01:11:27'),
(34, 0, 0, 1, 0, '2017-03-09', '2017-03-09 01:34:16', '2017-03-09 01:34:16'),
(35, 0, 0, 2, 0, '2017-03-10', '2017-03-10 06:30:19', '2017-03-10 06:30:19'),
(36, 0, 0, 1, 0, '2017-03-13', '2017-03-13 08:53:30', '2017-03-13 08:53:30');
-- --------------------------------------------------------
--
-- 表的结构 `article`
--
CREATE TABLE `article` (
`id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '0',
`title` text,
`author` text COMMENT '作者',
`sub` text,
`content` text,
`remark` text,
`visiter` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '1' COMMENT '1:开启0:关闭',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `article`
--
INSERT INTO `article` (`id`, `category_id`, `title`, `author`, `sub`, `content`, `remark`, `visiter`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '关于我们', '大白', '简介', '<p>这里放关于我们内容</p>', '1', 11, 1, '2016-01-05 14:41:14', '2017-03-02 06:52:09');
-- --------------------------------------------------------
--
-- 表的结构 `article_category`
--
CREATE TABLE `article_category` (
`id` int(11) unsigned NOT NULL,
`pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级',
`name` text COMMENT '类型',
`status` int(11) NOT NULL DEFAULT '1' COMMENT '1:开启0:关闭',
`remark` text COMMENT '备注',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文章类型';
--
-- 转存表中的数据 `article_category`
--
INSERT INTO `article_category` (`id`, `pid`, `name`, `status`, `remark`, `created_at`, `updated_at`) VALUES
(1, 0, '帮助', 1, 'pc端页面下帮助', '2016-12-08 23:17:30', '2017-02-17 02:07:13');
-- --------------------------------------------------------
--
-- 表的结构 `auth_group`
--
CREATE TABLE `auth_group` (
`id` int(8) unsigned NOT NULL,
`title` char(100) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1:启用0:禁用',
`rules` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `auth_group`
--
INSERT INTO `auth_group` (`id`, `title`, `status`, `rules`, `created_at`, `updated_at`) VALUES
(1, '超级管理员', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,', '2017-01-16 01:28:11', '0000-00-00 00:00:00'),
(2, '普通管理员', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58', '2017-01-16 06:59:52', '2017-02-15 09:08:55');
-- --------------------------------------------------------
--
-- 表的结构 `auth_group_access`
--
CREATE TABLE `auth_group_access` (
`id` int(10) unsigned NOT NULL,
`uid` int(11) NOT NULL DEFAULT '0',
`group_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `auth_group_access`
--
INSERT INTO `auth_group_access` (`id`, `uid`, `group_id`) VALUES
(1, 1, 1),
(3, 2, 1),
(5, 4, 2),
(6, 5, 2),
(7, 6, 2),
(8, 7, 1);
-- --------------------------------------------------------
--
-- 表的结构 `auth_rule`
--
CREATE TABLE `auth_rule` (
`id` mediumint(8) unsigned NOT NULL,
`name` char(80) DEFAULT NULL,
`title` char(20) DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT '1',
`rank` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) NOT NULL DEFAULT '1',
`condition` char(100) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `auth_rule`
--
INSERT INTO `auth_rule` (`id`, `name`, `title`, `type`, `rank`, `status`, `condition`, `created_at`, `updated_at`) VALUES
(1, 'admin/index/index', '系统首页', 1, 0, 1, '', '2017-01-09 08:37:37', '0000-00-00 00:00:00'),
(2, 'admin/analysis/user', '用户分析', 1, 0, 1, '', '2017-01-10 07:20:26', '0000-00-00 00:00:00'),
(3, 'admin/analysis/order', '订单分析', 1, 0, 1, '', '2017-01-10 07:25:40', '0000-00-00 00:00:00'),
(4, 'admin/analysis/product', '商品分析', 1, 0, 1, '', '2017-01-10 07:27:28', '0000-00-00 00:00:00'),
(5, 'admin/config.shop/index', '商城设置', 1, 0, 1, '', '2017-01-11 03:13:45', '0000-00-00 00:00:00'),
(6, 'admin/tpl.shop/index', '商城模板设置', 1, 0, 1, '', '2017-01-11 14:52:45', '0000-00-00 00:00:00'),
(7, 'admin/config.pay/index', '支付方式列表', 1, 0, 1, '', '2017-01-11 03:42:28', '0000-00-00 00:00:00'),
(8, 'admin/wx.config/index', '微信设置', 1, 0, 1, '', '2017-01-11 07:10:02', '0000-00-00 00:00:00'),
(9, 'admin/wx.menu/index', '微信菜单设置', 1, 0, 1, '', '2017-01-11 07:39:06', '0000-00-00 00:00:00'),
(10, 'admin/wx.menu/add', '新增修改微信菜单', 1, 0, 1, '', '2017-01-11 08:03:05', '0000-00-00 00:00:00'),
(11, 'admin/wx.menu/del', '删除微信菜单', 1, 0, 1, '', '2017-01-12 03:05:09', '0000-00-00 00:00:00'),
(12, 'admin/wx.reply/index', '微信自定义回复设置', 1, 0, 1, '', '2017-01-12 06:40:51', '0000-00-00 00:00:00'),
(13, 'admin/wx.reply/add', '新增修改自定义回复', 1, 0, 1, '', '2017-01-12 07:19:59', '0000-00-00 00:00:00'),
(14, 'admin/article.category/index', '文章分类', 1, 0, 1, '', '2017-01-14 01:35:20', '0000-00-00 00:00:00'),
(15, 'admin/article.category/add', '新增修改文章分类', 1, 0, 1, '', '2017-01-14 03:30:50', '0000-00-00 00:00:00'),
(16, 'admin/article.category/del', '删除文章分类', 1, 0, 1, '', '2017-01-14 03:42:44', '0000-00-00 00:00:00'),
(17, 'admin/article.index/index', '文章列表', 1, 0, 1, '', '2017-01-14 04:05:56', '0000-00-00 00:00:00'),
(18, 'admin/article.index/add', '新增修改文章', 1, 0, 1, '', '2017-01-16 01:26:29', '0000-00-00 00:00:00'),
(19, 'admin/auth.group/index', '用户组管理', 1, 0, 1, '', '2017-01-16 03:16:56', '0000-00-00 00:00:00'),
(20, 'admin/auth.group/add', '新增修改用户组', 1, 0, 1, '', '2017-01-16 03:44:14', '0000-00-00 00:00:00'),
(21, 'admin/auth.group/del', '删除用户组', 1, 0, 1, '', '2015-10-14 10:18:46', '0000-00-00 00:00:00'),
(22, 'admin/auth.group/update', '更改用户组状态', 1, 0, 1, '', '2015-10-14 10:19:00', '0000-00-00 00:00:00'),
(23, 'admin/auth.admin/index', '管理员管理', 1, 0, 1, '', '2015-10-14 06:03:58', '0000-00-00 00:00:00'),
(24, 'admin/auth.admin/add', '新增修改管理员', 1, 0, 1, '', '2015-10-14 06:03:58', '0000-00-00 00:00:00'),
(25, 'admin/auth.admin/del', '删除管理员', 1, 0, 1, '', '2015-10-14 06:03:58', '0000-00-00 00:00:00'),
(26, 'admin/auth.admin/update', '更改管理员状态', 1, 0, 1, '', '2015-10-14 10:19:56', '0000-00-00 00:00:00'),
(27, 'admin/user.index/index', '用户列表', 1, 0, 1, '', '2015-10-14 06:03:58', '0000-00-00 00:00:00'),
(28, 'admin/user.index/add', '新增修改用户', 1, 0, 1, '', '2015-10-14 06:03:58', '0000-00-00 00:00:00'),
(29, 'admin/user.index/del', '删除用户', 1, 0, 1, '', '2015-10-14 10:20:12', '0000-00-00 00:00:00'),
(30, 'admin/user.index/update', '更新用户状态', 1, 0, 1, '', '2015-10-14 10:20:18', '0000-00-00 00:00:00'),
(33, 'admin/file/index', '图片列表', 1, 0, 1, '', '2015-10-14 06:08:44', '0000-00-00 00:00:00'),
(34, 'admin/file/upload', '图片上传', 1, 0, 1, '', '2015-10-14 06:08:44', '0000-00-00 00:00:00'),
(35, 'admin/file/del', '删除图片', 1, 0, 1, '', '2015-10-14 06:08:44', '0000-00-00 00:00:00'),
(36, 'admin/shop.product.category/index', '菜单列表', 1, 0, 1, '', '2015-10-14 06:08:44', '0000-00-00 00:00:00'),
(37, 'admin/shop.product.category/add', '新增修改菜单', 1, 0, 1, '', '2015-10-18 03:09:21', '0000-00-00 00:00:00'),
(38, 'admin/shop.product.category/del', '删除菜单', 1, 0, 1, '', '2015-10-14 10:21:04', '0000-00-00 00:00:00'),
(39, 'admin/shop.product.label/index', '标签列表', 1, 0, 1, '', '2015-10-14 10:21:11', '0000-00-00 00:00:00'),
(40, 'admin/shop.product.label/add', '新增修改标签', 1, 0, 1, '', '2015-10-14 10:21:17', '0000-00-00 00:00:00'),
(41, 'admin/shop.product.label/del', '删除标签', 1, 0, 1, '', '2015-10-14 10:21:23', '0000-00-00 00:00:00'),
(42, 'admin/shop.product.index/index', '商品列表', 1, 0, 1, '', '2015-10-14 10:21:31', '0000-00-00 00:00:00'),
(43, 'admin/shop.product.index/add', '新增修改商品', 1, 0, 1, '', '2015-10-14 10:21:37', '0000-00-00 00:00:00'),
(44, 'admin/shop.product.index/update', '更新商品状态', 1, 0, 1, '', '2015-10-14 10:21:43', '0000-00-00 00:00:00'),
(45, 'admin/shop.product.index/del', '删除商品', 1, 0, 1, '', '2015-10-14 10:21:48', '0000-00-00 00:00:00'),
(46, 'admin/shop.product.sku/index', 'sku列表', 1, 0, 1, '', '2015-10-14 10:21:54', '0000-00-00 00:00:00'),
(47, 'admin/shop.product.sku/add', '新增修改sku', 1, 0, 1, '', '2015-10-14 10:22:00', '0000-00-00 00:00:00'),
(48, 'admin/shop.product.sku/del', '删除sku', 1, 0, 1, '', '2015-10-14 10:22:09', '0000-00-00 00:00:00'),
(49, 'admin/shop.product.sku/getlist', 'ajax获取sku', 1, 0, 1, '', '2015-10-14 10:22:14', '0000-00-00 00:00:00'),
(50, 'admin/config.wx/delreply', '删除自定义回复', 1, 0, 1, '', '2015-10-18 02:16:38', '0000-00-00 00:00:00'),
(51, 'admin/article.index/del', '删除文章', 1, 0, 1, '', '2015-10-14 06:11:01', '0000-00-00 00:00:00'),
(52, 'admin/shop.product.comment/index', '用户评论', 1, 0, 1, '', '2015-10-18 02:19:17', '0000-00-00 00:00:00'),
(53, 'admin/shop.product.comment/del', '删除评论', 1, 0, 1, '', '2015-10-18 02:19:35', '0000-00-00 00:00:00'),
(54, 'admin/shop.product.comment/update', '更改评论状态', 1, 0, 1, '', '2015-10-14 10:21:23', '0000-00-00 00:00:00'),
(55, 'admin/config.pay/update', '修改支付方式状态', 1, 0, 1, '', '2015-10-18 02:21:13', '0000-00-00 00:00:00'),
(56, 'admin/config.pay/add', '配置支付', 1, 0, 1, '', '2015-10-18 02:24:07', '0000-00-00 00:00:00'),
(57, 'admin/shop.order.index/index', '订单列表', 1, 0, 1, '', '2015-10-14 10:21:23', '0000-00-00 00:00:00'),
(58, 'admin/shop.order.index/detail', '订单详情', 1, 0, 1, '', '2017-01-10 13:52:32', '0000-00-00 00:00:00'),
(59, 'admin/config.delivery/index', '快递列表', 1, 0, 1, '', '2017-01-10 14:00:50', '0000-00-00 00:00:00'),
(60, 'admin/config.delivery/add', '添加修改快递', 1, 0, 1, '', '2017-02-13 18:13:26', '0000-00-00 00:00:00'),
(61, 'admin/config.delivery/del', '删除快递', 1, 0, 1, '', '2017-02-14 23:21:34', '0000-00-00 00:00:00'),
(62, 'admin/config.delivery/update', '启用禁用快递', 1, 0, 1, '', '2017-02-15 01:34:53', '0000-00-00 00:00:00'),
(63, 'admin/shop.order.index/update', '更改订单状态', 1, 0, 1, '', '2017-02-15 03:15:37', '0000-00-00 00:00:00'),
(64, 'admin/shop.product.booking/index', '缺货登记列表', 1, 0, 1, '', '2017-02-15 03:25:32', '0000-00-00 00:00:00'),
(65, 'admin/shop.order.backtype/index', '售后类型列表', 1, 0, 1, '', '2017-02-15 07:15:19', '0000-00-00 00:00:00'),
(66, 'admin/shop.order.backtype/add', '编辑添加售后类型', 1, 0, 1, '', '2017-02-15 07:30:01', '0000-00-00 00:00:00'),
(67, 'admin/shop.order.backtype/del', '删除售后类型', 1, 0, 1, '', '2017-02-15 07:30:41', '0000-00-00 00:00:00'),
(68, 'admin/shop.order.backtype/update', '更新售后类型状态', 1, 0, 1, '', '2017-02-15 07:31:09', '0000-00-00 00:00:00'),
(69, 'admin/shop.order.backlist/index', '售后列表', 1, 0, 1, '', '2017-02-15 08:05:53', '0000-00-00 00:00:00'),
(70, 'admin/shop.order.backlist/update', '更改售后状态', 1, 0, 1, '', '2017-02-15 08:29:54', '0000-00-00 00:00:00'),
(71, 'admin/user.level/index', '会员等级列表', 1, 0, 1, '', '2017-02-15 10:10:19', '0000-00-00 00:00:00'),
(72, 'admin/user.level/add', '新增编辑会员等级', 1, 0, 1, '', '2017-02-15 10:15:43', '0000-00-00 00:00:00'),
(73, 'admin/user.level/del', '删除会员等级', 1, 0, 1, '', '2017-02-15 11:18:56', '0000-00-00 00:00:00'),
(74, 'admin/user.msg/index', '消息列表', 1, 0, 1, '', '2017-02-15 11:19:21', '0000-00-00 00:00:00'),
(75, 'admin/user.msg/add', '添加修改消息', 1, 0, 1, '', '2017-02-15 12:53:51', '0000-00-00 00:00:00'),
(76, 'admin/user.msg/del', '删除消息', 1, 0, 1, '', '2017-02-15 12:54:14', '0000-00-00 00:00:00'),
(77, 'admin/user.msg/update', '更新消息状态', 1, 0, 1, '', '2017-02-15 12:54:38', '0000-00-00 00:00:00'),
(78, 'admin/user.tx/index', '提现列表', 1, 0, 1, '', '2017-02-15 13:17:49', '0000-00-00 00:00:00'),
(79, 'admin/user.tx/update', '更改提现状态', 1, 0, 1, '', '2017-02-15 13:18:23', '0000-00-00 00:00:00'),
(80, 'admin/shop.trade/index', '财务明细', 1, 0, 1, '', '2017-02-15 13:47:10', '0000-00-00 00:00:00'),
(81, 'admin/user.recharge/index', '充值记录', 1, 0, 1, '', '2017-02-15 14:28:04', '0000-00-00 00:00:00'),
(82, 'admin/config.mail/index', '邮件配置', 1, 0, 1, '', '2017-02-16 01:26:09', '0000-00-00 00:00:00'),
(83, 'admin/config.sms/index', '短信配置', 1, 0, 1, '', '2017-02-16 02:22:50', '0000-00-00 00:00:00'),
(84, 'admin/location.country/index', '地址设置', 1, 0, 1, '', '2017-02-16 02:29:01', '0000-00-00 00:00:00'),
(85, 'admin/location.country/add', '新增修改国家', 1, 0, 1, '', '2017-02-16 03:13:01', '0000-00-00 00:00:00'),
(86, 'admin/location.country/update', '更新国家状态', 1, 0, 1, '', '2017-02-16 03:13:26', '0000-00-00 00:00:00'),
(87, 'admin/location.province/index', '省份列表', 1, 0, 1, '', '2017-02-16 03:24:34', '0000-00-00 00:00:00'),
(88, 'admin/location.province/add', '新增修改省份', 1, 0, 1, '', '2017-02-16 03:24:58', '0000-00-00 00:00:00'),
(89, 'admin/location.province/update', '更新省份状态', 1, 0, 1, '', '2017-02-16 03:25:33', '0000-00-00 00:00:00'),
(90, 'admin/location.city/index', '城市列表', 1, 0, 1, '', '2017-02-16 06:13:05', '0000-00-00 00:00:00'),
(92, 'admin/location.city/add', '新增修改城市', 1, 0, 1, '', '2017-02-16 06:13:14', '0000-00-00 00:00:00'),
(93, 'admin/location.city/update', '更新城市状态', 1, 0, 1, '', '2017-02-16 06:13:20', '0000-00-00 00:00:00'),
(94, 'admin/location.district/index', '区域列表', 1, 0, 1, '', '2017-02-16 06:32:17', '0000-00-00 00:00:00'),
(95, 'admin/location.district/add', '新增修改区域', 1, 0, 1, '', '2017-02-16 06:32:20', '0000-00-00 00:00:00'),
(96, 'admin/location.district/update', '更新区域状态', 1, 0, 1, '', '2017-02-16 06:32:24', '0000-00-00 00:00:00'),
(97, 'admin/tpl.mail/index', '邮件模版列表', 1, 0, 1, '', '2017-02-16 07:05:55', '0000-00-00 00:00:00'),
(98, 'admin/tpl.mail/add', '新增修改邮件模版', 1, 0, 1, '', '2017-02-16 07:05:58', '0000-00-00 00:00:00'),
(99, 'admin/tpl.mail/update', '更新邮件模版状态', 1, 0, 1, '', '2017-02-16 07:06:02', '0000-00-00 00:00:00'),
(100, 'admin/tpl.sms/index', '短信模版列表', 1, 0, 1, '', '2017-02-16 07:06:06', '0000-00-00 00:00:00'),
(101, 'admin/tpl.sms/add', '新增修改短信模版', 1, 0, 1, '', '2017-02-16 07:30:03', '0000-00-00 00:00:00'),
(102, 'admin/tpl.sms/update', '开启关闭短信模版', 1, 0, 1, '', '2017-02-16 07:30:08', '0000-00-00 00:00:00'),
(103, 'admin/wx.tplmsg/index', '模版消息列表', 1, 0, 1, '', '2017-02-16 07:30:13', '0000-00-00 00:00:00'),
(104, 'admin/wx.tplmsg/add', '新增编辑模版消息', 1, 0, 1, '', '2017-02-16 10:43:55', '0000-00-00 00:00:00'),
(106, 'admin/wx.tplmsg/update', '开启关闭模版消息', 1, 0, 1, '', '2017-02-16 10:44:03', '0000-00-00 00:00:00'),
(107, 'admin/wx.kefu/index', '多客服设置', 1, 0, 1, '', '2017-02-16 10:44:09', '0000-00-00 00:00:00'),
(108, 'admin/wx.print/index', '微信打印机设置', 1, 0, 1, '', '2017-02-17 01:31:57', '0000-00-00 00:00:00'),
(109, 'admin/article.category/update', '更改文章分类状态', 1, 0, 1, '', '2017-02-17 02:00:42', '0000-00-00 00:00:00'),
(110, 'admin/article.index/update', '更改文章状态', 1, 0, 1, '', '2017-02-17 02:12:54', '0000-00-00 00:00:00'),
(112, 'admin/ads.position/index', '广告位置', 1, 0, 1, '', '2017-02-17 03:11:26', '0000-00-00 00:00:00'),
(113, 'admin/ads.position/update', '开启关闭广告位置', 1, 0, 1, '', '2017-02-17 03:23:45', '0000-00-00 00:00:00'),
(114, 'admin/ads.index/index', '广告列表', 1, 0, 1, '', '2017-02-17 03:31:30', '0000-00-00 00:00:00'),
(115, 'admin/ads.index/add', '新增修改广告', 1, 0, 1, '', '2017-02-17 03:34:48', '0000-00-00 00:00:00'),
(116, 'admin/ads.index/update', '开启关闭广告', 1, 0, 1, '', '2017-02-17 03:35:10', '0000-00-00 00:00:00'),
(117, 'admin/user.index/export', '导出用户', 1, 0, 1, '', '2017-02-17 06:28:31', '0000-00-00 00:00:00'),
(118, 'admin/shop.trade/export', '导出财务明细', 1, 0, 1, '', '2017-02-17 08:35:20', '0000-00-00 00:00:00'),
(119, 'admin/shop.order.index/export', '导出全部订单', 1, 0, 1, '', '2017-02-17 10:14:50', '0000-00-00 00:00:00'),
(120, 'admin/shop.product.index/export', '导出全部商品', 1, 0, 1, '', '2017-02-18 01:11:09', '0000-00-00 00:00:00'),
(121, 'admin/tpl.sms/send', '发送测试短信', 1, 0, 1, '', '2017-02-18 09:08:55', '0000-00-00 00:00:00'),
(122, 'admin/tpl.mail/send', '发送测试邮件', 1, 0, 1, '', '2017-02-18 09:24:27', '0000-00-00 00:00:00'),
(123, 'admin/shop.product.index/sku', '商品sku管理', 1, 0, 1, '', '2017-02-22 14:11:44', '0000-00-00 00:00:00'),
(124, 'admin/addons/index', '插件管理', 1, 0, 1, '', '2017-02-27 01:53:49', '0000-00-00 00:00:00'),
(125, 'admin/addons/shop', '应用商店', 1, 0, 1, '', '2017-03-01 10:09:35', '0000-00-00 00:00:00'),
(126, 'admin/addons/getFileDownload', '下载插件', 1, 0, 1, '', '2017-03-01 10:29:52', '0000-00-00 00:00:00'),
(127, 'admin/addons/compare', '解压插件', 1, 0, 1, '', '2017-03-01 10:30:32', '0000-00-00 00:00:00'),
(128, 'admin/tpl.fee/index', '费用模版', 1, 0, 1, NULL, '2017-03-13 05:46:01', '0000-00-00 00:00:00'),
(129, 'admin/tpl.fee/add', '新增修改费用模版', 1, 0, 1, NULL, '2017-03-13 05:51:57', '0000-00-00 00:00:00'),
(130, 'admin/tpl.fee/update', '更新费用模版', 1, 0, 1, NULL, '2017-03-13 05:53:08', '0000-00-00 00:00:00'),
(131, 'admin/shop.feedback/index', '反馈管理列表', 1, 0, 1, NULL, '2017-03-14 01:06:32', '0000-00-00 00:00:00'),
(132, 'admin/ads.position/add', '新增修改广告位置', 1, 0, 1, NULL, '2017-03-15 07:45:52', '0000-00-00 00:00:00'),
(133, 'admin/base/update', '系统更新', 1, 0, 1, NULL, '2017-03-20 02:57:30', '0000-00-00 00:00:00'),
(134, 'admin/wx.reply/del', '删除自定义回复', 1, 0, 1, NULL, '2017-03-21 02:57:30', '0000-00-00 00:00:00'),
(135, 'admin/wx.robot/index', '图灵机器人', 1, 0, 1, NULL, '2017-03-21 02:57:30', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `config`
--
CREATE TABLE `config` (
`id` int(10) unsigned NOT NULL,
`name` text COMMENT '商城名称',
`title` text COMMENT '商城标题',
`description` text COMMENT '商城描述',
`help` text COMMENT '使用帮助',
`about` text COMMENT '关于我们',
`keywords` text COMMENT '商城关键词',
`welcome` text COMMENT '欢迎信息',
`logo_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城Logo',
`qq` varchar(255) DEFAULT NULL COMMENT '客服QQ',
`tel` text COMMENT '客服电话',
`mail` text COMMENT '客服邮箱',
`tx_fee` float NOT NULL DEFAULT '0' COMMENT '提现手续费',
`theme` text COMMENT '模版主题',
`debug` int(1) NOT NULL DEFAULT '0' COMMENT '调试模式',
`status` int(11) NOT NULL DEFAULT '1' COMMENT '1:开启0:关闭',
`shop_update` int(1) NOT NULL DEFAULT '1' COMMENT '商城升级',
`closed_reason` text COMMENT '关站原因',
`tongji_code` text COMMENT '统计代码',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `config`
--
INSERT INTO `config` (`id`, `name`, `title`, `description`, `help`, `about`, `keywords`, `welcome`, `logo_id`, `qq`, `tel`, `mail`, `tx_fee`, `theme`, `debug`, `status`, `shop_update`, `closed_reason`, `tongji_code`, `created_at`, `updated_at`) VALUES
(1, 'wemall商城', '单用户微商城', '111111', '这里是使用帮助', '', 'wemall', 'wemall欢迎您!\r\n111', 105, '1604583867', '18538753627', '1604583867@qq.com', 0.01, 'default', 0, 1, 1, '商城暂时关闭。。。。', '11111', '2017-01-10 13:30:26', '2017-05-27 01:45:46');
-- --------------------------------------------------------
--
-- 表的结构 `delivery`
--
CREATE TABLE `delivery` (
`id` int(10) unsigned NOT NULL,
`name` text,
`sub` text,
`status` int(11) DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `delivery`
--
INSERT INTO `delivery` (`id`, `name`, `sub`, `status`, `created_at`, `updated_at`) VALUES
(1, '顺丰快递', '顺丰快递介绍', 0, '2017-02-15 01:14:39', '2017-02-15 01:48:56'),
(2, '中通快递', '', 1, '2017-01-02 19:04:50', '2017-02-02 11:09:02'),
(3, '顺丰速递', '顺丰速递', 0, '2017-01-05 19:59:10', '2017-01-28 10:53:06'),
(4, '顺丰速递', '顺丰速递介绍', 1, '2017-01-05 19:59:28', '2017-02-09 23:24:22'),
(5, '天天快递', '天天快递', 0, '2017-01-07 00:24:51', '2017-02-13 00:54:36'),
(6, '申通速递', '申通速递', 0, '2017-01-12 22:23:46', '2017-02-11 15:45:44'),
(7, '顺丰快递', '顺丰快递', 0, '2017-01-12 22:55:19', '2017-02-01 02:49:04'),
(8, '同城快递', '11111111111111', 0, '2017-03-02 06:46:55', '2017-03-02 06:46:55');
-- --------------------------------------------------------
--
-- 表的结构 `feedback`
--
CREATE TABLE `feedback` (
`id` int(10) unsigned NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`value` text,
`remark` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `feedback`
--
INSERT INTO `feedback` (`id`, `user_id`, `value`, `remark`, `created_at`, `updated_at`) VALUES
(1, 1, '很好', NULL, '2016-12-21 04:13:36', '2016-12-21 04:13:36');
-- --------------------------------------------------------
--
-- 表的结构 `fee_tpl`
--
CREATE TABLE `fee_tpl` (
`id` int(11) unsigned NOT NULL,
`name` text,
`value` float NOT NULL DEFAULT '0' COMMENT '模版费用',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '1:开启0:关闭',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `fee_tpl`
--
INSERT INTO `fee_tpl` (`id`, `name`, `value`, `status`, `created_at`, `updated_at`) VALUES
(1, '跑腿费', 5, 1, '2017-03-13 05:42:46', '2017-03-13 06:04:31'),
(2, '111', 1, 1, '2017-03-14 02:59:43', '2017-03-14 02:59:43');
-- --------------------------------------------------------
--
-- 表的结构 `file`
--
CREATE TABLE `file` (
`id` int(10) unsigned NOT NULL,
`name` text,
`ext` text,
`type` text,
`savename` text,
`savepath` text,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `file`
--
INSERT INTO `file` (`id`, `name`, `ext`, `type`, `savename`, `savepath`, `time`) VALUES
(1, '测试图片', 'jpg', 'image/jpeg', 'noimage.gif', 'img/', '2015-10-07 04:24:18'),
(2, '5615e26f54d75.jpg', 'jpg', 'image/jpeg', '563c4f4336719.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(3, '5615ea4fd93f4.jpg', 'jpg', 'image/jpeg', '563c4f433762a.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(4, '5615eaa90c582.jpg', 'jpg', 'image/jpeg', '563c4f4337c28.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(5, '5615eaa90d34c.jpg', 'jpg', 'image/jpeg', '563c4f4338996.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(6, '5615eaa90dfad.jpg', 'jpg', 'image/jpeg', '563c4f4339b2d.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(7, '5615eaa90e804.jpg', 'jpg', 'image/jpeg', '563c4f433ab12.jpg', '2015-11-06/', '2015-11-06 06:57:07'),
(9, '1-370x370-1420.jpg', 'jpg', 'image/jpeg', '563c52adac85f.jpg', '2015-11-06/', '2015-11-06 07:11:41'),
(10, '1-370x370-5844-4KHF8KDU.jpg', 'jpg', 'image/jpeg', '563c52bb4b7eb.jpg', '2015-11-06/', '2015-11-06 07:11:55'),
(11, '1-370x370-5985-9KPFBWR1.jpg', 'jpg', 'image/jpeg', '563c52bb4bced.jpg', '2015-11-06/', '2015-11-06 07:11:55'),
(12, '1-370x370-6486-BXPDCPCU.jpg', 'jpg', 'image/jpeg', '563c540523c16.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(13, '1-370x370-5942-KCHKPX9K.jpg', 'jpg', 'image/jpeg', '563c540524b9c.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(14, '1-370x370-4394-3YU37TSK.jpg', 'jpg', 'image/jpeg', '563c54052539a.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(15, '1-370x370-3265-PU41F9AB.jpg', 'jpg', 'image/jpeg', '563c540525aca.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(16, '1-370x370-4854-4TC46UPX.jpg', 'jpg', 'image/jpeg', '563c5405260d0.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(17, '1-370x370-6423-YSDU6WA6.jpg', 'jpg', 'image/jpeg', '563c540526487.jpg', '2015-11-06/', '2015-11-06 07:17:25'),
(18, '55fa7cf5d3c70.jpg', 'jpg', 'image/jpeg', '563c61f936dbd.jpg', '2015-11-06/', '2015-11-06 08:16:57'),
(19, '55fa79e11089e.png', 'png', 'image/jpeg', '563c61f937aff.png', '2015-11-06/', '2015-11-06 08:16:57'),
(20, '55fa76b46c708.png', 'png', 'image/jpeg', '563c61f938112.png', '2015-11-06/', '2015-11-06 08:16:57'),
(21, '55fa763dbe297.png', 'png', 'image/jpeg', '563c61f9385ba.png', '2015-11-06/', '2015-11-06 08:16:57'),
(22, '55fa76266b041.png', 'png', 'image/jpeg', '563c61f938931.png', '2015-11-06/', '2015-11-06 08:16:57'),
(23, '55fa759ae7a02.png', 'png', 'image/jpeg', '563c61f938cac.png', '2015-11-06/', '2015-11-06 08:16:57'),
(24, '55fa73efc80f0.png', 'png', 'image/jpeg', '563c61f939289.png', '2015-11-06/', '2015-11-06 08:16:57'),
(25, '55fa737d985f2.png', 'png', 'image/jpeg', '563c61f9395ed.png', '2015-11-06/', '2015-11-06 08:16:57'),
(26, '563885a8a6b84.jpg', 'jpg', 'image/jpeg', '563c61f93985d.jpg', '2015-11-06/', '2015-11-06 08:16:57'),
(27, '1417595621584.jpg', 'jpg', 'image/jpeg', '563c68eff3721.jpg', '2015-11-06/', '2015-11-06 08:46:40'),
(28, '1417597271905.jpg', 'jpg', 'image/jpeg', '563c695de2403.jpg', '2015-11-06/', '2015-11-06 08:48:29'),
(29, '1434268044104.jpg', 'jpg', 'image/jpeg', '563c695de2cbe.jpg', '2015-11-06/', '2015-11-06 08:48:29'),
(66, '56efb341Nda416fd1.jpg', '', 'image/jpeg', '5632a9014bc508accf89a0a64f3b4aa5.jpg', '20170117/', '2017-01-17 07:15:38'),
(67, 'bg_1.jpg', '', 'image/jpeg', 'c81134e3c2458f8df014b3591abf07ca.jpg', '20170208/', '2017-02-08 09:21:08'),
(75, 'd59b165a-fd97-11e6-9041-38c986416005.png', 'png', 'image/jpeg', 'd59b165a-fd97-11e6-9041-38c986416005.png', 'avatar/', '2017-02-28 09:25:24'),
(76, '185dce92-fd98-11e6-bf91-38c986416005.png', 'png', 'image/jpeg', '185dce92-fd98-11e6-bf91-38c986416005.png', 'avatar/', '2017-02-28 09:27:16'),
(77, '4c1d5f2c-fd98-11e6-96a1-38c986416005.png', 'png', 'image/jpeg', '4c1d5f2c-fd98-11e6-96a1-38c986416005.png', 'avatar/', '2017-02-28 09:28:45'),
(78, '9b3bbba8-fd98-11e6-8fc2-38c986416005.png', 'png', 'image/jpeg', '9b3bbba8-fd98-11e6-8fc2-38c986416005.png', 'avatar/', '2017-02-28 09:30:56'),
(79, '315edd9e-fe21-11e6-80e5-38c986416005.png', 'png', 'image/jpeg', '315edd9e-fe21-11e6-80e5-38c986416005.png', 'avatar/', '2017-03-01 01:48:40'),
(80, '01a65d55c313156ac7253f363ff64d.jpg', '', 'image/jpeg', '5447948bab8014fb7c0042241c0e4f57.jpg', '20170301/', '2017-03-01 09:12:17'),
(81, '13R58PICFI9_1024.jpg', '', 'image/jpeg', '097fd1fda978d094f9904af0608f221d.jpg', '20170301/', '2017-03-01 09:12:24'),
(82, '36B58PICNjS_1024.jpg', '', 'image/jpeg', '84a482526055161c8f0bbd5adb187cea.jpg', '20170301/', '2017-03-01 09:12:28'),
(83, '58dd09156201b1902851409b3e83cd24.jpg', '', 'image/jpeg', 'fee7be02ebd9ff2230d27e5f761d0f84.jpg', '20170301/', '2017-03-01 09:12:33'),
(84, '0179ae57a457600000018c1ba38fc9.jpg', '', 'image/jpeg', '0a95e34df473253874107f3c24a750de.jpg', '20170301/', '2017-03-01 09:12:37'),
(85, '8326cffc1e178a82a8cfbbfdf603738da877e8f8.jpg', '', 'image/jpeg', 'ec63d8efbfd68e95e8511b23f14d0946.jpg', '20170301/', '2017-03-01 09:12:50'),
(86, 'bf76bdfbcd6ef583ba30b161e85e57dc.jpg', '', 'image/jpeg', '20bbc27d4764d0d9563b64e8759e648e.jpg', '20170301/', '2017-03-01 09:12:56'),
(87, 'u=176602520,3100091901&fm=23&gp=0.jpg', '', 'image/jpeg', '4c9fbc348b5f3523cb9f036d0fe082e1.jpg', '20170301/', '2017-03-01 09:13:00'),
(88, 'u=2457965475,4177702945&fm=23&gp=0.jpg', '', 'image/jpeg', '67d75c663a18fd76260a0ffa7b0478a7.jpg', '20170301/', '2017-03-01 09:13:04'),
(89, '4d6d5a0e-fe5f-11e6-b32a-38c986416005.png', 'png', 'image/jpeg', '4d6d5a0e-fe5f-11e6-b32a-38c986416005.png', 'avatar/', '2017-03-01 09:13:20'),
(90, '8326cffc1e178a82a8cfbbfdf603738da877e8f8.jpg', '', 'image/jpeg', 'dd6186b0f03df315719dd86b5ddeff44.jpg', '20170301/', '2017-03-01 09:25:56'),
(91, '9777035_165424741000_2.jpg', '', 'image/jpeg', '1868123d999a98b3baf9366d003e0b0f.jpg', '20170301/', '2017-03-01 09:26:01'),
(92, '0_xuemanni_6513_20141201142805.jpg', '', 'image/jpeg', '8733de38978e3aeda8d602d83fad15a0.jpg', '20170301/', '2017-03-01 09:26:15'),
(93, '013a2c57a4554a0000018c1bf33dc2.jpg', '', 'image/jpeg', '500ab48dd025e0d0c9e1403c89d15f3a.jpg', '20170301/', '2017-03-01 09:26:22'),
(94, 'u=2457965475,4177702945&fm=23&gp=0.jpg', '', 'image/jpeg', '01efc214d75aecd27f013f7b8a875701.jpg', '20170301/', '2017-03-01 09:26:34'),
(95, '58b5146dNad045c4c.jpg', '', 'image/jpeg', '94e731c90910a50acea3866a476e9688.jpg', '20170301/', '2017-03-01 09:40:34'),
(96, '4_rrgy.jpg', '', 'image/jpeg', 'edcc54a680e487ff1dd558609751626a.jpg', '20170301/', '2017-03-01 09:43:37'),
(97, '750_yzht-360_570x273_90.jpg', '', 'image/jpeg', '73b89408e0c0e7f88b704388b179bf86.jpg', '20170301/', '2017-03-01 09:45:34'),
(98, '1487647018790_570x273_90.jpg', '', 'image/jpeg', 'dd64da07f97009638a07f0194b4f4712.jpg', '20170301/', '2017-03-01 09:45:47'),
(99, '1487670798030_570x273_90.jpg', '', 'image/jpeg', 'dc27aef302cff30e0630d673ed528009.jpg', '20170301/', '2017-03-01 09:46:26'),
(100, '1487661952019_570x273_90.jpg', '', 'image/jpeg', '0a9e06f5c08b5ee0129167980de3f721.jpg', '20170301/', '2017-03-01 09:47:09'),
(101, '8316119c-feef-11e6-8cc9-38c986416005.png', 'png', 'image/jpeg', '8316119c-feef-11e6-8cc9-38c986416005.png', 'avatar/', '2017-03-02 02:25:41'),
(102, '37acf652-fef0-11e6-985c-38c986416005.png', 'png', 'image/jpeg', '37acf652-fef0-11e6-985c-38c986416005.png', 'avatar/', '2017-03-02 02:30:36'),
(103, '8cfc870c-fef1-11e6-9146-38c986416005.png', 'png', 'image/jpeg', '8cfc870c-fef1-11e6-9146-38c986416005.png', 'avatar/', '2017-03-02 02:40:14'),
(104, 'd2b2275ac43cc8bce03760c162d23724ca67b803122af-qLuXr8_fw658.jpeg', '', 'image/jpeg', 'a02795d30768a851b4a90554698ce2d2.jpeg', '20170302/', '2017-03-02 07:15:26'),
(105, 'wemall.png', '', 'image/png', '718dd9bbdbd36a7f8f2654dcfebb03cb.png', '20170302/', '2017-03-02 07:15:53'),
(106, '0213.jpg', '', 'image/jpeg', '8c99ecd017cb478f5f3400a76eb729ea.jpg', '20170302/', '2017-03-02 08:27:57'),
(107, '5_02135.jpg', '', 'image/jpeg', '96b2251cecc3cc0731b8fd585b2ef104.jpg', '20170302/', '2017-03-02 08:30:04'),
(108, '1_022702.jpg', '', 'image/jpeg', '5e9ba5046a0b588bdfafa1ffd59add44.jpg', '20170302/', '2017-03-02 08:31:40'),
(109, 'longchamp_crossbody_bags_roseau_sakura_1016873A26_0.png', '', 'image/png', '280e56d761a25c625257891807ee2256.png', '20170302/', '2017-03-02 09:23:28'),
(110, '58b56445N7a3876dc.jpeg', '', 'image/jpeg', 'b8eef843324e0ba721c3781b4924dfd9.jpeg', '20170302/', '2017-03-02 09:55:32'),
(111, '58abb2dbN2d71963d.jpg', '', 'image/jpeg', '5b6ab452593c5e7ce80a9245866be5d8.jpg', '20170302/', '2017-03-02 10:26:26'),
(112, '58abb1eaN847f21e1.jpg', '', 'image/jpeg', '0f9793f82399770d55ca184f8a6782cb.jpg', '20170302/', '2017-03-02 10:27:54'),
(113, '36388a12-00ac-11e7-aa6d-38c986416005.png', 'png', 'image/jpeg', '36388a12-00ac-11e7-aa6d-38c986416005.png', 'avatar/', '2017-03-04 07:28:51'),
(114, 'c7fdca30-00ba-11e7-9859-38c986416005.png', 'png', 'image/jpeg', 'c7fdca30-00ba-11e7-9859-38c986416005.png', 'avatar/', '2017-03-04 09:13:09'),
(115, 'c7fdcf94-00ba-11e7-b37a-38c986416005.png', 'png', 'image/jpeg', 'c7fdcf94-00ba-11e7-b37a-38c986416005.png', 'avatar/', '2017-03-04 09:13:09'),
(116, 'c7fdca62-00ba-11e7-bbfe-38c986416005.png', 'png', 'image/jpeg', 'c7fdca62-00ba-11e7-bbfe-38c986416005.png', 'avatar/', '2017-03-04 09:13:09'),
(117, 'TB25L4.c3SI.eBjy1XcXXc1jXXa_!!2597188887.jpg', '', 'image/jpeg', 'ee93143bfc28e9eaceaa525b812ddf53.jpg', '20170304/', '2017-03-04 09:31:01'),
(118, 'TB2jZYwa5pnpuFjSZFIXXXh2VXa_!!2041961913.jpg_400x400.jpg', '', 'image/jpeg', '1728f7e25c847a2cfd09fa3c6bd7aa88.jpg', '20170304/', '2017-03-04 09:36:02'),
(119, 'c3ef5450-031b-11e7-b19d-38c986416005.png', 'png', 'image/jpeg', 'c3ef5450-031b-11e7-b19d-38c986416005.png', 'avatar/', '2017-03-07 09:52:42'),
(120, 'c1d27f3e-03a8-11e7-a6f3-38c986416005.png', 'png', 'image/jpeg', 'c1d27f3e-03a8-11e7-a6f3-38c986416005.png', 'avatar/', '2017-03-08 02:41:45'),
(121, '840ad852-0468-11e7-b144-38c986416005.png', 'png', 'image/jpeg', '840ad852-0468-11e7-b144-38c986416005.png', 'avatar/', '2017-03-09 01:34:20'),
(122, '89614146-07ca-11e7-8da9-38c986416005.png', 'png', 'image/jpeg', '89614146-07ca-11e7-8da9-38c986416005.png', 'avatar/', '2017-03-13 08:53:37'),
(123, '611cbbf4-0863-11e7-8c5a-38c986416005.png', 'png', 'image/jpeg', '611cbbf4-0863-11e7-8c5a-38c986416005.png', 'avatar/', '2017-03-14 03:07:43'),
(124, '748ed74e-0863-11e7-b553-38c986416005.png', 'png', 'image/jpeg', '748ed74e-0863-11e7-b553-38c986416005.png', 'avatar/', '2017-03-14 03:08:11'),
(125, 'a55102f8-0863-11e7-ad11-38c986416005.png', 'png', 'image/jpeg', 'a55102f8-0863-11e7-ad11-38c986416005.png', 'avatar/', '2017-03-14 03:09:32'),
(126, '452cd0da-08a1-11e7-8be7-38c986416005.png', 'png', 'image/jpeg', '452cd0da-08a1-11e7-8be7-38c986416005.png', 'avatar/', '2017-03-14 10:30:41'),
(127, '47281a70-08a1-11e7-ad7e-38c986416005.png', 'png', 'image/jpeg', '47281a70-08a1-11e7-ad7e-38c986416005.png', 'avatar/', '2017-03-14 10:30:43'),
(128, '4797f6a6-08a1-11e7-b16c-38c986416005.png', 'png', 'image/jpeg', '4797f6a6-08a1-11e7-b16c-38c986416005.png', 'avatar/', '2017-03-14 10:30:44'),
(129, '47ef3dbc-08a1-11e7-b740-38c986416005.png', 'png', 'image/jpeg', '47ef3dbc-08a1-11e7-b740-38c986416005.png', 'avatar/', '2017-03-14 10:30:44'),
(130, '48a08860-08a1-11e7-80e9-38c986416005.png', 'png', 'image/jpeg', '48a08860-08a1-11e7-80e9-38c986416005.png', 'avatar/', '2017-03-14 10:30:46'),
(131, 'd7d435f8-0929-11e7-82db-38c986416005.png', 'png', 'image/jpeg', 'd7d435f8-0929-11e7-82db-38c986416005.png', 'avatar/', '2017-03-15 02:48:19'),
(132, 'e78a304c-0929-11e7-8730-38c986416005.png', 'png', 'image/jpeg', 'e78a304c-0929-11e7-8730-38c986416005.png', 'avatar/', '2017-03-15 02:48:44'),
(133, 'f089bffa-0929-11e7-9cdf-38c986416005.png', 'png', 'image/jpeg', 'f089bffa-0929-11e7-9cdf-38c986416005.png', 'avatar/', '2017-03-15 02:48:59'),
(134, 'f3c70a2e-0929-11e7-a7af-38c986416005.png', 'png', 'image/jpeg', 'f3c70a2e-0929-11e7-a7af-38c986416005.png', 'avatar/', '2017-03-15 02:49:04'),
(135, '0bc4b288-092b-11e7-8a93-38c986416005.png', 'png', 'image/jpeg', '0bc4b288-092b-11e7-8a93-38c986416005.png', 'avatar/', '2017-03-15 02:56:59');
-- --------------------------------------------------------
--
-- 表的结构 `location`
--
CREATE TABLE `location` (
`id` smallint(5) unsigned NOT NULL,
`pid` smallint(5) NOT NULL DEFAULT '0',
`name` varchar(120) DEFAULT NULL,
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:国家,1:省份,2:市,3:区',
`status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `location`
--
INSERT INTO `location` (`id`, `pid`, `name`, `type`, `status`) VALUES
(1, 0, '中国', 0, 0),
(2, 1, '河南', 1, 0),
(3, 2, '郑州', 2, 0),
(4, 2, '开封', 2, 0),
(5, 3, '金水区', 3, 0);
-- --------------------------------------------------------
--
-- 表的结构 `mail`
--
CREATE TABLE `mail` (
`id` int(11) unsigned NOT NULL,
`host` text COMMENT '服务器地址',
`port` int(11) DEFAULT NULL COMMENT '服务器端口',
`secure` double NOT NULL DEFAULT '0' COMMENT '1:加密0:不加密',
`replyTo` text COMMENT '回信地址',
`user` text COMMENT '发送邮箱',
`pass` text COMMENT '授权码,通过QQ获取',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- 转存表中的数据 `mail`
--
INSERT INTO `mail` (`id`, `host`, `port`, `secure`, `replyTo`, `user`, `pass`, `created_at`, `updated_at`) VALUES
(1, 'smtpdm.aliyun.com', 465, 1, 'koahub@163.com', 'mail@notice.koahub.com', '786699892smtp', '2017-02-16 01:52:41', '2017-03-02 06:48:29');
-- --------------------------------------------------------
--
-- 表的结构 `mail_tpl`
--
CREATE TABLE `mail_tpl` (
`id` int(11) unsigned NOT NULL,
`type` text COMMENT '类型',
`name` text COMMENT '模版名',
`content` text COMMENT '内容',
`status` int(11) NOT NULL DEFAULT '1' COMMENT '状态1:开启0:关闭',
`mail` text COMMENT '测试发送邮箱',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `mail_tpl`
--
INSERT INTO `mail_tpl` (`id`, `type`, `name`, `content`, `status`, `mail`, `created_at`, `updated_at`) VALUES
(1, 'register', '注册模版', '<p>您好,欢迎您注册wemallshop微信商城,您的验证码是:$code</p>', 1, '1604583867@qq.com', '0000-00-00 00:00:00', '2017-02-18 09:38:44');
-- --------------------------------------------------------
--
-- 表的结构 `oauth_applet`
--
CREATE TABLE `oauth_applet` (
`id` int(11) unsigned NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`openid` text COMMENT '用户的标识,对当前小程序唯一',
`nickname` text COMMENT '用户的昵称',
`gender` int(11) NOT NULL DEFAULT '0' COMMENT '1:男2:女0:未知',
`city` text COMMENT '用户所在城市',
`province` text COMMENT '用户所在省份',
`language` text COMMENT '语言',
`avatarUrl` text COMMENT '用户头像',
`unionid` text COMMENT '统一用户',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='微信小程序登陆';
--
-- 转存表中的数据 `oauth_applet`
--
INSERT INTO `oauth_applet` (`id`, `user_id`, `openid`, `nickname`, `gender`, `city`, `province`, `language`, `avatarUrl`, `unionid`, `created_at`, `updated_at`) VALUES
(1, 1, '', '', 0, '', '', '', '', '', '2017-03-13 13:24:02', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `oauth_wx`
--
CREATE TABLE `oauth_wx` (
`id` int(11) unsigned NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`openid` text COMMENT '用户的标识,对当前公众号唯一',
`nickname` text COMMENT '用户的昵称',
`sex` int(11) NOT NULL DEFAULT '0' COMMENT '1:男2:女0:未知',
`city` text COMMENT '用户所在城市',
`country` text COMMENT '用户所在国家',
`province` text COMMENT '用户所在省份',
`language` text COMMENT '语言',
`headimgurl` text COMMENT '用户头像',
`subscribe_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '关注时间',
`unionid` text COMMENT '统一用户',
`subscribe` int(11) NOT NULL DEFAULT '1' COMMENT '1:关注0:取消',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='微信登陆';
--
-- 转存表中的数据 `oauth_wx`
--
INSERT INTO `oauth_wx` (`id`, `user_id`, `openid`, `nickname`, `sex`, `city`, `country`, `province`, `language`, `headimgurl`, `subscribe_time`, `unionid`, `subscribe`, `created_at`, `updated_at`) VALUES
(1, 1, '', '', 0, '', '', '', '', '', '0000-00-00 00:00:00', '', 0, '2017-03-13 13:24:02', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `order`
--
CREATE TABLE `order` (
`id` int(10) unsigned NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
`delivery_id` int(11) NOT NULL DEFAULT '0' COMMENT '快递方式',
`delivery_code` text COMMENT '快递单号',
`delivery_time` text,
`orderid` text COMMENT '订单号',
`totalprice` double(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
`totalprice_org` float NOT NULL DEFAULT '0' COMMENT '原价',
`payment_id` int(11) NOT NULL DEFAULT '0' COMMENT '付款方式',
`pay_status` int(11) NOT NULL DEFAULT '0' COMMENT '1:已支付0:未支付',
`coupon` text COMMENT '优惠券',
`freight` float NOT NULL DEFAULT '0',
`discount` int(11) NOT NULL DEFAULT '0',
`totalscore` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
`employee_id` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0' COMMENT '1:到店自提0:送货上门',
`stores` text COMMENT '自提门店',
`remark` text COMMENT '备注',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '0:待发货,1:已发货,2:已完成,3:已评价, -1:已关闭,-2:待退款,-3:已退款',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `order`
--
INSERT INTO `order` (`id`, `user_id`, `delivery_id`, `delivery_code`, `delivery_time`, `orderid`, `totalprice`, `totalprice_org`, `payment_id`, `pay_status`, `coupon`, `freight`, `discount`, `totalscore`, `employee_id`, `type`, `stores`, `remark`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 0, '', '10:30-11:30', '1703131545409', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '', NULL, -1, '2017-03-03 09:44:40', '2017-03-03 09:44:40'),
(2, 1, 0, '', '10:30-11:30', '1703030547309', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":"18538553590"}', NULL, -1, '2017-03-03 09:47:30', '2017-03-03 09:47:30'),
(3, 1, 0, '', '10:30-11:30', '1703030604472', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:04:47', '2017-03-03 10:04:47'),
(4, 1, 0, '', '10:30-11:30', '1703030618553', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:18:55', '2017-03-03 10:18:55'),
(5, 1, 0, '', '10:30-11:30', '1703030622401', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:22:39', '2017-03-03 10:22:39'),
(6, 1, 0, '', '10:30-11:30', '1703030627455', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:27:45', '2017-03-03 10:27:45'),
(7, 1, 0, '', '10:30-11:30', '1703030631071', 100.00, 0, 4, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:31:07', '2017-03-03 10:31:07'),
(8, 1, 0, '', '10:30-11:30', '1703030631505', 0.00, 0, 4, 1, '', 0, 0, 0, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:31:50', '2017-03-03 10:31:50'),
(9, 1, 0, '', '10:30-11:30', '1703030638338', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:38:33', '2017-03-03 10:38:33'),
(10, 1, 0, '', '10:30-11:30', '1703030640178', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:40:17', '2017-03-03 10:40:17'),
(11, 1, 0, '', '10:30-11:30', '1703030641204', 100.00, 0, 4, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:41:20', '2017-03-03 10:41:20'),
(12, 1, 0, '', '10:30-11:30', '1703030641572', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:41:57', '2017-03-03 10:41:57'),
(13, 1, 0, '', '10:30-11:30', '1703030643257', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:43:25', '2017-03-03 10:43:25'),
(14, 1, 0, '', '10:30-11:30', '1703030645476', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:45:47', '2017-03-03 10:45:47'),
(15, 1, 0, '', '10:30-11:30', '1703030648109', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:48:10', '2017-03-03 10:48:10'),
(16, 1, 0, '', '10:30-11:30', '1703030652376', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:52:36', '2017-03-03 10:52:36'),
(17, 1, 0, '', '10:30-11:30', '1703030654262', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:54:26', '2017-03-03 10:54:26'),
(18, 1, 0, '', '10:30-11:30', '1703030657114', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 10:57:10', '2017-03-03 10:57:10'),
(19, 1, 0, '', '10:30-11:30', '1703030701407', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, 0, '2017-03-03 11:01:40', '2017-03-03 11:01:40'),
(20, 1, 0, '', '10:30-11:30', '1703030702585', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, -1, '2017-03-03 11:02:58', '2017-03-03 11:02:58'),
(21, 1, 0, '', '10:30-11:30', '1703030706282', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 1, '{"address":0,"phone":""}', NULL, -1, '2017-03-03 11:06:26', '2017-03-03 11:06:26'),
(22, 1, 0, '', '10:30-11:30', '1703030710015', 800.00, 0, 1, 0, '', 0, 0, 88, 0, 1, '{"address":0,"phone":""}', NULL, -1, '2017-03-03 11:10:01', '2017-03-03 11:10:01'),
(23, 1, 0, '', '10:30-11:30', '1703030718412', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":""}', NULL, -1, '2017-03-03 11:18:41', '2017-03-03 11:18:41'),
(24, 1, 0, '', '10:30-11:30', '1703040931564', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, -1, '2017-03-04 01:31:56', '2017-03-04 01:31:56'),
(25, 1, 0, '', '10:30-11:30', '1703040934395', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":"18538553590"}', NULL, -1, '2017-03-04 01:34:38', '2017-03-04 01:34:38'),
(26, 1, 0, '', '10:30-11:30', '1703040938524', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":0,"phone":""}', NULL, -1, '2017-03-04 01:38:52', '2017-03-04 01:38:52'),
(27, 1, 0, '', '10:30-11:30', '1703040939391', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":"185385535960"}', NULL, -1, '2017-03-04 01:39:39', '2017-03-04 01:39:39'),
(28, 1, 0, '', '10:30-11:30', '1703040948436', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 01:48:43', '2017-03-04 01:48:43'),
(29, 1, 0, '', '10:30-11:30', '1703040202519', 100.00, 0, 1, 0, '', 0, 0, 11, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":""}', NULL, 0, '2017-03-04 06:02:50', '2017-03-04 06:02:50'),
(30, 1, 0, '', '14:30-15:30', '1703040235347', 312.00, 0, 1, 0, '', 0, 0, 45, 0, 0, '{"address":0,"phone":""}', NULL, -1, '2017-03-04 06:35:33', '2017-03-04 06:35:33'),
(31, 1, 0, '', '14:30-15:30', '1703040325461', 36.00, 0, 1, 0, '', 0, 0, 36, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 07:25:46', '2017-03-04 07:25:46'),
(32, 1, 0, '', '14:30-15:30', '1703040327041', 36.00, 0, 1, 0, '', 0, 0, 36, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 07:27:04', '2017-03-04 07:27:04'),
(33, 26, 0, '', '14:30-15:30', '1703040331247', 36.00, 0, 1, 0, '', 0, 0, 36, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 07:31:24', '2017-03-04 07:31:24'),
(34, 26, 0, '', '10:30-11:30', '1703040333008', 12.00, 0, 1, 0, '', 0, 0, 12, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 07:33:00', '2017-03-04 07:33:00'),
(35, 24, 0, '', '14:30-15:30', '1703040342277', 24.00, 0, 1, 0, '', 0, 0, 24, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 07:42:27', '2017-03-04 07:42:27'),
(36, 20, 0, '', '14:30-15:30', '1703040540573', 12.00, 0, 4, 0, '', 0, 0, 12, 0, 0, '{"address":0,"phone":""}', NULL, 0, '2017-03-04 09:40:56', '2017-03-04 09:40:56'),
(37, 1, 0, '', '10:30-11:30', '1703040600401', 12.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:00:40', '2017-03-04 10:00:40'),
(38, 1, 0, '', '10:30-11:30', '1703040603339', 12.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:03:33', '2017-03-04 10:03:33'),
(39, 1, 0, '', '10:30-11:30', '1703040607469', 12.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:07:46', '2017-03-04 10:07:46'),
(40, 1, 0, '', '10:30-11:30', '1703040608335', 0.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:08:33', '2017-03-04 10:08:33'),
(41, 1, 0, '', '10:30-11:30', '1703040610138', 0.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:10:13', '2017-03-04 10:10:13'),
(42, 1, 0, '', '10:30-11:30', '1703040612194', 2.00, 12, 1, 0, '{"code":"933758","price":10}', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:12:19', '2017-03-04 10:12:19'),
(43, 1, 0, '', '10:30-11:30', '1703040647593', 0.00, 12, 1, 0, '{"code":"118775","price":20}', 0, 0, 12, 0, 0, '', NULL, 0, '2017-03-04 10:47:58', '2017-03-04 10:47:58'),
(44, 23, 0, '', '10:30-11:30', '1703060219211', 136.00, 136, 2, 0, '', 0, 0, 46, 0, 0, '', NULL, 0, '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(45, 23, 0, '', '15:30-17:30', '1703060242355', 48.00, 48, 3, 0, '', 0, 0, 48, 0, 0, '', NULL, 0, '2017-03-06 06:42:35', '2017-03-06 06:42:35'),
(46, 23, 0, '', '15:30-17:30', '1703060248146', 72.00, 72, 1, 0, '', 0, 0, 72, 0, 0, '', NULL, 0, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(47, 23, 0, '', '15:30-17:30', '1703060251125', 48.00, 48, 1, 0, '', 0, 0, 48, 0, 0, '', NULL, 0, '2017-03-06 06:51:12', '2017-03-06 06:51:12'),
(48, 23, 0, '', '10:30-11:30', '1703060254531', 36.00, 36, 1, 0, '', 0, 0, 36, 0, 0, '', NULL, 0, '2017-03-06 06:54:52', '2017-03-06 06:54:52'),
(49, 23, 0, '', '15:30-17:30', '1703060300539', 129.00, 129, 1, 0, '', 0, 0, 100, 0, 0, '', NULL, 0, '2017-03-06 07:00:53', '2017-03-06 07:00:53'),
(50, 23, 0, '', '15:30-17:30', '1703060322038', 36.00, 36, 1, 0, '', 0, 0, 36, 0, 0, '', NULL, 0, '2017-03-06 07:22:03', '2017-03-06 07:22:03'),
(51, 23, 0, '', '10:30-11:30', '1703060334341', 36.00, 36, 1, 0, '', 0, 0, 36, 0, 0, '', NULL, 0, '2017-03-06 07:34:34', '2017-03-06 07:34:34'),
(52, 23, 0, '', '14:30-15:30', '1703060622108', 36.00, 36, 1, 0, '', 0, 0, 36, 0, 0, '', '', 0, '2017-03-06 10:22:10', '2017-03-06 10:22:10'),
(53, 24, 0, '', '14:30-15:30', '1703070950141', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', -1, '2017-03-07 01:50:13', '2017-03-07 01:50:13'),
(54, 1, 0, '', '10:30-11:30', '1703071005121', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 02:05:12', '2017-03-07 02:05:12'),
(55, 1, 0, '', '10:30-11:30', '1703071005467', 12.00, 12, 3, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 02:05:46', '2017-03-07 02:05:46'),
(56, 1, 0, '', '10:30-11:30', '1703071006315', 12.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 02:06:31', '2017-03-07 02:06:31'),
(57, 1, 0, '', '10:30-11:30', '1703071008512', 12.00, 12, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 02:08:50', '2017-03-07 02:08:50'),
(58, 23, 0, '', '14:30-15:30', '1703071054049', 0.07, 0.07, 1, 0, '', 0, 0, 84, 0, 0, '', '', 0, '2017-03-07 02:54:04', '2017-03-07 02:54:04'),
(59, 24, 0, '', '14:30-15:30', '1703071103526', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 03:03:51', '2017-03-07 03:03:51'),
(60, 20, 0, '', '14:30-15:30', '1703071110469', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '111', 0, '2017-03-07 03:10:46', '2017-03-07 03:10:46'),
(61, 24, 0, '', '14:30-15:30', '1703071151155', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', 'aa', 0, '2017-03-07 03:51:15', '2017-03-07 03:51:15'),
(62, 24, 0, '', '14:30-15:30', '1703071155302', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 03:55:30', '2017-03-07 03:55:30'),
(63, 24, 0, '', '14:30-15:30', '1703071205012', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 04:05:01', '2017-03-07 04:05:01'),
(64, 24, 0, '', '14:30-15:30', '1703070226464', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 06:26:45', '2017-03-07 06:26:45'),
(65, 1, 0, '', '10:30-11:30', '1703070236293', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 06:36:29', '2017-03-07 06:36:29'),
(66, 24, 0, '', '14:30-15:30', '1703070303478', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:03:47', '2017-03-07 07:03:47'),
(67, 24, 0, '', '14:30-15:30', '1703070315583', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:15:58', '2017-03-07 07:15:58'),
(68, 24, 0, '', '14:30-15:30', '1703070322458', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:22:45', '2017-03-07 07:22:45'),
(69, 1, 0, '', '10:30-11:30', '1703070325553', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:25:55', '2017-03-07 07:25:55'),
(70, 20, 0, '', '14:30-15:30', '1703070326332', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:26:32', '2017-03-07 07:26:32'),
(71, 1, 0, '', '10:30-11:30', '1703070327224', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:27:22', '2017-03-07 07:27:22'),
(72, 1, 0, '', '10:30-11:30', '1703070328159', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:28:15', '2017-03-07 07:28:15'),
(73, 1, 0, '', '10:30-11:30', '1703070329242', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:29:24', '2017-03-07 07:29:24'),
(74, 20, 0, '', '14:30-15:30', '1703070329379', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:29:36', '2017-03-07 07:29:36'),
(75, 1, 0, '', '10:30-11:30', '1703070330066', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:30:06', '2017-03-07 07:30:06'),
(76, 1, 0, '', '10:30-11:30', '1703070331266', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 2, '2017-03-07 07:31:26', '2017-03-07 07:31:26'),
(77, 20, 0, '', '14:30-15:30', '1703070331296', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:31:29', '2017-03-07 07:31:29'),
(78, 1, 0, '', '10:30-11:30', '1703070332019', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:32:01', '2017-03-07 07:32:01'),
(79, 20, 0, '', '14:30-15:30', '1703070334409', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:34:40', '2017-03-07 07:34:40'),
(80, 20, 0, '', '14:30-15:30', '1703070337232', 12.00, 12, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:37:23', '2017-03-07 07:37:23'),
(81, 20, 0, '', '14:30-15:30', '1703070348015', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:48:01', '2017-03-07 07:48:01'),
(82, 21, 0, '', '10:30-11:30', '1703070350517', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:50:51', '2017-03-07 07:50:51'),
(83, 21, 0, '', '10:30-11:30', '1703070353431', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:53:43', '2017-03-07 07:53:43'),
(84, 21, 0, '', '10:30-11:30', '1703070359569', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 07:59:56', '2017-03-07 07:59:56'),
(85, 21, 0, '', '10:30-11:30', '1703070401248', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 08:01:24', '2017-03-07 08:01:24'),
(86, 20, 0, '', '14:30-15:30', '1703070409036', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 08:09:03', '2017-03-07 08:09:03'),
(87, 20, 0, '', '14:30-15:30', '1703070417546', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 08:17:54', '2017-03-07 08:17:54'),
(88, 20, 0, '', '14:30-15:30', '1703070421347', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 08:21:34', '2017-03-07 08:21:34'),
(89, 20, 0, '', '14:30-15:30', '1703070427241', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 08:27:24', '2017-03-07 08:27:24'),
(90, 21, 0, '', '10:30-11:30', '1703070512087', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 09:12:08', '2017-03-07 09:12:08'),
(91, 21, 0, '', '10:30-11:30', '1703070524248', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 09:24:24', '2017-03-07 09:24:24'),
(92, 21, 0, '', '10:30-11:30', '1703070557328', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 09:57:31', '2017-03-07 09:57:31'),
(93, 21, 0, '', '10:30-11:30', '1703070605101', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 10:05:10', '2017-03-07 10:05:10'),
(94, 21, 0, '', '10:30-11:30', '1703070623401', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":"18538553590"}', '', 0, '2017-03-07 10:23:40', '2017-03-07 10:23:40'),
(95, 21, 0, '', '10:30-11:30', '1703070626013', 0.01, 0.01, 4, 0, '', 0, 0, 12, 0, 1, '{"address":"郑州市金水区北三环园田路11号","phone":"18538553590"}', '', -1, '2017-03-07 10:26:01', '2017-03-07 10:26:01'),
(96, 23, 0, '', '15:30-17:30', '1703070644487', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 10:44:47', '2017-03-07 10:44:47'),
(97, 23, 0, '', '15:30-17:30', '1703070645215', 0.00, 0, 2, 0, '', 0, 0, 0, 0, 0, '', '', 0, '2017-03-07 10:45:21', '2017-03-07 10:45:21'),
(98, 23, 0, '', '15:30-17:30', '1703070646087', 0.00, 0, 2, 0, '', 0, 0, 0, 0, 0, '', '', 0, '2017-03-07 10:46:08', '2017-03-07 10:46:08'),
(99, 23, 0, '', '15:30-17:30', '1703070652256', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 10:52:25', '2017-03-07 10:52:25'),
(100, 23, 0, '', '15:30-17:30', '1703070652424', 0.00, 0, 2, 0, '', 0, 0, 0, 0, 0, '', '', 0, '2017-03-07 10:52:42', '2017-03-07 10:52:42'),
(101, 23, 0, '', '15:30-17:30', '1703070652468', 0.00, 0, 2, 0, '', 0, 0, 0, 0, 0, '', '', 0, '2017-03-07 10:52:46', '2017-03-07 10:52:46'),
(102, 23, 0, '', '15:30-17:30', '1703070653079', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 10:53:07', '2017-03-07 10:53:07'),
(103, 23, 0, '', '15:30-17:30', '1703070707369', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-07 11:07:36', '2017-03-07 11:07:36'),
(104, 1, 0, '', '10:30-11:30', '1703080911279', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', -1, '2017-03-08 01:11:27', '2017-03-08 01:11:27'),
(105, 1, 0, '', '10:30-11:30', '1703080929042', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:29:04', '2017-03-08 01:29:04'),
(106, 1, 0, '', '10:30-11:30', '1703080935125', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:35:12', '2017-03-08 01:35:12'),
(107, 1, 0, '', '10:30-11:30', '1703080937012', 0.01, 0.01, 1, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:37:01', '2017-03-08 01:37:01'),
(108, 1, 0, '', '10:30-11:30', '1703080937165', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:37:16', '2017-03-08 01:37:16'),
(109, 1, 0, '', '10:30-11:30', '1703080939325', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:39:32', '2017-03-08 01:39:32'),
(110, 21, 0, '', '10:30-11:30', '1703080942267', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:42:25', '2017-03-08 01:42:25'),
(111, 1, 0, '', '10:30-11:30', '1703080943301', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 01:43:30', '2017-03-08 01:43:30'),
(112, 1, 0, '', '10:30-11:30', '1703081021146', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:21:14', '2017-03-08 02:21:14'),
(113, 1, 0, '', '10:30-11:30', '1703081025327', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:25:32', '2017-03-08 02:25:32'),
(114, 1, 0, '', '10:30-11:30', '1703081026255', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:26:25', '2017-03-08 02:26:25'),
(115, 21, 0, '', '10:30-11:30', '1703081046336', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:46:33', '2017-03-08 02:46:33'),
(116, 21, 0, '', '10:30-11:30', '1703081048474', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:48:47', '2017-03-08 02:48:47'),
(117, 21, 0, '', '10:30-11:30', '1703081052202', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 02:52:20', '2017-03-08 02:52:20'),
(118, 21, 0, '', '10:30-11:30', '1703081106006', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 03:06:00', '2017-03-08 03:06:00'),
(119, 1, 0, '', '10:30-11:30', '1703081117273', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 03:17:27', '2017-03-08 03:17:27'),
(120, 1, 0, '', '10:30-11:30', '1703081120123', 0.01, 0.01, 2, 0, '', 0, 0, 12, 0, 0, '', '', 0, '2017-03-08 03:20:12', '2017-03-08 03:20:12');
-- --------------------------------------------------------
--
-- 表的结构 `order_contact`
--
CREATE TABLE `order_contact` (
`id` int(10) unsigned NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`order_id` int(11) NOT NULL DEFAULT '0',
`name` text,
`phone` text,
`province` text,
`city` text,
`district` text,
`address` text,
`postcode` text,
`remark` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `order_contact`
--
INSERT INTO `order_contact` (`id`, `user_id`, `order_id`, `name`, `phone`, `province`, `city`, `district`, `address`, `postcode`, `remark`, `created_at`, `updated_at`) VALUES
(1, 1, 28, '老王', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 01:48:43', '2017-03-04 01:48:43'),
(2, 1, 30, 'ouba刚', '13273852162', '北京', '北京', NULL, '许昌学院静十207', NULL, NULL, '2017-03-04 06:35:33', '2017-03-04 06:35:33'),
(3, 1, 31, 'ouba刚', '13273852162', '北京', '北京', NULL, '许昌学院静十207111', NULL, NULL, '2017-03-04 07:25:46', '2017-03-04 07:25:46'),
(4, 1, 32, 'ouba刚', '13273852162', '北京', '北京', NULL, '许昌学院静十207111', NULL, NULL, '2017-03-04 07:27:04', '2017-03-04 07:27:04'),
(5, 26, 33, 'ouba刚', '13273852162', '北京', '北京', NULL, '许昌学院静十207111', NULL, NULL, '2017-03-04 07:31:24', '2017-03-04 07:31:24'),
(6, 26, 34, 'ouba刚', '13273852162', '河南', '洛阳', NULL, '许昌学院静十207111', NULL, NULL, '2017-03-04 07:33:00', '2017-03-04 07:33:00'),
(7, 24, 35, '', '', '北京', '北京', NULL, '', NULL, NULL, '2017-03-04 07:42:27', '2017-03-04 07:42:27'),
(8, 20, 36, '', '', '河南', '郑州', NULL, '', NULL, NULL, '2017-03-04 09:40:56', '2017-03-04 09:40:56'),
(9, 1, 37, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:00:40', '2017-03-04 10:00:40'),
(10, 1, 38, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:03:33', '2017-03-04 10:03:33'),
(11, 1, 39, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:07:46', '2017-03-04 10:07:46'),
(12, 1, 40, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:08:33', '2017-03-04 10:08:33'),
(13, 1, 41, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:10:13', '2017-03-04 10:10:13'),
(14, 1, 42, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:12:19', '2017-03-04 10:12:19'),
(15, 1, 43, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-04 10:47:58', '2017-03-04 10:47:58'),
(16, 23, 44, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(17, 23, 45, '呵呵哒', '1234', NULL, NULL, NULL, '郑州金水区', NULL, NULL, '2017-03-06 06:42:35', '2017-03-06 06:42:35'),
(18, 23, 46, '呵呵哒', '1234', NULL, NULL, NULL, '郑州金水区', NULL, NULL, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(19, 23, 47, '老王', '18303175634', NULL, NULL, NULL, '你隔壁啊', NULL, NULL, '2017-03-06 06:51:12', '2017-03-06 06:51:12'),
(20, 23, 48, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-06 06:54:52', '2017-03-06 06:54:52'),
(21, 23, 49, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-06 07:00:53', '2017-03-06 07:00:53'),
(22, 23, 50, '呵呵哒', '1234', NULL, NULL, NULL, '郑州金水区', NULL, NULL, '2017-03-06 07:22:03', '2017-03-06 07:22:03'),
(23, 23, 51, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-06 07:34:34', '2017-03-06 07:34:34'),
(24, 23, 52, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-06 10:22:10', '2017-03-06 10:22:10'),
(25, 24, 53, '', '', '北京', '北京', NULL, '', NULL, NULL, '2017-03-07 01:50:13', '2017-03-07 01:50:13'),
(26, 1, 54, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 02:05:12', '2017-03-07 02:05:12'),
(27, 1, 55, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 02:05:46', '2017-03-07 02:05:46'),
(28, 1, 56, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 02:06:31', '2017-03-07 02:06:31'),
(29, 1, 57, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 02:08:50', '2017-03-07 02:08:50'),
(30, 23, 58, 'ouba刚', '13273852162', NULL, NULL, NULL, '许昌学院静十207', NULL, NULL, '2017-03-07 02:54:04', '2017-03-07 02:54:04'),
(31, 24, 59, '', '', '北京', '北京', NULL, '', NULL, NULL, '2017-03-07 03:03:51', '2017-03-07 03:03:51'),
(32, 20, 60, '', '', '河南', '郑州', NULL, '', NULL, NULL, '2017-03-07 03:10:46', '2017-03-07 03:10:46'),
(33, 24, 62, '', '', '北京', '北京', NULL, '', NULL, NULL, '2017-03-07 03:55:30', '2017-03-07 03:55:30'),
(34, 24, 63, 'lee', '18336787690', '北京', '北京', NULL, 'aaa', NULL, NULL, '2017-03-07 04:05:01', '2017-03-07 04:05:01'),
(35, 24, 64, 'lee', '18336787690', '北京', '北京', NULL, 'aaa', NULL, NULL, '2017-03-07 06:26:45', '2017-03-07 06:26:45'),
(36, 1, 65, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 06:36:29', '2017-03-07 06:36:29'),
(37, 24, 66, 'lee', '18336787690', '北京', '北京', NULL, 'aaa', NULL, NULL, '2017-03-07 07:03:47', '2017-03-07 07:03:47'),
(38, 24, 67, 'lee', '18336787690', '北京', '北京', NULL, 'aaa', NULL, NULL, '2017-03-07 07:15:58', '2017-03-07 07:15:58'),
(39, 24, 68, 'lee', '18336787690', '北京', '北京', NULL, 'aaa', NULL, NULL, '2017-03-07 07:22:45', '2017-03-07 07:22:45'),
(40, 1, 69, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:25:55', '2017-03-07 07:25:55'),
(41, 20, 70, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:26:32', '2017-03-07 07:26:32'),
(42, 1, 71, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:27:22', '2017-03-07 07:27:22'),
(43, 1, 72, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:28:15', '2017-03-07 07:28:15'),
(44, 1, 73, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:29:24', '2017-03-07 07:29:24'),
(45, 20, 74, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:29:36', '2017-03-07 07:29:36'),
(46, 1, 75, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:30:06', '2017-03-07 07:30:06'),
(47, 1, 76, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:31:26', '2017-03-07 07:31:26'),
(48, 20, 77, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:31:29', '2017-03-07 07:31:29'),
(49, 1, 78, '老李', '13781120886', '北京', '北京', '东城区', '就你隔壁', NULL, NULL, '2017-03-07 07:32:01', '2017-03-07 07:32:01'),
(50, 20, 79, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:34:40', '2017-03-07 07:34:40'),
(51, 20, 80, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:37:23', '2017-03-07 07:37:23'),
(52, 20, 81, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 07:48:01', '2017-03-07 07:48:01'),
(53, 21, 82, '雪贝特', '18538553590', '北京', '北京', '东城区', '天安门', NULL, NULL, '2017-03-07 07:50:51', '2017-03-07 07:50:51'),
(54, 21, 83, '雪贝特', '18538553590', '北京', '北京', '东城区', '天安门', NULL, NULL, '2017-03-07 07:53:43', '2017-03-07 07:53:43'),
(55, 21, 84, '雪贝特', '18538553590', '北京', '北京', '东城区', '天安门', NULL, NULL, '2017-03-07 07:59:56', '2017-03-07 07:59:56'),
(56, 21, 85, '雪贝特', '18538553590', '北京', '北京', '东城区', '天安门', NULL, NULL, '2017-03-07 08:01:24', '2017-03-07 08:01:24'),
(57, 20, 86, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 08:09:03', '2017-03-07 08:09:03'),
(58, 20, 87, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 08:17:54', '2017-03-07 08:17:54'),
(59, 20, 88, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 08:21:34', '2017-03-07 08:21:34'),
(60, 20, 89, 'lee', '18336787690', '河南', '郑州', NULL, 'aaaa', NULL, NULL, '2017-03-07 08:27:24', '2017-03-07 08:27:24'),
(61, 21, 90, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-07 09:12:08', '2017-03-07 09:12:08'),
(62, 21, 91, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-07 09:24:24', '2017-03-07 09:24:24'),
(63, 21, 92, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-07 09:57:31', '2017-03-07 09:57:31'),
(64, 21, 93, '雪贝特', '18538553590', '河南', '开封', NULL, '开封市', NULL, NULL, '2017-03-07 10:05:10', '2017-03-07 10:05:10'),
(65, 23, 96, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:44:47', '2017-03-07 10:44:47'),
(66, 23, 97, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:45:21', '2017-03-07 10:45:21'),
(67, 23, 98, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:46:08', '2017-03-07 10:46:08'),
(68, 23, 99, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:52:25', '2017-03-07 10:52:25'),
(69, 23, 100, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:52:42', '2017-03-07 10:52:42'),
(70, 23, 101, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:52:46', '2017-03-07 10:52:46'),
(71, 23, 102, 'ouba刚', '18303741595', NULL, NULL, NULL, '许昌学院', NULL, NULL, '2017-03-07 10:53:07', '2017-03-07 10:53:07'),
(72, 23, 103, '呵呵哒', '1234', NULL, NULL, NULL, '郑州金水区', NULL, NULL, '2017-03-07 11:07:36', '2017-03-07 11:07:36'),
(73, 1, 104, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:11:27', '2017-03-08 01:11:27'),
(74, 1, 105, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:29:04', '2017-03-08 01:29:04'),
(75, 1, 106, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:35:12', '2017-03-08 01:35:12'),
(76, 1, 107, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:37:01', '2017-03-08 01:37:01'),
(77, 1, 108, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:37:16', '2017-03-08 01:37:16'),
(78, 1, 109, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:39:32', '2017-03-08 01:39:32'),
(79, 21, 110, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-08 01:42:25', '2017-03-08 01:42:25'),
(80, 1, 111, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 01:43:30', '2017-03-08 01:43:30'),
(81, 1, 112, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 02:21:14', '2017-03-08 02:21:14'),
(82, 1, 113, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 02:25:32', '2017-03-08 02:25:32'),
(83, 1, 114, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 02:26:25', '2017-03-08 02:26:25'),
(84, 21, 115, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-08 02:46:33', '2017-03-08 02:46:33'),
(85, 21, 116, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-08 02:48:47', '2017-03-08 02:48:47'),
(86, 21, 117, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-08 02:52:20', '2017-03-08 02:52:20'),
(87, 21, 118, '雪贝特', '18538553590', '河南', NULL, NULL, '天安门', NULL, NULL, '2017-03-08 03:06:00', '2017-03-08 03:06:00'),
(88, 1, 119, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 03:17:27', '2017-03-08 03:17:27'),
(89, 1, 120, '老李', '13781120886', '河南', NULL, NULL, '就你隔壁', NULL, NULL, '2017-03-08 03:20:12', '2017-03-08 03:20:12');
-- --------------------------------------------------------
--
-- 表的结构 `order_detail`
--
CREATE TABLE `order_detail` (
`id` int(10) unsigned NOT NULL,
`order_id` int(11) NOT NULL DEFAULT '0',
`product_id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`name` text,
`sku_id` text,
`sku_name` text,
`num` int(11) NOT NULL DEFAULT '0',
`price` double(10,2) NOT NULL DEFAULT '0.00',
`remark` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `order_detail`
--
INSERT INTO `order_detail` (`id`, `order_id`, `product_id`, `user_id`, `name`, `sku_id`, `sku_name`, `num`, `price`, `remark`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 09:44:40', '2017-03-03 09:44:40'),
(2, 2, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 09:47:30', '2017-03-03 09:47:30'),
(3, 3, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:04:47', '2017-03-03 10:04:47'),
(4, 4, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:18:55', '2017-03-03 10:18:55'),
(5, 5, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:22:39', '2017-03-03 10:22:39'),
(6, 6, 9, 1, '经典日韩行李箱', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:27:45', '2017-03-03 10:27:45'),
(7, 7, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 10:31:07', '2017-03-03 10:31:07'),
(8, 9, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 10:38:33', '2017-03-03 10:38:33'),
(9, 10, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:40:17', '2017-03-03 10:40:17'),
(10, 11, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 10:41:20', '2017-03-03 10:41:20'),
(11, 12, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 10:41:57', '2017-03-03 10:41:57'),
(12, 13, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:43:25', '2017-03-03 10:43:25'),
(13, 14, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:45:47', '2017-03-03 10:45:47'),
(14, 15, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:48:10', '2017-03-03 10:48:10'),
(15, 16, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:52:36', '2017-03-03 10:52:36'),
(16, 17, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:54:26', '2017-03-03 10:54:26'),
(17, 18, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 10:57:10', '2017-03-03 10:57:10'),
(18, 19, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 11:01:40', '2017-03-03 11:01:40'),
(19, 20, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 11:02:58', '2017-03-03 11:02:58'),
(20, 21, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-03 11:06:26', '2017-03-03 11:06:26'),
(21, 22, 24, 1, '111', NULL, NULL, 8, 100.00, NULL, '2017-03-03 11:10:01', '2017-03-03 11:10:01'),
(22, 23, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-03 11:18:41', '2017-03-03 11:18:41'),
(23, 24, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 01:31:56', '2017-03-04 01:31:56'),
(24, 25, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 01:34:38', '2017-03-04 01:34:38'),
(25, 26, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 01:38:52', '2017-03-04 01:38:52'),
(26, 27, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 01:39:39', '2017-03-04 01:39:39'),
(27, 28, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 01:48:43', '2017-03-04 01:48:43'),
(28, 29, 4, 1, '香梨', NULL, NULL, 0, 12.00, NULL, '2017-03-04 06:02:50', '2017-03-04 06:02:50'),
(29, 29, 24, 1, '111', NULL, NULL, 1, 100.00, NULL, '2017-03-04 06:02:50', '2017-03-04 06:02:50'),
(30, 30, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-04 06:35:33', '2017-03-04 06:35:33'),
(31, 30, 24, 1, '111', NULL, NULL, 3, 100.00, NULL, '2017-03-04 06:35:33', '2017-03-04 06:35:33'),
(32, 31, 4, 1, '香梨', NULL, NULL, 3, 12.00, NULL, '2017-03-04 07:25:46', '2017-03-04 07:25:46'),
(33, 32, 4, 1, '香梨', NULL, NULL, 3, 12.00, NULL, '2017-03-04 07:27:04', '2017-03-04 07:27:04'),
(34, 33, 2, 26, '香蕉', NULL, NULL, 1, 12.00, NULL, '2017-03-04 07:31:24', '2017-03-04 07:31:24'),
(35, 33, 4, 26, '香梨', NULL, NULL, 2, 12.00, NULL, '2017-03-04 07:31:24', '2017-03-04 07:31:24'),
(36, 34, 4, 26, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-04 07:33:00', '2017-03-04 07:33:00'),
(37, 35, 4, 24, '香梨', NULL, NULL, 2, 12.00, NULL, '2017-03-04 07:42:27', '2017-03-04 07:42:27'),
(38, 36, 9, 20, '经典日韩行李箱', NULL, NULL, 1, 12.00, NULL, '2017-03-04 09:40:56', '2017-03-04 09:40:56'),
(39, 37, 4, 1, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:00:40', '2017-03-04 10:00:40'),
(40, 38, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:03:33', '2017-03-04 10:03:33'),
(41, 39, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:07:46', '2017-03-04 10:07:46'),
(42, 40, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:08:33', '2017-03-04 10:08:33'),
(43, 41, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:10:13', '2017-03-04 10:10:13'),
(44, 42, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:12:19', '2017-03-04 10:12:19'),
(45, 43, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-04 10:47:58', '2017-03-04 10:47:58'),
(46, 44, 4, 23, '香梨', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(47, 44, 10, 23, '双肩包', NULL, NULL, 2, 12.00, NULL, '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(48, 44, 23, 23, '单肩包', NULL, NULL, 1, 100.00, NULL, '2017-03-06 06:19:20', '2017-03-06 06:19:20'),
(49, 45, 16, 23, '高档提包', NULL, NULL, 3, 12.00, NULL, '2017-03-06 06:42:35', '2017-03-06 06:42:35'),
(50, 45, 1, 23, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:42:35', '2017-03-06 06:42:35'),
(51, 46, 2, 23, '香蕉', NULL, NULL, 2, 12.00, NULL, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(52, 46, 3, 23, '苹果', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(53, 46, 5, 23, '葡萄', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(54, 46, 9, 23, '经典日韩行李箱', NULL, NULL, 2, 12.00, NULL, '2017-03-06 06:48:14', '2017-03-06 06:48:14'),
(55, 47, 11, 23, '军绿行礼箱', NULL, NULL, 3, 12.00, NULL, '2017-03-06 06:51:12', '2017-03-06 06:51:12'),
(56, 47, 12, 23, '粉红手提包', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:51:12', '2017-03-06 06:51:12'),
(57, 48, 13, 23, '高档手提包', NULL, NULL, 2, 12.00, NULL, '2017-03-06 06:54:52', '2017-03-06 06:54:52'),
(58, 48, 14, 23, '金属白行李箱', NULL, NULL, 1, 12.00, NULL, '2017-03-06 06:54:52', '2017-03-06 06:54:52'),
(59, 49, 25, 23, '新款牛皮斜跨小清新短款钱包', NULL, NULL, 1, 129.00, NULL, '2017-03-06 07:00:53', '2017-03-06 07:00:53'),
(60, 50, 18, 23, '小巧手提包', NULL, NULL, 1, 12.00, NULL, '2017-03-06 07:22:03', '2017-03-06 07:22:03'),
(61, 50, 21, 23, '肉末茄子', NULL, NULL, 2, 12.00, NULL, '2017-03-06 07:22:03', '2017-03-06 07:22:03'),
(62, 51, 15, 23, '红色行李箱', NULL, NULL, 3, 12.00, NULL, '2017-03-06 07:34:34', '2017-03-06 07:34:34'),
(63, 52, 4, 23, '香梨', NULL, NULL, 3, 12.00, NULL, '2017-03-06 10:22:10', '2017-03-06 10:22:10'),
(64, 53, 2, 24, '香蕉', NULL, NULL, 1, 12.00, NULL, '2017-03-07 01:50:13', '2017-03-07 01:50:13'),
(65, 54, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 02:05:12', '2017-03-07 02:05:12'),
(66, 55, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-07 02:05:46', '2017-03-07 02:05:46'),
(67, 56, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-07 02:06:31', '2017-03-07 02:06:31'),
(68, 57, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-07 02:08:50', '2017-03-07 02:08:50'),
(69, 58, 4, 23, '香梨', NULL, NULL, 7, 0.01, NULL, '2017-03-07 02:54:04', '2017-03-07 02:54:04'),
(70, 59, 3, 24, '苹果', NULL, NULL, 1, 12.00, NULL, '2017-03-07 03:03:51', '2017-03-07 03:03:51'),
(71, 60, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 03:10:46', '2017-03-07 03:10:46'),
(72, 62, 9, 24, '经典日韩行李箱', NULL, NULL, 1, 12.00, NULL, '2017-03-07 03:55:30', '2017-03-07 03:55:30'),
(73, 63, 5, 24, '葡萄', NULL, NULL, 1, 12.00, NULL, '2017-03-07 04:05:01', '2017-03-07 04:05:01'),
(74, 64, 10, 24, '双肩包', NULL, NULL, 1, 12.00, NULL, '2017-03-07 06:26:45', '2017-03-07 06:26:45'),
(75, 65, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 06:36:29', '2017-03-07 06:36:29'),
(76, 66, 2, 24, '香蕉', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:03:47', '2017-03-07 07:03:47'),
(77, 67, 3, 24, '苹果', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:15:58', '2017-03-07 07:15:58'),
(78, 68, 2, 24, '香蕉', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:22:45', '2017-03-07 07:22:45'),
(79, 69, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:25:55', '2017-03-07 07:25:55'),
(80, 70, 1, 20, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:26:32', '2017-03-07 07:26:32'),
(81, 71, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:27:22', '2017-03-07 07:27:22'),
(82, 72, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:28:15', '2017-03-07 07:28:15'),
(83, 73, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:29:24', '2017-03-07 07:29:24'),
(84, 74, 3, 20, '苹果', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:29:36', '2017-03-07 07:29:36'),
(85, 75, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:30:06', '2017-03-07 07:30:06'),
(86, 76, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:31:26', '2017-03-07 07:31:26'),
(87, 77, 5, 20, '葡萄', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:31:29', '2017-03-07 07:31:29'),
(88, 78, 1, 1, '橙子', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:32:01', '2017-03-07 07:32:01'),
(89, 79, 5, 20, '葡萄', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:34:40', '2017-03-07 07:34:40'),
(90, 80, 2, 20, '香蕉', NULL, NULL, 1, 12.00, NULL, '2017-03-07 07:37:23', '2017-03-07 07:37:23'),
(91, 81, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:48:01', '2017-03-07 07:48:01'),
(92, 82, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:50:51', '2017-03-07 07:50:51'),
(93, 83, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:53:43', '2017-03-07 07:53:43'),
(94, 84, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 07:59:56', '2017-03-07 07:59:56'),
(95, 85, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 08:01:24', '2017-03-07 08:01:24'),
(96, 86, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 08:09:03', '2017-03-07 08:09:03'),
(97, 87, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 08:17:54', '2017-03-07 08:17:54'),
(98, 88, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 08:21:34', '2017-03-07 08:21:34'),
(99, 89, 4, 20, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 08:27:24', '2017-03-07 08:27:24'),
(100, 90, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 09:12:08', '2017-03-07 09:12:08'),
(101, 91, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 09:24:24', '2017-03-07 09:24:24'),
(102, 92, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 09:57:31', '2017-03-07 09:57:31'),
(103, 93, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:05:10', '2017-03-07 10:05:10'),
(104, 94, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:23:40', '2017-03-07 10:23:40'),
(105, 95, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:26:01', '2017-03-07 10:26:01'),
(106, 96, 4, 23, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:44:47', '2017-03-07 10:44:47'),
(107, 97, 4, 23, '香梨', NULL, NULL, 0, 0.01, NULL, '2017-03-07 10:45:21', '2017-03-07 10:45:21'),
(108, 98, 4, 23, '香梨', NULL, NULL, 0, 0.01, NULL, '2017-03-07 10:46:08', '2017-03-07 10:46:08'),
(109, 99, 4, 23, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:52:25', '2017-03-07 10:52:25'),
(110, 100, 4, 23, '香梨', NULL, NULL, 0, 0.01, NULL, '2017-03-07 10:52:42', '2017-03-07 10:52:42'),
(111, 101, 4, 23, '香梨', NULL, NULL, 0, 0.01, NULL, '2017-03-07 10:52:46', '2017-03-07 10:52:46'),
(112, 102, 4, 23, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 10:53:07', '2017-03-07 10:53:07'),
(113, 103, 4, 23, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-07 11:07:36', '2017-03-07 11:07:36'),
(114, 104, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:11:27', '2017-03-08 01:11:27'),
(115, 105, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:29:04', '2017-03-08 01:29:04'),
(116, 106, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:35:12', '2017-03-08 01:35:12'),
(117, 107, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:37:01', '2017-03-08 01:37:01'),
(118, 108, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:37:16', '2017-03-08 01:37:16'),
(119, 109, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:39:32', '2017-03-08 01:39:32'),
(120, 110, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:42:25', '2017-03-08 01:42:25'),
(121, 111, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 01:43:30', '2017-03-08 01:43:30'),
(122, 112, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:21:14', '2017-03-08 02:21:14'),
(123, 113, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:25:32', '2017-03-08 02:25:32'),
(124, 114, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:26:25', '2017-03-08 02:26:25'),
(125, 115, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:46:33', '2017-03-08 02:46:33'),
(126, 116, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:48:47', '2017-03-08 02:48:47'),
(127, 117, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 02:52:20', '2017-03-08 02:52:20'),
(128, 118, 4, 21, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 03:06:00', '2017-03-08 03:06:00'),
(129, 119, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 03:17:27', '2017-03-08 03:17:27'),
(130, 120, 4, 1, '香梨', NULL, NULL, 1, 0.01, NULL, '2017-03-08 03:20:12', '2017-03-08 03:20:12');
-- --------------------------------------------------------
--
-- 表的结构 `order_fee`
--
CREATE TABLE `order_fee` (
`id` int(10) unsigned NOT NULL,
`order_id` int(11) NOT NULL DEFAULT '0',
`name` text,
`value` float NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `order_feedback_type`
--
CREATE TABLE `order_feedback_type` (
`id` int(11) unsigned NOT NULL,
`name` text COMMENT '类型',
`sub` text COMMENT '备注',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '状态1:开启0:关闭',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `order_feedback_type`
--
INSERT INTO `order_feedback_type` (`id`, `name`, `sub`, `status`, `created_at`, `updated_at`) VALUES
(1, '不想要了1', '这里是备注', 1, '2016-12-10 03:20:38', '2017-02-15 07:39:20'),
(2, '破了', '', 1, '2016-12-13 02:29:07', '2017-01-15 22:17:33'),
(3, '111', '222', 1, '2016-12-15 15:39:03', '2017-01-15 22:17:35'),
(4, '实物差距太大', '实物差距太大', 1, '2017-01-05 22:34:51', '2017-01-15 22:17:37'),
(5, '22', '222', 1, '2017-03-02 07:06:42', '2017-03-02 07:06:50');
-- --------------------------------------------------------
--
-- 表的结构 `payment`
--
CREATE TABLE `payment` (
`id` tinyint(3) unsigned NOT NULL,
`type` varchar(20) DEFAULT NULL,
`name` varchar(120) DEFAULT NULL,
`sub` text,
`rank` tinyint(3) NOT NULL DEFAULT '0',
`config` text,
`status` tinyint(1) NOT NULL DEFAULT '0',
`is_cod` tinyint(1) NOT NULL DEFAULT '0' COMMENT '货到付款',
`is_online` tinyint(1) NOT NULL DEFAULT '0' COMMENT '在线支付',
`is_config` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `payment`
--
INSERT INTO `payment` (`id`, `type`, `name`, `sub`, `rank`, `config`, `status`, `is_cod`, `is_online`, `is_config`, `created_at`, `updated_at`) VALUES
(1, 'cod', '货到付款', '开通城市请详见网站公告。', 0, '', 1, 1, 0, 0, '2017-02-14 05:11:48', '2017-02-13 21:04:55'),
(2, 'wxpay', '微信支付', '微信支付,是基于微信公众号JS_API网页支付提供的支付服务功能。', 0, '{"mchid":"1243051102","key":"0IVTlxNMurPnBga1ulahd7g4m36jirgR","x_mchid":"1445117902","x_key":"8e157d6843fb72dcb27f9762308b8333"}', 1, 0, 1, 1, '2017-02-14 05:11:48', '2017-03-07 02:36:01'),
(3, 'alipay', '支付宝', '支付宝(www.alipay.com)是国内先进的网上支付平台。', 0, '{"account":"koahub@163.com","partner":"2088421387324241","key":"95ljtrm73l34qg1x5dlfyqpayx2c1c0v"}', 1, 0, 1, 1, '2017-02-14 05:11:48', '2017-02-14 05:47:00'),
(4, 'balance', '余额支付', '使用帐户余额支付。只有会员才能使用,通过设置信用额度,可以透支。', 0, '', 1, 0, 1, 0, '2017-02-14 05:11:48', '2017-02-13 02:10:32');
-- --------------------------------------------------------
--
-- 表的结构 `product`
--
CREATE TABLE `product` (
`id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '0',
`name` text,
`subname` text,
`price` float NOT NULL DEFAULT '0' COMMENT '售价',
`old_price` float NOT NULL DEFAULT '0' COMMENT '原价',
`spec` text COMMENT '商品规格',
`address` text COMMENT '商品产地',
`store` int(11) NOT NULL DEFAULT '0' COMMENT '库存',
`sales` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
`unit` text COMMENT '商品单位',
`score` float NOT NULL DEFAULT '0' COMMENT '赠送积分',
`visiter` int(11) NOT NULL DEFAULT '0' COMMENT '访问量',
`sku` text,
`sku_status` int(11) NOT NULL DEFAULT '0' COMMENT '1:启用0:禁用',
`file_id` int(11) NOT NULL DEFAULT '0' COMMENT '图片',
`files` text COMMENT '图集',
`detail` text,
`status` int(11) NOT NULL DEFAULT '1' COMMENT '0:隐藏,1:显示',
`labels` text COMMENT '标签值',
`remark` text,
`rank` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product`
--
INSERT INTO `product` (`id`, `category_id`, `name`, `subname`, `price`, `old_price`, `spec`, `address`, `store`, `sales`, `unit`, `score`, `visiter`, `sku`, `sku_status`, `file_id`, `files`, `detail`, `status`, `labels`, `remark`, `rank`, `created_at`, `updated_at`) VALUES
(1, 1, '橙子', '美味可口', 12, 0, '', '', 5, 0, '', 12, 19, '1,2,3', 1, 12, '11,12,', '<p>1111</p>', 1, '', '', 0, '2016-07-19 01:45:09', '2017-02-24 04:00:29'),
(2, 1, '香蕉', '', 12, 0, '', '', 10, 0, '', 12, 7, '1,2,5,6,7', 1, 118, '12,', '', 1, '', '', 0, '2016-07-18 10:47:48', '2017-03-04 09:36:15'),
(3, 1, '苹果', '美味', 12, 0, '', '', 100, 0, '', 12, 13, '0', 0, 11, '', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-04 09:33:51'),
(4, 1, '香梨', '', 0.01, 1, '', '', 100, 0, '', 12, 1, '0', 0, 17, '17,117,', '<p><img src="https://img.alicdn.com/imgextra/i2/2597188887/TB2pjN0c9iJ.eBjSspoXXcpMFXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i1/2597188887/TB2yeh5c9iJ.eBjSspiXXbqAFXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i4/2597188887/TB2M.cgcygSXeFjy0FcXXahAXXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i2/2597188887/TB25L4.c3SI.eBjy1XcXXc1jXXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i1/2597188887/TB2Rnp8c39J.eBjSsppXXXAAVXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i2/2597188887/TB2et7JdCmK.eBjSZPfXXce2pXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i1/2597188887/TB2npN7c9GI.eBjSspcXXcVjFXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i1/2597188887/TB2mCQAdp5N.eBjSZFmXXboSXXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i1/2597188887/TB29WIJdzm2.eBjSZFtXXX56VXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i2/2597188887/TB2F1r_bKNOdeFjSZFBXXctzXXa_!!2597188887.jpg" class="img-ks-lazyload"/><img src="https://img.alicdn.com/imgextra/i4/2597188887/TB2649UeFXXXXbuXXXXXXXXXXXX_!!2597188887.jpg" class="img-ks-lazyload"/></p>', 1, '', '', 1111, '2016-07-20 09:13:56', '2017-03-07 01:49:43'),
(5, 1, '葡萄', NULL, 12, 0, '', '', 100, 0, '', 12, 0, '0', 0, 16, '', '', 1, '', '', 0, '2016-01-05 03:02:23', '0000-00-00 00:00:00'),
(6, 1, '菠萝', '', 12, 0, '', '', 100, 0, '', 12, 0, '1,2,3,5,6,7,9,10,11', 0, 15, '', '', 0, '', '', 0, '2016-01-05 03:02:23', '2017-02-22 08:57:47'),
(7, 1, '火龙果', '', 12, 0, '', '', 100, 0, '', 12, 2, '9,10,11', 0, 14, '', '', 0, '', '', 0, '2016-01-05 03:02:23', '2017-02-22 08:56:54'),
(8, 1, '奇异果', '', 12, 0, '', '', 100, 0, '', 12, 0, '5,6,7,8', 0, 13, '', '', 0, '', '', 0, '2016-01-05 03:02:23', '2017-02-22 08:56:44'),
(9, 1, '经典日韩行李箱', '', 12, 0, '', '', 100, 0, '', 12, 1, '1,2,3,4', 0, 90, '90,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:31:24'),
(10, 2, '双肩包', '', 12, 0, '', '', 100, 0, '', 12, 0, '1,2,3,5,6', 0, 91, '91,', '', 1, '', '', 100, '2016-01-05 03:02:23', '2017-03-03 02:00:27'),
(11, 2, '军绿行礼箱', '', 12, 0, '', '', 100, 0, '', 12, 0, '1,2,5,6,7', 0, 92, '92,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:29:28'),
(12, 2, '粉红手提包', '', 12, 0, '', '', 100, 0, '', 12, 1, '1,2,4', 0, 93, '93,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:27:25'),
(13, 2, '高档手提包', '', 12, 0, '', '', 100, 0, '', 12, 0, '9,10,11', 0, 81, '81,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:23:52'),
(14, 2, '金属白行李箱', '', 12, 0, '', '', 100, 0, '', 12, 0, '5,6', 0, 80, '80,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:22:58'),
(15, 3, '红色行李箱', '', 12, 0, '', '', 100, 0, '', 12, 0, '1,2', 0, 86, '86,', '', 1, '', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:22:04'),
(16, 2, '高档提包', '', 12, 0, '', '', 100, 0, '', 12, 0, '9,10,11', 0, 84, '84,', '', 1, '', '', 20, '2016-01-05 03:02:23', '2017-03-03 01:20:56'),
(17, 2, '经典行李箱', '', 12, 0, '', '', 100, 0, '', 12, 0, '5,6', 0, 82, '82,', '', 1, '2', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:19:13'),
(18, 2, '小巧手提包', '', 12, 0, '', '', 100, 0, '', 12, 0, '1,2,3', 0, 87, '87,', '', 1, '1', '', 0, '2016-01-05 03:02:23', '2017-03-01 09:20:23'),
(19, 1, '红烧排骨11', '11', 1211, 1, '', '', 0, 0, '11', 12, 1, '1,2,5,6,7,8', 1, 83, '83,', '', 1, '1', '1', 0, '2016-01-11 10:39:35', '2017-03-02 08:43:24'),
(21, 3, '肉末茄子', '好吃不贵', 12, 0.2, '', '', 100, 1, '千克', 12, 3, '1,2,3,5,6,7,8', 1, 88, '84,88,', '<p>箱包详情<img src="http://img.baidu.com/hi/jx2/j_0028.gif"/><img src="http://192.168.0.106/public/ueditor/php/upload/image/20170222/1487761361901759.jpg" title="1487761361901759.jpg" alt="403525e0-b3bb-11e6-b639-bf5cd88ca9e8.jpg"/></p><p style="display: none;"><br/></p>', 1, '1,2', '', 0, '2016-03-10 07:30:14', '2017-03-01 09:33:24'),
(23, 3, '单肩包', '', 100, 120, '', '', 10, 0, '元', 10, 0, NULL, 0, 109, '109,', '<p><img src="http://192.168.0.107/public/ueditor/php/upload/image/20170302/1488449575940167.png" title="1488449575940167.png" alt="longchamp_crossbody_bags_roseau_sakura_1016873A26_0.png" width="304" height="287"/></p>', 1, '1,2,3', '', 22, '2017-03-02 09:26:46', '2017-03-02 10:16:12'),
(24, 1, '111', '11', 100, 120, '', '', 100, 0, '元', 11, 0, NULL, 0, 110, '110,', '<p><img src="http://192.168.0.107/public/ueditor/php/upload/image/20170302/1488449467856217.jpeg" title="1488449467856217.jpeg" alt="58b56445N7a3876dc.jpeg"/></p><p>&nbsp; &nbsp; &nbsp; &nbsp;进口的说<img src="http://192.168.0.107/public/ueditor/php/upload/image/20170302/1488452758963934.jpeg" title="1488452758963934.jpeg" alt="d2b2275ac43cc8bce03760c162d23724ca67b803122af-qLuXr8_fw658.jpeg" width="327" height="342"/>法和刚开始</p><p style="text-align:center"><img src="http://img.baidu.com/hi/jx2/j_0015.gif"/></p><p><br/></p>', 1, '1,2,3', '1', 0, '2017-03-02 10:05:38', '2017-03-04 09:32:26'),
(25, 4, '新款牛皮斜跨小清新短款钱包', '', 129, 168, '', '', 100, 0, '', 100, 0, NULL, 0, 112, '112,', '<p><img src="http://192.168.0.107/public/ueditor/php/upload/image/20170302/1488450522428302.jpg" title="1488450522428302.jpg" alt="58abb1eaN847f21e1.jpg"/></p>', 1, '1,2,3', '', 0, '2017-03-02 10:28:50', '2017-03-02 10:29:17'),
(26, 4, '111', '11', 11, 0, '', '', 0, 0, '111', 11, 0, NULL, 0, 112, '112,', '<p>11</p>', 1, '1', '', 0, '2017-03-02 10:30:59', '2017-03-02 10:30:59');
-- --------------------------------------------------------
--
-- 表的结构 `product_category`
--
CREATE TABLE `product_category` (
`id` int(11) unsigned NOT NULL,
`name` text,
`pid` int(11) NOT NULL DEFAULT '0',
`file_id` int(11) NOT NULL DEFAULT '0',
`remark` text,
`rank` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product_category`
--
INSERT INTO `product_category` (`id`, `name`, `pid`, `file_id`, `remark`, `rank`, `created_at`, `updated_at`) VALUES
(1, '精品精品', 0, 83, '', 23, '2015-11-18 02:25:27', '2017-03-07 06:56:00'),
(2, '顶级', 0, 87, '', 15, '2015-11-06 08:05:39', '2017-03-02 10:12:15'),
(3, '日韩', 0, 82, '12', 13, '2015-11-06 08:06:06', '2017-03-03 01:55:27'),
(4, '流行精', 0, 90, '', 22, '2016-01-05 02:30:11', '2017-03-07 06:56:05'),
(8, '春夏', 0, 0, '', 0, '2017-03-02 10:17:43', '2017-03-02 10:17:43'),
(9, '优雅', 0, 0, '', 0, '2017-03-02 10:17:51', '2017-03-02 10:17:51'),
(10, '复古', 0, 0, '', 12, '2017-03-02 10:18:03', '2017-03-03 01:55:35');
-- --------------------------------------------------------
--
-- 表的结构 `product_comment`
--
CREATE TABLE `product_comment` (
`id` int(10) unsigned NOT NULL,
`product_id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`name` text,
`star` int(11) NOT NULL DEFAULT '0' COMMENT '星星5',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '1:显示0:隐藏',
`remark` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product_comment`
--
INSERT INTO `product_comment` (`id`, `product_id`, `user_id`, `name`, `star`, `status`, `remark`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '不错不错', 0, 1, NULL, '2017-02-14 03:56:22', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `product_exchange`
--
CREATE TABLE `product_exchange` (
`id` int(10) unsigned NOT NULL,
`order_id` int(11) NOT NULL DEFAULT '0',
`product_id` int(11) NOT NULL DEFAULT '0',
`reason_id` int(11) NOT NULL DEFAULT '0',
`remark` text,
`status` int(11) NOT NULL DEFAULT '0' COMMENT '-1:拒绝0:未处理1:通过',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product_exchange`
--
INSERT INTO `product_exchange` (`id`, `order_id`, `product_id`, `reason_id`, `remark`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 21, 1, 'aaa', -1, '2016-12-28 15:03:59', '2016-12-28 17:40:19');
-- --------------------------------------------------------
--
-- 表的结构 `product_label`
--
CREATE TABLE `product_label` (
`id` int(10) unsigned NOT NULL,
`name` text,
`subname` text,
`remark` text,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product_label`
--
INSERT INTO `product_label` (`id`, `name`, `subname`, `remark`, `created_at`, `updated_at`) VALUES
(1, '热销', '热销', '121', '2016-01-05 08:48:11', '2017-02-10 01:46:53'),
(2, '推荐', '推荐', '', '2016-01-05 08:55:11', '0000-00-00 00:00:00'),
(3, '特卖', '特卖', '', '2016-01-07 08:00:37', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `product_sku`
--
CREATE TABLE `product_sku` (
`id` int(11) unsigned NOT NULL,
`product_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
`ids` text COMMENT 'sku-id',
`name` text COMMENT 'sku-name',
`price` float NOT NULL DEFAULT '0' COMMENT '售价',
`old_price` float NOT NULL DEFAULT '0' COMMENT '原价',
`store` int(11) NOT NULL DEFAULT '0' COMMENT '库存',
`sales` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `product_sku`
--
INSERT INTO `product_sku` (`id`, `product_id`, `ids`, `name`, `price`, `old_price`, `store`, `sales`, `created_at`, `updated_at`) VALUES
(9, 19, '2-6', '红-X', 0, 0, 0, 0, '2017-02-13 04:47:22', '2017-02-22 15:26:28'),
(10, 19, '2-7', '红-XL', 0, 0, 0, 0, '2017-02-13 04:47:22', '2017-02-22 15:26:28'),
(11, 19, '2-8', '红-2XL', 0, 0, 0, 0, '2017-02-13 04:47:30', '2017-02-22 15:26:28'),
(21, 21, '3-6', '黄-X', 0, 0, 0, 0, '2017-02-15 06:57:18', '2017-02-22 15:25:54'),
(22, 21, '3-7', '黄-XL',