阿里巴巴分类信息 信息分类数据表MySQL UTF8 记录数9,553

-- phpMyAdmin SQL Dump -- version 3.3.8 -- http://www.phpmyadmin.net -- -- 主机: localhost:3306 -- 生成日期: 2011 年 08 月 28 日 01:51 -- 服务器版本: 5.1.51 -- PHP 版本: 5.2.14 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 */; -- -- 数据库: `ftp_35dalu_com` -- -- -------------------------------------------------------- -- -- 表的结构 `sw_thread_cat` -- CREATE TABLE IF NOT EXISTS `sw_thread_cat` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `upid` mediumint(8) NOT NULL DEFAULT '0', `alias` varchar(60) NOT NULL, `level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '级别，最小值为1', `order` smallint(5) NOT NULL DEFAULT '1', `hot` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9554 ; -- -- 转存表中的数据 `sw_thread_cat` -- INSERT INTO `sw_thread_cat` (`id`, `name`, `upid`, `alias`, `level`, `order`, `hot`) VALUES (1, '照明工业', 0, '', 1, 1, 0), (2, '白炽灯', 1, '', 2, 1, 0), (3, '彩色灯泡', 2, '', 3, 1, 0), (4, '卤钨灯泡', 2, '', 3, 2, 0), (5, '摄影灯泡', 2, '', 3, 3, 0), (6, '普通照明白炽灯', 2, '', 3, 4, 0), (7, '微型灯泡', 2, '', 3, 5, 0), (8, '聚光灯泡', 2, '', 3, 6, 0), (9, '水下灯泡', 2, '', 3, 7, 0), (10, '无影灯', 2, '', 3, 8, 0), (11, '红外线灯泡', 2, '', 3, 9, 0), (12, '指示灯泡', 2, '', 3, 10, 0), (13, '其他白炽灯', 2, '', 3, 11, 0), (14, '气体放电灯', 1, '', 2, 2, 0), (15, '氙气灯', 14, '', 3, 1, 0), (16, 'U型荧光灯管', 14, '', 3, 2, 0), (17, '冷阴极荧光灯', 14, '', 3, 3, 0), (18, '霓虹灯管', 14, '', 3, 4, 0), (19, '直型荧光灯管', 14, '', 3, 5, 0), (20, '环型荧光灯管', 14, '', 3, 6, 0), (21, '钠灯', 14, '', 3, 7, 0), (22, '汞灯', 14, '', 3, 8, 0), (23, '金卤灯', 14, '', 3, 9, 0), (24, '氖灯', 14, '', 3, 10, 0), (25, '紫外线灯管', 14, '', 3, 11, 0), (26, '螺旋型荧光灯管', 14, '', 3, 12, 0), (27, '其他气体放电灯', 14, '', 3, 13, 0), (28, '冷光源', 1, '', 2, 3, 0), (29, 'EL冷光片', 28, '', 3, 1, 0), (30, '其他冷光源', 28, '', 3, 2, 0), (31, '灯具配附件', 1, '', 2, 4, 0), (32, '灯箱', 31, '', 3, 1, 0), (33, '触发器', 31, '', 3, 2, 0), (34, '光源器', 31, '', 3, 3, 0), (35, '灯杯', 31, '', 3, 4, 0), (36, '支架', 31, '', 3, 5, 0), (37, '灯头、灯座', 31, '', 3, 6, 0), (38, '灯盘', 31, '', 3, 7, 0), (39, '灯柱灯杆', 31, '', 3, 8, 0), (40, '灯罩', 31, '', 3, 9, 0), (41, '启辉器', 31, '', 3, 10, 0), (42, '镇流器', 31, '', 3, 11, 0), (43, '灯控制器', 31, '', 3, 12, 0), (44, '变压器', 31, '', 3, 13, 0), (45, '其他灯具配附件', 31, '', 3, 14, 0), (46, '电光源材料', 1, '', 2, 5, 0), (47, '灯丝', 46, '', 3, 1, 0), (48, '荧光粉、电子粉', 46, '', 3, 2, 0), (49, '灯管、泡壳', 46, '', 3, 3, 0), (50, '芯柱', 46, '', 3, 4, 0), (51, '其他电光源材料', 46, '', 3, 5, 0), (52, '插头', 1, '', 2, 6, 0), (53, '两极电源插头', 52, '', 3, 1, 0), (54, '三极电源插头', 52, '', 3, 2, 0), (55, '音频、视频插头', 52, '', 3, 3, 0), (56, '其他插头', 52, '', 3, 4, 0), (57, '插座', 1, '', 2, 7, 0), (58, '插座配件', 57, '', 3, 1, 0), (59, '定时器插座', 57, '', 3, 2, 0), (60, '工业插座', 57, '', 3, 3, 0), (61, '地面插座', 57, '', 3, 4, 0), (62, '桌面插座', 57, '', 3, 5, 0), (63, '机柜插座', 57, '', 3, 6, 0), (64, '墙壁插座', 57, '', 3, 7, 0), (65, '接线插座', 57, '', 3, 8, 0), (66, 'PCB插座', 57, '', 3, 9, 0), (67, '音频、视频插座', 57, '', 3, 10, 0), (68, '转换插座', 57, '', 3, 11, 0), (69, '其他插座', 57, '', 3, 12, 0), (70, '绝缘材料', 1, '', 2, 8, 0), (71, '电工胶带', 70, '', 3, 1, 0), (72, '绝缘套管', 70, '', 3, 2, 0), (73, '绝缘隔离柱', 70, '', 3, 3, 0), (74, '绝缘子', 70, '', 3, 4, 0), (75, '绝缘带', 70, '', 3, 5, 0), (76, '云母片', 70, '', 3, 6, 0), (77, '绝缘板', 70, '', 3, 7, 0), (78, '绝缘纸', 70, '', 3, 8, 0), (79, '绝缘垫片', 70, '', 3, 9, 0), (80, '其他绝缘材料', 70, '', 3, 10, 0), (81, '其他未分类', 1, '', 2, 9, 0), (82, '室外照明灯具', 1, '', 2, 10, 0), (83, '太阳能灯', 82, '', 3, 1, 0), (84, '隧道灯具', 82, '', 3, 2, 0), (85, '泛光灯', 82, '', 3, 3, 0), (86, '投射灯', 82, '', 3, 4, 0), (87, '探照灯', 82, '', 3, 5, 0), (88, '草坪灯', 82, '', 3, 6, 0), (89, '埋地灯', 82, '', 3, 7, 0), (90, '高杆灯', 82, '', 3, 8, 0), (91, '道路照明灯', 82, '', 3, 9, 0), (92, '庭院灯', 82, '', 3, 10, 0), (93, '无极灯', 82, '', 3, 11, 0), (94, '景观灯', 82, '', 3, 12, 0), (95, '码头、桥梁灯具', 82, '', 3, 13, 0), (96, '其他室外照明灯具', 82, '', 3, 14, 0), (97, '常规照明', 1, '', 2, 11, 0), (98, '格栅灯', 97, '', 3, 1, 0), (99, '吸顶灯', 97, '', 3, 2, 0), (100, '筒灯', 97, '', 3, 3, 0), (101, '小夜灯', 97, '', 3, 4, 0), (102, '其他常规照明', 97, '', 3, 5, 0), (103, '专门用途灯具', 1, '', 2, 12, 0), (104, '运动场馆灯具', 103, '', 3, 1, 0), (105, '舞台灯具', 103, '', 3, 2, 0), (106, '摄影灯具', 103, '', 3, 3, 0), (107, '医疗灯具', 103, '', 3, 4, 0), (108, '射灯、杯灯', 103, '', 3, 5, 0), (109, '广告灯具', 103, '', 3, 6, 0), (110, '紫外线灯', 103, '', 3, 7, 0), (111, '灭蚊灯', 103, '', 3, 8, 0), (112, '红外线灯', 103, '', 3, 9, 0), (113, '工矿灯具', 103, '', 3, 10, 0), (114, '水下灯具', 103, '', 3, 11, 0), (115, '防爆灯具', 103, '', 3, 12, 0), (116, '工艺装饰灯具', 103, '', 3, 13, 0), (117, '装饰灯串', 103, '', 3, 14, 0), (118, 'LED灯具', 103, '', 3, 15, 0), (119, '机床灯具', 103, '', 3, 16, 0), (120, '其他专门用途灯具', 103, '', 3, 17, 0), (121, '车灯', 1, '', 2, 13, 0), (122, '大灯、前照灯', 121, '', 3, 1, 0), (123, '转向灯、角灯', 121, '', 3, 2, 0), (124, '尾灯', 121, '', 3, 3, 0), (125, '雾灯', 121, '', 3, 4, 0), (126, '仪表灯', 121, '', 3, 5, 0), (127, '刹车灯', 121, '', 3, 6, 0), (128, '车顶灯', 121, '', 3, 7, 0), (129, '牌照灯', 121, '', 3, 8, 0), (130, '工作灯、检修灯', 121, '', 3, 9, 0), (131, '其他车灯', 121, '', 3, 10, 0), (132, '指示灯具', 1, '', 2, 14, 0), (133, '交通警示灯', 132, '', 3, 1, 0), (134, '航空障碍灯', 132, '', 3, 2, 0), (135, '其他指示灯具', 132, '', 3, 3, 0), (136, '应急指示灯具', 132, '', 3, 4, 0), (137, '信号灯', 132, '', 3, 5, 0), (138, '设备指示灯', 132, '', 3, 6, 0), (139, '电子加工', 1, '', 2, 15, 0), (140, 'SMT贴片加工', 139, '', 3, 1, 0), (141, '插件加工', 139, '', 3, 2, 0), (142, 'COB邦定加工', 139, '', 3, 3, 0), (143, '电子组装加工', 139, '', 3, 4, 0), (144, '电子焊接加工', 139, '', 3, 5, 0), (145, '其他电子加工', 139, '', 3, 6, 0), (146, '照明灯具设计', 1, '', 2, 16, 0), (147, '二手照明器材', 1, '', 2, 17, 0), (148, '照明器材代理加盟', 1, '', 2, 18, 0), (149, '照明加工', 1, '', 2, 19, 0), (150, '照明器材项目合作', 1, '', 2, 20, 0), (151, '库存照明器材', 1, '', 2, 21, 0), (152, '电子元器件', 0, '', 1, 2, 0), (153, '集成电路(IC)', 152, '', 2, 1, 0), (154, '二极管', 152, '', 2, 2, 0), (155, '三极管', 152, '', 2, 3, 0), (156, '可控硅(晶闸管)', 152, '', 2, 4, 0), (157, '场效应管', 152, '', 2, 5, 0), (158, '整流器、整流设备', 152, '', 2, 6, 0), (159, '连接器', 152, '', 2, 7, 0), (160, 'LED系列产品', 152, '', 2, 8, 0), (161, 'LCD系列产品', 152, '', 2, 9, 0), (162, '显示器件', 152, '', 2, 10, 0), (163, 'PCB电路板', 152, '', 2, 11, 0), (164, '变压器', 152, '', 2, 12, 0), (165, '电感器', 152, '', 2, 13, 0), (166, '继电器', 152, '', 2, 14, 0), (167, '变频器', 152, '', 2, 15, 0), (168, '传感器', 152, '', 2,