人群定向SQL表

SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for rc_throng-- ----------------------------DROP TABLE IF EXISTS `rc_throng`;CREATE TABLE `rc_throng` (  `throng_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '人群ID',  `sort` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '人群分类',  `pid` int(11) DEFAULT NULL COMMENT '父ID',  `level` smallint(6) DEFAULT NULL COMMENT '等级',  PRIMARY KEY (`throng_id`)) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1 COMMENT='人群表';-- ------------------------------ Records of rc_throng-- ----------------------------INSERT INTO `rc_throng` VALUES ('1', '金融财经', '0', '0');INSERT INTO `rc_throng` VALUES ('2', '投资', '1', '1');INSERT INTO `rc_throng` VALUES ('3', '宏观经济', '1', '1');INSERT INTO `rc_throng` VALUES ('4', '商业', '1', '1');INSERT INTO `rc_throng` VALUES ('5', '产业经济学', '1', '1');INSERT INTO `rc_throng` VALUES ('6', '理财', '1', '1');INSERT INTO `rc_throng` VALUES ('7', '创业', '1', '1');INSERT INTO `rc_throng` VALUES ('8', '企业管理', '1', '1');INSERT INTO `rc_throng` VALUES ('9', '体育', '0', '0');INSERT INTO `rc_throng` VALUES ('10', '足球', '9', '1');INSERT INTO `rc_throng` VALUES ('11', '篮球', '9', '1');INSERT INTO `rc_throng` VALUES ('12', '羽毛球', '9', '1');INSERT INTO `rc_throng` VALUES ('13', '户外运动', '9', '1');INSERT INTO `rc_throng` VALUES ('14', '极限运动', '9', '1');INSERT INTO `rc_throng` VALUES ('15', '体育八卦', '9', '1');INSERT INTO `rc_throng` VALUES ('16', '水上运动', '9', '1');INSERT INTO `rc_throng` VALUES ('17', '乒乓球', '9', '1');INSERT INTO `rc_throng` VALUES ('18', '棋牌', '9', '1');INSERT INTO `rc_throng` VALUES ('19', '健美健身', '9', '1');INSERT INTO `rc_throng` VALUES ('20', '跑步骑行', '9', '1');INSERT INTO `rc_throng` VALUES ('21', '其他竞技体育', '9', '1');INSERT INTO `rc_throng` VALUES ('22', '文化历史', '0', '0');INSERT INTO `rc_throng` VALUES ('23', '历史', '22', '1');INSERT INTO `rc_throng` VALUES ('24', '考古', '22', '1');INSERT INTO `rc_throng` VALUES ('25', '传统文化', '22', '1');INSERT INTO `rc_throng` VALUES ('26', '艺术', '22', '1');INSERT INTO `rc_throng` VALUES ('27', '建筑文化', '22', '1');INSERT INTO `rc_throng` VALUES ('28', '文学', '22', '1');INSERT INTO `rc_throng` VALUES ('29', '文物', '22', '1');INSERT INTO `rc_throng` VALUES ('30', '娱乐', '0', '0');INSERT INTO `rc_throng` VALUES ('31', '影视', '30', '1');INSERT INTO `rc_throng` VALUES ('32', '音乐', '30', '1');INSERT INTO `rc_throng` VALUES ('33', '明显八卦', '30', '1');INSERT INTO `rc_throng` VALUES ('34', '日韩娱乐', '30', '1');INSERT INTO `rc_throng` VALUES ('35', '欧美娱乐', '30', '1');INSERT INTO `rc_throng` VALUES ('36', '港台娱乐', '30', '1');INSERT INTO `rc_throng` VALUES ('37', '综艺', '30', '1');INSERT INTO `rc_throng` VALUES ('38', '歌剧', '30', '1');INSERT INTO `rc_throng` VALUES ('39', '话剧', '30', '1');INSERT INTO `rc_throng` VALUES ('40', '小品', '30', '1');INSERT INTO `rc_throng` VALUES ('41', '搞笑', '30', '1');INSERT INTO `rc_throng` VALUES ('42', '戏剧', '30', '1');INSERT INTO `rc_throng` VALUES ('43', '曲艺', '30', '1');INSERT INTO `rc_throng` VALUES ('44', '科技数码', '0', '0');INSERT INTO `rc_throng` VALUES ('45', '手机', '44', '1');INSERT INTO `rc_throng` VALUES ('46', '电脑', '44', '1');INSERT INTO `rc_throng` VALUES ('47', '其他数码产品', '44', '1');INSERT INTO `rc_throng` VALUES ('48', '科技', '44', '1');INSERT INTO `rc_throng` VALUES ('49', '互联网', '44', '1');INSERT INTO `rc_throng` VALUES ('50', '家电', '44', '1');INSERT INTO `rc_throng` VALUES ('51', '运营商', '44', '1');INSERT INTO `rc_throng` VALUES ('52', '政治军事', '0', '0');INSERT INTO `rc_throng` VALUES ('53', '外交', '52', '1');INSERT INTO `rc_throng` VALUES ('54', '时政', '52', '1');INSERT INTO `rc_throng` VALUES ('55', '武器装备', '52', '1');INSERT INTO `rc_throng` VALUES ('56', '国际社会', '52', '1');INSERT INTO `rc_throng` VALUES ('57', '军事', '52', '1');INSERT INTO `rc_throng` VALUES ('58', '汽车', '0', '0');INSERT INTO `rc_throng` VALUES ('59', '新车', '58', '1');INSERT INTO `rc_throng` VALUES ('60', '汽车用品', '58', '1');INSERT INTO `rc_throng` VALUES ('61', '进口车', '58', '1');INSERT INTO `rc_throng` VALUES ('62', '汽车行情', '58', '1');INSERT INTO `rc_throng` VALUES ('63', '豪华车', '58', '1');INSERT INTO `rc_throng` VALUES ('64', '新能源汽车', '58', '1');INSERT INTO `rc_throng` VALUES ('65', '国产车', '58', '1');INSERT INTO `rc_throng` VALUES ('66', 'MPV', '58', '1');INSERT INTO `rc_throng` VALUES ('67', '汽车导购', '58', '1');INSERT INTO `rc_throng` VALUES ('68', 'SUV', '58', '1');INSERT INTO `rc_throng` VALUES ('69', '跑车', '58', '1');INSERT INTO `rc_throng` VALUES ('70', '商用车', '58', '1');INSERT INTO `rc_throng` VALUES ('71', '汽车改装', '58', '1');INSERT INTO `rc_throng` VALUES ('72', '汽车维修', '58', '1');INSERT INTO `rc_throng` VALUES ('73', '二手车', '58', '1');INSERT INTO `rc_throng` VALUES ('74', '摩托车', '58', '1');INSERT INTO `rc_throng` VALUES ('75', '汽车保养', '58', '1');INSERT INTO `rc_throng` VALUES ('76', '汽车租赁', '58', '1');INSERT INTO `rc_throng` VALUES ('77', '美容时尚', '0', '0');INSERT INTO `rc_throng` VALUES ('78', '时装搭配', '77', '1');INSERT INTO `rc_throng` VALUES ('79', '美容美体', '77', '1');INSERT INTO `rc_throng` VALUES ('80', '奢饰品', '77', '1');INSERT INTO `rc_throng` VALUES ('81', '婚嫁', '77', '1');INSERT INTO `rc_throng` VALUES ('82', '游戏动漫', '0', '0');INSERT INTO `rc_throng` VALUES ('83', '冒险游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('84', '游戏产业', '82', '1');INSERT INTO `rc_throng` VALUES ('85', '动作游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('86', '战略游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('87', '游戏机', '82', '1');INSERT INTO `rc_throng` VALUES ('88', '桌游', '82', '1');INSERT INTO `rc_throng` VALUES ('89', '角色扮演', '82', '1');INSERT INTO `rc_throng` VALUES ('90', '体育游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('91', '网游', '82', '1');INSERT INTO `rc_throng` VALUES ('92', '单机游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('93', '动漫', '82', '1');INSERT INTO `rc_throng` VALUES ('94', '手游', '82', '1');INSERT INTO `rc_throng` VALUES ('95', '沙盒游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('96', '棋牌游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('97', '射击游戏', '82', '1');INSERT INTO `rc_throng` VALUES ('98', '电竞', '82', '1');INSERT INTO `rc_throng` VALUES ('99', '旅游美食', '0', '0');INSERT INTO `rc_throng` VALUES ('100', '旅游', '99', '1');INSERT INTO `rc_throng` VALUES ('101', '美食', '99', '1');INSERT INTO `rc_throng` VALUES ('102', '母婴育儿', '0', '0');INSERT INTO `rc_throng` VALUES ('103', '孕产', '102', '1');INSERT INTO `rc_throng` VALUES ('104', '育儿', '102', '1');INSERT INTO `rc_throng` VALUES ('105', '生活健康', '0', '0');INSERT INTO `rc_throng` VALUES ('106', '护理', '105', '1');INSERT INTO `rc_throng` VALUES ('107', '疾病', '105', '1');INSERT INTO `rc_throng` VALUES ('108', '健身', '105', '1');INSERT INTO `rc_throng` VALUES ('109', '养生', '105', '1');INSERT INTO `rc_throng` VALUES ('110', '心理健康', '105', '1');INSERT INTO `rc_throng` VALUES ('111', '癌症', '105', '1');INSERT INTO `rc_throng` VALUES ('112', '传染病', '105', '1');INSERT INTO `rc_throng` VALUES ('113', '胃肠病', '105', '1');INSERT INTO `rc_throng` VALUES ('114', '颈椎病', '105', '1');INSERT INTO `rc_throng` VALUES ('115', '口腔护理', '105', '1');INSERT INTO `rc_throng` VALUES ('116', '瘦身', '105', '1');INSERT INTO `rc_throng` VALUES ('117', '儿科', '105', '1');INSERT INTO `rc_throng` VALUES ('118', '药品', '105', '1');INSERT INTO `rc_throng` VALUES ('119', '保健品', '105', '1');INSERT INTO `rc_throng` VALUES ('120', '皮肤病', '105', '1');INSERT INTO `rc_throng` VALUES ('121', '心血管病', '105', '1');INSERT INTO `rc_throng` VALUES ('122', '流感', '105', '1');INSERT INTO `rc_throng` VALUES ('123', '遗传', '105', '1');INSERT INTO `rc_throng` VALUES ('124', '呼吸道疾病', '105', '1');INSERT INTO `rc_throng` VALUES ('125', '前列腺', '105', '1');INSERT INTO `rc_throng` VALUES ('126', '整形', '105', '1');INSERT INTO `rc_throng` VALUES ('127', '传统中医', '105', '1');INSERT INTO `rc_throng` VALUES ('128', '医学新闻', '105', '1');INSERT INTO `rc_throng` VALUES ('129', '日常健康', '105', '1');INSERT INTO `rc_throng` VALUES ('130', '产科', '105', '1');INSERT INTO `rc_throng` VALUES ('131', '房产家装', '0', '0');INSERT INTO `rc_throng` VALUES ('132', '房产', '131', '1');INSERT INTO `rc_throng` VALUES ('133', '家装', '131', '1');INSERT INTO `rc_throng` VALUES ('134', '情感星座', '0', '0');INSERT INTO `rc_throng` VALUES ('135', '星座', '134', '1');INSERT INTO `rc_throng` VALUES ('136', '情感', '134', '1');INSERT INTO `rc_throng` VALUES ('137', '命理', '134', '1');INSERT INTO `rc_throng` VALUES ('138', '教育', '0', '0');INSERT INTO `rc_throng` VALUES ('139', '升学考试', '138', '1');INSERT INTO `rc_throng` VALUES ('140', '职业教育', '138', '1');INSERT INTO `rc_throng` VALUES ('141', '外语', '138', '1');INSERT INTO `rc_throng` VALUES ('142', '出国留学', '138', '1');INSERT INTO `rc_throng` VALUES ('143', '公务员考试', '138', '1');INSERT INTO `rc_throng` VALUES ('144', '艺术教育', '138', '1');INSERT INTO `rc_throng` VALUES ('145', '哲学', '138', '1');INSERT INTO `rc_throng` VALUES ('146', '家庭教育', '138', '1');INSERT INTO `rc_throng` VALUES ('147', '在线教育', '138', '1');INSERT INTO `rc_throng` VALUES ('148', '商务服务', '0', '0');INSERT INTO `rc_throng` VALUES ('149', '农林牧鱼', '148', '1');