drop table rec.sodetail;
drop table rec.salesorders;
drop table rec.customers;
drop table rec.inventory;
drop sequence rec.sonumseq;
@\\neelix\oracle\scripts\admin\makecustomers;

create sequence rec.sonumseq start with 13000;

create table rec.SalesOrders
    (SONUM number(6), 
     CUSTID number(5),
     ORDERDATE date,
     SHIPDATE date,
     SHIPVIA varchar2(10),
     ORDERTOTAL number(8,2),
     SALESAGENT number(5))
     PCTFREE 70
     PCTUSED 10
     STORAGE(INITIAL 100 next 50 MINEXTENTS 3);
create table rec.inventory
    (PARTNO varchar2(6), 
     DESCRIPTION varchar2(35),
     COST number(8,2),
     PRICE number(8,2),
     ONHAND number(7),
     ONORDER number(7),
     ALLOCATED number(7),
     ITEMNO number(3));
Create table rec.SODetail
    (SONUM number(6),
     LINENUM number(3),
     PARTNO varchar2(6),
     QTY number(7),
     COST number(8,2),
     PRICE number(8,2))
     PCTFREE 70
     PCTUSED 10
     STORAGE(INITIAL 100 next 100 MINEXTENTS 8);
Insert into rec.inventory values('RW','Royal Widget',456.0,570.0,7000,0,0,1);
Insert into rec.inventory values('NWW','New Wave Widget',688.0,860.0,7000,0,0,2);
Insert into rec.inventory values('EW','Econo Widget',160.0,200.0,7000,0,0,3);
Insert into rec.inventory values('FW','Flaming Widget',200.0,250.0,7000,0,0,4);
Insert into rec.inventory values('BB','Buggie Bumper',255.2,319.0,7000,0,0,5);
Insert into rec.inventory values('WJ','Watchemejigger',310.4,388.0,7000,0,0,6);
Insert into rec.inventory values('OTT','Old Time Thingy',577.6,722.0,7000,0,0,7);
Insert into rec.inventory values('RX7','RX7 Heating Module',720.0,900.0,7000,0,0,8);
Insert into rec.inventory values('RX8','RX8 Heating Module',960.0,1200.0,7000,0,0,9);
Insert into rec.inventory values('C22','C22 Control Unit',1120.0,1400.0,7000,0,0,10);
Insert into rec.inventory values('C24','C24 Control Unit',1360.0,1700.0,7000,0,0,11);
Insert into rec.inventory values('C26','C26 Control Unit',1520.0,1900.0,7000,0,0,12);
Insert into rec.inventory values('X14','X14 Ram Filter System',240.0,300.0,7000,0,0,13);
Insert into rec.inventory values('X15','X15 Ram Filter System',360.0,450.0,7000,0,0,14);
Insert into rec.inventory values('X17','X17 Ram Filter System',680.0,850.0,7000,0,0,15);
commit
/