merge from trunk

[plcapi.git] / migrations / 009-down-pcu-types.sql

diff --git a/migrations/009-down-pcu-types.sql b/migrations/009-down-pcu-types.sql
new file mode 100644 (file)
index 0000000..1dbe9d2
--- /dev/null
+++ b/migrations/009-down-pcu-types.sql
@@ -0,0 +1,13 @@
+--
+-- 009 revert
+--
+
+DROP VIEW view_pcu_types;
+
+DROP VIEW pcu_type_ports;
+
+DROP TABLE pcu_type_port;
+
+DROP TABLE pcu_types; 
+
+UPDATE plc_db_version SET subversion = 7;