def upgrade():
op.create_table(
'ad',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('asin', sa.String(20), nullable=False),
sa.Column('title', sa.String(128), nullable=False),
sa.Column('url', sa.String(1024), nullable=False),
sa.Column('description', sa.String(256), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('asin', name='ux_ad_asin'),
)
op.create_table(
'link_ad',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('issue_id', sa.Integer(), nullable=False),
sa.Column('link_id', sa.Integer(), nullable=False),
sa.Column('ad_id', sa.Integer(), nullable=False),
sa.Column('weight', sa.Numeric(5, 2), nullable=False, server_default='0'),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('link_id', 'ad_id', name='ux_link_ad'),
)
op.create_index('ix_link_weight', 'link_ad', ['link_id', 'weight'], unique=False)
op.create_index('ix_issue_weight', 'link_ad', ['issue_id', 'weight'], unique=False)
评论列表
文章目录