diff options
| author | Pierre-Yves Chibon <pingou@pingoured.fr> | 2012-04-25 19:25:34 +0200 |
|---|---|---|
| committer | Pierre-Yves Chibon <pingou@pingoured.fr> | 2012-04-25 19:25:34 +0200 |
| commit | a875892b35a60fb44d97e269e86afa13374f985b (patch) | |
| tree | 8807b0c3556ba3bfdc30f28e604470a22ca7fab7 | |
| parent | 1a8993a312fb6636d98f59014d11ec2552cda498 (diff) | |
Add indexes to the table structure
| -rw-r--r-- | kittystore/sastore.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/kittystore/sastore.py b/kittystore/sastore.py index b415f27..f63ee7c 100644 --- a/kittystore/sastore.py +++ b/kittystore/sastore.py @@ -39,15 +39,15 @@ class Email(Base): __tablename__ = 'email' id = Column(Integer, primary_key=True) - list_name = Column(String(50), nullable=False) + list_name = Column(String(50), nullable=False, index=True) sender = Column(String(100), nullable=False) email = Column(String(75), nullable=False) - subject = Column(Text, nullable=False) - content = Column(Text, nullable=False) - date = Column(DateTime) + subject = Column(Text, nullable=False, index=True) + content = Column(Text, nullable=False, index=True) + date = Column(DateTime, index=True) message_id = Column(String(150), unique=True, nullable=False) stable_url_id = Column(String(250), unique=True, nullable=False) - thread_id = Column(String(150), nullable=False) + thread_id = Column(String(150), nullable=False, index=True) references = Column(Text) full = Column(Text) |