11 lines
407 B
MySQL
11 lines
407 B
MySQL
|
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='帳號';
|