mirror of
https://github.com/felipegcoutinho/openmonetis.git
synced 2026-09-08 05:26:00 +00:00
3 lines
341 B
SQL
3 lines
341 B
SQL
DROP INDEX "lancamentos_ofx_fit_id_user_id_idx";--> statement-breakpoint
|
|
ALTER TABLE "lancamentos" ADD COLUMN "ofx_import_fingerprint" text;--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "lancamentos_ofx_import_fingerprint_user_id_idx" ON "lancamentos" USING btree ("user_id","ofx_import_fingerprint") WHERE ofx_import_fingerprint IS NOT NULL; |