From 8f691b566ffbc79f1d2d7a3f67d8607cc03a789c Mon Sep 17 00:00:00 2001 From: hellekin Date: Thu, 8 Oct 2020 16:51:30 +0200 Subject: Add model foundation for classifications Taxonomy > Category > Section This commit adds models for it. https://doc.incommon.cc/#classifications --- db/migrate/20201008132251_create_taxonomies.rb | 16 ++++++++++++++++ db/migrate/20201008132731_create_categories.rb | 15 +++++++++++++++ db/migrate/20201008133300_create_sections.rb | 14 ++++++++++++++ 3 files changed, 45 insertions(+) create mode 100644 db/migrate/20201008132251_create_taxonomies.rb create mode 100644 db/migrate/20201008132731_create_categories.rb create mode 100644 db/migrate/20201008133300_create_sections.rb (limited to 'db/migrate') diff --git a/db/migrate/20201008132251_create_taxonomies.rb b/db/migrate/20201008132251_create_taxonomies.rb new file mode 100644 index 0000000..8c746b1 --- /dev/null +++ b/db/migrate/20201008132251_create_taxonomies.rb @@ -0,0 +1,16 @@ +class CreateTaxonomies < ActiveRecord::Migration[6.0] + def change + create_table :taxonomies do |t| + t.string :name, limit: 64 + t.string :summary, limit: 64 + t.text :description + t.uuid :uuid + t.integer :categories_count, default: 0 + t.references :agent, null: false, foreign_key: true + + t.timestamps + end + add_index :taxonomies, :name, unique: true + add_index :taxonomies, :uuid, unique: true + end +end diff --git a/db/migrate/20201008132731_create_categories.rb b/db/migrate/20201008132731_create_categories.rb new file mode 100644 index 0000000..eb5a6fa --- /dev/null +++ b/db/migrate/20201008132731_create_categories.rb @@ -0,0 +1,15 @@ +class CreateCategories < ActiveRecord::Migration[6.0] + def change + create_table :categories do |t| + t.string :name, limit: 64 + t.string :summary, limit: 136 + t.text :description + t.references :taxonomy, null: false, foreign_key: true + t.string :color, limit: 25 + t.integer :rank + t.integer :sections_count, default: 0 + + t.timestamps + end + end +end diff --git a/db/migrate/20201008133300_create_sections.rb b/db/migrate/20201008133300_create_sections.rb new file mode 100644 index 0000000..c71c055 --- /dev/null +++ b/db/migrate/20201008133300_create_sections.rb @@ -0,0 +1,14 @@ +class CreateSections < ActiveRecord::Migration[6.0] + def change + create_table :sections do |t| + t.string :name, limit: 64 + t.string :summary, limit: 136 + t.text :description + t.references :category, null: false, foreign_key: true + t.string :color, limit: 25 + t.integer :rank, default: 0 + + t.timestamps + end + end +end -- cgit v1.2.3