uT218W9x

1CREATE database sample_db;
2USE sample_db;
3
4CREATE  TABLE IF NOT EXISTS sample_db.Person (
5  id_SSN INT NOT NULL ,
6  first VARCHAR(45) NULL ,
7  last VARCHAR(45) NULL ,
8  PRIMARY KEY (id_SSN) ,
9  UNIQUE INDEX SSN_UNIQUE (id_SSN ASC) )
10
11CREATE  TABLE IF NOT EXISTS sample_db.owner (
12  EIN INT NOT NULL ,
13  mailing_address VARCHAR(200) NULL ,
14  INDEX id_SSN () ,
15  CONSTRAINT id_SSN00
16    FOREIGN KEY ()
17    REFERENCES sample_db.Person ()
18    ON DELETE NO ACTION
19    ON UPDATE NO ACTION)