#69 jbilling-schema-postgressql has errors

Database
open
nobody
None
5
2010-09-10
2010-09-10
mbodbg
No

The table mediation_process could not be created with the script delivered in version 2.2.0

CREATE TABLE mediation_process
(
id INTEGER NOT NULL,
configuration_id INTEGER NOT NULL,
start_datetime TIMESTAMP NOT NULL,
end_datetime TIMESTAMP default 'NULL',
orders_affected INTEGER NOT NULL,
OPTLOCK INTEGER NOT NULL,
PRIMARY KEY (id)
);

you need to change end_datetime TIMESTAMP default 'NULL', to end_datetime TIMESTAMP default NULL,

It also seems that the script is not creacting the actual database schema correctly, some other tables are missing fields

Discussion