25 lines
755 B
Ruby
25 lines
755 B
Ruby
class CreateGateways < ActiveRecord::Migration[8.0]
|
|
def change
|
|
create_table :gateways do |t|
|
|
t.string :device_id, null: false
|
|
t.string :name
|
|
t.string :api_key_digest, null: false
|
|
t.string :status, default: "offline"
|
|
t.datetime :last_heartbeat_at
|
|
t.integer :messages_sent_today, default: 0
|
|
t.integer :messages_received_today, default: 0
|
|
t.integer :total_messages_sent, default: 0
|
|
t.integer :total_messages_received, default: 0
|
|
t.boolean :active, default: true
|
|
t.integer :priority, default: 1
|
|
t.jsonb :metadata, default: {}
|
|
|
|
t.timestamps
|
|
end
|
|
|
|
add_index :gateways, :device_id, unique: true
|
|
add_index :gateways, :status
|
|
add_index :gateways, :active
|
|
end
|
|
end
|