aboutsummaryrefslogtreecommitdiff
path: root/db/migrate
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20201008184053_add_dewey_id_to_categories_and_sections.rb8
-rw-r--r--db/migrate/20201008190558_create_join_table_resource_sections.rb8
2 files changed, 16 insertions, 0 deletions
diff --git a/db/migrate/20201008184053_add_dewey_id_to_categories_and_sections.rb b/db/migrate/20201008184053_add_dewey_id_to_categories_and_sections.rb
new file mode 100644
index 0000000..d876b47
--- /dev/null
+++ b/db/migrate/20201008184053_add_dewey_id_to_categories_and_sections.rb
@@ -0,0 +1,8 @@
+class AddDeweyIdToCategoriesAndSections < ActiveRecord::Migration[6.0]
+ def change
+ add_column :categories, :dewey_id, :integer
+ add_column :sections, :dewey_id, :integer
+ add_index :categories, :dewey_id, unique: true
+ add_index :sections, :dewey_id, unique: true
+ end
+end
diff --git a/db/migrate/20201008190558_create_join_table_resource_sections.rb b/db/migrate/20201008190558_create_join_table_resource_sections.rb
new file mode 100644
index 0000000..d01c27f
--- /dev/null
+++ b/db/migrate/20201008190558_create_join_table_resource_sections.rb
@@ -0,0 +1,8 @@
+class CreateJoinTableResourceSections < ActiveRecord::Migration[6.0]
+ def change
+ create_join_table :resources, :sections do |t|
+ # t.index [:resource_id, :section_id]
+ # t.index [:section_id, :resource_id]
+ end
+ end
+end