You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@openmeetings.apache.org by "Maxim Solodovnik (Commented) (JIRA)" <ji...@apache.org> on 2012/03/28 15:36:27 UTC

[jira] [Commented] (OPENMEETINGS-107) Unify database schema

    [ https://issues.apache.org/jira/browse/OPENMEETINGS-107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240402#comment-13240402 ] 

Maxim Solodovnik commented on OPENMEETINGS-107:
-----------------------------------------------

I would also suggest to have shorter table/column names. This will help to support oracle (which creates triggers based on table/column name)
                
> Unify database schema
> ---------------------
>
>                 Key: OPENMEETINGS-107
>                 URL: https://issues.apache.org/jira/browse/OPENMEETINGS-107
>             Project: Openmeetings
>          Issue Type: Task
>    Affects Versions: 2.0 Apache Incubator Release
>            Reporter: SebastianWagner
>             Fix For: 2.0 Apache Incubator Release
>
>
> All primary key fields should have an identical pattern.
> Except the MeetMe which we discussed on the mailing list:
> http://mail-archives.apache.org/mod_mbox/incubator-openmeetings-dev/201203.mbox/%3CCACeMiA9uz-Sam0OoY%3DMVjVFqQuFvf4YYtvfe04FqBRZ4WzunVQ%40mail.gmail.com%3E
> I think we can use "id" for the primary key but should use that consequently in all our tables.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira