<commit_before>"""Add snapshot model

Revision ID: 2191c871434
Revises: 19168fe64c41
Create Date: 2014-07-17 17:21:42.915797

"""

# revision identifiers, used by Alembic.
revision = '2191c871434'
down_revision = '19168fe64c41'

from alembic import op
import sqlalchemy as sa

def upgrade():
    op.create_table(
        'snapshot',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=True),
        sa.Column('status', sa.Enum(), server_default='0', nullable=False),
        sa.Column('url', sa.String(length=200), nullable=True),
        sa.ForeignKeyConstraint(['build_id'], ['build.id'], ),
        sa.ForeignKeyConstraint(['project_id'], ['project.id'], ondelete='CASCADE'),<commit_msg>Minor lint<commit_after>"""Add snapshot model

Revision ID: 2191c871434
Revises: 19168fe64c41
Create Date: 2014-07-17 17:21:42.915797

"""

# revision identifiers, used by Alembic.
revision = '2191c871434'
down_revision = '19168fe64c41'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table(
        'snapshot',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=True),
        sa.Column('status', sa.Enum(), server_default='0', nullable=False),
        sa.Column('url', sa.String(length=200), nullable=True),
        sa.ForeignKeyConstraint(['build_id'], ['build.id'], ),
        sa.ForeignKeyConstraint(['project_id'], ['project.id'], ondelete='CASCADE'),
{'fraction_non_alphanumeric': 0.165, 'fraction_numerical': 0.0775, 'mean_word_length': 4.2838283828382835, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '6738867', 'n_tokens_mistral': 619, 'n_tokens_neox': 541, 'n_words': 108}