
--------------------------------------------------
-- 06/18/2020
-- Author: Tony Chen 
-- Following changes are made to integrade with 
-- PHOENIX system.
--------------------------------------------------

-- Remove old properties. 
DELETE FROM `application_preferences` 
    WHERE NAME = 'PORTALREST'
;


-- Add new properties. 
INSERT INTO `application_preferences` (`NAME`, `VALUE`, `PREFERENCE`) VALUES
    ('PORTALREST', '1',                    'api.service.available'),
    ('PORTALREST', 'AES',                  'encryption.params.algorithm'),
    ('PORTALREST', 'CBC',                  'encryption.params.cipher.mode'),
    ('PORTALREST', 'PKCS5Padding',         'encryption.params.cipher.padding'),
    ('PORTALREST', 'HmacSHA512',           'encryption.params.hmac.algorithm'),
    ('PORTALREST', '256',                  'encryption.params.key.length'),
    ('PORTALREST', 'PBKDF2WithHmacSHA512', 'encryption.params.pbkdf2.algorithm'),
    ('PORTALREST', '200000',	           'encryption.params.pbkdf2.iterations')
;
-- --------------------------------------------------

INSERT INTO `application_preferences` (`NAME`, `VALUE`, `PREFERENCE`) VALUES
    ('PORTALREST', 'CIPRES SCIENCE GATEWAY', 'api.access.token.issuer'),
    ('PORTALREST', 'CIPRES PORTAL REST API', 'api.access.token.audience')
;
-- --------------------------------------------------

INSERT INTO `version` (`VERSION`, `LAST_MODIFIED_TIME`) VALUES 
    ('2020-06-18', NOW())
;
-- --------------------------------------------------
