--Populate the products table
insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price)
values (
    1,
    'Pen',
    'Super Pen',
    'This new pen is just amazing you need to try it!',
    5);

insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price)
values (
    2,
    'Pencil',
    'Custom Pencil',
    'Description: This pencil is designed to stay sharp longer, and is comfortable in the hand.',
    2);

insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price)
values (
    4,
    'Eraser',
    'New and Improved Eraser',
    'A long lasting smudgeless eraser for all kinds of pencils.',
    1.50);

insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price)
values (
    5,
    'Pencil Case',
    'Basic Pencil Case',
    'A small single zip plastic pencil case with lettering for names.',
    3);

insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price)
values (
    3,
    'Note Pad',
    'Student Special',
    '240 leaf A4 lecture pad.',
    3.50);

/* For the sake of time we will ignore writing packs

-- Populate the writing_packs table
insert into writing_packs
values (1,5,1,1,2,4);
-- Add a writing pack to the products table
insert into products (
    product_id,
    product_type,
    product_name,
    description,
    price,
    writing_pack_id)
values (6,
    'Writing Pack',
    'Special Writing Pack',
    'WritingPack including two super pens, a custom pencil a new and improved eraser and a basic pencil case.',
    15.00,
    1);
*/

-- Create a demo price list
insert into price_lists values ('Demo',CURRENT_DATE);

-- Add a the previous products to the demo price list
insert into price_list_products values ('Demo',1);
insert into price_list_products values ('Demo',2);
insert into price_list_products values ('Demo',3);
insert into price_list_products values ('Demo',4);
insert into price_list_products values ('Demo',5);
--insert into price_list_products values ('Demo',6);