The idea is to create a database for dvd movie reading of imdb
Only registered user can sign on for this project

Features

• Parse IMDB for movie information
• Complet search database for actors and movie
• Beautiful webdesign
• jeux de casino en ligne

Please feel free to commit your own ideas here.

Please feel free to commit your code here.

The first draft of the database

 
CREATE TABLE `actors` (
  `movie_id` int(11) NOT NULL DEFAULT '0',
  `imdb_id` varchar(30) NOT NULL DEFAULT '',
  `actor` varchar(200) NOT NULL DEFAULT '',
  `role` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY  (`movie_id`,`imdb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 
 
# Dump of table covers
# ------------------------------------------------------------
 
CREATE TABLE `covers` (
  `movie_id` int(11) NOT NULL DEFAULT '0',
  `thumbnail` blob,
  `image` longblob,
  PRIMARY KEY  (`movie_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 
 
# Dump of table genres
# ------------------------------------------------------------
 
CREATE TABLE `genres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `genre` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  KEY `genre` (`genre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 
 
# Dump of table moviegenre
# ------------------------------------------------------------
 
CREATE TABLE `moviegenre` (
  `movie_id` int(11) NOT NULL DEFAULT '0',
  `genre_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`movie_id`,`genre_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 
 
# Dump of table movies
# ------------------------------------------------------------
 
CREATE TABLE `movies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imdb` varchar(250) NOT NULL DEFAULT '',
  `title` varchar(200) NOT NULL DEFAULT '',
  `plot` text,
  `tagline` varchar(250) DEFAULT NULL,
  `director` varchar(100) DEFAULT NULL,
  `writer` varchar(100) DEFAULT NULL,
  `year` int(4) NOT NULL DEFAULT '0',
  `color` varchar(100) DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `runtime` int(11) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `rating` varchar(100) DEFAULT NULL,
  `releasedate` varchar(100) DEFAULT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Please write your self up here if you like to work on this project.

MG ⇒ Michael Gøtzhe, michael@greenquery.com