Add categories, sections, and import data

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