-- Mise à jour n° de version
UPDATE `system` SET `value`='v7.1.1' WHERE `name`='base' and `groupe`='module';

-- data_cat
INSERT IGNORE INTO `data_cat` (`groupe`, `name`, `label`, `description`, `type`, `fromID`, `creationDate`) VALUES
('admin', 'clicRDV', 'clicRDV', 'Paramètres pour clicRDV', 'base', '1', '2019-01-01 00:00:00')
ON DUPLICATE KEY UPDATE groupe=values(groupe), name=values(name), label=values(label), description=values(description), type=values(type), fromID=values(fromID), creationDate=values(creationDate);

-- data_types
SET @catID = (SELECT data_cat.id FROM data_cat WHERE data_cat.name='clicRDV');

