Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Добавление процессинга Подарочные карты ЦФТ
- INSERT INTO service_type (id, name) SELECT NEXTVAL('hibernate_sequence'), 'giftcards' WHERE NOT EXISTS (SELECT 1 FROM service_type WHERE name = 'giftcards');
- INSERT INTO service_provider (id, DELETED, name, registered_name, service_type) VALUES (NEXTVAL('hibernate_sequence'), FALSE, 'CFTGiftCards', 'Подарочные карты ЦФТ', (SELECT id FROM service_type WHERE name LIKE 'giftcards'));
- -- Добавление префиксов для Подарочных карт ЦФТ
- INSERT INTO service_provider_settings (id, name, VALUE, provider) VALUES (NEXTVAL('hibernate_sequence'), 'barCodePrefixes', '778,777,776', (SELECT id FROM service_provider WHERE name LIKE 'CFTGiftCards'));
- INSERT INTO service_provider_settings (id, name, VALUE, provider) VALUES (NEXTVAL('hibernate_sequence'), 'cardPrefixes', '778,777,776', (SELECT id FROM service_provider WHERE name LIKE 'CFTGiftCards'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement