File: imdb.sql

# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 30, 2003 at 10:36 AM
# Server version: 4.0.2
# PHP Version: 4.2.1
# Database : `imdb`
# --------------------------------------------------------

#
# Table structure for table `actor`
#
# Creation: Jul 29, 2003 at 04:23 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `actor` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6135 ;
# --------------------------------------------------------

#
# Table structure for table `directed`
#
# Creation: Jul 29, 2003 at 04:25 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `directed` (
  `id` int(11) NOT NULL auto_increment,
  `directorid` int(11) NOT NULL default '0',
  `movieid` varchar(10) NOT NULL default '0',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='which director for which movie' AUTO_INCREMENT=332 ;
# --------------------------------------------------------

#
# Table structure for table `director`
#
# Creation: Jul 29, 2003 at 04:23 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `director` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=298 ;
# --------------------------------------------------------

#
# Table structure for table `genre`
#
# Creation: Jul 29, 2003 at 04:23 PM
# Last update: Jul 29, 2003 at 05:44 PM
#

CREATE TABLE `genre` (
  `id` int(11) NOT NULL auto_increment,
  `genre` varchar(255) NOT NULL default '',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;
# --------------------------------------------------------

#
# Table structure for table `movie`
#
# Creation: Jul 29, 2003 at 04:24 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `movie` (
  `id` varchar(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `cover` varchar(255) NOT NULL default '',
  `year` varchar(10) NOT NULL default '0',
  `rating` double NOT NULL default '0',
  `tagline` varchar(255) NOT NULL default '',
  `outline` text NOT NULL,
  `outlinemore` text NOT NULL,
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='movies';
# --------------------------------------------------------

#
# Table structure for table `moviegenre`
#
# Creation: Jul 29, 2003 at 04:24 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `moviegenre` (
  `id` int(11) NOT NULL auto_increment,
  `movieid` varchar(10) NOT NULL default '0',
  `genreid` int(11) NOT NULL default '0',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=679 ;
# --------------------------------------------------------

#
# Table structure for table `role`
#
# Creation: Jul 29, 2003 at 04:24 PM
# Last update: Jul 29, 2003 at 07:24 PM
#

CREATE TABLE `role` (
  `id` int(11) NOT NULL auto_increment,
  `actorid` int(11) NOT NULL default '0',
  `movieid` varchar(10) NOT NULL default '0',
  `part` varchar(255) NOT NULL default '',
  `date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='which actor in which movie' AUTO_INCREMENT=6338 ;