Files
elprice/resources/migrations/20260214170000-create-production.up.sql
magnusandClaude Opus 4.6 3a319f5cf4 Fix sync: add missing tables, Linux date, token from env
Add production and consumption table migrations. Fix sync-month.sh
to use Linux date syntax and default to port 3030. Read Eloverblik
token from ELOVERBLIK_TOKEN env var with .token file fallback.
Mount .token into Docker container.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-15 13:06:14 +01:00

7 lines
163 B
SQL

CREATE TABLE production (
time_start TIMESTAMPTZ NOT NULL,
hour INTEGER NOT NULL,
kwh DOUBLE PRECISION,
PRIMARY KEY (time_start, hour)
);