
-- ----------------------------
-- Table structure for xy_vip
-- ----------------------------
DROP TABLE IF EXISTS `xy_vip`;
CREATE TABLE `xy_vip`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_company` tinyint(1) NULL DEFAULT 1,
  `price` decimal(10, 2) NULL DEFAULT 0.00,
  `discount` tinyint(0) NULL DEFAULT 0,
  `default` tinyint(1) NULL DEFAULT 0,
  `status` tinyint(1) NULL DEFAULT 1,
  `stock` int(0) NULL DEFAULT 0,
  `sold` int(0) NULL DEFAULT 0,
  `surplus_stock` int(0) NULL DEFAULT 0,
  `va_discount` tinyint(0) NULL DEFAULT 0,
  `level` tinyint(0) NULL DEFAULT 1,
  `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
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '套餐' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xy_vip
-- ----------------------------
INSERT INTO `xy_vip` VALUES (1, '免费会员', '', 1, 0.00, 0, 1, 1, 0, 1, 0, 0, 0, NULL, NULL, 1618132225, 1595835848);
INSERT INTO `xy_vip` VALUES (2, '月度会员', '', 1, 500.00, 60, 0, 1, 0, 40, 0, 95, 1, NULL, NULL, 1617800728, 1595838987);
INSERT INTO `xy_vip` VALUES (3, '季度会员', '', 1, 1500.00, 50, 0, 1, 100, 7, 93, 93, 2, NULL, NULL, 1618133742, 1595927252);
INSERT INTO `xy_vip` VALUES (4, '半年会员', '', 1, 3000.00, 50, 0, 1, 100, 12, 88, 88, 3, NULL, NULL, 1618050562, 1595927281);
INSERT INTO `xy_vip` VALUES (5, '全年会员', '', 1, 6000.00, 50, 0, 1, 100, 14, 86, 80, 4, NULL, NULL, 1618050057, 1595927301);
INSERT INTO `xy_vip` VALUES (6, '免费会员', '', 0, 0.00, 0, 1, 1, 0, 0, 0, 0, 0, NULL, NULL, 1618133860, 1597286715);
