Column('rating', RatingColumn, nullable=False),
default_fkey(['tagid'], ['searchtag.tagid'], name='blocktag_tagid_fkey'),
default_fkey(['userid'], ['login.userid'], name='blocktag_userid_fkey'),
)
Index('ind_blocktag_userid', blocktag.c.userid)
charcomment = Table(
'charcomment',
metadata,
Column('commentid', Integer(), primary_key=True, nullable=False),
Column('userid', Integer(), nullable=False),
Column('targetid', Integer(), nullable=False),
Column('parentid', Integer(), nullable=False, server_default='0'),
Column('content', String(length=10000), nullable=False),
Column('unixtime', WeasylTimestampColumn(), nullable=False),
Column('settings', String(length=20), nullable=False, server_default=''),
Column('hidden_by', Integer(), nullable=True),
default_fkey(['targetid'], ['character.charid'],
name='charcomment_targetid_fkey'),
default_fkey(['userid'], ['login.userid'], name='charcomment_userid_fkey'),
default_fkey(['hidden_by'], ['login.userid'],
name='charcomment_hidden_by_fkey'),
)
Index('ind_charcomment_targetid_commentid', charcomment.c.targetid,
charcomment.c.commentid)
collection = Table(
'collection',
metadata,
Column('rating', RatingColumn, nullable=False),
default_fkey(['tagid'], ['searchtag.tagid'], name='blocktag_tagid_fkey'),
default_fkey(['userid'], ['login.userid'], name='blocktag_userid_fkey'),
)
Index('ind_blocktag_userid', blocktag.c.userid)
charcomment = Table(
'charcomment', metadata,
Column('commentid', Integer(), primary_key=True, nullable=False),
Column('userid', Integer()),
Column('targetid', Integer()),
Column('parentid', Integer(), nullable=False, server_default='0'),
Column('content', Text(), nullable=False),
Column('unixtime', WeasylTimestampColumn(), nullable=False),
Column('indent', Integer(), nullable=False, server_default='0'),
Column('settings', String(length=20), nullable=False, server_default=''),
Column('hidden_by', Integer(), nullable=True),
default_fkey(['targetid'], ['character.charid'], name='charcomment_targetid_fkey'),
default_fkey(['userid'], ['login.userid'], name='charcomment_userid_fkey'),
default_fkey(['hidden_by'], ['login.userid'], name='charcomment_hidden_by_fkey'),
)
Index('ind_charcomment_targetid', charcomment.c.targetid)
collection = Table(
'collection', metadata,
Column('userid', Integer(), primary_key=True, nullable=False),
Column('submitid', Integer(), primary_key=True, nullable=False),