#
# mSQL Dump  (requires mSQL-1.0.6 or better)
#
# Host: localhost    Database: ucar
#--------------------------------------------------------


#
# Table structure for table 'cars'
#
CREATE TABLE cars (
  ID INT NOT NULL PRIMARY KEY,
  DEALERID INT,
  VIN CHAR(20),
  MAKE CHAR(20),
  MODEL CHAR(20),
  YEAR CHAR(4),
  COLOR CHAR(20),
  MILEAGE INT,
  PRICE INT,
  TERMS CHAR(60),
  GIF CHAR(1),
  DESCR CHAR(1),
  CREATEDATE INT,
  UPDATEDATE INT,
  EXPIREDATE INT,
  COMMENT CHAR(100),
  SOLD CHAR(3),
  TYPE CHAR(38)
) \g


#
# Dumping data for table 'cars'
#

INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (1,1,'383987','Ford','EXPLORER','1993','Red',23077,18500,'','','0',843948311,844005363,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2,1,'483987','Plymouth','SATELLITE','1965','Blue',33916,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (3,1,'5383987','Buick','LE SABRE','1990','Pink',17073,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (4,2,'683987','BMW','2002 TI','1975','Blue',41672,5299,'','','0',843948311,844644784,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (5,2,'783987','Mercedes','500 SEL','1996','Black',38642,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (6,2,'883987','Saturn','EF2002','1992','Charcoal',14513,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (7,3,'313987','Toyota','COROLLA','1991','Navy Blue',14730,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (8,3,'323987','Fiat','SPIDER 2000','1970','White',24163,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (9,3,'333987','Studebaker','ALLANTE +4','1952','Green',25247,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (1021,1,'IP3451FBR456FD111','Mazda','RX7','1988','Black',35000,25000,'EASY CREDIT',NULL,NULL,844052886,846235016,NULL,'Limited Edition Turbo-charge 13B Rotary Engine','N','2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (11,1,'483987','Plymouth','SATELLITE','1965','Blue',34143,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (12,1,'5383987','Buick','LE SABRE','1990','Pink',34473,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (13,2,'683987','BMW','2002 TI','1975','Green',45816,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (14,2,'783987','Mercedes','500 SEL','1996','Black',21004,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (15,2,'883987','Saturn','EF2002','1992','Charcoal',34661,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (16,3,'313987','Toyota','COROLLA','1991','Navy Blue',37757,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (17,3,'323987','Fiat','SPIDER 2000','1970','White',49325,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (18,3,'333987','Studebaker','ALLANTE +4','1952','Green',14392,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (19,1,'383987','Ford','EXPLORER','1993','Red',40328,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (20,1,'483987','Plymouth','SATELLITE','1965','Blue',46452,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (21,1,'5383987','Buick','LE SABRE','1990','Pink',17846,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (22,2,'683987','BMW','2002 TI','1975','Green',12365,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (23,2,'783987','Mercedes','500 SEL','1996','Black',32930,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (24,2,'883987','Saturn','EF2002','1992','Charcoal',22034,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (25,3,'313987','Toyota','COROLLA','1991','Navy Blue',47936,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (26,3,'323987','Fiat','SPIDER 2000','1970','White',33754,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (27,3,'333987','Studebaker','ALLANTE +4','1952','Green',17810,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (28,1,'383987','Ford','EXPLORER','1993','Red',17841,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (29,1,'483987','Plymouth','SATELLITE','1965','Blue',20725,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (30,1,'5383987','Buick','LE SABRE','1990','Pink',39221,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (31,2,'683987','BMW','2002 TI','1975','Green',11835,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (32,2,'783987','Mercedes','500 SEL','1996','Black',24824,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (33,2,'883987','Saturn','EF2002','1992','Charcoal',25107,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (34,3,'313987','Toyota','COROLLA','1991','Navy Blue',42302,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (35,3,'323987','Fiat','SPIDER 2000','1970','White',12888,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (36,3,'333987','Studebaker','ALLANTE +4','1952','Green',12099,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (37,1,'383987','Ford','EXPLORER','1993','Red',48373,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (38,1,'483987','Plymouth','SATELLITE','1965','Blue',12441,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (39,1,'5383987','Buick','LE SABRE','1990','Pink',40253,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (40,2,'683987','BMW','2002 TI','1975','Green',44181,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (41,2,'783987','Mercedes','500 SEL','1996','Black',38694,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (42,2,'883987','Saturn','EF2002','1992','Charcoal',46892,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (43,3,'313987','Toyota','COROLLA','1991','Navy Blue',45279,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (44,3,'323987','Fiat','SPIDER 2000','1970','White',26776,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (45,3,'333987','Studebaker','ALLANTE +4','1952','Green',33808,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (46,1,'383987','Ford','EXPLORER','1993','Red',38365,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (47,1,'483987','Plymouth','SATELLITE','1965','Blue',41688,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (48,1,'5383987','Buick','LE SABRE','1990','Pink',22992,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (49,2,'683987','BMW','2002 TI','1975','Green',40297,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (50,2,'783987','Mercedes','500 SEL','1996','Black',15286,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (51,2,'883987','Saturn','EF2002','1992','Charcoal',34911,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (52,3,'313987','Toyota','COROLLA','1991','Navy Blue',31870,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (53,3,'323987','Fiat','SPIDER 2000','1970','White',17820,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (54,3,'333987','Studebaker','ALLANTE +4','1952','Green',41549,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (55,1,'383987','Ford','EXPLORER','1993','Red',39817,18500,'','','0',843948311,844119129,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (56,1,'483987','Plymouth','SATELLITE','1965','Blue',31082,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (57,1,'5383987','Buick','LE SABRE','1990','Pink',32687,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (58,2,'683987','BMW','2002 TI','1975','Green',32638,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (59,2,'783987','Mercedes','500 SEL','1996','Black',26222,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (60,2,'883987','Saturn','EF2002','1992','Charcoal',35689,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (61,3,'313987','Toyota','COROLLA','1991','Navy Blue',35141,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (62,3,'323987','Fiat','SPIDER 2000','1970','White',34990,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (63,3,'333987','Studebaker','ALLANTE +4','1952','Green',21539,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (64,1,'383987','Ford','EXPLORER','1993','Red',34828,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (65,1,'483987','Plymouth','SATELLITE','1965','Blue',24727,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (66,1,'5383987','Buick','LE SABRE','1990','Pink',25474,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (67,2,'683987','BMW','2002 TI','1975','Green',29957,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (68,2,'783987','Mercedes','500 SEL','1996','Black',18205,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (69,2,'883987','Saturn','EF2002','1992','Charcoal',38120,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (70,3,'313987','Toyota','COROLLA','1991','Navy Blue',37865,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (71,3,'323987','Fiat','SPIDER 2000','1970','White',17517,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (72,3,'333987','Studebaker','ALLANTE +4','1952','Green',14265,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (73,1,'383987','Ford','EXPLORER','1993','Red',23792,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (74,1,'483987','Plymouth','SATELLITE','1965','Blue',13182,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (75,1,'5383987','Buick','LE SABRE','1990','Pink',42462,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (76,2,'683987','BMW','2002 TI','1975','Green',11920,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (77,2,'783987','Mercedes','500 SEL','1996','Black',17889,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (78,2,'883987','Saturn','EF2002','1992','Charcoal',40767,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (79,3,'313987','Toyota','COROLLA','1991','Navy Blue',40231,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (80,3,'323987','Fiat','SPIDER 2000','1970','White',27701,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (81,3,'333987','Studebaker','ALLANTE +4','1952','Green',25692,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (82,1,'383987','Ford','EXPLORER','1993','Red',46989,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (83,1,'483987','Plymouth','SATELLITE','1965','Blue',42484,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (84,1,'5383987','Buick','LE SABRE','1990','Pink',10221,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (85,2,'683987','BMW','2002 TI','1975','Green',43041,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (86,2,'783987','Mercedes','500 SEL','1996','Black',18433,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (87,2,'883987','Saturn','EF2002','1992','Charcoal',39519,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (88,3,'313987','Toyota','COROLLA','1991','Navy Blue',23817,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (89,3,'323987','Fiat','SPIDER 2000','1970','White',42094,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (90,3,'333987','Studebaker','ALLANTE +4','1952','Green',36455,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (91,1,'383987','Ford','EXPLORER','1993','Red',45466,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (92,1,'483987','Plymouth','SATELLITE','1965','Blue',23240,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (93,1,'5383987','Buick','LE SABRE','1990','Pink',15799,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (94,2,'683987','BMW','2002 TI','1975','Green',29985,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (95,2,'783987','Mercedes','500 SEL','1996','Black',35629,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (96,2,'883987','Saturn','EF2002','1992','Charcoal',41285,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (97,3,'313987','Toyota','COROLLA','1991','Navy Blue',45446,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (98,3,'323987','Fiat','SPIDER 2000','1970','White',23447,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (99,3,'333987','Studebaker','ALLANTE +4','1952','Green',15347,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (100,1,'383987','Ford','EXPLORER','1993','Red',41216,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (101,1,'483987','Plymouth','SATELLITE','1965','Blue',25689,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (102,1,'5383987','Buick','LE SABRE','1990','Pink',46662,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (103,2,'683987','BMW','2002 TI','1975','Green',29762,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (104,2,'783987','Mercedes','500 SEL','1996','Black',35875,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (105,2,'883987','Saturn','EF2002','1992','Charcoal',31394,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (106,3,'313987','Toyota','COROLLA','1991','Navy Blue',23631,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (107,3,'323987','Fiat','SPIDER 2000','1970','White',33853,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (108,3,'333987','Studebaker','ALLANTE +4','1952','Green',25349,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (109,1,'383987','Ford','EXPLORER','1993','Red',20709,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (110,1,'483987','Plymouth','SATELLITE','1965','Blue',27051,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (111,1,'5383987','Buick','LE SABRE','1990','Pink',12121,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (112,2,'683987','BMW','2002 TI','1975','Green',15061,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (113,2,'783987','Mercedes','500 SEL','1996','Black',38707,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (114,2,'883987','Saturn','EF2002','1992','Charcoal',35454,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (115,3,'313987','Toyota','COROLLA','1991','Navy Blue',47300,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (116,3,'323987','Fiat','SPIDER 2000','1970','White',46167,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (117,3,'333987','Studebaker','ALLANTE +4','1952','Green',36004,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (118,1,'383987','Ford','EXPLORER','1993','Red',39829,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (119,1,'483987','Plymouth','SATELLITE','1965','Blue',27459,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (120,1,'5383987','Buick','LE SABRE','1990','Pink',40135,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (121,2,'683987','BMW','2002 TI','1975','Green',46700,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (122,2,'783987','Mercedes','500 SEL','1996','Black',16626,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (123,2,'883987','Saturn','EF2002','1992','Charcoal',30888,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (124,3,'313987','Toyota','COROLLA','1991','Navy Blue',49377,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (125,3,'323987','Fiat','SPIDER 2000','1970','White',20038,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (126,3,'333987','Studebaker','ALLANTE +4','1952','Green',33989,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (127,1,'383987','Ford','EXPLORER','1993','Red',18122,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (128,1,'483987','Plymouth','SATELLITE','1965','Blue',15813,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (129,1,'5383987','Buick','LE SABRE','1990','Pink',30151,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (130,2,'683987','BMW','2002 TI','1975','Green',28109,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (131,2,'783987','Mercedes','500 SEL','1996','Black',10497,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (132,2,'883987','Saturn','EF2002','1992','Charcoal',49232,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (133,3,'313987','Toyota','COROLLA','1991','Navy Blue',18263,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (134,3,'323987','Fiat','SPIDER 2000','1970','White',16579,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (135,3,'333987','Studebaker','ALLANTE +4','1952','Green',44598,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (136,1,'383987','Ford','EXPLORER','1993','Red',27345,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (137,1,'483987','Plymouth','SATELLITE','1965','Blue',11731,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (138,1,'5383987','Buick','LE SABRE','1990','Pink',25598,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (139,2,'683987','BMW','2002 TI','1975','Green',21985,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (140,2,'783987','Mercedes','500 SEL','1996','Black',29384,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (141,2,'883987','Saturn','EF2002','1992','Charcoal',34295,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (142,3,'313987','Toyota','COROLLA','1991','Navy Blue',37937,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (143,3,'323987','Fiat','SPIDER 2000','1970','White',43565,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (144,3,'333987','Studebaker','ALLANTE +4','1952','Green',25128,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (145,1,'383987','Ford','EXPLORER','1993','Red',31917,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (146,1,'483987','Plymouth','SATELLITE','1965','Blue',18506,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (147,1,'5383987','Buick','LE SABRE','1990','Pink',47987,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (148,2,'683987','BMW','2002 TI','1975','Green',31247,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (149,2,'783987','Mercedes','500 SEL','1996','Black',48580,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (150,2,'883987','Saturn','EF2002','1992','Charcoal',24423,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (151,3,'313987','Toyota','COROLLA','1991','Navy Blue',43438,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (152,3,'323987','Fiat','SPIDER 2000','1970','White',16810,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (153,3,'333987','Studebaker','ALLANTE +4','1952','Green',36419,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (154,1,'383987','Ford','EXPLORER','1993','Red',36448,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (155,1,'483987','Plymouth','SATELLITE','1965','Blue',12208,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (156,1,'5383987','Buick','LE SABRE','1990','Pink',29857,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (157,2,'683987','BMW','2002 TI','1975','Green',34572,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (158,2,'783987','Mercedes','500 SEL','1996','Black',18655,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (159,2,'883987','Saturn','EF2002','1992','Charcoal',37412,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (160,3,'313987','Toyota','COROLLA','1991','Navy Blue',46901,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (161,3,'323987','Fiat','SPIDER 2000','1970','White',41103,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (162,3,'333987','Studebaker','ALLANTE +4','1952','Green',23227,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (163,1,'383987','Ford','EXPLORER','1993','Red',31222,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (1018,1,'999-87-9876','Chevrolet','Cavalier','1990','Blue',60000,2000,'',NULL,NULL,843971889,844003234,NULL,'','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (165,1,'5383987','Buick','LE SABRE','1990','Pink',12401,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (166,2,'683987','BMW','2002 TI','1975','Green',27241,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (167,2,'783987','Mercedes','500 SEL','1996','Black',34013,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (168,2,'883987','Saturn','EF2002','1992','Charcoal',43886,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (169,3,'313987','Toyota','COROLLA','1991','Navy Blue',14407,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (170,3,'323987','Fiat','SPIDER 2000','1970','White',18317,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (171,3,'333987','Studebaker','ALLANTE +4','1952','Green',43768,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (172,1,'383987','Ford','EXPLORER','1993','Red',33217,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (173,1,'483987','Plymouth','SATELLITE','1965','Blue',20048,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (174,1,'5383987','Buick','LE SABRE','1990','Pink',36017,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (175,2,'683987','BMW','2002 TI','1975','Green',45144,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (176,2,'783987','Mercedes','500 SEL','1996','Black',14830,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (177,2,'883987','Saturn','EF2002','1992','Charcoal',37269,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (178,3,'313987','Toyota','COROLLA','1991','Navy Blue',25849,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (179,3,'323987','Fiat','SPIDER 2000','1970','White',17549,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (180,3,'333987','Studebaker','ALLANTE +4','1952','Green',43874,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (181,1,'383987','Ford','EXPLORER','1993','Red',42013,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (182,1,'483987','Plymouth','SATELLITE','1965','Blue',32778,900,'','','0',843948311,845341337,0,'From Planet Claire','','2 Door Notchback (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (183,1,'5383987','Buick','LE SABRE','1990','Pink',11630,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (184,2,'683987','BMW','2002 TI','1975','Green',27488,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (185,2,'783987','Mercedes','500 SEL','1996','Black',20546,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (186,2,'883987','Saturn','EF2002','1992','Charcoal',11091,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (187,3,'313987','Toyota','COROLLA','1991','Navy Blue',13525,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (188,3,'323987','Fiat','SPIDER 2000','1970','White',47311,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (189,3,'333987','Studebaker','ALLANTE +4','1952','Green',15489,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (190,1,'383987','Ford','EXPLORER','1993','Red',37514,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (191,1,'483987','Plymouth','SATELLITE','1965','Blue',26268,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (192,1,'5383987','Buick','LE SABRE','1990','Pink',19917,6000,'','','0',843948311,843948311,0,'We call it the Pink Flamingo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (193,2,'683987','BMW','2002 TI','1975','Green',19936,4899,'','','0',843948311,843948311,0,'Collector Car','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (194,2,'783987','Mercedes','500 SEL','1996','Black',24439,48900,'','','0',843948311,843948311,0,'The best!','','Luxury')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (195,2,'883987','Saturn','EF2002','1992','Charcoal',27714,19000,'','','0',843948311,843948311,0,'No scratches on the doors!','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (196,3,'313987','Toyota','COROLLA','1991','Navy Blue',27058,6000,'','','0',843948311,843948311,0,'Oh what a feeling!','','Compact')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (197,3,'323987','Fiat','SPIDER 2000','1970','White',34035,1999,'','','0',843948311,843948311,0,'Needs tires','','Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (198,3,'333987','Studebaker','ALLANTE +4','1952','Green',20147,40000,'','','0',843948311,843948311,0,'Mint Condition','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (199,1,'383987','Ford','EXPLORER','1993','Red',14370,18500,'','','0',843948311,843948311,0,'Best selling car on the market','','Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (200,1,'483987','Plymouth','SATELLITE','1965','Blue',37583,900,'','','0',843948311,843948311,0,'From Planet Claire','','Classic')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (1022,1,'1234567891023','Chrysler','Concorde','1996','White',12000,10000,'cash',NULL,NULL,844196345,844196345,NULL,'Nice car. Executive demo','','Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2007,29,'Vin','Jeep','Comanche','1996','Blue',25000,29000,'Cash',NULL,NULL,NULL,845341421,NULL,NULL,NULL,'Sport Utility')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2008,30,'12345HY1234','Audi','100LS','89','Blue',12000,12500,'Cash',NULL,NULL,NULL,845626438,NULL,NULL,NULL,'4 Door Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2009,31,'Ford?????','Ford','MUSTANG','1982','black',160000,3500,'cod',NULL,NULL,NULL,845653126,NULL,NULL,NULL,'3 Door Hatchback')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2010,32,'V124312431243','Porsche','911','1983','White',102106,25000,'cash',NULL,NULL,NULL,845662638,NULL,NULL,NULL,'2 Door Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2014,36,'12341234','Chevrolet','CORVETTE','91','Black',123123,12302,'Cash',NULL,NULL,NULL,846014456,NULL,NULL,NULL,'2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2015,37,'12341234','Chevrolet','CORVETTE','91','Black',123123,12302,'Cash',NULL,NULL,NULL,846014501,NULL,NULL,NULL,'2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2018,40,'1233400908','Alfa Romeo','QUADRIFAGLIO','85','Black/White',1234567,12334,'Cash',NULL,NULL,NULL,846015685,NULL,NULL,NULL,'2 Door Convertible')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2019,41,'','Hummer','DFG 1000','1990','Camouflage',50000,96000,'',NULL,NULL,NULL,846213177,NULL,NULL,NULL,'Other Truck')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2022,44,'33393-309339','GM','JIMMY','1956','Pink',39993,20222,'OAC',NULL,NULL,NULL,846223490,NULL,'Comment1 Comment2',NULL,'2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2024,46,'V123j4j112343','Volkswagen','VANAGON','1984','blue',120142,5000,'cash',NULL,NULL,NULL,846233648,NULL,'Good Shape Good Stereo',NULL,'Full Size Van')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2025,47,'J11j2k3jj12344','Chevrolet','EL CAMINO','1977','White',204113,1500,'cash',NULL,NULL,NULL,846233885,NULL,'test1 test2',NULL,'Regular Cab Pickup')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2027,49,'VIN','Eagle','TALON','1995','RED',25000,96000,'OAC',NULL,NULL,NULL,846271343,NULL,'comment ',NULL,'2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2029,51,'','Chevrolet','MONTE CARLO','1976','PURPLE',67000,89000,'',NULL,NULL,NULL,846272110,NULL,' ',NULL,'4 Door Sedan')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2030,52,'J1243j21j34j213','Chevrolet','EL CAMINO','1977','BLUE',2812,2000,'1500 down 250 later',NULL,NULL,NULL,846283562,NULL,'great shape ',NULL,'Other Truck')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2031,53,'j1J2J344J123J','Mazda','626','1986','GRAY',151100,1500,'Cash',NULL,NULL,NULL,846480899,NULL,'good car dependable',NULL,'2 Door (Coupe or Sedan)')\g
INSERT INTO cars (ID, DEALERID, VIN, MAKE, MODEL, YEAR, COLOR, MILEAGE, PRICE, TERMS, GIF, DESCR, CREATEDATE, UPDATEDATE, EXPIREDATE, COMMENT, SOLD, TYPE) VALUES (2054,63,'','Audi','QUATTRO','1996','RED',12000,28000,'OAC',NULL,NULL,847433573,847433574,NULL,'comment line 1 comment line 2',NULL,'4 Door Sedan')\g

#
# Table structure for table 'dealer'
#
CREATE TABLE dealer (
  ID INT NOT NULL PRIMARY KEY,
  USERNAME CHAR(10),
  NAME CHAR(40),
  CFIRST CHAR(20),
  CLAST CHAR(20),
  ADDR1 CHAR(40),
  ADDR2 CHAR(40),
  CITY CHAR(22),
  STATE CHAR(18),
  COUNTRY CHAR(20),
  AREACODE CHAR(5),
  ZIP CHAR(16),
  PHONE CHAR(20),
  CREATEDATE INT,
  URL CHAR(80),
  DESCR INT,
  LOGO INT,
  EMAILADMIN CHAR(30),
  EMAIL CHAR(30),
  EMAILMATCH CHAR(30),
  UPDATEDATE INT,
  PUBLIC INT,
  VERIFIEDBY CHAR(30),
  VERIFIEDDATE INT
) \g


#
# Dumping data for table 'dealer'
#

INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (1,'rainier','Rainier Lincoln-Mercury','','','','','Seattle','WA','United States','206','98105','',843948311,'http://www.rainier.com',0,0,'','',NULL,844008455,0,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (2,'baker','Baker Ford','John','Elliott','','','Kent','WA','United States','206','','',843948311,'http://www.baker.com',0,0,'','',NULL,845618175,0,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (3,'adams','Adams Saturn','','','','','Auburn','WA','United States','206','98001','',843948311,'http://www.adams.com',0,0,'','',NULL,844009883,0,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (30,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','123-1234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,845626437,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (31,NULL,NULL,'Don','Britton','1909164th Ave',NULL,'Bellevue','WA','United States','206','98008','643-4759',NULL,NULL,NULL,NULL,NULL,'dbritt@halcyon.com',NULL,845653126,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (32,NULL,NULL,'Rick','Coulthurst','7451 Warner Ave #E142',NULL,'Huntington Beach','CA','United States','714','92647','848-2271',NULL,NULL,NULL,NULL,NULL,'rlc9999@earthlink.net',NULL,845662638,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (33,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','555-1212',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846013983,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (34,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','123-1234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846014244,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (35,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','123-1234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846014286,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (36,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','1321234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846014456,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (37,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','132-1234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846014501,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (38,NULL,NULL,'Eric','Park','123 Anywhere',NULL,'Anaheim','CA','United States','714','92801','132-1234',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846014534,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (39,NULL,NULL,'Eric','Park','123 anywhere',NULL,'Anaheim','CA','United States','714','92801','123-1324',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846015617,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (40,NULL,NULL,'Eric','Park','123 anywhere',NULL,'Anaheim','CA','United States','714','92801','123-1324',NULL,NULL,NULL,NULL,NULL,'ejp@autopedia.com',NULL,846015685,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (41,NULL,NULL,'John','Doe','123 Main Street',NULL,'Los Altos ','CA','United States','413','90455','222-2928',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846213177,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (42,NULL,NULL,'John','Elliott','83 Columbia',NULL,'Seattle','WA','United States','413','98104','444-4044',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846219600,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (43,NULL,NULL,'John','Elliott','83 Columbia',NULL,'Seattle','WA','United States','413','98104','444-4044',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846223428,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (44,NULL,NULL,'John','Elliott','83 Columbia',NULL,'Seattle','WA','United States','413','98104','444-4044',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846223490,1,'johne',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (45,NULL,NULL,'Rick','Coulthurst','7451 Warner Ave E142',NULL,'Huntington Beach','CA','United States','714','92647','848-2271',NULL,NULL,NULL,NULL,NULL,'rick@autopedia.com',NULL,846233589,1,NULL,NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (46,NULL,NULL,'Rick','Coulthurst','7451 Warner Ave E142',NULL,'Huntington Beach','CA','United States','714','92647','848-2271',NULL,NULL,NULL,NULL,NULL,'rick@autopedia.com',NULL,846233648,1,NULL,NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (47,NULL,NULL,'First','Last','Street',NULL,'City','CA','United States','714','92646','888-8888',NULL,NULL,NULL,NULL,NULL,'rick@autopedia.com',NULL,846233885,1,NULL,NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (48,NULL,NULL,'John','Elliott','123 Main St',NULL,'Seattle','WA','United States','206','98102','622-3333',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846271196,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (49,NULL,NULL,'John','Elliott','123 Main St',NULL,'Seattle','WA','United States','206','98102','622-3333',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846271343,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (50,NULL,NULL,'John','Elliott','83 Colu',NULL,'Seattle','WA','United States','206','98272','8600054',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846271621,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (51,NULL,NULL,'John','Elliott','83 Colu',NULL,'Seattle','WA','United States','206','98272','8600054',NULL,NULL,NULL,NULL,NULL,'johne@djc.com',NULL,846272110,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (52,NULL,NULL,'Jack','Chott','1243 5th street',NULL,'Garden Grove','CA','United States','714','92644','892-5226',NULL,NULL,NULL,NULL,NULL,'rick@autopedia.com',NULL,846283562,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (53,NULL,NULL,'Lee','Coulthurst','7745 Ronald Road',NULL,'Huntington Beach','CA','United States','714','92647','842-5956',NULL,NULL,NULL,NULL,NULL,'rlc9999@earthlink.net',NULL,846480899,1,'user',NULL)\g
INSERT INTO dealer (ID, USERNAME, NAME, CFIRST, CLAST, ADDR1, ADDR2, CITY, STATE, COUNTRY, AREACODE, ZIP, PHONE, CREATEDATE, URL, DESCR, LOGO, EMAILADMIN, EMAIL, EMAILMATCH, UPDATEDATE, PUBLIC, VERIFIEDBY, VERIFIEDDATE) VALUES (63,NULL,NULL,'John','Elliott','717 34th Ave',NULL,'Seattle','WA','United States','206','98122','622-8272',NULL,NULL,NULL,NULL,NULL,'john3@djc.com','JOHN3@DJC.COM',847433573,1,'user',NULL)\g

#
# Table structure for table 'keys'
#
CREATE TABLE keys (
  name CHAR(20) NOT NULL PRIMARY KEY,
  val INT
) \g


#
# Dumping data for table 'keys'
#

INSERT INTO keys (name, val) VALUES ('dealer',20)\g
INSERT INTO keys (name, val) VALUES ('cars',2000)\g