<commit_before>"""Added message table

Revision ID: 3f282468e66e
Revises: 58cdd<PASSWORD>
Create Date: 2014-07-29 18:00:47.003786

"""

# revision identifiers, used by Alembic.
revision = '3f282468e66e'
down_revision = '4f167529e567'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table(
        'message',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('message', sa.Unicode(), nullable=True),
        sa.Column('subject', sa.Unicode(), nullable=True),
        sa.Column('from_user_id', sa.BigInteger(), nullable=True),
        sa.Column('to_user_id', sa.BigInteger(), nullable=True),
        sa.Column('date', sa.DateTime(), nullable=True),
        sa.Column('read', sa.Boolean(), nullable=True),
        sa.ForeignKeyConstraint(['from_user_id'], ['users.id'], ),
        sa.ForeignKeyConstraint(['to_user_id'], ['users.id'], ),
        sa.PrimaryKeyConstraint('id')
    )


def downgrade():
    op.drop_table('message')<commit_msg>Resolving alembic branches conflicts<commit_after>"""Added message table

Revision ID: 3f282468e66e
Revises: <PASSWORD>
Create Date: 2014-07-29 18:00:47.003786

"""

# revision identifiers, used by Alembic.
revision = '3f282468e66e'
down_revision = '<PASSWORD>'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table(
        'message',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('message', sa.Unicode(), nullable=True),
        sa.Column('subject', sa.Unicode(), nullable=True),
        sa.Column('from_user_id', sa.BigInteger(), nullable=True),
        sa.Column('to_user_id', sa.BigInteger(), nullable=True),
        sa.Column('date', sa.DateTime(), nullable=True),
        sa.Column('read', sa.Boolean(), nullable=True),
        sa.ForeignKeyConstraint(['from_user_id'], ['users.id'], ),
        sa.ForeignKeyConstraint(['to_user_id'], ['users.id'], ),
        sa.PrimaryKeyConstraint('id')
    )


def downgrade():
    op.drop_table('message')
{'fraction_non_alphanumeric': 0.165, 'fraction_numerical': 0.044, 'mean_word_length': 3.9285714285714284, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, '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': '4148206', 'n_tokens_mistral': 718, 'n_tokens_neox': 658, 'n_words': 126}