PHP Classes

File: imdb.sql

Recommend this page to a friend!
  Classes of Randy Gerritse   IMDBSearch   imdb.sql   Download  
File: imdb.sql
Role: Auxiliary data
Content type: text/plain
Description: sql file to create the required tables (if you want to store locally)
Class: IMDBSearch
Search the Internet Movie DataBase
Author: By
Last change:
Date: 20 years ago
Size: 3,483 bytes
 

Contents

Class file image Download
# 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 ;