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