aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorXinhui2017-09-06 11:17:28 +0200
committerXinhui2017-09-06 11:22:20 +0200
commit55f142f0a2ef77b88229585225edd561fcf53d92 (patch)
treebf89183cd75c649fa79d5e1e9bd88df6298c2ff1 /db
parent64e68de279967fc352f96e414ddb04bd32aa8a74 (diff)
downloadchouette-core-55f142f0a2ef77b88229585225edd561fcf53d92.tar.bz2
Model ComplianceCheckResource
Refs #4391
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20170906091136_create_compliance_check_resources.rb13
-rw-r--r--db/schema.rb12
2 files changed, 24 insertions, 1 deletions
diff --git a/db/migrate/20170906091136_create_compliance_check_resources.rb b/db/migrate/20170906091136_create_compliance_check_resources.rb
new file mode 100644
index 000000000..45713fed5
--- /dev/null
+++ b/db/migrate/20170906091136_create_compliance_check_resources.rb
@@ -0,0 +1,13 @@
+class CreateComplianceCheckResources < ActiveRecord::Migration
+ def change
+ create_table :compliance_check_resources do |t|
+ t.string :status
+ t.string :name
+ t.string :type
+ t.string :reference
+ t.hstore :metrics
+
+ t.timestamps null: false
+ end
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 1cc3692cf..a1897ac49 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20170906084628) do
+ActiveRecord::Schema.define(version: 20170906091136) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -155,6 +155,16 @@ ActiveRecord::Schema.define(version: 20170906084628) do
add_index "compliance_check_blocks", ["compliance_check_set_id"], name: "index_compliance_check_blocks_on_compliance_check_set_id", using: :btree
+ create_table "compliance_check_resources", id: :bigserial, force: :cascade do |t|
+ t.string "status"
+ t.string "name"
+ t.string "type"
+ t.string "reference"
+ t.hstore "metrics"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "compliance_check_sets", id: :bigserial, force: :cascade do |t|
t.integer "referential_id"
t.integer "compliance_control_set_id"