Restore /20131029115820_create_compliance_check_results. Refs #4469

2 files changed, 25 insertions, 1 deletions

diff --git a/db/migrate/20131029115820_create_compliance_check_results.rb b/db/migrate/20131029115820_create_compliance_check_results.rb
new file mode 100644
index 000000000..7f5c8e436
--- /dev/null
+++ b/db/migrate/20131029115820_create_compliance_check_results.rb
@@ -0,0 +1,23 @@
+class CreateComplianceCheckResults < ActiveRecord::Migration
+  def up
+    unless table_exists? :compliance_check_results
+      create_table :compliance_check_results do |t|
+        t.belongs_to :compliance_check_task , :null => :no ,:limit => 8
+        t.string :rule_code      # rule code value
+        t.string :severity      # warning, error, improvement
+        t.string :status      # NA, OK, NOK
+        t.integer :violation_count # number of violation occurences
+        t.text :detail # detail of violation location
+        t.timestamps
+      end
+      add_foreign_key :compliance_check_results, :compliance_check_tasks, :on_delete => :cascade
+    end
+  end
+
+  def down
+    if table_exists? :compliance_check_results
+      execute "drop table compliance_check_results"
+      # drop_table :compliance_check_results
+    end
+  end
+end
diff --git a/db/migrate/20170906092619_create_compliance_check_results.rb b/db/migrate/20170906092619_create_new_compliance_check_results.rb
index e917d384e..a22800a8f 100644
--- a/db/migrate/20170906092619_create_compliance_check_results.rb
+++ b/db/migrate/20170906092619_create_new_compliance_check_results.rb
@@ -1,5 +1,6 @@
-class CreateComplianceCheckResults < ActiveRecord::Migration
+class CreateNewComplianceCheckResults < ActiveRecord::Migration
   def change
+    drop_table :compliance_check_results if table_exists? :compliance_check_results
     create_table :compliance_check_results do |t|
       t.references :compliance_check, index: true, foreign_key: true
       t.references :compliance_check_resource, index: true, foreign_key: true