[Summary view] [Print] [Text view]

   1  <?xml version="1.0" encoding="UTF-8" ?>
   2  <XMLDB PATH="tool/recyclebin/db" VERSION="20160315" COMMENT="XMLDB file for Moodle tool/recyclebin"
   3      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   4      xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
   5  >
   6    <TABLES>
   7      <TABLE NAME="tool_recyclebin_course" COMMENT="A list of items in the course recycle bin">
   8        <FIELDS>
   9          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  10          <FIELD NAME="courseid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
  11          <FIELD NAME="section" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
  12          <FIELD NAME="module" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
  13          <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false"/>
  14          <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  15        </FIELDS>
  16        <KEYS>
  17          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  18          <KEY NAME="courseid" TYPE="foreign" FIELDS="courseid" REFTABLE="course" REFFIELDS="id"/>
  19        </KEYS>
  20        <INDEXES>
  21          <INDEX NAME="timecreated" UNIQUE="false" FIELDS="timecreated"/>
  22        </INDEXES>
  23      </TABLE>
  24      <TABLE NAME="tool_recyclebin_category" COMMENT="A list of items in the category recycle bin">
  25        <FIELDS>
  26          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  27          <FIELD NAME="categoryid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
  28          <FIELD NAME="shortname" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
  29          <FIELD NAME="fullname" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
  30          <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
  31        </FIELDS>
  32        <KEYS>
  33          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  34          <KEY NAME="categoryid" TYPE="foreign" FIELDS="categoryid" REFTABLE="course_categories" REFFIELDS="id"/>
  35        </KEYS>
  36        <INDEXES>
  37          <INDEX NAME="timecreated" UNIQUE="false" FIELDS="timecreated"/>
  38        </INDEXES>
  39      </TABLE>
  40    </TABLES>
  41  </XMLDB>