Some blank index.html files to prevent browsing
[moodle.git] / lib / db / schemaEvent.xml
CommitLineData
945e013c 1<?xml version="1.0"?>\r
2<schema>\r
3 <table name="event">\r
4 <field name="id" type="I" size="10">\r
5 <KEY/>\r
6 <AUTOINCREMENT/>\r
7 </field>\r
8 <field name="name" type="X">\r
9 <NOTNULL/>\r
10 </field>\r
11 <field name="description" type="C" size="255" default="">\r
12 <NOTNULL/>\r
13 </field>\r
14 <field name="courseid" type="I" size="10" default="0">\r
15 <KEY/>\r
16 <NOTNULL/>\r
17 </field>\r
18 <field name="groupid" type="I" size="10" default="0">\r
19 <NOTNULL/>\r
20 </field>\r
21 <field name="userid" type="I" size="10" default="0">\r
22 <KEY/>\r
23 <NOTNULL/>\r
24 </field>\r
25 <field name="modulename" type="C" size="20" default="">\r
26 <NOTNULL/>\r
27 </field>\r
28 <field name="instance" type="I" size="10" default="0">\r
29 <NOTNULL/>\r
30 </field>\r
31 <field name="eventtype" type="C" size="20" default="">\r
32 <NOTNULL/>\r
33 </field>\r
34 <field name="timestart" type="I" size="10" default="0">\r
35 <NOTNULL/>\r
36 </field>\r
37 <field name="timeduration" type="I" size="10" default="0">\r
38 <NOTNULL/>\r
39 </field>\r
40 <field name="timemodified" type="I" size="10" default="0">\r
41 <NOTNULL/>\r
42 </field>\r
43 </table>\r
44 <sql>\r
45 <descr>Insert 1 row for testing only...comment out later</descr>\r
46 <query platform="postgres|postgres7">\r
47 insert into event values (1,1,1,1,1,1,1,1,1,1,1,1)\r
48 </query>\r
49 <query platform="mysql">\r
50 insert into event values (1,1,1,1,1,1,1,1,1,1,1,1)\r
51 </query>\r
52 <query platform="oci8po">\r
53 insert into event values (1,1,1,1,1,1,1,1,1,1,1,1)\r
54 </query>\r
55 </sql>\r
56</schema>\r
57\r