[ROL-880] SQL failes to install in MySQL 5.x

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.2
• Fix Version/s: 2.0
• Component/s: Data Model & JPA Backend
• Environment: FreeBSD, MySQL 5, Tomcat 5 Java 5
• Assignee: Anil Gangolli
• Reporter: Brill Pappin
• Created: 13/Nov/05 05:07
• Updated: 20/Mar/06 17:37
• Resolved: 22/Nov/05 16:01

Description

Have an issue related to bad statements in the createdb.sql fro MySQL:

create table pingtarget:
condition integer default 0 not null, – condition code

– "condition" appears to be a reserved word.

Fix/Workaround:
surrounding the column name in backticks seems to work.
`condition` integer default 0 not null, – condition code