Initial add...separate .xml file for each table.
[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       <NOTNULL/>\r
10     </field>\r
11     <field name="sortorder" type="I" size="10" default="0">\r
12       <NOTNULL/>\r
13     </field>\r
14     <field name="password" type="C" size="50" default="0">\r
15       <NOTNULL/>\r
16     </field>\r
17     <field name="fullname" type="C" size="254" default="0">\r
18       <NOTNULL/>\r
19     </field>\r
20     <field name="shortname" type="C" size="15" default="0">\r
21       <NOTNULL/>\r
22     </field>\r
23     <field name="summary" type="X" >\r
24       <NOTNULL/>\r
25     </field>\r
26     <field name="format" type="C" size="15" default="topics">\r
27       <NOTNULL/>\r
28     </field>\r
29     <field name="showgrades" type="L" default="1">\r
30       <NOTNULL/>\r
31     </field>\r
32     <field name="modinfo" type="X">\r
33       <NOTNULL/>\r
34     </field>\r
35     <field name="newsitems" type="I1" default="1">\r
36       <NOTNULL/>\r
37     </field>\r
38     <field name="teacher" type="C" size="100" default="Teacher">\r
39       <NOTNULL/>\r
40     </field>\r
41     <field name="teachers" type="C" size="100" default="Teachers">\r
42       <NOTNULL/>\r
43     </field>\r
44     <field name="student" type="C" size="100" default="Student">\r
45       <NOTNULL/>\r
46     </field>\r
47     <field name="students" type="C" size="100" default="Students">\r
48       <NOTNULL/>\r
49     </field>\r
50     <field name="guest" type="I1" size="2" default="0">\r
51       <NOTNULL/>\r
52     </field>\r
53     <field name="startdate" type="I" size="10" default="0">\r
54       <NOTNULL/>\r
55     </field>\r
56     <field name="numsections" type="I1" size="5" default="1">\r
57       <NOTNULL/>\r
58     </field>\r
59     <field name="showrecent" type="I1" size="5" default="1">\r
60       <NOTNULL/>\r
61     </field>\r
62     <field name="marker" type="I" size="10" default="0">\r
63       <NOTNULL/>\r
64     </field>\r
65     <field name="maxbytes" type="I" size="10" default="0">\r
66       <NOTNULL/>\r
67     </field>\r
68     <field name="showreports" type="I" size="4" default="0">\r
69       <NOTNULL/>\r
70     </field>\r
71     <field name="visible" type="I" size="10" default="1">\r
72       <NOTNULL/>\r
73     </field>\r
74     <field name="timecreated" type="I" size="10" default="0">\r
75       <NOTNULL/>\r
76     </field>\r
77     <field name="timemodified" type="I" size="10" default="0">\r
78       <NOTNULL/>\r
79     </field>\r
80   </table>\r
81   <sql>\r
82     <descr>Insert 1 row for testing only...comment out later</descr>\r
83     <query platform="postgres|postgres7">\r
84       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
85     </query>\r
86     <query platform="mysql">\r
87       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
88     </query>\r
89     <query platform="oci8po">\r
90       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
91     </query>\r
92   </sql>\r
93 </schema>\r
94 \r