Alter Table UOASxxx.Suppliers Drop Constraint Spplr_ID;
Drop index UOASxxx.SupplierID;
Drop table UOASxxx.Suppliers;
Create Table UOASxxx.Suppliers (
   SupplrNbr	Smallint Not Null,
   Name		Char(15),
   Address	VarChar(40),
   Code         Smallint
 )
   IN UOASxxx.TSSxxx
;

Create Unique Index SupplierID on UOASxxx.Suppliers(SupplrNbr);
Alter Table UOASxxx.Suppliers ADD Constraint Spplr_ID Primary Key (supplrNbr);

Insert Into UOASxxx.Suppliers values 
(51,'Defector Parts','16 Justamere Lane, Tacoma WA',20);
Insert Into UOASxxx.Suppliers values 
(52,'Vesuvius Inc','512 Ancient Blvd Pompeii NY',20);
Insert Into UOASxxx.Suppliers values 
(53,'Atlantis Co','8 Ocean Ave Washington DC',10);
Insert Into UOASxxx.Suppliers values 
(54,'Titanic Parts','32 Sinking Street Atlantic City NJ',30);
Insert Into UOASxxx.Suppliers values 
(57,'Eagle Hardware','64 Tranquility Place, Apollo MN',30);
Insert Into UOASxxx.Suppliers values 
(61,'Skylab Parts','128 Orbit Blvd, Sydney Australia',10);
Insert Into UOASxxx.Suppliers values 
(64,'Knight Ltd','256 Arthur Court, Camelot England',20);
Alter Table UOASxxx.Inventory Drop Constraint Invtry_ID;
Drop Index UOASxxx.InventoryID;
Drop Table UOASxxx.Inventory;

Create Table UOASxxx.Inventory (
   InvPartNbr	Smallint Not Null,
   PartName	Char(10),
   OnHand	Integer
   )
IN UOASxxx.TSSxxx
 ;

Create unique Index InventoryID on UOASxxx.Inventory(InvPartNbr);
Alter Table UOASxxx.Inventory ADD Constraint Invtry_ID Primary Key (InvPartNbr);  

Insert Into UOASxxx.Inventory Values (105,'Gear',0);
Insert Into UOASxxx.Inventory Values (106,'Gear',700);
Insert Into UOASxxx.Inventory Values (124,'Bolt',900);
Insert Into UOASxxx.Inventory Values (125,'Bolt',1000);
Insert Into UOASxxx.Inventory Values (134,'Nut',900);
Insert Into UOASxxx.Inventory Values (135,'Nut',1000);
Insert Into UOASxxx.Inventory Values (171,'Generator',500);
Insert Into UOASxxx.Inventory Values (172,'Generator',400);
Insert Into UOASxxx.Inventory Values (181,'Wheel',1000);
Insert Into UOASxxx.Inventory Values (205,'Band',450);
Insert Into UOASxxx.Inventory Values (206,'Motor',225);
Insert Into UOASxxx.Inventory Values (221,'Axle',1500);
Insert Into UOASxxx.Inventory Values (222,'Axle',25);
Insert Into UOASxxx.Inventory Values (231,'Axle',75);
Insert Into UOASxxx.Inventory Values (232,'Axle',150);
Insert Into UOASxxx.Inventory Values (241,'Wheel',300);


Alter Table UOASxxx.Quotations Drop Constraint Quotation;
Drop index UOASxxx.Q_NDX; 
Drop Table UOASxxx.Quotations;

Create Table UOASxxx.Quotations (
   SupplrNbr	Smallint Not Null,
   InvPartNbr   smallint Not Null,
   Price        Decimal (7,2),
   Time		Smallint,
   OnOrder	Integer
  )
IN UOASxxx.TSSxxx
 ;
 
Create unique Index Q_NDX on UOASxxx.Quotations(SupplrNbr,InvPartNbr);
Alter Table UOASxxx.Quotations ADD Constraint Quotation Primary Key (SupplrNbr, InvPartNbr);
  

Insert Into UOASxxx.Quotations Values (51,124,1.25,5,400);
Insert Into UOASxxx.Quotations Values (51,125,0.55,5,0);
Insert Into UOASxxx.Quotations Values (51,134,0.40,5,500);
Insert Into UOASxxx.Quotations Values (51,135,0.39,5,1000);
Insert Into UOASxxx.Quotations Values (51,221,0.30,10,10000);
Insert Into UOASxxx.Quotations Values (51,231,0.10,10,5000);
Insert Into UOASxxx.Quotations Values (52,105,7.50,10,200);
Insert Into UOASxxx.Quotations Values (52,205,0.15,20,0);
Insert Into UOASxxx.Quotations Values (52,206,0.15,20,0);
Insert Into UOASxxx.Quotations Values (53,124,1.35,3,500);
Insert Into UOASxxx.Quotations Values (53,125,0.58,3,200);
Insert Into UOASxxx.Quotations Values (53,134,0.38,3,200);
Insert Into UOASxxx.Quotations Values (53,135,0.42,3,1000);
Insert Into UOASxxx.Quotations Values (53,222,0.25,15,10000);
Insert Into UOASxxx.Quotations Values (53,232,Null,15,0);
Insert Into UOASxxx.Quotations Values (53,241,0.08,15,6000);