[jira] [Assigned] (ROL-1685) minor error in create table script for HSQLDB (causing the install to fail)

["Glen Mazza (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ROL-1685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Glen Mazza reassigned ROL-1685:
-------------------------------

    Assignee: Glen Mazza  (was: Roller Unassigned)
    
> minor error in create table script for HSQLDB (causing the install to fail)
> ---------------------------------------------------------------------------
>
>                 Key: ROL-1685
>                 URL: https://issues.apache.org/jira/browse/ROL-1685
>             Project: Roller
>          Issue Type: Bug
>          Components: Database Access & Data Model, Installation
>    Affects Versions: 4.0
>         Environment: JDK 1.6.0_04 on windows XP, jetty 6.1.7, HSQLDB 1.8.0.9
>            Reporter: michal pisanko
>            Assignee: Glen Mazza
>            Priority: Minor
>
> When issuing the install command on new installation an error occurs creating tables.
> There is a minor error in table definition script for hsqldb:
> file: roller/WEB-INF/classes/dbscripts/hsqldb/createdb.sql
> line: 80 (for 'create table webpage')
> reading: 
> action      varchar(16) not null default 'custom'
> Should be: 
> action      varchar(16) default 'custom' not null 
> The order is incorrect - 'default' clause must precede 'not null' constraint (I think that might be an issue for other databases as well).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira