Skip to content

Instantly share code, notes, and snippets.

@vaughany
Created November 15, 2016 09:25
Show Gist options
  • Save vaughany/bf71ede4b2c53495b35e1cfc5fe7f9d6 to your computer and use it in GitHub Desktop.
Save vaughany/bf71ede4b2c53495b35e1cfc5fe7f9d6 to your computer and use it in GitHub Desktop.
Moodle 3.1 user table fields
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