-- 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 integer PRIMARY KEY,
  name text NOT NULL,
  label text,
  url text NOT NULL,
  api_key text,
  api_key_source text,
  format text NOT NULL,
  headers text,
  prefix text
);

CREATE TABLE IF NOT EXISTS chronicle_aliases (
  id integer PRIMARY KEY,
  name text NOT NULL,
  random_order bool NOT NULL DEFAULT FALSE
);

CREATE TABLE IF NOT EXISTS chronicle_alias_providers (
  id integer PRIMARY KEY,
  alias_id bigint REFERENCES chronicle_aliases (id) ON DELETE CASCADE,
  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 integer PRIMARY KEY,
  name text,
  source text,
  value text
);