prompt: We are currently solving the following issue within our repository. Here is the issue text:
  --- BEGIN ISSUE ---
  Error in migrations
  **Describe the bug**
  Due to recent merging of PRs https://github.com/fossasia/open-event-server/pull/6744/ https://github.com/fossasia/open-event-server/pull/6748
  
  The PR https://github.com/fossasia/open-event-server/pull/6744 has an invalid migration to remove the 'secret' column from the db which was unrelated to PR. Hence now we have two migration for  the same column `secret` from `settings` which
   drops column on upgrade and creates  on downgrade
  
  
  **Additional context**
  @iamareebjamal - Please chck
  
  
  --- END ISSUE ---
  
  Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
  --- BEGIN FILES ---
  Path: `migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py`
  Content:
  ```
  1 """empty message
  2 
  3 Revision ID: 6ebafb385765
  4 Revises: 30a490ad1609
  5 Create Date: 2020-01-17 18:09:31.897988
  6 
  7 """
  8 
  9 from alembic import op
  10 import sqlalchemy as sa
  11 import sqlalchemy_utils
  12 
  13 
  14 # revision identifiers, used by Alembic.
  15 revision = '6ebafb385765'
  16 down_revision = '30a490ad1609'
  17 
  18 
  19 def upgrade():
  20     # ### commands auto generated by Alembic - please adjust! ###
  21     op.drop_column('settings', 'secret')
  22     op.add_column('ticket_holders', sa.Column('age_group', sa.String(), nullable=True))
  23     # ### end Alembic commands ###
  24 
  25 
  26 def downgrade():
  27     # ### commands auto generated by Alembic - please adjust! ###
  28     op.drop_column('ticket_holders', 'age_group')
  29     op.add_column('settings', sa.Column('secret', sa.VARCHAR(), autoincrement=False, nullable=True))
  30     # ### end Alembic commands ###
  31
  ```
  --- END FILES ---
  
  Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.
  
  Here is an example:
  
  ```diff
  diff --git a/examples/server_async.py b/examples/server_async.py
  --- a/examples/server_async.py
  +++ b/examples/server_async.py
  @@ -313,4 +313,4 @@
   
   
   if __name__ == "__main__":
  -    asyncio.run(run_async_server("."), debug=True)
  +    asyncio.run(run_async_server(), debug=True)
  diff --git a/examples/server_sync.py b/examples/server_sync.py
  --- a/examples/server_sync.py
  +++ b/examples/server_sync.py
  @@ -313,5 +313,5 @@
   
   
   if __name__ == "__main__":
  -    server = run_sync_server(".")
  +    server = run_sync_server()
       server.shutdown()
  
  ```
  
golden_diff: diff --git a/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py b/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py
  --- a/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py
  +++ b/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py
  @@ -18,7 +18,6 @@
   
   def upgrade():
       # ### commands auto generated by Alembic - please adjust! ###
  -    op.drop_column('settings', 'secret')
       op.add_column('ticket_holders', sa.Column('age_group', sa.String(), nullable=True))
       # ### end Alembic commands ###
   
  @@ -26,5 +25,4 @@
   def downgrade():
       # ### commands auto generated by Alembic - please adjust! ###
       op.drop_column('ticket_holders', 'age_group')
  -    op.add_column('settings', sa.Column('secret', sa.VARCHAR(), autoincrement=False, nullable=True))
       # ### end Alembic commands ###
  
verification_info: {"golden_diff": "diff --git a/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py b/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py\n--- a/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py\n+++ b/migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py\n@@ -18,7 +18,6 @@\n \n def upgrade():\n     # ### commands auto generated by Alembic - please adjust! ###\n-    op.drop_column('settings', 'secret')\n     op.add_column('ticket_holders', sa.Column('age_group', sa.String(), nullable=True))\n     # ### end Alembic commands ###\n \n@@ -26,5 +25,4 @@\n def downgrade():\n     # ### commands auto generated by Alembic - please adjust! ###\n     op.drop_column('ticket_holders', 'age_group')\n-    op.add_column('settings', sa.Column('secret', sa.VARCHAR(), autoincrement=False, nullable=True))\n     # ### end Alembic commands ###\n", "issue": "Error in migrations\n**Describe the bug**\r\nDue to recent merging of PRs https://github.com/fossasia/open-event-server/pull/6744/ https://github.com/fossasia/open-event-server/pull/6748\r\n\r\nThe PR https://github.com/fossasia/open-event-server/pull/6744 has an invalid migration to remove the 'secret' column from the db which was unrelated to PR. Hence now we have two migration for  the same column `secret` from `settings` which\r\n drops column on upgrade and creates  on downgrade\r\n\r\n\r\n**Additional context**\r\n@iamareebjamal - Please chck\r\n\n", "before_files": [{"content": "\"\"\"empty message\n\nRevision ID: 6ebafb385765\nRevises: 30a490ad1609\nCreate Date: 2020-01-17 18:09:31.897988\n\n\"\"\"\n\nfrom alembic import op\nimport sqlalchemy as sa\nimport sqlalchemy_utils\n\n\n# revision identifiers, used by Alembic.\nrevision = '6ebafb385765'\ndown_revision = '30a490ad1609'\n\n\ndef upgrade():\n    # ### commands auto generated by Alembic - please adjust! ###\n    op.drop_column('settings', 'secret')\n    op.add_column('ticket_holders', sa.Column('age_group', sa.String(), nullable=True))\n    # ### end Alembic commands ###\n\n\ndef downgrade():\n    # ### commands auto generated by Alembic - please adjust! ###\n    op.drop_column('ticket_holders', 'age_group')\n    op.add_column('settings', sa.Column('secret', sa.VARCHAR(), autoincrement=False, nullable=True))\n    # ### end Alembic commands ###\n", "path": "migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py"}], "after_files": [{"content": "\"\"\"empty message\n\nRevision ID: 6ebafb385765\nRevises: 30a490ad1609\nCreate Date: 2020-01-17 18:09:31.897988\n\n\"\"\"\n\nfrom alembic import op\nimport sqlalchemy as sa\nimport sqlalchemy_utils\n\n\n# revision identifiers, used by Alembic.\nrevision = '6ebafb385765'\ndown_revision = '30a490ad1609'\n\n\ndef upgrade():\n    # ### commands auto generated by Alembic - please adjust! ###\n    op.add_column('ticket_holders', sa.Column('age_group', sa.String(), nullable=True))\n    # ### end Alembic commands ###\n\n\ndef downgrade():\n    # ### commands auto generated by Alembic - please adjust! ###\n    op.drop_column('ticket_holders', 'age_group')\n    # ### end Alembic commands ###\n", "path": "migrations/versions/rev-2020-01-17-18:09:31-6ebafb385765_.py"}]}