The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=251
======================================================================
Reported By: kaname
Assigned To:
======================================================================
Project: DBMail
Issue ID: 251
Category: Database layer
Reproducibility: always
Severity: minor
Priority: normal
Status: resolved
Resolution: fixed
Fixed in Version: SVN Trunk
======================================================================
Date Submitted: 18-Aug-05 05:36 CEST
Last Modified: 21-Mar-06 15:04 CET
======================================================================
Summary: Missing table definition (postgresql)
Description:
The table definition of postgresql is wrong.
The patch was made compared with the definition of MySQL.
Please confirm it.
======================================================================
Relationships ID Summary
----------------------------------------------------------------------
duplicate of 0000225 Missing table definition in the file sq...
======================================================================
----------------------------------------------------------------------
kaname - 18-Aug-05 06:01
----------------------------------------------------------------------
This problem is the same as 0000224 and 0000225.
----------------------------------------------------------------------
aaron - 08-Feb-06 07:42
----------------------------------------------------------------------
Should this table...
CREATE TABLE dbmail_datefield (
physmessage_id INT8 NOT NULL
REFERENCES dbmail_physmessage(id)
ON UPDATE CASCADE ON DELETE CASCADE,
id INT8 DEFAULT
nextval('dbmail_datefield_idnr_seq'),
datefield VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
Be...
- datefield VARCHAR(100) NOT NULL DEFAULT '',
+ datefield TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00',
?
----------------------------------------------------------------------
aaron - 08-Feb-06 07:42
----------------------------------------------------------------------
The other parts of the patch are either obsolete or changed already.
----------------------------------------------------------------------
kaname - 10-Mar-06 10:36
----------------------------------------------------------------------
In the type of datefield of the dbmail_datefield table, MySQL is DATETIME.
PostgreSQL is VARCHAR(100).
The type of datefield of PostgreSQL is TIMESTAMP when matching it to
MySQL.
----------------------------------------------------------------------
paul - 21-Mar-06 15:04
----------------------------------------------------------------------
patch applied.
Issue History
Date Modified Username Field Change
======================================================================
18-Aug-05 05:36 kaname New Issue
18-Aug-05 05:36 kaname File Added: add_sql.patch
18-Aug-05 06:01 kaname Note Added: 0000842
08-Feb-06 07:39 aaron Relationship added duplicate of 0000225
08-Feb-06 07:42 aaron Note Added: 0000988
08-Feb-06 07:42 aaron Note Added: 0000989
10-Mar-06 10:36 kaname Note Added: 0001034
21-Mar-06 15:04 paul Note Added: 0001045
21-Mar-06 15:04 paul Status new => resolved
21-Mar-06 15:04 paul Resolution open => fixed
21-Mar-06 15:04 paul Fixed in Version => SVN Trunk
======================================================================
