| 123456789101112131415161718192021222324252627282930313233343536 |
- """Create private column in project table
- Revision ID: 4255158a6913
- Revises: 4df75d40bafa
- Create Date: 2016-06-06 14:33:47.039207
- """
- # revision identifiers, used by Alembic.
- revision = '4255158a6913'
- down_revision = '4df75d40bafa'
- from alembic import op
- import sqlalchemy as sa
- def upgrade():
- ''' Add a private column in the project table
- '''
- op.add_column(
- 'projects',
- sa.Column('private', sa.Boolean, nullable=True, default=False)
- )
- op.execute('''UPDATE "projects" '''
- '''SET private=False;''')
- op.alter_column(
- 'projects',
- column_name='private',
- nullable=False, existing_nullable=True)
- def downgrade():
- ''' Remove the private column
- '''
- op.drop_column('projects', 'private')
|
