[JS1-549] turbine-mysql-4.sql script malformed

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.6
• Component/s: Turbine
• Environment: mysql 4.0.20
• Assignee: David Sean Taylor
• Reporter: Greg Buchanan
• Created: 27/May/05 06:46
• Updated: 02/Jun/05 02:40
• Resolved: 02/Jun/05 02:40

Description

turbine-mysql-4.sql script has sql syntax errors which prevent the user from creating jetspeed required mysql tables without editing.

1. Comment lines in script do not have # to start comments throughout
2. The SQL command beginning with "CREATE TABLE TURBINE_USER" has an extraneous comma after the field definition for PASSWORD_CHANGED

Changing comment lines to add "#" and removing the extraneous comma corrects this problem and allows scripts to run without errors.