Use is_internal_email function (see bug 978)
[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
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