51415576d3e9_org_metadata.py 文件源码

def upgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('organization',
    sa.Column('organization_id', sa.Integer(), nullable=False),
    sa.Column('external_id', sa.String(length=80), nullable=False),
    sa.Column('display_name', sa.String(length=255), nullable=False),
    sa.Column('hpo_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['hpo_id'], ['hpo.hpo_id'], ),
    sa.PrimaryKeyConstraint('organization_id')
    )
    op.add_column(u'site', sa.Column('address_1', sa.String(length=1024), nullable=True))
    op.add_column(u'site', sa.Column('address_2', sa.String(length=1024), nullable=True))
    op.add_column(u'site', sa.Column('admin_emails', sa.String(length=4096), nullable=True))
    op.add_column(u'site', sa.Column('city', sa.String(length=255), nullable=True))
    op.add_column(u'site', sa.Column('directions', sa.String(length=1024), nullable=True))
    op.add_column(u'site', sa.Column('latitude', sa.Float(), nullable=True))
    op.add_column(u'site', sa.Column('launch_date', sa.Date(), nullable=True))
    op.add_column(u'site', sa.Column('link', sa.String(length=255), nullable=True))
    op.add_column(u'site', sa.Column('longitude', sa.Float(), nullable=True))
    op.add_column(u'site', sa.Column('notes', sa.String(length=1024), nullable=True))
    op.add_column(u'site', sa.Column('organization_id', sa.Integer(), nullable=True))
    op.add_column(u'site', sa.Column('phone_number', sa.String(length=80), nullable=True))
    op.add_column(u'site', sa.Column('physical_location_name', sa.String(length=1024), nullable=True))
    op.add_column(u'site', sa.Column('site_status', model.utils.Enum(SiteStatus), nullable=True))
    op.add_column(u'site', sa.Column('state', sa.String(length=2), nullable=True))
    op.add_column(u'site', sa.Column('zip_code', sa.String(length=10), nullable=True))
    op.alter_column(u'site', 'hpo_id',
               existing_type=mysql.INTEGER(display_width=11),
               nullable=True)
    op.create_foreign_key(None, 'site', 'organization', ['organization_id'], ['organization_id'])
    op.drop_column(u'site', 'consortium_name')
    # ### end Alembic commands ###