CREATE TABLE "tariff" (
	"id" varchar PRIMARY KEY NOT NULL,
	"slots" jsonb NOT NULL,
	"peak_electricity_price" integer DEFAULT 0 NOT NULL,
	"peak_service_fee" integer DEFAULT 0 NOT NULL,
	"valley_electricity_price" integer DEFAULT 0 NOT NULL,
	"valley_service_fee" integer DEFAULT 0 NOT NULL,
	"flat_electricity_price" integer DEFAULT 0 NOT NULL,
	"flat_service_fee" integer DEFAULT 0 NOT NULL,
	"is_active" boolean DEFAULT true NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "charge_point" ADD COLUMN "pricing_mode" varchar DEFAULT 'fixed' NOT NULL;--> statement-breakpoint
ALTER TABLE "transaction" ADD COLUMN "electricity_fee" integer;--> statement-breakpoint
ALTER TABLE "transaction" ADD COLUMN "service_fee" integer;