Duplicate entry '1' for key 'PRIMARY'

[vikey89]

Ragazzi sto creando della pagine in php, solo che al momento di eseguire la pagina mi crea l'errore:

Duplicate entry '1' for key 'PRIMARY' 

Vi posto il codice di entrambe le pagine , perchè non ho capito dov'è duplicata la PRIMARY KEY:

Pagina 1

<?php
//Collegamento MySql
$db = mysql_connect('localhost', 'root', '******') or
      die ('Non è possibile connttersi');

// Crea il Databse se non esiste
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query ($query, $db) or die (mysql_error ($db));

//Per sicurezza seleziona database attivo
mysql_select_db('moviesite', $db) or die (mysql_error ($db));

//Crea tabella movie
$query = 'CREATE TABLE movie (
    movie_id         INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
    movie_name       VARCHAR (255)     NOT NULL,
    movie_type       TINYINT           NOT NULL DEFAULT 0,
    movie_year       SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    movie_leadactor  INTEGER UNSIGNED  NOT NULL DEFAULT 0,
    movie_director   INTEGER UNSIGNED  NOT NULL DEFAULT 0,

    PRIMARY KEY (movie_id),
    KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
    mysql_query($query, $db) or die (mysql_error ($db));

//Crea tabella movietype
$query = 'CREATE TABLE movietype (
    movietype_id      TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
    movietype_label   VARCHAR(100)   NOT NULL,
    PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
    mysql_query($query, $db) or die (mysql_error ($db));

//crea tabella people
$query = 'CREATE TABLE people (
    people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
    people_fullname   VARCHAR (255)       NOT NULL,
    people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
    people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

    PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
    mysql_query($query, $db) or die (mysql_error ($db));
    echo 'Movie database successfully created!';
?>

Pagina 2

<?php
//Collegamento MySql
$db = mysql_connect('localhost', 'root', '******') or
      die ('Non è possibile connttersi');

//Per sicurezza seleziona database attivo
mysql_select_db('moviesite', $db) or die (mysql_error ($db));

//Inserisci dati nella tabella movie
$query = 'INSERT INTO movie
      (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
       movie_director)
       VALUES
       (1, "Bruce Almighty", 5, 2003, 1, 2),
       (2, "Office space", 5, 1999, 5, 6),
       (3, "Grand Canyion", 2, 1991, 4, 3)';
mysql_query ($query, $db) or die (mysql_error ($db));

//Inserisci dati nella tabella movietype
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
        VALUES
        (1, "Sci fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query ($query, $db) or die (mysql_error ($db));

//Inserisci dati nella tabella people
$query = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
        VALUES
        (1, "Jim Carrey", 1,0),
        (2, "Tom Shadyac", 0,1),
        (3, "Lawrence Kasdan", 0,1),
        (4, "Kevin Kline", 1,0),
        (5, "Ron Livingston", 1,0),
        (6, "Mike Judge", 0,1)';
mysql_query ($query, $db) or die (mysql_error ($db));

echo 'Data inserted succefully!';
?>

Dove ho sbagliato?