about summary refs log tree commit diff
path: root/db/migrate/20181007025445_create_pghero_space_stats.rb
diff options
context:
space:
mode:
authorThibG <thib@sitedethib.com>2018-10-11 21:28:03 +0200
committerGitHub <noreply@github.com>2018-10-11 21:28:03 +0200
commit00759642446c41c9e9c428010ed0d3d3b79703bb (patch)
treef8cc02c4034d2436ea849a4f313c42eabc51a808 /db/migrate/20181007025445_create_pghero_space_stats.rb
parentbb1103d9742f088252f8156968a474ca8a58b087 (diff)
parent8f720be9f3ad314f0c0b0c7c0cc81616ba20e8fd (diff)
Merge pull request #775 from ThibG/glitch-soc/merge-upstream
Merge upstream changes
Diffstat (limited to 'db/migrate/20181007025445_create_pghero_space_stats.rb')
-rw-r--r--db/migrate/20181007025445_create_pghero_space_stats.rb13
1 files changed, 13 insertions, 0 deletions
diff --git a/db/migrate/20181007025445_create_pghero_space_stats.rb b/db/migrate/20181007025445_create_pghero_space_stats.rb
new file mode 100644
index 000000000..6198a6f84
--- /dev/null
+++ b/db/migrate/20181007025445_create_pghero_space_stats.rb
@@ -0,0 +1,13 @@
+class CreatePgheroSpaceStats < ActiveRecord::Migration[5.2]
+  def change
+    create_table :pghero_space_stats do |t|
+      t.text :database
+      t.text :schema
+      t.text :relation
+      t.integer :size, limit: 8
+      t.timestamp :captured_at
+    end
+
+    add_index :pghero_space_stats, [:database, :captured_at]
+  end
+end