Nicolas Lamirault wrote:
5- Database model
[snip]
Migration #1: EXEC: "create table employees (id serial, name varchar(100))" EXEC: "create table products (id serial, name varchar(100))" While accessing database #<MYSQL-DATABASE localhost/test/root OPEN {AA87289}> with expression "UPDATE SCHEMA_INFO SET VERSION = 1 WHERE (VERSION = 0)": Error 1146 / Table 'test.SCHEMA_INFO' doesn't exist has occurred. [Condition of type CLSQL-SYS:SQL-DATABASE-DATA-ERROR]
It looks like a known problem. According to the clsql guys, it's better to solve this problem at the server side: http://lists.b9.com/pipermail/clsql-help/2004-December/000377.html The relevant mysql link: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html Hope this solves your problem. I have fixed the other problems you have reported - however, I am no longer exporting the *migration-dir*, to make sure the database connection is configured properly before the migrations are run. Decoupling *migration-dir* and database config is a little tricky now, will perhaps solve this in the next version. Thanks so much for the feedback. Regards, Vamsee