Hi Eric, Thanks, is actually looked up in Header table before (and now again) but the to and from parts are not present there. other headers are there like Subject and Return-Path, but no to or from headers. and it was also interesting for me to know why to store headers like this? why not to store them in columns in message table?
Thanks MN ________________________________________ PHP & ASP .Net 3.5 web developer Java & C# desktop developer www.mohamnag.com On Sun, Nov 14, 2010 at 3:59 PM, Eric Charles <[email protected]> wrote: > Hi Mohammad, > > You can find the generated database schema here: > > https://svn.apache.org/repos/asf/james/server/trunk/src/site/resources/images/database/james-database-schema-derby.png > (will be on M2 web site, with more info) > > The users is in the JAMESUSER table. > Depending on your virtualHosting config, JAMESUSER.NAME is the email > address (or the user part that must be completed with a domain). > > The user has MAILBOXes via the SUBSCRIPTION table. > > The email are in MESSAGE (belonging to a MAILBOX via MEMBERSHIP). You have > to look in the HEADER table to get all the detailled infos (from, to, cc, > bcc,...). > > Tks, > > Eric > > > > On 14/11/2010 12:16, Mohammad Naghavi wrote: > >> Hi every body, >> I installed and worked with james 3 m1 with a mysql backend. now what I >> wanted to ask is to get as much information about db structure as >> possible. >> for example I sent an email from server to itself using telnet and >> I received the mail correctly but now I find no where in db that sender >> and >> receiver's email address are stored! or what I need to know is how to add >> a >> user directly in database? >> >> Thanks in advance, >> MN >> ________________________________________ >> PHP& ASP .Net 3.5 web developer >> Java& C# desktop developer >> www.mohamnag.com >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
