[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: Database table names Eric Charles Thu Dec 30 01:00:22 2010


There are 2 opened JIRA for this:
https//issues.apache.org/jira/browse/IMAP-228 Name JPA Database Tables and Columns
https://issues.apache.org/jira/browse/IMAP-233 jpa mapping files

The first JIRA is about adding annotations in the JAVA entities to fix the databases and column names so they will be the same for every database vendors. We can discuss if we need to add a JAMES_ prefix to the table names or if we should advice to use a dedicated table space for James database.

The second JIRA is about having external mapping XML files so the administrator could always rename/adapt the database structure and related queries.

Both JIRA need to be implemented before 3.0 release.



PS: I have copied [EMAIL PROTECTED]

On 30/12/2010 03:31, hanasaki wrote:
This is not really an issue.
You can make two name spaces with userIds to access them too:
    - id = jamesSmtp
    - id = liferayPortal

Happy holidays!

-------- Original Message --------
Subject: Database table names
From: Mint Nick <[EMAIL PROTECTED]>
Date: 12/29/2010 07:47 PM

Hello all, So, I've run into a snag, I thought this might be a great
place to propose a change. I'm storing everything onto a PostGre
database and noticed that both James and Liferay have tables named
subscription. Since we are about to release a new version of James,
how about adding prefixes to the tables for enhanced compatibility?
Maybe something as simple as Jsubscription, or AJsubscription? Just a
thought. It would certainly make things easier.