2: 2013-04-03 (水) 09:38:48 iseki  |
3: 2013-04-09 (火) 00:16:53 iseki |
| | | id | bigint(10) | NO | PRI | NULL | auto_increment | | | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| | | courseid | bigint(10) | NO | MUL | 0 | | | | | courseid | bigint(10) | NO | MUL | 0 | | |
| - | | groupid | bigint(10) | NO | MUL | 0 | | | + | | classid | bigint(10) | NO | | 0 | | |
| | | creator | bigint(10) | NO | | 0 | | | | | creator | bigint(10) | NO | | 0 | | |
| | | sessdate | bigint(10) | NO | MUL | 0 | | | | | sessdate | bigint(10) | NO | MUL | 0 | | |
| | | id | bigint(10) | NO | PRI | NULL | auto_increment | | | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| | | courseid | bigint(10) | NO | MUL | 0 | | | | | courseid | bigint(10) | NO | MUL | 0 | | |
| - | | groupid | bigint(10) | NO | MUL | 0 | | | + | | classid | bigint(10) | NO | | 0 | | |
| - | | status | varchar(1) | NO | MUL | Y | | | + | | status | varchar(1) | NO | | Y | | |
| | | grade | mediumint(5) | NO | | 0 | | | | | grade | mediumint(5) | NO | | 0 | | |
| | +----------+--------------+------+-----+---------+----------------+ | | +----------+--------------+------+-----+---------+----------------+ |
| - | 5 rows in set (0.02 sec) | + | 5 rows in set (0.00 sec) |
| | | | |
| | - autoattend_students | | - autoattend_students |
| | | attsid | bigint(10) | NO | MUL | 0 | | | | | attsid | bigint(10) | NO | MUL | 0 | | |
| | | studentid | bigint(10) | NO | MUL | 0 | | | | | studentid | bigint(10) | NO | MUL | 0 | | |
| - | | status | varchar(1) | NO | MUL | Y | | | + | | classid | bigint(10) | NO | | 0 | | |
| | + | | status | varchar(1) | NO | | Y | | |
| | | called | varchar(1) | NO | | D | | | | | called | varchar(1) | NO | | D | | |
| | | calledby | bigint(10) | NO | | 0 | | | | | calledby | bigint(10) | NO | | 0 | | |
| | | ipaddress | varchar(20) | NO | | | | | | | ipaddress | varchar(20) | NO | | | | |
| | +------------+-------------+------+-----+---------+----------------+ | | +------------+-------------+------+-----+---------+----------------+ |
| - | 9 rows in set (0.01 sec) | + | 10 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) |
| | | | |
| | - autoattendmod | | - autoattendmod |
