Changeset 6eab7e9 in Klonkt for src/config
- Timestamp:
- 07/28/2026 11:22:07 PM (6 weeks ago)
- Branches:
- main
- Children:
- 0202104
- Parents:
- 6c152a5
- File:
-
- 1 edited
-
src/config/database.js (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
src/config/database.js
r6c152a5 r6eab7e9 523 523 PRIMARY KEY (slug, feature, guardian_uri) 524 524 ); 525 -- Guardian availability (FEP-633c 3.6): one guardian's attention as seen 526 -- from one ward on this server. Never public; the ward reads it via the 527 -- owner-only guardians queue. One rule above all: one answer restores 528 -- everything, so every row here is one answer away from disappearing. 529 CREATE TABLE IF NOT EXISTS ap_guardian_attention ( 530 ward_slug TEXT NOT NULL, 531 guardian_uri TEXT NOT NULL, 532 state TEXT NOT NULL DEFAULT 'active', -- 'active' | 'away' | 'dormant' 533 away_until INTEGER, -- epoch ms while declared away 534 PRIMARY KEY (ward_slug, guardian_uri) 535 ); 536 -- The ONLY admissible dormancy evidence (3.6.2): directly addressed 537 -- requests that went unanswered. Calendar time alone never counts. 538 CREATE TABLE IF NOT EXISTS ap_attention_requests ( 539 ward_slug TEXT NOT NULL, 540 guardian_uri TEXT NOT NULL, 541 request_id TEXT NOT NULL, 542 asked_at INTEGER NOT NULL, -- epoch ms 543 PRIMARY KEY (ward_slug, guardian_uri, request_id) 544 ); 545 -- A lapse (3.6.3): the available co-guardians deciding to release a 546 -- dormant one. Irreversible, so the window always runs in full; any sign 547 -- of life from the target cancels it outright. 548 CREATE TABLE IF NOT EXISTS ap_lapses ( 549 id TEXT PRIMARY KEY, 550 ward_slug TEXT NOT NULL, 551 ward_uri TEXT NOT NULL, 552 target_uri TEXT NOT NULL, 553 opened_by TEXT NOT NULL, 554 set_json TEXT NOT NULL, -- the available set at open, target excluded 555 accepts_json TEXT NOT NULL DEFAULT '[]', 556 rejects_json TEXT NOT NULL DEFAULT '[]', 557 opened_at INTEGER NOT NULL, -- epoch ms 558 window_ms INTEGER NOT NULL, 559 cancelled INTEGER NOT NULL DEFAULT 0, 560 applied INTEGER NOT NULL DEFAULT 0, 561 created_at DATETIME DEFAULT CURRENT_TIMESTAMP 562 ); 525 563 CREATE TABLE IF NOT EXISTS ap_delivery ( 526 564 id INTEGER PRIMARY KEY AUTOINCREMENT, … … 617 655 ensureColumn('ap_mentions', 'help_request', 'INTEGER'); // inbound ward call-for-help (Guardian PWA message centre) 618 656 ensureColumn('ap_outbox', 'wave', 'INTEGER'); // FEP-633c shaer:wave (guardian -> ward nudge) 657 ensureColumn('ap_outbox', 'away_until', 'INTEGER'); // FEP-633c 3.6.1 shaer:away + endTime (epoch ms) 619 658 ensureColumn('ap_mentions', 'wave', 'INTEGER'); // inbound guardian wave 620 659 // FEP-633c §2.2: object hint that the author is a ward. Register-only for now;
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)