templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql should have varchar(5) instead of varchar(1)

see http://answers.nuxeo.com/questions/10188/nuxeo-595-cluster-couldnt-store-job-error-value-too-long-for-type-character-varying1

but in details:

• when configuring nuxeo in cluster with a postgresql database, I ran the templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql

• when starting nuxeo I get "failed to schedule job with id 'softDeleteCleanup'"

• too short fields are in the templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql. In particular all VARCHAR(1) like is_durable, is_volatile, is_stateful, requests_recovery...

• they should be 5 characters at least, because I see "false" stored inside, or they should be boolean and not varying char.

Reporter: nicolas
E-mail: nicolas.zin@gmail.com