-- MySQL dump 10.13 Distrib 5.5.53, for Win32 (AMD64)
--
-- Host: localhost Database: taobao
-- ------------------------------------------------------
-- Server version 5.5.53
/*!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 `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`id` varchar(50) NOT NULL,
`pid` int(10) DEFAULT NULL,
`groupId` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`path` text,
`idpath` text,
`spell` varchar(255) DEFAULT NULL,
KEY `id` (`id`) USING BTREE,
KEY `pid` (`pid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES ('40',NULL,'G_1','腾讯QQ专区',NULL,NULL,'txqqzq'),('99',NULL,'G_1','网络游戏点卡',NULL,NULL,'wlyxdk'),('50011665',NULL,'G_1','网游装备/游戏币/帐号/代练',NULL,NULL,'wyzbyxbzhdl'),('50010404',NULL,'G_2','服饰配件/皮带/帽子/围巾',NULL,NULL,'fspjpdmzwj'),('50011740',NULL,'G_2','流行男鞋',NULL,NULL,'lxnx'),('30',NULL,'G_2','男装',NULL,NULL,'nz'),('1625',NULL,'G_2','女士内衣/男士内衣/家居服',NULL,NULL,'nsnynsnyjjf'),('50006843',NULL,'G_2','女鞋',NULL,NULL,'nx'),('16',NULL,'G_2','女装/女士精品',NULL,NULL,'nznsjp'),('50006842',NULL,'G_2','箱包皮具/热销女包/男包',NULL,NULL,'xbpjrxnbnb'),('50008090',NULL,'G_3','3C数码配件',NULL,NULL,'3csmpj'),('50018222',NULL,'G_3','DIY电脑',NULL,NULL,'diydn'),('1201',NULL,'G_3','MP3/MP4/iPod/录音笔',NULL,NULL,'mp3mp4ipodlyb'),('50007218',NULL,'G_3','办公设备/耗材/相关服务',NULL,NULL,'bgsbhcxgfw'),('1101',NULL,'G_3','笔记本电脑',NULL,NULL,'bjbdn'),('11',NULL,'G_3','电脑硬件/显示器/电脑周边',NULL,NULL,'dnyjxsqdnzb'),('20',NULL,'G_3','电玩/配件/游戏/攻略',NULL,NULL,'dwpjyxgl'),('50024099',NULL,'G_3','电子元器件市场',NULL,NULL,'dzyqjsc'),('124852003',NULL,'G_3','二手数码',NULL,NULL,'essm'),('124044001',NULL,'G_3','品牌台机/品牌一体机/服务器',NULL,NULL,'pptjppytjfwq'),('50019780',NULL,'G_3','平板电脑/MID',NULL,NULL,'pbdnmid'),('50012164',NULL,'G_3','闪存卡/U盘/存储/移动硬盘',NULL,NULL,'sckupccydyp'),('1512',NULL,'G_3','手机',NULL,NULL,'sj'),('14',NULL,'G_3','数码相机/单反相机/摄像机',NULL,NULL,'smxjdfxjsxj'),('50018264',NULL,'G_3','网络设备/网络相关',NULL,NULL,'wlsbwlxg'),('50018004',NULL,'G_3','文具电教/文化用品/商务用品',NULL,NULL,'wjdjwhypswyp'),('50012082',NULL,'G_4','厨房电器',NULL,NULL,'cfdq'),('50022703',NULL,'G_4','大家电',NULL,NULL,'djd'),('50002768',NULL,'G_4','个人护理/保健/按摩器材',NULL,NULL,'grhlbjamqc'),('122718004',NULL,'G_4','家庭保健',NULL,NULL,'jtbj'),('50012100',NULL,'G_4','生活电器',NULL,NULL,'shdq'),('50011972',NULL,'G_4','影音电器',NULL,NULL,'yydq'),('28',NULL,'G_5','ZIPPO/瑞士军刀/眼镜',NULL,NULL,'zipporsjdyj'),('50010788',NULL,'G_5','彩妆/香水/美妆工具',NULL,NULL,'czxsmzgj'),('50023282',NULL,'G_5','美发护发/假发',NULL,NULL,'mfhfjf'),('1801',NULL,'G_5','美容护肤/美体/精油',NULL,NULL,'mrhfmtjy'),('50013864',NULL,'G_5','饰品/流行首饰/时尚饰品新',NULL,NULL,'splxssssspx'),('50468001',NULL,'G_5','手表',NULL,NULL,'sb'),('50011397',NULL,'G_5','珠宝/钻石/翡翠/黄金',NULL,NULL,'zbzschj'),('35',NULL,'G_6','奶粉/辅食/营养品/零食',NULL,NULL,'nffsyypls'),('50014812',NULL,'G_6','尿片/洗护/喂哺/推车床',NULL,NULL,'npxhwbtcc'),('122650005',NULL,'G_6','童鞋/婴儿鞋/亲子鞋',NULL,NULL,'txyexqzx'),('50008165',NULL,'G_6','童装/婴儿装/亲子装',NULL,NULL,'tzyezqzz'),('25',NULL,'G_6','玩具/童车/益智/积木/模型',NULL,NULL,'wjtcyzjmmx'),('50022517',NULL,'G_6','孕妇装/孕产妇用品/营养',NULL,NULL,'yfzycfypyy'),('50008163',NULL,'G_7','床上用品',NULL,NULL,'csyp'),('50020579',NULL,'G_7','电子/电工',NULL,NULL,'dzdg'),('50020332',NULL,'G_7','基础建材',NULL,NULL,'jcjc'),('50020808',NULL,'G_7','家居饰品',NULL,NULL,'jjsp'),('27',NULL,'G_7','家装主材',NULL,NULL,'jzzc'),('122852001',NULL,'G_7','居家布艺',NULL,NULL,'jjby'),('124050001',NULL,'G_7','全屋定制',NULL,NULL,'qwdz'),('50020611',NULL,'G_7','商业/办公家具',NULL,NULL,'sybgjj'),('50020857',NULL,'G_7','特色手工艺',NULL,NULL,'tssgy'),('50020485',NULL,'G_7','五金/工具',NULL,NULL,'wjgj'),('50008164',NULL,'G_7','住宅家具',NULL,NULL,'zzjj'),('50023804',NULL,'G_7','装修设计/施工/监理',NULL,NULL,'zxsjsgjl'),('50023717',NULL,'G_8','OTC药品/医疗器械/计生用品',NULL,NULL,'otcypylqxjsyp'),('50026800',NULL,'G_8','保健食品/膳食营养补充食品',NULL,NULL,'bjspssyybcsp'),('122952001',NULL,'G_8','餐饮具',NULL,NULL,'cyj'),('124458005',NULL,'G_8','茶',NULL,NULL,'c'),('2813',NULL,'G_8','成人用品/情趣用品',NULL,NULL,'crypqqyp'),('50016349',NULL,'G_8','厨房/烹饪用具',NULL,NULL,'cfpyj'),('50020275',NULL,'G_8','传统滋补营养品',NULL,NULL,'ctzbyyp'),('50016348',NULL,'G_8','家庭/个人清洁工具',NULL,NULL,'jtgrqjgj'),('122950001',NULL,'G_8','节庆用品/礼品',NULL,NULL,'jqyplp'),('50008141',NULL,'G_8','酒类',NULL,NULL,'jl'),('21',NULL,'G_8','居家日用',NULL,NULL,'jjry'),('50026316',NULL,'G_8','咖啡/麦片/冲饮',NULL,NULL,'kfmpcy'),('50016422',NULL,'G_8','粮油米面/南北干货/调味品',NULL,NULL,'lymmnbghdwp'),('50002766',NULL,'G_8','零食/坚果/特产',NULL,NULL,'lsjgtc'),('122928002',NULL,'G_8','收纳整理',NULL,NULL,'snzl'),('50050359',NULL,'G_8','水产肉类/新鲜蔬果/熟食',NULL,NULL,'scrlxxsgss'),('50025705',NULL,'G_8','洗护清洁剂/卫生巾/纸/香薰',NULL,NULL,'xhqjjwsjzx'),('124354002',NULL,'G_9','电动车/配件/交通工具',NULL,NULL,'ddcpjjtgj'),('50013886',NULL,'G_9','户外/登山/野营/旅行用品',NULL,NULL,'hwdsyylxyp'),('50010728',NULL,'G_9','运动/瑜伽/健身/球迷用品',NULL,NULL,'ydjsqmyp'),('50510002',NULL,'G_9','运动包/户外包/配件',NULL,NULL,'ydbhwbpj'),('50011699',NULL,'G_9','运动服/休闲服装',NULL,NULL,'ydfxxfz'),('50012029',NULL,'G_9','运动鞋new',NULL,NULL,'ydxnew'),('122684003',NULL,'G_9','自行车/骑行装备/零配件',NULL,NULL,'zxcqxzblpj'),('29',NULL,'G_10','宠物/宠物食品及用品',NULL,NULL,'cwcwspjyp'),('50025707',NULL,'G_10','度假线路/签证送关/旅游服务',NULL,NULL,'djxlqzsglyfw'),('23',NULL,'G_10','古董/邮币/字画/收藏',NULL,NULL,'gdybzhsc'),('50454031',NULL,'G_10','景点门票/演艺演出/周边游',NULL,NULL,'jdmpyyyczby'),('50017300',NULL,'G_10','乐器/吉他/钢琴/配件',NULL,NULL,'lqjtgqpj'),('124484008',NULL,'G_10','模玩/动漫/周边/cos/桌游',NULL,NULL,'mwdmzbcoszy'),('33',NULL,'G_10','书籍/杂志/报纸',NULL,NULL,'sjzzbz'),('50011949',NULL,'G_10','特价酒店/特色客栈/公寓旅馆',NULL,NULL,'tjjdtskzgylg'),('34',NULL,'G_10','音乐/影视/明星/音像',NULL,NULL,'ylysmxyx'),('50025111',NULL,'G_11','本地化生活服务',NULL,NULL,'bdhshfw'),('50008075',NULL,'G_11','餐饮美食卡券',NULL,NULL,'cymskq'),('50025110',NULL,'G_11','电影/演出/体育赛事',NULL,NULL,'dyyctyss'),('50023575',NULL,'G_11','房产/租房/新房/二手房/�
- 1
- 2
前往页