Differences From Artifact [43a4e0a4f4]:
- File src/zip.c — part of check-in [768e19219f] at 2017-12-04 21:29:53 on branch trunk — Add the /sqlar webpage. Link to this page from the /info page. (user: drh size: 28643)
To Artifact [367ef7e4bd]:
- File src/zip.c — part of check-in [f5c81a6c4f] at 2017-12-04 21:49:18 on branch trunk — Make the default page size on SQL archives 512 bytes. (user: drh size: 28675)
| ︙ | |||
404 405 406 407 408 409 410 411 412 413 414 415 416 417 | 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 | + |
sqlite3_vfs_register(&p->vfs, 0);
sqlite3_open_v2("file:xyz.db", &p->db,
SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName
);
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"
|
| ︙ |