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/e
t; If it doesn't work, you can always fall back to the 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.n
This is not really a how to question but more of a should I question.
Do you put your create database, create users, set permissions in the
configuration files? Is this a "best practice"?
If you do:
Do you then create a separate changeset.properties and changeset.xml for
those specific items?
H
gt; Is it "database change management"? Something else?
>
> Probably the biggest thing we need to do is get more incoming links. I
> keep planning on spending more time pushing and writing about liquibase,
> but I keep pushing it off in favor of feature enhancements.
>
This seems like it should be so basic, but I can't figure out what's not
happening. I decided I wanted to tag the database as it is before each
version. That way while I'm doing development on a version it's really
easy to rollback to the beginning. However, the tag doesn't seem to be
happening
Thanks.
I experienced something interesting. Maybe a bug report?
I set up my document like this:
Add an empty changeset so we can tag the beginning state.
I ran the rollback to v0.0 and the builder reported a successful
migration, but all of the tables were still there.
Then I tried ad
I'm sure there's something really obvious I'm missing, but I just can't
figure it out.
I've been using liquibase fine on Ubuntu, but now I'm setting it up on
our test server (windows server 2003) and it won't run. I'm not getting
an error code, just the help text so I'm not sure how to fix wh
older that mysql.jar is in, right?
Thanks
Joelle
Voxland, Nathan wrote:
> What do you have in your changeset.properties file? Is your classpath
> property in there wrong for windows?
>
> Nathan
>
> -Original Message-
> From: Joelle Tegwen [mailto:tegwe...@umn.edu]
Doh.
Thanks for answering my very simple question.
Joelle
Paul Keeble wrote:
> You need to add the path to the jar file in the classpath, the directory is
> not sufficient for it to find the driver.
>
> Paul
>
>
> - Original Message
> From: Joelle Tegw