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 realize the second 2 are reaches but I figured I would try anyway. Thoughts? - Drew
