insert into departament(name, phone, notes) values('Podgotovitelni', '733-54-54(доб. 110)', 'Отдел занимается входным контролем и подготовкой комплектующих');
insert into departament(name, phone, notes) values('Sborochniy', '733-54-54(доб. 112)', 'Отдел осуществляет устновку ЭРЭ, рачную и автоматическую пайки');
insert into departament(name, phone, notes) values('Vihodnoi', '733-54-54(доб. 116)', 'Отдел очищает спаянные ПП, покрывает лаком и вставляет в корпуса');
insert into departament(name, phone, notes) values('Testirovachnii', '733-54-54(доб. 111)', 'Отдел проводит выходной функциональный и электрический контроли');



insert into staff(fio, pasport, id_dep) values('Ivanov', '4345 635434', 1);
insert into staff(fio, pasport, id_dep) values('Tulenko', '7334 641507', 1);
insert into staff(fio, pasport, id_dep) values('Nefedov', '8445 384890', 2);
insert into staff(fio, pasport, id_dep) values('Popov', '2331 479098', 2);
insert into staff(fio, pasport, id_dep) values('Udaev', '4778 538428', 2);
insert into staff(fio, pasport, id_dep) values('Moskalec', '2533 564234', 3);
insert into staff(fio, pasport, id_dep) values('Ismagilov', '2778 300955', 3);
insert into staff(fio, pasport, id_dep) values('Latypov', '2655 566356', 4);
insert into staff(fio, pasport, id_dep) values('Usmanov', '4355 540950', 4);



insert into list_of_operation(name, id_dep) values('Vhodnoi control', 1);
insert into list_of_operation(name, id_dep) values('Formovka', 1);
insert into list_of_operation(name, id_dep) values('Komplektacia ERE', 1);
insert into list_of_operation(name, id_dep) values('Ustanovka ERE', 2);
insert into list_of_operation(name, id_dep) values('Paika volnoi', 2);
insert into list_of_operation(name, id_dep) values('Paika payalnikom', 2);
insert into list_of_operation(name, id_dep) values('Otmivka', 3);
insert into list_of_operation(name, id_dep) values('Lakirovka', 3);
insert into list_of_operation(name, id_dep) values('Ustanovka v korpus', 3);
insert into list_of_operation(name, id_dep) values('Electric contol', 4);
insert into list_of_operation(name, id_dep) values('Function control', 4);
insert into list_of_operation(name, id_dep) values('Package', 3);



insert into equipment(name, inventar_nomer) values('Stol', 112342);
insert into equipment(name, inventar_nomer) values('Montage stol', 435709);
insert into equipment(name, inventar_nomer) values('Formovshik', 398084);
insert into equipment(name, inventar_nomer) values('Loopa', 400987);
insert into equipment(name, inventar_nomer) values('Pincet', 459800);
insert into equipment(name, inventar_nomer) values('Payalnik', 450984);
insert into equipment(name, inventar_nomer) values('Ustanovka paiki volnoi', 124349);
insert into equipment(name, inventar_nomer) values('Vanna', 390084);
insert into equipment(name, inventar_nomer) values('Ustanovka lakirovaniya', 454355);
insert into equipment(name, inventar_nomer) values('Otvertka', 450094);
insert into equipment(name, inventar_nomer) values('Ustanovka function control', 100934);
insert into equipment(name, inventar_nomer) values('Ustanovka electric control', 490372);
insert into equipment(name, inventar_nomer) values('Upakovshik v plenku', 450094);



insert into match_equip_op(id_listop, id_equipment) values(1, 1);
insert into match_equip_op(id_listop, id_equipment) values(1, 4);
insert into match_equip_op(id_listop, id_equipment) values(2, 1);
insert into match_equip_op(id_listop, id_equipment) values(2, 3);
insert into match_equip_op(id_listop, id_equipment) values(2, 5);
insert into match_equip_op(id_listop, id_equipment) values(3, 1);
insert into match_equip_op(id_listop, id_equipment) values(3, 5);
insert into match_equip_op(id_listop, id_equipment) values(4, 2);
insert into match_equip_op(id_listop, id_equipment) values(4, 5);
insert into match_equip_op(id_listop, id_equipment) values(4, 4);
insert into match_equip_op(id_listop, id_equipment) values(5, 7);
insert into match_equip_op(id_listop, id_equipment) values(6, 2);
insert into match_equip_op(id_listop, id_equipment) values(6, 4);
insert into match_equip_op(id_listop, id_equipment) values(6, 5);
insert into match_equip_op(id_listop, id_equipment) values(6, 6);
insert into match_equip_op(id_listop, id_equipment) values(7, 8);
insert into match_equip_op(id_listop, id_equipment) values(8, 9);
insert into match_equip_op(id_listop, id_equipment) values(9, 2);
insert into match_equip_op(id_listop, id_equipment) values(9, 10);
insert into match_equip_op(id_listop, id_equipment) values(10, 11);
insert into match_equip_op(id_listop, id_equipment) values(11, 12);
insert into match_equip_op(id_listop, id_equipment) values(12, 10);
insert into match_equip_op(id_listop, id_equipment) values(12, 13);



insert into products_type(type_name) values('Usilitel moshnosti');
insert into products_type(type_name) values('Metalloiskatel');



	insert into tp(id_type, nom, id_listop) values(1, 1, 1);
	insert into tp(id_type, nom, id_listop) values(1, 2, 2);
	insert into tp(id_type, nom, id_listop) values(1, 3, 3);
	insert into tp(id_type, nom, id_listop) values(1, 4, 4);
	insert into tp(id_type, nom, id_listop) values(1, 5, 6);
	insert into tp(id_type, nom, id_listop) values(1, 6, 7);
	insert into tp(id_type, nom, id_listop) values(1, 7, 9);
	insert into tp(id_type, nom, id_listop) values(1, 8, 10);
	insert into tp(id_type, nom, id_listop) values(2, 1, 1);
	insert into tp(id_type, nom, id_listop) values(2, 2, 2);
	insert into tp(id_type, nom, id_listop) values(2, 3, 3);
	insert into tp(id_type, nom, id_listop) values(2, 4, 4);
	insert into tp(id_type, nom, id_listop) values(2, 5, 5);
	insert into tp(id_type, nom, id_listop) values(2, 6, 7);
	insert into tp(id_type, nom, id_listop) values(2, 7, 8);
	insert into tp(id_type, nom, id_listop) values(2, 8, 9);
	insert into tp(id_type, nom, id_listop) values(2, 9, 11);
	insert into tp(id_type, nom, id_listop) values(2, 10, 12);




insert into resources(name) values('Resistor 1.3 кОм');
insert into resources(name) values('Resistor 5.6 кОм');
insert into resources(name) values('Resistor 3.2 кОм');
insert into resources(name) values('Resistor 1.7 кОм');
insert into resources(name) values('Resistor 15 Ом; 2 Вт');
insert into resources(name) values('Condensator 110 нФ');
insert into resources(name) values('Condensator 340 пФ');
insert into resources(name) values('Condensator 10 мкФ');
insert into resources(name) values('Condensator 300 мкФ; 30 В');
insert into resources(name) values('Condensator 150 мкФ; 12 В');
insert into resources(name) values('Condensator 600 нФ');
insert into resources(name) values('IMS TDA2005');
insert into resources(name) values('IMS К567ЛА7');
insert into resources(name) values('IMS К561ЛЕ5');
insert into resources(name) values('Tr-r КД522Б');
insert into resources(name) values('Tr-r КТ211А');
insert into resources(name) values('Dynamic 5 Вт');
insert into resources(name) values('Pripoi ПОС 61');
insert into resources(name) values('Spirt 97%');
insert into resources(name) values('Aceton');
insert into resources(name) values('Laak');
insert into resources(name) values('Provod');
insert into resources(name) values('Plenka');
insert into resources(name) values('Shuup');
insert into resources(name) values('Korpus 24B');



insert into res_usage(id_res, rcount) values(1, '5 sht.');
insert into res_usage(id_res, rcount) values(2, '2 g.');
insert into res_usage(id_res, rcount) values(4, '1 sht.');
insert into res_usage(id_res, rcount) values(5, '2 sht.');
insert into res_usage(id_res, rcount) values(6, '3 sht.');
insert into res_usage(id_res, rcount) values(8, '2 sht.');
insert into res_usage(id_res, rcount) values(9, '4 sht.');
insert into res_usage(id_res, rcount) values(12, '1 sht.');
insert into res_usage(id_res, rcount) values(18, '40 g.');
insert into res_usage(id_res, rcount) values(19, '100 g.');
insert into res_usage(id_res, rcount) values(20, '30 g.');
insert into res_usage(id_res, rcount) values(22, '150 sm.');
insert into res_usage(id_res, rcount) values(1, '2 sht.');
insert into res_usage(id_res, rcount) values(2, '2 sht.');
insert into res_usage(id_res, rcount) values(3, '3 sht.');
insert into res_usage(id_res, rcount) values(4, '2 sht.');
insert into res_usage(id_res, rcount) values(6, '3 sht.');
insert into res_usage(id_res, rcount) values(7, '1 sht.');
insert into res_usage(id_res, rcount) values(8 , '1 sht.');
insert into res_usage(id_res, rcount) values(10, '2 sht.');
insert into res_usage(id_res, rcount) values(11, '5 sht.');
insert into res_usage(id_res, rcount) values(13, '2 sht.');
insert into res_usage(id_res, rcount) values(14, '2 sht.');
insert into res_usage(id_res, rcount) values(15, '4 sht.');
insert into res_usage(id_res, rcount) values(16, '2 sht.');
insert into res_usage(id_res, rcount) values(17, '1 sht.');
insert into res_usage(id_res, rcount) values(18, '200 g.');
insert into res_usage(id_res, rcount) values(19, '20 g.');
insert into res_usage(id_res, rcount) values(20, '50 g.');
insert into res_usage(id_res, rcount) values(21, '45 g.');
insert into res_usage(id_res, rcount) values(23, '70 sm');
insert into res_usage(id_res, rcount) values(24, '1 sht.');
insert into res_usage(id_res, rcount) values(25, '1 sht.');



insert into tp_res_us(id_tp, id_resus) values(1, 1);
insert into tp_res_us(id_tp, id_resus) values(1, 2);
insert into tp_res_us(id_tp, id_resus) values(1, 3);
insert into tp_res_us(id_tp, id_resus) values(1, 4);
insert into tp_res_us(id_tp, id_resus) values(1, 5);
insert into tp_res_us(id_tp, id_resus) values(1, 6);
insert into tp_res_us(id_tp, id_resus) values(1, 7);
insert into tp_res_us(id_tp, id_resus) values(1, 8);

insert into tp_res_us(id_tp, id_resus) values(2, 1);
insert into tp_res_us(id_tp, id_resus) values(2, 2);
insert into tp_res_us(id_tp, id_resus) values(2, 3);
insert into tp_res_us(id_tp, id_resus) values(2, 4);
insert into tp_res_us(id_tp, id_resus) values(2, 5);
insert into tp_res_us(id_tp, id_resus) values(2, 6);
insert into tp_res_us(id_tp, id_resus) values(2, 7);

insert into tp_res_us(id_tp, id_resus) values(3, 1);
insert into tp_res_us(id_tp, id_resus) values(3, 2);
insert into tp_res_us(id_tp, id_resus) values(3, 3);
insert into tp_res_us(id_tp, id_resus) values(3, 4);
insert into tp_res_us(id_tp, id_resus) values(3, 5);
insert into tp_res_us(id_tp, id_resus) values(3, 6);
insert into tp_res_us(id_tp, id_resus) values(3, 7);
insert into tp_res_us(id_tp, id_resus) values(3, 8);
insert into tp_res_us(id_tp, id_resus) values(3, 12);

insert into tp_res_us(id_tp, id_resus) values(4, 1);
insert into tp_res_us(id_tp, id_resus) values(4, 2);
insert into tp_res_us(id_tp, id_resus) values(4, 3);
insert into tp_res_us(id_tp, id_resus) values(4, 4);
insert into tp_res_us(id_tp, id_resus) values(4, 5);
insert into tp_res_us(id_tp, id_resus) values(4, 6);
insert into tp_res_us(id_tp, id_resus) values(4, 7);
insert into tp_res_us(id_tp, id_resus) values(4, 8);
insert into tp_res_us(id_tp, id_resus) values(4, 12);

insert into tp_res_us(id_tp, id_resus) values(6, 9);
insert into tp_res_us(id_tp, id_resus) values(6, 10);

insert into tp_res_us(id_tp, id_resus) values(7, 11);


insert into tp_res_us(id_tp, id_resus) values(1, 22);
insert into tp_res_us(id_tp, id_resus) values(1, 23);
insert into tp_res_us(id_tp, id_resus) values(1, 24);
insert into tp_res_us(id_tp, id_resus) values(1, 25);
insert into tp_res_us(id_tp, id_resus) values(1, 26);

insert into tp_res_us(id_tp, id_resus) values(2, 13);
insert into tp_res_us(id_tp, id_resus) values(2, 14);
insert into tp_res_us(id_tp, id_resus) values(2, 15);
insert into tp_res_us(id_tp, id_resus) values(2, 16);
insert into tp_res_us(id_tp, id_resus) values(2, 17);
insert into tp_res_us(id_tp, id_resus) values(2, 18);
insert into tp_res_us(id_tp, id_resus) values(2, 19);
insert into tp_res_us(id_tp, id_resus) values(2, 20);
insert into tp_res_us(id_tp, id_resus) values(2, 21);

insert into tp_res_us(id_tp, id_resus) values(3, 13);
insert into tp_res_us(id_tp, id_resus) values(3, 14);
insert into tp_res_us(id_tp, id_resus) values(3, 15);
insert into tp_res_us(id_tp, id_resus) values(3, 16);
insert into tp_res_us(id_tp, id_resus) values(3, 17);
insert into tp_res_us(id_tp, id_resus) values(3, 18);
insert into tp_res_us(id_tp, id_resus) values(3, 19);
insert into tp_res_us(id_tp, id_resus) values(3, 20);
insert into tp_res_us(id_tp, id_resus) values(3, 21);
insert into tp_res_us(id_tp, id_resus) values(3, 22);
insert into tp_res_us(id_tp, id_resus) values(3, 23);
insert into tp_res_us(id_tp, id_resus) values(3, 24);
insert into tp_res_us(id_tp, id_resus) values(3, 25);
insert into tp_res_us(id_tp, id_resus) values(3, 26);
insert into tp_res_us(id_tp, id_resus) values(3, 32);

insert into tp_res_us(id_tp, id_resus) values(4, 13);
insert into tp_res_us(id_tp, id_resus) values(4, 14);
insert into tp_res_us(id_tp, id_resus) values(4, 15);
insert into tp_res_us(id_tp, id_resus) values(4, 16);
insert into tp_res_us(id_tp, id_resus) values(4, 17);
insert into tp_res_us(id_tp, id_resus) values(4, 18);
insert into tp_res_us(id_tp, id_resus) values(4, 19);
insert into tp_res_us(id_tp, id_resus) values(4, 20);
insert into tp_res_us(id_tp, id_resus) values(4, 21);
insert into tp_res_us(id_tp, id_resus) values(4, 22);
insert into tp_res_us(id_tp, id_resus) values(4, 23);
insert into tp_res_us(id_tp, id_resus) values(4, 24);
insert into tp_res_us(id_tp, id_resus) values(4, 25);
insert into tp_res_us(id_tp, id_resus) values(4, 26);

insert into tp_res_us(id_tp, id_resus) values(5, 27);
insert into tp_res_us(id_tp, id_resus) values(5, 28);

insert into tp_res_us(id_tp, id_resus) values(7, 29);

insert into tp_res_us(id_tp, id_resus) values(8, 30);

insert into tp_res_us(id_tp, id_resus) values(9, 32);
insert into tp_res_us(id_tp, id_resus) values(9, 33);

insert into tp_res_us(id_tp, id_resus) values(12, 31);

insert into tables(table_name) values('DEPARTMENT');
insert into tables(table_name) values('EQUIPMENT');
insert into tables(table_name) values('LIST_OF_OPERATION');
insert into tables(table_name) values('MATCH_EQUIP_OP');
insert into tables(table_name) values('OPERATIONS');
insert into tables(table_name) values('PRODUCT');
insert into tables(table_name) values('PRODUCTS_TYPE');
insert into tables(table_name) values('REPORTS');
insert into tables(table_name) values('RESOURCES');
insert into tables(table_name) values('RES_USAGE');
insert into tables(table_name) values('STAFF');
insert into tables(table_name) values('TP');
insert into tables(table_name) values('TP_RES_US');


insert into fields(field_name, id_table) values('NAME',1);
insert into fields(field_name, id_table) values('PHONE',1);
insert into fields(field_name, id_table) values('NOTES',1);
insert into fields(field_name, id_table) values('INVERTAR_NOMER',);
insert into fields(field_name, id_table) values('NAME',2);
insert into fields(field_name, id_table) values('NOTES',2);
insert into fields(field_name, id_table) values('NAME',3);
insert into fields(field_name, id_table) values('NOTES',3);
insert into fields(field_name, id_table) values('MASSOVOST',3);
insert into fields(field_name, id_table) values('TOCHNOST',3);
insert into fields(field_name, id_table) values('NOTES',4);
insert into fields(field_name, id_table) values('OP_STATUS_STR',5);
insert into fields(field_name, id_table) values('NOTES',5);
insert into fields(field_name, id_table) values('STATUS_STR',6);
insert into fields(field_name, id_table) values('NOTES',6);
insert into fields(field_name, id_table) values('TYPE_NAME',7);
insert into fields(field_name, id_table) values('NOTES',8);
insert into fields(field_name, id_table) values('NAME',9);
insert into fields(field_name, id_table) values('NAME',10);
insert into fields(field_name, id_table) values('NOTES',10);
insert into fields(field_name, id_table) values('RCOUNT',11);
insert into fields(field_name, id_table) values('NOTES',11);
insert into fields(field_name, id_table) values('FIO',12);
insert into fields(field_name, id_table) values('NOTES',12);
insert into fields(field_name, id_table) values('PASSPORT',12);
insert into fields(field_name, id_table) values('NOTES',13);
