
-- ----------------------------
-- Table structure for xy_user_vip
-- ----------------------------
DROP TABLE IF EXISTS `xy_user_vip`;
CREATE TABLE `xy_user_vip`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(0) NULL DEFAULT NULL,
  `company_vip_level` tinyint(0) NULL DEFAULT 0,
  `company_vip_time` bigint(11) NULL DEFAULT NULL,
  `personal_vip_level` tinyint(0) NULL DEFAULT 0,
  `personal_vip_time` bigint(11) NULL DEFAULT NULL,
  `release_jobs_sum` int(0) NULL DEFAULT 0,
  `download_resume` int(0) NULL DEFAULT 0,
  `im_max_people` int(0) NULL DEFAULT 0,
  `top_day` int(0) NULL DEFAULT 0,
  `refresh_sum` int(0) NULL DEFAULT 0,
  `urgent_day` int(0) NULL DEFAULT 0,
  `invite_aninterview` int(0) NULL DEFAULT 0,
  `job_fair` int(0) NULL DEFAULT 0,
  `today_down_resume` int(0) NULL DEFAULT 0,
  `update_vip` tinyint(1) NULL DEFAULT 1,
  `update_time` int(0) NULL DEFAULT NULL,
  `create_time` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户-套餐' ROW_FORMAT = Dynamic;
