When liquibase starts it first checks for the databasevhangelog
tables. If they are not there it creates them. If they are it
continues on.
With updatesql mode, it does the same check but the code is a bit
wired because it can't really create the tables. There must be a bug
in there.
If you could enter an issue in the sourceforge issue tracker that
would be great.
Nathan
On Apr 3, 2009, at 6:07 PM, "Sven Haiges" <hansam...@yahoo.de> wrote:
Hi Nathan,
I am using Liquibase 1.9.1. Would this mean even if I let liquibase
synchronize with the db it would not try to create these tables?
Thanx for the CREATEs. Should I log a jira somewhere?
Cheers
Sven
On Fri, Apr 3, 2009 at 3:19 PM, Voxland, Nathan <nvoxl...@intelligentinsites.com
> wrote:
Liquibase should add create table commands for the databasechangelog
and databasechangeloglock tables in your script if they don’t exist.
We have made some changes around how we output the updateSQL text,
however, and it may have gotten lost, or it may be fixed in a later
version. Which version of liquibase are you running?
The liquibase tables are very straightforward and I would say just
add the create table statements to the beginning of the script
manually until we figure out why they aren’t being put in there.
You’re actual sql will depend on your database, but the java code th
at is generating the columns looks like this:
return new CreateTableStatement(“databasechangelog)
.addPrimaryKeyColumn("ID", "VARCHAR(63)", null,
null, new NotNullConstraint())
.addPrimaryKeyColumn("AUTHOR", "VARCHAR(63)", null,
null, new NotNullConstraint())
.addPrimaryKeyColumn("FILENAME", "VARCHAR(200)",
null, null, new NotNullConstraint())
.addColumn("DATEEXECUTED", getDateTimeType(), new
NotNullConstraint())
.addColumn("MD5SUM", "VARCHAR(32)")
.addColumn("DESCRIPTION", "VARCHAR(255)")
.addColumn("COMMENTS", "VARCHAR(255)")
.addColumn("TAG", "VARCHAR(255)")
.addColumn("LIQUIBASE", "VARCHAR(10)");
And
return new CreateTableStatement(“databasechangeloglock”)
.addPrimaryKeyColumn("ID", "INT", null, null, new
NotNullConstraint())
.addColumn("LOCKED", getBooleanType(), new
NotNullConstraint())
.addColumn("LOCKGRANTED", getDateTimeType())
.addColumn("LOCKEDBY", "VARCHAR(255)");
You should be able to figure out the exact sql from that even if you
don’t know java.
Nathan
From: Sven Haiges [mailto:hansam...@yahoo.de]
Sent: Friday, April 03, 2009 5:12 PM
To: liquibase-user@lists.sourceforge.net
Subject: [Liquibase-user] SQL for liquibase tables
Hi,
I am brand new to liquibase and like what I exerienced so far. We
would like to use liquibase for an existing project and the way we
choose to migrate to using liquibase is have liquibase generate the
SQL for us (updateSQL command).
This works fine, but here is one little thing we don't understand:
- the generated SQL does not contain a CREATE TABLE for the
liquibase tables themselves. The insert for the changeset would fail
as that table does not yet exist.
I understand that the update command would create the table, but
then we would have to run liquibase update at least once. All we
want to do at this point is get the SQL from liquibase and then run
everything manually from there.
One way I would solve it could be to create an empty changeset or
so... but it is a hack. What is the officical way?
Cheers
Sven
--
Sven Haiges
sven.hai...@googlemail.com
Yahoo Messenger / Skype: hansamann
Personal Homepage, Wiki & Blog: http://www.svenhaiges.de
Subscribe to the Grails Podcast:
http://feeds.grailspodcast.com/grailspodcast
http://www.grailspodcast.com
---
---
---
---------------------------------------------------------------------
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
--
Sven Haiges
sven.hai...@googlemail.com
Yahoo Messenger / Skype: hansamann
Personal Homepage, Wiki & Blog: http://www.svenhaiges.de
Subscribe to the Grails Podcast:
http://feeds.grailspodcast.com/grailspodcast
http://www.grailspodcast.com
---
---
---
---------------------------------------------------------------------
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
------------------------------------------------------------------------------
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
