0.7 sqlite SQL upgrade has broken syntax
|Reported by:||mrjoel||Owned by:|
The 0.7 release sql for sqlite upgrade is missing the table reference for the index. The change required is included below.
Also, updating the DB schema via the installer presents a list of versions from which to update, but the latest option was 0.5.1 instead of 0.6 which I was running. Not sure if it's related to the broken schema syntax.
Apply to both sqlite.initial.sql and sqlite.update.sql
-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name); +CREATE UNIQUE INDEX ix_searches_user_type_name on searches (user_id, type, name);
Change History (3)
comment:1 Changed 18 months ago by mrjoel
- Priority changed from 3 to 5
- Severity changed from normal to major
comment:2 Changed 18 months ago by alec
- Milestone changed from later to 0.8-beta
- Resolution set to fixed
- Status changed from new to closed