50,000 human reviewed links database - built to order

CREATE TABLE IF NOT EXISTS `links` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `cat_id` int(20) NOT NULL DEFAULT '0',
  `cat_name` varchar(180) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NONE',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `desc` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci,
  `alexaRank` mediumint(8) NOT NULL DEFAULT '0',
  `parent` int(20) NOT NULL DEFAULT '0',
  `paid` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `url` (`url`),
  FULLTEXT KEY `cat_name` (`cat_name`,`url`,`title`,`desc`,`keywords`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=317719 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`id`, `cat_id`, `cat_name`, `url`, `title`, `desc`, `keywords`, `alexaRank`, `parent`, `paid`) VALUES
(2, 998601, 'News and Events', 'http://universe.byu.edu/', 'Daily Universe', 'Student newspaper of Brigham Young University in Provo.', NULL, 5082, 0, 1),
(7, 998601, 'News and Events', 'http://www.wsusignpost.com/', 'The WSU Signpost', 'Thrice-weekly student newspaper of Weber State University in Ogden.', NULL, 3150307, 0, 1),
(32, 998601, 'News and Events', 'http://fairfieldchampion.com.au/', 'Fairfield City Champion', 'With almost 100,000 readers, this weekly paper is distributed free to dozens of suburbs including Abbotsbury, Cabramatta, Edensor Park, Fairfield, Greenfield Park, a', NULL, 2106130, 0, 1);

CREATE TABLE IF NOT EXISTS `categories` (
  `cat_id` int(20) NOT NULL AUTO_INCREMENT,
  `parent` int(50) NOT NULL,
  `cat_name` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `count` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1007860 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`cat_id`, `parent`, `cat_name`, `count`) VALUES
(442411, 0, 'Home and Garden', 269),
(443545, 443001, 'Baking and Confections', 214),
(815879, 815589, 'Elements', 208),
(274774, 274660, 'Restaurant Chains', 202);