Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
mod_apply/devel/DB
[
Front page
]
[ ]
Start:
- mdl_apply
mysql> show columns from mdl_apply;
+-------------------------+--------------+------+-----+-...
| Field | Type | Null | Key | ...
+-------------------------+--------------+------+-----+-...
| id | bigint(10) | NO | PRI | ...
| course | bigint(10) | NO | MUL | ...
| name | varchar(255) | NO | | ...
| intro | longtext | NO | | ...
| introformat | smallint(4) | NO | | ...
| email_notification | tinyint(1) | NO | | ...
| email_notification_user | tinyint(1) | NO | | ...
| multiple_submit | tinyint(1) | NO | | ...
| use_calendar | tinyint(1) | NO | | ...
| name_pattern | varchar(16) | NO | | ...
| only_acked_accept | tinyint(1) | NO | | ...
| enable_deletemode | tinyint(1) | NO | | ...
| can_discard | tinyint(1) | NO | | ...
| date_format | varchar(32) | NO | | ...
| time_open | bigint(10) | NO | | ...
| time_close | bigint(10) | NO | | ...
| time_modified | bigint(10) | NO | | ...
+-------------------------+--------------+------+-----+-...
17 rows in set (0.00 sec)
- mdl_apply_submit
mysql> show columns from mdl_apply_submit;
+---------------+--------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+---------------+--------------+------+-----+---------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| 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 | ...
+---------------+--------------+------+-----+---------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| 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 | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| 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_...
| course | bigint(10) | NO | MUL | 0 | ...
| name | varchar(255) | NO | | | ...
| ispublic | tinyint(1) | NO | | 0 | ...
+----------+--------------+------+-----+---------+------...
4 rows in set (0.00 sec)
End:
- mdl_apply
mysql> show columns from mdl_apply;
+-------------------------+--------------+------+-----+-...
| Field | Type | Null | Key | ...
+-------------------------+--------------+------+-----+-...
| id | bigint(10) | NO | PRI | ...
| course | bigint(10) | NO | MUL | ...
| name | varchar(255) | NO | | ...
| intro | longtext | NO | | ...
| introformat | smallint(4) | NO | | ...
| email_notification | tinyint(1) | NO | | ...
| email_notification_user | tinyint(1) | NO | | ...
| multiple_submit | tinyint(1) | NO | | ...
| use_calendar | tinyint(1) | NO | | ...
| name_pattern | varchar(16) | NO | | ...
| only_acked_accept | tinyint(1) | NO | | ...
| enable_deletemode | tinyint(1) | NO | | ...
| can_discard | tinyint(1) | NO | | ...
| date_format | varchar(32) | NO | | ...
| time_open | bigint(10) | NO | | ...
| time_close | bigint(10) | NO | | ...
| time_modified | bigint(10) | NO | | ...
+-------------------------+--------------+------+-----+-...
17 rows in set (0.00 sec)
- mdl_apply_submit
mysql> show columns from mdl_apply_submit;
+---------------+--------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+---------------+--------------+------+-----+---------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| 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 | ...
+---------------+--------------+------+-----+---------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| 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 | E...
+--------------+--------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| 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_...
| course | bigint(10) | NO | MUL | 0 | ...
| name | varchar(255) | NO | | | ...
| ispublic | tinyint(1) | NO | | 0 | ...
+----------+--------------+------+-----+---------+------...
4 rows in set (0.00 sec)
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today
Who's Online
72 user(s) are online (4 user(s) are browsing xpwiki)
Members: 0
Guests: 72
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com