[sql] Failed to execute: ALTER TABLE geocodes_country ADD INDEX IDX_COUNTRY_CODE (code ASC) , ADD INDEX IDX_COUNTRY_NAME (value ASC)
[sql] Failed to execute: ALTER TABLE geocodes_city ADD INDEX IDX_CITY_CODE (code ASC) , ADD INDEX IDX_CITY_NAME (value ASC) , ADD INDEX IDX_COUNTRY_CODE_CITIES (code_country ASC)
[sql] Failed to execute: INSERT INTO identitystore_duplicate_rule( code, name, description, nb_equal_attributes, nb_missing_attributes, priority, active, daemon, nb_filled_attributes) VALUES ('ExternalDeclarationRule', 'Règle utilisée pour rattacher les déclarations externes d''identités suspectées d''avoir des doublons', '', 0, 0, 0, 0, 0, 0)
[sql] Failed to execute: CREATE TABLE identitystore_identity ( id_identity int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), connection_id varchar(100) NULL UNIQUE, customer_id varchar(50) NOT NULL UNIQUE, date_create timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, last_update_date timestamp(3) DEFAULT CURRENT_TIMESTAMP, is_deleted smallint default 0, date_delete timestamp(3) NULL, is_merged smallint default 0, date_merge timestamp(3) NULL, id_master_identity int NULL, is_mon_paris_active smallint NOT NULL DEFAULT 0, expiration_date timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP + INTERVAL '36 MONTH', PRIMARY KEY (id_identity) )
[sql] Failed to execute: CREATE INDEX identitystore_identity_connection_id ON identitystore_identity (connection_id)
[sql] Failed to execute: CREATE INDEX identitystore_identity_customer_id ON identitystore_identity (customer_id)
[sql] Failed to execute: CREATE INDEX identitystore_identity_master_id ON identitystore_identity (id_master_identity)
[sql] Failed to execute: CREATE INDEX identitystore_identity_expiration_date ON identitystore_identity (expiration_date)
[sql] Failed to execute: CREATE TABLE identitystore_ref_attribute ( id_attribute int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), name varchar(100) NOT NULL default '' UNIQUE, key_name varchar(100) NOT NULL default '' UNIQUE, description varchar(255) NULL, key_type int NOT NULL default '0', key_weight int NOT NULL default '0', certifiable smallint default 0, pivot smallint default 0, mandatory_for_creation smallint NOT NULL DEFAULT 0, common_search_key VARCHAR(100) NULL, validation_regex varchar(510) DEFAULT '^[A-Za-zÀ-Üà-üds''-]+$', validation_error_message varchar(255) DEFAULT 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', validation_error_message_key varchar(128) NOT NULL DEFAULT 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash', PRIMARY KEY (id_attribute) )
[sql] Failed to execute: ALTER TABLE identitystore_ref_certification_attribute_level ADD CONSTRAINT fk_attribute_ref_certification_level_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: CREATE TABLE identitystore_identity_attribute ( id_identity int NOT NULL default '0', id_attribute int NOT NULL default '0', attribute_value LONGVARCHAR NULL, id_certification int NOT NULL default '0', id_file int default '0', lastupdate_date timestamp(3) NOT NULL default CURRENT_TIMESTAMP, lastupdate_application VARCHAR(100) NULL, PRIMARY KEY (id_identity, id_attribute) )
[sql] Failed to execute: ALTER TABLE identitystore_identity_attribute ADD CONSTRAINT fk_identity_attribute_id_identity FOREIGN KEY (id_identity) REFERENCES identitystore_identity (id_identity)
[sql] Failed to execute: ALTER TABLE identitystore_identity_attribute ADD CONSTRAINT fk_identity_attribute_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: CREATE INDEX ix_attribute_value ON identitystore_identity_attribute (attribute_value ASC)
[sql] Failed to execute: CREATE TABLE identitystore_identity_attribute_certificate ( id_attribute_certificate int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), certifier_code varchar(255) NOT NULL default '', certificate_date timestamp(3) NOT NULL, certificate_level int NOT NULL default '0', expiration_date timestamp(3) NULL default NULL, PRIMARY KEY (id_attribute_certificate) )
[sql] Failed to execute: CREATE TABLE identitystore_client_application_certifiers ( id_client_app int NOT NULL, certifier_code varchar(255) NOT NULL default '', PRIMARY KEY (id_client_app, certifier_code) )
[sql] Failed to execute: CREATE INDEX identitystore_client_application_certifiers_id_client_app ON identitystore_client_application_certifiers (id_client_app)
[sql] Failed to execute: CREATE TABLE identitystore_identity_attribute_history ( id_history int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), change_type int NOT NULL, change_satus varchar(255) NOT NULL, change_message varchar(255) default null, author_type varchar(255) NOT NULL, author_name varchar(255) default null, client_code varchar(255) default null, id_identity int NOT NULL, attribute_key varchar(50) NOT NULL, attribute_value varchar(255) default null, certification_process varchar(255) default null, certification_date timestamp(3) default null, modification_date timestamp(3) NOT NULL default CURRENT_TIMESTAMP, metadata json DEFAULT NULL, PRIMARY KEY (id_history) )
[sql] Failed to execute: CREATE TABLE identitystore_service_contract ( id_service_contract int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), id_client_app integer NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, organizational_entity character varying(255) DEFAULT ''::character varying NOT NULL, moa_entity_name character varying(255) DEFAULT ''::character varying NOT NULL, moa_responsible_name character varying(255) DEFAULT ''::character varying NOT NULL, moa_contact_name character varying(255) DEFAULT ''::character varying NOT NULL, moe_entity_name character varying(255) DEFAULT ''::character varying NOT NULL, moe_responsible_name character varying(255) DEFAULT ''::character varying NOT NULL, contact_name character varying(255) DEFAULT ''::character varying NOT NULL, service_type character varying(255) DEFAULT ''::character varying NOT NULL, starting_date date NOT NULL, ending_date date, data_retention_period_in_months integer NOT NULL, authorized_creation smallint DEFAULT 0 NOT NULL, authorized_update smallint DEFAULT 0 NOT NULL, authorized_deletion smallint DEFAULT 0 NOT NULL, authorized_search smallint DEFAULT 0 NOT NULL, authorized_import smallint DEFAULT 0 NOT NULL, authorized_export smallint DEFAULT 0 NOT NULL, authorized_merge smallint DEFAULT 0 NOT NULL, authorized_account_update smallint DEFAULT 0 NOT NULL, authorized_decertification smallint DEFAULT 0 NOT NULL, authorized_agent_history_read smallint DEFAULT 0 NOT NULL, PRIMARY KEY (id_service_contract) )
[sql] Failed to execute: ALTER TABLE identitystore_service_contract ADD CONSTRAINT fk_service_contract_id_client_app FOREIGN KEY (id_client_app) REFERENCES identitystore_client_application (id_client_app)
[sql] Failed to execute: CREATE TABLE identitystore_service_contract_attribute_right ( id_service_contract int NOT NULL, id_attribute int NOT NULL, searchable smallint NOT NULL default 0, readable smallint NOT NULL default 0, writable smallint NOT NULL default 0, mandatory smallint NOT NULL default 0, PRIMARY KEY (id_service_contract, id_attribute) )
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_right ADD CONSTRAINT fk_attribute_right_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_right ADD CONSTRAINT fk_attribute_right_id_service_contract FOREIGN KEY (id_service_contract) REFERENCES identitystore_service_contract (id_service_contract)
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_requirement ADD CONSTRAINT fk_attribute_requirement_id_service_contract FOREIGN KEY (id_service_contract) REFERENCES identitystore_service_contract (id_service_contract)
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_requirement ADD CONSTRAINT fk_attribute_requirement_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_certification ADD CONSTRAINT fk_attribute_certification_id_service_contract FOREIGN KEY (id_service_contract) REFERENCES identitystore_service_contract (id_service_contract)
[sql] Failed to execute: ALTER TABLE identitystore_service_contract_attribute_certification ADD CONSTRAINT fk_attribute_certification_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: ALTER TABLE identitystore_identity_search_rule_attribute ADD CONSTRAINT fk_identity_search_rule_attribute_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: INSERT INTO identitystore_identity_search_rule_attribute (id_rule, id_attribute) SELECT MAX(r.id_rule), a.id_attribute FROM identitystore_identity_search_rule r, identitystore_ref_attribute a WHERE a.key_name = 'login' GROUP BY a.id_attribute
[sql] Failed to execute: INSERT INTO identitystore_identity_search_rule_attribute (id_rule, id_attribute) SELECT MAX(r.id_rule), a.id_attribute FROM identitystore_identity_search_rule r, identitystore_ref_attribute a WHERE a.key_name = 'email' GROUP BY a.id_attribute
[sql] Failed to execute: INSERT INTO identitystore_identity_search_rule_attribute (id_rule, id_attribute) SELECT MAX(r.id_rule), a.id_attribute FROM identitystore_identity_search_rule r, identitystore_ref_attribute a WHERE a.key_name = 'family_name' GROUP BY a.id_attribute
[sql] Failed to execute: INSERT INTO identitystore_identity_search_rule_attribute (id_rule, id_attribute) SELECT MAX(r.id_rule), a.id_attribute FROM identitystore_identity_search_rule r, identitystore_ref_attribute a WHERE a.key_name = 'first_name' GROUP BY a.id_attribute
[sql] Failed to execute: INSERT INTO identitystore_identity_search_rule_attribute (id_rule, id_attribute) SELECT MAX(r.id_rule), a.id_attribute FROM identitystore_identity_search_rule r, identitystore_ref_attribute a WHERE a.key_name = 'birthdate' GROUP BY a.id_attribute
[sql] Failed to execute: CREATE TABLE identitystore_identity_history ( id_history int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), change_type int not null, change_status varchar(255), change_message varchar(255), author_type varchar(255), author_name varchar(255), client_code varchar(255), customer_id varchar(50) NOT NULL, modification_date timestamp(3) default CURRENT_TIMESTAMP, metadata json default NULL, PRIMARY KEY (id_history) )
[sql] Failed to execute: CREATE INDEX identitystore_identity_history_cuid ON identitystore_identity_history (customer_id)
[sql] Failed to execute: CREATE TABLE identitystore_duplicate_rule ( id_rule int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), code varchar(100) NOT NULL UNIQUE, name varchar(100) NOT NULL, description varchar, nb_filled_attributes int, nb_equal_attributes int, nb_missing_attributes int, priority INT NOT NULL DEFAULT 100, active smallint NOT NULL DEFAULT 0, daemon smallint NOT NULL DEFAULT 0, daemon_last_exec_date TIMESTAMP(3) DEFAULT NULL, detection_limit int default -1, PRIMARY KEY (id_rule) )
[sql] Failed to execute: CREATE TABLE identitystore_quality_suspicious_identity ( id_suspicious_identity int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), customer_id varchar(50) default '' NOT NULL, id_duplicate_rule INT NOT NULL DEFAULT 0, date_create timestamp(3) default CURRENT_TIMESTAMP not null, last_update_date timestamp(3), date_delete timestamp(3), is_deleted smallint default 0, PRIMARY KEY (id_suspicious_identity) )
[sql] Failed to execute: CREATE INDEX identitystore_quality_suspicious_identity_cuid ON identitystore_quality_suspicious_identity (customer_id)
[sql] Failed to execute: ALTER TABLE identitystore_ref_attribute_values ADD CONSTRAINT fk_id_attribute FOREIGN KEY (id_attribute) REFERENCES identitystore_ref_attribute (id_attribute)
[sql] Failed to execute: insert into public.identitystore_identity_search_rule (id_rule, type) VALUES (1, 'OR'), (3, 'AND')
[sql] Failed to execute: INSERT INTO public.identitystore_identity_search_rule_attribute (id_rule, id_attribute) VALUES (1, 16), (1, 12), (3, 3), (3, 4), (3, 5)
[sql] Failed to execute: INSERT INTO public.identitystore_ref_attribute (id_attribute, name, key_name, description, key_type, key_weight, certifiable, pivot, common_search_key, mandatory_for_creation, validation_regex, validation_error_message, validation_error_message_key) VALUES (10, 'Code postal', 'address_postal_code', 'Champ d''adresse : code postal', 0, 0, 1, 0, null , 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (11, 'Ville', 'address_city', 'Champ d''adresse : ville', 0, 0, 1, 0, null , 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (16, 'Login', 'login', 'Login de connexion (email)', 0, '20', 1, 0, 'common_email', 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (31, '(FC) Key', 'fc_key', 'Format FranceConnect - Key', 0, 0, 0, 0, null , 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (8, 'Adresse', 'address', 'Addresse postale', 0, 0, 1, 0, null , 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (9, 'Complément d''adresse', 'address_detail', 'Complément d''adresse', 0, 0, 1, 0, null , 0, '^[A-Za-zÀ-Üà-ü\d\s''-]+$', 'uniquement caractères alphanumériques, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alphanum.apostrophe.space.dash'), (13, 'Téléphone portable', 'mobile_phone', 'Réservé pour l''envoi de SMS', 0, '15', 1, 0, 'common_phone', 0, '^0(6|7)\d{8}$', 'uniquement numérique, numéro français sur 10 chiffres commençant par O6 ou 07.', 'identitystore.attribute.status.validation.error.mobile.phone.format'), (14, 'Téléphone fixe', 'fixed_phone', 'Téléphone fixe', 0, '14', 0, 0, 'common_phone', 0, '^0([1-5]|9)\d{8}$', 'uniquement numérique, numéro français sur 10 chiffres commençant par 01 à 05 ou 09.', 'identitystore.attribute.status.validation.error.fixed.phone.format'), (56, 'Code INSEE commune de naissance', 'birthplace_code', 'Code INSEE de la commune de naissance ou vide pour l''étranger. (Attribut Pivot)', 0, 5, 1, 1, null , 0, '^[A-Z\d]{5}$', 'Alphanumérique sur 5 caractères. Le code doit exister dans notre référentiel géocode', 'identitystore.attribute.status.validation.error.geocodes.format'), (57, 'Code INSEE pays de naissance', 'birthcountry_code', 'Code INSEE du pays de naissance. (Attribut Pivot)', 0, 3, 1, 1, null , 0, '^[A-Z\d]{5}$', 'Alphanumérique sur 5 caractères. Le code doit exister dans notre référentiel géocode', 'identitystore.attribute.status.validation.error.geocodes.format'), (1, 'Genre', 'gender', '0:Non défini /1:Femme / 2:Homme (Attribut Pivot)', 0, 3, 1, 1, null , 0, '^[0-2]{1}$', 'uniquement 0, 1 ou 2', 'identitystore.attribute.status.validation.error.gender.format'), (2, 'Nom d''usage', 'preferred_username', 'Nom d''usage', 0, '15', 0, 0, 'common_lastname', 0, '^[A-Za-zÀ-Üà-ü\s''-]+$', 'Uniquement caractères aplha, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alpha.apostrophe.space.dash'), (4, 'Prénoms de naissance', 'first_name', 'Liste des prénoms de naissance séparés par des espaces. (Attribut Pivot).', 0, 10, 1, 1, null , 1, '^[A-Za-zÀ-Üà-ü\s''-]+$', 'Uniquement caractères aplha, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alpha.apostrophe.space.dash'), (3, 'Nom de naissance', 'family_name', 'Nom de naissance. (Attribut Pivot)', 0, '18', 1, 1, 'common_lastname', 1, '^[A-Za-zÀ-Üà-ü\s''-]+$', 'Uniquement caractères aplha, apostrophe, espace et tirets.', 'identitystore.attribute.status.validation.error.only.alpha.apostrophe.space.dash'), (12, 'Email de contact', 'email', 'Email de contact', 0, '20', 1, 0, 'common_email', 0, '^[\w-;]+@([\w-]+;)+[\w-]{2,4}$', 'format mail du type xxx@yyy.zzz', 'identitystore.attribute.status.validation.error.email.format'), (5, 'Date de naissance', 'birthdate', 'Date de naissance au format JJ/MM/AAAA (Attribut Pivot)', 0, '17', 1, 1, null , 0, '^(?:(?:31(\/)(?:0[13578]|1[02]))\1|(?:(?:29|30)(\/)(?:0[13-9]|1[0-2])\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:29(\/)02\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:0[1-9]|1\d|2[0-8])(\/)(?:(?:0[1-9])|(?:1[0-2]))\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$', 'Date exprimée sur 10 caractères en jj/mm/aaaa.', 'identitystore.attribute.status.validation.error.date.format'), (6, 'Libellé commune de naissance', 'birthplace', 'Libellé de la commune de naissance', 0, 5, 1, 0, null , 0, '^[A-Z\s]+$', 'uniquement caractères aplha en majuscule non accentué, et espace.', 'identitystore.attribute.status.validation.error.only.uppercase.space'), (7, 'Libellé pays de naissance', 'birthcountry', 'Libellé du pays de naissance', 0, 3, 1, 0, null , 0, '^[A-Z\s]+$', 'uniquement caractères aplha en majuscule non accentué, et espace.', 'identitystore.attribute.status.validation.error.only.uppercase.space') 
