Update database tables authored by Elke Kreim's avatar Elke Kreim
...@@ -72,5 +72,27 @@ Indexes: ...@@ -72,5 +72,27 @@ Indexes:
"mdl_roleassi_useconrol_ix" btree (userid, contextid, roleid) "mdl_roleassi_useconrol_ix" btree (userid, contextid, roleid)
``` ```
### mdl_context
```bash
Table "public.mdl_context"
Column | Type | Collation | Nullable | Default
--------------+------------------------+-----------+----------+-----------------------------------------
id | bigint | | not null | nextval('mdl_context_id_seq'::regclass)
contextlevel | bigint | | not null | 0
instanceid | bigint | | not null | 0
path | character varying(255) | | |
depth | smallint | | not null | 0
locked | smallint | | not null | 0
Indexes:
"mdl_cont_id_pk" PRIMARY KEY, btree (id)
"mdl_cont_conins_uix" UNIQUE, btree (contextlevel, instanceid)
"mdl_cont_ins_ix" btree (instanceid)
"mdl_cont_pat_ix" btree (path)
"mdl_cont_pat_ix_pattern" btree (path varchar_pattern_ops)
```