yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 00-sys.db
systems/00-admin/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
← Back 00-sys decisions
Tables
decisions
25
domain
0
events
4
items
1
sessions
57
sqlite_sequence
4
transfers_log
0
decisions
25 rows
27
system: 00 Admin
tap
⌂ Admin Hub →
id
27
system
00 Admin
date
2026-07-24
subject
approved_by
USR369 David
se_id
—
tr_id
—
▼ Show timestamps
created_at
2026-07-23 20:17:35
⊞ Full detail →
26
Series J EXEC_OPEN deployed platform-wide
system: 00 Admin
All 11 systems now have Series J files. COMMS PING/PICKUP wired into startup. Series H/I retired. Broadcast ID320 sent.
tap
⌂ Admin Hub →
id
26
system
00 Admin
date
07/19/26
subject
Series J EXEC_OPEN deployed platform-wide
approved_by
USR369 David
se_id
—
tr_id
—
detail
All 11 systems now have Series J files. COMMS PING/PICKUP wired into startup. Series H/I retired. Broadcast ID320 sent.
▼ Show timestamps
created_at
2026-07-19 07:20:35
⊞ Full detail →
25
Board staleness root-caused to two independent bugs in boards_rebuild()
system: 00 Admin
Function only runs on all_pass close, and reads a retired MASTER_LIST.md instead of records.db. Both need Server 40 fix. Tasked as T638/T639.
tap
⌂ Admin Hub →
id
25
system
00 Admin
date
07/18/26
subject
Board staleness root-caused to two independent bugs in boards_rebuild()
approved_by
USR369 David
se_id
—
tr_id
—
detail
Function only runs on all_pass close, and reads a retired MASTER_LIST.md instead of records.db. Both need Server 40 fix. Tasked as T638/T639.
▼ Show timestamps
created_at
2026-07-18 08:10:17
⊞ Full detail →
24
verify_lib.php syntax bug fixed — was breaking SYNC/OPEN platform-wide
system: 00 Admin
Missing foreach closing braces introduced when PICKUP_GATE task creation was disabled. Fixed and verified via CHECKPOINT test call.
tap
⌂ Admin Hub →
id
24
system
00 Admin
date
07/16/26
subject
verify_lib.php syntax bug fixed — was breaking SYNC/OPEN platform-wide
approved_by
USR369 David
se_id
—
tr_id
—
detail
Missing foreach closing braces introduced when PICKUP_GATE task creation was disabled. Fixed and verified via CHECKPOINT test call.
▼ Show timestamps
created_at
2026-07-16 19:31:51
⊞ Full detail →
23
Human Description Field Standard established
system: 00 Admin
Every table David views must have a description field — one plain English sentence. Applied to 58 tables platform-wide, backfilled from existing subject/summa …
tap
⌂ Admin Hub →
id
23
system
00 Admin
date
2026-07-16
subject
Human Description Field Standard established
approved_by
USR369 David
se_id
—
tr_id
—
detail
Every table David views must have a description field — one plain English sentence. Applied to 58 tables platform-wide, backfilled from existing subject/summary fields.
▼ Show timestamps
created_at
2026-07-16 08:58:55
⊞ Full detail →
22
CHECKPOINT command built and deployed platform-wide
system: 00 Admin
Mid-session save without closing — writes decisions, handoff, runs UPDATE, reports to Master. Referenced in RULES-S.md and cmd-popup.js.
tap
⌂ Admin Hub →
id
22
system
00 Admin
date
2026-07-16
subject
CHECKPOINT command built and deployed platform-wide
approved_by
USR369 David
se_id
—
tr_id
—
detail
Mid-session save without closing — writes decisions, handoff, runs UPDATE, reports to Master. Referenced in RULES-S.md and cmd-popup.js.
▼ Show timestamps
created_at
2026-07-16 08:58:55
⊞ Full detail →
21
Task registry built — tasks table in records.db — tasks-api.php — T001-T016 registered — all
system: 00 Admin
tasks table: id/code/title/detail/priority/status/from_system/to_system/created_by/created_at/assigned_at/closed_at/session_ref. tasks-api.php: create/assign/li …
tap
⌂ Admin Hub →
id
21
system
00 Admin
date
07/12/26
subject
Task registry built — tasks table in records.db — tasks-api.php — T001-T016 registered — all system todo files s
approved_by
USR369 David
se_id
—
tr_id
—
detail
tasks table: id/code/title/detail/priority/status/from_system/to_system/created_by/created_at/assigned_at/closed_at/session_ref. tasks-api.php: create/assign/list/get/close/next_code. Auto-injects into target system todo-[code].md on assign. T-codes added to all todo-00.md items. 9 missing todo files seeded.
description
Task registry built — tasks table in records.db — tasks-api.php — T001-T016 registered — all system todo files seeded
▼ Show timestamps
created_at
2026-07-12 13:24:42
⊞ Full detail →
20
backend/web/ — new web infrastructure directory — search.db + search-api.php + media/[00-95]/ pe
system: 00 Admin
backend/web/db/search.db (4 tables: searches/results/pages/media), search-api.php (log_search/check_cache/get_searches/get_results/log_page/log_media/stats), ba …
tap
⌂ Admin Hub →
id
20
system
00 Admin
date
07/12/26
subject
backend/web/ — new web infrastructure directory — search.db + search-api.php + media/[00-95]/ per-system subdirs
approved_by
USR369 David
se_id
—
tr_id
—
detail
backend/web/db/search.db (4 tables: searches/results/pages/media), search-api.php (log_search/check_cache/get_searches/get_results/log_page/log_media/stats), backend/web/media/ with decade-code subdirs (pages/images/downloads/cache). /sessions/ root removed. backend/media/ removed, consolidated into backend/web/media/.
description
backend/web/ — new web infrastructure directory — search.db + search-api.php + media/[00-95]/ per-system subdirs
▼ Show timestamps
created_at
2026-07-12 13:24:42
⊞ Full detail →
19
web-fetch.php v2.0/v2.1 — multi-source search proxy — PubMed/Wikipedia/HackerNews — auto-mode
system: 00 Admin
DDG blocks server IPs. Built multi-source: medical queries → PubMed NCBI API, tech queries → HackerNews Algolia API, general → Wikipedia API. Auto-detects …
tap
⌂ Admin Hub →
id
19
system
00 Admin
date
07/12/26
subject
web-fetch.php v2.0/v2.1 — multi-source search proxy — PubMed/Wikipedia/HackerNews — auto-mode — no Google/Micros
approved_by
USR369 David
se_id
—
tr_id
—
detail
DDG blocks server IPs. Built multi-source: medical queries → PubMed NCBI API, tech queries → HackerNews Algolia API, general → Wikipedia API. Auto-detects mode from query keywords. 2-hour cache via search.db. All searches logged.
description
web-fetch.php v2.0/v2.1 — multi-source search proxy — PubMed/Wikipedia/HackerNews — auto-mode — no Google/Microsoft — de
▼ Show timestamps
created_at
2026-07-12 13:24:42
⊞ Full detail →
18
file-editor.php v1.0 — platform file editor — read+edit+save — backend/tools/
system: 00 Admin
POST save with token auth. Hub Open links → file-editor.
tap
⌂ Admin Hub →
id
18
system
00 Admin
date
07/12/26
subject
file-editor.php v1.0 — platform file editor — read+edit+save — backend/tools/
approved_by
USR369 David
se_id
—
tr_id
—
detail
POST save with token auth. Hub Open links → file-editor.
description
file-editor.php v1.0 — platform file editor — read+edit+save — backend/tools/
▼ Show timestamps
created_at
2026-07-12 10:21:44
⊞ Full detail →
17
backend/tools/ — platform tool suite — consolidated from domains/ and sys-com/
system: 00 Admin
14 files updated. 7 orphans deleted. .htaccess updated. file-reader dirname fixed.
tap
⌂ Admin Hub →
id
17
system
00 Admin
date
07/12/26
subject
backend/tools/ — platform tool suite — consolidated from domains/ and sys-com/
approved_by
USR369 David
se_id
—
tr_id
—
detail
14 files updated. 7 orphans deleted. .htaccess updated. file-reader dirname fixed.
description
backend/tools/ — platform tool suite — consolidated from domains/ and sys-com/
▼ Show timestamps
created_at
2026-07-12 10:21:44
⊞ Full detail →
16
server-map.php v5.0 — jump links fixed — duplicate id bug — Systems Tree — collapsed default
system: 00 Admin
buildTree emitted both id=rN and id=dir-... on same div. Fix: anchorId sole id. sys_tree added, sections collapsed, jumpToTree fixed.
tap
⌂ Admin Hub →
id
16
system
00 Admin
date
07/12/26
subject
server-map.php v5.0 — jump links fixed — duplicate id bug — Systems Tree — collapsed default — Open+Print prev
approved_by
USR369 David
se_id
—
tr_id
—
detail
buildTree emitted both id=rN and id=dir-... on same div. Fix: anchorId sole id. sys_tree added, sections collapsed, jumpToTree fixed.
description
server-map.php v5.0 — jump links fixed — duplicate id bug — Systems Tree — collapsed default — Open+Print preview button
▼ Show timestamps
created_at
2026-07-12 10:21:44
⊞ Full detail →
15
D098 — Pre-close checklist mandatory — all records must be complete before close
system: 00 Admin
Checklist added to RULES-S.md close sequence step 6. Every decision must be written to BOTH records.db (short, get rec_id) and system DB (full detail, store rec …
tap
⌂ Admin Hub →
id
15
system
00 Admin
date
07/07/26
subject
D098 — Pre-close checklist mandatory — all records must be complete before close
approved_by
USR369 David
tr_id
—
detail
Checklist added to RULES-S.md close sequence step 6. Every decision must be written to BOTH records.db (short, get rec_id) and system DB (full detail, store rec_id). Session must be written to BOTH DBs. Link-back must be complete — records.db decisions have sys_id pointing to system DB decision. System DB decisions have rec_id pointing to records.db. knowledge.md written. Backup run if significant work. Session is NOT confirmed closed until all 8 checklist items complete. Standing order ID31 distributed.
description
D098 — Pre-close checklist mandatory — all records must be complete before close
▼ Show timestamps
created_at
2026-07-07 17:52:54
⊞ Full detail →
12
Session 007 backup — 7 key files stamped 07072026
system: 00 Admin
Backed up to systems/00-admin/backup/: db-admin.html, panel.html, board.html, RULES-S.md, COMMANDS_v2.0-S.md, records_api.php, 0369_index.html. All stamped 0707 …
tap
⌂ Admin Hub →
id
12
system
00 Admin
date
07/07/26
subject
Session 007 backup — 7 key files stamped 07072026
approved_by
USR369 David
tr_id
—
detail
Backed up to systems/00-admin/backup/: db-admin.html, panel.html, board.html, RULES-S.md, COMMANDS_v2.0-S.md, records_api.php, 0369_index.html. All stamped 07072026.
description
Session 007 backup — 7 key files stamped 07072026
▼ Show timestamps
created_at
2026-07-07 17:37:40
⊞ Full detail →
11
D097 — Session close: write to records.db + system DB — REC_ID link-back
system: 00 Admin
Every session close writes decisions and session record to both records.db (short/community) and system DB (full detail). REC_ID on decisions links to records.d …
tap
⌂ Admin Hub →
id
11
system
00 Admin
date
07/07/26
subject
D097 — Session close: write to records.db + system DB — REC_ID link-back
approved_by
USR369 David
tr_id
—
detail
Every session close writes decisions and session record to both records.db (short/community) and system DB (full detail). REC_ID on decisions links to records.db session. update_decision_session action on records api for link-back. All systems notified via RULES-S.md + standing order ID17.
description
D097 — Session close: write to records.db + system DB — REC_ID link-back
▼ Show timestamps
created_at
2026-07-07 17:37:40
⊞ Full detail →
10
D096 — Trash/Archive policy — Server [40] jurisdiction
system: 00 Admin
Two-stage: archive after 3 days to /trash/archive/[date]/ — permanent delete after 7 days. Server checks at open. Root cleanup: nc_assets/ and Logs/ to trash. …
tap
⌂ Admin Hub →
id
10
system
00 Admin
date
07/07/26
subject
D096 — Trash/Archive policy — Server [40] jurisdiction
approved_by
USR369 David
tr_id
—
detail
Two-stage: archive after 3 days to /trash/archive/[date]/ — permanent delete after 7 days. Server checks at open. Root cleanup: nc_assets/ and Logs/ to trash. logs/ needs fence. Transfer 190 to Server [40].
description
D096 — Trash/Archive policy — Server [40] jurisdiction
▼ Show timestamps
created_at
2026-07-08 00:06:44
⊞ Full detail →
9
D095 — ORIENT command + per-system identity files + dash-code naming standard
system: 00 Admin
ORIENT command created. Runs at session open step 3b after RULES-S.md. Loads knowledge-[code].md (shortcuts/lessons) and jurisdiction-[code].md (identity/respon …
tap
⌂ Admin Hub →
id
9
system
00 Admin
date
07/07/26
subject
D095 — ORIENT command + per-system identity files + dash-code naming standard
approved_by
USR369 David
tr_id
—
detail
ORIENT command created. Runs at session open step 3b after RULES-S.md. Loads knowledge-[code].md (shortcuts/lessons) and jurisdiction-[code].md (identity/responsibilities). All per-system owned files use dash-code suffix: filename-[system_code].md. Community/shared files have no suffix. All 9 remaining systems deployed with both files + EXEC_OPEN Series D. backend/0369/ USR369 drop box built with Orient launcher — tap system, copy command, download EXEC_OPEN. COMMANDS v2.0 and RULES-S.md updated. Standing order ID16 distributed to all 11 systems. Community DB ID 111.
description
D095 — ORIENT command + per-system identity files + dash-code naming standard
▼ Show timestamps
created_at
2026-07-08 00:06:32
⊞ Full detail →
8
D094 — knowledge.md format: shortcuts only
system: 00 Admin
knowledge-[code].md files must contain shortcuts and techniques only. No data, no session history, no decisions. If it belongs in a decision record or session l …
tap
⌂ Admin Hub →
id
8
system
00 Admin
date
07/07/26
subject
D094 — knowledge.md format: shortcuts only
approved_by
USR369 David
tr_id
—
detail
knowledge-[code].md files must contain shortcuts and techniques only. No data, no session history, no decisions. If it belongs in a decision record or session log, it goes there. Goal is wisdom not storage. Updated RULES-S.md under KNOWLEDGE LOG PROTOCOL Format section.
description
D094 — knowledge.md format: shortcuts only
▼ Show timestamps
created_at
2026-07-08 00:06:32
⊞ Full detail →
7
D099 — RULES-S.md updated with endpoint codes GOV4 CLEAN governance dir session sequences
system: 00 Admin
Admin session 006 07/06/26
tap
⌂ Admin Hub →
id
7
system
00 Admin
date
07/07/26
subject
D099 — RULES-S.md updated with endpoint codes GOV4 CLEAN governance dir session sequences
approved_by
USR369 David
se_id
—
tr_id
—
detail
Admin session 006 07/06/26
description
D099 — RULES-S.md updated with endpoint codes GOV4 CLEAN governance dir session sequences
▼ Show timestamps
created_at
2026-07-07 02:53:10
⊞ Full detail →
6
Round-trip test — Session 002
system: 00 Admin
Full load→work→save test executed. All endpoints live. BLOCKER 1 and BLOCKER 2 resolved. Phase 2 complete.
tap
⌂ Admin Hub →
id
6
system
00 Admin
date
07/05/26
subject
Round-trip test — Session 002
approved_by
Admin [00]
se_id
—
tr_id
—
detail
Full load→work→save test executed. All endpoints live. BLOCKER 1 and BLOCKER 2 resolved. Phase 2 complete.
description
Round-trip test — Session 002
▼ Show timestamps
created_at
2026-07-05 01:59:54
⊞ Full detail →
5
Three-world architecture locked in preferences
system: 00 Admin
v1.5 down there / v1.6 in transition / v2.0 destination. Preferences updated by David to reflect all three worlds.
tap
⌂ Admin Hub →
id
5
system
00 Admin
date
07/04/26
subject
Three-world architecture locked in preferences
approved_by
USR369 David
se_id
—
tr_id
—
detail
v1.5 down there / v1.6 in transition / v2.0 destination. Preferences updated by David to reflect all three worlds.
description
Three-world architecture locked in preferences
▼ Show timestamps
created_at
2026-07-04 22:29:31
⊞ Full detail →
4
System 00 renamed SERADM to Admin everywhere
system: 00 Admin
All live pages, directories, transfer inboxes updated. systems/00-admin/ is canonical directory.
tap
⌂ Admin Hub →
id
4
system
00 Admin
date
07/04/26
subject
System 00 renamed SERADM to Admin everywhere
approved_by
USR369 David
se_id
—
tr_id
—
detail
All live pages, directories, transfer inboxes updated. systems/00-admin/ is canonical directory.
description
System 00 renamed SERADM to Admin everywhere
▼ Show timestamps
created_at
2026-07-04 22:29:31
⊞ Full detail →
3
config.json v1.6 built — lean server-load config
system: 00 Admin
systems/00-admin/config/config.json live. Template at governance/CONFIG_TEMPLATE_v1.6.json.
tap
⌂ Admin Hub →
id
3
system
00 Admin
date
07/04/26
subject
config.json v1.6 built — lean server-load config
approved_by
USR369 David
se_id
—
tr_id
—
detail
systems/00-admin/config/config.json live. Template at governance/CONFIG_TEMPLATE_v1.6.json.
description
config.json v1.6 built — lean server-load config
▼ Show timestamps
created_at
2026-07-04 22:29:31
⊞ Full detail →
2
Commands v2.0 deployed to governance
system: 00 Admin
01_COMMANDS_v2.0.md live. Old renamed to v1.5 reference. PICKUP/DROP/RECORD/LOG/STATUS/DEPLOY/VERIFY/BOOTSTRAP defined.
tap
⌂ Admin Hub →
id
2
system
00 Admin
date
07/04/26
subject
Commands v2.0 deployed to governance
approved_by
USR369 David
se_id
—
tr_id
—
detail
01_COMMANDS_v2.0.md live. Old renamed to v1.5 reference. PICKUP/DROP/RECORD/LOG/STATUS/DEPLOY/VERIFY/BOOTSTRAP defined.
description
Commands v2.0 deployed to governance
▼ Show timestamps
created_at
2026-07-04 22:29:31
⊞ Full detail →
1
Admin [00] per-system DB built — mirrors Server [04]
system: 00 Admin
systems/00-admin/data/api.php live. Four tables: decisions, sessions, events, transfers_log.
tap
⌂ Admin Hub →
id
1
system
00 Admin
date
07/04/26
subject
Admin [00] per-system DB built — mirrors Server [04]
approved_by
USR369 David
se_id
—
tr_id
—
detail
systems/00-admin/data/api.php live. Four tables: decisions, sessions, events, transfers_log.
description
Admin [00] per-system DB built — mirrors Server [04]
▼ Show timestamps
created_at
2026-07-04 22:29:30
⊞ Full detail →
Backend Domains Panel DB Viewer Transfers
Backend Tools DB Viewer DB Admin Server Map File Editor Backend Tools DB Viewer DB Admin Server Map File Editor