
# revision identifiers, used by Alembic.
revision = '4f8e995d1dba'
down_revision = '4bfecbcc7dbd'

from alembic import op
from sqlalchemy.sql import text


def upgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("""ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16),
                                                    ADD COLUMN folder_prefix varchar(191);"""))


def downgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator, DROP COLUMN folder_prefix"))


# revision identifiers, used by Alembic.
revision = '4f8e995d1dba'
down_revision = '4bfecbcc7dbd'

from alembic import op
from sqlalchemy.sql import text


def upgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16)"))
    conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_prefix varchar(191)"))


def downgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_prefix"))

Revert "merge alter statements together."
Revert "merge alter statements together."

This reverts commit 0ed919a86c835956596e9e897423e6176625f158.
Reverting all IMAP folder handling patches.

  
  # revision identifiers, used by Alembic.
  revision = '4f8e995d1dba'
  down_revision = '4bfecbcc7dbd'
  
  from alembic import op
  from sqlalchemy.sql import text
  
  
  def upgrade():
      conn = op.get_bind()
      conn.execute(text("set @@lock_wait_timeout = 20;"))
-     conn.execute(text("""ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16),
+     conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16)"))
-                                                     ADD COLUMN folder_prefix varchar(191);"""))
+     conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_prefix varchar(191)"))
  
  
  def downgrade():
      conn = op.get_bind()
      conn.execute(text("set @@lock_wait_timeout = 20;"))
-     conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator, DROP COLUMN folder_prefix"))
+     conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator"))
+     conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_prefix"))
  
Revert "merge alter statements together."
## Code Before:

# revision identifiers, used by Alembic.
revision = '4f8e995d1dba'
down_revision = '4bfecbcc7dbd'

from alembic import op
from sqlalchemy.sql import text


def upgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("""ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16),
                                                    ADD COLUMN folder_prefix varchar(191);"""))


def downgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator, DROP COLUMN folder_prefix"))

## Instruction:
Revert "merge alter statements together."
## Code After:

# revision identifiers, used by Alembic.
revision = '4f8e995d1dba'
down_revision = '4bfecbcc7dbd'

from alembic import op
from sqlalchemy.sql import text


def upgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_separator varchar(16)"))
    conn.execute(text("ALTER TABLE genericaccount ADD COLUMN folder_prefix varchar(191)"))


def downgrade():
    conn = op.get_bind()
    conn.execute(text("set @@lock_wait_timeout = 20;"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_separator"))
    conn.execute(text("ALTER TABLE genericaccount DROP COLUMN folder_prefix"))
