Stephen Adkins wrote:
>
> Hi,
>
> >> - some db systems has restrictions on name-length of database-objects, e.g.
> >> Informix 18 chars (lowercase) on all objects (tables, columns, views, ...)
> >>
> >> So here a shorter prefix instead of Turbine would do better.
>
> This is a great point worth considering.
> However, it may still work. (read below)
>
> >Ugh. -1 on supporting databases with arbitrary restrictions like this
> >(i.e. broken).
>
> These databases are not broken. They are that way because the SQL spec
> only calls for 18 characters. Oracle only recognizes the first 18
> characters, although it allows you to provide additional characters.
We should give up on those databases too easily :)
> In fact, I suggest that you make sure that all table names are unique in
> the first 14 characters. This is because it is common to have other
> database objects (indexes, etc.) which need to be unique in the first
> 18 chars. Thus, a table name like TurbineUserGroupRole would often be
> accompanied by a set of indexes named
>
> TurbineUserGroupRole_PK
> TurbineUserGroupRole_AK1
> TurbineUserGroupRole_IE2
>
> These will not work in Oracle because they are not unique in the first
> 18 characters. Rather, an autogenerating tool might truncate the table
> name to 14 characters in order to have room for the suffix like so.
>
> TurbineUserGro_PK
> TurbineUserGro_AK1
> TurbineUserGro_IE2
What about even shorter notatoin, something like
TurbineU_PK
TurbineR_PK
TurbineG_PK
TurbineP_PK
TurbineUGR_FK_U
TurbineUGR_FK_G
TurbineUGR_FK_R
TurbineRP_FK_R
TurbineRP_FK_P
+ namespace safe
+ no ambiguity
+ no truncated names
Thoughts?
Rafal
--
Rafal Krzewski
Senior Internet Developer
mailto:[EMAIL PROTECTED]
+48 22 8534830 http://e-point.pl
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
