Changes
Page history
Update database tables
authored
Sep 27, 2024
by
Elke Kreim
Show whitespace changes
Inline
Side-by-side
database-tables.md
View page @
c3af36ac
...
@@ -92,6 +92,77 @@ Indexes:
...
@@ -92,6 +92,77 @@ Indexes:
"mdl_cont_pat_ix_pattern"
btree
(
path varchar_pattern_ops
)
"mdl_cont_pat_ix_pattern"
btree
(
path varchar_pattern_ops
)
```
```
### mdl_user
```
bash
Column | Type | Collation | Nullable | Default
-------------------
+------------------------+-----------+----------+--------------------------------------
id
| bigint | | not null | nextval
(
'mdl_user_id_seq'
::regclass
)
auth | character varying
(
20
)
| | not null |
'manual'
::character varying
confirmed | smallint | | not null | 0
policyagreed | smallint | | not null | 0
deleted | smallint | | not null | 0
suspended | smallint | | not null | 0
mnethostid | bigint | | not null | 0
username | character varying
(
100
)
| | not null |
''
::character varying
password | character varying
(
255
)
| | not null |
''
::character varying
idnumber | character varying
(
255
)
| | not null |
''
::character varying
firstname | character varying
(
100
)
| | not null |
''
::character varying
lastname | character varying
(
100
)
| | not null |
''
::character varying
email | character varying
(
100
)
| | not null |
''
::character varying
emailstop | smallint | | not null | 0
phone1 | character varying
(
20
)
| | not null |
''
::character varying
phone2 | character varying
(
20
)
| | not null |
''
::character varying
institution | character varying
(
255
)
| | not null |
''
::character varying
department | character varying
(
255
)
| | not null |
''
::character varying
address | character varying
(
255
)
| | not null |
''
::character varying
city | character varying
(
120
)
| | not null |
''
::character varying
country | character varying
(
2
)
| | not null |
''
::character varying
lang | character varying
(
30
)
| | not null |
'en'
::character varying
calendartype | character varying
(
30
)
| | not null |
'gregorian'
::character varying
theme | character varying
(
50
)
| | not null |
''
::character varying
timezone | character varying
(
100
)
| | not null |
'99'
::character varying
firstaccess | bigint | | not null | 0
lastaccess | bigint | | not null | 0
lastlogin | bigint | | not null | 0
currentlogin | bigint | | not null | 0
lastip | character varying
(
45
)
| | not null |
''
::character varying
secret | character varying
(
15
)
| | not null |
''
::character varying
picture | bigint | | not null | 0
description | text | | |
descriptionformat | smallint | | not null | 1
mailformat | smallint | | not null | 1
maildigest | smallint | | not null | 0
maildisplay | smallint | | not null | 2
autosubscribe | smallint | | not null | 1
trackforums | smallint | | not null | 0
timecreated | bigint | | not null | 0
timemodified | bigint | | not null | 0
trustbitmask | bigint | | not null | 0
imagealt | character varying
(
255
)
| | |
lastnamephonetic | character varying
(
255
)
| | |
firstnamephonetic | character varying
(
255
)
| | |
middlename | character varying
(
255
)
| | |
alternatename | character varying
(
255
)
| | |
moodlenetprofile | character varying
(
255
)
| | |
Indexes:
"mdl_user_id_pk"
PRIMARY KEY, btree
(
id
)
"mdl_user_alt_ix"
btree
(
alternatename
)
"mdl_user_aut_ix"
btree
(
auth
)
"mdl_user_cit_ix"
btree
(
city
)
"mdl_user_con_ix"
btree
(
confirmed
)
"mdl_user_cou_ix"
btree
(
country
)
"mdl_user_del_ix"
btree
(
deleted
)
"mdl_user_ema_ix"
btree
(
email
)
"mdl_user_fir2_ix"
btree
(
firstnamephonetic
)
"mdl_user_fir_ix"
btree
(
firstname
)
"mdl_user_idn_ix"
btree
(
idnumber
)
"mdl_user_las2_ix"
btree
(
lastaccess
)
"mdl_user_las3_ix"
btree
(
lastnamephonetic
)
"mdl_user_las_ix"
btree
(
lastname
)
"mdl_user_mid_ix"
btree
(
middlename
)
"mdl_user_mneuse_uix"
UNIQUE, btree
(
mnethostid, username
)
```
...
...
...
...
