11 lines
419 B
SQL
Executable File
11 lines
419 B
SQL
Executable File
DROP TABLE IF EXISTS `T_CUSTOMER`;
|
|
CREATE TABLE `T_CUSTOMER` (
|
|
`UUID` varchar(32) NOT NULL DEFAULT '',
|
|
`USERNAME` varchar(64) DEFAULT NULL,
|
|
`ONLINE_STATE` int(2) DEFAULT NULL,
|
|
`LAST_CUSTOMER_TIME` datetime DEFAULT NULL,
|
|
`LAST_ONLINE_TIME` datetime DEFAULT NULL,
|
|
`LAST_OFFLINE_TIME` datetime DEFAULT NULL,
|
|
`CREATE_TIME` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`UUID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |