Re: Database table names

Hi,
IMAP-228 and IMAP-233 will be my first dev todo on 2011 (end-of 2010 is a bit busy here).
See my comments on JIRAs
tks,
Eric


On 30/12/2010 16:08, Norman Maurer wrote:
> 2010/12/30 Eric Charles<[email protected]>:
>> Hi,
>>
>> There are 2 opened JIRA for this:
>> https//issues.apache.org/jira/browse/IMAP-228 Name JPA Database Tables and
>> Columns
> I think we should fix this before M3 ...
>
>
>> https://issues.apache.org/jira/browse/IMAP-233 jpa mapping files
> To be honest I'm -0 for this patch. I think it makes sense to have the
> queries specified in the annotations. Move it to an extra xml file
> will just force us to mantain one more. If a dev want to change the
> query he should just override the needed methods..
>
>
>> 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.
>>
>> Tks,
>>
>> Eric
>>
>> 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]>
>>> To: [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.
>>>>
>>
>
> Bye.
> Norman