flagflag  
1: 2013-04-18 (Thu) 23:28:09 iseki source Cur: 2014-06-04 (Wed) 17:10:45 iseki source
Line 1: Line 1:
-** autoattend DB [#o7221fbb]+** autoattend devel [#o7221fbb] 
*** DB [#n9de12e3] *** DB [#n9de12e3]
-- autoattend_sessions+**** autoattend_sessions [#l0100cb2]
 mysql> show columns from mdl_autoattend_sessions;  mysql> show columns from mdl_autoattend_sessions;
 +--------------+--------------+------+-​----+---------+----------------+  +--------------+--------------+------+-​----+---------+----------------+
Line 26: Line 27:
 17 rows in set (0.01 sec)  17 rows in set (0.01 sec)
-- autoattend_settings+**** autoattend_settings [#l7cafe8a]
 mysql> show columns from mdl_autoattend_settings;  mysql> show columns from mdl_autoattend_settings;
- +----------+--------------+------+-----​+---------+----------------+ + +-------------+--------------+------+-----+-​--------+----------------+ 
- | 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 | 
- | courseid | bigint(10)  | NO  | MUL | 0      |                | + | courseid   | bigint(10)  | NO  | MUL | 0      |                | 
- | classid | bigint(10)  | NO  |    | 0      |                | + | classid     | bigint(10)  | NO  |    | 0      |                | 
- | status   | varchar(1)  | NO  |    | Y      |                | + | status     | varchar(1)  | NO  |    | Y      |                | 
- | grade   | mediumint(5) | NO  |    | 0      |                | + | acronym    | varchar(10)  | NO  |    |        |                | 
- +----------+--------------+------+-----​+---------+----------------+ + | title      | varchar(24)  | NO  |    |        |                | 
- 5 rows in set (0.00 sec)+ | description | varchar(64)  | NO  |    |        |                | 
 + | grade       | mediumint(5) | NO  |    | 0      |                | 
 + +-------------+--------------+------+-----+-​--------+----------------+ 
 + 8 rows in set (0.00 sec)
-- autoattend_students+**** autoattend_students [#k82a6bf9]
 mysql> show columns from mdl_autoattend_students;  mysql> show columns from mdl_autoattend_students;
 +------------+-------------+------+----​-+---------+----------------+  +------------+-------------+------+----​-+---------+----------------+
Line 56: Line 60:
 9 rows in set (0.00 sec)  9 rows in set (0.00 sec)
-- autoattend_classes+**** autoattend_classes [#p44f2d27]
 mysql> show columns from mdl_autoattend_classes;  mysql> show columns from mdl_autoattend_classes;
 +--------------+-------------+------+--​---+---------+----------------+  +--------------+-------------+------+--​---+---------+----------------+
Line 69: Line 73:
 5 rows in set (0.00 sec)  5 rows in set (0.00 sec)
-- autoattend_classifies+**** autoattend_classifies [#e948c4be]
 mysql> show columns from mdl_autoattend_classifies;  mysql> show columns from mdl_autoattend_classifies;
 +-----------+------------+------+-----+​---------+----------------+  +-----------+------------+------+-----+​---------+----------------+
Line 81: Line 85:
 4 rows in set (0.00 sec)  4 rows in set (0.00 sec)
-- autoattendmod+**** autoattendmod [#rae03d28]
 mysql> show columns from mdl_autoattendmod;  mysql> show columns from mdl_autoattendmod;
 +--------------+--------------+------+-​----+---------+----------------+  +--------------+--------------+------+-​----+---------+----------------+
Line 95: Line 99:
 6 rows in set (0.00 sec)  6 rows in set (0.00 sec)
 +#br
 +
 +*** attendance [#pef550fd]
 +**** attendance [#ed57d2db]
 + mysql> show columns from mdl_attendance ;
 + +--------+--------------+------+-----+-​--------+----------------+
 + | Field  | Type        | Null | Key | Default | Extra          |
 + +--------+--------------+------+-----+-​--------+----------------+
 + | id    | bigint(10)  | NO  | PRI | NULL    | auto_increment |
 + | course | bigint(10)  | NO  | MUL | 0      |                |
 + | name  | varchar(255) | YES  |    | NULL    |                |
 + | grade  | bigint(10)  | NO  |    | 100    |                |
 + +--------+--------------+------+-----+-​--------+----------------+
 + 4 rows in set (0.00 sec)
 +
 +**** attendance_log [#n99bf917]
 + mysql> show columns from mdl_attendance_log;
 + +-----------+--------------+------+----​-+---------+----------------+
 + | Field    | Type        | Null | Key | Default | Extra          |
 + +-----------+--------------+------+----​-+---------+----------------+
 + | id        | bigint(10)  | NO  | PRI | NULL    | auto_increment |
 + | sessionid | bigint(10)  | NO  | MUL | 0      |                |
 + | studentid | bigint(10)  | NO  | MUL | 0      |                |
 + | statusid  | bigint(10)  | NO  | MUL | 0      |                |
 + | statusset | varchar(100) | YES  |    | NULL    |                |
 + | timetaken | bigint(10)  | NO  |    | 0      |                |
 + | takenby  | bigint(10)  | NO  |    | 0      |                |
 + | remarks  | varchar(255) | YES  |    | NULL    |                |
 + +-----------+--------------+------+----​-+---------+----------------+
 + 8 rows in set (0.00 sec)
 +
 +**** attendance_sessions [#be1329bb]
 + mysql> show columns from mdl_attendance_sessions;
 + +-------------------+------------+-----​-+-----+---------+----------------+
 + | Field            | Type      | Null | Key | Default | Extra          |
 + +-------------------+------------+-----​-+-----+---------+----------------+
 + | id                | bigint(10) | NO  | PRI | NULL    | auto_increment |
 + | attendanceid      | bigint(10) | NO  | MUL | 0      |                |
 + | groupid          | bigint(10) | NO  | MUL | 0      |                |
 + | sessdate          | bigint(10) | NO  | MUL | 0      |                |
 + | duration          | bigint(10) | NO  |    | 0      |                |
 + | lasttaken        | bigint(10) | YES  |    | NULL    |                |
 + | lasttakenby      | bigint(10) | NO  |    | 0      |                |
 + | timemodified      | bigint(10) | YES  |    | NULL    |                |
 + | description      | longtext  | NO  |    | NULL    |                |
 + | descriptionformat | tinyint(2) | NO  |    | 0      |                |
 + +-------------------+------------+-----​-+-----+---------+----------------+
 + 10 rows in set (0.00 sec)
 +
 +**** attendance_statuses [#lad8e2d2]
 + mysql> show columns from mdl_attendance_statuses;
 + +--------------+-------------+------+--​---+---------+----------------+
 + | Field        | Type        | Null | Key | Default | Extra          |
 + +--------------+-------------+------+--​---+---------+----------------+
 + | id          | bigint(10)  | NO  | PRI | NULL    | auto_increment |
 + | attendanceid | bigint(10)  | NO  | MUL | 0      |                |
 + | acronym      | varchar(2)  | NO  |    |        |                |
 + | description  | varchar(30) | NO  |    |        |                |
 + | grade        | smallint(3) | NO  |    | 0      |                |
 + | visible      | tinyint(1)  | NO  | MUL | 1      |                |
 + | deleted      | tinyint(1)  | NO  | MUL | 0      |                |
 + +--------------+-------------+------+--​---+---------+----------------+
 + 7 rows in set (0.00 sec)
#br #br
Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Page owner: iseki
Site admin: admin

Site Search


Advanced Search

Login
Username:

Password:


Lost Password?
Register now!!

Sub Menu

Books

mini Calendar
Last MonthMay 2024Next Month
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
58 user(s) are online (11 user(s) are browsing xpwiki)

Members: 0
Guests: 58

more...

Access Counter
Today : 5668566856685668
Yesterday : 9324932493249324
Total : 2358482023584820235848202358482023584820235848202358482023584820
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com