Yep, going with Ron's suggestions, you could do: CREATED LAST_UPDATED
But, as Jobin mentioned, would LAST_UPDATED be construed as last time data in the table changed or last time the DDL or the table changed? -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
