Skip to main content

Kurulum Dökümanı 25.2.1

DB Scripti Oracle

-- ******************** V25.2.1 MERGE SCRIPTS - STARTED ******************
CREATE TABLE "UDENTIFY".media_preferences (
id NUMBER(19) NOT NULL,
file_encryption NUMBER(1) DEFAULT 1 NOT NULL,
CONSTRAINT media_preferences_pkey PRIMARY KEY (ID) USING INDEX ( CREATE INDEX "UDENTIFY".media_preferences_id_ix ON "UDENTIFY".media_preferences(ID) ONLINE ),
CONSTRAINT fk_media_preferences_customer FOREIGN KEY (id) REFERENCES "UDENTIFY".customer_based_preferences (id) ON DELETE CASCADE
);


ALTER TABLE "UDENTIFY".ocr_security_preferences
ADD (mrz_ocr_data_match_threshold FLOAT DEFAULT 0.7 NOT NULL);

ALTER TABLE "UDENTIFY".checklist
ADD (randomize NUMBER(1) DEFAULT 0 NOT NULL);

ALTER TABLE "UDENTIFY".ocr_security_preferences
MODIFY (signature_exist_check DEFAULT NULL);


UPDATE "UDENTIFY".ocr_security_preferences
SET signature_exist_check = CASE
WHEN signature_exist_check = 1 THEN 1
WHEN signature_exist_check = 0 THEN 0
ELSE signature_exist_check
END;

ALTER TABLE "UDENTIFY".ocr_security_preferences
MODIFY (signature_exist_check NUMBER(5));

ALTER TABLE "UDENTIFY".ocr_security_preferences
MODIFY (signature_exist_check DEFAULT 1);

ALTER TABLE "UDENTIFY".ocr_security_preferences
ADD CONSTRAINT signature_exist_check_valid_values
CHECK (signature_exist_check IN (0, 1, 2));

-- ******************** V25.2.1 MERGE SCRIPTS - ENDED ********************

Eklenen enviromentler:

UDENTIFY_LOGBACK_JSON_ENABLED=false
SERVER_ERROR_INCLUDE_STACKTRACE=never
UDENTIFY_STRICT_XSS_FILTER_ENABLED=false
UDENTIFY_FACE_HEALTHCHECK_REMOVE_IMAGE=false
UDENTIFY_DOCUMENT_LIVENESS_THRESHOLD=0.6
SPRING_DATASOURCE_HIKARI_MAXIMUM_POOL_SIZE=50

Çıkarılan enviromentler:

UDENTIFY_OCR_ENABLE_MRZOCRDATAMATCH
UDENTIFY_MEDIA_ENCRYPTION_ENABLED
SPRING_WEB_RESOURCES_STATIC_LOCATIONS
UDENTIFY_AUTHENTICATOR_CUSTOMER_LOGO_FOLDER_ROOT