CREATE TABLE `lyrics` ( `lyric_id` int(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `status_id` int(11) NOT NULL default '0', `text` varchar(175) NOT NULL default '', `user_id` int(11) NOT NULL default '0', `user_name` varchar(25) NOT NULL default '', `handle` varchar(25) NOT NULL default '', `posted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`lyric_id`), KEY `timestamp` (`timestamp`,`user_id`,`posted`), KEY `handle` (`handle`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=964 ;