From 9bede43b4d1c905bc1b8b06f0ea2ec0358110c62 Mon Sep 17 00:00:00 2001 From: Navan Chauhan Date: Thu, 10 Jun 2021 15:57:17 +0530 Subject: intiial migration script --- migrations/versions/02e90d95b9e8_.py | 39 +++++++++++++++++++++ .../__pycache__/02e90d95b9e8_.cpython-39.pyc | Bin 0 -> 1067 bytes 2 files changed, 39 insertions(+) create mode 100644 migrations/versions/02e90d95b9e8_.py create mode 100644 migrations/versions/__pycache__/02e90d95b9e8_.cpython-39.pyc diff --git a/migrations/versions/02e90d95b9e8_.py b/migrations/versions/02e90d95b9e8_.py new file mode 100644 index 0000000..c65e6ba --- /dev/null +++ b/migrations/versions/02e90d95b9e8_.py @@ -0,0 +1,39 @@ +"""empty message + +Revision ID: 02e90d95b9e8 +Revises: +Create Date: 2021-06-10 15:55:56.198381 + +""" +from alembic import op +import sqlalchemy as sa + + +# revision identifiers, used by Alembic. +revision = '02e90d95b9e8' +down_revision = None +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.create_table('users', + sa.Column('first_name', sa.String(), nullable=True), + sa.Column('last_name', sa.String(), nullable=True), + sa.Column('email', sa.String(length=120), nullable=False), + sa.Column('confirmation', sa.Boolean(), nullable=True), + sa.Column('paid', sa.Boolean(), nullable=True), + sa.Column('role', sa.String(), nullable=True), + sa.Column('team', sa.String(), nullable=True), + sa.Column('login_type', sa.String(), nullable=True), + sa.Column('_password', sa.String(), nullable=True), + sa.PrimaryKeyConstraint('email') + ) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('users') + # ### end Alembic commands ### diff --git a/migrations/versions/__pycache__/02e90d95b9e8_.cpython-39.pyc b/migrations/versions/__pycache__/02e90d95b9e8_.cpython-39.pyc new file mode 100644 index 0000000..50aed8a Binary files /dev/null and b/migrations/versions/__pycache__/02e90d95b9e8_.cpython-39.pyc differ -- cgit v1.2.3