text: # noinspection SqlNoDataSourceInspectionForFile
  
  CREATE TABLE `foo` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `birth` datetime NOT NULL COMMENT '生日',
    `avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `age` int NOT NULL DEFAULT 0,
    `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT ', 0:,1:',
    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modify` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `name` (`name`) USING BTREE,
    KEY `type` (`type`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT 'foo';
  
  CREATE TABLE `user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `password` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `display_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `age` int NOT NULL DEFAULT 0,
    `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT ', 0:,1:',
    `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'admin' COMMENT '账号类型,admin:管理,channel:渠道,author:作者',
    `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modify` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `username` (`username`) USING BTREE,
    KEY `type` (`type`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT '用户表';
  
  CREATE TABLE `role` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `value` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modify` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE `perm` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `value` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `group_id` bigint(20) NOT NULL COMMENT 'ID',
    `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modify` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE `user_role_mid` (
    `user_id` bigint(20) NOT NULL COMMENT 'ID',
    `role_id` bigint(20) NOT NULL COMMENT 'ID',
    PRIMARY KEY (`user_id`,`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE `role_perm_mid` (
    `role_id` bigint(20) NOT NULL COMMENT 'ID',
    `perm_id` bigint(20) NOT NULL COMMENT 'ID',
    PRIMARY KEY (`role_id`,`perm_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE `boo` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL COMMENT '用户编号',
    `comic_id` bigint(20) NOT NULL COMMENT '漫画编号',
    `issue_id` bigint(20) NOT NULL COMMENT '话编号',
    `price` int(11) NOT NULL DEFAULT '0' COMMENT '价格',
    `amount` int(11) NOT NULL DEFAULT '0' COMMENT '实际付费金额',
    `coupon` int(11) NOT NULL DEFAULT '0' COMMENT '书券金额',
    `product` bigint(20) NOT NULL DEFAULT '0' COMMENT '产品编号',
    `channel` bigint(20) NOT NULL DEFAULT '0' COMMENT '渠道号',
    `ip` varbinary(16) NOT NULL DEFAULT '' COMMENT 'IP地址(ATON后)',
    `remark` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注',
    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modify` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk` (`user_id`,`comic_id`,`issue_id`),
    KEY `product` (`product`),
    KEY `channel` (`channel`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='漫画订阅表';
  
  CREATE TABLE `soo` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `user_id` bigint(20) NOT NULL COMMENT '用户编号',
    PRIMARY KEY (`id`),
    KEY `name` (`name`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT 'soo';