Website Content for Sale

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 ;

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 ;

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);

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');