Contents

# frozen_string_literal: true

Sequel.migration do
  up do
    create_table :push_notification_devices do
      primary_key :id

      column :token,      :varchar, empty: false, unique: true
      column :alias,      :varchar
      column :badge,      :int4, null: false, default: 0
      column :locale,     :varchar
      column :language,   :varchar
      column :timezone,   :varchar, empty: false, default: 'UTC'
      column :ip_address, :inet
      column :lat,        :float8
      column :lng,        :float8
      column :tags,       :'text[]'

      index :token
      index :alias
      index %i[lat lng]
    end
  end

  down do
    drop_table :push_notification_devices
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
rack-push-notification-0.6.0	./lib/rack/push-notification/migrations/001_base_schema.rb