"""init2

Revision ID: 69b85d86968f
Revises: 9f83e778144c
Create Date: 2017-09-25 17:36:03.015859

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '69b85d86968f'
down_revision = '9f83e778144c'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('users', sa.Column('about_me', sa.Text(), nullable=True))
    op.add_column('users', sa.Column('colleage', sa.String(length=64), nullable=True))
    op.add_column('users', sa.Column('last_seen', sa.DateTime(), nullable=True))
    op.add_column('users', sa.Column('major', sa.String(length=64), nullable=True))
    op.add_column('users', sa.Column('member_since', sa.DateTime(), nullable=True))
    op.add_column('users', sa.Column('nick', sa.String(length=64), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('users', 'nick')
    op.drop_column('users', 'member_since')
    op.drop_column('users', 'major')
    op.drop_column('users', 'last_seen')
    op.drop_column('users', 'colleage')
    op.drop_column('users', 'about_me')
    # ### end Alembic commands ###
