# Copyright (c) 2003 Juraj Kolesár (koli) <koli@koli.sk>               

# dump of data for database tucniak

USE tucniak;
#TABLE s_messures
INSERT INTO s_messures (messure) 
	VALUES ('ks');
INSERT INTO s_messures (messure) 
	VALUES ('m');
#TABLE s_codes
INSERT INTO s_codes (code) 
	VALUES ('mouse');
INSERT INTO s_codes (code) 
	VALUES ('cd');
INSERT INTO s_codes (code) 
	VALUES ('net');
#TABLE s_items
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('1', '1', 'S0001', 'Genius Netscroll');
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('1', '1', 'S0002', 'Microsoft Intelli');
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('2', '1', 'S0003', 'Imation CD-R');
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('1', '1', 'S0004', 'A4 Tech');
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('2', '1', 'S0005', 'Verbatim CD-RW');
INSERT INTO s_items (fk_s_codes, fk_s_messures, number, name) 
	VALUES ('3', '2', 'S0006', 'Ethernet coaxial');

#TABLE s_inputs
INSERT INTO s_inputs (fk_a_letters, code, date) 
	VALUES ('1', 'PRI001', '20030122');
INSERT INTO s_inputs (fk_a_letters, code, date) 
	VALUES ('1', 'PRI002', '20030213');

#TABLE s_add
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('1', '1', '10', '110');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('1', '2', '1', '540');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('1', '3', '20', '14');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('2', '4', '2', '250');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('2', '1', '5', '105');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('2', '5', '2', '45');
INSERT INTO s_add (fk_s_inputs, fk_s_items, count, price) 
	VALUES ('2', '6', '100', '16');