36 lines
940 B
Python
36 lines
940 B
Python
|
|
## File autogenerated by genmodel.py
|
|
|
|
from sqlalchemy import *
|
|
|
|
|
|
meta = MetaData()
|
|
|
|
mails = Table('mails', meta,
|
|
Column('created_at', TIMESTAMP, nullable=False),
|
|
Column('updated_at', TIMESTAMP, nullable=False),
|
|
Column('id', INTEGER, primary_key=True, nullable=False),
|
|
Column('date', DATETIME),
|
|
Column('envelope', TEXT),
|
|
Column('body', TEXT),
|
|
Column('text', TEXT),
|
|
Column('from_', TEXT),
|
|
Column('from_mailbox', VARCHAR),
|
|
Column('from_host', VARCHAR),
|
|
Column('to_', TEXT),
|
|
Column('to_mailbox', TEXT),
|
|
Column('to_host', VARCHAR),
|
|
Column('subject', TEXT),
|
|
)
|
|
|
|
threads = Table('threads', meta,
|
|
Column('created_at', TIMESTAMP, nullable=False),
|
|
Column('updated_at', TIMESTAMP, nullable=False),
|
|
Column('id', INTEGER, primary_key=True, nullable=False),
|
|
Column('firstmail', INTEGER),
|
|
Column('islabeled', BOOLEAN),
|
|
Column('opened', BOOLEAN),
|
|
Column('body', TEXT),
|
|
)
|
|
|