Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 1 
<?xml version="1.0" encoding="UTF-8" ?>
2 
<!-- User login, view course and post - Tests queries 10, 12, 14 (write) -->
3 
<dataset>
4 
    <table name="log">
5 
        <column>time</column>
6 
        <column>userid</column>
7 
        <column>course</column>
8 
        <column>action</column>
9 
        <row>
10 
            <value>[start_1]</value>
11 
            <value>[user1_id]</value>
12 
            <value>[site_id]</value>
13 
            <value>login</value>
14 
        </row>
15 
        <row>
16 
            <value>[start_2]</value>
17 
            <value>[user1_id]</value>
18 
            <value>[course1_id]</value>
19 
            <value>view</value>
20 
        </row>
21 
        <row>
22 
            <value>[start_3]</value>
23 
            <value>[user1_id]</value>
24 
            <value>[course1_id]</value>
25 
            <value>add post</value>
26 
        </row>
27 
    </table>
28 
    <table name="stats_daily">
29 
        <column>courseid</column>
30 
        <column>timeend</column>
31 
        <column>roleid</column>
32 
        <column>stattype</column>
33 
        <column>stat1</column>
34 
        <column>stat2</column>
35 
        <!-- Query 2 -->
36 
        <row>
37 
            <value>[site_id]</value>
38 
            <value>[end]</value>
39 
            <value>0</value>
40 
            <value>logins</value>
41 
            <value>1</value>
42 
            <value>1</value>
43 
        </row>
44 
        <!-- Queris 3 (stat1) and 4 (stat2) -->
45 
        <row>
46 
            <value>[course1_id]</value>
47 
            <value>[end]</value>
48 
            <value>[student_roleid]</value>
49 
            <value>enrolments</value>
50 
            <value>1</value>
51 
            <value>1</value>
52 
        </row>
53 
        <!-- Queries 5 (stat1) and 6 (stat2) -->
54 
        <row>
55 
            <value>[course1_id]</value>
56 
            <value>[end]</value>
57 
            <value>0</value>
58 
            <value>enrolments</value>
59 
            <value>1</value>
60 
            <value>1</value>
61 
        </row>
62 
        <!-- Query 7 -->
63 
        <row>
64 
            <value>[site_id]</value>
65 
            <value>[end]</value>
66 
            <value>0</value>
67 
            <value>enrolments</value>
68 
            <value>4</value>
69 
            <value>1</value>
70 
        </row>
71 
        <!-- Query 9 -->
72 
        <row>
73 
            <value>[site_id]</value>
74 
            <value>[end]</value>
75 
            <value>[frontpage_roleid]</value>
76 
            <value>enrolments</value>
77 
            <value>4</value>
78 
            <value>1</value>
79 
        </row>
80 
        <!-- Query 11 -->
81 
        <row>
82 
            <value>[site_id]</value>
83 
            <value>[end]</value>
84 
            <value>0</value>
85 
            <value>activity</value>
86 
            <value>0</value>
87 
            <value>0</value>
88 
        </row>
89 
        <!-- Query 11 -->
90 
        <row>
91 
            <value>[course1_id]</value>
92 
            <value>[end]</value>
93 
            <value>0</value>
94 
            <value>activity</value>
95 
            <value>1</value>
96 
            <value>1</value>
97 
        </row>
98 
        <!-- Query 12 (read) -->
99 
        <row>
100 
            <value>[course1_id]</value>
101 
            <value>[end]</value>
102 
            <value>[student_roleid]</value>
103 
            <value>activity</value>
104 
            <value>1</value>
105 
            <value>1</value>
106 
        </row>
107 
    </table>
108 
    <table name="stats_user_daily">
109 
        <column>courseid</column>
110 
        <column>userid</column>
111 
        <column>roleid</column>
112 
        <column>timeend</column>
113 
        <column>statsreads</column>
114 
        <column>statswrites</column>
115 
        <column>stattype</column>
116 
        <!-- Query 1 -->
117 
        <row>
118 
            <value>[site_id]</value>
119 
            <value>[user1_id]</value>
120 
            <value>0</value>
121 
            <value>[end]</value>
122 
            <value>1</value>
123 
            <value>0</value>
124 
            <value>logins</value>
125 
        </row>
126 
        <!-- Query 10 -->
127 
        <row>
128 
            <value>[course1_id]</value>
129 
            <value>[user1_id]</value>
130 
            <value>0</value>
131 
            <value>[end]</value>
132 
            <value>1</value>
133 
            <value>1</value>
134 
            <value>activity</value>
135 
        </row>
136 
        <!-- Query 10 -->
137 
        <row>
138 
            <value>[site_id]</value>
139 
            <value>[user1_id]</value>
140 
            <value>0</value>
141 
            <value>[end]</value>
142 
            <value>0</value>
143 
            <value>0</value>
144 
            <value>activity</value>
145 
        </row>
146 
        <!-- Query 10 - default record -->
147 
        <row>
148 
            <value>[site_id]</value>
149 
            <value>0</value>
150 
            <value>0</value>
151 
            <value>[end]</value>
152 
            <value>0</value>
153 
            <value>0</value>
154 
            <value>activity</value>
155 
        </row>
156 
    </table>
157 
</dataset>