X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;ds=sidebyside;f=trunk%2Fmigrations%2F009-down-pcu-types.sql;fp=trunk%2Fmigrations%2F009-down-pcu-types.sql;h=1dbe9d2e39bbdaca6dd5a56a91fa7b57fd2e673e;hb=5a4c1b1278ffa01e630fde47f7c54888ed20a576;hp=0000000000000000000000000000000000000000;hpb=cee5ab52df1c9f38b6eaff2dd354cb22f59028c7;p=plcapi.git

diff --git a/trunk/migrations/009-down-pcu-types.sql b/trunk/migrations/009-down-pcu-types.sql
new file mode 100644
index 0000000..1dbe9d2
--- /dev/null
+++ b/trunk/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;