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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0
• Fix Version/s: 5.0.1
• Component/s: Data Model & JPA Backend, Installation & Configuration
• Environment: JDK 1.6.0_04 on windows XP, jetty 6.1.7, HSQLDB 1.8.0.9
• Browser Version: N/A
• Customer(s): anyone possibly
• Database: HSQLDB 1.8.0.9
• JDK Version: SUN JDK 1.6.0_04
• Level of effort: Minimal, just change order of words on one line.
• O/S Version: Windows XP
• Assignee: Glen Mazza
• Reporter: michal pisanko
• Created: 05/Mar/08 12:35
• Updated: 19/May/13 12:25
• Resolved: 19/May/13 12:25

Description

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