delete from property;
delete from propertyDetail;
delete from userBookmarks;
--
--
insert into property values 
  ('Automobiles','UsedOrNew','Which cars are you interested in?',1,'checkbox');
insert into property values 
  ('Automobiles','BodyStyle','Which body styles are you considering?',2,'multiselect');
insert into property values 
  ('Automobiles','Make','Which manufacturer are you considering?',3,'multiselect');
insert into property values 
  ('Automobiles','Age','What age cars are you considering?',4,'radio');
insert into property values 
  ('Automobiles','PriceRange','What price range are you looking for?',5,'radio');
insert into property values 
  ('Automobiles','SellerType','Which sellers do you prefer?',6,'radio');
insert into property values 
  ('Automobiles','Mileage','What mileage are you looking for?',7,'radio');
insert into property values 
  ('Automobiles','Color','What exterior color do you prefer?',8,'multiselect');
insert into property values 
  ('Automobiles','Sunroof','What exterior color do you prefer?',9,'radio');
insert into property values 
  ('Automobiles','LuxurySeats','What exterior color do you prefer?',10,'radio');
insert into property values 
  ('Automobiles','Transmission','What exterior color do you prefer?',11,'radio');
insert into property values 
  ('Automobiles','FuelType','What exterior color do you prefer?',12,'checkbox');
--
--
insert into propertyDetail values ('Automobiles','UsedOrNew','New Cars',1);
insert into propertyDetail values ('Automobiles','UsedOrNew','Used Cars',2);
insert into propertyDetail values ('Automobiles','UsedOrNew','Certified Cars',3);
--
insert into propertyDetail values ('Automobiles','BodyStyle','Convertible',1);
insert into propertyDetail values ('Automobiles','BodyStyle','Coupe',2);
insert into propertyDetail values ('Automobiles','BodyStyle','Hatchback',3);
insert into propertyDetail values ('Automobiles','BodyStyle','Sedan',4);
insert into propertyDetail values ('Automobiles','BodyStyle','SUV',5);
insert into propertyDetail values ('Automobiles','BodyStyle','Truck',6);
insert into propertyDetail values ('Automobiles','BodyStyle','Van',7);
insert into propertyDetail values ('Automobiles','BodyStyle','Wagon',8);
--
insert into propertyDetail values ('Automobiles','Make','Acura',1);
insert into propertyDetail values ('Automobiles','Make','Audi',2);
insert into propertyDetail values ('Automobiles','Make','Bentley',3);
insert into propertyDetail values ('Automobiles','Make','BMW',4);
insert into propertyDetail values ('Automobiles','Make','Ford',5);
insert into propertyDetail values ('Automobiles','Make','Honda',6);
insert into propertyDetail values ('Automobiles','Make','Hyundai',7);
insert into propertyDetail values ('Automobiles','Make','Mazda',8);
insert into propertyDetail values ('Automobiles','Make','Nissan',9);
insert into propertyDetail values ('Automobiles','Make','Saab',10);
insert into propertyDetail values ('Automobiles','Make','Toyota',11);
insert into propertyDetail values ('Automobiles','Make','Volkswagen',12);
--
insert into propertyDetail values ('Automobiles','Age','Less than 2 years old',1);
insert into propertyDetail values ('Automobiles','Age','Between 2 and 5 years old',2);
insert into propertyDetail values ('Automobiles','Age','Between 5 and 10 years old',3);
insert into propertyDetail values ('Automobiles','Age','More than 10 years old',4);
--
insert into propertyDetail values ('Automobiles','PriceRange','Less than $12,000',1);
insert into propertyDetail values ('Automobiles','PriceRange','Between $12,000 and $18,000',2);
insert into propertyDetail values ('Automobiles','PriceRange','Between $18,000 and $30,000',3);
insert into propertyDetail values ('Automobiles','PriceRange','More than $30,000',4);
--
insert into propertyDetail values ('Automobiles','SellerType','Dealers',1);
insert into propertyDetail values ('Automobiles','SellerType','Private Seller',2);
--
insert into propertyDetail values ('Automobiles','Mileage','Less than 15,000',1);
insert into propertyDetail values ('Automobiles','Mileage','Less than 30,000',2);
insert into propertyDetail values ('Automobiles','Mileage','Less than 45,000',3);
insert into propertyDetail values ('Automobiles','Mileage','Less than 60,000',4);
insert into propertyDetail values ('Automobiles','Mileage','More than 60,000',5);
--
insert into propertyDetail values ('Automobiles','Color','Beige',1);
insert into propertyDetail values ('Automobiles','Color','Black',2);
insert into propertyDetail values ('Automobiles','Color','Blue',3);
insert into propertyDetail values ('Automobiles','Color','Brown',4);
insert into propertyDetail values ('Automobiles','Color','Burgundy',5);
insert into propertyDetail values ('Automobiles','Color','Charcoal',6);
insert into propertyDetail values ('Automobiles','Color','Gold',7);
insert into propertyDetail values ('Automobiles','Color','Gray',8);
insert into propertyDetail values ('Automobiles','Color','Green',9);
insert into propertyDetail values ('Automobiles','Color','Orange',10);
insert into propertyDetail values ('Automobiles','Color','Pink',11);
insert into propertyDetail values ('Automobiles','Color','Red',12);
insert into propertyDetail values ('Automobiles','Color','Silver',13);
insert into propertyDetail values ('Automobiles','Color','Tan',14);
insert into propertyDetail values ('Automobiles','Color','Turquoise',15);
insert into propertyDetail values ('Automobiles','Color','White',16);
--
insert into propertyDetail values ('Automobiles','Sunroof','Yes',1);
insert into propertyDetail values ('Automobiles','Sunroof','No',2);
--
insert into propertyDetail values ('Automobiles','LuxurySeats','Yes',1);
insert into propertyDetail values ('Automobiles','LuxurySeats','No',2);
--
insert into propertyDetail values ('Automobiles','Transmission','Automatic',1);
insert into propertyDetail values ('Automobiles','Transmission','Manual',2);
--
insert into propertyDetail values ('Automobiles','FuelType','Alternative',1);
insert into propertyDetail values ('Automobiles','FuelType','Gasoline',2);
insert into propertyDetail values ('Automobiles','FuelType','Diesel',3);
--
--
drop table autoFactTable cascade constraints;
create table autoFactTable (
  autoID varchar2(64),
  url varchar2(256), -- can be a URL to a description page including a photo
  UsedOrNew number(3),
  BodyStyle number(3),
  Make number(3),
  Age number(3),
  PriceRange number(3),
  SellerType number(3),
  Mileage number(3),
  Color number(3),
  Sunroof number(3),
  LuxurySeats number(3),
  Transmission number(3),
  FuelType number(3),
  primary key (autoID)
);
--
--
