e851b34d79b8_init.py 文件源码

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('credential',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('type', postgresql.ENUM('username', 'admin', name='credential_types'), nullable=False),
    sa.Column('key', sa.String(length=255), nullable=False),
    sa.Column('value', sa.String(length=255), nullable=True),
    sa.Column('created_at', sa.DateTime(timezone=True), server_default=sa.text(u'now()'), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('key')
    )
    op.create_table('photo',
    sa.Column('id', sa.String(length=36), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=True),
    sa.Column('original_width', sa.Integer(), nullable=True),
    sa.Column('original_height', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('post',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('photo_id', sa.String(length=36), nullable=True),
    sa.Column('message', sa.Text(), nullable=True),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('created_at', sa.DateTime(timezone=True), server_default=sa.text(u'now()'), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('user',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('username', sa.String(length=80), nullable=False),
    sa.Column('photo_id', sa.String(length=36), nullable=True),
    sa.Column('created_at', sa.DateTime(timezone=True), server_default=sa.text(u'now()'), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )

    op.create_foreign_key(
        'credential_user_id_fkey',
        'credential', 'user',
        ['user_id'], ['id'],
    )
    op.create_foreign_key(
        'photo_user_id_fkey',
        'photo', 'user',
        ['user_id'], ['id'],
    )
    op.create_foreign_key(
        'post_photo_id_fkey',
        'post', 'photo',
        ['photo_id'], ['id'],
    )
    op.create_foreign_key(
        'post_user_id_fkey',
        'post', 'user',
        ['user_id'], ['id'],
    )
    op.create_foreign_key(
        'user_photo_id_fkey',
        'user', 'photo',
        ['photo_id'], ['id'],
    )
    # ### end Alembic commands ###