Tvorba database

$filmy = "CREATE TABLE movie(
            movie_id int(11) NOT NULL auto_increment,
            movie_name varchar (255) NOT NULL,
            movie_type tinyint(2) NOT NULL default 0,
            movie_year int(4) NOT NULL default 0,
            movie_leadactor int(11) NOT NULL default 0,
            movie_director int(11) NOT NULL default 0,
            PRIMARY KEY (movie_id),
            KEY movie_type(movie_type, movie_year)
                )";
        
        $vysledky = mysql_query($filmy)or
                die (mysql_error());
        
        $typyfilmu = "CREATE TABLE movietype(
            movietype_id int(11) NOT NULL auto_increment,
            movietype_label varchar(100) NOT NULL,
            PRIMARY KEY (movietype_id)                  
                )";
        
        $vysledky = mysql_query($typyfilmu)or
                die (mysql_error());
        
        $lide = "CREATE TABLE people(
            people_id int(11) NOT NULL auto_increment,
            people_fullname varchar (255) NOT NULL,
            people_isactor tinyint(1) NOT NULL default 0,
            people_isdirector tinyint(1) NOT NULL default 0,
            PRIMARY KEY (people_id)
                )";
        
        $vysledky = mysql_query($lide)or
                die (mysql_error());

$vlozit = "INSERT INTO movie(movie_id, movie_name, movie_type, ".
                "movie_year, movie_leadactor, movie_director)".
                "VALUES (1, 'Bozsky Bruce', 5, 2003,1,2),".
                "(2, 'Malery pana sikuly', 5, 1999,5,6),".
                "(3, 'Grand Canyon', 2, 1991, 4,3)";
        
        $vysledky = mysql_query($vlozit)or
                die(mysql_error());
        
        
        $typ = "INSERT INTO movietype (movietype_id, movietype_label)".
                "VALUES (1, 'SCI-FI'),".
                "(2, 'Drama'),".
                "(3, 'Dobrodruzny'),".
                "(4, 'Valecny'),".
                "(5, 'Komedie'),".
                "(6, 'Horror'),".
                "(7, 'Akcni'),".
                "(8, 'Detsky')";
        
        $vysledky = mysql_query($typ)or
                die(mysql_error());
        
        $lide = "INSERT INTO people (people_id, people_fullname,".
                "people_isactor, people_isdirector)".
                "VALUES (1, Jim Carrey, 1 ,0),".
                "(2, Tom Shadyac, 0,1),".
                "(3, Tom Cruise, 0,1),".
                "(4, Roberto de Niro, 0,1),".
                "(5, Kevin Costner, 1,0),".
                "(6, Harrison Ford, 0,1)";
        
        $vysledky = mysql_query($lide)or
                die(mysql_error());