schema.sql

CREATE TABLE global (
 g_last_amd_scan INTEGER DEFAULT 0
);
CREATE TABLE job (
 job_id         INTEGER PRIMARY KEY AUTOINCREMENT,
 job_name       TEXT,
 job_path_id    INTEGER REFERENCES path(id),
 job_ok		INTEGER DEFAULT 0,	-- finished without error
 job_started	INTEGER DEFAULT 0,	-- unix localtime 0 means never
 job_enabled    INTEGER DEFAULT 1 	-- boolean
);
CREATE TABLE lock (
  lck_name      TEXT,
  lck_mode      INTEGER,
  lck_pid       INTEGER
);
CREATE TABLE path (
 path_id        INTEGER PRIMARY KEY AUTOINCREMENT,
 path_server    TEXT,
 path_path      TEXT
);
CREATE TABLE rejoined (
  rejoined_job_name TEXT
);
CREATE TABLE stat (
  stat_job_id             INTEGER REFERENCES job(id),
  stat_started            INTEGER,
  stat_files              INTEGER,
  stat_files_transferred  INTEGER,
  stat_bytes              INTEGER,
  stat_bytes_transferred  INTEGER,
  stat_du_bytes           INTEGER,
  stat_seconds            INTEGER,
  stat_type		          TEXT,
  stat_volume_id	      INTEGER REFERENCES volume(volume_id)
);
CREATE TABLE upid (
 upid_pid         INTEGER PRIMARY KEY NOT NULL,
 upid_incarnation TEXT,
 upid_text        TEXT NOT NULL DEFAULT "",
 upid_since       INTEGER,
 upid_shutdown_pending INTEGER DEFAULT 0
);
CREATE TABLE volume (
  volume_id	INTEGER PRIMARY KEY AUTOINCREMENT,
  volume_path	TEXT
);