[Noalyss-commit] [noalyss] 12/17: correct patch

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit fe05527c9d615694b115383ccef5b89a6d6e14db
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Sun Oct 30 18:36:14 2022 +0100

    correct patch
---
 include/sql/patch/upgrade177.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/include/sql/patch/upgrade177.sql b/include/sql/patch/upgrade177.sql
index 7c77c5a9c..acb1c8667 100644
--- a/include/sql/patch/upgrade177.sql
+++ b/include/sql/patch/upgrade177.sql
@@ -15,6 +15,8 @@ select f_id,
        cd.fd_id as card_category
 from contact_data cd   ;
 
+insert into fiche_def_ref(frd_id,frd_text) values(16,'Contact') on conflict  
do nothing;
+
 insert into attr_min values (16,32);
 
 insert into jnt_fic_attr (fd_id,jnt_order,ad_id) select fd_id,10,32 from 
fiche_def where frd_id=16 on conflict(fd_id,ad_id) do nothing;