Some blank index.html files to prevent browsing
[moodle.git] / lib / db / schemaCourse_categories.xml
1 <?xml version="1.0"?>\r
2 <schema>\r
3   <table name="course_categories">\r
4     <field name="id" type="I" size="10">\r
5       <KEY/>\r
6       <AUTOINCREMENT/>\r
7     </field>\r
8     <field name="name" type="C" size="255">\r
9       <NOTNULL/>\r
10     </field>\r
11     <field name="description" type="X">\r
12       <NOTNULL/>\r
13     </field>\r
14     <field name="parent" type="I" size="10">\r
15       <NOTNULL/>\r
16     </field>\r
17     <field name="sortorder" type="I" size="10">\r
18       <NOTNULL/>\r
19     </field>\r
20     <field name="coursecount" type="I" size="10">\r
21       <NOTNULL/>\r
22     </field>\r
23     <field name="visible" type="L" size="1" default="1">\r
24       <NOTNULL/>\r
25     </field>\r
26     <field name="timemodified" type="L" size="10" default="0">\r
27       <NOTNULL/>\r
28     </field>\r
29   </table>\r
30   <sql>\r
31     <descr>Insert 1 row for testing only...comment out later</descr>\r
32     <query platform="postgres|postgres7">\r
33       insert into course_categories values (1,'1','1',1,1,1,1,1)\r
34     </query>\r
35     <query platform="mysql">\r
36       insert into course_categories values (1,'1','1',1,1,1,1,1)\r
37     </query>\r
38     <query platform="oci8po">\r
39       insert into course_categories values (1,'1','1',1,1,1,1,1)\r
40     </query>\r
41   </sql>\r
42 </schema>\r
43 \r