4105ee839f58_create_queue_log_table.py

Go to the documentation of this file.

"""create queue_log table
 
Revision ID: 4105ee839f58
Revises: None
Create Date: 2016-09-30 22:32:45.918340
 
"""
 
# revision identifiers, used by Alembic.
revision = '4105ee839f58'
down_revision = None
branch_labels = None
depends_on = None
 
from alembic import op
import sqlalchemy as sa
 
 
def upgrade():
    op.create_table(
        'queue_log',
        sa.Column('id', sa.BigInteger, primary_key=True, nullable=False,
                  unique=True, autoincrement=True),
        sa.Column('time', sa.DateTime()),
        sa.Column('callid', sa.String(80)),
        sa.Column('queuename', sa.String(256)),
        sa.Column('agent', sa.String(80)),
        sa.Column('event', sa.String(32)),
        sa.Column('data1', sa.String(100)),
        sa.Column('data2', sa.String(100)),
        sa.Column('data3', sa.String(100)),
        sa.Column('data4', sa.String(100)),
        sa.Column('data5', sa.String(100))
    )
 
 
def downgrade():
    op.drop_table('queue_log')