3 -- this down script is provided for convenience only
4 -- DO NOT USE on an operational site
5 -- the change in migration 003 involves creating
6 -- the new view view_nodenetworks for fetching instances
8 -- AND to alter NodeNetworks.py accordingly
9 -- so this change cannot be easily undone
10 -- unless you also revert the API itself
12 DROP VIEW view_nodenetworks;
14 DROP VIEW view_nodenetwork_settings;
16 DROP VIEW nodenetwork_settings;
18 DROP TABLE nodenetwork_setting;
20 DROP TABLE nodenetwork_setting_types;
23 UPDATE plc_db_version SET subversion = 2;
24 SELECT subversion from plc_db_version;