<commit_before>"""create jobs table

Revision ID: 34a1034caa3b
Revises: <PASSWORD>
Create Date: 2013-11-02 00:30:42.855428

"""
from alembic import op
import sqlalchemy as sa


revision = '34a1034caa3b'
down_revision = '34<PASSWORD>4<PASSWORD>'


def upgrade():
    """Creates the `jobs` table."""
    op.create_table(
        'jobs',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('created', sa.DateTime(timezone=True)),
        sa.Column('title', sa.Unicode(100), nullable=False),
        sa.Column('slug', sa.Unicode(125), nullable=False, unique=True, index=True),
        sa.Column('description', sa.UnicodeText, nullable=True),
        sa.Column('contact_method', sa.Integer, nullable=False),
        sa.Column('contact_email', sa.Unicode(150), nullable=True),
        sa.Column('contact_url', sa.Unicode(200), nullable=True),
        sa.Column('job_type', sa.Integer, nullable=False),
        sa.Column('remote_work', sa.Boolean, nullable=False, default=False),
        sa.Column('company_id',
                  sa.Integer,
                  sa.ForeignKey('companies.id'),
                  nullable=False),
        sa.Column('location_id',
                  sa.Integer,
                  sa.ForeignKey('locations.id'),
                  nullable=False),
    )


def downgrade():
    """Drops the `jobs` table."""
    op.drop_table('jobs')<commit_msg>Updare Job model schema with remote_work as integer<commit_after>"""create jobs table

Revision ID: 34a1034caa3b
Revises: <PASSWORD>
Create Date: 2013-11-02 00:30:42.855428

"""
from alembic import op
import sqlalchemy as sa


revision = '34a1034caa3b'
down_revision = '34b87469a386'


def upgrade():
    """Creates the `jobs` table."""
    op.create_table(
        'jobs',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('created', sa.DateTime(timezone=True)),
        sa.Column('title', sa.Unicode(100), nullable=False),
        sa.Column('slug', sa.Unicode(125), nullable=False, unique=True, index=True),
        sa.Column('description', sa.UnicodeText, nullable=True),
        sa.Column('contact_method', sa.Integer, nullable=False),
        sa.Column('contact_email', sa.Unicode(150), nullable=True),
        sa.Column('contact_url', sa.Unicode(200), nullable=True),
        sa.Column('job_type', sa.Integer, nullable=False),
        sa.Column('remote_work', sa.Integer, nullable=False, default=False),
        sa.Column('company_id',
                  sa.Integer,
                  sa.ForeignKey('companies.id'),
                  nullable=False),
        sa.Column('location_id',
                  sa.Integer,
                  sa.ForeignKey('locations.id'),
                  nullable=False),
    )


def downgrade():
    """Drops the `jobs` table."""
    op.drop_table('jobs')
{'fraction_non_alphanumeric': 0.1510920157536699, 'fraction_numerical': 0.03759398496240601, 'mean_word_length': 2.8698060941828256, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3011775', 'n_tokens_mistral': 968, 'n_tokens_neox': 880, 'n_words': 164}