annotate db/migrate/045_create_boards.rb @ 1628:9c5f8e24dadc live tip

Quieten this cron script
author Chris Cannam
date Tue, 25 Aug 2020 11:38:49 +0100
parents 513646585e45
children
rev   line source
Chris@0 1 class CreateBoards < ActiveRecord::Migration
Chris@0 2 def self.up
Chris@0 3 create_table :boards do |t|
Chris@0 4 t.column :project_id, :integer, :null => false
Chris@0 5 t.column :name, :string, :default => "", :null => false
Chris@0 6 t.column :description, :string
Chris@0 7 t.column :position, :integer, :default => 1
Chris@0 8 t.column :topics_count, :integer, :default => 0, :null => false
Chris@0 9 t.column :messages_count, :integer, :default => 0, :null => false
Chris@0 10 t.column :last_message_id, :integer
Chris@0 11 end
Chris@0 12 add_index :boards, [:project_id], :name => :boards_project_id
Chris@0 13 end
Chris@0 14
Chris@0 15 def self.down
Chris@0 16 drop_table :boards
Chris@0 17 end
Chris@0 18 end