Could anyone lend some help?
Trying to figure out how to do this in SQLite3
(this is mySQL)
CREATE TABLE car_contacts (
id INTEGER NOT NULL AUTO_INCREMENT,
carriers_id CHAR NOT NULL,
name CHAR NULL,
phone CHAR NULL,
phone_ext INTEGER NULL,
fax CHAR NULL,
email CHAR NULL,
PRIMARY KEY(id, carriers_id),
INDEX car_contacts_FKIndex1(carriers_id),
FOREIGN KEY(carriers_id)
REFERENCES carriers(id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
); any help would be greatly apreciated!
Last edited by lukerobi; Oct 18th, 2009 at 5:13 pm.
Reputation Points: 14
Solved Threads: 16
Junior Poster in Training
Offline 50 posts
since Sep 2009
Unsolved 
