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