|
1: 2013-04-18 (木) 23:08:26 iseki  |
| | + | *** IP [#y7f751bb] |
| | + | - Allowed IPs |
| | + | -- 128.2.1.1/2 => 128.0.0.0/192.0.0.0 |
| | + | -- 222.222.111.222/255. => 222.0.0.0/255.0.0.0 |
| | + | -- 123.12.0/255.255.255.0 => 123.12.0.0/255.255.255.0 |
| | + | -- 123.31.6.0 => 123.31.6.0/255.255.255.0 |
| | + | -- 202. => 202.0.0.0/255.0.0.0 |
| | + | #br |
| | | | |
| | + | *** DB [#ic53f9bf] |
| | + | - 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_classifies; |
| | + | +-----------+------------+------+-----+---------+----------------+ |
| | + | | 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 [#u61bd317] |
| | + | #br |
| | + | ** Module [#te286389] |
| | + | #br |
