summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db/migrate/20210503215828_add_gid_indicies.rb7
-rw-r--r--db/schema.rb5
2 files changed, 11 insertions, 1 deletions
diff --git a/db/migrate/20210503215828_add_gid_indicies.rb b/db/migrate/20210503215828_add_gid_indicies.rb
new file mode 100644
index 0000000..3568f55
--- /dev/null
+++ b/db/migrate/20210503215828_add_gid_indicies.rb
@@ -0,0 +1,7 @@
+class AddGidIndicies < ActiveRecord::Migration[6.1]
+ def change
+ add_index :activities, :gid
+ add_index :items, :gid
+ add_index :skills, :gid
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index a86c111..8dd6dcc 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,7 +10,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 2021_05_03_005919) do
+ActiveRecord::Schema.define(version: 2021_05_03_215828) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -22,6 +22,7 @@ ActiveRecord::Schema.define(version: 2021_05_03_005919) do
t.jsonb "whatnot"
t.datetime "created_at", precision: 6, null: false
t.datetime "updated_at", precision: 6, null: false
+ t.index ["gid"], name: "index_activities_on_gid"
end
create_table "character_items", force: :cascade do |t|
@@ -55,6 +56,7 @@ ActiveRecord::Schema.define(version: 2021_05_03_005919) do
t.jsonb "whatnot"
t.datetime "created_at", precision: 6, null: false
t.datetime "updated_at", precision: 6, null: false
+ t.index ["gid"], name: "index_items_on_gid"
end
create_table "skills", force: :cascade do |t|
@@ -63,6 +65,7 @@ ActiveRecord::Schema.define(version: 2021_05_03_005919) do
t.text "description"
t.datetime "created_at", precision: 6, null: false
t.datetime "updated_at", precision: 6, null: false
+ t.index ["gid"], name: "index_skills_on_gid"
end
create_table "users", force: :cascade do |t|