|
1 | | -"""created_users_table |
| 1 | +"""added-verification-auth |
2 | 2 |
|
3 | | -Revision ID: 15770e820938 |
| 3 | +Revision ID: b1ec015461c4 |
4 | 4 | Revises: |
5 | | -Create Date: 2022-07-06 15:11:26.439123 |
| 5 | +Create Date: 2022-08-26 20:35:54.899416 |
6 | 6 |
|
7 | 7 | """ |
8 | 8 | from alembic import op |
9 | 9 | import sqlalchemy as sa |
10 | 10 | from sqlalchemy.dialects import postgresql |
11 | 11 |
|
12 | 12 | # revision identifiers, used by Alembic. |
13 | | -revision = '15770e820938' |
| 13 | +revision = 'b1ec015461c4' |
14 | 14 | down_revision = None |
15 | 15 | branch_labels = None |
16 | 16 | depends_on = None |
|
19 | 19 | def upgrade() -> None: |
20 | 20 | # ### commands auto generated by Alembic - please adjust! ### |
21 | 21 | op.create_table('users', |
22 | | - sa.Column('id', postgresql.UUID(), server_default=sa.text('uuid_generate_v4()'), nullable=False), |
| 22 | + sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False), |
23 | 23 | sa.Column('name', sa.String(), nullable=False), |
24 | 24 | sa.Column('email', sa.String(), nullable=False), |
25 | 25 | sa.Column('password', sa.String(), nullable=False), |
26 | 26 | sa.Column('photo', sa.String(), nullable=True), |
27 | 27 | sa.Column('verified', sa.Boolean(), server_default='False', nullable=False), |
| 28 | + sa.Column('verification_code', sa.String(), nullable=True), |
28 | 29 | sa.Column('role', sa.String(), server_default='user', nullable=False), |
29 | 30 | sa.Column('created_at', sa.TIMESTAMP(timezone=True), server_default=sa.text('now()'), nullable=False), |
30 | 31 | sa.Column('updated_at', sa.TIMESTAMP(timezone=True), server_default=sa.text('now()'), nullable=False), |
31 | 32 | sa.PrimaryKeyConstraint('id'), |
32 | | - sa.UniqueConstraint('email') |
| 33 | + sa.UniqueConstraint('email'), |
| 34 | + sa.UniqueConstraint('verification_code') |
33 | 35 | ) |
34 | 36 | # ### end Alembic commands ### |
35 | 37 |
|
|
0 commit comments