[Summary view] [Print] [Text view]

   1  <?xml version="1.0" encoding="UTF-8" ?>
   2  <XMLDB PATH="mod/chat/db" VERSION="20120122" COMMENT="XMLDB file for Moodle mod/chat"
   3      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   4      xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
   5  >
   6    <TABLES>
   7      <TABLE NAME="chat" COMMENT="Each of these is a chat room">
   8        <FIELDS>
   9          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  10          <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  11          <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
  12          <FIELD NAME="intro" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
  13          <FIELD NAME="introformat" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="text format of intro field"/>
  14          <FIELD NAME="keepdays" TYPE="int" LENGTH="11" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  15          <FIELD NAME="studentlogs" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  16          <FIELD NAME="chattime" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  17          <FIELD NAME="schedule" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  18          <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  19        </FIELDS>
  20        <KEYS>
  21          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  22        </KEYS>
  23        <INDEXES>
  24          <INDEX NAME="course" UNIQUE="false" FIELDS="course"/>
  25        </INDEXES>
  26      </TABLE>
  27      <TABLE NAME="chat_messages" COMMENT="Stores all the actual chat messages">
  28        <FIELDS>
  29          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  30          <FIELD NAME="chatid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  31          <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  32          <FIELD NAME="groupid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  33          <FIELD NAME="system" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  34          <FIELD NAME="message" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
  35          <FIELD NAME="timestamp" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  36        </FIELDS>
  37        <KEYS>
  38          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  39          <KEY NAME="chatid" TYPE="foreign" FIELDS="chatid" REFTABLE="chat" REFFIELDS="id"/>
  40        </KEYS>
  41        <INDEXES>
  42          <INDEX NAME="userid" UNIQUE="false" FIELDS="userid"/>
  43          <INDEX NAME="groupid" UNIQUE="false" FIELDS="groupid"/>
  44          <INDEX NAME="timestamp-chatid" UNIQUE="false" FIELDS="timestamp, chatid"/>
  45        </INDEXES>
  46      </TABLE>
  47      <TABLE NAME="chat_messages_current" COMMENT="Stores current session">
  48        <FIELDS>
  49          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  50          <FIELD NAME="chatid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  51          <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  52          <FIELD NAME="groupid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  53          <FIELD NAME="system" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  54          <FIELD NAME="message" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
  55          <FIELD NAME="timestamp" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  56        </FIELDS>
  57        <KEYS>
  58          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  59          <KEY NAME="chatid" TYPE="foreign" FIELDS="chatid" REFTABLE="chat" REFFIELDS="id"/>
  60        </KEYS>
  61        <INDEXES>
  62          <INDEX NAME="userid" UNIQUE="false" FIELDS="userid"/>
  63          <INDEX NAME="groupid" UNIQUE="false" FIELDS="groupid"/>
  64          <INDEX NAME="timestamp-chatid" UNIQUE="false" FIELDS="timestamp, chatid"/>
  65        </INDEXES>
  66      </TABLE>
  67      <TABLE NAME="chat_users" COMMENT="Keeps track of which users are in which chat rooms">
  68        <FIELDS>
  69          <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
  70          <FIELD NAME="chatid" TYPE="int" LENGTH="11" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  71          <FIELD NAME="userid" TYPE="int" LENGTH="11" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  72          <FIELD NAME="groupid" TYPE="int" LENGTH="11" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  73          <FIELD NAME="version" TYPE="char" LENGTH="16" NOTNULL="true" SEQUENCE="false"/>
  74          <FIELD NAME="ip" TYPE="char" LENGTH="45" NOTNULL="true" SEQUENCE="false"/>
  75          <FIELD NAME="firstping" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  76          <FIELD NAME="lastping" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  77          <FIELD NAME="lastmessageping" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  78          <FIELD NAME="sid" TYPE="char" LENGTH="32" NOTNULL="true" SEQUENCE="false"/>
  79          <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
  80          <FIELD NAME="lang" TYPE="char" LENGTH="30" NOTNULL="true" SEQUENCE="false"/>
  81        </FIELDS>
  82        <KEYS>
  83          <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
  84          <KEY NAME="chatid" TYPE="foreign" FIELDS="chatid" REFTABLE="chat" REFFIELDS="id"/>
  85        </KEYS>
  86        <INDEXES>
  87          <INDEX NAME="userid" UNIQUE="false" FIELDS="userid"/>
  88          <INDEX NAME="lastping" UNIQUE="false" FIELDS="lastping"/>
  89          <INDEX NAME="groupid" UNIQUE="false" FIELDS="groupid"/>
  90        </INDEXES>
  91      </TABLE>
  92    </TABLES>
  93  </XMLDB>