Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldTypePurpose
passwordchar(90)Encrypted password
gradechar(30)Degree or programme of student students are on
surnamechar(35)Last name
initialschar(10)Initials
titlevarchar(30)Title
usernamechar(15)Username (should match LDAP where required)
emailchar(65)Email address
roleschar(40)

Role of the current user (staff, student, sysadmin, etc). See also User Roles

Info

This field was removed in Rogo 7.2.0


idint(10) unsignedPrimary Key – auto increment.
first_nameschar(60)First names
genderenum('Male','Female')Sex
special_needstinyint(4)Flag where a student has special needs (see special_needs table)
yearofstudytinyint(4)Year of study for students
user_deleteddatetimeStores when a user was deleted. NULL = still live.
password_expireint(11) unsignedDate when cached password will expire. Set to NULL so passwords do not expire in Rogo (i.e. for locally stored passwords)

...