How to fix error in SQL REFERENCES syntax?

Question

MySQL

CREATE TABLE org (
ogr_id INT not null primary key ,
identifier VARCHAR ( 25 ) not null UNIQUE
);
CREATE TABLE person (
p_id INT not null auto_increment primary key , 
p_name VARCHAR ( 25 ) not null ,
p_login VARCHAR ( 15 ) not null ,
password VARCHAR ( 15 ) not null , 
org INT not null ,
FOREIGN  KEY org REFERENCES org ( org_id )
ON UPDATE CASCADE 
ON DELETE CASCADE ,
UNIQUE (org_id, p_login , password ) 
)

such an error appears

Error code 1064, SQL state 42000: 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 'REFERENCES org ( org_id )
ON UPDATE CASCADE
ON DELETE CASCADE ,
UNIQUE (org_id,' at line 7

It's been over an hour and I can't figure out what's going on.

Answer 1

First, you don't have org_id in this table, so UNIQUE (org_id) will throw an error.
Secondly,

CREATE TABLE person (
p_id INT not null auto_increment primary key , 
p_name VARCHAR ( 25 ) not null ,
p_login VARCHAR ( 15 ) not null ,
password VARCHAR ( 15 ) not null , 
org INT not null REFERENCES org ( org_id ) ON UPDATE CASCADE ON DELETE CASCADE ,
UNIQUE (org, p_login , password ) 
)

Answer 2

syntax error =)