Created
November 15, 2016 09:25
-
-
Save vaughany/bf71ede4b2c53495b35e1cfc5fe7f9d6 to your computer and use it in GitHub Desktop.
Moodle 3.1 user table fields
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
id autogenerated - ignore | |
auth must equal "manual" (for the time being at least) | |
confirmed must equal 1 | |
policyagreed must equal 0 | |
deleted must equal 0 | |
suspended must equal 0 | |
mnethostid must equal 1 | |
username Moodle will most likely have rules for what can and cannot go in here, but it's probs lowercase alphanum only, plus underscores. | |
password Moodle will have a function to hash this properly, don't write your own! | |
idnumber CiaB OS ID | |
firstname as given | |
lastname as given | |
email as given | |
emailstop 0 | |
icq | |
skype | |
yahoo | |
aim | |
msn | |
phone1 as given | |
phone2 as given, if given | |
institution | |
department | |
address as given, if given | |
city as given, if given | |
country as given, if given | |
lang must equal "en" by deafult for now | |
calendartype must equal "gregorian" | |
theme | |
timezone default to "99" | |
firstaccess | |
lastaccess | |
lastlogin | |
currentlogin | |
lastip | |
secret | |
picture Use if given, "0" if not | |
url | |
description null | |
descriptionformat 1 | |
mailformat 1 | |
maildigest 0 | |
maildisplay 2 | |
autosubscribe 1 | |
trackforums 0 | |
timecreated Moodle will most likely populate this field itself. | |
timemodified Moodle will most likely populate this field itself too. | |
trustbitmask 0 | |
imagealt null | |
lastnamephonetic null unless given | |
firstnamephonetic null unless given | |
middlename null unless given | |
alternatename null unless given |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment