Diff
Not logged in

Differences From Artifact [5bfc8480d1]:

To Artifact [e516ec9ab3]:


404
405
406
407
408
409
410
411
412
413
414
415
416






417
418
419
420
421
422
423
404
405
406
407
408
409
410






411
412
413
414
415
416
417
418
419
420
421
422
423







-
-
-
-
-
-
+
+
+
+
+
+







    assert( p->db );
    blob_zero(&p->tmp);
    sqlite3_exec(p->db,
        "PRAGMA page_size=512;"
        "PRAGMA journal_mode = off;"
        "PRAGMA cache_spill = off;"
        "BEGIN;"
        "CREATE TABLE sqlar("
          "name TEXT PRIMARY KEY,  -- name of the file\n"
          "mode INT,               -- access permissions\n"
          "mtime INT,              -- last modification time\n"
          "sz INT,                 -- original file size\n"
          "data BLOB               -- compressed content\n"
        "CREATE TABLE sqlar(\n"
          "  name TEXT PRIMARY KEY,  -- name of the file\n"
          "  mode INT,               -- access permissions\n"
          "  mtime INT,              -- last modification time\n"
          "  sz INT,                 -- original file size\n"
          "  data BLOB               -- compressed content\n"
        ");", 0, 0, 0
    );
    sqlite3_prepare(p->db,
        "INSERT INTO sqlar VALUES(?, ?, ?, ?, ?)", -1,
        &p->pInsert, 0
    );
    assert( p->pInsert );