SQL storage: schema migration now possible

Hi,

FYI I just committed (NXP-2872) proper code to do schema migrations in  
SQL when using the SQL storage backend. This will be in Nuxeo 5.1.7.
So now if you modify a schema to add a new field, the column will be  
added in the database. This brings the SQL code on par with Jackrabbit  
regarding schema additions (forceReloadTypes).

If you add a new field, you will get a:
   WARN  [Mapper] Adding missing column in database:  
"myschema"."mynewfield"

If you remove a field, you will get a:
   WARN  [Mapper] Database contains additional unused columns for  
table "myschema": MYOLDFIELD

And if you change the type of a field, you will get a:
   ERROR [Mapper] SQL type mismatch for "myschema"."myfield": expected  
123, database has 456
where 123 and 456 are java.sql.Types integers representing the column  
type.

Florent

--

-- 
Florent Guillaume, Head of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87