backup.sql

PRAGMA defer_foreign_keys=TRUE;
CREATE TABLE Users (
  Id          INTEGER PRIMARY KEY,
  Name        TEXT    NOT NULL UNIQUE,
  Email       TEXT,
  Description TEXT    NOT NULL
);
INSERT INTO "Users" VALUES(2,'Phil Bachmann',NULL,'<p>Thinker, inventor and the website developer.</p>');
INSERT INTO "Users" VALUES(3,'Asa',NULL,'<p>Swedish Woman</p>');
CREATE TABLE Concepts (
  Id          INTEGER PRIMARY KEY,
  UserId      INTEGER NOT NULL,
  ConceptNo   INTEGER NOT NULL,
  Name        TEXT    NOT NULL,
  Description TEXT    NOT NULL
);
INSERT INTO "Concepts" VALUES(1,2,101,'Why have you inserted so much material into the conversation at once?','<p></p><p>I thought we were having a discussion on a specific topic, so I''m not sure what you meant by introducing a link containing so much new information. I have to assume it was done with good intentions, but please explain the reasons:</p><ul><li>Are you so keen on sharing this information that you didn''t stop to consider what effect it would have on the conversation?</li><li>Do you genuinely feel that the conversation is lacking and needs an infusion of new material to keep it going?</li><li>Do you really not want to engage with the topic of discussion and hope that by dropping in a link you are contributing "something"?</li><li>Maybe the problem is not you, it''s me: I''m being too precious and should just work through the information in the link, however long it takes me.</li></ul><p></p><p>Perhaps you can assist me by explaining:</p><ul><li>Why you have introduced the link?</li><li>How it fits into the conversation?</li><li>What you think I will learn from it that I do not already know?</li></ul><p>In summary, you''ve given me a whole lot of information and not told me why you have done so or what you want me to do with it.</p><p></p>');
INSERT INTO "Concepts" VALUES(2,2,1001,'Make a note of things that might be wrong','<p>This concept is an acknowledgement that we can''t fix everything, but we can at least make a mental note of them for future consideration and potential action.</p>');
INSERT INTO "Concepts" VALUES(3,2,1002,'Professional serenader','<p>Someone who tries to make a living from writing.</p>');
CREATE TABLE Passkeys (
  CredentialId TEXT    PRIMARY KEY,
  UserId       INTEGER NOT NULL,
  PublicKey    TEXT    NOT NULL,
  DeviceType   TEXT,
  Transports   TEXT,
  CreatedAt    TEXT    NOT NULL
);
INSERT INTO "Passkeys" VALUES('d2etiY6S5PLcT8dT4-_mWw',2,'pQECAyYgASFYIEVSvuYjQpq8vGlqe9WMYfsOZF_fAHwNmv36QU01G_xmIlggAeUFG9uqozBnkwAfGinKHL_S_QWtDD0psLM1AVYV_iw','multiDevice',NULL,'2026-02-16T10:29:40.750Z');
INSERT INTO "Passkeys" VALUES('YqG0cQ9lWVyLEjTrHAeo4w',3,'pQECAyYgASFYILmt3P9UCbWIKAS7qHMg8RL1GDpaSPjYbq7dKqE8Um6EIlggS5sOL5P0PeV6kJP9dEruyKB1iTMcHheF8YpI_Qg84uE','multiDevice',NULL,'2026-02-18T23:10:10.800Z');
INSERT INTO "Passkeys" VALUES('tw0mRZ3q2EL2hyKu76YCNQ',3,'pQECAyYgASFYICNXiIrvYT1iPbZEHwOlP2mfPSrm13zFZNNDn6aHigq1IlggQ_K1gICKojIszmI1kfl61vCijh2IHT2r-qGyKdiF2g8','multiDevice',NULL,'2026-02-19T08:20:53.096Z');
CREATE TABLE RegoLinks (
  Token     TEXT NOT NULL PRIMARY KEY,
  UserName  TEXT NOT NULL,
  ExpiresAt TEXT NOT NULL
);
CREATE TABLE Focuses (
  Id          INTEGER PRIMARY KEY,
  Name        TEXT    NOT NULL,
  UserId      INTEGER NOT NULL,
  Description TEXT    NOT NULL
, Included TEXT NOT NULL DEFAULT '', Excluded TEXT NOT NULL DEFAULT '');
CREATE TABLE Evidence (
  Id                INTEGER  PRIMARY KEY,
  FocusId           INTEGER  NOT NULL,
  SourceUrl         TEXT     NOT NULL,
  Description       TEXT     NOT NULL,
  PersonalCopyR2Ref TEXT,
  IsPublic          INTEGER  NOT NULL DEFAULT 0
);
CREATE TABLE Examples (
  Id          INTEGER PRIMARY KEY,
  UserId      INTEGER NOT NULL,
  FocusId     INTEGER NOT NULL,
  ConceptId   INTEGER NOT NULL,
  Description TEXT    NOT NULL
);
DELETE FROM sqlite_sequence;
CREATE UNIQUE INDEX idx_Concepts_UserId_ConceptNo ON Concepts(UserId, ConceptNo);
CREATE UNIQUE INDEX idx_Concepts_UserId_Name       ON Concepts(UserId, Name);
CREATE INDEX idx_Passkeys_UserId ON Passkeys(UserId);
CREATE INDEX idx_Focuses_UserId ON Focuses(UserId);
CREATE INDEX idx_Evidence_FocusId ON Evidence(FocusId);
CREATE INDEX idx_Examples_UserId    ON Examples(UserId);
CREATE INDEX idx_Examples_FocusId   ON Examples(FocusId);
CREATE INDEX idx_Examples_ConceptId ON Examples(ConceptId);
CREATE UNIQUE INDEX idx_Focuses_UserId_Name ON Focuses(UserId, Name);