=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 SaaS Development Framework.

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 CreateLesliBabelStrings < ActiveRecord::Migration[6.0]
    def change
        create_table :lesli_babel_strings do |t|

            t.string    :label
            t.string    :es # spanish
            t.string    :en # english
            t.string    :de # deutsch/german
            t.string    :fr # french
            t.string    :nl # nederlands/netherlands/holanda
            t.string    :pl # polski/polish/poland
            t.string    :pt # portuguese
            t.string    :it # italian
            t.string    :tr # turkish
            t.string    :ro # romanian
            t.string    :bg # bulgarian
            t.string    :uk # Ukrainian
            t.string    :sr # Serbian
            t.string    :hr # Hrvatski/Croatian

            t.integer   :status # 0 disabled, 1 ok, 2 need help, 3 need translation
            t.string    :context

            t.datetime  :last_update_es
            t.datetime  :last_update_en
            t.datetime  :last_update_de
            t.datetime  :last_update_fr
            t.datetime  :last_update_nl
            t.datetime  :last_update_pl
            t.datetime  :last_update_pt
            t.datetime  :last_update_it
            t.datetime  :last_update_tr
            t.datetime  :last_update_ro
            t.datetime  :last_update_bg
            t.datetime  :last_update_uk
            t.datetime  :last_update_sr
            t.datetime  :last_update_hr

            t.datetime  :last_update_status
            t.datetime  :last_update_context

            t.string    :reference_bucket
            t.datetime  :deleted_at
            t.timestamps
        end
        add_reference(:lesli_babel_strings, :bucket, foreign_key: { to_table: :lesli_babel_buckets })
    end
end