Download this file
| 1 | -- A person is a person ref and a blind index. There is no address column |
| 2 | -- here and there is not meant to be one: §10 says "people — person ref, |
| 3 | -- blind index, created_at. No address column", and gate 2's schema half |
| 4 | -- (internal/guardstest/noaddress_test.go) fails the build if one appears. |
| 5 | -- |
| 6 | -- blind_index is the only way back from an address to a person, which is |
| 7 | -- why HOME_PEPPER is a one-way door: lose it and every row here is |
| 8 | -- orphaned. Nothing writes this table yet. |
| 9 | CREATE TABLE people ( |
| 10 | person_ref TEXT PRIMARY KEY, |
| 11 | blind_index TEXT NOT NULL UNIQUE, -- UNIQUE already indexes it; no second index |
| 12 | created_at TEXT NOT NULL |
| 13 | ); |
| 14 | |
amadan