[jira] Commented: (JS1-460) MySql srcipts to create and populate DB

[je...@jakarta.apache.org]

The following comment has been added to this issue:

     Author: ZebX
    Created: Fri, 2 Jul 2004 7:27 AM
       Body:
This new turbine-mysql-create.sql file is buggy too.

****
CREATE TABLE TURBINE_USER
(
    USER_ID integer NOT NULL PRIMARY KEY ,
    LOGIN_NAME VARCHAR (32) NOT NULL UNIQUE,
    PASSWORD_VALUE VARCHAR (32) NOT NULL,
    FIRST_NAME VARCHAR (99) NOT NULL,
    LAST_NAME VARCHAR (99) NOT NULL,
    EMAIL VARCHAR (99),
    CONFIRM_VALUE VARCHAR (99),
    MODIFIED timestamp,
    CREATED timestamp,
    LAST_LOGIN timestamp,
    DISABLED CHAR,
    OBJECTDATA BLOB,
    PASSWORD_CHANGED DATE,  <==================== comma in excess
);
****
---------------------------------------------------------------------
View this comment:
  http://issues.apache.org/jira/browse/JS1-460?page=comments#action_36460

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/JS1-460

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: JS1-460
    Summary: MySql srcipts to create and populate DB
       Type: Test

     Status: Closed
   Priority: Trivial
 Resolution: FIXED

    Project: Jetspeed
 Components: 
             Database
   Fix Fors:
             1.6-dev
   Versions:
             1.4b5-dev / CVS

   Assignee: 
   Reporter: Michael Muller

    Created: Mon, 26 Apr 2004 4:09 AM
    Updated: Fri, 2 Jul 2004 7:27 AM

Description:



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://issues.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