gistfile1.sql

BEGIN TRANSACTION;
CREATE TABLE vehicle_type (
  id int primary key,
  name text
);
INSERT INTO "vehicle_type" VALUES(1,'Car');
INSERT INTO "vehicle_type" VALUES(2,'Truck');
CREATE TABLE make (
  id int primary key,
  name text
);
INSERT INTO "make" VALUES(1,'Chevy');
INSERT INTO "make" VALUES(2,'Ford');
CREATE TABLE model (
  id int primary key,
  make_id int,
  vehicle_type_id int,
  name text
);
INSERT INTO "model" VALUES(1,1,1,'Camaro');
INSERT INTO "model" VALUES(2,2,1,'Mustang');
INSERT INTO "model" VALUES(3,1,2,'Silverado');
INSERT INTO "model" VALUES(4,2,2,'F-150');
COMMIT;