fwr1qfNH

1<?php
2
3//connect to MYSQL
4$db = mysql_connect('localhost','root','') or die ("Check Your Parameters.");
5//cerate the amin database if it doessn't already exist
6$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
7mysql_select_db('moviesite' ) or die (mysql_error($db));
8
9mysql_query ($query, $db) or die (mysql_error($db));
10
11//create the movie table
12$query = 'CREATE TABLE movie (
13		   	movie_id		INTERGER 	UNSIGNED 	NOT NULL 	AUTO_INCREMENT,
14			movie_name		VARCHAR 	(255)	 	NOT NULL			,
15			movie_type		TINYINT 			 	NOT NULL 	DEFAULT	0,
16			movie_year		SMALLINT 	UNSIGNED 	NOT NULL 	DEFAULT	0,
17			movie_leadactor	INTEGER 	UNSIGNED 	NOT NULL 	DEFAULT	0,
18			movie_director	INTEGER 	UNSIGNED 	NOT NULL 	DEFAULT	0,
19			
20			PRIMARY KEY (movie_id)
21			KEY movie_type (movie_type, movie_year)
22							)
23			ENGINE=MyISAM';
24		mysql_query($query,$db) or die (mysql_error($db));
25		
26		//create the movietype table
27		$query = 'CREATE TABLE movietype (
28					movietype_id	TINYINT 	UNSIGNED 	NOT NULL AUTO_INCREMENT,
29					movietype_label	VARCHAR		(100)		NOT NULL,
30					PRIMARY KEY (movietype_id)
31										)
32				ENGINE=MyISAM';
33		mysql_query($query, $db) or die (mysql_error($db));
34
35//create the people 
36$query = 'CREATE TABLE movie (
37		   	people_id			INTERGER 	UNSIGNED 	NOT NULL 	AUTO_INCREMENT,
38			people_fullname		VARCHAR 	(255)	 	NOT NULL,
39			people_isactor		TINYINT 	UNSIGNED 	NOT NULL 	DEFAULT	0,
40			people_isdirector 	TINYINT 	UNSIGNED 	NOT NULL 	DEFAULT	0,
41		
42			PRIMARY KEY (people_id)
43										)
44			ENGINE=MyISAM';
45		mysql_query($query,$db) or die (mysql_error($db));
46
47		
48		echo 'Moviedatabase successfully created!';
49		
50?>