-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 15, 2007 at 04:49 PM
-- Server version: 5.0.34
-- PHP Version: 5.2.1-pl3-gentoo
-- 
-- Database: `getflix`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `movie`
-- 

CREATE TABLE `movie` (
  `ID` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `year` smallint(5) unsigned NOT NULL,
  `mpaa` varchar(16) NOT NULL,
  `genre` varchar(128) NOT NULL,
  `rating` float NOT NULL,
  `globalRating` float default NULL,
  `directorID` int(10) unsigned default NULL,
  `details` tinyint(4) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Table structure for table `movie_actor`
-- 

CREATE TABLE `movie_actor` (
  `movieID` int(10) unsigned NOT NULL,
  `roleID` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`movieID`,`roleID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Table structure for table `role`
-- 

CREATE TABLE `role` (
  `ID` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;