Brijesh's Git Server — watchman @ main

observability tool, needs to be rewritten once identity is stable

schema/schema.sql (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 
CREATE TABLE Projects (
  ID TEXT PRIMARY KEY,
  Name TEXT NOT NULL
);

CREATE TABLE Logs (
  Time INTEGER NOT NULL,
  Level TEXT NOT NULL,
  Message TEXT NOT NULL,
  Subject TEXT,
  UserID TEXT,
  ProjectID TEXT NOT NULL,
  FOREIGN KEY (ProjectID) REFERENCES Project(ID)
);

CREATE TABLE ProjectKeys (
    ProjectID TEXT NOT NULL,
    AccessKey TEXT NOT NULL,
    SecretKey TEXT NOT NULL,
    Expiry INTEGER,
    FOREIGN KEY (ProjectID) REFERENCES Projects(ID)
);