CREATE TABLE merchant ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 商户ID, name varchar(100) NOT NULL COMMENT 商户名称, code varchar(50) NOT NULL COMMENT 商户编码, status tinyint(4) DEFAULT 1 COMMENT 状态1-正常 0-停用, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uk_code (code) ) ENGINEInnoDB DEFAULT CHARSETutf8mb4 COMMENT商户表;