Create Table problem

[amavadia]

Hi, I am looking to create 3 tables for a project I am just starting on, and was wondering if anyone could help spot the error(s) in my code:

 

I am trying to run it through a php file. The server/login details are in the include file, which are correct because ive used the same file to create other parts of the database. This is the error I keep getting:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY (employer_id) ) ENGINE=MyISAM' at line 11

 

<?php
include 'db.inc.php';

$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or
die('Unable to connect');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));


//create customers table
$query = 'CREATE TABLE IF NOT EXISTS customer (
people_id           INTEGER         NOT NULL AUTO_INCREMENT,
first_name          VARCHAR(20)     NOT NULL,
last_name           VARCHAR(20)     NOT NULL,
email               VARCHAR(50)     NOT NULL,
address_1           VARCHAR(30)     NOT NULL,
address_2           VARCHAR(30),
county              VARCHAR(30)     NOT NULL,
postcode            VARCHAR(10)     NOT NULL,
telephone           VARCHAR(15),
customer_attribute  VARCHAR(255)    NOT NULL,
active              BOOLEAN         NOT NULL DEFAULT TRUE,
PRIMARY KEY(people_id)
)
ENGINE=MyISAM';


mysql_query($query, $db) or die(mysql_error($db));

//create employer table
$query = 'CREATE TABLE IF NOT EXISTS employer (
employer_id         INTEGER         NOT NULL AUTO_INCREMENT,
name                VARCHAR(50)     NOT NULL,
address_1           VARCHAR(30)     NOT NULL,
address_2           VARCHAR(30),
county              VARCHAR(30)     NOT NULL,
postcode            VARCHAR(10)     NOT NULL,
email               VARCHAR(50)     NOT NULL,
telephone           VARCHAR(15)     NOT NULL,
active              BOOLEAN         NOT NULL DEFAULT TRUE,
PRIMATY KEY (employer_id)
)
ENGINE=MyISAM';

mysql_query($query, $db) or die(mysql_error($db));

//create advert table
$query = 'CREATE TABLE IF NOT EXISTS advert (
advert_id           INTEGER                 NOT NULL AUTO_INCREMENT,
employer_id         INTEGER                 NOT NULL,
start_date          DATE                    NOT NULL,
finish_date         DATE                    NOT NULL,
vacancies           TINYINT UNSIGNED,
description         TEXT[3000]              NOT NULL,
app_deadline        DATE,
location            VARCHAR(30)             NOT NULL,
salary              MEDIUMINT(6) UNSIGNED   NOT NULL,
web_link            VARCHAR(50),
app_process         VARCHAR(255)            NOT NULL,
attributes          VARCHAR(255)            NOT NULL,
PRIMARY KEY (advert_id)
FOREIGN KEY (employer_id) REFERENCES employer(employer_id)
)
ENGINE=MyISAM';

mysql_query($query, $db) or die(mysql_error($db));

echo 'success!';
?>

 

Thanks!

[PFMaBiSmAd]

What's wrong with the following word in your query: PRIMATY

[amavadia]

Thank you!! had a few other errors after that but managed to sort them out. Much appreciated!