UPDATE scolarite s SET s.LIB_SECTION = '' WHERE s.LIB_SECTION IS NULL;
UPDATE scolarite s SET s.CYCLE = '' WHERE s.CYCLE IS NULL;
UPDATE scolarite s SET s.ANNEE = '' WHERE s.ANNEE IS NULL;
INSERT INTO droit (`COD_DRO`, `LIB_DRO`) VALUES ('DA_STA_++', 'Gestion des statistiques ++');
-- Nouvelle interdiction : Actions sur dossier étudiants
INSERT INTO droit (COD_DRO, LIB_DRO) VALUES ('DR_ITD_CSL', "Interdiction ouverture dossier médical");
-- Nouveau droit : Listing des alertes
INSERT INTO droit (COD_DRO, LIB_DRO) VALUES ('DL_VAL', "Listing des alertes");
-- Nouveau témoin : envoi mail intervenant lors prise rdv
ALTER TABLE motifcreneau ADD COLUMN NOTIF_USER TINYINT(4) NOT NULL AFTER TEM_AVC_RDV;
ALTER TABLE parametre_calendar ADD COLUMN OBJET_MAIL_RDV_USER VARCHAR(50) NULL DEFAULT 'Rendez-vous pris' COLLATE 'latin1_swedish_ci' AFTER MAIL_RDV, ADD COLUMN MAIL_RDV_USER LONGTEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER OBJET_MAIL_RDV_USER;
UPDATE parametre_calendar SET MAIL_RDV_USER='Bonjour, \r\n\r\nL\'étudiant(e) <CIVILITE><ETUDIANT> a pris un rendez-vous sur votre créneau horaire, le <DATE_HEURE_RDV> au centre <CENTRE>.\r\n';
-- Parametre pour les mails de relances
CREATE TABLE parametre_relance ( ID_PARAM INT(5) NOT NULL AUTO_INCREMENT, MAIL_AUTO TINYINT(4) NOT NULL DEFAULT '0', MAIL_MANUEL TINYINT(4) NOT NULL DEFAULT '0', EXPEDITEUR_MAIL VARCHAR(50) NOT NULL DEFAULT 'Service de santé' COLLATE 'latin1_swedish_ci', PRIMARY KEY (ID_PARAM) USING BTREE ) COMMENT='Parametres concernant les relances (mail, ...)' COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=2 ;
ALTER TABLE parametre_relance ADD COLUMN CONTENU_MAIL VARCHAR(10000) NOT NULL DEFAULT 'Bonjour,</br>Suite à l\'examen de votre dossier, nous vous rappelons que nous attendons de votre part :</br><b>${but}</b></br></br>Nous vous remercions de bien vouloir, selon le cas :</br> - soit passer au service</br> - soit nous faire parvenir les pièces manquantes.</br></br><b>${complement}</b></br></br>Cordialement,</br>' AFTER EXPEDITEUR_MAIL;
INSERT INTO parametre_relance (ID_PARAM) VALUES ('1');
ALTER TABLE relance ADD COLUMN NB_MAIL INT(11) NULL DEFAULT 0 AFTER NB_EDITION;
-- Parametre taille signature
ALTER TABLE utilisateur ADD COLUMN TAILLE_SIGNATURE VARCHAR(5) NULL DEFAULT 'S' AFTER CLE_SCAN;
-- Parametre mail convoc
UPDATE parametre_convoc p SET p.TEXT_MAIL_CLAT = REPLACE(p.TEXT_MAIL_CLAT, '<', '[');
UPDATE parametre_convoc p SET p.TEXT_MAIL_CLAT = REPLACE(p.TEXT_MAIL_CLAT, '>', ']');
UPDATE parametre_convoc p SET p.TEXT_MAIL = REPLACE(p.TEXT_MAIL, '<', '[');
UPDATE parametre_convoc p SET p.TEXT_MAIL = REPLACE(p.TEXT_MAIL, '>', ']');
UPDATE parametre_convoc p SET p.TEXT_MAIL_CANCEL = REPLACE(p.TEXT_MAIL_CANCEL, '<', '[');
UPDATE parametre_convoc p SET p.TEXT_MAIL_CANCEL = REPLACE(p.TEXT_MAIL_CANCEL, '>', ']');
UPDATE parametre_convoc p SET p.TEXT_MAIL_EDIT = REPLACE(p.TEXT_MAIL_EDIT, '<', '[');
UPDATE parametre_convoc p SET p.TEXT_MAIL_EDIT = REPLACE(p.TEXT_MAIL_EDIT, '>', ']');
--
ALTER TABLE modeleordonnance DROP INDEX fk_Modeleordonnance_COD_MOD_idx;
-- Liaison entre import et modele importation
ALTER TABLE importidentite ADD DAA_ETB TINYINT( 1 ) NULL DEFAULT NULL;
ALTER TABLE importidentite ADD DAA_ENS_SUP TINYINT( 1 ) NULL DEFAULT NULL;
ALTER TABLE importidentite ADD IDENTIFIANT TINYINT( 1 ) NULL DEFAULT NULL;
UPDATE importidentite SET DAA_ETB = 1;
UPDATE importidentite SET DAA_ENS_SUP = 1;
UPDATE importidentite SET IDENTIFIANT = 1;
-- correctif importidentité
UPDATE importidentite SET COD_INE='0' WHERE COD_INE IS NULL;
UPDATE importidentite SET COD_ETU='0' WHERE COD_ETU IS NULL;
-- mise a jour nomenclature interne
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '11', 'Agriculteur sur petite exploitation', NULL, 210, NULL, 1, NULL, NULL, '2020-12-14 14:03:44', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '12', 'Agriculteur sur moyenne exploitation', NULL, 200, NULL, 1, NULL, NULL, '2020-12-14 14:03:02', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '13', 'Agriculteur sur grande exploitation', NULL, 220, NULL, 1, NULL, NULL, '2020-12-14 14:04:05', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '62', 'Ouvriers qualifiés de type industrie', NULL, 140, NULL, 1, NULL, NULL, '2020-12-14 13:55:42', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '63', 'Ouvriers qualifiés de type artisanat', NULL, 180, NULL, 1, NULL, NULL, '2020-12-14 14:00:51', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '64', 'Chauffeurs', NULL, 150, NULL, 1, NULL, NULL, '2020-12-14 13:56:18', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '65', 'Ouvriers qualifiés manutent. magasiniers', NULL, 160, NULL, 1, NULL, NULL, '2020-12-14 13:59:13', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '67', 'Ouvriers non qualifiés de type industrie', NULL, 190, NULL, 1, NULL, NULL, '2020-12-14 14:01:33', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '68', 'Ouvriers non qualifiés de type artisanat', NULL, 230, NULL, 1, NULL, NULL, '2020-12-14 13:51:40', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '74', 'Retraité cadre', NULL, 100, NULL, 1, NULL, NULL, '2020-12-14 13:51:40', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '75', 'Retraité profession intermédiaire', NULL, 130, NULL, 1, NULL, NULL, '2020-12-14 13:54:13', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '77', 'Retraité employé', NULL, 110, NULL, 1, NULL, NULL, '2020-12-14 13:52:50', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '78', 'Retraité ouvrier', NULL, 120, NULL, 1, NULL, NULL, '2020-12-14 13:53:23', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '84', 'Elève / Etudiant', NULL, 250, NULL, 1, NULL, NULL, '2020-12-14 13:51:40', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '85', 'Sans profession - de 60 ans (hors retraite)', NULL, 170, NULL, 1, NULL, NULL, '2020-12-14 14:00:08', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='PRF'), '86', 'Sans profession + de 60 ans (hors retraite)', NULL, 240, NULL, 1, NULL, NULL, '2020-12-14 13:51:40', NULL);
--
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='BAC'), 'STHR', 'ST de l Hôtellerie et restauration', 'ST Hôt.Res', 100, NULL, 1, NULL, NULL, '2020-12-14 00:00:00', NULL);
INSERT INTO `itemnomenclature` VALUES(NULL, (SELECT ID_NMC FROM nomenclature WHERE COD_NMC='BAC'), '0038', '0038-brevet des métiers d art', '0038-bma', 110, NULL, 1, NULL, NULL, '2020-12-14 00:00:00', NULL);