Not being able to import table heidiSQL - Postgres

Question

I am trying to import this sql script to my db on heidiSQL. But I get this error when I run the script

ERROR: type "app_activity_date_index" does not exist LINE 9: INDEX "app_activity_date_index" ("date")

The code:

CREATE TABLE IF NOT EXISTS "app_activity" (
     "id" BIGINT NOT NULL DEFAULT 'nextval(''app_activity_id_seq''::regclass)',
     "date" TIMESTAMP NOT NULL,
     "type" TEXT NOT NULL,
     "area" TEXT NOT NULL,
     "count" INTEGER NOT NULL,
     INDEX "app_activity_date_index" ("date"),
     PRIMARY KEY ("id")
);

INSERT INTO "app_activity" ("id", "date", "type", "area", "count") VALUES
    (1, '2021-08-17 00:00:00', 'picagens', 'Lactogal - Prod. Alimentares', 1),
    (2, '2021-08-17 00:00:00', 'ferias_contingentes', 'Lactogal - Prod. Alimentares', 1),
    (3, '2021-08-17 00:00:00', 'oportunidades', 'Lactogal - Prod. Alimentares', 2),
    (4, '2021-08-17 00:00:00', 'ferias_contingentes', 'Sistemas de Informação', 2);

Any solution please? Thanks in advance