diff options
| -rw-r--r-- | mediagoblin/plugins/persona/migrations/c7d4840a5592_persona_plugin_initial_migration.py | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mediagoblin/plugins/persona/migrations/c7d4840a5592_persona_plugin_initial_migration.py b/mediagoblin/plugins/persona/migrations/c7d4840a5592_persona_plugin_initial_migration.py new file mode 100644 index 00000000..0c40893a --- /dev/null +++ b/mediagoblin/plugins/persona/migrations/c7d4840a5592_persona_plugin_initial_migration.py @@ -0,0 +1,35 @@ +"""Persona plugin initial migration + +Revision ID: c7d4840a5592 +Revises: 52bf0ccbedc1 +Create Date: 2016-03-12 23:30:33.624390 + +""" + +# revision identifiers, used by Alembic. +revision = 'c7d4840a5592' +down_revision = '52bf0ccbedc1' +branch_labels = ('persona_plugin',) +depends_on = None + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + if op.get_bind().engine.has_table('persona__user_emails'): + # Skip; this has already been instantiated + # (probably via sqlalchemy-migrate) + return + + op.create_table( + 'persona__user_emails', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('persona_email', sa.Unicode(), nullable=False), + sa.Column('user_id', sa.Integer(), nullable=False), + sa.ForeignKeyConstraint(['user_id'], ['core__users.id'], ), + sa.PrimaryKeyConstraint('id')) + + +def downgrade(): + op.drop_table('persona__user_emails') |