Jump to content

Create Table problem


amavadia

Recommended Posts

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!

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.