1 Star 0 Fork 353

tocgi / iWshop

forked from Yc Chan / iWshop 
Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
iwshop_dev.sql 324.24 KB
Copy Edit Web IDE Raw Blame History
九瑞林哥 authored 2016-08-09 17:59 . 测试数据库
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272
-- mysqldump-php https://github.com/ifsnop/mysqldump-php
--
-- Host: 127.0.0.1 Database: iwshop_dev
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.13-MariaDB
-- Date: Tue, 09 Aug 2016 16:57:42 +0800
/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admin`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin_name` varchar(255) DEFAULT NULL,
`admin_account` varchar(255) NOT NULL,
`admin_password` varchar(255) NOT NULL,
`admin_last_login` datetime DEFAULT NULL,
`admin_ip_address` varchar(255) DEFAULT NULL,
`admin_auth` varchar(255) DEFAULT NULL,
`supplier_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`admin_account`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='后台管理员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin`
--
LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `admin` VALUES (1,'超级管理员','admin','4a0894d6e8f3b5c6ee0c519bcb98b6b7fd0affcb343ace3a093f29da4b2535604b61f0aebd60c0f0e49cc53adba3fffb','2016-08-09 15:46:28','127.0.0.1','stat,orde,prod,gmes,user,comp,sett',0);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `admin_login_records`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_login_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(255) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
`ldate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='后台管理员登录记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_login_records`
--
LOCK TABLES `admin_login_records` WRITE;
/*!40000 ALTER TABLE `admin_login_records` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `admin_login_records` VALUES (1,'admin','127.0.0.1','2016-07-23 09:23:16'),(2,'admin','127.0.0.1','2016-07-23 09:24:02'),(3,'admin','127.0.0.1','2016-07-23 09:26:45'),(4,'admin','127.0.0.1','2016-07-23 09:26:51'),(5,'admin','127.0.0.1','2016-07-23 09:29:01'),(6,'admin','127.0.0.1','2016-07-25 08:30:52'),(7,'admin','127.0.0.1','2016-07-25 09:04:46'),(8,'admin','127.0.0.1','2016-07-25 11:25:03'),(9,'admin','127.0.0.1','2016-07-27 09:02:18'),(10,'admin','127.0.0.1','2016-07-27 17:41:02'),(11,'admin','127.0.0.1','2016-07-28 09:02:42'),(12,'admin','127.0.0.1','2016-07-28 17:13:53'),(13,'admin','127.0.0.1','2016-07-28 17:25:43'),(14,'admin','127.0.0.1','2016-07-28 17:33:49'),(15,'zsoner','127.0.0.1','2016-08-06 09:05:19'),(16,'zsoner','127.0.0.1','2016-08-06 09:05:30'),(17,'zsoner','127.0.0.1','2016-08-06 09:05:35'),(18,'admin','127.0.0.1','2016-08-06 09:05:41'),(19,'admin','127.0.0.1','2016-08-06 15:32:03'),(20,'admin','127.0.0.1','2016-08-06 18:01:41'),(21,'admin','127.0.0.1','2016-08-06 18:01:55'),(22,'admin','127.0.0.1','2016-08-06 18:02:10'),(23,'admin','127.0.0.1','2016-08-06 18:06:48'),(24,'zsoner','127.0.0.1','2016-08-08 09:01:11'),(25,'admin','127.0.0.1','2016-08-08 09:01:17'),(26,'admin','127.0.0.1','2016-08-08 10:00:22'),(27,'admin','127.0.0.1','2016-08-09 15:46:28');
/*!40000 ALTER TABLE `admin_login_records` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `articles`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thumb_media_id` varchar(255) DEFAULT NULL COMMENT '图文消息缩略图的media_id,可以在基础支持-上传多媒体文件接口中获得',
`author` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`content_source_url` varchar(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`digest` varchar(255) DEFAULT NULL,
`show_cover_pic` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图文消息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `articles`
--
LOCK TABLES `articles` WRITE;
/*!40000 ALTER TABLE `articles` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `articles` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `auth_group`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
`module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '组类型',
`title` varchar(32) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
`description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态:为1正常,为0禁用,-1为删除',
`rules` text NOT NULL COMMENT '用户组拥有的规则code,多个规则 , 隔开',
`update_time` int(10) unsigned NOT NULL,
`create_time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='权限组表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group`
--
LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `auth_group` VALUES (1,'',0,'测试组','',1,'1OxMW4,1CxHz3,I0MXo1,POQ45,1S7DU2,yQGtY1,1dHtF4,1gN6L3,1mSd24,THsPA1,1shp13,1ejRy3,1rH4Y2,1mf2e3,m7IPe',1469268393,0);
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `auth_group_access`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_access` (
`uid` mediumint(8) unsigned NOT NULL,
`group_id` mediumint(8) unsigned NOT NULL,
UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
KEY `uid` (`uid`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户权限表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group_access`
--
LOCK TABLES `auth_group_access` WRITE;
/*!40000 ALTER TABLE `auth_group_access` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `auth_group_access` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `auth_rule`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_rule` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
`module` varchar(20) NOT NULL DEFAULT '' COMMENT '规则所属module',
`pid` int(8) NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;0-主菜单',
`name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
`title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
`condition` varchar(255) NOT NULL DEFAULT '' COMMENT '规则附加条件',
`is_menu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是按钮',
`code` varchar(12) NOT NULL DEFAULT '',
`is_btn` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是按钮',
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`) USING BTREE,
KEY `module` (`status`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=237 DEFAULT CHARSET=utf8 COMMENT='权限节点表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_rule`
--
LOCK TABLES `auth_rule` WRITE;
/*!40000 ALTER TABLE `auth_rule` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `auth_rule` VALUES (1,'',0,0,'AuthManage','',1,'',0,'5UhMm',0),(2,'',1,1,'AuthManage/index','查看列表',1,'',0,'1OxMW4',0),(3,'',1,1,'AuthManage/addGroup','新增组',1,'',0,'1CxHz3',0),(4,'',1,1,'AuthManage/editGroup','编辑组',1,'',0,'I0MXo1',0),(5,'',1,1,'AuthManage/allotGroupAccess','分配组权限',1,'',0,'1MVrA3',0),(6,'',1,1,'AuthManage/allotGroupUser','分配组用户',1,'',0,'2SazF2',0),(7,'',1,1,'AuthManage/addUserToGroup','新增用户到组',1,'',0,'aA0Tx',0),(8,'',1,1,'AuthManage/deleteGroupUser','删除组用户',1,'',0,'POQ45',0),(9,'',1,1,'AuthManage/changeStatus','改变状态',1,'',0,'1S7DU2',0),(10,'',1,1,'AuthManage/refreshNode','更新节点',1,'',0,'yQGtY1',0),(11,'',0,0,'FancyPage','',1,'',0,'Aks4p1',0),(12,'',11,1,'FancyPage/fancyAlterGroup','fancy弹出组',1,'',0,'Nh7Sg1',0),(13,'',11,1,'FancyPage/fancyAddGroup','fancy新增组',1,'',0,'quurE',0),(14,'',11,1,'FancyPage/orderRefund','订单退款',1,'',0,'Kgglo1',0),(15,'',11,1,'FancyPage/ajaxSelectProduct','动态选择产品',1,'',0,'1dHtF4',0),(16,'',11,1,'FancyPage/ajaxPdBlocks','动态pdblocks',1,'',0,'1GNDt2',0),(17,'',0,0,'WdminPage','',1,'',0,'16E0r3',0),(18,'',17,1,'WdminPage/index','查看列表',1,'',0,'1dFFG4',0),(19,'',17,1,'WdminPage/home','home',1,'',0,'Cbaqp1',0),(20,'',17,1,'WdminPage/orders_manage','订单管理',1,'',0,'PFmB31',0),(21,'',17,1,'WdminPage/orders_refund','订单退款',1,'',0,'7tEiH1',0),(22,'',17,1,'WdminPage/orders_comment','订单评论',1,'',0,'1fHNT3',0),(23,'',17,1,'WdminPage/ajax_orders_comment','动态订单评论',1,'',0,'oZRsi',0),(24,'',17,1,'WdminPage/list_products','列表产品',1,'',0,'erzi42',0),(25,'',17,1,'WdminPage/list_product_instock','列表产品库存',1,'',0,'1polO4',0),(26,'',17,1,'WdminPage/list_product_instock_in','列表产品库存in',1,'',0,'rmOv51',0),(27,'',17,1,'WdminPage/iframe_alter_product','框架弹出产品',1,'',0,'a7PwE1',0),(28,'',17,1,'WdminPage/iframe_list_product','框架列表产品',1,'',0,'1nocn3',0),(29,'',17,1,'WdminPage/ajax_add_category','动态新增分类',1,'',0,'1XNBg2',0),(30,'',17,1,'WdminPage/ajax_add_brand','动态新增品牌',1,'',0,'1MzMt3',0),(31,'',17,1,'WdminPage/alter_products_category','弹出产品分类',1,'',0,'1e0kU2',0),(32,'',17,1,'WdminPage/alter_category','弹出分类',1,'',0,'1gN6L3',0),(33,'',17,1,'WdminPage/gmess_list','素材列表',1,'',0,'zXNor1',0),(34,'',17,1,'WdminPage/gmess_sent','素材sent',1,'',0,'19gdm2',0),(35,'',17,1,'WdminPage/gmess_send','素材发送',1,'',0,'1mGqR2',0),(36,'',17,1,'WdminPage/ajax_gmess_list','动态素材列表',1,'',0,'1vjeR4',0),(37,'',17,1,'WdminPage/ajax_gmess_user_list','动态素材用户列表',1,'',0,'zMgZx',0),(38,'',17,1,'WdminPage/customer_messages','用户消息s',1,'',0,'1mSd24',0),(39,'',17,1,'WdminPage/message_session','消息session',1,'',0,'ZF2mW1',0),(40,'',17,1,'WdminPage/iframe_list_customer','框架列表用户',1,'',0,'g196k',0),(41,'',17,1,'WdminPage/list_customers','列表用户',1,'',0,'1lZeW4',0),(42,'',17,1,'WdminPage/deleted_products','已删除产品',1,'',0,'1D8VB3',0),(43,'',17,1,'WdminPage/alter_product_specs','弹出产品规格',1,'',0,'1E2L64',0),(44,'',17,1,'WdminPage/list_customer_orders','列表用户订单',1,'',0,'LkbcL1',0),(45,'',17,1,'WdminPage/list_companys','列表公司s',1,'',0,'THsPA1',0),(46,'',17,1,'WdminPage/company_withdrawal','公司withdrawal',1,'',0,'1oKqJ4',0),(47,'',17,1,'WdminPage/list_company_users','列表公司用户s',1,'',0,'1BVm84',0),(48,'',17,1,'WdminPage/settings_autoresponse','设置自动回复',1,'',0,'1Y3tt',0),(49,'',17,1,'WdminPage/iframe_alter_autoresponse','框架弹出自动回复',1,'',0,'HYSyS',0),(50,'',17,1,'WdminPage/settings_base','设置base',1,'',0,'EawES',0),(51,'',17,1,'WdminPage/settings_menu','设置菜单',1,'',0,'1shp13',0),(52,'',17,1,'WdminPage/ajax_alter_product_spec','动态弹出产品规格',1,'',0,'BVdIG1',0),(53,'',17,1,'WdminPage/ajax_alter_product_spec_detail','动态弹出产品规格详情',1,'',0,'HbtHV',0),(54,'',17,1,'WdminPage/ajax_alter_product_spec_rep','动态弹出产品规格rep',1,'',0,'1aMoF4',0),(55,'',17,1,'WdminPage/list_company_income','列表公司income',1,'',0,'1f25Z4',0),(56,'',17,1,'WdminPage/alter_company','弹出公司',1,'',0,'1CFtI3',0),(57,'',17,1,'WdminPage/company_bills','公司bills',1,'',0,'1ejRy3',0),(58,'',17,1,'WdminPage/alter_product_serials','弹出产品系列',1,'',0,'1HcGG3',0),(59,'',17,1,'WdminPage/iframe_alter_serial','框架弹出系列',1,'',0,'1Ww394',0),(60,'',17,1,'WdminPage/orders_history_address','订单历史新增ress',1,'',0,'52HU61',0),(61,'',17,1,'WdminPage/iframe_alter_customer','框架弹出用户',1,'',0,'18uHR4',0),(62,'',17,1,'WdminPage/sale_trend','销售trend',1,'',0,'QIgjj',0),(63,'',17,1,'WdminPage/area_ans','areaans',1,'',0,'1rH4Y2',0),(64,'',17,1,'WdminPage/user_ans','用户ans',1,'',0,'1f5qR4',0),(65,'',17,1,'WdminPage/com_sale','com销售',1,'',0,'p2riJ',0),(66,'',17,1,'WdminPage/overview','overview',1,'',0,'Qm0XE2',0),(67,'',17,1,'WdminPage/customer_profile','用户profile',1,'',0,'bxHBT1',0),(68,'',17,1,'WdminPage/alter_brand','弹出品牌',1,'',0,'dOx1R',0),(69,'',17,1,'WdminPage/alter_product_brand','弹出产品品牌',1,'',0,'mUWGi',0),(70,'',17,1,'WdminPage/corporation','corporation',1,'',0,'1Lyaj3',0),(71,'',17,1,'WdminPage/addEnterprise','新增enterprise',1,'',0,'1D8NL3',0),(72,'',17,1,'WdminPage/settings_banners','设置广告图s',1,'',0,'e70Za1',0),(73,'',17,1,'WdminPage/settings_banner_edit','设置广告图编辑',1,'',0,'nKQSR',0),(74,'',17,1,'WdminPage/settings_ads','设置ads',1,'',0,'mQjhR',0),(75,'',17,1,'WdminPage/settings_expfee','设置expfee',1,'',0,'gdbp81',0),(76,'',17,1,'WdminPage/user_level','用户级别',1,'',0,'GkV182',0),(77,'',17,1,'WdminPage/settings_alter_envs','设置弹出红包',1,'',0,'3KgKX1',0),(78,'',17,1,'WdminPage/settings_envs','设置红包',1,'',0,'KHl29',0),(79,'',17,1,'WdminPage/settings_auth','设置认证',1,'',0,'01U8b',0),(80,'',17,1,'WdminPage/auth_edit','认证编辑',1,'',0,'Di2NA2',0),(81,'',17,1,'WdminPage/user_envsend','用户红包发送',1,'',0,'vPVat',0),(82,'',17,1,'WdminPage/settings_expcompany','设置exp公司',1,'',0,'CezWh',0),(83,'',17,1,'WdminPage/alter_section','弹出section',1,'',0,'1lTnv3',0),(84,'',17,1,'WdminPage/settings_section','设置section',1,'',0,'35VWj1',0),(85,'',17,1,'WdminPage/settings_envs_robb','设置红包robb',1,'',0,'1mf2e3',0),(86,'',17,1,'WdminPage/envsRobList','红包rob列表',1,'',0,'jITG',0),(87,'',17,1,'WdminPage/gmess_category','素材分类',1,'',0,'1dZUA3',0),(88,'',17,1,'WdminPage/suppliers_list','suppliers列表',1,'',0,'creGu1',0),(89,'',17,1,'WdminPage/credit_exchange','信用卡ex改变',1,'',0,'qjqvx1',0),(90,'',17,1,'WdminPage/user_feedbacks','用户反馈s',1,'',0,'1VRk23',0),(91,'',17,1,'WdminPage/orders_withdrawal','订单withdrawal',1,'',0,'m7IPe',0),(92,'',17,1,'WdminPage/orders_express_record','订单物流记录',1,'',0,'o8Kv41',0),(93,'',17,1,'WdminPage/settings_navigation','设置导航',1,'',0,'1ij9c2',0),(94,'',17,1,'WdminPage/alter_navigation','弹出导航',1,'',0,'1t0Hx3',0),(95,'',17,1,'WdminPage/order_stat','订单信息',1,'',0,'tHyIm1',0),(96,'',17,1,'WdminPage/company_tree','公司tree',1,'',0,'9pUbT',0),(97,'',17,1,'WdminPage/company_rebates','公司回扣',1,'',0,'6lZO22',0),(98,'',17,1,'WdminPage/company_rebates_record','公司回扣记录',1,'',0,'5esw01',0),(99,'',17,1,'WdminPage/company_setting','公司设置ting',1,'',0,'1wJw93',0),(100,'',17,1,'WdminPage/company_level','公司级别',1,'',0,'YAymm1',0),(101,'',17,1,'WdminPage/user_balance_record','用户流水记录',1,'',0,'1d9zW4',0),(102,'',17,1,'WdminPage/user_credit_record','用户信用卡记录',1,'',0,'2Ae5L2',0),(103,'',0,0,'WdminStat','',1,'',0,'1bV3E4',0),(104,'',103,1,'WdminStat/update_wechat_stat','更新微信信息',1,'',0,'1tpCi3',0),(105,'',103,1,'WdminStat/check_wechat_stat_status','检查微信信息状态',1,'',0,'10c4D4',0),(106,'',103,1,'WdminStat/getSaleStat','获取销售信息',1,'',0,'uwQK42',0),(107,'',103,1,'WdminStat/getSalePercent','获取销售所占比',1,'',0,'1Ndxr2',0),(108,'',103,1,'WdminStat/getHotSaleProduct','获取热销产品',1,'',0,'1LEeX3',0),(109,'',103,1,'WdminStat/getUserStat','获取用户信息',1,'',0,'1688H3',0),(110,'',103,1,'WdminStat/getUserSexPercent','获取用户sex所占比',1,'',0,'u5AYG2',0),(111,'',103,1,'WdminStat/getHotBuyUser','获取hotbuy用户',1,'',0,'1Gh7o3',0),(112,'',103,1,'WdminStat/getCompanyUserPercent','获取公司用户所占比',1,'',0,'5x3lY1',0),(113,'',0,0,'wBoard','',1,'',0,'1NCwX4',0),(114,'',113,1,'wBoard/getList','获取列表',1,'',0,'L7JIG1',0),(115,'',113,1,'wBoard/addBoard','新增board',1,'',0,'1faTc4',0),(116,'',113,1,'wBoard/deleteBoard','删除board',1,'',0,'1tLgn3',0),(117,'',0,0,'wBrands','',1,'',0,'WtmHH2',0),(118,'',117,1,'wBrands/vBrand','v品牌',1,'',0,'1rHwg3',0),(119,'',117,1,'wBrands/create','新增',1,'',0,'8UaBu',0),(120,'',117,1,'wBrands/set','设置',1,'',0,'1TRKS4',0),(121,'',117,1,'wBrands/del','删除',1,'',0,'1BT7Z4',0),(122,'',117,1,'wBrands/gets','获取',1,'',0,'cxss2',0),(123,'',117,1,'wBrands/uploadImage','上传图片',1,'',0,'1OxBf2',0),(124,'',0,0,'wCompany','',1,'',0,'1Ke154',0),(125,'',124,1,'wCompany/getInfo','获取信息',1,'',0,'1W48p3',0),(126,'',124,1,'wCompany/modify','修改',1,'',0,'JdTW32',0),(127,'',124,1,'wCompany/getList','获取列表',1,'',0,'QuRXk1',0),(128,'',124,1,'wCompany/deleteCompany','删除公司',1,'',0,'uOdtV1',0),(129,'',124,1,'wCompany/getUnVerifedCount','获取un已验证数目',1,'',0,'aASeA2',0),(130,'',124,1,'wCompany/getVerifedCount','获取已验证数目',1,'',0,'16ufT2',0),(131,'',124,1,'wCompany/companyReqDeny','公司reqdeny',1,'',0,'1FveS4',0),(132,'',124,1,'wCompany/setCompanyAgreement','设置公司agreement',1,'',0,'15jAO2',0),(133,'',0,0,'wCompanyLevel','',1,'',0,'1hCkM4',0),(134,'',133,1,'wCompanyLevel/deleteLevel','删除级别',1,'',0,'wd0mP',0),(135,'',133,1,'wCompanyLevel/modi','修改',1,'',0,'12Vjl2',0),(136,'',133,1,'wCompanyLevel/getInfo','获取信息',1,'',0,'11jOZ3',0),(137,'',133,1,'wCompanyLevel/getList','获取列表',1,'',0,'UH4HQ1',0),(138,'',133,1,'wCompanyLevel/getListAll','获取列出所有',1,'',0,'TUR8i1',0),(139,'',0,0,'wCredit','',1,'',0,'MxQ7Y',0),(140,'',139,1,'wCredit/modify','修改',1,'',0,'15guf3',0),(141,'',139,1,'wCredit/delete','删除',1,'',0,'UR866',0),(142,'',139,1,'wCredit/add','新增',1,'',0,'7Xeek',0),(143,'',0,0,'wEnvs','',1,'',0,'1oWpr3',0),(144,'',143,1,'wEnvs/send','发送',1,'',0,'yua4n1',0),(145,'',0,0,'wFeedBack','',1,'',0,'1OFir2',0),(146,'',145,1,'wFeedBack/getList','获取列表',1,'',0,'lsjHK',0),(147,'',145,1,'wFeedBack/deleteFeedBack','删除反馈',1,'',0,'KOQFD2',0),(148,'',0,0,'wGmess','',1,'',0,'zyoT8',0),(149,'',148,1,'wGmess/getGmessList','获取素材列表',1,'',0,'1lrVx3',0),(150,'',148,1,'wGmess/ajaxDelByMsgId','动态删除通过msgid',1,'',0,'6N4zD1',0),(151,'',148,1,'wGmess/gmess_edit','素材编辑',1,'',0,'1cyfC4',0),(152,'',148,1,'wGmess/getCloudCategorys','获取云分类s',1,'',0,'1Qm403',0),(153,'',148,1,'wGmess/getCloudList','获取云列表',1,'',0,'1ixCH4',0),(154,'',148,1,'wGmess/cloneGmess','克隆素材',1,'',0,'809T4',0),(155,'',148,1,'wGmess/sendGmessNWay','发送素材nway',1,'',0,'14TOe4',0),(156,'',148,1,'wGmess/alterGmessPage','弹出素材页',1,'',0,'AqSGv1',0),(157,'',148,1,'wGmess/sendGemss','发送gemss',1,'',0,'dxyLS1',0),(158,'',0,0,'wImages','',1,'',0,'1jAX94',0),(159,'',158,1,'wImages/ImageUpload','图片上传',1,'',0,'1e85M2',0),(160,'',0,0,'wOrder','',1,'',0,'frliY1',0),(161,'',160,1,'wOrder/order_exports','订单导出',1,'',0,'1quvL2',0),(162,'',160,1,'wOrder/getOrderInfo','获取订单信息',1,'',0,'19A1j2',0),(163,'',160,1,'wOrder/getOrderList','获取订单列表',1,'',0,'gv2MV',0),(164,'',160,1,'wOrder/deleteOrder','删除订单',1,'',0,'1l8UQ3',0),(165,'',160,1,'wOrder/ajaxGetOrderStatnums','动态获取订单数目',1,'',0,'aAY852',0),(166,'',160,1,'wOrder/expressSend','物流发送',1,'',0,'1f5jI4',0),(167,'',160,1,'wOrder/getExpressCompanys','获取物流公司s',1,'',0,'1KofS2',0),(168,'',160,1,'wOrder/getExpressStaff','获取物流staff',1,'',0,'1cVTp3',0),(169,'',160,1,'wOrder/getExpressStaffHistroy','获取物流staffhistroy',1,'',0,'1BDhS3',0),(170,'',160,1,'wOrder/ajaxLoadOrderExpress','动态加载订单物流',1,'',0,'jCauk',0),(171,'',160,1,'wOrder/get_refund_record','获取退款记录',1,'',0,'wLduC1',0),(172,'',160,1,'wOrder/refund','退款',1,'',0,'18xA64',0),(173,'',160,1,'wOrder/getExpressRecords','获取物流记录s',1,'',0,'wVY9D2',0),(174,'',160,1,'wOrder/getStatList','获取tat列表',1,'',0,'1MCsv3',0),(175,'',160,1,'wOrder/getOrderAddresses','获取订单地址',1,'',0,'1Y4WS4',0),(176,'',160,1,'wOrder/orderPayed','订单已支付',1,'',0,'BcBik1',0),(177,'',0,0,'wProduct','',1,'',0,'ZWN8D1',0),(178,'',177,1,'wProduct/ajax_product_list_stock','动态产品列表库存',1,'',0,'1K0Is2',0),(179,'',177,1,'wProduct/ajax_product_list','动态产品列表',1,'',0,'1bD6d4',0),(180,'',177,1,'wProduct/switchOnline','切换在线',1,'',0,'1ygYh2',0),(181,'',177,1,'wProduct/ajaxGetCategroys','动态获取categroys',1,'',0,'1ljas3',0),(182,'',177,1,'wProduct/ajaxAlterCategroy','动态弹出categroy',1,'',0,'14uWb4',0),(183,'',177,1,'wProduct/ajaxDelCategroy','动态删除categroy',1,'',0,'1cBJF3',0),(184,'',177,1,'wProduct/generateStaticDesc','生成静态desc',1,'',0,'1PqHR4',0),(185,'',177,1,'wProduct/productReverse','产品reverse',1,'',0,'1YVqV2',0),(186,'',177,1,'wProduct/removeProduct','删除产品',1,'',0,'1ld5Q2',0),(187,'',177,1,'wProduct/ajaxAddCategroy','动态新增categroy',1,'',0,'1Le2i2',0),(188,'',177,1,'wProduct/ImageUpload','图片上传',1,'',0,'hTj3j1',0),(189,'',0,0,'wRebate','',1,'',0,'E72xB',0),(190,'',189,1,'wRebate/getRebateList','获取回扣列表',1,'',0,'f7FHb',0),(191,'',189,1,'wRebate/getRebateRules','获取回扣规则s',1,'',0,'1NR5a2',0),(192,'',189,1,'wRebate/checkRebate','检查回扣',1,'',0,'kTsHH1',0),(193,'',189,1,'wRebate/alterRuleInfo','弹出规则信息',1,'',0,'pGoBl',0),(194,'',189,1,'wRebate/deleteRule','删除规则',1,'',0,'jRpTa',0),(195,'',189,1,'wRebate/comfirmRebate','确认回扣',1,'',0,'ExbFd1',0),(196,'',189,1,'wRebate/rebateCheck','回扣检查',1,'',0,'1haZK3',0),(197,'',189,1,'wRebate/getRebateCount','获取回扣数目',1,'',0,'1obAM2',0),(198,'',0,0,'wSettings','',1,'',0,'aWTSD',0),(199,'',198,1,'wSettings/updateSettings','更新设置',1,'',0,'uFwB31',0),(200,'',198,1,'wSettings/ajaxGetSettings','动态获取ettings',1,'',0,'1CWT93',0),(201,'',198,1,'wSettings/ajaxGetExpTemplate','动态获取物流模板',1,'',0,'1T8en3',0),(202,'',198,1,'wSettings/updateExpTemplate','更新物流模板',1,'',0,'1mWFc2',0),(203,'',198,1,'wSettings/addEnvs','新增红包',1,'',0,'AVDS92',0),(204,'',198,1,'wSettings/delteEnvs','删除te红包',1,'',0,'1y8Bd2',0),(205,'',198,1,'wSettings/alterSection','弹出section',1,'',0,'1tJGT4',0),(206,'',198,1,'wSettings/clearEnvsRobRecord','清除红包rob记录',1,'',0,'JFIui',0),(207,'',198,1,'wSettings/ajaxAlterEnvs','动态弹出红包',1,'',0,'osWs92',0),(208,'',198,1,'wSettings/deleteEnvsRob','删除红包rob',1,'',0,'1gJ674',0),(209,'',198,1,'wSettings/getAccount','获取账户',1,'',0,'1cDJ43',0),(210,'',198,1,'wSettings/getAccounts','获取账户s',1,'',0,'1G9FM2',0),(211,'',198,1,'wSettings/deleteAuth','删除认证',1,'',0,'1hZnA3',0),(212,'',198,1,'wSettings/addAuth','新增认证',1,'',0,'U5P0W1',0),(213,'',198,1,'wSettings/alterNavigation','弹出导航',1,'',0,'7PPjs',0),(214,'',198,1,'wSettings/ajaxGetWechatMenu','动态获取微信菜单',1,'',0,'1GGgv3',0),(215,'',0,0,'wSupplier','',1,'',0,'lu9e92',0),(216,'',215,1,'wSupplier/delete','删除',1,'',0,'1hJJr2',0),(217,'',215,1,'wSupplier/modi','修改',1,'',0,'n9ZlK1',0),(218,'',0,0,'wSystem','',1,'',0,'1ic3j3',0),(219,'',218,1,'wSystem/logs','日志',1,'',0,'1kZg44',0),(220,'',218,1,'wSystem/getSystemLogs','获取系统日志',1,'',0,'U32pK2',0),(221,'',0,0,'wUser','',1,'',0,'10ihM2',0),(222,'',221,1,'wUser/getUserList','获取用户列表',1,'',0,'135bA3',0),(223,'',221,1,'wUser/getUserCount','获取用户数目',1,'',0,'BHYzy1',0),(224,'',221,1,'wUser/getUserLevel','获取用户级别',1,'',0,'aW1072',0),(225,'',221,1,'wUser/getUserLevelInfo','获取用户级别信息',1,'',0,'1VKLL3',0),(226,'',221,1,'wUser/alterUserLevelInfo','弹出用户级别信息',1,'',0,'1fNwr2',0),(227,'',221,1,'wUser/deleteLevel','删除级别',1,'',0,'1nzzM3',0),(228,'',221,1,'wUser/deleteUser','删除用户',1,'',0,'9vOJA2',0),(229,'',221,1,'wUser/getUserInfo','获取用户信息',1,'',0,'Lkm3d',0),(230,'',221,1,'wUser/alterUser','弹出用户',1,'',0,'a79eG1',0),(231,'',221,1,'wUser/user_exports','用户导出',1,'',0,'WRwBh',0),(232,'',221,1,'wUser/getUserBalanceRecord','获取用户流水记录',1,'',0,'aIndA',0),(233,'',221,1,'wUser/getUserCreditRecord','获取用户信用卡记录',1,'',0,'3jYuD2',0),(234,'',0,0,'wWithdrawal','',1,'',0,'x07NI2',0),(235,'',234,1,'wWithdrawal/getList','获取列表',1,'',0,'gYEkd1',0),(236,'',234,1,'wWithdrawal/audit','audit',1,'',0,'1Zdwe4',0);
/*!40000 ALTER TABLE `auth_rule` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_addresses`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_addresses` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`uname` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`dist` varchar(255) DEFAULT NULL,
`addrs` varchar(255) DEFAULT NULL,
`poscode` varchar(32) DEFAULT NULL,
PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户地址信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_addresses`
--
LOCK TABLES `client_addresses` WRITE;
/*!40000 ALTER TABLE `client_addresses` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_addresses` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_autoenvs`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_autoenvs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`envid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户关注自动红包';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_autoenvs`
--
LOCK TABLES `client_autoenvs` WRITE;
/*!40000 ALTER TABLE `client_autoenvs` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_autoenvs` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_balance_records`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_balance_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`amount` double DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`rtype` enum('default','rebate','deposit','withdrawal') DEFAULT 'default',
`rtime` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户余额记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_balance_records`
--
LOCK TABLES `client_balance_records` WRITE;
/*!40000 ALTER TABLE `client_balance_records` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_balance_records` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_bank_card`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_bank_card` (
`id` int(11) NOT NULL,
`uid` int(11) DEFAULT NULL,
`bankname` varchar(255) DEFAULT NULL,
`sub` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`dist` varchar(255) DEFAULT NULL,
`cardno` int(11) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户银行卡数据表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_bank_card`
--
LOCK TABLES `client_bank_card` WRITE;
/*!40000 ALTER TABLE `client_bank_card` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_bank_card` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_cart`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_cart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) NOT NULL COMMENT '用户编号',
`product_id` int(11) NOT NULL COMMENT '商品编号',
`spec_id` int(11) DEFAULT '0' COMMENT '商品规格',
`count` int(11) NOT NULL DEFAULT '1' COMMENT '商品数量',
PRIMARY KEY (`id`),
KEY `index_openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户购物车';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_cart`
--
LOCK TABLES `client_cart` WRITE;
/*!40000 ALTER TABLE `client_cart` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_cart` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_credit_record`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_credit_record` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`amount` int(5) DEFAULT NULL,
`dt` datetime DEFAULT CURRENT_TIMESTAMP,
`reltype` tinyint(2) DEFAULT NULL,
`relid` int(11) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`rtime` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户积分记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_credit_record`
--
LOCK TABLES `client_credit_record` WRITE;
/*!40000 ALTER TABLE `client_credit_record` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_credit_record` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_deposit_order`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_deposit_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`amount` float(11,2) DEFAULT '0.00',
`deposit_time` datetime DEFAULT CURRENT_TIMESTAMP,
`deposit_status` enum('wait','payed') DEFAULT 'wait',
`deposit_serial` varchar(255) DEFAULT NULL COMMENT '订单编号',
`wepay_serial` varchar(255) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_openid` (`openid`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户充值表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_deposit_order`
--
LOCK TABLES `client_deposit_order` WRITE;
/*!40000 ALTER TABLE `client_deposit_order` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_deposit_order` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_envelopes`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_envelopes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`envid` int(11) DEFAULT NULL,
`count` int(11) DEFAULT '0',
`exp` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户红包表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_envelopes`
--
LOCK TABLES `client_envelopes` WRITE;
/*!40000 ALTER TABLE `client_envelopes` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `client_envelopes` VALUES (1,'oIGpIxO4u3TBR5RnABr3EpiSH2o4',1,1,1,'2017-06-02 00:00:00');
/*!40000 ALTER TABLE `client_envelopes` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_envelopes_type`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_envelopes_type` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`type` int(11) DEFAULT '0',
`req_amount` float DEFAULT NULL,
`dis_amount` float DEFAULT NULL,
`pid` varchar(255) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户红包类型表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_envelopes_type`
--
LOCK TABLES `client_envelopes_type` WRITE;
/*!40000 ALTER TABLE `client_envelopes_type` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `client_envelopes_type` VALUES (1,'满100减10块',0,100,10,'2475,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2426,2427,2428,2434,2435,2436,2456,2457,2458,2459,2460','');
/*!40000 ALTER TABLE `client_envelopes_type` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_feedbacks`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_feedbacks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`feedback` text,
`ftime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户反馈信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_feedbacks`
--
LOCK TABLES `client_feedbacks` WRITE;
/*!40000 ALTER TABLE `client_feedbacks` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_feedbacks` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_level`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_level` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`level_name` varchar(255) NOT NULL DEFAULT '',
`level_credit` int(11) NOT NULL,
`level_discount` float DEFAULT NULL,
`level_credit_feed` float DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`upable` tinyint(1) DEFAULT '1',
`isdefault` tinyint(1) DEFAULT '0' COMMENT '是否默认分组',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户分组';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_level`
--
LOCK TABLES `client_level` WRITE;
/*!40000 ALTER TABLE `client_level` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_level` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_message_session`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_message_session` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`unread` int(11) DEFAULT '0',
`undesc` varchar(255) DEFAULT NULL,
`lasttime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniopenid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_message_session`
--
LOCK TABLES `client_message_session` WRITE;
/*!40000 ALTER TABLE `client_message_session` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_message_session` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_messages`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`msgtype` tinyint(2) DEFAULT '0',
`msgcont` text,
`msgdirect` tinyint(4) DEFAULT '0',
`autoreped` tinyint(4) DEFAULT '0',
`send_time` datetime DEFAULT NULL,
`sreaded` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_messages`
--
LOCK TABLES `client_messages` WRITE;
/*!40000 ALTER TABLE `client_messages` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_messages` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_order_address`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_order_address` (
`addr_id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
`tel` varchar(255) NOT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
PRIMARY KEY (`addr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单地址信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_order_address`
--
LOCK TABLES `client_order_address` WRITE;
/*!40000 ALTER TABLE `client_order_address` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_order_address` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_product_likes`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_product_likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) NOT NULL,
`product_id` int(11) NOT NULL,
`like_time` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uni` (`openid`,`product_id`) USING BTREE,
KEY `uopenid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户商品收藏';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_product_likes`
--
LOCK TABLES `client_product_likes` WRITE;
/*!40000 ALTER TABLE `client_product_likes` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_product_likes` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_sign_record`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_sign_record` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`dt` date DEFAULT NULL,
`credit` int(11) DEFAULT NULL,
`openid` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dt` (`dt`,`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户签到记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_sign_record`
--
LOCK TABLES `client_sign_record` WRITE;
/*!40000 ALTER TABLE `client_sign_record` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_sign_record` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_urecord`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_urecord` (
`id` int(11) NOT NULL,
`uid` int(11) DEFAULT NULL,
`amount` float(11,2) DEFAULT NULL,
`ctime` datetime DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_urecord`
--
LOCK TABLES `client_urecord` WRITE;
/*!40000 ALTER TABLE `client_urecord` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_urecord` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `client_withdrawal_order`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_withdrawal_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`openid` varchar(255) NOT NULL,
`amount` float(11,2) NOT NULL DEFAULT '0.00',
`username` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`bankname` varchar(255) DEFAULT NULL,
`subbranch` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`dist` varchar(255) DEFAULT NULL,
`cardno` varchar(255) DEFAULT NULL,
`rtime` datetime DEFAULT CURRENT_TIMESTAMP,
`status` enum('wait','reject','pass') DEFAULT 'wait',
`serial` varchar(255) DEFAULT NULL COMMENT '订单编号',
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_openid` (`openid`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户提现表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `client_withdrawal_order`
--
LOCK TABLES `client_withdrawal_order` WRITE;
/*!40000 ALTER TABLE `client_withdrawal_order` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `client_withdrawal_order` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `clients`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
`client_id` int(25) NOT NULL AUTO_INCREMENT COMMENT '会员卡号',
`client_nickname` varchar(512) NOT NULL,
`client_name` varchar(512) NOT NULL COMMENT '会员姓名',
`client_sex` varchar(1) DEFAULT NULL COMMENT '会员性别',
`client_phone` varchar(20) NOT NULL DEFAULT '' COMMENT '会员电话',
`client_email` varchar(255) DEFAULT NULL,
`client_head` varchar(255) DEFAULT NULL,
`client_head_lastmod` datetime DEFAULT NULL,
`client_password` varchar(255) DEFAULT '' COMMENT '会员密码',
`client_level` tinyint(3) DEFAULT '0' COMMENT '会员种类\\r\\n1为普通会员\\r\\n0为合作商',
`client_wechat_openid` varchar(50) NOT NULL DEFAULT '' COMMENT '会员微信openid',
`client_joindate` date NOT NULL,
`client_province` varchar(60) DEFAULT NULL,
`client_city` varchar(60) DEFAULT NULL,
`client_address` varchar(60) DEFAULT '' COMMENT '会员住址',
`client_money` float(15,2) NOT NULL DEFAULT '0.00' COMMENT '会员存款',
`client_credit` int(15) NOT NULL DEFAULT '0' COMMENT '会员积分',
`client_remark` varchar(255) DEFAULT '' COMMENT '会员备注',
`client_groupid` int(11) DEFAULT '0',
`client_storeid` int(10) DEFAULT '0' COMMENT '会员所属店号',
`client_personid` varchar(255) DEFAULT NULL,
`client_comid` int(11) DEFAULT '0' COMMENT '代理编号',
`client_autoenvrec` tinyint(4) DEFAULT '0',
`client_overdraft_amount` float(11,2) DEFAULT '0.00' COMMENT '用户信用总额',
`is_com` tinyint(4) DEFAULT '0',
`deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (`client_id`),
UNIQUE KEY `index_openid` (`client_wechat_openid`) USING BTREE,
KEY `index_comid` (`client_comid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `clients`
--
LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `clients` VALUES (1,'Zsoner','Zsoner','m','','','http://wx.qlogo.cn/mmopen/zRLVLaGEokVW2e9kT1mPMHviaurKYoD1tETRXWPGU5hmGR6gSUlQTkzIJ6rcwhcjQib2wjQ8Uos2wCZo2Uico0osibma9UibT1v4q','2016-07-22 09:29:03','',0,'oIGpIxO4u3TBR5RnABr3EpiSH2o4','2016-07-22','浙江','宁波','浙江宁波',0.00,0,'',0,0,'',0,0,0.00,1,0);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `company_bills`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_bills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`comid` int(11) DEFAULT NULL,
`bill_amount` float(10,2) DEFAULT NULL,
`bill_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代理账单信息, 废弃';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_bills`
--
LOCK TABLES `company_bills` WRITE;
/*!40000 ALTER TABLE `company_bills` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `company_bills` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `company_income_record`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_income_record` (
`record_id` int(11) NOT NULL AUTO_INCREMENT,
`amount` float(11,2) NOT NULL DEFAULT '0.00',
`date` datetime NOT NULL,
`client_id` int(11) DEFAULT NULL,
`order_id` int(11) NOT NULL,
`com_id` varchar(255) NOT NULL,
`pcount` int(11) NOT NULL,
`is_seted` tinyint(4) DEFAULT '0',
`is_reqed` tinyint(4) DEFAULT '0',
PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代理收入记录, 废弃';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_income_record`
--
LOCK TABLES `company_income_record` WRITE;
/*!40000 ALTER TABLE `company_income_record` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `company_income_record` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `company_level`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_level` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`level_name` varchar(255) NOT NULL DEFAULT '',
`level_discount` float(11,2) DEFAULT NULL,
`level_rebate_point` float(11,2) DEFAULT '0.00',
`level_remark` varchar(255) DEFAULT NULL,
`level_addtime` datetime DEFAULT CURRENT_TIMESTAMP,
`upable` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='代理等级';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_level`
--
LOCK TABLES `company_level` WRITE;
/*!40000 ALTER TABLE `company_level` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `company_level` VALUES (1,'默认分组',0.98,0.00,'','2016-07-21 18:07:57',1);
/*!40000 ALTER TABLE `company_level` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `company_rebate_rules`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_rebate_rules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level_id` int(11) DEFAULT '0',
`level_name` varchar(255) DEFAULT NULL,
`rule_name` varchar(255) DEFAULT NULL COMMENT '规则名称',
`rebate_level` tinyint(2) DEFAULT '1',
`rebate_type` enum('amount','percent') DEFAULT 'amount' COMMENT '返佣方式, 固定金额或比例',
`rebate_amount` float(11,2) DEFAULT NULL,
`addtime` datetime DEFAULT CURRENT_TIMESTAMP,
`remark` varchar(255) DEFAULT NULL,
`enabled` tinyint(1) DEFAULT '1' COMMENT '是否启用此规则',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代理返佣规则';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_rebate_rules`
--
LOCK TABLES `company_rebate_rules` WRITE;
/*!40000 ALTER TABLE `company_rebate_rules` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `company_rebate_rules` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `company_users`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`openid` varchar(255) DEFAULT NULL,
`comid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniopenid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代理和用户关联信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_users`
--
LOCK TABLES `company_users` WRITE;
/*!40000 ALTER TABLE `company_users` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `company_users` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `companys`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companys` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0' COMMENT '代理的用户编号',
`gid` int(11) DEFAULT '0' COMMENT '组ID',
`parent` int(11) DEFAULT '0',
`name` varchar(200) NOT NULL,
`email` varchar(100) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`join_date` datetime DEFAULT CURRENT_TIMESTAMP,
`openid` varchar(255) DEFAULT NULL,
`money` float DEFAULT '0',
`alipay` varchar(255) DEFAULT NULL,
`bank_name` varchar(255) DEFAULT NULL,
`bank_account` varchar(255) DEFAULT NULL,
`bank_personname` varchar(255) DEFAULT NULL,
`person_id` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`deleted` tinyint(4) NOT NULL DEFAULT '0',
`utype` tinyint(4) DEFAULT '0' COMMENT '已废弃字段',
`verifed` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uniuid` (`uid`),
UNIQUE KEY `uniname` (`name`,`email`,`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='代理信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `companys`
--
LOCK TABLES `companys` WRITE;
/*!40000 ALTER TABLE `companys` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `companys` VALUES (1,1,1,0,'曾松林','5415@qq.com','18357082542','2016-07-22 09:43:43','oIGpIxO4u3TBR5RnABr3EpiSH2o4',0,'','','','','','',0,0,1);
/*!40000 ALTER TABLE `companys` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `envs_robblist`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `envs_robblist` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`on` int(11) DEFAULT NULL,
`remains` int(11) DEFAULT NULL,
`envsid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `envs_robblist`
--
LOCK TABLES `envs_robblist` WRITE;
/*!40000 ALTER TABLE `envs_robblist` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `envs_robblist` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `envs_robrecord`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `envs_robrecord` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`envsid` int(11) DEFAULT NULL,
`eid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `envs_robrecord`
--
LOCK TABLES `envs_robrecord` WRITE;
/*!40000 ALTER TABLE `envs_robrecord` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `envs_robrecord` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `express_record`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `express_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) DEFAULT NULL,
`confirm_time` datetime DEFAULT NULL,
`send_time` datetime DEFAULT NULL,
`costs` varchar(255) DEFAULT '0' COMMENT '配送时效',
`openid` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `express_record`
--
LOCK TABLES `express_record` WRITE;
/*!40000 ALTER TABLE `express_record` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `express_record` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `gmess_category`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmess_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat_name` varchar(255) NOT NULL,
`parent` int(11) DEFAULT '0',
`sort` tinyint(4) DEFAULT NULL,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gmess_category`
--
LOCK TABLES `gmess_category` WRITE;
/*!40000 ALTER TABLE `gmess_category` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `gmess_category` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `gmess_page`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmess_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`content` text,
`desc` varchar(255) DEFAULT NULL,
`catimg` varchar(255) DEFAULT NULL,
`thumb_media_id` varchar(255) DEFAULT NULL,
`content_source_url` varchar(255) DEFAULT NULL COMMENT '原文链接',
`media_id` varchar(255) DEFAULT NULL,
`createtime` date DEFAULT NULL,
`category` int(11) DEFAULT NULL,
`deleted` tinyint(4) DEFAULT '0',
`hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数目',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gmess_page`
--
LOCK TABLES `gmess_page` WRITE;
/*!40000 ALTER TABLE `gmess_page` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `gmess_page` VALUES (1,'加盟味趣,大有所为','<p><img src=\\"http://www.shop.com/uploads/default/8da6/c416a/8da614c04a2b12f16b219dae959993c0.jpg\\" _src=\\"http://www.shop.com/uploads/default/8da6/c416a/8da614c04a2b12f16b219dae959993c0.jpg\\" style=\\"\\"/></p><p><br/></p><p><br/></p><p><img src=\\"http://www.shop.com/uploads/default/0860/e3c06/0860c3eb4544ed13ad723a1d7e04b653.jpg\\" _src=\\"http://www.shop.com/uploads/default/0860/e3c06/0860c3eb4544ed13ad723a1d7e04b653.jpg\\" style=\\"\\"/></p><p><br/></p><p><br/></p><p><img src=\\"http://www.shop.com/uploads/default/9231/04f13/9231f40c176224c1cb917a77957ff560.jpg\\" _src=\\"http://www.shop.com/uploads/default/9231/04f13/9231f40c176224c1cb917a77957ff560.jpg\\" style=\\"\\"/></p><p><br/></p><p><br/></p><p><img src=\\"http://www.shop.com/uploads/default/f4f5/f245f/f4f542f712cda28a29392d9365bede4e.jpg\\" _src=\\"http://www.shop.com/uploads/default/f4f5/f245f/f4f542f712cda28a29392d9365bede4e.jpg\\" style=\\"\\"/></p><p><br/></p><p><br/></p><p>点击下载2016年7月最新内部招商计划书</p><p><a href=\\"http://www.baidu.com\\" target=\\"_self\\"><span style=\\"font-family: 微软雅黑, 'Microsoft YaHei'; font-size: 24px; color: rgb(155, 187, 89);\\">点击此处下载 <span style=\\"color: rgb(155, 187, 89); font-family: 微软雅黑, 'Microsoft YaHei'; font-size: 24px;\\">《</span>深圳前海味趣网络科技有限公司(最新合伙人计划书-0712-F).pptx》</span></a></p><p><span style=\\"font-family: 微软雅黑, 'Microsoft YaHei'; font-size: 14px;\\">温馨提示:建议在WIFI环境下进行下载!!</span></p>','','/uploads/default/9c78/1bc87/9c78cb159ca87563dd11bd0de8c5c06c.png','n_Byb8IU9yBsG2WRoNRFTmKVPIfqQNqh7nVdq8Jy3Wu-IjrppNZtYHGUfXZ9MxKU','','HGy7Ai78Xz0x_jcAE8Uwca4Ga6BPYvFe7xx3oUQouSJty0OmcjBkfl2hZ-VZRxon','2016-07-25',NULL,0,56),(2,'认识味趣','<p style=\\"color: rgb(0, 0, 0); white-space: normal; text-indent: 2em; line-height: 2em;\\"><span style=\\"font-family: 微软雅黑, 'Microsoft YaHei';\\">‍‍味趣网络,专注于厨房健康食材的深耕与服务,满足用户日益增长的对“味”的需求与渴望,让人们放心用“料”、安心用“料”、省心用“料”</span></p><p style=\\"color: rgb(0, 0, 0); white-space: normal; text-indent: 2em; line-height: 2em;\\"><span style=\\"font-family: 微软雅黑, 'Microsoft YaHei';\\">味趣网络自成立以来,本着三高(高品质、高效率、高服务)三低(低成本、低毛利、低价格)的经营理念以及对健康食材、对调味品业的深度理解与专致,发展迅速,已成功搭建PC+移动端+第三方线上平台、线下贸易、实体连锁体系以及大数据服务与分析系统;支撑线上线下的高效运转,并在东莞市细村市场、大岭山信立农批市场、东莞市南城区设立了分公司,体验店与大型仓库中心;立足珠三角,深耕广东,布局全国,现已放开加盟店合作条件。</span></p><p style=\\"color: rgb(0, 0, 0); white-space: normal; text-indent: 2em; line-height: 2em;\\"><span style=\\"font-family: 微软雅黑, 'Microsoft YaHei';\\">用真诚的态度、用诚心的价格,用贴心的服务,味趣网络,值得您长期信赖的合作伙伴!</span></p><p style=\\"color: rgb(0, 0, 0); line-height: normal; white-space: normal;\\"><br/></p><p><br/></p>','‍‍味趣网络,专注于厨房健康食材的深耕与服务,满足用户日益增长的对“味”的需求与渴望,让人们放心用“料”、安心用“料”、省心用“料”。','/uploads/images/logo-640.png','LQFgYe6nxtZg6o5MA_yG3OlvRp6pHLN24QKS8WKgEQWhhSrQ_FlICIQ-P0zWS32a','','TNFW5uOZ3uZHizQ32HVSNzbRBHmmeZ0mAdjY_TpA87VOb04TgOFQaiUSe8sRGdq0','2016-07-25',NULL,0,64);
/*!40000 ALTER TABLE `gmess_page` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `gmess_send_stat`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmess_send_stat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg_id` int(11) NOT NULL,
`send_date` datetime DEFAULT NULL,
`send_count` int(11) DEFAULT NULL,
`read_count` int(11) DEFAULT '0',
`share_count` int(11) DEFAULT '0',
`receive_count` int(11) DEFAULT NULL,
`send_type` tinyint(4) DEFAULT '0',
`msg_type` enum('text','images') DEFAULT 'images',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gmess_send_stat`
--
LOCK TABLES `gmess_send_stat` WRITE;
/*!40000 ALTER TABLE `gmess_send_stat` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `gmess_send_stat` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `gmess_tasks`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmess_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gmess_id` int(11) NOT NULL,
`task_time` int(11) DEFAULT '0',
`task_exec_time` int(11) DEFAULT '0',
`task_finish_time` datetime DEFAULT NULL,
`admin_id` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gmess_tasks`
--
LOCK TABLES `gmess_tasks` WRITE;
/*!40000 ALTER TABLE `gmess_tasks` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `gmess_tasks` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `group_buy`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_buy` (
`tuan_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '团购ID',
`tuan_title` varchar(255) NOT NULL COMMENT '团购标题',
`product_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
`tuan_picture` varchar(100) NOT NULL COMMENT '团购图片',
`tuan_start_time` datetime NOT NULL COMMENT '活动开始时间',
`tuan_end_time` datetime NOT NULL COMMENT '活动结束时间',
`tuan_deposit_price` decimal(10,3) NOT NULL DEFAULT '0.000' COMMENT '定金',
`tuan_per_number` int(10) NOT NULL DEFAULT '0' COMMENT '每人限购数量',
`tuan_send_point` int(11) NOT NULL DEFAULT '0' COMMENT '赠送积分数',
`tuan_number` int(10) NOT NULL DEFAULT '0' COMMENT '限购数量',
`tuan_pre_number` int(10) NOT NULL DEFAULT '0' COMMENT '虚拟购买数量',
`tuan_desc` text NOT NULL COMMENT '团购介绍',
`tuan_goodshow_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否显示商品详情',
`tuan_now_number` int(10) NOT NULL DEFAULT '0' COMMENT '已团购数量',
`tuan_order` int(10) NOT NULL DEFAULT '0' COMMENT '显示次序',
`tuan_create_time` datetime NOT NULL COMMENT '团购创建时间',
`tuan_update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '团购更新时间',
`tuan_price` decimal(10,3) DEFAULT '0.000' COMMENT '团购价',
`tuan_bid` int(11) NOT NULL DEFAULT '0' COMMENT '团购所属品牌类目',
`tuan_cid` int(11) NOT NULL DEFAULT '0' COMMENT '团购所属分类',
`tuan_baoyou` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包邮:0:不包邮;1:包邮',
`tuan_remark` varchar(255) DEFAULT NULL COMMENT '团购简介',
`tuan_start_code` tinyint(1) DEFAULT '0' COMMENT '是否启用验证码',
`overdue_start_time` datetime NOT NULL COMMENT '补交余款开始时间',
`overdue_end_time` datetime NOT NULL COMMENT '补交余款结束时间',
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
`is_deposit` tinyint(1) DEFAULT '0' COMMENT '是否启用担保金',
`is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`tuan_id`),
KEY `is_active` (`is_active`),
KEY `sort_order` (`tuan_order`),
KEY `tuan_start_time` (`tuan_start_time`),
KEY `tuan_end_time` (`tuan_end_time`),
KEY `product_id` (`product_id`),
KEY `tuan_goodshow_status` (`tuan_goodshow_status`),
KEY `overdue_start_time` (`overdue_start_time`),
KEY `overdue_end_time` (`overdue_end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品团购表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_buy`
--
LOCK TABLES `group_buy` WRITE;
/*!40000 ALTER TABLE `group_buy` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `group_buy` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `group_buy_log`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_buy_log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) NOT NULL COMMENT '订单ID',
`tuan_id` int(10) NOT NULL DEFAULT '0' COMMENT '团购ID',
`client_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员ID',
`product_id` int(10) NOT NULL COMMENT '商品ID',
`num` int(4) NOT NULL DEFAULT '0' COMMENT '购买数量。取值范围:大于零的整数',
`remark` varchar(200) NOT NULL COMMENT '备注',
PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='团购日志记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_buy_log`
--
LOCK TABLES `group_buy_log` WRITE;
/*!40000 ALTER TABLE `group_buy_log` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `group_buy_log` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `order_credit_available`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_credit_available` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cfrom` float(5,2) DEFAULT NULL,
`cto` float(5,2) DEFAULT NULL,
`credit` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_credit_available`
--
LOCK TABLES `order_credit_available` WRITE;
/*!40000 ALTER TABLE `order_credit_available` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `order_credit_available` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `order_rebates`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_rebates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`comid` int(11) DEFAULT NULL,
`order_id` int(11) DEFAULT NULL,
`order_amount` float(11,2) DEFAULT '0.00',
`order_serial` varchar(255) DEFAULT NULL COMMENT '订单流水号',
`order_time` datetime DEFAULT NULL COMMENT '下单时间',
`rebate_amount` float(11,2) DEFAULT '0.00' COMMENT '返佣金额',
`rebate_type` varchar(255) DEFAULT NULL COMMENT '返佣方式',
`rebate_rate` float(11,2) DEFAULT '0.00' COMMENT '返佣比率',
`rebate_level` tinyint(2) DEFAULT '0' COMMENT '返佣级别',
`rtime` datetime DEFAULT CURRENT_TIMESTAMP,
`status` enum('wait','pass','reject') DEFAULT 'wait',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`),
UNIQUE KEY `unique_comid_orderid` (`order_id`,`comid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单返佣表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_rebates`
--
LOCK TABLES `order_rebates` WRITE;
/*!40000 ALTER TABLE `order_rebates` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `order_rebates` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `order_refundment`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_refundment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) DEFAULT NULL,
`serial_number` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`refund_amount` float(10,2) DEFAULT '0.00',
`refund_time` datetime DEFAULT NULL,
`refund_type` tinyint(4) DEFAULT '0',
`refund_serial` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`payment_type` tinyint(2) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_refundment`
--
LOCK TABLES `order_refundment` WRITE;
/*!40000 ALTER TABLE `order_refundment` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `order_refundment` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `orders`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单编号',
`client_id` int(11) DEFAULT NULL COMMENT '客户编号',
`serial_number` varchar(30) DEFAULT NULL,
`order_time` datetime DEFAULT NULL COMMENT '订单交易时间',
`receive_time` datetime DEFAULT NULL COMMENT '收货时间',
`send_time` datetime DEFAULT NULL COMMENT '发货时间',
`order_balance` float(10,2) DEFAULT '0.00' COMMENT '余额抵现',
`order_expfee` float(10,2) DEFAULT '0.00' COMMENT '订单运费',
`order_amount` float(10,2) DEFAULT '0.00' COMMENT '总价',
`order_refund_amount` float(10,2) DEFAULT '0.00',
`order_discounted` float(11,2) DEFAULT '1.00' COMMENT '订单折扣比例',
`supply_price_amount` float(10,2) DEFAULT '0.00',
`original_amount` float(10,2) DEFAULT '0.00',
`company_id` int(11) DEFAULT '0',
`product_count` int(11) DEFAULT '0',
`wepay_serial` varchar(50) DEFAULT NULL,
`wepay_openid` varchar(255) DEFAULT '',
`wepay_unionid` varchar(255) DEFAULT NULL,
`wepayed` tinyint(1) DEFAULT '0' COMMENT '订单是否已支付',
`leword` text,
`status` enum('unpay','payed','received','canceled','closed','refunded','delivering','reqing') NOT NULL DEFAULT 'unpay' COMMENT '订单状态',
`express_openid` varchar(255) DEFAULT NULL,
`express_code` varchar(255) DEFAULT NULL,
`express_com` varchar(255) DEFAULT NULL,
`exptime` varchar(255) DEFAULT NULL,
`envs_id` int(11) DEFAULT '0',
`is_commented` tinyint(1) DEFAULT '0',
`address_hash` varchar(255) DEFAULT NULL,
`supplier_id` int(11) DEFAULT '0',
`rebated` tinyint(1) DEFAULT '0' COMMENT '返佣是否已经处理',
`rebated_amount` float(11,2) DEFAULT '0.00' COMMENT '已经返佣的金额',
PRIMARY KEY (`order_id`),
KEY `openid` (`wepay_openid`) USING BTREE,
KEY `serial_number` (`serial_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `orders_address`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders_address` (
`addr_id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(11) NOT NULL DEFAULT '0',
`order_id` int(11) NOT NULL DEFAULT '0',
`user_name` varchar(255) NOT NULL,
`tel_number` varchar(255) NOT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`hash` varchar(255) DEFAULT NULL,
PRIMARY KEY (`addr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders_address`
--
LOCK TABLES `orders_address` WRITE;
/*!40000 ALTER TABLE `orders_address` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `orders_address` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `orders_comment`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`openid` varchar(255) DEFAULT NULL,
`starts` tinyint(4) DEFAULT NULL,
`content` text,
`mtime` datetime DEFAULT NULL,
`orderid` int(11) DEFAULT NULL,
`anonymous` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `openid` (`openid`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders_comment`
--
LOCK TABLES `orders_comment` WRITE;
/*!40000 ALTER TABLE `orders_comment` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `orders_comment` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `orders_detail`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders_detail` (
`detail_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(20) NOT NULL COMMENT '订单编号',
`product_id` int(20) NOT NULL COMMENT '商品编号',
`product_count` int(10) NOT NULL COMMENT '商品数量',
`product_discount_price` float(11,2) NOT NULL DEFAULT '0.00',
`original_amount` float(11,2) DEFAULT NULL,
`product_price_hash_id` int(11) NOT NULL DEFAULT '0',
`refunded` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders_detail`
--
LOCK TABLES `orders_detail` WRITE;
/*!40000 ALTER TABLE `orders_detail` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `orders_detail` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `product_brand`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_brand` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`brand_name` varchar(255) DEFAULT NULL,
`brand_img1` varchar(255) DEFAULT NULL,
`brand_img2` varchar(255) DEFAULT NULL,
`brand_cat` int(11) DEFAULT NULL,
`sort` tinyint(4) DEFAULT '0',
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uniname` (`brand_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product_brand`
--
LOCK TABLES `product_brand` WRITE;
/*!40000 ALTER TABLE `product_brand` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `product_brand` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `product_category`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_category` (
`cat_id` int(11) NOT NULL AUTO_INCREMENT,
`cat_name` varchar(255) NOT NULL,
`cat_descs` text,
`cat_image` varchar(255) NOT NULL DEFAULT '',
`cat_parent` int(11) NOT NULL DEFAULT '0',
`cat_level` int(11) DEFAULT '0',
`cat_order` int(11) NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用',
PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product_category`
--
LOCK TABLES `product_category` WRITE;
/*!40000 ALTER TABLE `product_category` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `product_category` VALUES (1,'高端酱油',NULL,'/uploads/product_cate/jiangyou.jpg',0,0,0,1),(2,'陈醋白醋',NULL,'/uploads/product_cate/cu.jpg',0,0,0,1),(3,'调味用料',NULL,'/uploads/product_cate/tiaoweiliao.jpg',0,0,0,1),(4,'色油色粉',NULL,'/uploads/product_cate/28.jpg',0,0,0,1),(5,'调味用料',NULL,'/uploads/product_cate/23.jpg',0,0,0,0),(6,'鸡精鸡粉',NULL,'/uploads/product_cate/15.jpg',0,0,0,1),(7,'面包糠',NULL,'/uploads/product_cate/72.jpg',0,0,0,1),(8,'调味香汁',NULL,'/uploads/product_cate/25.jpg',0,0,0,1),(9,'独家特供',NULL,'/uploads/product_cate/wayqu.jpg',0,0,0,1);
/*!40000 ALTER TABLE `product_category` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `product_credit_exanges`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_credit_exanges` (
`product_id` int(11) NOT NULL,
`product_credits` int(11) DEFAULT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product_credit_exanges`
--
LOCK TABLES `product_credit_exanges` WRITE;
/*!40000 ALTER TABLE `product_credit_exanges` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `product_credit_exanges` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
--
-- Table structure for table `product_images`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_images` (
`product_id` int(11) NOT NULL DEFAULT '0',
`image_id` int(11) NOT NULL AUTO_INCREMENT,
`image_path` varchar(512) NOT NULL,
`image_sort` tinyint(4) DEFAULT '0',
`image_type` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`image_id`),
KEY `index_product` (`product_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product_images`
--
LOCK TABLES `product_images` WRITE;
/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `product_images` VALUES (1,1,'uploads/alibaba/9397/9397d7386575a089ba5a8d4f03524660.jpg',0,0),(1,2,'uploads/alibaba/f716/f716e814c63c39d54374ae7f8245c87a.jpg',0,0),(1,3,'uploads/alibaba/c11a/c11aa30ee8284c94dd73e2ba9c34d783.jpg',0,0),(1,4,'uploads/alibaba/f47d/f47d842a207ad82b82711ddbb0ff5d6c.jpg',0,0),(2,5,'uploads/alibaba/170f/170fe89b3e8728707197638d1bbd4f94.jpg',0,0),(2,6,'uploads/alibaba/0c12/0c12c69c16276de7a4bf33a3e1d15a22.jpg',0,0),(2,7,'uploads/alibaba/f54a/f54ab47e18247a09098eec27baafd9a9.jpg',0,0),(2,8,'uploads/alibaba/5577/5577193a6d64b698c588d083d5de52ca.jpg',0,0),(2,9,'uploads/alibaba/eac0/eac040b2cc483edf5754cc02f05b660e.jpg',0,0),(2,10,'uploads/alibaba/f4c7/f4c7344735d40163f658f61033a47b47.jpg',0,0),(2,11,'uploads/alibaba/f4c7/f4c7344735d40163f658f61033a47b47.jpg',0,0),(3,12,'uploads/alibaba/299a/299a1a636bdf1bfa619667e6236af0b4.jpg',0,0),(3,13,'uploads/alibaba/a08c/a08c4546756eb620d169d0129be1330c.jpg',0,0),(3,14,'uploads/alibaba/7e3a/7e3a1d450de6a2f687eb435f34745a9d.jpg',0,0),(3,15,'uploads/alibaba/1185/1185ee081257ed03a8d84bc519a9780b.jpg',0,0),(3,16,'uploads/alibaba/4c30/4c3062c38f719cf01fd21e741725211d.jpg',0,0),(4,17,'uploads/alibaba/76f3/76f3b928e31f344b9c131912eeb9dc6b.jpg',0,0),(4,18,'uploads/alibaba/4952/495245acb0c378d04965f2ebfcd5c188.jpg',0,0),(4,19,'uploads/alibaba/81bd/81bd671cff6e61490b1617999df83bdf.jpg',0,0),(4,20,'uploads/alibaba/c031/c031e5cb8813d7a8726b42edd6b1a110.jpg',0,0),(4,21,'uploads/alibaba/eb1e/eb1e230c6c2cbc97afe365fb48e974bb.jpg',0,0),(4,22,'uploads/alibaba/eb1e/eb1e230c6c2cbc97afe365fb48e974bb.jpg',0,0),(5,23,'uploads/alibaba/bfeb/bfeba6516c6e36234d8a5315fdb1cf88.jpg',0,0),(5,24,'uploads/alibaba/09b3/09b341f91e3df71a77c8af21e71f9d2a.jpg',0,0),(5,25,'uploads/alibaba/5e6b/5e6baf747a172fa5820808d50ec5adfa.jpg',0,0),(5,26,'uploads/alibaba/9360/93600d3ddf264e508a47d4cdf6a685a7.jpg',0,0),(5,27,'uploads/alibaba/1390/13903823314e1848c522609db3f94671.jpg',0,0),(6,28,'uploads/alibaba/da52/da526797f1b1b9362c707739374c3866.jpg',0,0),(6,29,'uploads/alibaba/d15d/d15d510bff8c41f6550d21f75f3060b6.jpg',0,0),(6,30,'uploads/alibaba/b96a/b96a03a2828f907b6ce81b3baa6e9465.jpg',0,0),(6,31,'uploads/alibaba/4487/4487cb9e643be57b96c8487890679145.jpg',0,0),(7,32,'uploads/alibaba/7a68/7a68bf46f35e9bf1a74c59bdf8b1ad93.jpg',0,0),(7,33,'uploads/alibaba/1952/1952bd6f59b0dc05a372afc4d58d9708.jpg',0,0),(7,34,'uploads/alibaba/83bc/83bc51c7b31ec675b88c5476d1eb65c3.jpg',0,0),(7,35,'uploads/alibaba/e568/e568be069fce4e7613489ddb2d93ad15.jpg',0,0),(8,36,'uploads/alibaba/1d2c/1d2cb3c64b24c03ff17a05918e7a80c4.jpg',0,0),(8,37,'uploads/alibaba/74dc/74dc6cd28fa481146baa2b7114aa295b.jpg',0,0),(8,38,'uploads/alibaba/a7a2/a7a25f83998676f7673d514fed8face6.jpg',0,0),(8,39,'uploads/alibaba/1870/1870f3ccabff33b75a3bfbc9466f8cea.jpg',0,0),(9,40,'uploads/alibaba/1fae/1faebb6d0d373422ae9776af1807ab54.jpg',0,0),(9,41,'uploads/alibaba/a321/a321ef9cc82e7e4319cc9c96cb3a4a27.jpg',0,0),(9,42,'uploads/alibaba/e48e/e48ef3ce126abfb1b8ddf79df0124727.jpg',0,0),(9,43,'uploads/alibaba/523a/523a6b84204dfd5cd115f9c4e3cf592d.jpg',0,0),(10,44,'uploads/alibaba/b38c/b38ca25387a4afb71fd75ea17d172239.jpg',0,0),(10,45,'uploads/alibaba/05a8/05a82b6ab5d55e626670a113c45d7ede.jpg',0,0),(10,46,'uploads/alibaba/0560/0560b25a4b490c29bdda37758b668e26.jpg',0,0),(10,47,'uploads/alibaba/0594/0594401bd4d70d7a045be927a0c7b68e.jpg',0,0),(10,48,'uploads/alibaba/704c/704c21870385d6b158ee816efb008a02.jpg',0,0),(11,49,'uploads/alibaba/c13e/c13ecbd268cdc424356f0e65edc24728.jpg',0,0),(11,50,'uploads/alibaba/58b7/58b779b4949c3ba6e664334449661ae7.jpg',0,0),(11,51,'uploads/alibaba/6604/6604434b6cc6464df532ea3d250a15a6.jpg',0,0),(12,52,'uploads/alibaba/66b1/66b16bf31bf2b951dda0c9c6c14fa2ea.jpg',0,0),(12,53,'uploads/alibaba/1a00/1a00d8dfcf33a0b92f17aee50af0387e.jpg',0,0),(12,54,'uploads/alibaba/7023/7023aa1ee11800dbef0dee989fcad546.jpg',0,0),(13,55,'uploads/alibaba/a0ae/a0ae6c44cc0862f3f58c729b48b3fb78.jpg',0,0),(13,56,'uploads/alibaba/5258/525851ca855838ef2dbadee39d8e5004.jpg',0,0),(14,57,'uploads/alibaba/4cd6/4cd62f381420f28cc35c28494b48fb5c.jpg',0,0),(14,58,'uploads/alibaba/3101/3101995257084491b3ae9ef84045a46a.jpg',0,0),(14,59,'uploads/alibaba/56a1/56a177760dc15beaeecc2690721d3318.jpg',0,0),(14,60,'uploads/alibaba/b7fb/b7fb3e548ad6113c12377c1175bbfd82.jpg',0,0),(15,61,'uploads/alibaba/0da5/0da58a767c3447895bda1e51a87fdaec.jpg',0,0),(15,62,'uploads/alibaba/cb1c/cb1c475ccecf0c7894b328abcf2238e4.jpg',0,0),(15,63,'uploads/alibaba/e448/e448526d86dbba8b2cacdce72803d470.jpg',0,0),(15,64,'uploads/alibaba/06ef/06efefaad22e923b9a74758225a7278f.jpg',0,0),(16,65,'uploads/alibaba/27d3/27d357b75d0dc72f06184695bf024f1f.jpg',0,0),(16,66,'uploads/alibaba/d497/d497df3a39fb97615a0406a045da5d44.jpg',0,0),(16,67,'uploads/alibaba/103f/103f336403af01238f2f77069ea2c580.jpg',0,0),(17,68,'uploads/alibaba/6cbe/6cbeb9fff3f82a81d6298542a0163bf8.jpg',0,0),(17,69,'uploads/alibaba/7d07/7d076581fa56d4b862f1534c7a3841f5.jpg',0,0),(17,70,'uploads/alibaba/31ff/31ffc8adc89af3aae2fb16dcd4f1eca9.jpg',0,0),(17,71,'uploads/alibaba/a754/a75415f80766dd5139fb1565f75ef0fb.jpg',0,0),(17,72,'uploads/alibaba/9cf6/9cf6205536d1e31a5c03bb84519b47df.jpg',0,0),(18,73,'uploads/alibaba/32a3/32a3ec45327839f7b12b1e5ac4e494ed.jpg',0,0),(18,74,'uploads/alibaba/1d29/1d296a82b88e029402396e842f781697.jpg',0,0),(18,75,'uploads/alibaba/0242/02426d6481f299aa39ae8f6c0531ad6a.jpg',0,0),(18,76,'uploads/alibaba/213c/213c75bfd7135fe014c7192200ad99e5.jpg',0,0),(19,77,'uploads/alibaba/efeb/efeb2f223778df6761ef74e2aebc7c35.jpg',0,0),(19,78,'uploads/alibaba/8012/80129ccb7bae823a4bf539948d9dbfbb.jpg',0,0),(19,79,'uploads/alibaba/1558/1558bf0a9664baa2495cf1a2ec2dee67.jpg',0,0),(19,80,'uploads/alibaba/9bcc/9bcce00925ca2728956c4a3648c21f04.jpg',0,0),(20,81,'uploads/alibaba/ef19/ef193aa9d98e855ee1fb903ee9a151c7.jpg',0,0),(20,82,'uploads/alibaba/dd04/dd04ee2f3d9c75e4323e0dce255ebe3f.jpg',0,0),(21,83,'uploads/alibaba/a543/a543233ccaf67d47259caecd9394d72d.jpg',0,0),(21,84,'uploads/alibaba/4627/4627b8b2ce2a21170deaf93933c43830.jpg',0,0),(21,85,'uploads/alibaba/f205/f20511222d7554e0abf145e130484b6b.jpg',0,0),(21,86,'uploads/alibaba/eff4/eff4d8e9e079ac79ebffb308b6eed079.jpg',0,0),(22,87,'uploads/alibaba/f785/f78593279a6b4a71ef20445589657ec7.jpg',0,0),(22,88,'uploads/alibaba/2112/2112dc165301ab86cbc936bf003ed2b2.jpg',0,0),(22,89,'uploads/alibaba/f376/f376d23683c2b711763c05e1182fbe0f.jpg',0,0),(23,90,'uploads/alibaba/0c5a/0c5a6003e40f641ddd70e4b2a042a86e.jpg',0,0),(23,91,'uploads/alibaba/ea99/ea995560d08888b55bc9c8c737eac991.jpg',0,0),(23,92,'uploads/alibaba/1ca6/1ca693aae03b0138ea93c538fe4f2414.jpg',0,0),(23,93,'uploads/alibaba/732c/732c6563e2d496b6d19ed89ba1512341.jpg',0,0),(24,94,'uploads/alibaba/e31e/e31e68d539cfad41faabd302a1b5fbc9.jpg',0,0),(24,95,'uploads/alibaba/db03/db03d32e63136677f9999e3b8c39fed4.jpg',0,0),(24,96,'uploads/alibaba/c193/c193a326b610f19434ac696241b0f95a.jpg',0,0),(24,97,'uploads/alibaba/ce70/ce70027c345fd19a9c076f89dba7fc55.jpg',0,0),(25,98,'uploads/alibaba/cdbf/cdbfe1cc8f8cae0cb2c89343a18a9e3f.jpg',0,0),(25,99,'uploads/alibaba/367b/367bd4b0341ddf6c129144ab321dd170.jpg',0,0),(25,100,'uploads/alibaba/a266/a2669a0e23b0b8a12da1ea91d9af85ec.jpg',0,0),(26,101,'uploads/alibaba/fb62/fb62378f4e8e1407d802b520d53e16f0.jpg',0,0),(26,102,'uploads/alibaba/7113/71138b381fab702aab2a49792aede0dd.jpg',0,0),(27,103,'uploads/alibaba/f778/f778c8f3b074114b33efa80355389f13.jpg',0,0),(27,104,'uploads/alibaba/4ae2/4ae284783d335d053cbe080959b96d3d.jpg',0,0),(27,105,'uploads/alibaba/f1f5/f1f55c2b97ddd6f90fc0ffa2068793fb.jpg',0,0),(27,106,'uploads/alibaba/7833/78332975d3a081f87e586fcded61dc8d.jpg',0,0),(28,107,'uploads/alibaba/3c51/3c51323151d854384b26df4d31e0a3f0.jpg',0,0),(28,108,'uploads/alibaba/b2ca/b2caebc8a8a86824fa1b1a58ffcfb6b5.jpg',0,0),(28,109,'uploads/alibaba/64af/64af300b2b422dcad1e1ac160e4da574.jpg',0,0),(29,110,'uploads/alibaba/6783/67837543479d1484d9d45de72f9be9a1.jpg',0,0),(29,111,'uploads/alibaba/efbc/efbc67f01cddd31319a4be7e54706515.jpg',0,0),(29,112,'uploads/alibaba/082c/082c1160559c3c9ab47ecec4121b21b9.jpg',0,0),(29,113,'uploads/alibaba/733b/733bc3f3dedfe918de599da3375d1b0e.jpg',0,0),(30,114,'uploads/alibaba/4ddb/4ddb07db243ef0f4a295be4ed3bde420.jpg',0,0),(30,115,'uploads/alibaba/fcda/fcdaf6925b2ffa80f8ee4c0523f40a45.jpg',0,0),(30,116,'uploads/alibaba/d197/d1973b7f5d6656bbf42c380fdd50f047.jpg',0,0),(30,117,'uploads/alibaba/8bbc/8bbc8ba6af709f7109f42f27ff2ca0da.jpg',0,0),(31,118,'uploads/alibaba/7bdc/7bdc8f17bdc5ddaae6eea1a0373d3e81.jpg',0,0),(31,119,'uploads/alibaba/0c78/0c7853ee00aa21f0e510001b5a13a4a2.jpg',0,0),(31,120,'uploads/alibaba/cb37/cb37b844780b047836463af7e1e499c6.jpg',0,0),(31,121,'uploads/alibaba/d7da/d7dadb0e5cb8f33debb2ad392a1f2f87.jpg',0,0),(32,122,'uploads/alibaba/1254/1254d18589adc4fb986223fc03f1794b.jpg',0,0),(32,123,'uploads/alibaba/4d3b/4d3b8c5345efce5b37fc6d5bbf4b6896.jpg',0,0),(32,124,'uploads/alibaba/42e7/42e778c27a67bff0068c412094fc295a.jpg',0,0),(32,125,'uploads/alibaba/014f/014f0262da625b1e2016ee01e95d6b6b.jpg',0,0),(33,126,'uploads/alibaba/a65a/a65a8b916124a6cd3487ec2e1314c30c.jpg',0,0),(33,127,'uploads/alibaba/85b7/85b7871dae2faf52a0b6b5e94fd8cee6.jpg',0,0),(33,128,'uploads/alibaba/111c/111cc78b7e5df82b2e32df2626ec3b1b.jpg',0,0),(33,129,'uploads/alibaba/ac26/ac266a072bafe67b094aa8c9edde3695.jpg',0,0),(34,130,'uploads/alibaba/9edf/9edffbb16c3818ff87f7834aeecd6494.jpg',0,0),(34,131,'uploads/alibaba/20c6/20c6b72b34f0d680ac807e1966806f8d.jpg',0,0),(34,132,'uploads/alibaba/01ed/01ed34badcd64086497a67e1ad76e833.jpg',0,0),(34,133,'uploads/alibaba/61fc/61fcf00490fe91effe110252a238b0b0.jpg',0,0),(35,134,'uploads/alibaba/99c5/99c5fdcac653f952c7b7ef1fe5da5658.jpg',0,0),(35,135,'uploads/alibaba/413e/413e8265b51cd6150cdc5c27f6aa1fa9.jpg',0,0),(35,136,'uploads/alibaba/624b/624b1d9497b07c8ca07900bda63b576b.jpg',0,0),(35,137,'uploads/alibaba/8825/88258d415011aedb46415db930dc645c.jpg',0,0),(35,138,'uploads/alibaba/9270/927014576357cb81907a2a69425c9893.jpg',0,0),(36,139,'uploads/alibaba/891d/891dcba475d87abed506129f47a16608.jpg',0,0),(36,140,'uploads/alibaba/e840/e8408b0060522db432892995ccca691a.jpg',0,0),(36,141,'uploads/alibaba/a206/a206591fbab6f6834c76e8e2bed9991b.jpg',0,0),(36,142,'uploads/alibaba/1a7b/1a7b8f2b227dd4465a36c8989ee0902b.jpg',0,0),(37,143,'uploads/alibaba/a723/a7230388d52f35fbad64fdc9026bd34d.jpg',0,0),(37,144,'uploads/alibaba/9c56/9c56b568b36012ad14e77bbb8c109035.jpg',0,0),(37,145,'uploads/alibaba/59d3/59d31f01d515d906eca4e3261b38b495.jpg',0,0),(37,146,'uploads/alibaba/79b5/79b505165a942a714e53b00c572601b7.jpg',0,0),(37,147,'uploads/alibaba/0218/02184e5feadd3aaa7f5a9015ee06af6d.jpg',0,0),(37,148,'uploads/alibaba/0218/02184e5feadd3aaa7f5a9015ee06af6d.jpg',0,0),(38,149,'uploads/alibaba/964f/964f42d5f004a4be7f24d5e592f377f7.jpg',0,0),(38,150,'uploads/alibaba/2000/20009bb787fa57486a10c20ae92c8472.jpg',0,0),(38,151,'uploads/alibaba/c711/c711c487cb881635e5b6c3c151cc9b0b.jpg',0,0),(38,152,'uploads/alibaba/3d1e/3d1e6add578855b84314e0812327a48c.jpg',0,0),(39,153,'uploads/alibaba/5597/5597e021bac184a2d2c0f20691b35924.jpg',0,0),(39,154,'uploads/alibaba/ea43/ea430bb0c7b82f65d92082a8616fe219.jpg',0,0),(39,155,'uploads/alibaba/8de4/8de42a21a118b6e773e02c221b115f12.jpg',0,0),(39,156,'uploads/alibaba/2090/20905249a5b769eaa7d5d16719475715.jpg',0,0),(40,157,'uploads/alibaba/d3f9/d3f9986616bdbc628ff0c3c668419060.jpg',0,0),(40,158,'uploads/alibaba/42f8/42f866859217268ab7369e21bcdf3e06.jpg',0,0),(40,159,'uploads/alibaba/367f/367f8c8c6bf9b2dd661974197a800a3f.jpg',0,0),(40,160,'uploads/alibaba/50d1/50d1567e7cb339de7e100a444ed593f5.jpg',0,0),(41,161,'uploads/alibaba/a1ab/a1ab8be048d3a3a07b5530de860e1770.jpg',0,0),(41,162,'uploads/alibaba/0db5/0db552662ed1173010ee21efea684df0.jpg',0,0),(41,163,'uploads/alibaba/bb06/bb067edfe97aeb3c77fb987b47288bc1.jpg',0,0),(41,164,'uploads/alibaba/da43/da4377ff58e55127c61de33371b35e0b.jpg',0,0),(42,165,'uploads/alibaba/758e/758eee92dc174602ad5948100e457838.jpg',0,0),(42,166,'uploads/alibaba/98c3/98c31a2be942578ec4946cc3f1490087.jpg',0,0),(42,167,'uploads/alibaba/6846/6846e0eed1772c9ee1254ec11aa87ea5.jpg',0,0),(42,168,'uploads/alibaba/d3b9/d3b9e479a7b3b0294c9b118310c0abf1.jpg',0,0),(43,169,'uploads/alibaba/a71d/a71dd7315f9d85c9bac1388f5946e395.jpg',0,0),(43,170,'uploads/alibaba/bfae/bfaee91f656f06db94d8df3cf88414aa.jpg',0,0),(43,171,'uploads/alibaba/e341/e341b3283b0d1921ae755b73468efbfe.jpg',0,0),(43,172,'uploads/alibaba/3489/34890c05b45648ff63910d8b10ea775a.jpg',0,0),(44,173,'uploads/alibaba/8ad5/8ad56dd1e35a0b5468f05aebda207739.jpg',0,0),(44,174,'uploads/alibaba/7440/7440eb922eb89c6505f33a36b56b71bd.jpg',0,0),(44,175,'uploads/alibaba/7c9c/7c9c90a39416e7a121d863919e382dd5.jpg',0,0),(45,176,'uploads/alibaba/1599/1599221ab40afdcfe4cae1ea7e6742c0.jpg',0,0),(45,177,'uploads/alibaba/114a/114af847d251a056ea27e67deefd2155.jpg',0,0),(45,178,'uploads/alibaba/f523/f5237595cd7c520165da3876f4bbb655.jpg',0,0),(45,179,'uploads/alibaba/53e5/53e538d71542707e479000e826c08449.jpg',0,0),(46,180,'uploads/alibaba/edc7/edc76ed8b3cb839fcfc677817d80e100.jpg',0,0),(46,181,'uploads/alibaba/9687/9687e1e003d9156251f11baada620322.jpg',0,0),(46,182,'uploads/alibaba/25b8/25b86e4f36196e4ec37a178fc4103d00.jpg',0,0),(46,183,'uploads/alibaba/7f20/7f204ba6b52bd6770b92af5c1a2bd239.jpg',0,0),(47,184,'uploads/alibaba/7cea/7cea9dbfc5adbfa4de900156effd11ac.jpg',0,0),(47,185,'uploads/alibaba/21f1/21f118a3832c99f44e1c6e00f4c17b2e.jpg',0,0),(48,186,'uploads/alibaba/7c69/7c69a1aaeda7c0c058819895c93309f4.jpg',0,0),(48,187,'uploads/alibaba/6e13/6e132f62d2427ef972cc73e6f77c7eb1.jpg',0,0),(48,188,'uploads/alibaba/a47b/a47b8b2ee4fd24e65c9f17591707dca1.jpg',0,0),(48,189,'uploads/alibaba/84b3/84b3c6248a0517fa7957900c66b571a3.jpg',0,0),(49,190,'uploads/alibaba/c385/c385fb40551664fb854a307e10ccefaf.jpg',0,0),(49,191,'uploads/alibaba/b94d/b94d98b8db1b2dd117b080e2104d5514.jpg',0,0),(49,192,'uploads/alibaba/4413/44134b143ef80270deb1b54724c01650.jpg',0,0),(49,193,'uploads/alibaba/5f43/5f43eee6e8a0cf4340535be972dc9db3.jpg',0,0),(49,194,'uploads/alibaba/b749/b74961d95879c6f0163bfe01aa2497f8.jpg',0,