-- Populating the prints table..

INSERT INTO prints(sku, description, last_no_ordered, last_no_used, status_id)
VALUES ('MPP13112','Little Lady Mary','12','12', '1');
INSERT INTO prints(sku, description, last_no_ordered, last_no_used, status_id)
VALUES ('MPP12028','a Flower in the wind','103','100', '1');
INSERT INTO prints(sku, description, last_no_ordered, last_no_used, status_id)
VALUES ('MPP14111','Lost','183','182', '1');
INSERT INTO prints(sku, description, last_no_ordered, last_no_used, status_id)
VALUES ('MPP16054','Learn to dance','43','43', '1')

-- print_statusus
INSERT INTO print_status(status_id, description)
VALUES ('1','Active');
INSERT INTO print_status(status_id, description)
VALUES ('2','Discontinued');
INSERT INTO print_status(status_id, description)
VALUES ('3','Limit Reached');
INSERT INTO print_status(status_id, description)
VALUES ('4','Inactive');

-- Order lines
INSERT INTO order_lines(order_no, order_line_no, sku, qty_ordered, qty_received)
VALUES ('MAI-758','1','MPP13112','4','0');
INSERT INTO order_lines(order_no, order_line_no, sku, qty_ordered, qty_received)
VALUES ('MAI-758','2','MPP12028','12','0');
INSERT INTO order_lines(order_no, order_line_no, sku, qty_ordered, qty_received)
VALUES ('MAI-758','3','MPP14111','10','0');
INSERT INTO order_lines(order_no, order_line_no, sku, qty_ordered, qty_received)
VALUES ('MAI-758','4','MPP16054','5','0');
INSERT INTO order_lines(order_no, order_line_no, sku, qty_ordered, qty_received)
VALUES ('MAI-758','5','MPP13124','6','0');

SELECT * FROM order_lines
WHERE order_no='MAI-758'
AND sku='MPP13125'

SELECT * FROM orders
WHERE order_no='MAI-758'