reduce短网址平台

本项目为Coody Framework+Minicat首秀，短网址服务平台。部署在服务器，使用短域名解析即可提供服务。

全项目打包后(带前端页面)大小约：2.5M，非常精简。

前端采用Amaze UI，后端采用Coody Framework MVC，数据库采用H2DB

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.18</version>
</dependency>

coody.bean.dataSource.class=org.coody.framework.esource.ESource
coody.bean.dataSource.field.driver=com.mysql.jdbc.Driver
coody.bean.dataSource.field.url=jdbc\:mysql\://localhost:3306/reduce?useUnicode\=true&characterEncoding\=UTF-8&serverTimezone=GMT%2B8
coody.bean.dataSource.field.user=reduce
coody.bean.dataSource.field.password=Coody888!
coody.bean.dataSource.field.maxPoolSize=64
coody.bean.dataSource.field.minPoolSize=2
coody.bean.dataSource.field.initialPoolSize=5

CREATE TABLE `short_info` (
  `id` bigint(32) NOT NULL AUTO_INCREMENT,
  `frequency` bigint(32) NOT NULL DEFAULT 0,
  `status` tinyint(4) DEFAULT '1',
  `appId` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) 
);
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(32) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) ,
  UNIQUE KEY `email_uk` (`email`) USING BTREE
) ;
CREATE TABLE `app_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32)  DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `unionId` varchar(32) DEFAULT NULL,
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP,
  `status` int(2) DEFAULT '0',
  PRIMARY KEY (`id`) ,
  UNIQUE KEY `app_uk` (`unionId`)  USING BTREE
) ;
CREATE TABLE `email_queue` (
  `id` bigint(32) NOT NULL AUTO_INCREMENT,
  `unionId` varchar(32) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `context` varchar(256) DEFAULT NULL,
  `targeEmail` varchar(32) DEFAULT NULL,
  `status` int(2) DEFAULT '0',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP,
  `millisecond` bigint(32) DEFAULT NULL,
  `updateTime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
)

作者：Coody

版权：©2014-2020 Test404 All right reserved. 版权所有

反馈邮箱：644556636@qq.com  交流群号:218481849