New columns and tables.
[moodle.git] / lib / db / schemaCourse.xml
CommitLineData
920d4432 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
d8f6ab1b 9 <KEY/>\r
920d4432 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
5f1317f8 75 <field name="groupmode" type="I" size="4" default="0">\r
d8f6ab1b 76 <NOTNULL/>\r
77 </field>\r
5f1317f8 78 <field name="groupmodeforce" type="I" size="4" default="0">\r
d8f6ab1b 79 <NOTNULL/>\r
80 </field>\r
920d4432 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