actual-server/migrations/1561751833510_indexes.sql
2022-03-31 13:19:08 -04:00

7 lines
197 B
SQL

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;