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

11 lines
407 B
MySQL
Raw Permalink Normal View History

2024-07-21 15:57:56 +00:00
CREATE TABLE `account` (
`id` BIGINT NOT NULL AUTO_INCREMENT,
`account` VARCHAR(50) NOT NULL,
`token` VARCHAR(255) NOT NULL,
`platform` INT NOT NULL COMMENT '平台類型 1. ark 2. google',
`create_time` BIGINT NOT NULL DEFAULT 0,
`update_time` BIGINT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE INDEX `uk_account` (`account` ASC)
)ENGINE=InnoDB COMMENT='帳號';