MySQL

please help (what's wrong?)

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 227

Reputation: k2k is an unknown quantity at this point

Solved Threads: 0

k2k

Offline

Posting Whiz in Training

please help (what's wrong?)

Oct 10th, 2008

would anybody please point out what is wrong with the "order table" .. i spent hours and can't figure it out why this simple table won't work. i appreciate it.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 
CREATE TABLE customer(
cid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
fn VARCHAR(10),
LN VARCHAR(10),
phone VARCHAR(15));
 
CREATE TABLE address(
street VARCHAR(40) PRIMARY KEY NOT NULL,
city VARCHAR(10),
cid INTEGER NOT NULL,
FOREIGN KEY(cid) REFERENCES customer(cid));
 
 
CREATE TABLE ORDER(
oid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
o_price DOUBLE(5,2),
o_date VARCHAR(10), 
o_time VARCHAR(10),
cid INTEGER NOT NULL,
FOREIGN KEY(cid) REFERENCES customer(cid));
CREATE TABLE customer(
cid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
fn VARCHAR(10),
ln VARCHAR(10),
phone VARCHAR(15));

CREATE TABLE address(
street VARCHAR(40) PRIMARY KEY NOT NULL,
city VARCHAR(10),
cid INTEGER NOT NULL,
FOREIGN KEY(cid) REFERENCES customer(cid));


CREATE TABLE order(
oid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
o_price DOUBLE(5,2),
o_date VARCHAR(10), 
o_time VARCHAR(10),
cid INTEGER NOT NULL,
FOREIGN KEY(cid) REFERENCES customer(cid));