You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Thomas Polliard (JIRA)" <je...@jakarta.apache.org> on 2004/12/16 02:28:55 UTC

[jira] Created: (JS1-532) Bug in postgres create script

Bug in postgres create script
-----------------------------

         Key: JS1-532
         URL: http://nagoya.apache.org/jira/browse/JS1-532
     Project: Jetspeed
        Type: Bug
  Components: Database  
    Versions: 1.5    
 Environment: Linux Fedora Core 2/ Postgres  7.4.2
    Reporter: Thomas Polliard
    Priority: Minor


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)
);


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org