"""
Add the organization table.

Revision ID: 628c53b07
Revises: <KEY>
Create Date: 2018-03-15 11:00:50.420618
"""

import sqlalchemy as sa
from alembic import op

revision = "<KEY>"
down_revision = "<KEY>"


def upgrade():
    op.create_table(
        "organization",
        sa.Column("id", sa.Integer, autoincrement=True, primary_key=True),
        sa.Column("created", sa.DateTime, server_default=sa.func.now(), nullable=False),
        sa.Column("updated", sa.DateTime, server_default=sa.func.now(), nullable=False),
        sa.Column("name", sa.UnicodeText, nullable=False, index=True),
        sa.Column("logo", sa.UnicodeText),
        sa.Column("authority", sa.UnicodeText, nullable=False),
        sa.Column("pubid", sa.Text, unique=True, nullable=False),
    )


def downgrade():
    op.drop_table("organization")

"""
Add the organization table.

Revision ID: 628c53b07
Revises: <KEY>
Create Date: 2018-03-15 11:00:50.420618
"""

import sqlalchemy as sa
from alembic import op

revision = "<KEY>"
down_revision = "<KEY>"


def upgrade():
    op.create_table(
        "organization",
        sa.Column("id", sa.Integer, autoincrement=True, primary_key=True),
        sa.Column("created", sa.DateTime, server_default=sa.func.now(), nullable=False),
        sa.Column("updated", sa.DateTime, server_default=sa.func.now(), nullable=False),
        sa.Column("name", sa.UnicodeText, nullable=False, index=True),
        sa.Column("logo", sa.UnicodeText),
        sa.Column("authority", sa.UnicodeText, nullable=False),
        sa.Column("pubid", sa.Text, unique=True, nullable=False),
    )


def downgrade():
    op.drop_table("organization")

Add the organization table.  Revision ID: 628c53b07 Revises: <KEY> Create Date: 2018-03-15 11:00:50.420618