-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Dec 05, 2013 at 12:50 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `******`
--

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

--
-- Table structure for table `films`
--

CREATE TABLE `films` (
  `filmid` int(11) NOT NULL auto_increment,
  `filmtitle` text NOT NULL,
  `filmyear` int(11) NOT NULL,
  `filmrating` int(11) NOT NULL,
  `filmdesc` varchar(50) NOT NULL,
  `filmtrailer` text NOT NULL,
  `filmofficialurl` text NOT NULL,
  `filmcert` text NOT NULL,
  PRIMARY KEY  (`filmid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `films`
--

INSERT INTO `films` (`filmid`, `filmtitle`, `filmyear`, `filmrating`, `filmdesc`, `filmtrailer`, `filmofficialurl`, `filmcert`) VALUES
(1, 'The Apartment', 1960, 4, 'Drama', '', '', ''),
(2, 'Citizen Kane', 1941, 5, 'Drama', '', '', ''),
(3, 'North By Northwest', 1959, 5, 'Action', '', '', ''),
(4, 'Chinatown', 1974, 5, 'Thriller', '', '', ''),
(5, 'All About Eve', 1950, 4, 'Drama', '', '', ''),
(6, 'Casablanca', 1942, 5, 'Romance', '', '', ''),
(7, 'The Wizard Of Oz', 1939, 4, 'Fantasy', '', '', ''),
(8, '2001: A Space Odyssey ', 1968, 4, 'Adventure', '', '', ''),
(9, 'Black Narcissus', 1947, 5, 'Drama', '', '', ''),
(10, 'Apocalypse Now', 1979, 4, 'Action', '', '', ''),
(11, 'Withnail & I', 1987, 4, 'Comedy', '', '', ''),
(12, 'One Flew Over The Cuckoo''s Nest', 1975, 5, 'Drama', '', '', ''),
(13, 'Alien', 1979, 5, 'Horror', '', '', ''),
(14, 'Pulp Fiction ', 1994, 5, 'Crime', '', '', ''),
(15, 'Back To The Future', 1985, 5, 'Adventure', '', '', ''),
(16, 'Fanny And Alexander ', 1982, 4, 'Fantasy', '', '', ''),
(17, 'Double Indemnity', 1944, 4, 'Crime', '', '', ''),
(18, 'The Usual Suspects ', 1995, 4, 'Crime', '', '', ''),
(19, 'Trainspotting', 1996, 5, 'Crime', '', '', ''),
(20, 'Touch Of Evil', 1958, 5, 'Crime', '', '', '');
