ark-member/generate/database/mysql/20230529020011_account_uid_...

9 lines
281 B
MySQL
Raw Permalink Normal View History

2024-07-21 15:57:56 +00:00
CREATE TABLE `account_to_uid` (
`id` BIGINT NOT NULL AUTO_INCREMENT,
`account` VARCHAR(50) NOT NULL,
`uid` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `uk_account` (`account` ASC),
INDEX `idx_uid` (`uid` ASC)
)ENGINE=InnoDB COMMENT='帳號轉換表';