loader: Sync load- and build-time deps.
[asterisk/asterisk.git] / contrib / ast-db-manage / queue_log / versions / 4105ee839f58_create_queue_log_table.py
1 """create queue_log table
2
3 Revision ID: 4105ee839f58
4 Revises:
5 Create Date: 2016-09-30 22:32:45.918340
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '4105ee839f58'
11 down_revision = None
12 branch_labels = None
13 depends_on = None
14
15 from alembic import op
16 import sqlalchemy as sa
17
18
19 def upgrade():
20     op.create_table(
21         'queue_log',
22         sa.Column('id', sa.BigInteger, primary_key=True, nullable=False,
23                   unique=True, autoincrement=True),
24         sa.Column('time', sa.DateTime()),
25         sa.Column('callid', sa.String(80)),
26         sa.Column('queuename', sa.String(256)),
27         sa.Column('agent', sa.String(80)),
28         sa.Column('event', sa.String(32)),
29         sa.Column('data1', sa.String(100)),
30         sa.Column('data2', sa.String(100)),
31         sa.Column('data3', sa.String(100)),
32         sa.Column('data4', sa.String(100)),
33         sa.Column('data5', sa.String(100))
34     )
35
36
37 def downgrade():
38     op.drop_table('queue_log')