migrations for storing ssh keys - checkpoint

[sfa.git] / sfa / storage / migrations / 002-down-keys-roles.sql

diff --git a/sfa/storage/migrations/002-down-keys-roles.sql b/sfa/storage/migrations/002-down-keys-roles.sql
new file mode 100644 (file)
index 0000000..a3a2733
--- /dev/null
+++ b/sfa/storage/migrations/002-down-keys-roles.sql
@@ -0,0 +1,8 @@
+DROP VIEW view_records;
+DROP VIEW record_keys;
+DROP TABLE record_key;
+DROP TABLE keys;
+DROP TABLE key_types;
+
+------------------------------------------------------------
+UPDATE sfa_db_version SET subversion = 1;