| 12345678910111213141516171819202122 |
- import sqlalchemy as sa
- from alembic import op
- from sqlalchemy.dialects.mysql import BINARY
- revision = "0003_proposal_submitter"
- down_revision = "0002_auth_after_sales"
- branch_labels = None
- depends_on = None
- def upgrade():
- op.add_column("proposal_versions", sa.Column("submitted_by", BINARY(16), nullable=True))
- op.execute(
- "UPDATE proposal_versions AS p JOIN tickets AS t "
- "ON p.tenant_id=t.tenant_id AND p.proposal_id=t.id "
- "SET p.submitted_by=t.created_by"
- )
- op.alter_column("proposal_versions", "submitted_by", existing_type=BINARY(16), nullable=False)
- def downgrade():
- op.drop_column("proposal_versions", "submitted_by")
|
