=begin

Lesli

Copyright (c) 2023, Lesli Technologies, S. A.

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program. If not, see http://www.gnu.org/licenses/.

Lesli · Ruby on Rails Development Platform.

Made with ♥ by https://www.lesli.tech
Building a better future, one line of code at a time.

@contact  hello@lesli.tech
@website  https://www.lesli.tech
@license  GPLv3 http://www.gnu.org/licenses/gpl-3.0.en.html

// · ~·~     ~·~     ~·~     ~·~     ~·~     ~·~     ~·~     ~·~     ~·~
// ·
=end

class CreateLesliUserSessions < ActiveRecord::Migration[6.0]
    def change
        create_table :lesli_user_sessions do |t|
            t.inet   :user_remote                   # IPv4 and IPv6 hosts and networks
            t.string :user_agent

            t.string :session_token                 # authentication token
            t.string :session_source                # session created for/with

            t.integer  :usage_count                 # total number of interactions
            t.datetime :last_used_at                # last datetime token was used
            t.datetime :expiration_at, index: true  # auto-expire session at
            t.datetime :deleted_at, index: true

            t.timestamps
        end
        add_reference(:lesli_user_sessions, :user, foreign_key: { to_table: :lesli_users })
    end
end