"""Add services table

Revision ID: 001
Revises: 001
Create Date: 2020-09-02
"""

# revision identifiers, used by Alembic.
revision = '001'
down_revision = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table(
        'services',
        sa.Column('created_at', sa.DateTime()),
        sa.Column('updated_at', sa.DateTime(), nullable=True),
        sa.Column('deleted_at', sa.DateTime(), nullable=True),
        sa.Column('id', sa.Integer(), autoincrement=True),
        sa.Column('uuid', sa.String(length=36)),
        sa.Column('host',  sa.VARCHAR(length=255)),
        sa.Column('binary', sa.VARCHAR(length=255)),
        sa.Column('topic', sa.VARCHAR(length=255)),
        sa.Column('report_count', sa.Integer(), default=0),
        sa.Column('disabled', sa.Integer(), default=0),
        sa.Column('deleted', sa.Integer(), default=0),
        sa.Column('disabled_reason', sa.String(length=255)),
        sa.Column('last_seen_up', sa.DateTime()),
        sa.Column('forced_down', sa.Integer(), default=0),
        sa.Column('version', sa.String(length=36), default=0),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('host', 'topic', 'deleted',),
        sa.UniqueConstraint('host', 'binary', 'deleted',),
        sa.UniqueConstraint('uuid'),
        sa.CheckConstraint('disabled IN (0,1)')
    )