mysql to sqlite

[lukerobi]

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!