/*=====
   initial inventory population for trigger examples

   last modified: 2016-12-01
=====*/

-- get rid of any pre-existing contents in inventory, orders

delete from orders;
delete from inventory;

-- stick some initial contents into inventory table

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;

-- end of init-inventory.sql