def METHOD_NAME():
    # ### commands auto generated by Alembic ###
    op.create_table('advisory_hfi_classification_threshold',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('description', sa.String(), nullable=False),
                    sa.Column('name', sa.String(), nullable=False),
                    sa.PrimaryKeyConstraint('id'),
                    comment='The Operational Safe Works Standards specifies that an hfi of greater than 4000 should result in an advisory. However in order for an FBAN to create useful information, there are other thresholds of concern. E.g. > 10000'
                    )
    op.create_index(op.f('ix_advisory_hfi_classification_threshold_id'),
                    'advisory_hfi_classification_threshold', ['id'], unique=False)
    op.create_table('advisory_classified_hfi',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('threshold', sa.Integer(), nullable=False),
                    sa.Column('run_type', sa.Enum('forecast', 'actual', name='runtypeenum'), nullable=False),
                    sa.Column('run_date', sa.Date(), nullable=False),
                    sa.Column('for_date', sa.Date(), nullable=False),
                    sa.Column('geom', geoalchemy2.types.Geometry(geometry_type='POLYGON', srid=3005,
                                                                 spatial_index=False, from_text='ST_GeomFromEWKT', name='geometry'), nullable=True),
                    sa.ForeignKeyConstraint(['threshold'], ['advisory_hfi_classification_threshold.id'], ),
                    sa.PrimaryKeyConstraint('id'),
                    comment='HFI classification for some forecast/advisory run on some day, for some date'
                    )
    op.create_index('idx_advisory_classified_hfi_geom', 'advisory_classified_hfi',
                    ['geom'], unique=False, postgresql_using='gist')
    op.create_index(op.f('ix_advisory_classified_hfi_id'), 'advisory_classified_hfi', ['id'], unique=False)
    op.create_index(op.f('ix_advisory_classified_hfi_run_type'), 'advisory_classified_hfi', ['run_type'], unique=False)
    op.create_index(op.f('ix_advisory_classified_hfi_threshold'),
                    'advisory_classified_hfi', ['threshold'], unique=False)
    op.drop_index('ix_advisory_fire_zones_id', table_name='advisory_fire_zones')
    op.drop_index('ix_advisory_fire_zones_mof_fire_zone_id', table_name='advisory_fire_zones')
    op.drop_table('advisory_fire_zones')
    # ### end Alembic commands ###
    # Advisory shapes was missing an SRID:
    session = Session(bind=op.get_bind())
    session.execute(sa.text("SELECT UpdateGeometrySRID('advisory_shapes','geom',3005);"))