View Single Post
Old 12-26-2008, 04:36 PM  
jimbona
Confirmed User
 
Join Date: Jan 2007
Posts: 190
@naughty, the sql is in tagcloud_sql.sql

Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";



CREATE TABLE `lyrics_tags` (
  `tag_id` int(11) NOT NULL auto_increment,
  `tag_name` text NOT NULL,
  `count` int(11) default '0',
  `search_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tag_id`)
) ENGINE=INNODB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1615 ;

--
-- Dumping data for table `lyrics_tags`
--

INSERT INTO `lyrics_tags` VALUES(1432, 'rihanna', 40, '2008-03-11 16:06:52');
INSERT INTO `lyrics_tags` VALUES(1519, 'take+my+breath+away', 71, '2008-03-14 23:37:27');
INSERT INTO `lyrics_tags` VALUES(1518, 'michael+jackson', 31, '2008-03-14 23:35:44');
INSERT INTO `lyrics_tags` VALUES(1521, 'linkin+park', 168, '2008-03-14 23:42:08');
INSERT INTO `lyrics_tags` VALUES(1522, 'metallica', 11, '2008-03-14 23:57:42');
INSERT INTO `lyrics_tags` VALUES(1523, 'andain', 15, '2008-03-15 09:26:23');
__________________
Thanks
Paul
Thunder-Ball.net - Member
jimbona is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote