<reponame>rajatsharma94/lemur
"""Create index on certificates table for id desc


Revision ID: <KEY>
Revises: <KEY>
Create Date: 2018-10-11 11:23:31.195471

"""

revision = "<KEY>"
down_revision = "<KEY>"

import sqlalchemy as sa
from alembic import op


def upgrade():
    op.create_index(
        "ix_certificates_id_desc",
        "certificates",
        [sa.text("id DESC")],
        unique=True,
        postgresql_using="btree",
    )


def downgrade():
    op.drop_index("ix_certificates_id_desc", table_name="certificates")

"""Create index on certificates table for id desc


Revision ID: <KEY>
Revises: <KEY>
Create Date: 2018-10-11 11:23:31.195471

"""

revision = "<KEY>"
down_revision = "<KEY>"

import sqlalchemy as sa
from alembic import op


def upgrade():
    op.create_index(
        "ix_certificates_id_desc",
        "certificates",
        [sa.text("id DESC")],
        unique=True,
        postgresql_using="btree",
    )


def downgrade():
    op.drop_index("ix_certificates_id_desc", table_name="certificates")
Create index on certificates table for id desc   Revision ID: <KEY> Revises: <KEY> Create Date: 2018-10-11 11:23:31.195471