text: CREATE TABLE IF NOT EXISTS `user_info` (
    `user_id` int(11) NOT NULL,
    `username` varchar(16) NOT NULL,
    `email` varchar(255) DEFAULT NULL,
    `password` varchar(64) NOT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`user_id`),
    UNIQUE KEY `user_id_UNIQUE` (`user_id`),
    UNIQUE KEY `username_UNIQUE` (`username`),
    KEY `idx_username_email` (`username`,`email`),
    CONSTRAINT `fk_user_id_user_info_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  