Seata 1.4.x 找不到建表语句

傷城~ 2022-11-11 05:10 127阅读 0赞

找到下载的`seata`目录下`conf`文件夹，打开`README-zh.md`  
其内容：

# 脚本说明
    
    ## [client](https://github.com/seata/seata/tree/develop/script/client) 
    
    > 存放用于客户端的配置和SQL
    
    - at: AT模式下的 `undo_log` 建表语句
    - conf: 客户端的配置文件
    - saga: SAGA 模式下所需表的建表语句
    - spring: SpringBoot 应用支持的配置文件
    
    ## [server](https://github.com/seata/seata/tree/develop/script/server)
    
    > 存放server侧所需SQL和部署脚本
    
    - db: server 侧的保存模式为 `db` 时所需表的建表语句
    - docker-compose: server 侧通过 docker-compose 部署的脚本
    - helm: server 侧通过 Helm 部署的脚本
    - kubernetes: server 侧通过 Kubernetes 部署的脚本
    
    ## [config-center](https://github.com/seata/seata/tree/develop/script/config-center)
    
    > 用于存放各种配置中心的初始化脚本，执行时都会读取 `config.txt`配置文件，并写入配置中心
    
    - nacos: 用于向 Nacos 中添加配置
    - zk: 用于向 Zookeeper 中添加配置，脚本依赖 Zookeeper 的相关脚本，需要手动下载；ZooKeeper相关的配置可以写在 `zk-params.txt` 中，也可以在执行的时候输入
    - apollo: 向 Apollo 中添加配置，Apollo 的地址端口等可以写在 `apollo-params.txt`，也可以在执行的时候输入
    - etcd3: 用于向 Etcd3 中添加配置
    - consul: 用于向 consul 中添加配置

根据需要类型，点击标题超链接，这里我配置的是`server`，打开[https://github.com/seata/seata/tree/develop/script/server][https_github.com_seata_seata_tree_develop_script_server]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDE0OTYyNA_size_16_color_FFFFFF_t_70_pic_center]

*  进入`db`文件夹  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDE0OTYyNA_size_16_color_FFFFFF_t_70_pic_center 1]
 *  选择对应数据库，我选择`mysql`，建表语句就找到了

-- -------------------------------- The script used when storeMode is 'db' --------------------------------
    -- the table to store GlobalSession data
    CREATE TABLE IF NOT EXISTS `global_table`
    (
        `xid`                       VARCHAR(128) NOT NULL,
        `transaction_id`            BIGINT,
        `status`                    TINYINT      NOT NULL,
        `application_id`            VARCHAR(32),
        `transaction_service_group` VARCHAR(32),
        `transaction_name`          VARCHAR(128),
        `timeout`                   INT,
        `begin_time`                BIGINT,
        `application_data`          VARCHAR(2000),
        `gmt_create`                DATETIME,
        `gmt_modified`              DATETIME,
        PRIMARY KEY (`xid`),
        KEY `idx_gmt_modified_status` (`gmt_modified`, `status`),
        KEY `idx_transaction_id` (`transaction_id`)
    ) ENGINE = InnoDB
      DEFAULT CHARSET = utf8;
    
    -- the table to store BranchSession data
    CREATE TABLE IF NOT EXISTS `branch_table`
    (
        `branch_id`         BIGINT       NOT NULL,
        `xid`               VARCHAR(128) NOT NULL,
        `transaction_id`    BIGINT,
        `resource_group_id` VARCHAR(32),
        `resource_id`       VARCHAR(256),
        `branch_type`       VARCHAR(8),
        `status`            TINYINT,
        `client_id`         VARCHAR(64),
        `application_data`  VARCHAR(2000),
        `gmt_create`        DATETIME(6),
        `gmt_modified`      DATETIME(6),
        PRIMARY KEY (`branch_id`),
        KEY `idx_xid` (`xid`)
    ) ENGINE = InnoDB
      DEFAULT CHARSET = utf8;
    
    -- the table to store lock data
    CREATE TABLE IF NOT EXISTS `lock_table`
    (
        `row_key`        VARCHAR(128) NOT NULL,
        `xid`            VARCHAR(128),
        `transaction_id` BIGINT,
        `branch_id`      BIGINT       NOT NULL,
        `resource_id`    VARCHAR(256),
        `table_name`     VARCHAR(32),
        `pk`             VARCHAR(36),
        `gmt_create`     DATETIME,
        `gmt_modified`   DATETIME,
        PRIMARY KEY (`row_key`),
        KEY `idx_branch_id` (`branch_id`)
    ) ENGINE = InnoDB
      DEFAULT CHARSET = utf8;

[https_github.com_seata_seata_tree_develop_script_server]: https://github.com/seata/seata/tree/develop/script/server
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDE0OTYyNA_size_16_color_FFFFFF_t_70_pic_center]: /images/20221022/c9d9d25d9e4c4a89a89e911db4f69057.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDE0OTYyNA_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221022/bab7cdc79cc44b3e9d8de7818b66b3f1.png