-----
-- make sure any old contents of the inventory and orders
--     tables are removed, and start with some initial
--     example inventory contents
--
-- last modified: 2016-01-22
-----

delete from inventory;
delete from orders;

-- stick some initial contents into inventory

insert into inventory
values
(1, 'widget', 100, 1.11);

insert into inventory
values
(2, 'gadget', 200, 2.22);

insert into inventory
values
(3, 'whatsit', 300, 3.33);

insert into inventory
values
(4, 'doohickey', 400, 4.44);

prompt inventory now contains:

select  *
from    inventory;

prompt But, there are NO orders yet:

select  *
from    orders;