rendered paste body+ Zip Codes + Census Data (78,945 Records)
Download
CREATE TABLE `zips` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`ZIP_CODE` VARCHAR(15) NOT NULL,
`CITY` VARCHAR(2000) NOT NULL,
`STATE` VARCHAR(2000) NOT NULL,
`STATE_FULL` VARCHAR(2000) NOT NULL,
`AREA_CODE` VARCHAR(2000) NOT NULL,
`CITY_ALIAS_NAME` VARCHAR(2000) NOT NULL,
`CITY_ALIAS_ABBR` VARCHAR(2000) NOT NULL,
`CITY_TYPE` VARCHAR(2000) NOT NULL,
`COUNTY_NAME` VARCHAR(2000) NOT NULL,
`STATE_FIPS` VARCHAR(2000) NOT NULL,
`COUNTY_FIPS` VARCHAR(2000) NOT NULL,
`TIME_ZONE` VARCHAR(2000) NOT NULL,
`DAY_LIGHT_SAVING` VARCHAR(2000) NOT NULL,
`LATITUDE` VARCHAR(2000) NOT NULL,
`LONGITUDE` VARCHAR(2000) NOT NULL,
`ELEVATION` VARCHAR(2000) NOT NULL,
`MSA2000` VARCHAR(2000) NOT NULL,
`PMSA` VARCHAR(2000) NOT NULL,
`CBSA` VARCHAR(2000) NOT NULL,
`CBSA_DIV` VARCHAR(2000) NOT NULL,
`CBSA_TITLE` VARCHAR(2000) NOT NULL,
`PERSONS_PER_HOUSEHOLD` VARCHAR(2000) NOT NULL,
`ZIPCODE_POPULATION` VARCHAR(2000) NOT NULL,
`COUNTIES_AREA` VARCHAR(2000) NOT NULL,
`HOUSEHOLDS_PER_ZIPCODE` VARCHAR(2000) NOT NULL,
`WHITE_POPULATION` VARCHAR(2000) NOT NULL,
`BLACK_POPULATION` VARCHAR(2000) NOT NULL,
`HISPANIC_POPULATION` VARCHAR(2000) NOT NULL,
`INCOME_PER_HOUSEHOLD` VARCHAR(2000) NOT NULL,
`AVERAGE_HOUSE_VALUE` VARCHAR(2000) NOT NULL )
ENGINE = myisam;
+ Airports (4,166 Records)
Download
CREATE TABLE `default_table` (
`biz_id` int(11) NOT NULL auto_increment,
`biz_name` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`hours` varchar(100) NOT NULL default '',
`details` text NOT NULL,
PRIMARY KEY (`biz_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4167 ;
+ Animal Shelters (2,581 Records)
Download
CREATE TABLE `default_table` (
`biz_id` int(11) NOT NULL auto_increment,
`biz_name` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`hours` varchar(100) NOT NULL default '',
`details` text NOT NULL,
PRIMARY KEY (`biz_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2582 ;
+ Baby Names #1 (28,582 Records)
Download
CREATE TABLE `names` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`meaning` text NOT NULL,
`gender` varchar(6) NOT NULL default '',
`origin` varchar(24) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=28583 ;
+ Baby Names #2 (10,134 Records)
Download
CREATE TABLE `names` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`meaning` text NOT NULL,
`gender` varchar(6) NOT NULL default '',
`origin` varchar(24) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10135;
+ Celebrity BIOS (230 Records)
Download
CREATE TABLE `bios` (
`cat` char(1) default NULL,
`name` text,
`image` text,
`bio` text,
KEY `cat` (`cat`)
) TYPE=MyISAM;
+ Blogs (54,691 Records)
Download
CREATE TABLE `blogs` (
`id` int(11) default NULL,
`title` varchar(64) default NULL,
`url` varchar(255) default NULL,
`location` varchar(64) default NULL,
`country` varchar(64) default NULL,
`lastupdate` varchar(20) default NULL,
`subscribe` longtext,
`added` varchar(20) default NULL,
`language` varchar(64) default NULL,
`description` varchar(255) default NULL,
`keywords` longtext
) TYPE=MyISAM;
+ Entertainment Feeds (531 Records)
Download
CREATE TABLE `stations` (
`id` int(11) NOT NULL auto_increment,
`location` varchar(100) NOT NULL default '',
`title` text NOT NULL,
`style` varchar(30) NOT NULL default '',
`url` text NOT NULL,
PRIMARY KEY (`id`)
);
+ Entertainment Site Links (564 Records)
Download
CREATE TABLE `categories` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=23 ;
CREATE TABLE `stations` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`cid` tinytext NOT NULL,
`url` text NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=565 ;
+ Ezines (7,042 Records)
Download
CREATE TABLE `ezines` (
`id` int(5) NOT NULL auto_increment,
`title` varchar(128) NOT NULL default '',
`catnumber` int(2) NOT NULL default '0',
`category` varchar(64) NOT NULL default '',
`description` text NOT NULL,
`circulation` varchar(128) NOT NULL default '',
`frequency` varchar(128) NOT NULL default '',
`adsperissue` varchar(64) NOT NULL default '',
`adsperadvertiser` varchar(64) NOT NULL default '',
`publicationdate` varchar(64) NOT NULL default '',
`addeadline` varchar(128) NOT NULL default '',
`adspecs` varchar(128) NOT NULL default '',
`costofad` varchar(128) NOT NULL default '',
`paymentpptions` varchar(128) NOT NULL default '',
`howtoorder` varchar(128) NOT NULL default '',
`publishedby` varchar(128) NOT NULL default '',
`websiteurl` varchar(255) NOT NULL default '',
`contact` varchar(255) NOT NULL default '',
`howtosubscribe` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7043 ;
+ Famous Quotes #1 (21,814 Records)
Download
CREATE TABLE `fam_quotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`author` varchar(255) NOT NULL default '',
`quote` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
+ Famous Quotes #2 (17,394 Records)
Download
CREATE TABLE `quotes` (
`id` int(5) NOT NULL auto_increment,
`quote` text NOT NULL,
`author` varchar(128) NOT NULL default '',
`authordata` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17395 ;
+ Free Classified Ad Sites (57 Records)
Download
CREATE TABLE `free_classifieds` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=58 ;
+ Free Contest Sites (35 Records)
Download
CREATE TABLE `free_contests` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=36 ;
+ Free Coupon Sites (6 Records)
Download
CREATE TABLE `free_cupons` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
+ Free Dog Sites (12 Records)
Download
CREATE TABLE `free_dogstuff` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
+ Free E-Greeting Sites (367 Records)
Download
CREATE TABLE `free_egreetings` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=368 ;
+ Free Graphic Resource Sites (109 Records)
Download
CREATE TABLE `free_graphics` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=110 ;
+ Free Webhosting Sites (111 Records)
Download
CREATE TABLE `free_hosting` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=112 ;
+ Free Internet Service Providers (96 Records)
Download
CREATE TABLE `free_internet` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=97;
+ Free Shopping Rewards Sites (47 Records)
Download
CREATE TABLE `free_rewards` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=48;
+ Free Webmail Providers (263 Records)
Download
CREATE TABLE `free_email` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=264 ;
+ Free Webmaster Resources (73 Records)
Download
CREATE TABLE `free_webresources` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=74 ;
+ Fun Facts (1,489 Records)
Download
CREATE TABLE `fact` (
`Fact` varchar(255) NOT NULL default '',
PRIMARY KEY (`Fact`)
) TYPE=MyISAM;
+ Funny Jokes (9,986 Records)
Download
CREATE TABLE `new_jokes` (
`ID` int(6) NOT NULL auto_increment,
`Category` varchar(255) default NULL,
`Joke` text,
PRIMARY KEY (`ID`),
KEY `Category` (`Category`)
) ENGINE=MyISAM AUTO_INCREMENT=9986 DEFAULT CHARSET=latin1 AUTO_INCREMENT=9986 ;
+ Insults (4,291 Records)
Download
CREATE TABLE `insults` (
`id` int(10) unsigned NOT NULL auto_increment,
`info` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
+ Kids Games (226 Records)
Download
CREATE TABLE `games` (
`idnum` int(10) unsigned NOT NULL auto_increment,
`link` text NOT NULL,
`name` text NOT NULL,
`info` text NOT NULL,
PRIMARY KEY (`idnum`)
) TYPE=MyISAM;
+ Plants (89,758 Records)
Download
DROP TABLE IF EXISTS `plants`;
CREATE TABLE IF NOT EXISTS `plants` (
`id` int(10) NOT NULL default '0',
`symbol` varchar(255) NOT NULL default '',
`scientific` varchar(255) NOT NULL default '',
`common` varchar(255) NOT NULL default '',
`family` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+ Punk Related Sites (48 Records)
Download
CREATE TABLE `punk_artphotos` (
`ID` int(10) unsigned NOT NULL auto_increment,
`URL` text NOT NULL,
`Name` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;
+ Recipes - Drinks (9,033 Records)
Download
CREATE TABLE `drink` (
`id` int(5) NOT NULL auto_increment,
`title` varchar(64) NOT NULL default '',
`keywords` varchar(255) NOT NULL default '',
`content` varchar(255) NOT NULL default '',
`cat` varchar(64) NOT NULL default '',
`subcat` varchar(64) NOT NULL default '',
`ingredients` text NOT NULL,
`method` text NOT NULL,
`serve` varchar(64) NOT NULL default '',
`nutriinfo` text NOT NULL,
`visible` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9034 ;
+ Recipes - Ethnic Foods (4,064 Records)
Download
CREATE TABLE `ethnic_recipes` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`titlecat` varchar(255) default NULL,
`recipe` longtext,
`category` varchar(64) default NULL,
`category2` varchar(255) default NULL,
`category3` varchar(50) default NULL,
`category4` varchar(50) default NULL,
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
+ Recipes #1 (29,736 Records)
Download
CREATE TABLE `recipes` (
`id` int(11) default NULL,
`title` varchar(255) default NULL,
`titlecat` varchar(255) default NULL,
`recipe` longtext,
`category` varchar(64) default NULL,
`category2` varchar(255) default NULL,
`category3` varchar(50) default NULL,
`category4` varchar(50) default NULL,
KEY `category` (`category`),
KEY `category2` (`category2`)
) TYPE=MyISAM;
+ Recipes #2 (1,014 Records)
Download
CREATE TABLE `categories` (
`CategoryID` int(10) NOT NULL auto_increment,
`CategoryName` varchar(150) NOT NULL default '',
PRIMARY KEY (`CategoryID`),
UNIQUE KEY `CategoryName` (`CategoryName`)
) TYPE=MyISAM AUTO_INCREMENT=36 ;
CREATE TABLE `subcategories` (
`CategoryID` int(10) NOT NULL default '0',
`SubcategoryID` int(10) NOT NULL auto_increment,
`SubcategoryName` varchar(150) NOT NULL default '',
PRIMARY KEY (`SubcategoryID`)
) TYPE=MyISAM AUTO_INCREMENT=54;
CREATE TABLE `items` (
`ItemID` int(10) NOT NULL auto_increment,
`ItemTitle` varchar(255) NOT NULL default '',
`ItemCategory` int(10) NOT NULL default '0',
`ItemSubcategory` int(10) NOT NULL default '0',
`ItemText` text,
`ItemImage` varchar(255) NOT NULL default '',
`Contributor` varchar(50) NOT NULL default '',
`DateAdded` int(10) NOT NULL default '0',
`ItemType` varchar(10) NOT NULL default '',
`ItemStatus` varchar(20) NOT NULL default 'unapproved',
PRIMARY KEY (`ItemID`)
) TYPE=MyISAM AUTO_INCREMENT=1015;
+ Restaurants (291,123 Records)
Download
CREATE TABLE `restaurants` (
`RestaurantID` int(11) default NULL,
`RestaurantLocationID` int(11) default NULL,
`Name` varchar(75) default NULL,
`Address1` varchar(30) default NULL,
`Address2` varchar(20) default NULL,
`City` varchar(30) default NULL,
`State` char(2) default NULL,
`Zip` varchar(5) default NULL,
`PhoneMain` varchar(10) default NULL,
`PhoneToll` varchar(10) default NULL,
`Phone` varchar(10) default NULL,
`Fax` varchar(10) default NULL,
`Fax2` varchar(10) default NULL,
`URL` varchar(60) default NULL,
`Email` varchar(40) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ RSS Feeds (30,386 Records)
Download
CREATE TABLE `rss` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(64) NOT NULL default '',
`catnumber` int(3) NOT NULL default '0',
`subcategory` varchar(64) NOT NULL default '',
`subcatnumber` char(3) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=30386;
+ Scripts For Websites (10,457 Records)
Download
CREATE TABLE `admin` (
`id` smallint(6) NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`pass_word` varchar(200) NOT NULL default '',
`registered` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
CREATE TABLE `b2gpoll_data` (
`pid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`choice` varchar(250) NOT NULL default '',
`votes` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `b2gpoll_list` (
`pid` int(11) NOT NULL auto_increment,
`identifier` varchar(50) NOT NULL default '',
`nextcid` int(10) unsigned NOT NULL default '0',
`question` varchar(250) NOT NULL default '',
`timeStamp` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `categories` (
`catid` int(11) NOT NULL auto_increment,
`catfatherid` int(11) default NULL,
`catname` varchar(100) default NULL,
`catdescription` varchar(150) default NULL,
`total` int(11) default '0',
`catRecipLink` varchar(200) NOT NULL default '',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ;
CREATE TABLE `modules` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`filename` varchar(100) NOT NULL default '',
`notes` text NOT NULL,
`status` tinyint(1) NOT NULL default '0',
`form_page` varchar(100) NOT NULL default '0',
`thankyoufile` varchar(100) NOT NULL default '',
`sname` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
CREATE TABLE `rating` (
`id` int(11) NOT NULL auto_increment,
`review` text NOT NULL,
`review_date` varchar(50) NOT NULL default '',
`rating_id` int(11) NOT NULL default '0',
`rating` tinyint(2) NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
CREATE TABLE `sites` (
`siteid` int(11) NOT NULL auto_increment,
`sitetitle` varchar(100) default NULL,
`sitedescription` text,
`info` varchar(255) NOT NULL default '',
`pic` varchar(255) NOT NULL default '',
`restriction` varchar(255) NOT NULL default '',
`siteurl` varchar(100) default NULL,
`sitedate` varchar(10) default NULL,
`sponsordate` varchar(50) default NULL,
`sitecatid` int(11) default NULL,
`sitehits` int(11) NOT NULL default '0',
`tclicks` int(11) NOT NULL default '0',
`total_sp_clicks` int(11) NOT NULL default '0',
`clicks_purchased` int(11) NOT NULL default '0',
`totclicks_purchased` int(11) NOT NULL default '0',
`sites_userid` int(11) default NULL,
`updatetime` varchar(50) NOT NULL default '',
`rectype` varchar(50) NOT NULL default '',
`txn_id` varchar(100) NOT NULL default '',
`subscr_id` varchar(100) NOT NULL default '',
`payment_status` varchar(100) NOT NULL default '',
`_type` varchar(100) NOT NULL default '',
`status` tinyint(1) NOT NULL default '0',
`sponsor` tinyint(1) NOT NULL default '0',
`price` varchar(10) NOT NULL default '',
`invoice` int(11) NOT NULL default '0',
`acomments` text NOT NULL,
PRIMARY KEY (`siteid`),
FULLTEXT KEY `searchportal` (`sitetitle`,`sitedescription`,`siteurl`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10458 ;
+ Short Stories (358 Records)
Download
CREATE TABLE `main` (
`Number` int(6) NOT NULL auto_increment,
`Title` text NOT NULL,
`Author` text NOT NULL,
`Story` text NOT NULL,
`Source` text NOT NULL,
PRIMARY KEY (`Number`)
) TYPE=MyISAM AUTO_INCREMENT=359;
+ Lyrics (413,964 Records)
Download
CREATE TABLE lyrics (
id int(7) NOT NULL auto_increment,
artist varchar(250) NOT NULL default '',
title varchar(250) NOT NULL default '',
album varchar(250) NOT NULL default '',
letter char(2) NOT NULL default '',
lyrics text NOT NULL,
PRIMARY KEY (id),
FULLTEXT KEY artist (artist),
FULLTEXT KEY title (title),
FULLTEXT KEY album (album)
) TYPE=MyISAM;
CREATE TABLE songs (
id int(10) NOT NULL auto_increment,
link varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY link (link),
FULLTEXT KEY link_2 (link)
) TYPE=MyISAM;
+ Website Articles
Download
+ Movie Plots - IMDB (110,952 Records)
Download
CREATE TABLE `plots` (
`ID` int(11) NOT NULL auto_increment,
`Title` varchar(250) NOT NULL default ,
`Plot` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=110953 ;
+ Bash Quotes (19,942 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `bashquotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`quote` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Brand Name Drugs (8,627 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `brands` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) default NULL,
`category` varchar(250) default NULL,
`info` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Nintendo DS Cheats (2,235 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `ds_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Fights (5,887 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `events` (
`id` int(10) unsigned NOT NULL auto_increment,
`organization` varchar(255) default NULL,
`event` text,
`match` int(10) unsigned default NULL,
`winner` varchar(250) default NULL,
`looser` varchar(250) default NULL,
`method` text,
`round` int(10) unsigned default NULL,
`time` varchar(50) default NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Nintendo Game Cube Cheats (9,212 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `gamecube_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Nintendo Game Boy Advanced Cheats (2,642 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `gba_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Generic Drugs (3,011 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `generics` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) default NULL,
`category` varchar(250) default NULL,
`info` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ King James Bible - New Testament (8,513 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `acts` (
`chapter` tinyint(3) unsigned default NULL,
`verse` tinyint(3) unsigned default NULL,
`text` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
One table created for each book
+ King James Bible - Old Testament (23,203 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `amos` (
`chapter` tinyint(3) unsigned default NULL,
`verse` varchar(25) default NULL,
`text` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
One table created for each book
+ Nintendo 64 Cheats (2,597 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `n64_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ PC Games Cheats (6,978 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `pc_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Playstation 2 Cheats (20,848 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `ps2_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Playstation 3 Cheats (368 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `ps3_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ PSP Cheats (1,883 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `psp_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Vitamins (991 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `vitamins` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`intro` text,
`sources` text,
`treatment_for` text,
`def_symptom` text,
`dosage` text,
`side_effects` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Nintendo Wii Cheats (727 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `wii_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Hotels - Entire World (4,066 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `hotels` (
`id` int(10) unsigned NOT NULL auto_increment,
`continent` varchar(200) default NULL,
`city` varchar(200) default NULL,
`hotel_name` varchar(200) default NULL,
`stats` text,
`descr` text,
`ameni` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ XBOX 360 Cheats (2,786 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `xbox_cheats` (
`id` int(10) unsigned NOT NULL auto_increment,
`game` varchar(255) default NULL,
`cheat` text,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Camcorder Reviews (272 Records)
Download
CREATE TABLE `camcorders` (
`id` int(10) unsigned NOT NULL auto_increment,
`product` text,
`overview` text,
`review` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=273 ;
+ Cellphone Reviews (551 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `cellphones` (
`id` int(10) unsigned NOT NULL auto_increment,
`product` text,
`overview` text,
`review` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Desktop Computer Reviews (1,221 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `desktops` (
`id` int(10) unsigned NOT NULL auto_increment,
`product` text,
`overview` text,
`review` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Job Listings (11,468 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `jobs` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`descr` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Television Reviews (1,241 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `televisions` (
`id` int(10) unsigned NOT NULL auto_increment,
`product` text,
`overview` text,
`review` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Windows & Software Processes (30,020 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `startups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`filename` varchar(255) default NULL,
`description` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ NBA Stats (7,272 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `assists` (
`id` int(11) NOT NULL auto_increment,
`year` varchar(255) default NULL,
`player` varchar(255) default NULL,
`g` int(11) default NULL,
`ast` int(11) default NULL,
`apg` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ US Colleges (1,924+ Records)
Download
CREATE TABLE `campus_life` (
`college_id` int(11) NOT NULL default '0',
`percent_undergrad_college_owned` varchar(10) NOT NULL default '',
`percent_fraternity` varchar(10) NOT NULL default '',
`percent_sorority` varchar(10) NOT NULL default '',
`percent_campus_weekends` varchar(10) NOT NULL default '',
`offer_housing` varchar(10) NOT NULL default '',
`percent_students_college_housing` varchar(10) NOT NULL default '',
`campus_housing` varchar(10) NOT NULL default '',
`off_campus_assistance` varchar(10) NOT NULL default '',
`types_available` text NOT NULL,
`college_owned_singles` varchar(10) NOT NULL default '',
`college_owned_doubles` varchar(10) NOT NULL default '',
`college_owned_triples` varchar(10) NOT NULL default '',
`college_owned_apartments` varchar(10) NOT NULL default '',
`college_owned_other` varchar(10) NOT NULL default '',
`num_college_owned` varchar(10) NOT NULL default '',
`sprinkler_system` varchar(10) NOT NULL default '',
`fire_alarms` varchar(10) NOT NULL default '',
`high_speed_internet` varchar(10) NOT NULL default '',
`campus_size` varchar(25) NOT NULL default '',
`percent_weekends` varchar(50) NOT NULL default '',
`nearest_airport` varchar(100) NOT NULL default '',
`nearest_train` varchar(100) NOT NULL default '',
`nearest_bus` varchar(100) NOT NULL default '',
`public_transport` varchar(25) NOT NULL default '',
`cars_permitted` varchar(10) NOT NULL default '',
`percent_cars` varchar(10) NOT NULL default '',
`school_employment` varchar(10) NOT NULL default '',
`percent_undergrads_employed` varchar(10) NOT NULL default '',
`average_undergrad_earnings` varchar(25) NOT NULL default '',
`freshmen_discouraged_working` varchar(10) NOT NULL default '',
`army_rotc` varchar(100) NOT NULL default '',
`navy_rotc` varchar(100) NOT NULL default '',
`airforce_rotc` varchar(100) NOT NULL default '',
`alcohol_permitted` varchar(10) NOT NULL default '',
`additional_policies` text NOT NULL,
`popular_events` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `colleges` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`state_id` int(11) NOT NULL default '0',
`address` varchar(255) NOT NULL default '',
`website` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1925 ;
CREATE TABLE `extracurriculars` (
`college_id` int(11) NOT NULL default '0',
`student_activities` text NOT NULL,
`num_organizations` varchar(10) NOT NULL default '',
`honor_societies` text NOT NULL,
`religious_organizations` text NOT NULL,
`international_organizations` text NOT NULL,
`other_organizations` text NOT NULL,
`student_papers` text NOT NULL,
`num_frats` varchar(10) NOT NULL default '',
`frats_chapter_houses` varchar(10) NOT NULL default '',
`percent_frat_members` varchar(10) NOT NULL default '',
`num_sororities` varchar(10) NOT NULL default '',
`sororities_chapter_houses` varchar(10) NOT NULL default '',
`percent_sorority_members` varchar(10) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+ Cars (3,354 Records)
Download
CREATE TABLE `cars` (
`id` bigint(20) NOT NULL auto_increment,
`price` varchar(255) character set utf8 collate utf8_turkish_ci NOT NULL default '',
`submodel` text character set utf8 collate utf8_turkish_ci NOT NULL,
`mainmodel` text character set utf8 collate utf8_turkish_ci,
`typeofbody` text character set utf8 collate utf8_turkish_ci,
`maxbootspace` text character set utf8 collate utf8_turkish_ci,
`minbootspace` text character set utf8 collate utf8_turkish_ci,
`drivenwheels` text character set utf8 collate utf8_turkish_ci,
`engineandtype` text character set utf8 collate utf8_turkish_ci,
`engineposition` text character set utf8 collate utf8_turkish_ci,
`frontheadroom` text character set utf8 collate utf8_turkish_ci,
`frontlegroom` text character set utf8 collate utf8_turkish_ci,
`fueltype` text character set utf8 collate utf8_turkish_ci,
`handsfreephone` text character set utf8 collate utf8_turkish_ci,
`height` text character set utf8 collate utf8_turkish_ci,
`kerbweight` text character set utf8 collate utf8_turkish_ci,
`lenght` text character set utf8 collate utf8_turkish_ci,
`maxpowerbhp2rpm` text character set utf8 collate utf8_turkish_ci,
`maxtorquelbft2rpm` text character set utf8 collate utf8_turkish_ci,
`multicd` text character set utf8 collate utf8_turkish_ci,
`numberofdoors` text character set utf8 collate utf8_turkish_ci,
`numberofseats` text character set utf8 collate utf8_turkish_ci,
`rdsradio` text character set utf8 collate utf8_turkish_ci,
`rearheadroom` text character set utf8 collate utf8_turkish_ci,
`rearkneeroom` text character set utf8 collate utf8_turkish_ci,
`satellitenavigation` text character set utf8 collate utf8_turkish_ci,
`towingweight` text character set utf8 collate utf8_turkish_ci,
`turningcircle` text character set utf8 collate utf8_turkish_ci,
`uniquefitradio` text character set utf8 collate utf8_turkish_ci,
`width` text character set utf8 collate utf8_turkish_ci,
`acceleration060mph` text character set utf8 collate utf8_turkish_ci,
`topspeed` text character set utf8 collate utf8_turkish_ci,
`co2ratingg2km` text character set utf8 collate utf8_turkish_ci,
`warranty` text character set utf8 collate utf8_turkish_ci,
`pencepermile` text character set utf8 collate utf8_turkish_ci,
`serviceintervals` text character set utf8 collate utf8_turkish_ci,
`servicingcost3year` text character set utf8 collate utf8_turkish_ci,
`tankcapacity` text character set utf8 collate utf8_turkish_ci,
`typicalcontracthirerate` text character set utf8 collate utf8_turkish_ci,
`insurancequote` text character set utf8 collate utf8_turkish_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3355 ;
+ Golf (8,118 Records)
Download
CREATE TABLE `cities` (
`id` int(11) NOT NULL auto_increment,
`state_id` int(11) NOT NULL default '0',
`city` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8119 ;
+ Movie Quotes (18,261 Records)
Download
CREATE TABLE `movies` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`year` varchar(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2112 ;
CREATE TABLE `quotes` (
`id` int(11) NOT NULL auto_increment,
`movie_id` int(11) NOT NULL default '0',
`quote` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18262 ;
+ Warez (17,206 Records)
Download
CREATE TABLE `warez` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`body` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17207 ;
+ Actors/Actresses (6,392 Records)
Download
CREATE TABLE `actors` (
`movie_id` int(11) NOT NULL default '0',
`role_id` int(11) NOT NULL default '0',
`actor_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+ Baseball Stats (4,197 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `baseballplayers_checked` (
`id` int(11) NOT NULL auto_increment,
`first_name` varchar(255) default NULL,
`last_name` varchar(50) default NULL,
`nick` varchar(255) default NULL,
`dob` varchar(255) default NULL,
`birthcity` varchar(255) default NULL,
`zodiac` varchar(255) default NULL,
`diedon` varchar(255) default NULL,
`diedin` varchar(255) default NULL,
`cemetary` varchar(255) default NULL,
`college` varchar(255) default NULL,
`bats` varchar(255) default NULL,
`throws` varchar(255) default NULL,
`height` varchar(255) default NULL,
`weight` varchar(255) default NULL,
`first_game` varchar(255) default NULL,
`last_game` varchar(255) default NULL,
`draft` varchar(255) default NULL,
`bio` text,
KEY `Key` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ Boxing Stats (4,645 Records)
Download
CREATE TABLE /*!32312 IF NOT EXISTS*/ `boxers_checked` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`gender` varchar(255) default NULL,
`dob` varchar(255) default NULL,
`dod` varchar(255) default NULL,
`division` varchar(255) default NULL,
`residence` varchar(255) default NULL,
`birthplace` varchar(255) default NULL,
`stance` varchar(255) default NULL,
`height` varchar(255) default NULL,
`reach` varchar(255) default NULL,
`record` varchar(255) default NULL,
KEY `key` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ NFL Stats (2,152 Records)