| 1 | -- Artifacts mode, Phase 2 (docs/ARTIFACTS_MODE.md section 12). |
| 2 | -- |
| 3 | -- "Editors can share": a space setting that lets people with edit access |
| 4 | -- share what is in the space, as people with full access can. Off unless |
| 5 | -- a space's managers turn it on. |
| 6 | ALTER TABLE spaces ADD COLUMN editors_can_share INTEGER NOT NULL DEFAULT 0; |
| 7 | |
| 8 | -- Access requests, one row per person and folio: when they last asked. |
| 9 | -- A person asks again for the same folio at most once a day. |
| 10 | CREATE TABLE folio_access_requests ( |
| 11 | folio_id TEXT NOT NULL REFERENCES folios (id) ON DELETE CASCADE, |
| 12 | user_id TEXT NOT NULL, |
| 13 | requested_at TEXT NOT NULL, |
| 14 | PRIMARY KEY (folio_id, user_id) |
| 15 | ); |