2.短链系统数据库和表设计

前言

咱们的短链系统是一个高并发系统，需要存储海量的数据。

因此，我们在系统设计之初，就要考虑做分库分表了。

短链系统最核心的功能是长链接和短连接的映射。

系统能够快速通过短链code，反向查询到原始的长链接。

我们最终的目的是要设计100万QPS的短链系统。

接下来，先分析一下，我们该用什么样的分库分表方案。

1 容量和性能分析

数据量估算

日新增短链: 100万QPS × 3600秒 × 24小时 × 1% × 30% = 约2.6亿条/天

年数据量: 约950亿条记录

单条记录大小: 约200字节

年存储需求: 约19TB

性能要求

读写比例: 短链系统通常读:写 = 100:1

读QPS: 99万

写QPS: 1万

2 分库分表方案

方案一：16库 × 64表 = 1024张表

数据库数量: 16个

每库表数量: 64张

总表数量: 1024张

单表数据量: 约9300万条/年

单库QPS: 6.25万 (读5.6万 + 写0.65万)

方案二：32库 × 32表 = 1024张表

数据库数量: 32个

每库表数量: 32张

总表数量: 1024张

单表数据量: 约9300万条/年

单库QPS: 3.125万 (读2.8万 + 写0.325万)

方案三：8库 × 128表 = 1024张表

数据库数量: 8个

每库表数量: 128张

总表数量: 1024张

单表数据量: 约9300万条/年

单库QPS: 12.5万 (读11.25万 + 写1.25万)

最佳推荐：16库 × 64表

基于以下考虑，推荐16库 × 64表方案。

优势分析:

1. 性能均衡: 单库6.25万QPS在MySQL优化后可承受
2. 扩展性好: 可平滑扩展到32库
3. 运维适中: 16个数据库实例便于管理
4. 资源利用: 每库64张表，分片均匀

3 数据库和表设计

通过上面的综合分析，我们分库分表的方案打算使用16库 × 64表的方案。

先创建16个数据库：

-- 创建16个分库
CREATE DATABASE IF NOT EXISTS short_link_0 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_2 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_3 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_4 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_5 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_6 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_7 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_8 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_9 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_10 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_11 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_12 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_13 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_14 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS short_link_15 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

数据库是short_link_开头，后缀是从0~15，一共是16个数据库。

每个数据库创建64张短连接映射表：

-- 在每个数据库中创建64 张分表
-- 数据库 short_link_0
USE short_link_0;
CREATE TABLE short_url_mapping_0 (
      short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
      origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
      origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
      create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
      update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
      expire_days INT DEFAULT NULL COMMENT '过期天数',
      access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
      status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
      creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
      PRIMARY KEY (short_code),
      UNIQUE KEY uk_origin_url_hash (origin_url_hash),
      KEY idx_status_create_time (status, create_time),
      KEY idx_expire_time (expire_days),
      KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_0';

CREATE TABLE short_url_mapping_1 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_1';

CREATE TABLE short_url_mapping_2 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_2';


CREATE TABLE short_url_mapping_3 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_3';

CREATE TABLE short_url_mapping_4 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_4';

CREATE TABLE short_url_mapping_5 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_5';

CREATE TABLE short_url_mapping_6 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_6';


CREATE TABLE short_url_mapping_7 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_7';


CREATE TABLE short_url_mapping_8 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_8';


CREATE TABLE short_url_mapping_9 (
         short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
         origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
         origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
         create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
         update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
         expire_days INT DEFAULT NULL COMMENT '过期天数',
         access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
         status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
         creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
         PRIMARY KEY (short_code),
         UNIQUE KEY uk_origin_url_hash (origin_url_hash),
         KEY idx_status_create_time (status, create_time),
         KEY idx_expire_time (expire_days),
         KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_9';


CREATE TABLE short_url_mapping_10 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_10';


CREATE TABLE short_url_mapping_11 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_11';


CREATE TABLE short_url_mapping_12 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_12';

CREATE TABLE short_url_mapping_13 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_13';

CREATE TABLE short_url_mapping_14 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_14';

CREATE TABLE short_url_mapping_15 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_15';

CREATE TABLE short_url_mapping_16 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_16';


CREATE TABLE short_url_mapping_17 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_17';


CREATE TABLE short_url_mapping_18 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_18';


CREATE TABLE short_url_mapping_19 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_19';


CREATE TABLE short_url_mapping_20 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_20';


CREATE TABLE short_url_mapping_21 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_21';


CREATE TABLE short_url_mapping_22 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_22';


CREATE TABLE short_url_mapping_23 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_23';


CREATE TABLE short_url_mapping_24 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_24';


CREATE TABLE short_url_mapping_25 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_25';


CREATE TABLE short_url_mapping_26 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_26';


CREATE TABLE short_url_mapping_27 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_27';


CREATE TABLE short_url_mapping_28 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_28';


CREATE TABLE short_url_mapping_29 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_29';


CREATE TABLE short_url_mapping_30 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_30';


CREATE TABLE short_url_mapping_31 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_31';

CREATE TABLE short_url_mapping_32 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_32';


CREATE TABLE short_url_mapping_33 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_33';


CREATE TABLE short_url_mapping_34 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_34';

CREATE TABLE short_url_mapping_35 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_35';

CREATE TABLE short_url_mapping_36 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_36';

CREATE TABLE short_url_mapping_37 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_37';

CREATE TABLE short_url_mapping_38 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_38';

CREATE TABLE short_url_mapping_39 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_39';

CREATE TABLE short_url_mapping_40 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_40';

CREATE TABLE short_url_mapping_41 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_41';

CREATE TABLE short_url_mapping_42 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_42';

CREATE TABLE short_url_mapping_43 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_43';


CREATE TABLE short_url_mapping_44 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_44';


CREATE TABLE short_url_mapping_45 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_45';


CREATE TABLE short_url_mapping_46 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_46';


CREATE TABLE short_url_mapping_47 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_47';


CREATE TABLE short_url_mapping_48 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_48';


CREATE TABLE short_url_mapping_49 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_49';

CREATE TABLE short_url_mapping_50 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_50';

CREATE TABLE short_url_mapping_51 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_51';

CREATE TABLE short_url_mapping_52 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_52';


CREATE TABLE short_url_mapping_53 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_53';

CREATE TABLE short_url_mapping_54 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_54';

CREATE TABLE short_url_mapping_55 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_55';

CREATE TABLE short_url_mapping_56 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_56';

CREATE TABLE short_url_mapping_57 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_57';

CREATE TABLE short_url_mapping_58 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_58';

CREATE TABLE short_url_mapping_59 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_59';

CREATE TABLE short_url_mapping_60 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_60';

CREATE TABLE short_url_mapping_61 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_61';

CREATE TABLE short_url_mapping_62 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_62';

CREATE TABLE short_url_mapping_63 (
          short_code CHAR(8) NOT NULL COMMENT '短链编码，固定8位',
          origin_url VARCHAR(2048) NOT NULL COMMENT '原始URL',
          origin_url_hash CHAR(32) NOT NULL COMMENT '原始URL的MD5哈希值',
          create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
          update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
          expire_days INT DEFAULT NULL COMMENT '过期天数',
          access_count BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
          status TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-禁用，2-已过期',
          creator VARCHAR(50) DEFAULT NULL COMMENT '创建者',
          PRIMARY KEY (short_code),
          UNIQUE KEY uk_origin_url_hash (origin_url_hash),
          KEY idx_status_create_time (status, create_time),
          KEY idx_expire_time (expire_days),
          KEY idx_creator_create_time (creator, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表_63';

从表名是short_url_mapping_开头，后缀是从0~63，一共是64张表。

上面是创建short_link_0数据库的表的脚本。

其他的数据库，也可以用上面的创建表的脚本，只是需要把第一句USE short_link_0;，后面的0，改成对应数据库的编号即可，比如：

USE short_link_1;

每张表中包含如下字段：

• short_code ：短链接字段，它是数据库的主键，为了性能考虑固定是8位。

• origin_url：原始链接地址，接口会限制最长2024个字符。

• origin_url_hash：原始链接地址的hash值，用于快速查重和索引。

• create_time： 创建时间

• update_time： 修改时间

• expire_days： 过期天数

• access_count：访问次数

• status：状态，是否有效，可以禁用

• creator： 创建者

创建了唯一索引uk_origin_url_hash，原始URL哈希，用于查重。

创建了查询索引：idx_status_create_time，状态+创建时间，用于管理查询。

创建了查询过期索引：idx_expire_time，过期时间，用于清理过期数据。

创建了统计索引：idx_creator_create_time，创建者+创建时间，用于用户统计。