migrations/versions/9f5b73af01db_.py (22 lines of code) (raw):
"""empty message
Revision ID: 9f5b73af01db
Revises: b5b8370f9262
Create Date: 2017-05-18 16:25:08.317568
"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql
# revision identifiers, used by Alembic.
revision = "9f5b73af01db"
down_revision = "b5b8370f9262"
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index("idx_priority_areas_geometry", table_name="priority_areas")
op.add_column(
"project_info", sa.Column("project_id_str", sa.String(), nullable=True)
)
op.add_column(
"project_info",
sa.Column("text_searchable", postgresql.TSVECTOR(), nullable=True),
)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column("project_info", "text_searchable")
op.drop_column("project_info", "project_id_str")
op.create_index(
"idx_priority_areas_geometry", "priority_areas", ["geometry"], unique=False
)
# ### end Alembic commands ###