CREATE TABLE `t_test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`created` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`test_id` varchar(222) DEFAULT NULL,
`love_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;