Database Design

mysql to sqlite

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

•

Join Date: Sep 2009

Posts: 50

Reputation: lukerobi is an unknown quantity at this point

Solved Threads: 16

lukerobi

Offline

Junior Poster in Training

mysql to sqlite

Oct 18th, 2009

Could anyone lend some help?

Trying to figure out how to do this in SQLite3

(this is mySQL)

Help with Code Tags

(Toggle Plain Text)

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.