| 123456789101112131415161718192021222324 |
- -- ============================================================
- -- 应用凭证模块建表脚本（移植自 sdf-serve t_application_credentials，ude 库）
- -- 执行目标: 10.10.10.30:3306 / ude
- -- 说明: DDL 与 sdf 库源表一致;仅去掉 AUTO_INCREMENT=24(row 起始归零)
- -- ============================================================
- CREATE TABLE IF NOT EXISTS `t_application_credentials` (
- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '凭证 ID',
- `cred_iden` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用标识',
- `name` varchar(255) NOT NULL COMMENT '应用名称',
- `api_key` char(32) NOT NULL COMMENT '对外公钥',
- `api_secret` char(64) NOT NULL COMMENT 'HMAC 原始密钥（明文存储）',
- `hmac_algo` varchar(32) NOT NULL DEFAULT 'HMAC-SM3' COMMENT '签名算法',
- `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '启用状态：1=启用，2=禁用',
- `description` varchar(512) DEFAULT NULL COMMENT '应用描述',
- `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
- `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `updated_by` varchar(255) NOT NULL COMMENT '更新人',
- `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- UNIQUE KEY `idx_api_key` (`api_key`) USING BTREE,
- UNIQUE KEY `idx_cred_iden` (`cred_iden`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='应用凭证表'
|
