post/sql/collectionsModuleSql/issuer.sql

/*
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:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for issuer
-- ----------------------------
DROP TABLE IF EXISTS `issuer`;
CREATE TABLE `issuer` (
  `id` int(22) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像储存地址',
  `Issuer_name` varchar(255) DEFAULT NULL COMMENT '发行方名称',
  `mobile` varchar(255) DEFAULT NULL COMMENT '电话',
  `email` varchar(255) DEFAULT NULL COMMENT '邮件',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of issuer
-- ----------------------------
INSERT INTO `issuer` VALUES ('1', '', '黑龙江', null, null, null, null, null, null, null);
INSERT INTO `issuer` VALUES ('2', '', '黑龙江1', null, null, null, null, null, null, null);
INSERT INTO `issuer` VALUES ('3', '', '黑龙江2', null, null, null, null, null, null, null);