"""empty message
Revision ID: 0380e8ec69c0
Revises:
Create Date: 2023-02-09 17:00:29.257012
"""
from alembic import op
import sqlalchemy as sa
# revision identifiers, used by Alembic.
revision = '0380e8ec69c0'
down_revision = None
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('blog_tag',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('tag_name', sa.String(length=50), nullable=False, comment='标签名'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('blog_type',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('type_name', sa.String(length=50), nullable=False, comment='分类名'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('comment_user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('nickname', sa.String(length=50), nullable=False, comment='昵称'),
sa.Column('email', sa.String(length=20), nullable=False, comment='邮箱'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('nickname', sa.String(length=48), nullable=False, comment='昵称'),
sa.Column('email', sa.String(length=48), nullable=False, comment='邮箱'),
sa.Column('password', sa.String(length=128), nullable=True, comment='密码'),
sa.Column('head_url', sa.String(length=32), nullable=True, comment='头像'),
sa.Column('slogan', sa.String(length=64), nullable=True, comment='Slogan'),
sa.Column('detail', sa.Text(), nullable=True, comment='详细介绍'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('blog',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('title', sa.String(length=100), nullable=False, comment='标题'),
sa.Column('content', sa.Text(), nullable=False, comment='正文'),
sa.Column('see_num', sa.Integer(), nullable=True, comment='观看数'),
sa.Column('update_time', sa.DateTime(), nullable=True, comment='更新时间'),
sa.Column('type_id', sa.Integer(), nullable=True, comment='分类id'),
sa.Column('user_id', sa.Integer(), nullable=False, comment='创建人id'),
sa.ForeignKeyConstraint(['type_id'], ['blog_type.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('blog_map',
sa.Column('tag_id', sa.Integer(), nullable=False, comment='标签id'),
sa.Column('blog_id', sa.Integer(), nullable=False, comment='文章id'),
sa.ForeignKeyConstraint(['blog_id'], ['blog.id'], ),
sa.ForeignKeyConstraint(['tag_id'], ['blog_tag.id'], ),
sa.PrimaryKeyConstraint('tag_id', 'blog_id')
)
op.create_table('comments',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False, comment='id'),
sa.Column('create_time', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('comment_content', sa.Text(), nullable=False, comment='评论内容'),
sa.Column('blog_id', sa.Integer(), nullable=True, comment='评论文章id'),
sa.Column('parent_id', sa.Integer(), nullable=True, comment='父评论id'),
sa.Column('user_id', sa.Integer(), nullable=True, comment='评论人id'),
sa.ForeignKeyConstraint(['blog_id'], ['blog.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['comment_user.id'], ),
sa.PrimaryKeyConstraint('id')
)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('comments')
op.drop_table('blog_map')
op.drop_table('blog')
op.drop_table('user')
op.drop_table('comment_user')
op.drop_table('blog_type')
op.drop_table('blog_tag')
# ### end Alembic commands ###
单人博客开发，单用户，支持评论，前后端分离，后端采用flask-resfult进行api开发.zip （28个子文件） 
bigbiao_blog-master exts 
__init__.py 455B migrations README 38B script.py.mako 494B alembic.ini 857B env.py 3KB versions 0380e8ec69c0_.py 4KB 3a1aabd133bb_.py 919B app.py 1KB bigbiao_blog.db 44KB .idea bigbiao_blog.iml 407B vcs.xml 180B workspace.xml 13KB misc.xml 189B inspectionProfiles Project_Default.xml 1KB profiles_settings.xml 174B static uploads 
SE1OWUSRTJ1.png 2.27MB apps __init__.py 995B api __init__.py 612B user_api.py 3KB blog_api.py 2KB file_api.py 1KB utils __init__.py 3KB model __init__.py 1KB comments_info.py 811B blogs_info.py 2KB user_info.py 3KB conf __init__.py 804B settings.py 917B资源评论
