Oh, that's easy. Thanks! Joelle
Voxland, Nathan wrote: > Liquibase should just pass what you put in as a datatype straight > through to the SQL, so you should be able to specify a datatype of > "timestamp default current_timestamp on update current_timestamp" > > If it doesn't work, you can always fall back to the <sql> tag and > specify exactly the sql you want. > > Nathan > > -----Original Message----- > From: Joelle Tegwen [mailto:tegwe...@umn.edu] > Sent: Monday, January 26, 2009 12:23 PM > To: liquibase-user@lists.sourceforge.net > Subject: [Liquibase-user] Mysql Timestamp > > In Mysql it's possible to have a Timestamp column have the property "on > update current_timestamp". (This updates the value of the field for each > > update.) > > Auto-initialization and auto-update: > ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP > > http://dev.mysql.com/doc/refman/5.0/en/timestamp.html > > Is this supported? I couldn't find any reference to this in the > documentation, but I wanted to check in case I missed something. > > Thanks > Joelle > > > ------------------------------------------------------------------------ > ------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > -- The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time. - Tom Cargill of Bell Labs ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user
