View Single Post
Old 12-27-2008, 02:27 AM  
Naughty
Confirmed User
 
Industry Role:
Join Date: Jul 2001
Location: Utopia
Posts: 6,478
Quote:
Originally Posted by jimbona View Post
@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');
Ugh, i did an extended search in all php files, hence skipping the sql file. Thanks.
__________________
seks.ai for sale - ping me
Naughty is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote