a9ecd1c767_add_pro_field_to_user_table.py 472 Bytes
Edit Raw Blame History Permalink



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24


"""add pro field to user table

Revision ID: a9ecd1c767
Revises: 66594a9866c
Create Date: 2014-11-05 10:31:37.734790

"""

# revision identifiers, used by Alembic.
revision = 'a9ecd1c767'
down_revision = '66594a9866c'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('user', sa.Column('pro', sa.Boolean, default=False))
    query = 'UPDATE "user" SET pro=false;'
    op.execute(query)


def downgrade():
    op.drop_column('user', 'pro')