"""add speculative sc_user

Revision ID: dcaf8627acac
Revises: b2c02f04f5a2
Create Date: 2018-03-27 12:18:42.839675

"""

# revision identifiers, used by Alembic.
revision = 'dcaf8627acac'
down_revision = 'b2c02f04f5a2'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('''insert into sc_users (scid, name, active, not_found_at) values (0, '__SPECULATIVE__', false, now());''')


def downgrade():
    op.execute('''delete from sc_users where scid = 0''')