actual/packages/api/migrations/1561751833510_indexes.sql

8 lines
197 B
MySQL
Raw Permalink Normal View History

2022-04-29 02:44:38 +00:00
BEGIN TRANSACTION;
CREATE INDEX trans_category_date ON transactions(category, date);
CREATE INDEX trans_category ON transactions(category);
CREATE INDEX trans_date ON transactions(date);
COMMIT;