MySQL 用户信息表优化建议 - 提高性能和存储效率

CREATE TABLE userinfo(\n id INT UNSIGNED AUTO_INCREMENT NOT NULL,\n roles ENUM('role1', 'role2', 'role3') NOT NULL,\n username VARCHAR(50) UNIQUE NOT NULL,\n password VARCHAR(50) NOT NULL,\n email VARCHAR(100) UNIQUE NOT NULL,\n vcode VARCHAR(10) NOT NULL,\n sex BOOLEAN DEFAULT 0,\n age TINYINT UNSIGNED,\n title VARCHAR(500),\n avatar VARCHAR(100),\n register_time TIMESTAMP NOT NULL,\n online TIMESTAMP NOT NULL,\n downline TIMESTAMP NOT NULL,\n ulike TEXT,\n collect TEXT,\n uhistory TEXT,\n ip VARCHAR(15) UNSIGNED,\n is_delete BOOLEAN DEFAULT 0,\n feedback INT UNSIGNED,\n system_msg INT UNSIGNED,\n is_talk BOOLEAN DEFAULT 0,\n warning TINYINT UNSIGNED,\n ucomment INT UNSIGNED,\n article INT UNSIGNED,\n PRIMARY KEY (id, username),\n INDEX idx_username (username),\n INDEX idx_email (email),\n INDEX idx_register_time (register_time)\n) ENGINE=InnoDB DEFAULT CHARSET=UTF8;