portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Polliard (JIRA)" <jetspeed-...@jakarta.apache.org>
Subject [jira] Created: (JS1-532) Bug in postgres create script
Date Thu, 16 Dec 2004 01:28:55 GMT
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


Mime
View raw message