22 lines
607 B
Ruby
22 lines
607 B
Ruby
class CreateTreasuries < ActiveRecord::Migration[5.2]
|
|
def down
|
|
drop_table :treasuries
|
|
end
|
|
|
|
def up
|
|
create_table :treasuries do |t|
|
|
t.bigint :user_id, null: false, unsigned: true
|
|
t.string :title, limit: 128, null: true
|
|
t.string :data, null: false
|
|
t.text :result
|
|
t.integer :state, default: 0, null: false, unsigned: true
|
|
t.integer :kind, default: 0, null: false, unsigned: true
|
|
t.timestamps
|
|
end
|
|
add_index :treasuries, :user_id
|
|
add_index :treasuries, :data, unique: true
|
|
add_index :treasuries, %i[user_id title], unique: true
|
|
end
|
|
end
|
|
|