drop table if exists Purchaser;
drop table if exists Company1;
drop table if exists Company;
drop table if exists Product1;
drop table if exists Product;

create table Purchaser(ID int, Product text, Buyer text);
insert into Purchaser values(1, 'Gizmo', 'Joe Blow');
insert into Purchaser values(2, 'Powergizmo' ,'Jane Dow');
insert into Purchaser values(3, 'SingleTouch', 'Oscar Win');
insert into Purchaser values(4, 'MultiTouch' , 'Alice Wonder');

create table Company1(Cname text, HQ_city text);
insert into Company1 values('GWorks', 'Seattle');
insert into Company1 values('Canon', 'Seattle');
insert into Company1 values('Hitachi', 'Beijing');

create table Company(Cname text, Stock float, Country text);
insert into Company values('GWorks', 25.0, 'USA');
insert into Company values('Canon', 65.0, 'Japan');
insert into Company values('Hitachi', 15.0, 'Japan');

create table Product1(PName text, Maker text, Factory_loc text);
insert into Product1 values('Gizmo', 'GWorks', 'USA');
insert into Product1 values('Powergizmo', 'GWorks', 'USA');
insert into Product1 values('SingleTouch', 'Canon', 'China');
insert into Product1 values('MultiTouch', 'Hitachi', 'Japan');

create table Product(PName text,Price int, Category text, Manuf text);
insert into Product values('Gizmo', 19, 'Gadgets', 'GWorks');
insert into Product values('Powergizmo', 29, 'Gadgets', 'GWorks');
insert into Product values('SingleTouch', 149, 'Photography', 'Canon');
insert into Product values('MultiTouch', 203, 'Household', 'Hitachi');