Mercurial > hg > soundsoftware-site
annotate db/migrate/046_create_messages.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 CreateMessages < ActiveRecord::Migration |
Chris@0 | 2 def self.up |
Chris@0 | 3 create_table :messages do |t| |
Chris@0 | 4 t.column :board_id, :integer, :null => false |
Chris@0 | 5 t.column :parent_id, :integer |
Chris@0 | 6 t.column :subject, :string, :default => "", :null => false |
Chris@0 | 7 t.column :content, :text |
Chris@0 | 8 t.column :author_id, :integer |
Chris@0 | 9 t.column :replies_count, :integer, :default => 0, :null => false |
Chris@0 | 10 t.column :last_reply_id, :integer |
Chris@0 | 11 t.column :created_on, :datetime, :null => false |
Chris@0 | 12 t.column :updated_on, :datetime, :null => false |
Chris@0 | 13 end |
Chris@0 | 14 add_index :messages, [:board_id], :name => :messages_board_id |
Chris@0 | 15 add_index :messages, [:parent_id], :name => :messages_parent_id |
Chris@0 | 16 end |
Chris@0 | 17 |
Chris@0 | 18 def self.down |
Chris@0 | 19 drop_table :messages |
Chris@0 | 20 end |
Chris@0 | 21 end |