-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 12, 2007 at 10:12 PM
-- Server version: 5.0.32
-- PHP Version: 4.4.4-8
-- 
-- Database: `movienight`
-- 

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

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

CREATE TABLE `movie` (
  `movieid` int(11) NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `planned` date default NULL,
  `watched` date default NULL,
  `_charisma` tinyint(4) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `movietitle` tinytext collate utf8_unicode_ci NOT NULL,
  `serie` tinyint(4) NOT NULL default '0',
  `buried` date default NULL,
  `buriedby` int(11) default NULL,
  `trailer_link` text character set utf8 NOT NULL,
  `trailer_length` tinytext character set utf8 NOT NULL,
  `trailer_type` tinytext character set utf8 NOT NULL,
  `remarks` text character set utf8 NOT NULL,
  `imdb_id` mediumint(8) unsigned NOT NULL,
  `imdb_plot` text character set utf8 NOT NULL,
  `imdb_score` float NOT NULL default '0',
  `imdb_picture` blob NOT NULL,
  `imdb_runtime` tinytext character set utf8 NOT NULL,
  PRIMARY KEY  (`movieid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `moviecopy`
-- 

CREATE TABLE `moviecopy` (
  `movieid` int(11) NOT NULL default '0',
  `format` tinytext NOT NULL,
  `location` tinytext NOT NULL,
  `copyid` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`copyid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `userid` int(11) NOT NULL auto_increment,
  `username` tinytext NOT NULL,
  `password` tinytext NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `vote`
-- 

CREATE TABLE `vote` (
  `voteid` int(11) NOT NULL auto_increment,
  `movieid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `vote` int(11) NOT NULL default '0',
  PRIMARY KEY  (`voteid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
