# a pending username triggering a username taken error.
Column('invalid', Boolean(), server_default='f', nullable=False),
Column('invalid_email_addr',
String(length=100),
nullable=True,
server_default=None),
Column('ip_address_signup_request', String(length=39), nullable=True),
)
media = Table(
'media',
metadata,
Column('mediaid', Integer(), primary_key=True, nullable=False),
Column('file_type', String(length=8), nullable=False),
Column('attributes',
JSONValuesColumn(),
nullable=False,
server_default=text(u"''::hstore")),
Column('sha256', String(length=64)),
)
Index('ind_media_sha256', media.c.sha256)
media_media_links = Table(
'media_media_links',
metadata,
Column('linkid', Integer(), primary_key=True, nullable=False),
Column('described_with_id', Integer(), nullable=False),
Column('describee_id', Integer(), nullable=False),
Column('link_type', String(length=32), nullable=False),
default_fkey(['describee_id'], ['media.mediaid'],
logininvite = Table(
'logininvite', metadata,
Column('email', String(length=200), primary_key=True, nullable=False),
Column('userid', Integer(), nullable=False),
Column('unixtime', WeasylTimestampColumn(), nullable=False),
Column('settings', String(length=20), nullable=False, server_default=''),
)
media = Table(
'media', metadata,
Column('mediaid', Integer(), primary_key=True, nullable=False),
Column('media_type', String(length=32), nullable=False),
Column('file_type', String(length=8), nullable=False),
Column('attributes', JSONValuesColumn(), nullable=False, server_default=text(u"''::hstore")),
Column('sha256', String(length=64)),
)
media_media_links = Table(
'media_media_links', metadata,
Column('linkid', Integer(), primary_key=True, nullable=False),
Column('described_with_id', Integer(), nullable=False),
Column('describee_id', Integer(), nullable=False),
Column('link_type', String(length=32), nullable=False),
Column('attributes', JSONValuesColumn(), nullable=False, server_default=text(u"''::hstore")),
default_fkey(['describee_id'], ['media.mediaid'], name='media_media_links_describee_id_fkey'),
default_fkey(['described_with_id'], ['media.mediaid'], name='media_media_links_described_with_id_fkey'),
)