def downgrade():
    op.drop_table('vehicles')
    op.drop_table('roles_users')
    op.drop_table('report_preferences')
    op.drop_table('involved')
    op.drop_table('general_preferences')
    op.drop_table('users')
    op.drop_table('roles')
    op.drop_index(op.f('ix_markers_created'), table_name='markers')
    op.drop_index('acc_long_lat_idx', table_name='markers')
    op.drop_table('markers')
    op.drop_index('highlight_long_lat_idx', table_name='highlight_markers')
    op.drop_table('highlight_markers')
    op.drop_index(op.f('ix_discussions_created'), table_name='discussions')
    op.drop_index('disc_long_lat_idx', table_name='discussions')
    op.drop_table('discussions')
def downgrade():
    op.drop_table('vehicles')
    op.drop_table('roles_users')
    op.drop_table('report_preferences')
    op.drop_table('involved')
    op.drop_table('general_preferences')
    op.drop_table('users')
    op.drop_table('roles')
    op.drop_index(op.f('ix_markers_created'), table_name='markers')
    op.drop_index('acc_long_lat_idx', table_name='markers')
    op.drop_table('markers')
    op.drop_index('highlight_long_lat_idx', table_name='highlight_markers')
    op.drop_table('highlight_markers')
    op.drop_index(op.f('ix_discussions_created'), table_name='discussions')
    op.drop_index('disc_long_lat_idx', table_name='discussions')
    op.drop_table('discussions')