def downgrade()

in src/Backend/migrations/versions/2023_05_03_174247-e8d7b15c2a48_add_organization_and_groups_fixing_.py [0:0]


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, 'users', type_='foreignkey')
    op.drop_constraint(None, 'users', type_='foreignkey')
    op.drop_index(op.f('ix_users_role_id'), table_name='users')
    op.drop_index(op.f('ix_users_group_id'), table_name='users')
    op.drop_column('users', 'role_id')
    op.drop_column('users', 'group_id')
    op.create_table('role_user',
    sa.Column('role_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('user_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['role_id'], ['roles.id'], name='role_user_role_id_fkey', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='role_user_user_id_fkey', ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('role_id', 'user_id', name='role_user_pkey')
    )
    op.create_index('ix_role_user_user_id', 'role_user', ['user_id'], unique=False)
    op.create_index('ix_role_user_role_id', 'role_user', ['role_id'], unique=False)
    op.drop_index(op.f('ix_groups_organization_id'), table_name='groups')
    op.drop_table('groups')
    op.drop_table('organizations')