diff options
| author | Erik Johnston <erik@matrix.org> | 2017-07-11 09:58:59 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2017-07-11 11:42:25 +0100 |
| commit | 83936293eb3ddb8998191b537153eaeec5e7afb0 (patch) | |
| tree | c3aed88e8b0ed7c2f4105512f7f90c891aa9ab4b /synapse/storage/schema/delta/43 | |
| parent | Initial group server implementation (diff) | |
| download | synapse-83936293eb3ddb8998191b537153eaeec5e7afb0.tar.xz | |
Comments
Diffstat (limited to 'synapse/storage/schema/delta/43')
| -rw-r--r-- | synapse/storage/schema/delta/43/group_server.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/43/group_server.sql b/synapse/storage/schema/delta/43/group_server.sql index 6f1a941990..5dc7a497e2 100644 --- a/synapse/storage/schema/delta/43/group_server.sql +++ b/synapse/storage/schema/delta/43/group_server.sql @@ -24,6 +24,7 @@ CREATE TABLE groups ( CREATE UNIQUE INDEX groups_idx ON groups(group_id); +-- list of users the group server thinks are joined CREATE TABLE group_users ( group_id TEXT NOT NULL, user_id TEXT NOT NULL, @@ -35,7 +36,7 @@ CREATE TABLE group_users ( CREATE INDEX groups_users_g_idx ON group_users(group_id, user_id); CREATE INDEX groups_users_u_idx ON group_users(user_id); - +-- list of users the group server thinks are invited CREATE TABLE group_invites ( group_id TEXT NOT NULL, user_id TEXT NOT NULL @@ -55,6 +56,7 @@ CREATE INDEX groups_rooms_g_idx ON group_rooms(group_id, room_id); CREATE INDEX groups_rooms_r_idx ON group_rooms(room_id); +-- List of attestations we've given out and need to renew CREATE TABLE group_attestations_renewals ( group_id TEXT NOT NULL, user_id TEXT NOT NULL, @@ -65,6 +67,8 @@ CREATE INDEX group_attestations_renewals_g_idx ON group_attestations_renewals(gr CREATE INDEX group_attestations_renewals_u_idx ON group_attestations_renewals(user_id); CREATE INDEX group_attestations_renewals_v_idx ON group_attestations_renewals(valid_until_ms); + +-- List of attestations we've received from remotes and are interested in. CREATE TABLE group_attestations_remote ( group_id TEXT NOT NULL, user_id TEXT NOT NULL, |