fedorm

--Добавление процессинга для Exist.ru
INSERT INTO service_type(id, name)
VALUES (NEXTVAL('hibernate_sequence'), 'exist');

INSERT INTO service_provider(id, deleted, name, registered_name, service_type, settings_on_shop)
VALUES (NEXTVAL('hibernate_sequence'), FALSE, 'exist','Exist.ru',(SELECT id FROM service_type WHERE name='exist'),FALSE);

INSERT INTO service_provider_settings(id, name, VALUE, provider)
VALUES (NEXTVAL('hibernate_sequence'), 'balance_service_wsdl', 'http://172.29.16.223:8090/ExistEmulator/ExistBalanceService', (SELECT id FROM service_provider WHERE name='exist' AND deleted=FALSE));

INSERT INTO service_provider_settings(id, name, VALUE, provider)
VALUES (NEXTVAL('hibernate_sequence'), 'user_service_wsdl', 'http://172.29.16.223:8090/ExistEmulator/ExistUserService', (SELECT id FROM service_provider WHERE name='exist' AND deleted=FALSE));

INSERT INTO service_provider_settings(id, name, VALUE, provider)
VALUES (NEXTVAL('hibernate_sequence'), 'document_service_wsdl', 'http://172.29.16.223:8090/ExistEmulator/ExistDocumentService', (SELECT id FROM service_provider WHERE name='exist' AND deleted=FALSE));

INSERT INTO service_provider_settings(id, name, VALUE, provider)
VALUES(NEXTVAL('hibernate_sequence'), 'bankCodes', 'Сбербанк=24;Газпромбанк=25;Альфабанк=28', (SELECT id FROM service_provider WHERE name='exist' AND deleted=FALSE));