Hi there,
I have recently installed a James Mail server using mysql backend, and
everything is working perfectly. Now what I want is to seperate every inbox
table for each user. I don't want all email to be stored in one single inbox
email due to big amounts of data which is going to be stored in every inbox.
I have done it by defining the inbox configuration like this:
<inboxRepository>
<repository destinationURL="db://mysqlDB/inbox_" type="MAIL"/>
</inboxRepository>
which creates tables like inbox_test for user name as test.
but in this case no email can be saved in tables an I get the some errors
like repositury_name can not be empty.
I think this can be avoided by setting that column as nullable but then the
question is that if it can be managed by James.
Also in this case after deleting a user, its table was not automatically
deleted by James.
Is there any better way of having a separate table for each user?
Thanks in advance
----------------------------------------------------
PHP & ASP .Net 3.5 web developer
Delphi & C# desktop developer
www.mohamnag.com