-- Data tables. These are optional and only needed if you want to store and load configuration in the database.
CREATE TABLE IF NOT EXISTS chronicle_custom_providers (
  id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
  name text,
  label text,
  url text NOT NULL,
  api_key text,
  api_key_source text,
  format jsonb NOT NULL,
  headers jsonb,
  prefix text
);

CREATE TABLE IF NOT EXISTS chronicle_aliases (
  id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
  name text NOT NULL UNIQUE,
  random_order bool NOT NULL DEFAULT FALSE
);

CREATE TABLE IF NOT EXISTS chronicle_alias_providers (
  id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
  alias_id bigint REFERENCES chronicle_aliases (id),
  sort int NOT NULL DEFAULT 0,
  model text NOT NULL,
  provider text NOT NULL,
  api_key_name text
);

CREATE TABLE IF NOT EXISTS chronicle_api_keys (
  id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
  name text,
  source text,
  value text
);