gistfile1.sql

--Добавление ЕГАИС (включение для алкогольных товаров происходит на кассах)
INSERT INTO service_type(id, name)
VALUES (nextval('hibernate_sequence'), 'egais');
INSERT INTO service_provider(id, deleted, name, registered_name, service_type, settings_on_shop)
VALUES (nextval('hibernate_sequence'), FALSE, 'egais','ЕГАИС',(SELECT id FROM service_type WHERE name='egais'),FALSE);
INSERT INTO service_provider_settings(id, name, value, provider)
VALUES (nextval('hibernate_sequence'), 'egais_url', 'http://172.16.7.10:8080/xml', (SELECT id FROM service_provider WHERE name='egais' AND deleted=FALSE));