Fixes issue 11743: Changed get_uuid() function to prevent adding a new recipient on every update
authorIván Perdomo <ivan.perdomo@openbravo.com>
Mon, 14 Dec 2009 11:10:21 +0100
changeset 5706 b9b9f4e7a61b
parent 5703 e7ad8a48210d
child 5707 fb1395e81f64
child 5725 846021a22399
Fixes issue 11743: Changed get_uuid() function to prevent adding a new recipient on every update
src-db/database/model/postscript-Oracle.sql
src-db/database/model/postscript-PostgreSql.sql
--- a/src-db/database/model/postscript-Oracle.sql	Mon Dec 14 03:02:56 2009 +0100
+++ b/src-db/database/model/postscript-Oracle.sql	Mon Dec 14 11:10:21 2009 +0100
@@ -813,7 +813,7 @@
     INSERT INTO ad_alertrecipient(ad_client_id, ad_org_id, isactive, created, createdby,
                               updated, updatedby, ad_alertrecipient_id, ad_alertrule_id,
                               ad_role_id, sendemail)
-         VALUES('0', '0', 'Y', now(), '100', now(), '100', get_uuid(), '1005400000', '0', 'N');
+         VALUES('0', '0', 'Y', now(), '100', now(), '100', '8CC1347628D148FABA1FC26622F4B070', '1005400000', '0', 'N');
 EXCEPTION WHEN OTHERS THEN NULL;
 END;
 /-- END
--- a/src-db/database/model/postscript-PostgreSql.sql	Mon Dec 14 03:02:56 2009 +0100
+++ b/src-db/database/model/postscript-PostgreSql.sql	Mon Dec 14 11:10:21 2009 +0100
@@ -590,7 +590,7 @@
   INSERT INTO ad_alertrecipient(ad_client_id, ad_org_id, isactive, created, createdby,
                               updated, updatedby, ad_alertrecipient_id, ad_alertrule_id,
                               ad_role_id, sendemail)
-       VALUES('0', '0', 'Y', now(), '100', now(), '100', get_uuid(), '1005400000', '0', 'N');
+       VALUES('0', '0', 'Y', now(), '100', now(), '100', '8CC1347628D148FABA1FC26622F4B070', '1005400000', '0', 'N');
 EXCEPTION
 WHEN OTHERS THEN
 --do nothing