· 9 years ago · Nov 22, 2016, 09:28 PM
1CREATE TABLE IF NOT EXISTS `api2_tokenv2` ( `key` varchar(40) NOT NULL PRIMARY KEY, `user` varchar(255) NOT NULL, `platform` varchar(32) NOT NULL, `device_id` varchar(40) NOT NULL, `device_name` varchar(40) NOT NULL, `platform_version` varchar(16) NOT NULL, `client_version` varchar(16) NOT NULL, `last_accessed` datetime NOT NULL, `last_login_ip` char(39), wiped_at datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT `1970-01-01 00:00:00`, UNIQUE (`user`, `platform`, `device_id`)) ENGINE=INNODB;