X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=trunk%2Fmigrations%2F003-down-network-settings.sql;fp=trunk%2Fmigrations%2F003-down-network-settings.sql;h=796e4b4cc81cb3bb679c7722ed3e34876d51929b;hb=5a4c1b1278ffa01e630fde47f7c54888ed20a576;hp=0000000000000000000000000000000000000000;hpb=cee5ab52df1c9f38b6eaff2dd354cb22f59028c7;p=plcapi.git

diff --git a/trunk/migrations/003-down-network-settings.sql b/trunk/migrations/003-down-network-settings.sql
new file mode 100644
index 0000000..796e4b4
--- /dev/null
+++ b/trunk/migrations/003-down-network-settings.sql
@@ -0,0 +1,24 @@
+-- IMPORTANT NOTICE
+--
+-- this down script is provided for convenience only
+-- DO NOT USE on an operational site
+-- the change in migration 003 involves creating 
+-- the new view view_nodenetworks for fetching instances
+-- of NodeNetworks
+-- AND to alter NodeNetworks.py accordingly
+-- so this change cannot be easily undone 
+-- unless you also revert the API itself
+
+DROP VIEW view_nodenetworks;
+
+DROP VIEW view_nodenetwork_settings;
+
+DROP VIEW nodenetwork_settings;
+
+DROP TABLE nodenetwork_setting;
+
+DROP TABLE nodenetwork_setting_types;
+
+-- deflate subversion
+UPDATE plc_db_version SET subversion = 2;
+SELECT subversion from plc_db_version;