aboutsummaryrefslogtreecommitdiff
path: root/db/migrate/20201008132251_create_taxonomies.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20201008132251_create_taxonomies.rb')
-rw-r--r--db/migrate/20201008132251_create_taxonomies.rb16
1 files changed, 16 insertions, 0 deletions
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