Correct defaults.
[moodle.git] / lib / db / schemaCourse_modules.xml
CommitLineData
5a2f8b8d 1<?xml version="1.0"?>\r
2<schema>\r
3 <table name="course_modules">\r
4 <field name="id" type="I" size="10">\r
5 <KEY/>\r
6 <AUTOINCREMENT/>\r
7 </field>\r
8 <field name="course" type="I" size="10">\r
9 <NOTNULL/>\r
10 </field>\r
11 <field name="module" type="I" size="10">\r
12 <NOTNULL/>\r
13 </field>\r
14 <field name="instance" type="I" size="10">\r
15 <NOTNULL/>\r
16 </field>\r
17 <field name="section" type="I" size="10">\r
18 <NOTNULL/>\r
19 </field>\r
20 <field name="added" type="I" size="10">\r
21 <NOTNULL/>\r
22 </field>\r
23 <field name="deleted" type="L" size="4">\r
24 <NOTNULL/>\r
25 </field>\r
26 <field name="score" type="L" size="4">\r
27 <NOTNULL/>\r
28 </field>\r
29 <field name="indent" type="I" size="5">\r
30 <NOTNULL/>\r
31 </field>\r
32 <field name="visible" type="L" size="1">\r
33 <NOTNULL/>\r
34 </field>\r
35 </table>\r
36 <sql>\r
37 <descr>Insert 1 row for testing only...comment out later</descr>\r
38 <query platform="postgres|postgres7">\r
39 insert into course_modules values (1,1,1,1,1,1,1,1,1,1)\r
40 </query>\r
41 <query platform="mysql">\r
42 insert into course_modules values (1,1,1,1,1,1,1,1,1,1)\r
43 </query>\r
44 <query platform="oci8po">\r
45 insert into course_modules values (1,1,1,1,1,1,1,1,1,1)\r
46 </query>\r
47 </sql>\r
48</schema>\r
49\r