[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) NULL UNIQUE, date_create timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, is_deleted SMALLINT default 0, date_delete timestamp NULL , PRIMARY KEY (id_identity), INDEX (connection_id), INDEX (customer_id) )
[sql] Failed to execute: CREATE TABLE identitystore_attribute ( id_attribute int(6) NOT NULL, name varchar(100) NOT NULL default '' UNIQUE, key_name varchar(100) NOT NULL default '' UNIQUE, description LONGVARCHAR NULL, key_type int(11) NOT NULL default '0', PRIMARY KEY (id_attribute) )
[sql] Failed to execute: CREATE TABLE identitystore_identity_attribute ( id_identity int(11) NOT NULL default '0', id_attribute int(11) NOT NULL default '0', attribute_value LONGVARCHAR NULL, id_certification int(11) NOT NULL default '0', id_file int(11) default '0', lastupdate_date timestamp NOT NULL default CURRENT_TIMESTAMP, lastupdate_application VARCHAR(100) NULL, PRIMARY KEY ( id_identity , id_attribute ) )
[sql] Failed to execute: CREATE TABLE identitystore_attribute_certificate ( id_attribute_certificate int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), certifier_code varchar(255) NOT NULL default '', certificate_date timestamp NOT NULL, certificate_level int(11) NOT NULL default '0', expiration_date timestamp NULL default NULL, PRIMARY KEY (id_attribute_certificate) )
[sql] Failed to execute: CREATE TABLE identitystore_client_application_certifiers ( id_client_app int(6) NOT NULL, certifier_code varchar(255) NOT NULL default '', PRIMARY KEY (id_client_app, certifier_code), INDEX (id_client_app) )
[sql] Failed to execute: CREATE TABLE identitystore_client_application ( id_client_app int(6) NOT NULL, name varchar(100) NOT NULL UNIQUE, code varchar(100) NOT NULL UNIQUE, is_application_authorized_to_delete_value INT(1) NOT NULL DEFAULT 0, is_application_authorized_to_delete_certificate INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id_client_app) )
[sql] Failed to execute: CREATE TABLE identitystore_attribute_right ( id_client_app int(6) NOT NULL, id_attribute int(6) NOT NULL, readable int(1) NOT NULL default '0', writable int(1) NOT NULL default '0', certifiable int(1) NOT NULL default '0', searchable int(1) NOT NULL default '0', mandatory int(1) NOT NULL default '0', PRIMARY KEY (id_client_app, id_attribute) )
[sql] Failed to execute: CREATE TABLE identitystore_history_identity_attribute ( id_history int GENERATED BY DEFAULT AS IDENTITY(START WITH 1), change_type int(3) NOT NULL, id_identity int(11) NOT NULL, identity_connection_id varchar(100), attribute_key varchar(50) NOT NULL, attribute_new_value varchar(255) NOT NULL default '', attribute_old_value varchar(255) NOT NULL default '', author_id varchar(255) default '', author_type int(2) NOT NULL, author_application varchar(255) default '', certifier_name varchar(255) default '', modification_date timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY ( id_history ) )
[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_attribute ( id_attribute )
[sql] Failed to execute: ALTER TABLE identitystore_identity_attribute ADD INDEX ix_attribute_value USING BTREE (attribute_value(50) ASC)
[sql] Failed to execute: ALTER TABLE identitystore_attribute_right ADD CONSTRAINT fk_attribute_right_id_client_app FOREIGN KEY ( id_client_app ) REFERENCES identitystore_client_application ( id_client_app )
[sql] Failed to execute: ALTER TABLE identitystore_attribute_right ADD CONSTRAINT fk_attribute_right_id_attribute FOREIGN KEY ( id_attribute ) REFERENCES identitystore_attribute ( id_attribute )
[sql] Failed to execute: ALTER TABLE identitystore_history_identity_attribute ADD CONSTRAINT fk_history_identity_attribute_id_identity FOREIGN KEY ( id_identity ) REFERENCES identitystore_identity ( id_identity )
[sql] Failed to execute: DELETE FROM identitystore_attribute_certificate
[sql] Failed to execute: DELETE FROM identitystore_identity_attribute
[sql] Failed to execute: DELETE FROM identitystore_attribute_right
[sql] Failed to execute: DELETE FROM identitystore_client_application
[sql] Failed to execute: DELETE FROM identitystore_attribute
[sql] Failed to execute: DELETE FROM identitystore_identity
[sql] Failed to execute: INSERT INTO identitystore_attribute (id_attribute, key_name, name, description, key_type) VALUES (1, 'gender', 'Genre', '0:Non défini / 1:Homme / 2:Femme', 0), (2, 'email', 'Email', '', 0), (3, 'birthdate', 'Date de naissance', 'au format DD/MM/YYYY', 0), (4, 'birthplace', 'Lieu de naissance', '', 0), (5, 'mobile_phone', 'Téléphone portable', 'Réservé pour l''envoi de SMS', 0), (6, 'fixed_phone', 'Téléphone fixe', '',0), (7, 'phone', 'Téléphone fixe ou mobile', '', 0), (8, 'preferred_username', 'Nom usuel','', 0), (9, 'address', 'Adresse postale', '', 0), (10, 'first_name', 'Prénom', 'Prénom usuel', 0), (11, 'family_name', 'Nom de famille de naissance', '', 0), (12, 'address_number','Numéro de rue','Champ d''adresse : numéro de rue ',0), (13, 'address_suffix','Suffixe','Champ d''adresse : suffixe de numéro (bis,ter...)',0), (14, 'address_street','Rue','Champ d''adresse : rue, avenue...',0), (15, 'address_building','Immeuble','Champ d''adresse : immeuble, résidence...',0), (16, 'address_stair','Etage','Champ d''adresse : Etage, Numéro d appartement',0), (17, 'address_postal_code','Code postal','Champ d''adresse : code postal',0), (18, 'address_city','Ville','Champ d''adresse : ville',0), (19, 'birthcountry','Pays de naissance','',0), (30, 'fc_given_name' , '(FC) Prénoms' , 'Format Pivot FranceConnect - Liste des prénoms', 0 ), (31, 'fc_family_name' , '(FC) Nom de naissance' , 'Format Pivot FranceConnect', 0 ), (32, 'fc_birthdate' , '(FC) Date de naissance' , 'Format Pivot FranceConnect - format YYYY-MM-DD', 0 ), (33, 'fc_gender' , '(FC) Genre' , 'Format Pivot FranceConnect - male / female', 0 ), (34, 'fc_birthplace' , '(FC) Lieu de naissance' , 'Format Pivot FranceConnect - Code INSEE du lieu de naissance (ou une chaîne vide si la personne est née à l''étranger)', 0 ), (35, 'fc_birthcountry' , '(FC) Pays de naissance' , 'Format Pivot FranceConnect - Code INSEE du pays de naissance' , 0 )
[sql] Failed to execute: INSERT INTO identitystore_identity (id_identity, connection_id, customer_id, is_deleted, date_delete ) VALUES (1, 'azerty', '3F2504E0-4F89-11D3-9A0C-0305E82C3301', 0, now( ) )
[sql] Failed to execute: INSERT INTO identitystore_identity_attribute(id_identity,id_attribute,attribute_value,id_certification) VALUES (1, 1, 'M', 0), (1, 2, 'john.doe@gmail.com', 0), (1, 3, '11/10/1970', 0), (1, 4, 'Paris', 0), (1, 5, '0623457896', 0), (1, 6, '0123457896', 0), (1, 7, '0123457896', 0), (1, 8, 'Joe', 0), (1, 9, 'Rue de Rennes', 0), (1, 10, 'John', 0), (1, 11, 'Doe', 0), (1, 12, '8', 0), (1, 13, 'Bis', 0), (1, 14, 'Rue de Rennes', 0), (1, 15, 'Escalier B', 0), (1, 16, 'Etage 4', 0), (1, 17, '75018', 0), (1, 18, 'Paris', 0)
[sql] Failed to execute: INSERT INTO identitystore_client_application (id_client_app, name, code) VALUES (1, 'My Application', 'MyApplication')
[sql] Failed to execute: INSERT INTO identitystore_attribute_right (id_client_app, id_attribute, readable, writable, certifiable) VALUES (1, 1, 1, 1, 0), (1, 2, 1, 1, 0), (1, 3, 1, 1, 0), (1, 4, 1, 1, 0), (1, 5, 1, 1, 0), (1, 6, 1, 1, 0), (1, 7, 1, 1, 0), (1, 8, 1, 1, 0), (1, 9, 1, 1, 0), (1, 10, 1, 1, 0), (1, 11, 1, 1, 0), (1, 12, 1, 1, 0), (1, 13, 1, 1, 0), (1, 14, 1, 1, 0), (1, 15, 1, 1, 0), (1, 16, 1, 1, 0), (1, 17, 1, 1, 0), (1, 18, 1, 1, 0) 
