
-- ----------------------------
-- Table structure for xy_ads_position
-- ----------------------------
DROP TABLE IF EXISTS `xy_ads_position`;
CREATE TABLE `xy_ads_position`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `app_id` int(0) NULL DEFAULT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alias` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1,
  `width` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `height` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `start_time` int(0) NULL DEFAULT NULL,
  `end_time` int(0) NULL DEFAULT NULL,
  `update_time` int(0) NULL DEFAULT NULL,
  `create_time` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `alias`(`alias`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '广告位' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xy_ads_position
-- ----------------------------
INSERT INTO `xy_ads_position` VALUES (1, 1, '首页轮播', 'home_banner', 1, '638', '265', NULL, NULL, 1617441242, 1593413018);
INSERT INTO `xy_ads_position` VALUES (4, 1, '首页登录下方', 'home_logwin', 1, '270', '137', NULL, NULL, 1617961458, 1593509321);
INSERT INTO `xy_ads_position` VALUES (5, 1, '首页-A1', 'home_a1', 1, 'auto', '60', NULL, NULL, 1617964516, 1593509559);
INSERT INTO `xy_ads_position` VALUES (6, 1, '首页-A2', 'home_a2', 1, 'auto', '60', NULL, NULL, 1617964522, 1594367967);
INSERT INTO `xy_ads_position` VALUES (7, 2, '首页轮播-企业', 'company_banner', 1, 'auto', '124', NULL, NULL, 1617441233, 1606459232);
INSERT INTO `xy_ads_position` VALUES (8, 2, '首页轮播-求职者', 'personal_banner', 1, 'auto', '124', NULL, NULL, 1617441276, 1606459608);
INSERT INTO `xy_ads_position` VALUES (9, 4, '首页轮播-企业', 'company_banner', 1, 'auto', '124', NULL, NULL, 1617441285, 1609151669);
INSERT INTO `xy_ads_position` VALUES (10, 4, '首页轮播-求职者', 'personal_banner', 1, 'auto', '124', NULL, NULL, 1617441294, 1609151744);
INSERT INTO `xy_ads_position` VALUES (11, 6, '首页轮播-企业', 'company_banner', 1, 'auto', '124', NULL, NULL, 1617441305, 1609151769);
INSERT INTO `xy_ads_position` VALUES (12, 6, '首页轮播-求职者', 'personal_banner', 1, 'auto', '124', NULL, NULL, 1617441314, 1609151788);
INSERT INTO `xy_ads_position` VALUES (13, 1, '导航栏右侧', 'header_right', 1, 'auto', '50', NULL, NULL, 1617441321, 1613960955);
INSERT INTO `xy_ads_position` VALUES (14, 1, '网站底部', 'footer', 1, 'auto', '42', NULL, NULL, 1617441327, 1614678486);
INSERT INTO `xy_ads_position` VALUES (15, 2, '个人中心底部-企业', 'company_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441336, 1606459232);
INSERT INTO `xy_ads_position` VALUES (16, 2, '个人中心底部-求职者', 'personal_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441346, 1606459608);
INSERT INTO `xy_ads_position` VALUES (17, 4, '个人中心底部-企业', 'company_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441357, 1609151669);
INSERT INTO `xy_ads_position` VALUES (18, 4, '个人中心底部-求职者', 'personal_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441364, 1609151669);
INSERT INTO `xy_ads_position` VALUES (19, 6, '个人中心底部-企业', 'company_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441373, 1609151769);
INSERT INTO `xy_ads_position` VALUES (20, 6, '个人中心底部-求职者', 'personal_member_footer_ads', 1, 'auto', '75', NULL, NULL, 1617441382, 1609151788);
INSERT INTO `xy_ads_position` VALUES (21, 1, '搜索职位', 'search_jobs', 1, '350', 'auto', NULL, NULL, 1617609153, 1617608674);
INSERT INTO `xy_ads_position` VALUES (22, 1, '搜索人才', 'search_resume', 1, '350', 'auto', NULL, NULL, 1617609159, 1617608715);
INSERT INTO `xy_ads_position` VALUES (23, 1, '资讯列表Banner', 'news_banner', 1, 'auto', '265', NULL, NULL, 1617609172, 1617608909);
INSERT INTO `xy_ads_position` VALUES (24, 1, '资讯列表', 'article_list', 1, '300', 'auto', NULL, NULL, 1617609179, 1617608943);
INSERT INTO `xy_ads_position` VALUES (25, 1, '首页-A3', 'home_a3', 1, 'auto', '60', NULL, NULL, 1617964526, 1617961565);
