2: 2013-03-22 (Fri) 09:56:58 iseki |
3: 2013-03-24 (Sun) 21:20:51 iseki |
| | | |
| #br | | #br |
| + | |
| + | *** DB [#l2928f94] |
| + | - mdl_apply |
| + | mysql> show columns from mdl_apply; |
| + | +--------------------+--------------+------+-----+----------+----------------+ |
| + | | 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) | NO | | 0 | | |
| + | | email_notification | tinyint(1) | NO | | 0 | | |
| + | | multiple_submit | tinyint(1) | NO | | 0 | | |
| + | | use_calendar | tinyint(1) | NO | | 0 | | |
| + | | name_pattern | varchar(16) | NO | | lastname | | |
| + | | time_open | bigint(10) | NO | | 0 | | |
| + | | time_close | bigint(10) | NO | | 0 | | |
| + | | time_modified | bigint(10) | NO | | 0 | | |
| + | +--------------------+--------------+------+-----+----------+----------------+ |
| + | 12 rows in set (0.05 sec) |
| + | |
| + | - mdl_apply_submit |
| + | mysql> show columns from mdl_apply_submit; |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | apply_id | bigint(10) | NO | MUL | 0 | | |
| + | | user_id | bigint(10) | NO | | 0 | | |
| + | | version | mediumint(6) | NO | | 0 | | |
| + | | title | varchar(32) | NO | | | | |
| + | | class | tinyint(1) | NO | | 0 | | |
| + | | acked | tinyint(1) | NO | | 0 | | |
| + | | acked_user | bigint(10) | NO | | 0 | | |
| + | | acked_time | bigint(10) | NO | | 0 | | |
| + | | execd | tinyint(1) | NO | | 0 | | |
| + | | execd_user | bigint(10) | NO | | 0 | | |
| + | | execd_time | bigint(10) | NO | | 0 | | |
| + | | time_modified | bigint(10) | NO | | 0 | | |
| + | | otitle | varchar(32) | NO | | | | |
| + | | oclass | tinyint(1) | NO | | 0 | | |
| + | | oacked | tinyint(1) | NO | | 0 | | |
| + | | oacked_user | bigint(10) | NO | | 0 | | |
| + | | oacked_time | bigint(10) | NO | | 0 | | |
| + | | oexecd | tinyint(1) | NO | | 0 | | |
| + | | oexecd_user | bigint(10) | NO | | 0 | | |
| + | | oexecd_time | bigint(10) | NO | | 0 | | |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | 21 rows in set (0.00 sec) |
| + | |
| + | - mdl_apply_value |
| + | mysql> show columns from mdl_apply_value; |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | submit_id | bigint(10) | NO | MUL | 0 | | |
| + | | item_id | bigint(10) | NO | MUL | 0 | | |
| + | | version | mediumint(6) | NO | | 0 | | |
| + | | value | longtext | NO | | NULL | | |
| + | | time_modified | bigint(10) | NO | | 0 | | |
| + | +---------------+--------------+------+-----+---------+----------------+ |
| + | 6 rows in set (0.00 sec) |
| + | |
| + | - mdl_apply_item |
| + | mysql> show columns from mdl_apply_item; |
| + | +--------------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +--------------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | apply_id | bigint(10) | NO | MUL | 0 | | |
| + | | template | bigint(10) | NO | MUL | 0 | | |
| + | | name | varchar(255) | NO | | | | |
| + | | label | varchar(255) | NO | | | | |
| + | | presentation | longtext | NO | | NULL | | |
| + | | typ | varchar(255) | NO | | | | |
| + | | hasvalue | tinyint(1) | NO | | 0 | | |
| + | | position | smallint(3) | NO | | 0 | | |
| + | | required | tinyint(1) | NO | | 0 | | |
| + | | dependitem | bigint(10) | NO | | 0 | | |
| + | | dependvalue | varchar(255) | NO | | | | |
| + | | options | varchar(255) | NO | | | | |
| + | +--------------+--------------+------+-----+---------+----------------+ |
| + | 13 rows in set (0.00 sec) |
| + | |
| + | - mdl_apply_template |
| + | mysql> show columns from mdl_apply_template; |
| + | +----------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| + | | course | bigint(10) | NO | MUL | 0 | | |
| + | | name | varchar(255) | NO | | | | |
| + | | ispublic | tinyint(1) | NO | | 0 | | |
| + | +----------+--------------+------+-----+---------+----------------+ |
| + | 4 rows in set (0.00 sec) |
| | | |
| *** Bug [#zffe431e] | | *** Bug [#zffe431e] |
| - captcha | | - captcha |
- | - pagebreak で前に戻るとデータが消えている | |
| #br | | #br |