-- Добавить Крахмалева в локальную БД
Insert into ZAKUPKI_DEV.USERS (USER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,LOGIN,POSITION,PHONE,EMAIL,STATUS,ORGANIZATION_ID,IS_ADMIN,IS_SPECIALIST,NEEDS_PWD_CHANGE,IS_CONTRACT_SPECIALIST,REQUEST_STATUS,CREATE_DATE,LAST_MODIFY_DATE,LAST_MODIFY_USER_ID,REGISTRATION_DATE,INIT_PASSWORD,CODE_PHRASE,IS_PREPARE_CONTRACT_SPECIALIST,ORGANIZATION_ROLE,IS_COORDINATING_SPECIALIST,PASSWORD,CERTIFICATE_SN,ISSUER_SN,IS_ESIA_USER,EMAIL_EXT,SNILS,ESIA_UPDATE_DATE,IS_CHIEF,IS_PUBLISH_SPECIALIST,IS_SIGNING_SPECIALIST,IS_ADDITIONAL_ADMIN,IS_SVR_USER,CERTIFICATE_NAME,CERTIFICATE_EXPIRATION_DATE,INN) values
(2272216,'Николай','Петрович','Крахмалев-Тест','krahmalev','Уполномоченное должностное лицо','8-999-9999999','testoos@yandex.ru','A',1620620,1,0,0,0,'A',to_date('16-NOV-16','DD-MON-RR'),to_timestamp('28-JAN-17 06.33.20.345611000 PM','DD-MON-RR HH.MI.SSXFF AM'),2272215,to_timestamp('16-NOV-16 04.19.22.420000000 PM','DD-MON-RR HH.MI.SSXFF AM'),null,null,0,'FO,CU,CIA',0,'I3WlvsFO03WgW9YZS91eYXYL+h9zn+VdAvUbuX9UmXQ=','0ee4',null,0,null,null,null,0,1,1,0,1,'Крахмалев-Тест Николай Петрович.cer',to_timestamp('17-SEP-19 04.20.39.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),null);

Insert into ZAKUPKI_DEV.PRIVILEGE (PRIVILEGE_ID,ENABLED,ETP_ACTION,USER_ID,ORGANIZATION_ID,STATUS,ETP_ID,SYSTEM_PRIVILEGE,PRIVILEGE_SET,ETP_PRIVILEGE_SET,LAST_MODIFY_DATE,LAST_MODIFY_USER_ID,ORGANIZATION_LINK_ID,ORGANIZATION_ROLE)
values (8747855,null,null,2272216,null,'A',null,null,'5svo98bgoxbcd4sr39ed1y8l14781nj801qzjn0dpbse5jqcomjgysd3ha1m54ls80w5bf9tnqub01mxua3q0gbxw7p2c3on6efbvwmjaxw58jbyhndu52cimqpgmnv8o5thyhxg0xcx1a6vhwl0wh3fagf2pl7fwm0p44x73ij66tf518smuw5vb6q5ezst7wq3tex3scywmrsbfma6i8ke7kcwovh7ashnoeo5ma7yccd9dv15fi21wr8rfh0a5knjy0oztx8nqgzmk6nctgiuovr5ozrg6qp0i1e94tufk4scke2z6ecq8hjko0z72a54m2h6hnwmfbw00futrhhno7nkmc2vd79dsym90g5osyl3q5p94ygvvqvz78gdywgckqo',null,to_timestamp('28-JAN-17 06.41.31.974000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2272215,null,'OA');

-- Добавить Князеву в локальную БД
Insert into ZAKUPKI_DEV.USERS (USER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,LOGIN,POSITION,PHONE,EMAIL,STATUS,ORGANIZATION_ID,IS_ADMIN,IS_SPECIALIST,NEEDS_PWD_CHANGE,IS_CONTRACT_SPECIALIST,REQUEST_STATUS,CREATE_DATE,LAST_MODIFY_DATE,LAST_MODIFY_USER_ID,REGISTRATION_DATE,INIT_PASSWORD,CODE_PHRASE,IS_PREPARE_CONTRACT_SPECIALIST,ORGANIZATION_ROLE,IS_COORDINATING_SPECIALIST,PASSWORD,CERTIFICATE_SN,ISSUER_SN,IS_ESIA_USER,EMAIL_EXT,SNILS,ESIA_UPDATE_DATE,IS_CHIEF,IS_PUBLISH_SPECIALIST,IS_SIGNING_SPECIALIST,IS_ADDITIONAL_ADMIN,IS_SVR_USER,CERTIFICATE_NAME,CERTIFICATE_EXPIRATION_DATE,INN) values
(2272217,'Оксана','Петрович','Князева-Тест','knyazeva','Уполномоченное должностное лицо','8-999-9999999','testoos@yandex.ru','A',1620620,1,0,0,0,'A',to_date('16-NOV-16','DD-MON-RR'),to_timestamp('28-JAN-17 06.33.20.345611000 PM','DD-MON-RR HH.MI.SSXFF AM'),2272215,to_timestamp('16-NOV-16 04.19.22.420000000 PM','DD-MON-RR HH.MI.SSXFF AM'),null,null,0,'RA',0,'I3WlvsFO03WgW9YZS91eYXYL+h9zn+VdAvUbuX9UmXQ=','0E5E',null,0,null,null,null,0,1,1,0,1,'Князева-Тест Оксана Викторовна.cer',to_timestamp('17-SEP-19 04.20.39.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),null);

Insert into ZAKUPKI_DEV.PRIVILEGE (PRIVILEGE_ID,ENABLED,ETP_ACTION,USER_ID,ORGANIZATION_ID,STATUS,ETP_ID,SYSTEM_PRIVILEGE,PRIVILEGE_SET,ETP_PRIVILEGE_SET,LAST_MODIFY_DATE,LAST_MODIFY_USER_ID,ORGANIZATION_LINK_ID,ORGANIZATION_ROLE)
values (8747856,null,null,2272217,null,'A',null,null,'5svo98bgoxbcd4sr39ed1y8l14781nj801qzjn0dpbse5jqcomjgysd3ha1m54ls80w5bf9tnqub01mxua3q0gbxw7p2c3on6efbvwmjaxw58jbyhndu52cimqpgmnv8o5thyhxg0xcx1a6vhwl0wh3fagf2pl7fwm0p44x73ij66tf518smuw5vb6q5ezst7wq3tex3scywmrsbfma6i8ke7kcwovh7ashnoeo5ma7yccd9dv15fi21wr8rfh0a5knjy0oztx8nqgzmk6nctgiuovr5ozrg6qp0i1e94tufk4scke2z6ecq8hjko0z72a54m2h6hnwmfbw00futrhhno7nkmc2vd79dsym90g5osyl3q5p94ygvvqvz78gdywgckqo',null,to_timestamp('28-JAN-17 06.41.31.974000000 PM','DD-MON-RR HH.MI.SSXFF AM'),2272217,null,'RA');