def METHOD_NAME():
    # ### commands auto generated by Alembic ! ###
    op.create_table('c_haines_model_runs',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('model_run_timestamp', sa.TIMESTAMP(timezone=True), nullable=False),
                    sa.Column('prediction_model_id', sa.Integer(), nullable=False),
                    sa.ForeignKeyConstraint(['prediction_model_id'], ['prediction_models.id'], ),
                    sa.PrimaryKeyConstraint('id'),
                    sa.UniqueConstraint('model_run_timestamp', 'prediction_model_id'),
                    comment='Identifies the model run and prediction for a particular set of c-haines calculations'
                    )
    op.create_index(op.f('ix_c_haines_model_runs_id'), 'c_haines_model_runs', ['id'], unique=False)
    op.create_index(op.f('ix_c_haines_model_runs_prediction_model_id'),
                    'c_haines_model_runs', ['prediction_model_id'], unique=False)
    op.create_table('c_haines_predictions',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('prediction_timestamp', sa.TIMESTAMP(timezone=True), nullable=False),
                    sa.Column('model_run_id', sa.Integer(), nullable=False),
                    sa.ForeignKeyConstraint(['model_run_id'], ['c_haines_model_runs.id'], ),
                    sa.PrimaryKeyConstraint('id'),
                    sa.UniqueConstraint('prediction_timestamp', 'model_run_id'),
                    comment='Identifies the model run and prediction for a particular set of c-haines calculations'
                    )
    op.create_index(op.f('ix_c_haines_predictions_id'), 'c_haines_predictions', ['id'], unique=False)
    op.create_index(op.f('ix_c_haines_predictions_model_run_id'),
                    'c_haines_predictions', ['model_run_id'], unique=False)
    op.create_table('c_haines_polygons',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('geom', geoalchemy2.types.Geometry(geometry_type='POLYGON',
                                                                 spatial_index=False,
                                                                 from_text='ST_GeomFromEWKT', name='geometry'), nullable=False),
                    sa.Column('c_haines_index', sa.Enum('<4', '4-8', '8-11', '>11',
                                                        name='c_haines_severity_levels'), nullable=False),
                    sa.Column('c_haines_prediction_id', sa.Integer(), nullable=False),
                    sa.ForeignKeyConstraint(['c_haines_prediction_id'], ['c_haines_predictions.id'], ),
                    sa.PrimaryKeyConstraint('id')
                    )
    op.create_index('idx_c_haines_polygons_geom', 'c_haines_polygons',
                    ['geom'], unique=False, postgresql_using='gist')
    op.create_index(op.f('ix_c_haines_polygons_c_haines_prediction_id'),
                    'c_haines_polygons', ['c_haines_prediction_id'], unique=False)
    op.create_index(op.f('ix_c_haines_polygons_id'), 'c_haines_polygons', ['id'], unique=False)
    op.create_index('idx_prediction_model_grid_subsets_geom', 'prediction_model_grid_subsets',
                    ['geom'], unique=False, postgresql_using='gist')
    # ### end Alembic commands ###