summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authormo khan <mo@mokhan.ca>2015-02-07 08:33:02 -0700
committermo khan <mo@mokhan.ca>2015-02-07 08:33:02 -0700
commitd6af160515debb1de4144c632cc81e6039c3a1bf (patch)
treee157164dc0b057b34a0ecb710b2f7649ae4d67b2 /db
parentbbe1d5d27ac72a172d155249067206e85e3c013a (diff)
fetch report for file from virus total.
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20150207151759_create_file_reports.rb10
-rw-r--r--db/schema.rb9
2 files changed, 18 insertions, 1 deletions
diff --git a/db/migrate/20150207151759_create_file_reports.rb b/db/migrate/20150207151759_create_file_reports.rb
new file mode 100644
index 0000000..63a1702
--- /dev/null
+++ b/db/migrate/20150207151759_create_file_reports.rb
@@ -0,0 +1,10 @@
+class CreateFileReports < ActiveRecord::Migration
+ def change
+ create_table :file_reports, id: :uuid, default: 'uuid_generate_v4()' do |t|
+ t.uuid :disposition_id
+ t.json :data
+
+ t.timestamps null: false
+ end
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 1011d84..88839f9 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: 20150204042612) do
+ActiveRecord::Schema.define(version: 20150207151759) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -40,4 +40,11 @@ ActiveRecord::Schema.define(version: 20150204042612) do
add_index "events", ["agent_id"], name: "index_events_on_agent_id", using: :btree
+ create_table "file_reports", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t|
+ t.uuid "disposition_id"
+ t.json "data"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
end