
-- ----------------------------
-- Table structure for xy_ads
-- ----------------------------
DROP TABLE IF EXISTS `xy_ads`;
CREATE TABLE `xy_ads`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(0) NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` int(0) NULL DEFAULT 9999,
  `ads_icon` tinyint(1) NULL DEFAULT 0,
  `col` tinyint(0) NULL DEFAULT 12,
  `status` tinyint(1) NULL DEFAULT 1,
  `province` int(0) NULL DEFAULT NULL,
  `city` int(0) NULL DEFAULT NULL,
  `area` int(0) NULL DEFAULT NULL,
  `industry` int(0) 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 `pid`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '广告图片' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xy_ads
-- ----------------------------
INSERT INTO `xy_ads` VALUES (41, 1, '首页轮播-01', '/uploads/ads/image/20210412/18baf5fbe6abf64b4335379a446b0bde.png', 'http://www.xycms.com', 1, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196538, 1618196366);
INSERT INTO `xy_ads` VALUES (42, 1, '首页轮播-02', '/uploads/ads/image/20210412/edb21bc7258f66c3db9892acbbd1f497.png', 'http://www.xycms.com', 2, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196550, 1618196455);
INSERT INTO `xy_ads` VALUES (43, 1, '首页轮播-03', '/uploads/ads/image/20210412/eddc442213ec0ce00e5688be93a6ea23.png', 'http://www.xycms.com', 4, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196561, 1618196488);
INSERT INTO `xy_ads` VALUES (44, 1, '首页轮播-04', '/uploads/ads/image/20210412/1d8fc2817c9082f021eca67ca75c6e93.png', 'http://www.xycms.com', 3, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196556, 1618196512);
INSERT INTO `xy_ads` VALUES (45, 4, '海量职位等您来！', '/uploads/ads/image/20210412/59aa0a9f257e6315785f8935782c7b1c.png', 'http://www.xycms.com', 9999, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196694, 1618196694);
INSERT INTO `xy_ads` VALUES (46, 5, 'A1-01', '/uploads/ads/image/20210412/bafef2b74ac960857c543be2336492f1.png', 'http://www.xycms.com', 9999, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196899, 1618196899);
INSERT INTO `xy_ads` VALUES (47, 5, 'A1-02', '/uploads/ads/image/20210412/7961fb4a17baf39346c1835c0fd2684d.png', 'http://www.xycms.com', 9999, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196911, 1618196911);
INSERT INTO `xy_ads` VALUES (48, 5, 'A1-03', '/uploads/ads/image/20210412/6672ffe0ca2823757a7a71434f1925d5.png', 'http://www.xycms.com', 9999, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196920, 1618196920);
INSERT INTO `xy_ads` VALUES (49, 5, 'A1-04', '/uploads/ads/image/20210412/05c573ecf49cb6465ab073114fabc18c.png', 'http://www.xycms.com', 9999, 1, 12, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618196929, 1618196929);
INSERT INTO `xy_ads` VALUES (50, 6, 'A2-01', '/uploads/ads/image/20210412/9f41c9439ee076ef285b4659e39637be.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197403, 1618196993);
INSERT INTO `xy_ads` VALUES (51, 6, 'A2-02', '/uploads/ads/image/20210412/2a933420254985da5d33c4c2b77bf60f.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197402, 1618197002);
INSERT INTO `xy_ads` VALUES (52, 6, 'A2-03', '/uploads/ads/image/20210412/172285160a3aacf197f8321548938b57.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197401, 1618197011);
INSERT INTO `xy_ads` VALUES (53, 6, 'A2-04', '/uploads/ads/image/20210412/e10b4f5c34b58172460bc7af684eeea1.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197400, 1618197021);
INSERT INTO `xy_ads` VALUES (54, 6, 'A2-05', '/uploads/ads/image/20210412/75521a603a7b772e23771949d369b803.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197399, 1618197031);
INSERT INTO `xy_ads` VALUES (55, 6, 'A2-06', '/uploads/ads/image/20210412/b4b1cae8dd84470af3c161bf1e0fc334.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197399, 1618197050);
INSERT INTO `xy_ads` VALUES (56, 6, 'A2-07', '/uploads/ads/image/20210412/719379c46a53dda605d774b1c8628660.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197398, 1618197073);
INSERT INTO `xy_ads` VALUES (57, 6, 'A2-08', '/uploads/ads/image/20210412/86f4f6e0d73f55e0abbd94d00330127f.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197397, 1618197087);
INSERT INTO `xy_ads` VALUES (58, 6, 'A2-09', '/uploads/ads/image/20210412/a34f96cf484f748ed14eeb6cac29d1d8.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197397, 1618197158);
INSERT INTO `xy_ads` VALUES (59, 6, 'A2-10', '/uploads/ads/image/20210412/18bef02b6211d57f3019bf660d029e0d.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618197395, 1618197189);
INSERT INTO `xy_ads` VALUES (60, 6, 'A2-11', '/uploads/ads/image/20210412/2904ff404a93560faec8fe256a640d90.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198253, 1618198218);
INSERT INTO `xy_ads` VALUES (61, 6, 'A2-12', '/uploads/ads/image/20210412/d58fa319bc2e7879346975466650e372.png', 'http://www.xycms.com', 9999, 1, 3, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198251, 1618198236);
INSERT INTO `xy_ads` VALUES (62, 6, 'A2-13', '/uploads/ads/image/20210412/45f6c214002afec76f5c82b52be917da.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198605, 1618198459);
INSERT INTO `xy_ads` VALUES (63, 6, 'A2-14', '/uploads/ads/image/20210412/5aedfeb9e8079c151513d31d102f1fe9.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198604, 1618198472);
INSERT INTO `xy_ads` VALUES (64, 6, 'A2-15', '/uploads/ads/image/20210412/2a250ce7d53bb127bb9c449a0061b1b2.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198602, 1618198487);
INSERT INTO `xy_ads` VALUES (65, 6, 'A2-16', '/uploads/ads/image/20210412/92f8091cbd3c5d2ab52a67218a970016.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198600, 1618198501);
INSERT INTO `xy_ads` VALUES (66, 6, 'A2-17', '/uploads/ads/image/20210412/91529d4794bbf8df9c0e029aae22612b.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198599, 1618198510);
INSERT INTO `xy_ads` VALUES (67, 6, 'A2-18', '/uploads/ads/image/20210412/8efe1a4d14f90c5f6508dbc0e3aae2f7.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198598, 1618198521);
INSERT INTO `xy_ads` VALUES (68, 6, 'A2-19', '/uploads/ads/image/20210412/25689afcd46efb1f5291e22c807d4965.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618199024, 1618198535);
INSERT INTO `xy_ads` VALUES (69, 6, 'A2-20', '/uploads/ads/image/20210412/98c6d8cbb377a378c8fdd107c8343767.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198597, 1618198545);
INSERT INTO `xy_ads` VALUES (70, 6, 'A2-21', '/uploads/ads/image/20210412/5e9469ba6772807401db5ce9947e44b3.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618198596, 1618198553);
INSERT INTO `xy_ads` VALUES (71, 6, 'A2-22', '/uploads/ads/image/20210412/8c3f1b312101e9c668e6965001d6ceb3.png', 'http://www.xycms.com', 9999, 1, 6, 1, NULL,NULL,NULL,NULL,NULL, NULL, 1618199099, 1618199054);
