-- 2.3.0 to 3.0.0 ALTER TABLE `actes_cat` CHANGE `type` `module` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'base'; ALTER TABLE `actes_cat` ADD UNIQUE(`name`); ALTER TABLE `data_types` CHANGE `type` `module` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'base'; UPDATE `data_types` SET `name` = 'firstname' WHERE `data_types`.`id` = 3; INSERT IGNORE INTO `data_types` (`groupe`, `name`, `placeholder`, `label`, `description`, `validationRules`, `validationErrorMsg`, `formType`, `formValues`, `module`, `cat`, `fromID`, `creationDate`, `durationLife`, `displayOrder`) VALUES ('user', 'administratifPeutAvoirAgenda', '', 'administratifPeutAvoirAgenda', 'permet à l\'utilisateur sélectionné d\'avoir son agenda', '', '', 'checkbox', 'false', 'base', 64, 1, '2018-01-01 00:00:00', 3600, 1), ('user', 'clicRdvUserId', 'identifiant', 'identifiant', 'email@address.com', '', '', 'text', '', 'base', 66, 1, '2018-01-01 00:00:00', 3600, 1), ('user', 'clicRdvPassword', 'Mot de passe', 'Mot de passe', 'Mot de passe (chiffré)', '', '', 'password', '', 'base', 66, 1, '2018-01-01 00:00:00', 3600, 2), ('user', 'clicRdvGroupId', 'Groupe', 'Groupe', 'Groupe Sélectionné', '', '', 'select', '', 'base', 66, 1, '2018-01-01 00:00:00', 3600, 3), ('user', 'clicRdvCalId', 'Agenda', 'Agenda', 'Agenda sélectionné', '', '', 'select', '', 'base', 66, 1, '2018-01-01 00:00:00', 3600, 4), ('user', 'clicRdvConsultId', 'Consultations', 'Consultations', 'Correspondance entre consultations', '', '', 'select', '', 'base', 66, 1, '2018-01-01 00:00:00', 3600, 5), ('admin', 'clicRdvPatientId', 'ID patient', 'ID patient', 'ID patient', '', '', 'text', '', 'base', 26, 1, '2018-01-01 00:00:00', 3600, 1), ('relation', 'relationExternePatient', '', 'Relation externe patient', 'relation externe patient', '', '', 'number', '', 'base', 63, 1, '2018-01-01 00:00:00', 1576800000, 1); ALTER TABLE `people` ADD `module` varchar(20) DEFAULT NULL after `rank`; INSERT INTO `form_basic_types` (`id`, `name`, `placeholder`, `label`, `description`, `validationRules`, `validationErrorMsg`, `formType`, `formValues`, `type`, `cat`, `fromID`, `creationDate`, `deleteByID`, `deleteDate`) VALUES (5, 'verifPassword', 'confirmation du mot de passe', 'Confirmation du mot de passe', 'Confirmation du mot de passe utilisateur', 'required', 'La confirmation du mot de passe est manquante', 'password', '', 'base', 0, 0, '2018-01-01 00:00:00', 0, '2018-01-01 00:00:00'), (6, 'currentPassword', 'Mot de passe actuel', 'Mot de passe actuel', 'Mot de passe actuel de l\'utilisateur', 'required', 'Le mot de passe actuel est manquant', 'password', '', 'base', 0, 1, '2018-01-01 00:00:00', 0, '2018-01-01 00:00:00'); ALTER TABLE `forms` ADD `module` VARCHAR(20) NOT NULL DEFAULT 'base' AFTER `id`; INSERT INTO `forms` (`module`, `internalName`, `name`, `description`, `dataset`, `groupe`, `formMethod`, `formAction`, `cat`, `type`, `yamlStructure`, `yamlStructureDefaut`, `printModel`) VALUES ('base', 'firstLogin', 'Premier utilisateur', 'Création premier utilisateur', 'form_basic_types', 'admin', 'post', '/login/logInFirstDo/', 5, 'public', 'structure:\r\n row1:\r\n col1: \r\n head: "Mot de passe de l\'utilisateur 1"\r\n size: 3\r\n bloc:\r\n - userid,readonly #1 Identifiant\n - moduleSelect #7 Module\n - password,required #2 Mot de passe\n - verifPassword,required #5 Confirmation du mot de passe\n - submit #3 Valider', 'structure:\r\n row1:\r\n col1: \r\n head: "Mot de passe de l\'utilisateur 1"\r\n size: 3\r\n bloc:\r\n - userid,readonly #1 Identifiant\n - moduleSelect #7 Module\n - password,required #2 Mot de passe\n - verifPassword,required #5 Confirmation du mot de passe\n - submit #3 Valider', ''), ('base', 'baseUserParametersClicRdv', 'Paramètres utilisateur clicRDV', 'Paramètres utilisateur clicRDV', 'data_types', 'admin', 'post', '/user/actions/userParametersClicRdv/', 5, 'public', 'global:\n structure:\n row1:\n col1: \n head: "Compte clicRDV"\n size: 3\n bloc:\n - clicRdvUserId\n - clicRdvPassword\n - clicRdvGroupId\n - clicRdvCalId\n - clicRdvConsultId,nolabel', 'global:\n structure:\n row1:\n col1: \n head: "Compte clicRDV"\n size: 3\n bloc:\n - clicRdvUserId\n - clicRdvPassword\n - clicRdvGroupId\n - clicRdvCalId\n - clicRdvConsultId,nolabel', NULL), ('base', 'baseUserParametersPassword', 'Paramètres utilisateur MedShakeEHR', 'Paramètres utilisateur MedShakeEHR', 'form_basic_types', 'admin', 'post', '/user/actions/userParametersPassword/', 5, 'public', 'structure:\r\n row1:\r\n col1: \r\n head: "Paramètres MedShakeEHR"\r\n size: 3\r\n bloc:\r\n - currentPassword,required #6 Mot de passe actuel\n\n - password,required #2 Mot de passe\n - verifPassword,required #5 Confirmation du mot de passe', 'structure:\r\n row1:\r\n col1: \r\n head: "Paramètres MedShakeEHR"\r\n size: 3\r\n bloc:\r\n - currentPassword,required #6 Mot de passe actuel\n\n - password,required #2 Mot de passe\n - verifPassword,required #5 Confirmation du mot de passe', NULL); update `forms` set yamlStructure = 'col1:\r\n head: "Nom de naissance"\r\n bloc:\r\n - birthname,text-uppercase,gras #1 Nom de naissance\ncol2:\r\n head: "Nom d\'usage"\r\n bloc:\r\n - lastname,text-uppercase,gras #2 Nom d usage\n\r\ncol3:\r\n head: "Prénom"\r\n bloc:\r\n - firstname,text-capitalize,gras #3 Prénom\ncol4:\r\n head: "Date de naissance" \r\n bloc: \r\n - birthdate #8 Date de naissance\ncol5:\r\n head: "Tel" \r\n blocseparator: " - "\r\n bloc: \r\n - mobilePhone #7 Téléphone mobile\n - homePhone #10 Téléphone domicile\ncol6:\r\n head: "Email"\r\n bloc:\r\n - personalEmail #4 Email personnelle\ncol7:\r\n head: "Ville"\r\n bloc:\r\n - city,text-uppercase #12 Ville' where internalName='baseListingPatients'; update `forms` set yamlStructure = 'col1:\r\n head: "Identité"\r\n blocseparator: " "\r\n bloc:\r\n - titre,gras #51 Titre\n - lastname,text-uppercase,gras #2 Nom d usage\n - birthname,text-uppercase,gras #1 Nom de naissance\n - firstname,text-capitalize,gras #3 Prénom\ncol2:\r\n head: "Activité pro" \r\n bloc: \r\n - job #19 Activité professionnelle\ncol3:\r\n head: "Tel" \r\n bloc: \r\n - telPro #57 Téléphone professionnel\ncol4:\r\n head: "Fax" \r\n bloc: \r\n - faxPro #58 Fax professionnel\ncol5:\r\n head: "Email"\r\n bloc-separator: " - "\r\n bloc:\r\n - emailApicrypt #59 Email apicrypt\n - personalEmail #4 Email personnelle\ncol6:\r\n head: "Ville"\r\n bloc:\r\n - villeAdressePro,text-uppercase #56 Ville' where internalName='baseListingPro'; update `forms` set yamlStructure = 'global:\r\n noFormTags: true\r\nstructure:\r\n row1: \r\n col1: \r\n size: 6\r\n bloc: \r\n - birthname,readonly #1 Nom de naissance\n col2: \r\n size: 6\r\n bloc: \r\n - firstname,readonly #3 Prénom\n row2:\r\n col1: \r\n size: 6\r\n bloc: \r\n - lastname,readonly #2 Nom d usage\n col2: \r\n size: 6\r\n bloc: \r\n - birthdate,readonly #8 Date de naissance\n row3:\r\n col1: \r\n size: 12\r\n bloc: \r\n - personalEmail #4 Email personnelle\n\r\n row4: \r\n col1: \r\n size: 6\r\n bloc: \r\n - mobilePhone #7 Téléphone mobile\n col2: \r\n size: 6\r\n bloc: \r\n - homePhone #10 Téléphone domicile' where internalName='baseAgendaPriseRDV'; update `forms` set yamlStructure = 'structure:\r\n row1: \r\n col1: \r\n head: \'Etat civil\' \r\n size: 4\r\n bloc: \r\n - administrativeGenderCode #14 Sexe\n - birthname,required,autocomplete,data-acTypeID=2:1 #1 Nom de naissance\n - lastname,autocomplete,data-acTypeID=2:1 #2 Nom d usage\n - firstname,required,autocomplete,data-acTypeID=3:22:230:235:241 #3 Prénom\n - birthdate #8 Date de naissance\n col2:\r\n head: \'Contact\'\r\n size: 4\r\n bloc:\r\n - personalEmail #4 Email personnelle\n - mobilePhone #7 Téléphone mobile\n - homePhone #10 Téléphone domicile\n col3:\r\n head: \'Adresse personnelle\'\r\n size: 4\r\n bloc: \r\n - streetNumber #9 Numéro\n - street,autocomplete,data-acTypeID=11:55 #11 Rue\n - postalCodePerso #13 Code postal\n - city,autocomplete,data-acTypeID=12:56 #12 Ville\n row2:\r\n col1:\r\n size: 12\r\n bloc:\r\n - notes,rows=5 #21 Notes' where internalName='baseNewPatient'; update `forms` set yamlStructure = 'structure:\r\n row1: \r\n col1: \r\n head: \'Etat civil\' \r\n size: 4\r\n bloc: \r\n - administrativeGenderCode #14 Sexe\n - job,autocomplete #19 Activité professionnelle\n - titre,autocomplete #51 Titre\n - birthname,autocomplete,data-acTypeID=3:22:230:235:241 #1 Nom de naissance\n - lastname,autocomplete,data-acTypeID=2:1 #2 Nom d usage\n - firstname,autocomplete,data-acTypeID=3:22:230:235:241 #3 Prénom\n\r\n col2:\r\n head: \'Contact\'\r\n size: 4\r\n bloc:\r\n - emailApicrypt #59 Email apicrypt\n - profesionnalEmail #5 Email professionnelle\n - personalEmail #4 Email personnelle\n - telPro #57 Téléphone professionnel\n - telPro2 #248 Téléphone professionnel 2\n - mobilePhonePro #247 Téléphone mobile pro.\n - faxPro #58 Fax professionnel\n col3:\r\n head: \'Adresse professionnelle\'\r\n size: 4\r\n bloc: \r\n - numAdressePro #54 Numéro\n - rueAdressePro,autocomplete,data-acTypeID=11:55 #55 Rue\n - codePostalPro #53 Code postal\n - villeAdressePro,autocomplete,data-acTypeID=12:56 #56 Ville\n - serviceAdressePro,autocomplete #249 Service\n - etablissementAdressePro,autocomplete #250 Établissement\n row2:\r\n col1:\r\n size: 12\r\n bloc:\r\n - notesPro,rows=5 #443 Notes pros\n\r\n row3:\r\n col1:\r\n size: 4\r\n bloc:\r\n - rpps #103 RPPS\n col2:\r\n size: 4\r\n bloc:\r\n - adeli #104 Adeli\n col3:\r\n size: 4\r\n bloc:\r\n - nReseau #477 Numéro de réseau' where internalName='baseNewPro'; CREATE TABLE `system` ( `id` smallint(4) UNSIGNED NOT NULL, `module` varchar(20) DEFAULT 'base', `version` varchar(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ALTER TABLE `system` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `module` (`module`); ALTER TABLE `system` MODIFY `id` smallint(4) UNSIGNED NOT NULL AUTO_INCREMENT; INSERT INTO `system` (`id`,`module`,`version`) VALUES (1, 'base', 'v3.0.0');