These are chat archives for eysteinn13/FraunhoferDBWebsite

30th
Jun 2015
Eysteinn Gunnlaugsson
@eysteinn13
Jun 30 2015 13:26
INSERT INTO pos(po_number, customer_ID, receiving_date, initial_inspection, final_inspection, nr_of_lines, shipping_date, final_price, shipping_info) VALUES ('ponumber0', 1, '2015-5-8', 'initial inspection', 'final inspection', 10, '2015-06-06', 500, 'Ground');
Eysteinn Gunnlaugsson
@eysteinn13
Jun 30 2015 13:36
INSERT INTO lineitem(line_on_po, po_ID, quantity, price, tool_ID, diameter, length, double_end, coating_ID, est_run_number) VALUES (1,168, 20, 3.50, 'TESTTOOL168', '3/8', 3, 1, 5, 0.50);
INSERT INTO lineitem(line_on_po, po_ID, quantity, price, tool_ID, diameter, length, double_end, coating_ID, est_run_number) VALUES (1,168, 20, 3.50, 'TESTTOOL168', '3/8', 3, 1, 5, 0.50);
Freyr12
@Freyr12
Jun 30 2015 14:35
/Users/Frooze/Documents/220px-Linus_Torvalds.jpeg
Eysteinn Gunnlaugsson
@eysteinn13
Jun 30 2015 17:43
UPDATE price SET amount = x WHERE customer_ID = 1 AND diameter = 1/8 AND length = 2;