"""added_cmfglobalsettings_fields_and_cmfaudit

Revision ID: 8c3fa39ac2c4
Revises: d46827746110
Create Date: 2024-07-01 15:30:19.863252

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '8c3fa39ac2c4'
down_revision = 'd46827746110'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_global_settings', sa.Column('auth_admin_mode_relogin', sa.Boolean(), nullable=False, server_default="true"))
    op.add_column('cmf_global_settings', sa.Column('login_reuse_lock', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_global_settings', sa.Column('auth_inactive_block_days', sa.Integer(), nullable=False, server_default="0"))
    op.add_column('cmf_global_settings', sa.Column('auth_fail_timeout', sa.Integer(), nullable=False, server_default="1"))
    op.add_column('cmf_global_settings', sa.Column('auth_fail_try_count', sa.Integer(), nullable=False, server_default="5"))
    op.add_column('cmf_global_settings', sa.Column('auth_fail_permanent_block', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_global_settings', sa.Column('audit_storage_duration', sa.Integer(), nullable=False, server_default="0"))
    op.add_column('cmf_person', sa.Column('auth_inactive_block', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_person', sa.Column('auth_fail_try_counter', sa.Integer(), nullable=False, server_default="0"))
    op.add_column('cmf_person', sa.Column('auth_fail_block_end_date', sa.TIMESTAMP(timezone=True), nullable=True))
    op.add_column('cmf_person', sa.Column('auth_fail_permanent_block', sa.Boolean(), nullable=False, server_default="false"))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_global_settings', 'auth_admin_mode_relogin')
    op.drop_column('cmf_global_settings', 'login_reuse_lock')
    op.drop_column('cmf_person', 'auth_fail_permanent_block')
    op.drop_column('cmf_person', 'auth_fail_block_end_date')
    op.drop_column('cmf_person', 'auth_fail_try_counter')
    op.drop_column('cmf_person', 'auth_inactive_block')
    op.drop_column('cmf_global_settings', 'audit_storage_duration')
    op.drop_column('cmf_global_settings', 'auth_fail_permanent_block')
    op.drop_column('cmf_global_settings', 'auth_fail_try_count')
    op.drop_column('cmf_global_settings', 'auth_fail_timeout')
    op.drop_column('cmf_global_settings', 'auth_inactive_block_days')
    # ### end Alembic commands ###