From d2cb17038b8537a609be06be2ed7013dbe27117e Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Mon, 8 Mar 2021 22:11:55 +0100 Subject: beginning the BIG refactor. moving editor stuff into per-episode hierarchy --- ...3082204_add_episode_project_field_everywhere.py | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 animism-align/cli/app/sql/versions/202103082204_add_episode_project_field_everywhere.py (limited to 'animism-align/cli/app/sql/versions') diff --git a/animism-align/cli/app/sql/versions/202103082204_add_episode_project_field_everywhere.py b/animism-align/cli/app/sql/versions/202103082204_add_episode_project_field_everywhere.py new file mode 100644 index 0000000..ea672fd --- /dev/null +++ b/animism-align/cli/app/sql/versions/202103082204_add_episode_project_field_everywhere.py @@ -0,0 +1,31 @@ +"""add episode/project field everywhere + +Revision ID: 639488f6e800 +Revises: 0664d913e352 +Create Date: 2021-03-08 22:04:58.133358 + +""" +from alembic import op +import sqlalchemy as sa +import sqlalchemy_utc + + +# revision identifiers, used by Alembic. +revision = '639488f6e800' +down_revision = '0664d913e352' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.add_column('episode', sa.Column('project_id', sa.Integer(), nullable=True)) + op.add_column('paragraph', sa.Column('episode_id', sa.Integer(), nullable=True)) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_column('paragraph', 'episode_id') + op.drop_column('episode', 'project_id') + # ### end Alembic commands ### -- cgit v1.2.3-70-g09d2