seed.sql

INSERT INTO buyers (
  buyer_name
) VALUES ('summer classics'),('slettvoll'),('daro');

INSERT INTO products (
  description,
  buyer_id,
  weld_counter,
  polish_counter,
  weave_counter
) VALUES ('montecito lounge chair', 1, 0.1, 0.1, 0.1), ('montecito sofa', 1, 0.2, 0.2, 0.2), ('montecito ottoman', 1, 0.05, 0.05, 0.05), ('soho lounge chair', 1, 0.1, 0.1, 0.1), ('soho sofa', 1, 0.2, 0.2, 0.2), ('soho ottoman', 1, 0.05, 0.05, 0.05), ('marty lounge chair', 2, 0.1, 0.1, 0.1), ('marty sofa', 2, 0.2, 0.2, 0.2), ('marty ottoman', 2, 0.05, 0.05, 0.05), ('cape lounge chair', 2, 0.1, 0.1, 0.1), ('cape sofa', 0.1, 0.2, 0.2, 0.2), ('cape ottoman', 2, 0.05, 0.05, 0.05), ('antibes lounge chair', 2, 0.1, 0.1, 0.1), ('antibes sofa', 2, 0.2, 0.2, 0.2), ('antibes ottoman', 2, 1, 1, 1), ('langley lounge chair', 3, 0.1, 0.1, 0.1), ('langley sofa', 3, 0.2, 0.2, 0.2), ('langley ottoman', 3, 0.05, 0.05, 0.05), ('verde lounge chair', 3, 0.1, 0.1, 0.1), ('verde sofa', 3, 0.2, 0.2, 0.2), ('verde ottoman', 3, 0.05, 0.05, 0.05);

-- INSERT INTO orders (
--   client_po_no,
--   shipment_date,
--   product_id,
--   quantity
-- );

-- INSERT INTO schedule (
--   order_id INTEGER,
--   product_id INTEGER,
--   welding_schedule DATE,
--   polishing_schedule DATE,
--   weaving_schedule DATE
-- );