USE Cadelio
GO
INSERT INTO Logs(Log_ID, Log_MethodName, Log_Type, Log_Message, Log_Details, Log_Date, Log_SupportType) VALUES (NEWID(), 'UpdateCadelio', 'Update', 'Sql script executed', 'Execution of sql script is successull.', GETDATE(), 'PC') 
GO


--Dans cette version, genuvarum plus et genuvalgum plus sont rajouté dans la partie Examen de face et dos.
IF (SELECT COUNT(*) FROM CustomCaption WHERE Capt_Family = 'labels' AND Capt_Code = 'lbl_Genuvarrum_Plus') = 0
BEGIN
INSERT INTO CustomCaption (Capt_Family, Capt_Code, Capt_FR, Capt_EN) VALUES ('labels', 'lbl_Genuvarrum_Plus', 'Génuvarum plus', 'Genuvarum plus')
END
GO
IF (SELECT COUNT(*) FROM CustomCaption WHERE Capt_Family = 'labels' AND Capt_Code = 'lbl_Genuvalgum_Plus') = 0
BEGIN
INSERT INTO CustomCaption (Capt_Family, Capt_Code, Capt_FR, Capt_EN) VALUES ('labels', 'lbl_Genuvalgum_Plus', 'Génuvalgum plus', 'Genuvalgum plus')
END

GO