1: 2013-04-19 (金) 16:38:18 iseki  |
現: 2018-09-21 (金) 10:40:26 iseki |
| | - mdl_apply | | - mdl_apply |
| | mysql> show columns from mdl_apply; | | mysql> show columns from mdl_apply; |
| - | +--------------------+--------------+------+-----+----------+----------------+ | + | +-------------------------+--------------+------+-----+----------+----------------+ |
| - | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| - | +--------------------+--------------+------+-----+----------+----------------+ | + | +-------------------------+--------------+------+-----+----------+----------------+ |
| - | | id | bigint(10) | NO | PRI | NULL | auto_increment | | + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| - | | course | bigint(10) | NO | MUL | 0 | | | + | | course | bigint(10) | NO | MUL | 0 | | |
| - | | name | varchar(255) | NO | | | | | + | | name | varchar(255) | NO | | | | |
| - | | intro | longtext | NO | | NULL | | | + | | intro | longtext | NO | | NULL | | |
| - | | introformat | smallint(4) | NO | | 0 | | | + | | introformat | smallint(4) | NO | | 0 | | |
| - | | email_notification | tinyint(1) | NO | | 0 | | | + | | email_notification | tinyint(1) | NO | | 0 | | |
| - | | multiple_submit | tinyint(1) | NO | | 0 | | | + | | email_notification_user | tinyint(1) | NO | | 0 | | |
| - | | use_calendar | tinyint(1) | NO | | 0 | | | + | | multiple_submit | tinyint(1) | NO | | 0 | | |
| - | | name_pattern | varchar(16) | NO | | lastname | | | + | | use_calendar | tinyint(1) | NO | | 0 | | |
| - | | time_open | bigint(10) | NO | | 0 | | | + | | name_pattern | varchar(16) | NO | | lastname | | |
| - | | time_close | bigint(10) | NO | | 0 | | | + | | only_acked_accept | tinyint(1) | NO | | 0 | | |
| - | | time_modified | bigint(10) | NO | | 0 | | | + | | enable_deletemode | tinyint(1) | NO | | 0 | | |
| - | +--------------------+--------------+------+-----+----------+----------------+ | + | | can_discard | tinyint(1) | NO | | 1 | | |
| - | 12 rows in set (0.05 sec) | + | | date_format | varchar(32) | NO | | | | |
| | + | | time_open | bigint(10) | NO | | 0 | | |
| | + | | time_close | bigint(10) | NO | | 0 | | |
| | + | | time_modified | bigint(10) | NO | | 0 | | |
| | + | +-------------------------+--------------+------+-----+----------+----------------+ |
| | + | 17 rows in set (0.00 sec) |
| | | | |
| | - mdl_apply_submit | | - mdl_apply_submit |
| | 13 rows in set (0.00 sec) | | 13 rows in set (0.00 sec) |
| | | | |
| - | - mdl_apply_template | + | - mdl_apply_template （未使用） |
| | mysql> show columns from mdl_apply_template; | | mysql> show columns from mdl_apply_template; |
| | +----------+--------------+------+-----+---------+----------------+ | | +----------+--------------+------+-----+---------+----------------+ |
