@@ -0,0 +1,1249 @@
+%22%22%22Adds TimeExercisesHistory and TimeExercisesTaxonomy Tables%0A%0ARevision ID: 7791f2c862d2%0ARevises: 56630a78dca0%0ACreate Date: 2017-07-30 20:40:17.174425%0A%0A%22%22%22%0Afrom alembic import op%0Aimport sqlalchemy as sa%0A%0A%0A# revision identifiers, used by Alembic.%0Arevision = '7791f2c862d2'%0Adown_revision = '56630a78dca0'%0Abranch_labels = None%0Adepends_on = None%0A%0A%0Adef upgrade():%0A    op.create_table('time_exercises_taxonomy',%0A    sa.Column('id', sa.Integer(), nullable=False),%0A    sa.Column('name', sa.String(), nullable=False),%0A    sa.PrimaryKeyConstraint('id'),%0A    sa.UniqueConstraint('name')%0A    )%0A    op.create_table('time_exercises_history',%0A    sa.Column('id', sa.Integer(), nullable=False),%0A    sa.Column('user_id', sa.Integer(), nullable=False),%0A    sa.Column('exercise_id', sa.Integer(), nullable=True),%0A    sa.Column('distance', sa.Float(), nullable=True),%0A    sa.Column('duration', sa.Float(), nullable=True),%0A    sa.Column('exercise_date', sa.DateTime(), nullable=True),%0A    sa.ForeignKeyConstraint(%5B'exercise_id'%5D, %5B'time_exercises_history.id'%5D, ),%0A    sa.ForeignKeyConstraint(%5B'user_id'%5D, %5B'users.id'%5D, ),%0A    sa.PrimaryKeyConstraint('id')%0A    )%0A%0A%0Adef downgrade():%0A    op.drop_table('time_exercises_history')%0A    op.drop_table('time_exercises_taxonomy')%0A

Upgrade to add Time based exercises tables