gitee.com/woood2/luca@v1.0.4/scripts/init.sql (about)

     1  /*
     2   Navicat Premium Data Transfer
     3  
     4   Source Server         : local
     5   Source Server Type    : MySQL
     6   Source Server Version : 80020
     7   Source Host           : 10.78.202.136:3306
     8   Source Schema         : luca
     9  
    10   Target Server Type    : MySQL
    11   Target Server Version : 80020
    12   File Encoding         : 65001
    13  
    14   Date: 23/02/2021 15:28:49
    15  */
    16  
    17  SET NAMES utf8mb4;
    18  SET FOREIGN_KEY_CHECKS = 0;
    19  
    20  -- ----------------------------
    21  -- Table structure for app
    22  -- ----------------------------
    23  DROP TABLE IF EXISTS `app`;
    24  CREATE TABLE `app` (
    25    `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    26    `appkey` varchar(32) NOT NULL COMMENT '应用标识',
    27    `secret` varchar(64) NOT NULL COMMENT '应用私钥',
    28    `name` varchar(32) NOT NULL COMMENT '应用名称',
    29    `url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '访问地址',
    30    `logo` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'logo地址',
    31    `contacts` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系方式',
    32    `disabled` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '1.禁用 0.启用',
    33    `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
    34    `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
    35    `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
    36    PRIMARY KEY (`id`),
    37    UNIQUE KEY `uniq_name` (`name`),
    38    UNIQUE KEY `uniq_appkey` (`appkey`)
    39  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
    40  
    41  -- ----------------------------
    42  -- Records of app
    43  -- ----------------------------
    44  BEGIN;
    45  INSERT INTO `app` VALUES (2, 'ss', '22', '新浪微博5', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-13 04:54:25', '2021-02-23 15:27:55', '备注');
    46  INSERT INTO `app` VALUES (3, 'weibo', '111', '新浪微博', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-16 08:34:52', '2021-02-23 15:27:54', '备注');
    47  INSERT INTO `app` VALUES (4, 'weibo2', 'todo', '新浪微博2', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-21 04:36:56', '2021-02-23 15:27:50', '备注');
    48  INSERT INTO `app` VALUES (5, 'weibo3', '333', '新浪微博3', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-21 04:44:54', '2021-02-23 15:27:57', '备注');
    49  INSERT INTO `app` VALUES (7, 'weibo9', '444', '新浪微博9', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-21 08:24:05', '2021-02-23 15:28:02', '备注');
    50  INSERT INTO `app` VALUES (8, 'weibo8', '555', '新浪微博8', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-21 08:26:21', '2021-02-23 15:28:03', '备注');
    51  INSERT INTO `app` VALUES (9, 'weibo7', 'sadf123', '新浪微博77', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-21 08:29:18', '2021-02-23 15:28:10', '备注');
    52  INSERT INTO `app` VALUES (10, 'weibo11', '#$%', '新浪微博1111', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-27 03:55:48', '2021-02-23 15:28:14', '备注');
    53  INSERT INTO `app` VALUES (12, 'weibo13', 'dfeed', '新浪微博11', 'https://weibo.com', 'https://img.t.sinajs.cn/t6/style/images/apple/wbfont.svg', '@来去之间', 0, '2020-10-27 12:07:41', '2021-02-23 15:28:17', '备注');
    54  COMMIT;
    55  
    56  SET FOREIGN_KEY_CHECKS = 1;