Files
MySMSAPio/db/migrate/20251019070522_create_api_keys.rb
2025-10-22 17:22:17 +08:00

20 lines
511 B
Ruby

class CreateApiKeys < ActiveRecord::Migration[8.0]
def change
create_table :api_keys do |t|
t.string :name, null: false
t.string :key_digest, null: false
t.string :key_prefix, null: false
t.boolean :active, default: true
t.datetime :last_used_at
t.datetime :expires_at
t.jsonb :permissions, default: {}
t.timestamps
end
add_index :api_keys, :key_digest, unique: true
add_index :api_keys, :key_prefix
add_index :api_keys, :active
end
end