[JS1-532] Bug in postgres create script

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.5
• Component/s: Database
• Environment: Linux Fedora Core 2/ Postgres 7.4.2
• Assignee: Unassigned
• Reporter: Thomas Polliard
• Created: 16/Dec/04 01:22
• Updated: 16/Dec/04 01:22

Description

The script has one table that is created using mysql syntax. I have included a proper create table for the broken table:

jetspeed-1.5/src/sql/external/turbine-postgres.sql

CREATE TABLE EMAIL_INBOX (
EMAIL_INBOX_ID SERIAL,
MESSAGE_ID varchar(255) default NULL,
FILENAME varchar(255) default NULL,
ATTACHMENT text,
READFLAG integer default null,
PRIMARY KEY (EMAIL_INBOX_ID)
);