import { integer, real, sqliteTable } from "drizzle-orm/sqlite-core";

/**
 * Each row records one CPU load sample.
 * `ts` is the Unix timestamp in milliseconds (primary key, append-only).
 * `value` is the 1-minute load average from os.loadavg()[0].
 */
export const samples = sqliteTable("samples", {
  ts: integer("ts").primaryKey(),
  value: real("value").notNull(),
});