a09f820cbc93_create_user_table.py 文件源码

def upgrade():

    connection = op.get_bind()
    connection.execute('CREATE EXTENSION IF NOT EXISTS "uuid-ossp";')

    op.create_table(
        'users',
        sa.Column('id', postgresql.UUID, server_default=sa.text('uuid_generate_v1()'), primary_key=True),
        sa.Column('name', sa.Text, nullable=False, unique=True),
        sa.Column('password', sa.Text, nullable=False),
        sa.Column('modified', sa.DateTime, server_default=sa.text('clock_timestamp()')),
        sa.Column('created', sa.DateTime, server_default=sa.text('now()')),
    )