Herramientas de usuario

Herramientas del sitio


programacion:moodle-auth

Tabla de Contenidos

Moodle Auth

mdl_user

mysql> select id,username,firstname,lastname from mdl_user;

mysql> describe mdl_user;

Field Type Null Key Default Extra
id bigint(10) unsigned NO PRI NULL auto_increment
auth varchar(20) NO MUL manual
confirmed tinyint(1) NO MUL 0
policyagreed tinyint(1) NO 0
deleted tinyint(1) NO MUL 0
mnethostid bigint(10) unsigned NO MUL 0
username varchar(100) NO
password varchar(32) NO
idnumber varchar(255) NO MUL
firstname varchar(100) NO MUL
lastname varchar(100) NO MUL
email varchar(100) NO MUL
emailstop tinyint(1) unsigned NO 0
icq varchar(15) NO
skype varchar(50) NO
yahoo varchar(50) NO
aim varchar(50) NO
msn varchar(50) NO
phone1 varchar(20) NO
phone2 varchar(20) NO
institution varchar(40) NO
department varchar(30) NO
address varchar(70) NO
city varchar(20) NO MUL
country varchar(2) NO MUL
lang varchar(30) NO en_utf8
theme varchar(50) NO
timezone varchar(100) NO 99
firstaccess bigint(10) unsigned NO 0
lastaccess bigint(10) unsigned NO MUL 0
lastlogin bigint(10) unsigned NO 0
currentlogin bigint(10) unsigned NO 0
lastip varchar(15) NO
secret varchar(15) NO
picture tinyint(1) NO 0
url varchar(255) NO
description text YES NULL
mailformat tinyint(1) unsigned NO 1
maildigest tinyint(1) unsigned NO 0
maildisplay tinyint(2) unsigned NO 2
htmleditor tinyint(1) unsigned NO 1
ajax tinyint(1) unsigned NO 1
autosubscribe tinyint(1) unsigned NO 1
trackforums tinyint(1) unsigned NO 0
timemodified bigint(10) unsigned NO 0
trustbitmask bigint(10) unsigned NO 0
imagealt varchar(255) YES NULL
screenreader tinyint(1) NO 0

mdl_course

mysql> select id,fullname from mdl_course;

mysql> describe mdl_course;

Field Type Null Key Default Extra
id bigint(10) unsigned NO PRI NULL auto_increment
category bigint(10) unsigned NO MUL 0
sortorder bigint(10) unsigned NO 0
password varchar(50) NO
fullname varchar(254) NO
shortname varchar(100) NO MUL
idnumber varchar(100) NO MUL
summary text YES NULL
format varchar(10) NO topics
showgrades tinyint(2) unsigned NO 1
modinfo longtext YES NULL
newsitems mediumint(5) unsigned NO 1
teacher varchar(100) NO Teacher
teachers varchar(100) NO Teachers
student varchar(100) NO Student
students varchar(100) NO Students
guest tinyint(2) unsigned NO 0
startdate bigint(10) unsigned NO 0
enrolperiod bigint(10) unsigned NO 0
numsections mediumint(5) unsigned NO 1
marker bigint(10) unsigned NO 0
maxbytes bigint(10) unsigned NO 0
showreports smallint(4) unsigned NO 0
visible tinyint(1) unsigned NO 1
hiddensections tinyint(2) unsigned NO 0
groupmode smallint(4) unsigned NO 0
groupmodeforce smallint(4) unsigned NO 0
defaultgroupingid bigint(10) unsigned NO 0
lang varchar(30) NO
theme varchar(50) NO
cost varchar(10) NO
currency varchar(3) NO USD
timecreated bigint(10) unsigned NO 0
timemodified bigint(10) unsigned NO 0
metacourse tinyint(1) unsigned NO 0
requested tinyint(1) unsigned NO 0
restrictmodules tinyint(1) unsigned NO 0
expirynotify tinyint(1) unsigned NO 0
expirythreshold bigint(10) unsigned NO 0
notifystudents tinyint(1) unsigned NO 0
enrollable tinyint(1) unsigned NO 1
enrolstartdate bigint(10) unsigned NO 0
enrolenddate bigint(10) unsigned NO 0
enrol varchar(20) NO
defaultrole bigint(10) unsigned NO 0
programacion/moodle-auth.txt · Última modificación: 2013/06/18 11:46 por jherrero