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%[email protected]> >>>>>> 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%[email protected]> >>>>> 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%[email protected]> >>>> 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%[email protected]> >>> 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%[email protected]> >> 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%[email protected]> > 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
