Changeset 865

Timestamp:

12/19/11 15:13:52 (13 years ago)

Author:

nanardon

Message:

• add if exists to migration scripts

File:

• LATMOS-Accounts/sqldata/up_to_3.sql (modified) (1 diff)

LATMOS-Accounts/sqldata/up_to_3.sql

@@ -1 +1 @@
 begin;
     ALTER TABLE nethost_attributes_ips DROP CONSTRAINT nethost_is_single_ip;
-    DROP TRIGGER check_zone_name_unity_tg ON nethost;
-    DROP TRIGGER check_zone_name_unity_tg ON netzone;
-    DROP FUNCTION check_zone_name_unity();
-rollback;
+    DROP TRIGGER IF EXISTS check_zone_name_unity_tg ON nethost;
+    DROP TRIGGER IF EXISTS check_zone_name_unity_tg ON netzone;
+    DROP FUNCTION IF EXISTS check_zone_name_unity();
+commit;