Changeset 1344 for trunk

Timestamp:

05/29/15 17:30:50 (9 years ago)

Author:

nanardon

Message:

Add trigger to update global db rev on services

File:

• trunk/LATMOS-Accounts/bin/la-sql-upgrade.in (modified) (1 diff)

trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

@@ -502 +502 @@
               EXECUTE PROCEDURE service_sort_fields();
 
+            },
+            q{
+            CREATE TRIGGER service_rev_tg
+            BEFORE INSERT OR UPDATE OR DELETE
+            ON service
+            FOR EACH ROW
+            EXECUTE PROCEDURE rev_tg_f();
             },
         ],