def METHOD_NAME():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        "user_emails",
        sa.Column("id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("additional_email", sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column("is_primary_email", sa.BOOLEAN(), autoincrement=False, nullable=True),
        sa.Column(
            "address_verified",
            postgresql.TIMESTAMP(timezone=True),
            autoincrement=False,
            nullable=True,
        ),
        sa.ForeignKeyConstraint(["id"], ["useraccount.id"], name="user_emails_id_fkey"),
        sa.PrimaryKeyConstraint("id", name="user_emails_pkey"),
        sa.UniqueConstraint(
            "additional_email", name="user_emails_additional_email_key"
        ),
    )
    op.create_table(
        "verifications",
        sa.Column("id", sa.INTEGER(), autoincrement=True, nullable=False),
        sa.Column(
            "verification_pending",
            postgresql.TIMESTAMP(timezone=True),
            autoincrement=False,
            nullable=True,
        ),
        sa.Column(
            "verified",
            postgresql.TIMESTAMP(timezone=True),
            autoincrement=False,
            nullable=True,
        ),
        sa.Column("verification_link", sa.TEXT(), autoincrement=False, nullable=True),
        sa.PrimaryKeyConstraint("id", name="verifications_pkey"),
    )
    op.add_column(
        "verifications",
        sa.Column("verification_type", verification_type, nullable=False),
    )
    op.drop_table("verification")
    op.drop_table("usercontact")
    contact_origin.drop(op.get_bind())
    primary_contact.drop(op.get_bind())
    # ### end Alembic commands ###