values(nextVal('idOsnRom'), '3', '12');
##TypeOfObor
insert into TypeOfObor(TypeID,Name)
values(nextVal('idTypeObor'), 'Рабочий стол');
insert into TypeOfObor(TypeID,Name)
values(nextVal('idTypeObor'), 'Компьютер');
insert into TypeOfObor(TypeID,Name)
values(nextVal('idTypeObor'), 'Сервер');
insert into TypeOfObor(TypeID,Name)
values(nextVal('idTypeObor'), 'Проектор');
##Character
insert into character(charID, TypeID, model, about)
values(nextVal('idChar'), '1', 'Diciro', '50x150');
insert into character(charID, TypeID, model, about)
values(nextVal('idChar'), '2', 'Apple', 'intel i7 3000MH');
insert into character(charID, TypeID, model, about)
values(nextVal('idChar'), '2', 'Sony', 'intel i5, 2000MH');
insert into character(charID, TypeID, model, about)
values(nextVal('idChar'), '3', 'Cisco', '10000 MH');
insert into character(charID, TypeID, model, about)
values(nextVal('idChar'), '4', 'bibigon', '10K');
##typeofCompl
insert into typeOfCompl(TypeID, Name, Compat)
values(nextVal('idTypeCompl'), 'Материнская плата','Apple');
insert into typeOfCompl(TypeID, Name, Compat)
values(nextVal('idTypeCompl'), 'Видеокарта','Sony');
insert into typeOfCompl(TypeID, Name, Compat)
values(nextVal('idTypeCompl'), 'процессор','любой компьютер');
##Obor
insert into Obor(OborID,invertNum,SerNum,Sostoyan,TypeID,charID)
values(nextVal('idObor'), 123422, 22334444, 'Новый', '2', '4');
insert into Obor(OborID,invertNum,SerNum,Sostoyan,TypeID,charID)
values(nextVal('idObor'), 122347, 55555, 'Потертый', '2', '5');
insert into Obor(OborID,invertNum,SerNum,Sostoyan,TypeID,charID)
values(nextVal('idObor'), 445422, 22333344, 'Исправный', '3', '3');
##Complect
insert into Complect(ComplID,Model,TypeID,OborID)
values(nextVal('idCompl'), 'GS2000', '1', '4');
insert into Complect(ComplID,Model,TypeID,OborID)
values(nextVal('idCompl'), 'GX2222', '2', '5');
insert into Complect(ComplID,Model,TypeID,OborID)
values(nextVal('idCompl'), 'I7', '3', '6');
##osnWorkPlace
insert into osnWorkPlace(osnWorkID, WorkId, OborID)
values(nextVal('idOsnWork'), '7', '4');
insert into osnWorkPlace(osnWorkID, WorkId, OborID)
values(nextVal('idOsnWork'), '12', '5');
insert into osnWorkPlace(osnWorkID, WorkId, OborID)
values(nextVal('idOsnWork'), '11', '6');