Network System Laboratory - Backup source of autoattend(No. 5)

View the diff.
View the diff current.
Go to autoattend.
** DB [#n9de12e3]
- autoattend_sessions
 mysql> show columns from mdl_autoattend_sessions;
 +--------------+--------------+------+-----+---------+----------------+
 | Field        | Type         | Null | Key | Default | Extra          |
 +--------------+--------------+------+-----+---------+----------------+
 | id           | bigint(10)   | NO   | PRI | NULL    | auto_increment |
 | courseid     | bigint(10)   | NO   | MUL | 0       |                |
 | classid      | bigint(10)   | NO   |     | 0       |                |
 | creator      | bigint(10)   | NO   |     | 0       |                |
 | sessdate     | bigint(10)   | NO   | MUL | 0       |                |
 | starttime    | bigint(10)   | NO   | MUL | 0       |                |
 | endtime      | bigint(10)   | NO   |     | 0       |                |
 | latetime     | bigint(10)   | NO   |     | 0       |                |
 | takenby      | bigint(10)   | NO   |     | 0       |                |
 | timetaken    | bigint(10)   | NO   |     | 0       |                |
 | method       | varchar(1)   | NO   |     | S       |                |
 | attendkey    | varchar(36)  | YES  |     | NULL    |                |
 | denysameip   | tinyint(2)   | NO   |     | 1       |                |
 | allowip      | varchar(128) | YES  |     | NULL    |                |
 | description  | varchar(255) | YES  |     | NULL    |                |
 | state        | varchar(1)   | NO   |     | N       |                |
 | timemodified | bigint(10)   | NO   |     | 0       |                |
 +--------------+--------------+------+-----+---------+----------------+
 17 rows in set (0.01 sec)

- autoattend_settings
 mysql> show columns from mdl_autoattend_settings;
 +----------+--------------+------+-----+---------+----------------+
 | Field    | Type         | Null | Key | Default | Extra          |
 +----------+--------------+------+-----+---------+----------------+
 | id       | bigint(10)   | NO   | PRI | NULL    | auto_increment |
 | courseid | bigint(10)   | NO   | MUL | 0       |                |
 | classid  | bigint(10)   | NO   |     | 0       |                |
 | status   | varchar(1)   | NO   |     | Y       |                |
 | grade    | mediumint(5) | NO   |     | 0       |                |
 +----------+--------------+------+-----+---------+----------------+
 5 rows in set (0.00 sec)

- autoattend_students
 mysql> show columns from mdl_autoattend_students;
 +------------+-------------+------+-----+---------+----------------+
 | Field      | Type        | Null | Key | Default | Extra          |
 +------------+-------------+------+-----+---------+----------------+
 | id         | bigint(10)  | NO   | PRI | NULL    | auto_increment |
 | attsid     | bigint(10)  | NO   | MUL | 0       |                |
 | studentid  | bigint(10)  | NO   | MUL | 0       |                |
 | status     | varchar(1)  | NO   |     | Y       |                |
 | called     | varchar(1)  | NO   |     | D       |                |
 | calledby   | bigint(10)  | NO   |     | 0       |                |
 | calledtime | bigint(10)  | NO   |     | 0       |                |
 | remarks    | varchar(50) | YES  |     | NULL    |                |
 | ipaddress  | varchar(20) | NO   |     |         |                |
 +------------+-------------+------+-----+---------+----------------+
 9 rows in set (0.00 sec)

- autoattend_classes
 mysql> show columns from mdl_autoattend_classes;
 +--------------+-------------+------+-----+---------+----------------+
 | Field        | Type        | Null | Key | Default | Extra          |
 +--------------+-------------+------+-----+---------+----------------+
 | id           | bigint(10)  | NO   | PRI | NULL    | auto_increment |
 | courseid     | bigint(10)  | NO   | MUL | 0       |                |
 | creator      | bigint(10)  | NO   |     | 0       |                |
 | name         | varchar(50) | NO   |     | default |                |
 | timemodified | bigint(10)  | NO   |     | 0       |                |
 +--------------+-------------+------+-----+---------+----------------+
 5 rows in set (0.00 sec)

- autoattend_classifies
 mysql> show columns from mdl_autoattend_groups;
 +-----------+------------+------+-----+---------+----------------+
 | Field     | Type       | Null | Key | Default | Extra          |
 +-----------+------------+------+-----+---------+----------------+
 | id        | bigint(10) | NO   | PRI | NULL    | auto_increment |
 | courseid  | bigint(10) | NO   | MUL | 0       |                |
 | studentid | bigint(10) | NO   | MUL | 0       |                |
 | classid   | bigint(10) | NO   |     | 0       |                |
 +-----------+------------+------+-----+---------+----------------+
 4 rows in set (0.00 sec)

- autoattendmod
 mysql> show columns from mdl_autoattendmod;
 +--------------+--------------+------+-----+---------+----------------+
 | Field        | Type         | Null | Key | Default | Extra          |
 +--------------+--------------+------+-----+---------+----------------+
 | id           | bigint(10)   | NO   | PRI | NULL    | auto_increment |
 | course       | bigint(10)   | NO   | MUL | 0       |                |
 | name         | varchar(255) | NO   |     |         |                |
 | intro        | longtext     | NO   |     | NULL    |                |
 | introformat  | smallint(4)  | YES  |     | 0       |                |
 | timemodified | bigint(10)   | NO   |     | 0       |                |
 +--------------+--------------+------+-----+---------+----------------+
 6 rows in set (0.00 sec)

#br

** Block [#c3648f9a]
#br
** Module [#h925ddae]
#br
« Prev Next »
Backup source of autoattend (No. 5)

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter
