I have hit this as well in a Linux/mySQL environment. I actually had to modify core to fix some "farFu" vs "farFU" cases. I would be nice if the casing didn't change from 6 to 6.1
On Sep 28, 1:38 am, Michael Sharman <[email protected]> wrote: > This type of utility might be ok for custom type, but not for core > types. The core codebase should know what the table names are > (including the correct case), and considering it (the core codebase) > is the only thing which controls DDL statements everything should be > ok. I think this is what needs to be sorted out first...the official > map of core table names (and corresponding class names). > > On Sep 28, 3:30 pm, AJ Mercer <[email protected]> wrote: > > > > > maybe create an Admin utility than can be manually run on all types/rules? > > > On 28 September 2010 13:13, Blair McKenzie <[email protected]> wrote: > > > > SQL server does. Then the trick is going to be knowing when it is > > > warranted. Is it only for fixing table case? > > > > On Tue, Sep 28, 2010 at 2:55 PM, AJ Mercer <[email protected]> wrote: > > > >> mySQL has a statement to do this is one hit > > >> http://dev.mysql.com/doc/refman/5.0/en/rename-table.html > > > >> I would expect other engines do as well? > > > >> On 28 September 2010 12:23, Blair McKenzie <[email protected]> wrote: > > > >>> I would have to drop the table then recreate it, presumably querying > > >>> first then re-inserting every record afterwards. Not sure how practical > > >>> that > > >>> is. > > > >>> On Tue, Sep 28, 2010 at 1:46 PM, AJ Mercer <[email protected]> wrote: > > > >>>> Blair, > > > >>>> can you add a alterTable to change table name to match the casing of > > >>>> the > > >>>> filename? > > > >>>> On 28 September 2010 11:35, Blair McKenzie <[email protected]> wrote: > > > >>>>> I did the refactoring on a Linux desktop. Of course I may have turned > > >>>>> of case sensitivity sometime in the distant past, so I can't be > > >>>>> certain it > > >>>>> won't be a problem. If it turns out case is still an issue I would > > >>>>> personally prefer that the case of the table match the case of the > > >>>>> component. > > > >>>>> Blair > > > >>>>> On Tue, Sep 28, 2010 at 1:12 PM, Michael Sharman > > >>>>> <[email protected]>wrote: > > > >>>>>> I have a farcry 5.2.7 project which I've upgraded to 6.1 but have > > >>>>>> noticed that a lot of the table names have changed case from what > > >>>>>> they > > >>>>>> were previously (after updating the coapi). > > > >>>>>> Tables like: > > >>>>>> dmarchive (was dmArchive) > > >>>>>> dmevent (was dmEvent) > > >>>>>> etc > > > >>>>>> We've previously had a few issues with database table names as we run > > >>>>>> on Linux, I'm on a mac at the moment so I can't do a test yet. My > > >>>>>> question...is this correct? Is there a naming "convention" for > > >>>>>> database tables, at least the core ones? I have a funny feeling if I > > >>>>>> ran this on linux it would fail. > > > >>>>>> Should the naming convention be headless camel case; so dmImage > > >>>>>> instead of dmimage etc? Same for any far** prefixed tables. > > > >>>>>> Thanks. > > > >>>>>> -- > > >>>>>> You received this message cos you are subscribed to "farcry-dev" > > >>>>>> Google group. > > >>>>>> To post, email: [email protected] > > >>>>>> To unsubscribe, email: > > >>>>>> [email protected]<farcry-dev%2bunsubscr...@googlegrou > > >>>>>> ps.com> > > >>>>>> For more options:http://groups.google.com/group/farcry-dev > > >>>>>> -------------------------------- > > >>>>>> Follow us on Twitter:http://twitter.com/farcry > > > >>>>> -- > > >>>>> You received this message cos you are subscribed to "farcry-dev" > > >>>>> Google > > >>>>> group. > > >>>>> To post, email: [email protected] > > >>>>> To unsubscribe, email: > > >>>>> [email protected]<farcry-dev%2bunsubscr...@googlegrou > > >>>>> ps.com> > > >>>>> For more options:http://groups.google.com/group/farcry-dev > > >>>>> -------------------------------- > > >>>>> Follow us on Twitter:http://twitter.com/farcry > > > >>>> -- > > > >>>> *AJ Mercer* > > >>>> <webonix:net strength="Industrial" /> <http://webonix.net> | > > >>>> <webonix:org > > >>>> community="Open" /> <http://webonix.org> > > >>>>http://twitter.com/webonix > > > >>>> -- > > >>>> You received this message cos you are subscribed to "farcry-dev" Google > > >>>> group. > > >>>> To post, email: [email protected] > > >>>> To unsubscribe, email: > > >>>> [email protected]<farcry-dev%2bunsubscr...@googlegrou > > >>>> ps.com> > > >>>> For more options:http://groups.google.com/group/farcry-dev > > >>>> -------------------------------- > > >>>> Follow us on Twitter:http://twitter.com/farcry > > > >>> -- > > >>> You received this message cos you are subscribed to "farcry-dev" Google > > >>> group. > > >>> To post, email: [email protected] > > >>> To unsubscribe, email: > > >>> [email protected]<farcry-dev%2bunsubscr...@googlegrou > > >>> ps.com> > > >>> For more options:http://groups.google.com/group/farcry-dev > > >>> -------------------------------- > > >>> Follow us on Twitter:http://twitter.com/farcry > > > >> -- > > > >> *AJ Mercer* > > >> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org > > >> community="Open" /> <http://webonix.org> > > >>http://twitter.com/webonix > > > >> -- > > >> You received this message cos you are subscribed to "farcry-dev" Google > > >> group. > > >> To post, email: [email protected] > > >> To unsubscribe, email: > > >> [email protected]<farcry-dev%2bunsubscr...@googlegrou > > >> ps.com> > > >> For more options:http://groups.google.com/group/farcry-dev > > >> -------------------------------- > > >> Follow us on Twitter:http://twitter.com/farcry > > > > -- > > > You received this message cos you are subscribed to "farcry-dev" Google > > > group. > > > To post, email: [email protected] > > > To unsubscribe, email: > > > [email protected]<farcry-dev%2bunsubscr...@googlegrou > > > ps.com> > > > For more options:http://groups.google.com/group/farcry-dev > > > -------------------------------- > > > Follow us on Twitter:http://twitter.com/farcry > > > -- > > > *AJ Mercer* > > <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org > > community="Open" /> <http://webonix.org>http://twitter.com/webonix -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
