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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to