[JCR-1049] DatabaseFileSystem: mysql.ddl works for mysql5 but not mysql 4.1.20

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1, 1.2.2, 1.2.3, 1.3, 1.3.1
• Fix Version/s: 1.3.3
• Component/s: jackrabbit-core
• Environment: MySQL 4.1.20; ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
• Assignee: Stefan Guggisberg
• Reporter: Stephen More
• Created: 01/Aug/07 20:32
• Updated: 08/Oct/07 10:47
• Resolved: 16/Aug/07 10:03

Description

Perhaps a new column ( primary key ) could get added to the table called uid, which is actually an md5checksum of FSENTRY_PATH and FSENTRY_NAME.