Some blank index.html files to prevent browsing
[moodle.git] / lib / db / schemaEvent.xml
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