ALTER TRIGGER VLADELEC_BI0
AS
BEGIN /*$$IBE$$ 
  NEW.NVLAD = GEN_ID (NVLAD_GENERATOR, 1);
 $$IBE$$*/ POST_EVENT '$$IBE$$';
END;

INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1537,'ÀÁÀÅÂ','ÀËÅÊÑÅÉ','ÀËÅÊÑÅÅÂÈ×','235208755043','ÊÐÀÑÍÎÄÀÐÑÊÈÉ ÊÐÀÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ËÓÃÎÂÀß ÓË','4','4',NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0305','706111','2005-02-12 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1984-02-06 00:00:00',NULL,'ÒÅÌÐÞÊÑÊÈÉ',NULL,1,'ÑÂÅÒËÛÉ ÏÓÒÜ Ï','03251816000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1535,'ÀÊÈÌÎÂ','ÀÑÀÍ','ÁÅÊÈÐÎÂÈ×','235201819221','ÊÐÀÑÍÎÄÀÐÑÊÈÉ ÊÐÀÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'8ß ÃÂÀÐÄÅÉÑÊÀß ÓË','29',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0305','903336','2005-06-30 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1959-05-01 00:00:00',NULL,NULL,NULL,1,'ÒÀÌÀÍÜ ÑÒ-ÖÀ','03251825000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1398,'ÀÄÀÌßÍ','ÂÎÑÊÀÍ','ÌÈÑÀÊÎÂÈ×','235210358759','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ÇÀËÈÌÀÍÍÀß ÓË','5',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,NULL,NULL,'21','0307','569337','2007-07-26 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1987-01-09 00:00:00',NULL,NULL,NULL,1,'ÑÒÀÐÎÒÈÒÀÐÎÂÑÊÀß ÑÒ-ÖÀ','03251822000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1373,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÊÐÀÑÍÎÑÒÐÅËÜÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352038024','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ËÅÍÈÍÀ ÓË','8 Á',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075798','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÑÒÐÅËÊÀ Ï','03251813000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1365,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÍÎÂÎÒÀÌÀÍÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037831','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ËÅÍÈÍÀ','16',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075150','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÒÀÌÀÍÑÊÈÉ Ï','03251818000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1362,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÂÛØÅÑÒÅÁËÈÅÂÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037856','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ËÅÍÈÍÀ ÓË','94',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075138','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÂÛØÅÑÒÅÁËÈÅÂÑÊÀß ÑÒ-ÖÀ','03251804000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1357,'ÎÎÎ ÔÈÐÌÀ ÊÀÐÀ ÊÓÁÀÍÜ',NULL,NULL,'2352040665','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'ÏÈÎÍÅÐÑÊÀß ÓË','1 À',NULL,NULL,'ÀÏÊ','1072352000401','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÑÂÅÒËÛÉ ÏÓÒÜ Ï','03251816000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1340,'ÀÁÀÈÌÎÂ','ÀÍÀÒÎËÈÉ','ÄÌÈÒÐÈÅÂÈ×','235201729284','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í',NULL,'50 ËÅÒ ÎÊÒßÁÐß ÓË','12','1',NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0302','936378','2002-04-25 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1946-06-15 00:00:00',NULL,NULL,'ÑÒ. ÒÅÌÈÆÁÅÊÑÀÊÀß',1,'ÏÐÈÌÎÐÑÊÈÉ Ï','03251819000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1305,'ÀÊÑÈÍÈÍ','ÑÅÐÃÅÉ','ßÊÎÂËÅÂÈ×','235201821089','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ Ð-Í','ÒÅÌÐÞÊ Ã','ÊÀËÈÍÈÍÀ ÓË','67',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0303','201554','2002-07-31 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1948-04-08 00:00:00','23','ÊÅÌÅÐÎÂÑÊÀß','ÍÎÂÎÊÓÇÍÅÖÊ',1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1254,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÇÀÏÎÐÎÆÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß ÒÅÌÐÞÊÑÊÎÃÎ Ð-ÍÀ',NULL,NULL,'2352037920','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ËÅÍÈÍÀ ÓË','22',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075688','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÇÀÏÎÐÎÆÑÊÀß ÑÒ-ÖÀ','03251810000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1250,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÃÎËÓÁÈÖÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037870','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÑÎÂÅÒÑÊÀß ÓË','116',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075116','235201008',NULL,NULL,'21','0000','000000','2002-01-21 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÃÎËÓÁÈÖÊÀß ÑÒ-ÖÀ','03251807000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1247,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÒÅÌÐÞÊÑÊÎÃÎ ÃÎÐÎÄÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352038000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ËÅÍÈÍÀ ÓË','48',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075721','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÒÅÌÐÞÊ Ã','03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1245,'ÎÎÎ ÞÃÍÅÔÒÅÕÈÌÒÐÀÍÇÈÒ',NULL,NULL,'2352038786','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ','ÒÅÌÐÞÊ Ã','ÑÒÅÏÀÍÀ ÐÀÇÈÍÀ ÓË','47',NULL,NULL,'ÏÐÎ×ÈÅ','1062352015483','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1230,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÑÒÀÐÎÒÈÒÀÐÎÂÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352038049','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÏÅÐÂÎÌÀÉÑÊÈÉ ÏÅÐ','9',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075810','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÑÒÀÐÎÒÈÒÀÐÎÂÑÊÀß ÑÒ-ÖÀ','03251822000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1225,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÔÎÍÒÀËÎÂÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037969','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ËÅÍÈÍÀ ÓË','27',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075700','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÔÎÍÒÀËÎÂÑÊÀß ÑÒ-ÖÀ','03251830000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1187,'ÎÐËÎÂ','ÀËÅÊÑÀÍÄÐ','ÍÈÊÎËÀÅÂÈ×','235200850626','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÌÈÐÀ ÓË','18',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,'46','21','0304','224641','2003-03-11 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1948-08-09 00:00:00',NULL,'ÒÅÌÐÞÊÑÊÈÉ','ÔÎÍÒÀËÎÂÑÊÀß',1,'ÔÎÍÒÀËÎÂÑÊÀß ÑÒ-ÖÀ','03251830000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1176,'ÎÎÎ ÔÀÍÀÃÎÐÈß-ÞÃ',NULL,NULL,'2352040256','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÌÈÐÀ ÓË','49',NULL,NULL,'ÀÏÊ','1062352024679','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÑÅÍÍÎÉ Ï','03251819000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1162,'ÀÃÅÅÂ','ÑÅÐÃÅÉ','ÀËÅÊÑÀÍÄÐÎÂÈ×','235209670642','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÒÀÌÀÍÑÊÀß ÓË','340','3',NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','9603','564148','2003-09-27 00:00:00','ÎÂÄ ØÅËÊÎÂÑÊÎÃÎ ÐÀÉÎÍÀ','1978-04-04 00:00:00',NULL,'ØÅËÊÎÂÑÊÎÉ',NULL,1,'ÑÒÐÅËÊÀ Ï','03251813000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1148,'ÀÂÄÀËßÍ','ÀØÎÒ','ÍÈÊÎËÀÅÂÈ×','235204028505','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÁÅÐÅÃÎÂÀß ÓË','67',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0306','289440','2006-08-08 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÂÛØÅÑÒÅÁËÈÅÂÑÊÀß ÑÒ-ÖÀ','03251804000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1146,'ÎÎÎ ÝËÅÊÒÐÎÌÎÍÒÀÆÍÈÊ',NULL,NULL,'2352036490','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ','ÒÅÌÐÞÊ Ã','ËÅÍÈÍÀ ÓË','178','23',NULL,'ÏÐÎ×ÈÅ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1094,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÊÓÐ×ÀÍÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037983','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÊÐÀÑÍÀß ÓË','120',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075743',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÊÓÐ×ÀÍÑÊÀß ÑÒ-ÖÀ','03251816000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (1077,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÀÕÒÀÍÈÇÎÂÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037944','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÑÅÂÅÐÍÛÉ ÏÅÐ','11',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075765','235201001',1,NULL,'21','0000','000000','2002-01-21 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÀÕÒÀÍÈÇÎÂÑÊÀß ÑÒ-ÖÀ','03251802000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (991,'ÀÂÄÅÅÂ','ÑÅÐÃÅÉ','ÈÂÀÍÎÂÈ×','235205173618','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÊÐÀÑÍÎÀÐÌÅÉÑÊÀß ÓË','4','2',NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0304','307544','2003-04-05 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1960-08-30 00:00:00',NULL,NULL,'ÀËÅÉÑÊ',1,'ÒÀÌÀÍÑÊÈÉ Ï','03251818000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (954,'ÀÄÀÌÎÂ','ÀËÅÊÑÀÍÄÐ','ÈÂÀÍÎÂÈ×','235205813032','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ','ÒÅÌÐÞÊ','27 ÑÅÍÒßÁÐß ÓË','110',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0304','224432','2003-03-05 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1957-05-31 00:00:00',NULL,'ÒÅÌÐÞÊÑÊÈÉ','ÂÛØÅÑÒÅÁËÈÅÂÑÊÀß',1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (910,'ÀÁËßÒÈÔ','ÓÑÅÈÍ',NULL,'235203879165','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÃÀÃÀÐÈÍÀ ÓË','11','10',NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0303','200658','2002-07-19 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1956-09-03 00:00:00',NULL,NULL,'ÊÐÀÑÍÎÂÈØÅÐÑÊ',1,'ÑÅÍÍÎÉ Ï','03251819000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (794,'ÀÊÈØÈÍ','ÂÀÑÈËÈÉ','Ô¨ÄÎÐÎÂÈ×','000000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÏÐÎËÅÒÀÐÑÊÀß ÓË','179',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,NULL,NULL,'21','0000','000000','2000-01-21 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÑÒÀÐÎÒÈÒÀÐÎÂÑÊÀß ÑÒ-ÖÀ','03251822000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (710,'ÎÎÎ ÝËÅÊÒÀ',NULL,NULL,'0000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ','ÒÅÌÐÞÊ Ã',NULL,NULL,NULL,NULL,'ÏÐÎ×ÈÅ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (703,'ÀÁÐÀÌÎÂ','ÂÅÍÈÀÌÈÍ','ÀÍÀÒÎËÜÅÂÈ×','000000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÄÎÐÎÆÍÀß ÓË','2',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0000','000000','2000-12-20 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÇÀÏÎÐÎÆÑÊÀß ÑÒ','03251810000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (698,'ÀÁÄÓËÄÆÅËÈÊÎÂ','ÀÁËßÇÈÑ','ÀÁËßÌÅÒÎÂÈ×','000000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÑÎÑÅÄÑÊÀß ÓË','33',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0000','000000','2002-12-20 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÒÀÌÀÍÜ ÑÒ-ÖÀ','03251825000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (652,'ÀÁÈÁÓËÀÅÂ','ÐÅØÀÒ','ÑÀÁÐÈÅÂÈ×','000000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÊÎØÅÂÎÃÎ ÓË','21',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0000','000000','2000-12-20 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ',NULL,NULL,NULL,NULL,1,'ÑÒÐÅËÊÀ Ï','03251813000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (602,'ÀÁÐÀÌÎÂÀ','ËÞÁÎÂÜ','ÀÍÀÒÎËÜÅÂÍÀ','235204181528','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÐÀÁÎ×ÈÉ ÏÅÐ','26',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,0,NULL,'21','0300','351996','2000-08-18 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1954-12-10 00:00:00',NULL,NULL,NULL,1,'ÑÒÀÐÎÒÈÒÀÐÎÂÑÊÀß ÑÒ-ÖÀ','03251822000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (489,'¨ÐÆ','ÍÈÊÎËÀÉ','ÌÈÒÐÎÔÀÍÎÂÈ×','235200455288','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÖÅÍÒÐÀËÜÍÀß ÓË','52',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,'ÐÔ','21','0301','407367','2001-12-18 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1938-11-16 00:00:00',NULL,'ÒÅÌÐÞÊÑÊÈÉ',NULL,1,'ÑÎËÅÍÛÉ Õ','03251819000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (464,'ÎШË','ÂÈÊÒÎÐ','ÂÀÑÈËÜÅÂÈ×','000000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÑÎÂÅÒÑÊÀß ÓË','7',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÈËÜÈ× Ï','03251810000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (258,'ÀÁÈÁÓËÀÅÂ','ÔÅÂÇÈ','ÑÀÁÐÈÅÂÈ×','235209164798','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'ÊÎØÅÂÎÃÎ ÓË','21',NULL,NULL,'×ÀÑÒÍÛÉ',NULL,NULL,1,NULL,'21','0304','308009','2003-04-09 00:00:00','ÎÂÄ ÒÅÌÐÞÊÑÊÎÃÎ ÐÀÉÎÍÀ','1978-04-14 00:00:00',NULL,NULL,NULL,1,'ÑÒÐÅËÊÀ Ï','03251813000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (168,'ÎÎÎ ÞÃÑÒÐÎÉÌÀÐÊÅÒ',NULL,NULL,'0000000000','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ','ÒÅÌÐÞÊ Ã','ÀÍÀÏÑÊÎÅ ØÎÑÑÅ ÓË','5\1',NULL,NULL,'ÏÐÎ×ÈÅ',NULL,NULL,NULL,'23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (63,'5-É ÑÓÄÎÐÅÌÎÍÒÍÛÉ ÇÀÂÎÄ ÔÅÄÅÐÀËÜÍÎÉ ÏÎÃÐÀÍÈ×ÍÎÉ ÑËÓÆÁÛ ÐÔ',NULL,NULL,'2352021648','ÊÐÀÑÍÎÄÀÐÑÊÈÉ',NULL,'ÒÅÌÐÞÊ-ÏÎÐÒ',NULL,NULL,NULL,NULL,'ÏÐÎ×ÈÅ',NULL,'235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'03251501000',NULL);
INSERT INTO VLADELEC (NVLAD,FAM,NAME,OTCH,INN,REGION,RAION,TOWN,STREET,DOM,KW,TEL,TIPVLAD,OGRN,KPP,POL,COUNTRY,PASPKOD,SERPASP,NPASP,DATEPASP,WYDANPASP,DATEROGD,ROGDKODREG,ROGDRAION,ROGDTOWN,SENT_TO_UPR,NAS_PUNKT,OKATO,KORPUS) VALUES (12,'ÀÄÌÈÍÈÑÒÐÀÖÈß ÒÀÌÀÍÑÊÎÃÎ ÑÅËÜÑÊÎÃÎ ÏÎÑÅËÅÍÈß',NULL,NULL,'2352037817','ÊÐÀÑÍÎÄÀÐÑÊÈÉ','ÒÅÌÐÞÊÑÊÈÉ',NULL,'Ê. ÌÀÐÊÑÀ ÓË','106',NULL,NULL,'ÏÐÎ×ÈÅ','1052329075182','235201001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'ÒÀÌÀÍÜ ÑÒ-ÖÀ','03251825000',NULL);

ALTER TRIGGER VLADELEC_BI0
AS
BEGIN
  NEW.NVLAD = GEN_ID (NVLAD_GENERATOR, 1);
END