-------------------------------------------------------------------------------
-- shopstraight.sql
-- tourne le 19 septembre 2019
-- @shopstraight 
-------------------------------------------------------------------------------
drop table product cascade constraint;
create table product (
    name varchar2(30),
    rank int,
    quantity int,
    category varchar2(13)
    -- eater varchar2(10) -- Constance, Samuel, Dad, ...
    -- rayon varchar2(10) -- liquids, cans, chocolate, ...
    -- shop varchar2(10) -- auchan, picard
    -- monthly_quantity int 
);

insert into product values ('butter', null, 1, 'breakfast');
insert into product values ('ham', null, 6, 'breakfast');
insert into product values ('cheese', null, 8, 'breakfast');
insert into product values ('toasts bread', null, 1, 'breakfast');
insert into product values ('coffee', null, 4, 'breakfast');
insert into product values ('milk', null, 2, 'breakfast');
insert into product values ('bacon', null, 1, 'breakfast');
insert into product values ('apple', null, 5, 'breakfast');
insert into product values ('orange juice', null, 1, 'breakfast');
insert into product values ('pompotes red fruits', null, 5, 'breakfast');
insert into product values ('barre gerble (fig or almond)', null, 5,
                            'breakfast');

insert into product values ('chewing gum', null, 1, 'miscellaneous');

insert into product values ('good chocolate biscuits C', null, 1, 'sweets');
insert into product values ('prince', null, 1, 'sweets');
insert into product values ('salty black chocolate', null, 1, 'sweets');
insert into product values ('honey', null, 1, 'sweets');
insert into product values ('biscuits bjorg fig soja', null, 1, 'sweets');

insert into product values ('coke', null, 1, 'liquids');

insert into product values ('baguette', null, 3, '');

insert into product values ('', null, 1, '');

-------------------------------------------------------------------------------
