-- ----------------------------
-- Table structure for xy_company_industry
-- ----------------------------
DROP TABLE IF EXISTS `xy_company_industry`;
CREATE TABLE `xy_company_industry`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(10) NULL DEFAULT 0,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` tinyint(2) NULL DEFAULT 99,
  `status` tinyint(1) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 129 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '行业' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xy_company_industry
-- ----------------------------
INSERT INTO `xy_company_industry` VALUES (1, 0, '互联网/IT/电子/通信', 99, 1);
INSERT INTO `xy_company_industry` VALUES (2, 0, '广告/传媒/文化/体育', 99, 1);
INSERT INTO `xy_company_industry` VALUES (3, 0, '金融', 99, 1);
INSERT INTO `xy_company_industry` VALUES (4, 0, '教育培训', 99, 1);
INSERT INTO `xy_company_industry` VALUES (5, 0, '制药/医疗', 99, 1);
INSERT INTO `xy_company_industry` VALUES (6, 0, '交通/物流/贸易/零售', 99, 1);
INSERT INTO `xy_company_industry` VALUES (7, 0, '专业服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (8, 0, '房地产/建筑', 99, 1);
INSERT INTO `xy_company_industry` VALUES (9, 0, '汽车', 99, 1);
INSERT INTO `xy_company_industry` VALUES (12, 0, '机械/制造', 99, 1);
INSERT INTO `xy_company_industry` VALUES (13, 0, '消费品', 99, 1);
INSERT INTO `xy_company_industry` VALUES (14, 0, '服务业', 99, 1);
INSERT INTO `xy_company_industry` VALUES (15, 0, '能源/化工/环保', 99, 1);
INSERT INTO `xy_company_industry` VALUES (16, 0, '政府/非盈利机构/其他', 99, 1);
INSERT INTO `xy_company_industry` VALUES (17, 1, '电子商务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (18, 1, '游戏', 99, 1);
INSERT INTO `xy_company_industry` VALUES (19, 1, '媒体', 99, 1);
INSERT INTO `xy_company_industry` VALUES (20, 1, '广告营销', 99, 1);
INSERT INTO `xy_company_industry` VALUES (21, 1, '数据服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (22, 1, '医疗健康', 99, 1);
INSERT INTO `xy_company_industry` VALUES (23, 1, '生活服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (24, 1, 'O2O', 99, 1);
INSERT INTO `xy_company_industry` VALUES (25, 1, '旅游', 99, 1);
INSERT INTO `xy_company_industry` VALUES (26, 1, '分类信息', 99, 1);
INSERT INTO `xy_company_industry` VALUES (27, 1, '音乐/视频/阅读', 99, 1);
INSERT INTO `xy_company_industry` VALUES (28, 1, '在线教育', 99, 1);
INSERT INTO `xy_company_industry` VALUES (29, 1, '社交网络', 99, 1);
INSERT INTO `xy_company_industry` VALUES (30, 1, '人力资源服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (31, 1, '企业服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (32, 1, '信息安全', 99, 1);
INSERT INTO `xy_company_industry` VALUES (33, 1, '新零售', 99, 1);
INSERT INTO `xy_company_industry` VALUES (34, 1, '智能硬件', 99, 1);
INSERT INTO `xy_company_industry` VALUES (35, 1, '移动互联网', 99, 1);
INSERT INTO `xy_company_industry` VALUES (36, 1, '互联网', 99, 1);
INSERT INTO `xy_company_industry` VALUES (37, 1, '计算机软件', 99, 1);
INSERT INTO `xy_company_industry` VALUES (38, 1, '计算机硬件', 99, 1);
INSERT INTO `xy_company_industry` VALUES (39, 1, '计算机服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (40, 1, '通信/网络设备', 99, 1);
INSERT INTO `xy_company_industry` VALUES (41, 1, '运营商/增值服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (42, 1, '电子/半导体/集成电路', 99, 1);
INSERT INTO `xy_company_industry` VALUES (43, 2, '广告/公关/会展', 99, 1);
INSERT INTO `xy_company_industry` VALUES (44, 2, '新闻/出版', 99, 1);
INSERT INTO `xy_company_industry` VALUES (45, 2, '广播/影视', 99, 1);
INSERT INTO `xy_company_industry` VALUES (46, 2, '文化/体育/娱乐', 99, 1);
INSERT INTO `xy_company_industry` VALUES (47, 3, '银行', 99, 1);
INSERT INTO `xy_company_industry` VALUES (48, 3, '保险', 99, 1);
INSERT INTO `xy_company_industry` VALUES (49, 3, '证券/期货', 99, 1);
INSERT INTO `xy_company_industry` VALUES (50, 3, '基金', 99, 1);
INSERT INTO `xy_company_industry` VALUES (51, 3, '信托', 99, 1);
INSERT INTO `xy_company_industry` VALUES (52, 3, '互联网金融', 99, 1);
INSERT INTO `xy_company_industry` VALUES (53, 3, '投资/融资', 99, 1);
INSERT INTO `xy_company_industry` VALUES (54, 3, '租赁/拍卖/典当/担保', 99, 1);
INSERT INTO `xy_company_industry` VALUES (55, 4, '学前教育', 99, 1);
INSERT INTO `xy_company_industry` VALUES (56, 4, '院校', 99, 1);
INSERT INTO `xy_company_industry` VALUES (57, 4, '培训机构', 99, 1);
INSERT INTO `xy_company_industry` VALUES (58, 4, '学术/科研', 99, 1);
INSERT INTO `xy_company_industry` VALUES (59, 5, '制药', 99, 1);
INSERT INTO `xy_company_industry` VALUES (60, 5, '医疗/护理/卫生', 99, 1);
INSERT INTO `xy_company_industry` VALUES (61, 5, '医疗设备/器械', 99, 1);
INSERT INTO `xy_company_industry` VALUES (62, 6, '交通/运输', 99, 1);
INSERT INTO `xy_company_industry` VALUES (63, 6, '物流/仓储', 99, 1);
INSERT INTO `xy_company_industry` VALUES (64, 6, '批发/零售', 99, 1);
INSERT INTO `xy_company_industry` VALUES (65, 6, '贸易/进出口', 99, 1);
INSERT INTO `xy_company_industry` VALUES (66, 7, '咨询', 99, 1);
INSERT INTO `xy_company_industry` VALUES (67, 7, '法律', 99, 1);
INSERT INTO `xy_company_industry` VALUES (68, 7, '翻译', 99, 1);
INSERT INTO `xy_company_industry` VALUES (69, 7, '人力资源服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (70, 7, '财务/审计/税务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (71, 7, '检测/认证', 99, 1);
INSERT INTO `xy_company_industry` VALUES (72, 7, '专利/商标/知识产权', 99, 1);
INSERT INTO `xy_company_industry` VALUES (73, 7, '其他专业服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (74, 8, '房地产开发', 99, 1);
INSERT INTO `xy_company_industry` VALUES (75, 8, '工程施工', 99, 1);
INSERT INTO `xy_company_industry` VALUES (76, 8, '建筑设计', 99, 1);
INSERT INTO `xy_company_industry` VALUES (77, 8, '装修装饰', 99, 1);
INSERT INTO `xy_company_industry` VALUES (78, 8, '建材', 99, 1);
INSERT INTO `xy_company_industry` VALUES (79, 8, '地产经纪/中介', 99, 1);
INSERT INTO `xy_company_industry` VALUES (80, 8, '物业服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (81, 9, '汽车生产', 99, 1);
INSERT INTO `xy_company_industry` VALUES (82, 9, '汽车零部件', 99, 1);
INSERT INTO `xy_company_industry` VALUES (83, 9, '4S店/后市场', 99, 1);
INSERT INTO `xy_company_industry` VALUES (84, 10, '机械设备/机电/重工', 99, 1);
INSERT INTO `xy_company_industry` VALUES (85, 10, '仪器仪表/工业自动化', 99, 1);
INSERT INTO `xy_company_industry` VALUES (86, 10, '原材料及加工/模具', 99, 1);
INSERT INTO `xy_company_industry` VALUES (87, 10, '印刷/包装/造纸', 99, 1);
INSERT INTO `xy_company_industry` VALUES (88, 10, '船舶/航空/航天', 99, 1);
INSERT INTO `xy_company_industry` VALUES (89, 11, '食品/饮料/烟酒', 99, 1);
INSERT INTO `xy_company_industry` VALUES (90, 11, '日化', 99, 1);
INSERT INTO `xy_company_industry` VALUES (91, 11, '服装/纺织/皮革', 99, 1);
INSERT INTO `xy_company_industry` VALUES (92, 11, '家具/家电/家居', 99, 1);
INSERT INTO `xy_company_industry` VALUES (93, 11, '玩具/礼品', 99, 1);
INSERT INTO `xy_company_industry` VALUES (94, 11, '珠宝/首饰', 99, 1);
INSERT INTO `xy_company_industry` VALUES (95, 11, '工艺品/收藏品', 99, 1);
INSERT INTO `xy_company_industry` VALUES (96, 11, '办公用品及设备', 99, 1);
INSERT INTO `xy_company_industry` VALUES (97, 12, '餐饮', 99, 1);
INSERT INTO `xy_company_industry` VALUES (98, 12, '酒店', 99, 1);
INSERT INTO `xy_company_industry` VALUES (99, 12, '旅游', 99, 1);
INSERT INTO `xy_company_industry` VALUES (100, 12, '美容/美发', 99, 1);
INSERT INTO `xy_company_industry` VALUES (101, 12, '婚庆/摄影', 99, 1);
INSERT INTO `xy_company_industry` VALUES (102, 12, '其他服务业', 99, 1);
INSERT INTO `xy_company_industry` VALUES (103, 12, '休闲/娱乐', 99, 1);
INSERT INTO `xy_company_industry` VALUES (104, 12, '回收/维修', 99, 1);
INSERT INTO `xy_company_industry` VALUES (105, 12, '家政服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (106, 12, '宠物服务', 99, 1);
INSERT INTO `xy_company_industry` VALUES (107, 13, '石油/石化', 99, 1);
INSERT INTO `xy_company_industry` VALUES (108, 13, '化工', 99, 1);
INSERT INTO `xy_company_industry` VALUES (109, 13, '矿产/地质', 99, 1);
INSERT INTO `xy_company_industry` VALUES (110, 13, '采掘/冶炼', 99, 1);
INSERT INTO `xy_company_industry` VALUES (111, 13, '电力/热力/燃气/水利', 99, 1);
INSERT INTO `xy_company_industry` VALUES (112, 13, '新能源', 99, 1);
INSERT INTO `xy_company_industry` VALUES (113, 13, '环保', 99, 1);
INSERT INTO `xy_company_industry` VALUES (114, 14, '政府/公共事业', 99, 1);
INSERT INTO `xy_company_industry` VALUES (115, 14, '非盈利机构', 99, 1);
INSERT INTO `xy_company_industry` VALUES (116, 14, '农/林/牧/渔', 99, 1);
INSERT INTO `xy_company_industry` VALUES (117, 14, '其他行业', 99, 1);
INSERT INTO `xy_company_industry` VALUES (118, 15, '石油/石化', 99, 1);
INSERT INTO `xy_company_industry` VALUES (119, 15, '化工', 99, 1);
INSERT INTO `xy_company_industry` VALUES (120, 15, '矿产/地质', 99, 1);
INSERT INTO `xy_company_industry` VALUES (121, 15, '采掘/冶炼', 99, 1);
INSERT INTO `xy_company_industry` VALUES (122, 15, '电力/热力/燃气/水利', 99, 1);
INSERT INTO `xy_company_industry` VALUES (123, 15, '新能源', 99, 1);
INSERT INTO `xy_company_industry` VALUES (124, 15, '环保', 99, 1);
INSERT INTO `xy_company_industry` VALUES (125, 16, '政府/公共事业', 99, 1);
INSERT INTO `xy_company_industry` VALUES (126, 16, '非盈利机构', 99, 1);
INSERT INTO `xy_company_industry` VALUES (127, 16, '农林牧渔', 99, 1);
INSERT INTO `xy_company_industry` VALUES (128, 16, '其他行业', 99, 1);
