Changeset 6b5d7da in Klonkt for src/config/database.js
- Timestamp:
- 07/24/2026 04:56:51 PM (7 weeks ago)
- Branches:
- main
- Children:
- e61c289
- Parents:
- 9a00f28
- File:
-
- 1 edited
-
src/config/database.js (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
src/config/database.js
r9a00f28 r6b5d7da 405 405 ); 406 406 CREATE INDEX IF NOT EXISTS idx_ap_blocks_target ON ap_blocks(target); 407 CREATE TABLE IF NOT EXISTS ap_guardianships ( 408 id INTEGER PRIMARY KEY AUTOINCREMENT, 409 slug TEXT NOT NULL, -- our local site in this relation (guardianship module) 410 role TEXT NOT NULL, -- 'guardian' (slug guards other) | 'ward' (other guards slug) 411 other_uri TEXT NOT NULL, -- the counterpart actor URI (local or remote) 412 other_handle TEXT, -- cached @user@host for display 413 status TEXT NOT NULL, -- 'offered' (handshake pending) | 'accepted' 414 offer_id TEXT, -- the Offer activity id (FEP-633c section 3) 415 created_at DATETIME DEFAULT CURRENT_TIMESTAMP, 416 UNIQUE(slug, role, other_uri) 417 ); 418 CREATE INDEX IF NOT EXISTS idx_ap_guardianships_slug ON ap_guardianships(slug, role, status); 407 419 CREATE TABLE IF NOT EXISTS ap_delivery ( 408 420 id INTEGER PRIMARY KEY AUTOINCREMENT, … … 485 497 ensureColumn('ap_outbox', 'to_actors', 'TEXT'); // JSON array of recipient actor URIs for direct notes 486 498 ensureColumn('ap_outbox', 'help_request', 'INTEGER'); // FEP-633c shaer:helpRequest (ward's call for help) 499 ensureColumn('ap_mentions', 'help_request', 'INTEGER'); // inbound ward call-for-help (Guardian PWA message centre) 487 500 ensureColumn('ap_followers', 'name', 'TEXT'); // cached display name (shaer-aa3) 488 501 ensureColumn('ap_followers', 'handle', 'TEXT'); // @user@host
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)