21 行
502 B
Ruby
21 行
502 B
Ruby
class CreateScripts < ActiveRecord::Migration[8.0]
|
|
def up
|
|
create_table :scripts, id: { type: 'CHAR(4)' }, primary_key: :code do |t|
|
|
t.string :name, null: false
|
|
t.datetime :deprecated_at, index: true
|
|
t.datetime :created_at, null: false
|
|
end
|
|
|
|
execute <<~SQL
|
|
INSERT INTO
|
|
scripts(code, name, created_at)
|
|
VALUES
|
|
('Jpan', '漢字および仮名文字', #{ connection.quote Time.current })
|
|
SQL
|
|
end
|
|
|
|
def down
|
|
drop_table :scripts
|
|
end
|
|
end
|