/*
Navicat MySQL Data Transfer

Source Server         : ruoyi
Source Server Version : 50737
Source Host           : 120.76.241.226:3306
Source Database       : post

Target Server Type    : MYSQL
Target Server Version : 50737
File Encoding         : 65001

Date: 2023-02-26 14:37:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for post_collections
-- ----------------------------
DROP TABLE IF EXISTS `post_collections`;
CREATE TABLE `post_collections` (
  `id` int(22) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `system_id` int(22) DEFAULT NULL COMMENT '套系id',
  `issuer_id` int(22) DEFAULT NULL COMMENT '发行方id',
  `name` varchar(255) DEFAULT NULL COMMENT '套系名称',
  `start_time` datetime DEFAULT NULL COMMENT '售卖开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '售卖结束时间',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `status` char(1) DEFAULT '4' COMMENT '0 预售 1 已售尽 2正在售卖 3已过期  4未上架',
  `collections_number` int(22) DEFAULT NULL COMMENT '藏品数量',
  `collections_story` varchar(255) DEFAULT NULL COMMENT '藏品故事',
  `image` varchar(255) DEFAULT NULL COMMENT '藏品图片储存地址',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `del_flag` char(1) DEFAULT '0' COMMENT '0 不删除 1 删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of post_collections
-- ----------------------------
INSERT INTO `post_collections` VALUES ('3', '1', '1', null, '2023-02-09 19:49:59', '2023-02-16 19:49:56', '1.00', '3', '10', null, null, '2023-02-15 16:16:46', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('4', '1', '3', null, '2023-02-10 19:50:03', '2023-02-17 19:49:53', '2.00', '3', '1', null, null, '2023-02-15 16:17:44', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('5', '1', '2', 'sas', '2023-02-15 19:50:07', '2023-02-24 19:49:46', '3.00', '2', '1', null, null, '2023-02-15 16:17:51', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('6', '2', '2', null, '2023-02-20 19:48:37', '2023-02-21 19:48:47', '4.00', '0', '1', null, null, '2023-02-15 16:57:30', '2023-02-19 15:19:44', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('7', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-24 00:00:00', '44.00', '1', '0', 'string', 'string', '2023-02-15 18:10:44', '2023-02-19 15:19:42', 'string', 'admin', '0');
INSERT INTO `post_collections` VALUES ('8', '2', '2', null, '2023-02-15 19:50:12', '2023-02-16 19:49:50', '444.00', '3', '1', null, null, '2023-02-15 18:17:28', '2023-02-19 15:19:44', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('9', '3', '1', 'string', '2023-02-15 00:00:00', '2023-02-15 00:00:00', '44444.00', '4', '1', 'string', 'string', '2023-02-16 12:17:02', '2023-02-18 23:06:37', 'string', 'admin', '0');
INSERT INTO `post_collections` VALUES ('10', '4', '1', 'string', '2023-02-15 00:00:00', '2023-02-19 00:00:00', null, '4', '1', 'string', 'string', '2023-02-16 20:22:34', '2023-02-16 20:22:34', null, null, '0');
INSERT INTO `post_collections` VALUES ('11', '4', '1', 'string', '2023-02-15 00:00:00', '2023-02-16 00:00:00', null, '4', '1', 'string', 'string', '2023-02-16 20:25:13', '2023-02-16 20:25:13', null, null, '0');
INSERT INTO `post_collections` VALUES ('12', '4', '1', 'string', '2023-02-19 00:00:00', '2023-02-19 00:00:00', null, '4', '1', 'string', 'string', '2023-02-16 20:25:44', '2023-02-16 20:25:44', null, null, '0');
INSERT INTO `post_collections` VALUES ('13', '4', '1', 'string', '2023-02-14 00:00:00', '2023-02-19 00:00:00', null, '4', '1', 'string', 'string', '2023-02-16 20:26:11', '2023-02-16 20:26:11', null, null, '0');
INSERT INTO `post_collections` VALUES ('14', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-17 00:00:00', null, '3', '1', 'string', 'string', '2023-02-16 20:30:02', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('15', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-18 00:00:00', null, '3', '1', 'string', 'string', '2023-02-16 22:06:08', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('16', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-18 00:00:00', null, '3', '1', 'string', 'string', '2023-02-16 22:08:29', '2023-02-19 15:19:42', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('17', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-18 00:00:00', null, '3', '8', 'string', 'string', '2023-02-16 22:11:47', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('18', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-18 00:00:00', null, '3', '8', 'string', 'string', '2023-02-16 22:12:41', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('19', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-17 00:00:00', null, '3', '1', 'string', 'string', '2023-02-16 22:21:04', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('20', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-17 00:00:00', null, '3', '1', 'string', 'string', '2023-02-16 22:23:39', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('21', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-17 00:00:00', null, '3', '0', 'string', 'string', '2023-02-16 22:24:19', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('22', '1', '1', 'string', '2023-02-15 00:00:00', '2023-02-15 00:00:00', null, '3', '0', 'string', 'string', '2023-02-16 22:24:40', '2023-02-19 15:19:43', null, 'admin', '0');
INSERT INTO `post_collections` VALUES ('23', '1', '1', 'string', '2023-02-15 09:30:56', '2023-02-17 09:30:56', null, '3', '1', 'string', 'string', '2023-02-16 23:16:35', '2023-02-19 15:19:43', 'admin', 'admin', '0');
INSERT INTO `post_collections` VALUES ('24', '1', '1', 'czm', '2023-02-15 09:30:56', '2023-02-19 09:30:56', null, '3', '1', 'string', 'string', '2023-02-17 12:00:43', '2023-02-19 15:19:43', 'admin', 'admin', '0');
INSERT INTO `post_collections` VALUES ('25', '8', '1', 'czm1', '2023-02-15 09:30:56', '2023-02-19 09:30:56', '3000.00', '3', '1', 'string', 'string', '2023-02-17 12:02:34', '2023-02-19 21:44:57', 'admin', 'admin', '0');
INSERT INTO `post_collections` VALUES ('26', '8', '1', 'czm2', '2023-02-15 09:30:56', '2023-02-18 09:30:56', null, '3', '1', 'string', 'string', '2023-02-17 21:05:46', '2023-02-19 21:44:57', 'admin', 'admin', '0');
INSERT INTO `post_collections` VALUES ('27', '9', '1', 'string222', '2023-02-15 09:30:56', '2023-02-19 09:30:56', null, '3', '1', 'string', 'string', '2023-02-17 21:08:13', '2023-02-19 21:40:49', 'admin', 'admin', '0');
INSERT INTO `post_collections` VALUES ('28', '9', '1', 'ssss', '2023-02-15 09:30:56', '2023-02-19 09:30:56', null, '0', '1', 'string', 'string', '2023-02-18 22:40:30', '2023-02-18 23:06:37', 'admin', 'admin', '1');
INSERT INTO `post_collections` VALUES ('29', '3', '1', 'sdada', '2023-02-15 09:30:56', '2023-02-20 09:30:56', null, '4', '1', 'string', 'string', '2023-02-19 18:56:37', '2023-02-19 18:56:37', 'admin', 'admin', '0');
