/* WARNING: Script requires that SQLITE_DBCONFIG_DEFENSIVE be disabled */
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Questions (
    questionId INTEGER PRIMARY KEY,
    question TEXT NOT NULL UNIQUE
);
INSERT INTO Questions VALUES(1,'Summarize the codebase');
INSERT INTO Questions VALUES(2,'Explain the role of the process subfolder');
CREATE TABLE Scores (
    questionId INTEGER REFERENCES Questions(id),
    chunkHash TEXT REFERENCES Hashes(chunkHash),
    score INTEGER,  -- 0 or 1,
    timestamp TEXT
);
INSERT INTO Scores VALUES(1,'facf7631233ee1c7ac88e499644cf5ae',0,'2025-02-20T19:27:52.198921');
INSERT INTO Scores VALUES(1,'bc15d5f7e7c94d4d706ec0965f2707a5',1,'2025-02-20T19:27:53.389400');
INSERT INTO Scores VALUES(1,'bd84e7c95f6a4241cbdc0fdb1fe2ca56',1,'2025-02-20T19:27:57.625926');
INSERT INTO Scores VALUES(1,'293f7561bab8d0aff1270a6ea18a3a65',1,'2025-02-20T19:27:58.910777');
INSERT INTO Scores VALUES(1,'20b9e0c0611561502ebe27f4b78946c0',0,'2025-02-20T19:28:01.595352');
INSERT INTO Scores VALUES(1,'a2db0ba3b6f112eba6e69026c551f134',1,'2025-02-20T19:28:05.903456');
INSERT INTO Scores VALUES(1,'55cd884bc89576c9d3b9cd5017ab6a7b',1,'2025-02-20T19:28:08.476992');
INSERT INTO Scores VALUES(1,'54f142268d26949966636fef709cfe7f',1,'2025-02-20T19:28:16.146928');
INSERT INTO Scores VALUES(1,'44dac97aca9f6f7d16ed1d2b74da218d',0,'2025-02-20T19:28:23.508825');
INSERT INTO Scores VALUES(1,'af22afa0d720f50ba705baa93905a0b4',0,'2025-02-20T19:28:31.647545');
INSERT INTO Scores VALUES(1,'34dfa26b852e47dfc393e21ca132d7fb',1,'2025-02-20T19:28:35.978933');
INSERT INTO Scores VALUES(1,'6db18e1b7648518e13ff25ff0fd7af5f',1,'2025-02-20T19:28:40.787345');
INSERT INTO Scores VALUES(1,'53601e163ddd8a6a553e2f6813737f79',1,'2025-02-20T19:28:43.906707');
INSERT INTO Scores VALUES(1,'2f35b84545b4dcc42b8c7e2203e3ab24',0,'2025-02-20T19:28:47.453252');
INSERT INTO Scores VALUES(1,'c32872abb8f172d4ee69ab52170e6a9b',1,'2025-02-20T19:28:50.872352');
INSERT INTO Scores VALUES(1,'2b3ebed8aff5d6703cf2edab52f1ea2d',1,'2025-02-20T19:29:01.097046');
INSERT INTO Scores VALUES(1,'cfd61909ea2b0c2dd3ffe7160116b2ff',0,'2025-02-21T21:42:02.636416');
COMMIT;
