On Thu, 2004-12-16 at 05:56, Drew Morris wrote: > I would like to propose a couple of additions to the mailboxes table > that would make the processing more efficient both for DBMAIL and for > applications that share the data (like web front-ends). > > 1) Add a "Display Name" field to avoid having to parse it out of the > name field if it is a subfolder > 2) Add a parentid field to store which folder it is a direct child of > (use 0 for none) > 3) Add an OrdinalValue field (this is mostly for web-front ends) but > it would allow certain mailboxes to be "forced" into a position like > Inbox being listed first, Sent-Mail second, etc. > > 4) Path would be a list of ID's with slashes like /1/3/5 where one is > the main parent, 3 is a child and 5 is the next child in line.
I have all this working in my webmail already using not one extra field in the database. Actually nr3 isn't user selectable, the script just makes sure "system" mailboxes appears before the others and those after that are alphabetically sorted. Hopefully I'll be allowed to GPL some of the core code when it's finished. I can think of features MUCH more valuable to webmail usage, such as the separate broken-up headers table. Another thing would be some way of sharing a sent-mail folder and address-book with the IMAP-clients, but I'm still investigating this. GTG, meeting.. -HK
