problem with kernel_schema.sql, ezPublish 3.7.2

Tuesday 27 December 2005 8:32:26 pm

The distributed postgresql files for ezPublish 3.7.2 are in the mysql format and don't work for postgres.
Can anybody help with this problem, please.
Can I use distributed postgresql files for ezPublish 3.4 in ezPublish 3.7.2 or
where this files can be found.

Thursday 05 January 2006 12:44:36 am

Thank's for reply.

ezpublish-3.7.2
php-4.4.1
postgresql-v7.4.9

File kernel_schema.sql in folder kernel/sql/postgresql and in kernel/sql/mysql are the same.

Some first string from kernel/sql/postgresql/kernel_schema.sql :

CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL default '0',
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
);

CREATE TABLE ezbasket (
id int(11) NOT NULL auto_increment,
order_id int(11) NOT NULL default '0',
productcollection_id int(11) NOT NULL default '0',
session_id varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY ezbasket_session_id (session_id)
);

From kernel/sql/mysql/kernel_schema.sql :

CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL default '0',
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
);

CREATE TABLE ezbasket (
id int(11) NOT NULL auto_increment,
order_id int(11) NOT NULL default '0',
productcollection_id int(11) NOT NULL default '0',
session_id varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY ezbasket_session_id (session_id)
);

Thursday 12 January 2006 1:05:08 am

Looks like something wrong happened during building subrelease.
You can use kernel_schema.sql from 3.7.0. In addition you should apply
'update/database/postgresql/3.7/dbupdate-3.7.1-to-3.7.2.sql'.
Btw, new subrelease 3.7.3 should be out next week