3 Revision ID: aa6d7b595a94
5 Create Date: 2018-05-29 20:09:56.647358
9 import sqlalchemy as sa
12 # revision identifiers, used by Alembic.
13 revision = 'aa6d7b595a94'
14 down_revision = 'aa6d21889d22'
20 # ### commands auto generated by Alembic - please adjust! ###
21 op.add_column('package', sa.Column('media_license_id', sa.Integer()))
22 op.execute('UPDATE package SET media_license_id=license_id')
23 op.alter_column('package', 'media_license_id', nullable=False)
24 op.alter_column('package', 'license_id', existing_type=sa.INTEGER(), nullable=False)
25 op.create_foreign_key(None, 'package', 'license', ['media_license_id'], ['id'])
26 # ### end Alembic commands ###
30 # ### commands auto generated by Alembic - please adjust! ###
31 op.alter_column('package', 'license_id',
32 existing_type=sa.INTEGER(),
34 op.drop_column('package', 'media_license_id')
35 # ### end Alembic commands ###