"""res_pjsip: add contact via_addr and callid

Revision ID: a845e4d8ade8
Revises: bca7113d796f
Create Date: 2016-05-19 15:51:33.410852

"""

# revision identifiers, used by Alembic.
revision = 'a845e4d8ade8'
down_revision = 'd7e3c73eb2bf'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('ps_contacts', sa.Column('via_addr', sa.String(40)))
    op.add_column('ps_contacts', sa.Column('via_port', sa.Integer))
    op.add_column('ps_contacts', sa.Column('call_id', sa.String(255)))

def downgrade():
    op.drop_column('ps_contacts', 'via_addr')
    op.drop_column('ps_contacts', 'via_port')
    op.drop_column('ps_contacts', 'call_id')