Overview
Comment:Fix bug [3747fb82b8b42ec6] trying to remove an index that does not exist
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 9714d59a0603fedc4bb8072d46d4593cc43c9c3a625c9253dfa933729b0a06e1
User & Date: bohwaz on 2021-06-10 23:10:37
Other Links: manifest | tags
Context
2021-06-18
09:37
Prepend AND to WHERE clause in sql template sections, if missing, thanks @zou check-in: e3170a7744 user: bohwaz tags: trunk
2021-06-10
23:10
Fix bug [3747fb82b8b42ec6] trying to remove an index that does not exist check-in: 9714d59a06 user: bohwaz tags: trunk
23:09
Fix missing schema for upgrades from < 1.0.0 check-in: e26736bdec user: bohwaz tags: trunk
Changes

Modified src/include/data/1.0.7_migration.sql from [607cda27c7] to [f53124e2db].

1
2
3
4
5
-- Add indexes
DROP INDEX acc_transactions_type;
CREATE INDEX IF NOT EXISTS acc_transactions_type ON acc_transactions (type, id_year);

CREATE INDEX IF NOT EXISTS acc_transactions_lines_transaction ON acc_transactions_lines (id_transaction);

|



1
2
3
4
5
-- Add indexes
DROP INDEX IF EXISTS acc_transactions_type;
CREATE INDEX IF NOT EXISTS acc_transactions_type ON acc_transactions (type, id_year);

CREATE INDEX IF NOT EXISTS acc_transactions_lines_transaction ON acc_transactions_lines (id_transaction);