From 31850c6ca118b7828dbaa3ad1a87dab4287718f5 Mon Sep 17 00:00:00 2001 From: hellekin Date: Thu, 8 Oct 2020 22:10:41 +0200 Subject: Add categories, sections, and import data --- .../20201008184053_add_dewey_id_to_categories_and_sections.rb | 8 ++++++++ db/migrate/20201008190558_create_join_table_resource_sections.rb | 8 ++++++++ 2 files changed, 16 insertions(+) create mode 100644 db/migrate/20201008184053_add_dewey_id_to_categories_and_sections.rb create mode 100644 db/migrate/20201008190558_create_join_table_resource_sections.rb (limited to 'db/migrate') 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 -- cgit v1.2.3