9feefdedaf5b658c226edfedd5943857bff76ec7
[moodle.git] / lib / db / schemaCourse.xml
1 <?xml version="1.0"?>\r
2 <schema>\r
3   <table name="course">\r
4     <field name="id" type="I" size="10">\r
5       <KEY/>\r
6       <AUTOINCREMENT/>\r
7     </field>\r
8     <field name="category" type="I" size="10" default="0">\r
9       <KEY/>\r
10       <NOTNULL/>\r
11     </field>\r
12     <field name="sortorder" type="I" size="10" default="0">\r
13       <NOTNULL/>\r
14     </field>\r
15     <field name="password" type="C" size="50" default="0">\r
16       <NOTNULL/>\r
17     </field>\r
18     <field name="fullname" type="C" size="254" default="0">\r
19       <NOTNULL/>\r
20     </field>\r
21     <field name="shortname" type="C" size="15" default="0">\r
22       <NOTNULL/>\r
23     </field>\r
24     <field name="summary" type="X" >\r
25       <NOTNULL/>\r
26     </field>\r
27     <field name="format" type="C" size="15" default="topics">\r
28       <NOTNULL/>\r
29     </field>\r
30     <field name="showgrades" type="L" default="1">\r
31       <NOTNULL/>\r
32     </field>\r
33     <field name="modinfo" type="X">\r
34       <NOTNULL/>\r
35     </field>\r
36     <field name="newsitems" type="I1" default="1">\r
37       <NOTNULL/>\r
38     </field>\r
39     <field name="teacher" type="C" size="100" default="Teacher">\r
40       <NOTNULL/>\r
41     </field>\r
42     <field name="teachers" type="C" size="100" default="Teachers">\r
43       <NOTNULL/>\r
44     </field>\r
45     <field name="student" type="C" size="100" default="Student">\r
46       <NOTNULL/>\r
47     </field>\r
48     <field name="students" type="C" size="100" default="Students">\r
49       <NOTNULL/>\r
50     </field>\r
51     <field name="guest" type="I1" size="2" default="0">\r
52       <NOTNULL/>\r
53     </field>\r
54     <field name="startdate" type="I" size="10" default="0">\r
55       <NOTNULL/>\r
56     </field>\r
57     <field name="numsections" type="I1" size="5" default="1">\r
58       <NOTNULL/>\r
59     </field>\r
60     <field name="showrecent" type="I1" size="5" default="1">\r
61       <NOTNULL/>\r
62     </field>\r
63     <field name="marker" type="I" size="10" default="0">\r
64       <NOTNULL/>\r
65     </field>\r
66     <field name="maxbytes" type="I" size="10" default="0">\r
67       <NOTNULL/>\r
68     </field>\r
69     <field name="showreports" type="I" size="4" default="0">\r
70       <NOTNULL/>\r
71     </field>\r
72     <field name="visible" type="I" size="10" default="1">\r
73       <NOTNULL/>\r
74     </field>\r
75     <field name="groupmode" type="I" size="4" default="1">\r
76       <NOTNULL/>\r
77     </field>\r
78     <field name="groupmodeforce" type="I" size="4" default="1">\r
79       <NOTNULL/>\r
80     </field>\r
81     <field name="timecreated" type="I" size="10" default="0">\r
82       <NOTNULL/>\r
83     </field>\r
84     <field name="timemodified" type="I" size="10" default="0">\r
85       <NOTNULL/>\r
86     </field>\r
87   </table>\r
88   <sql>\r
89     <descr>Insert 1 row for testing only...comment out later</descr>\r
90     <query platform="postgres|postgres7">\r
91       insert into course(1,1,1,'1','1','1','1','1','1','1',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)\r
92     </query>\r
93     <query platform="mysql">\r
94       insert into course values (1,1,1,'1','1','1','1','1',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)\r
95     </query>\r
96     <query platform="oci8po">\r
97       insert into course values (1,1,1,'1','1','1','1','1',1,'1',1,'1','1','1','1',1,1,1,1,1,1,1,1,1,1)\r
98     </query>\r
99   </sql>\r
100 </schema>\r
101 \r