Hi All, On Wed, Mar 17, 2010 at 7:58 PM, Roy Lyseng <[email protected]> wrote: > Do as we did once: Use UPDATED for data and MODIFIED for metadata.
why "MODIFIED" and not "ALTERED" ? the other identifiers seem to follow the SQL verb, except this one.... > > Just make it consistently throughout. > > Likewise, we used INSERTED for data and CREATED for metadata. > > Thanks, > Roy >> >> -jay >> >> p.s. UUID or ID is also fine with me... >> >> On Wed, Mar 17, 2010 at 2:01 PM, Brian Aker <[email protected]> wrote: >>> >>> Hi! >>> >>> Unless Jay you disagree with Ronald, I am going to go with his >>> suggestion. >>> >>> BTW one other field I want to add is UUID. Basically I want to have this >>> around to have an identifier with each object that I can be 100% sure >>> when >>> doing comparisons that I am dealing with the same thing. >>> >>> Any thoughts on that? >>> >>> Cheers, >>> -Brian >>> >>> On Mar 17, 2010, at 9:55 AM, Ronald Bradford wrote: >>> >>>> Not sure of the tables in question, but the use of type identifier in >>>> names is kinda old. >>>> Drizzle is about all things new and shiny. >>>> >>>> Could I recommend from a architect position, "created" and >>>> "last_updated" are self describing. >>>> >>>> Ronald >>>> >>>> On Wed, Mar 17, 2010 at 3:32 AM, Jay Pipes <[email protected]> wrote: >>>> Hi, Brian! >>>> >>>> I really like what you're doing with the latest DDL things by adding a >>>> create and update timestamp to tables in the data dictionary! >>>> >>>> My quick suggestion is to make the fields a little more grammatically >>>> consistent. Currently, you have the fields as creation_timestamp and >>>> update_timestamp. I'd recommend either going with one or the other of >>>> the following: >>>> >>>> created_timestamp >>>> updated_timestamp >>>> >>>> -or- >>>> >>>> create_timestamp >>>> update_timestamp >>>> >>>> Just for consistency's sake. :) >>>> >>>> Other than that, really jazzed about the new DDL changes... woot. >>>> >>>> -jay >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~drizzle-discuss >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL", http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470484322.html _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
