This database contain movie quotes.
Number of movies: 7194
Number of quotes: 154 619
Structure
Code:
CREATE TABLE `moviequotes` (
`id` int(11) NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`movie` varchar(255) NOT NULL default '',
UNIQUE KEY `id` (`id`),
UNIQUE KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=167434 ;
Code:
CREATE TABLE `movies` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`letter` char(1) NOT NULL default '',
`year` bigint(20) NOT NULL default '0',
UNIQUE KEY `id` (`id`),
UNIQUE KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7195 ;
Examples
Code:
INSERT INTO `movies` (`id`, `name`, `letter`, `year`) VALUES (1, 'Prozac Nation', 'P', 2000);
INSERT INTO `movies` (`id`, `name`, `letter`, `year`) VALUES (2, 'Shooter', 'S', 2007);
INSERT INTO `movies` (`id`, `name`, `letter`, `year`) VALUES (3, 'Casino Royale', 'C', 2006);
INSERT INTO `movies` (`id`, `name`, `letter`, `year`) VALUES (4, 'Harry Potter and the Order of the Phoenix', 'H', 2007);
INSERT INTO `movies` (`id`, `name`, `letter`, `year`) VALUES (5, 'Dirty Dancing', 'D', 1987);
Code:
INSERT INTO `moviequotes` (`id`, `quote`, `movie`) VALUES (167433, 'Young and depressed in America.', 'Prozac Nation');
INSERT INTO `moviequotes` (`id`, `quote`, `movie`) VALUES (167432, 'I won. You lost.', 'Shooter');
INSERT INTO `moviequotes` (`id`, `quote`, `movie`) VALUES (167431, '1) Besides, you''re not my type. 2) Smart? 1) Single.', 'Casino Royale');
INSERT INTO `moviequotes` (`id`, `quote`, `movie`) VALUES (167430, 'I knew you were you.', 'Casino Royale');
INSERT INTO `moviequotes` (`id`, `quote`, `movie`) VALUES (167429, 'That''s why you think of women as dispoable objects and not meaningful pursuits. ', 'Casino Royale');
Price: 50$
Instant download:
http://it-essence.com/component/page...art/Itemid,26/
Payment: Automatic Paypal/Money Bookers at request.