dge-traefik-logs/sql/create_indexes.sql
Guillaume RYCKELYNCK 9b41e2350f first commit 20240311
2024-03-11 08:36:55 +01:00

36 lines
899 B
SQL

CREATE UNIQUE INDEX "ix_logs_2023_07_id" ON "LOGS_2023_07" (
"id"
);
CREATE INDEX "ix_logs_2023_07_service" ON "LOGS_2023_07" (
"ogc_service"
);
CREATE UNIQUE INDEX "ix_logs_2023_08_id" ON "LOGS_2023_08" (
"id"
);
CREATE INDEX "ix_logs_2023_08_service" ON "LOGS_2023_08" (
"ogc_service"
);
CREATE UNIQUE INDEX "ix_logs_2023_09_id" ON "LOGS_2023_09" (
"id"
);
CREATE INDEX "ix_logs_2023_09_service" ON "LOGS_2023_09" (
"ogc_service"
);
CREATE UNIQUE INDEX "ix_logs_2023_10_id" ON "LOGS_2023_10" (
"id"
);
CREATE INDEX "ix_logs_2023_10_service" ON "LOGS_2023_10" (
"ogc_service"
);
CREATE UNIQUE INDEX "ix_logs_2023_11_id" ON "LOGS_2023_11" (
"id"
);
CREATE INDEX "ix_logs_2023_11_service" ON "LOGS_2023_11" (
"ogc_service"
);
CREATE UNIQUE INDEX "ix_logs_2023_12_id" ON "LOGS_2023_12" (
"id"
);
CREATE INDEX "ix_logs_2023_12_service" ON "LOGS_2023_12" (
"ogc_service"
);