INSERT INTO TIMS.REPORT (TRANSLATION_ID,CUSTOMIZED_NAME,FILE_NAME,MINIMUM_VERSION,CLASS,TYPE) VALUES ("offChallenge", "récapitulatif des infractions", "template.jrxml", 2, "transport.report.DynamicOffenceChallenge", 2);
INSERT INTO TIMS.DROIT_RAPPORT (CLE_PROFIL,CLE_RAPPORT,ENABLE) select CLE_PROFIL, ID, 0 from TIMS.T_PROFIL, TIMS.REPORT where  TRANSLATION_ID="offChallenge";
UPDATE TIMS.DROIT_RAPPORT SET ENABLE = 1 WHERE CLE_PROFIL = 1;

INSERT INTO TIMS.T_FICHE (`NOM_FICHE`,`DESCRIPTION_FICHE`,`DROIT_DEFAUT`) VALUES ('POSITION','Accès à la partie géolocalisation','0000');
INSERT INTO TIMS.T_DROIT (`CLE_PROFIL`,`CLE_FICHE`,`ECRITURE`,`MODIFICATION`,`SUPPRESSION`,`CONSULTATION`) (select CLE_PROFIL, CLE_FICHE, 1,1,1,1 from `tims`.`t_profil`, `tims`.`t_fiche` where nom_fiche = "POSITION");

ALTER TABLE TIMS.T_UTILISATEUR ADD COLUMN USER_FUNCTION VARCHAR(32) DEFAULT NULL;

UPDATE TIMS.REPORT SET MINIMUM_VERSION="3" WHERE TRANSLATION_ID="payExport";
UPDATE TIMS.REPORT SET MINIMUM_VERSION="2" WHERE TRANSLATION_ID="dayPrint";
UPDATE TIMS.REPORT SET MINIMUM_VERSION="2" WHERE TRANSLATION_ID="hardnessCounter";

UPDATE TIMS.CONFIGURATION SET EVAL = "4.3.0" WHERE VALUE = "database_version";