Changeset 65abc85 in Klonkt for src/config/database.js
- Timestamp:
- 07/28/2026 10:40:50 AM (6 weeks ago)
- Branches:
- main
- Children:
- 2708282
- Parents:
- 2a76184
- File:
-
- 1 edited
-
src/config/database.js (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
src/config/database.js
r2a76184 r65abc85 502 502 PRIMARY KEY (slug, offer_id, party_uri) 503 503 ); 504 -- FEP-633c §5.6: a gated setting a ward's guardians decide together, which 505 -- has to work when they live on other servers (the ordinary case). One row 506 -- per guardian answer; the ward's server tallies (§3.5) and enforces. 507 -- The proposals themselves, so an Accept that only references the offer 508 -- id can still be resolved to "which feature, which value". 509 CREATE TABLE IF NOT EXISTS ap_gated_offers ( 510 offer_id TEXT PRIMARY KEY, 511 slug TEXT NOT NULL, -- the ward, on this server 512 feature TEXT NOT NULL, 513 value INTEGER NOT NULL, 514 created_at DATETIME DEFAULT CURRENT_TIMESTAMP 515 ); 516 CREATE TABLE IF NOT EXISTS ap_gated_votes ( 517 slug TEXT NOT NULL, -- the WARD, on this server 518 feature TEXT NOT NULL, -- e.g. 'shaer:externalEmbeds' 519 guardian_uri TEXT NOT NULL, -- who answered (must be a committed guardian) 520 value INTEGER NOT NULL, -- the value they voted for (0/1) 521 opened_at DATETIME NOT NULL, -- when this decision opened (the window start) 522 created_at DATETIME DEFAULT CURRENT_TIMESTAMP, 523 PRIMARY KEY (slug, feature, guardian_uri) 524 ); 504 525 CREATE TABLE IF NOT EXISTS ap_delivery ( 505 526 id INTEGER PRIMARY KEY AUTOINCREMENT,
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)