Proyectos de Subversion Moodle

<?xml version="1.0" encoding="UTF-8" ?>

<XMLDB PATH="mod/stickynotes/db" VERSION="20210521" COMMENT="XMLDB file for Moodle mod_stickynotes"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"

>

  <TABLES>

    <TABLE NAME="stickynotes" COMMENT="Stores the stickynotes activity module instances.">

      <FIELDS>

        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>

        <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the course this activity is part of."/>

        <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="The name of the activity module instance"/>

        <FIELD NAME="intro" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Activity description."/>

        <FIELD NAME="introformat" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="The format of the intro field."/>

        <FIELD NAME="colors" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if colors for sticky notes are enabled"/>

        <FIELD NAME="votes" TYPE="char" LENGTH="255" NOTNULL="true" DEFAULT="none" SEQUENCE="false" COMMENT="Check the type of vote enabled"/>

        <FIELD NAME="limitvotes" TYPE="int" LENGTH="4" NOTNULL="false" SEQUENCE="false" COMMENT="If enabled, limits the number of votes per user"/>

        <FIELD NAME="maxlimitvotes" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false" COMMENT="If enabled, set the max number of votes per use."/>

        <FIELD NAME="limitstickynotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Check if a max number of sticky notes per user is enabled"/>

        <FIELD NAME="maxstickynotes" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false" COMMENT="Number of maximum sticky notes per user"/>

        <FIELD NAME="orderstickynotes" TYPE="char" LENGTH="255" NOTNULL="true" DEFAULT="desc" SEQUENCE="false" COMMENT="Defines how sticky notes are ordered from newest to oldest (or inverse) or by numer of votes"/>

        <FIELD NAME="viewauthor" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If enabled, managers and teachers will see authors"/>

        <FIELD NAME="rotate" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="If enabled, notes will have a random rotation effect."/>

        <FIELD NAME="color1" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 1 is used."/>

        <FIELD NAME="color1_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 1 in the activity."/>

        <FIELD NAME="color2" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 2 is used."/>

        <FIELD NAME="color2_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 2 in the activity."/>

        <FIELD NAME="color3" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 3 is used."/>

        <FIELD NAME="color3_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 3 in the activity."/>

        <FIELD NAME="color4" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 4 is used."/>

        <FIELD NAME="color4_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 4 in the activity."/>

        <FIELD NAME="color5" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 5 is used."/>

        <FIELD NAME="color5_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 5 in the activity."/>

        <FIELD NAME="color6" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Check if color 6 is used."/>

        <FIELD NAME="color6_meaning" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" COMMENT="If used, gives meaning for the use of color 6 in the activity."/>

        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Timestamp of when the instance was added to the course."/>

        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Timestamp of when the instance was last modified."/>

        <FIELD NAME="displaystickycaption" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If enabled, displays colors caption in activity."/>

        <FIELD NAME="moveallnotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If enabled, students can move all notes and not only their owns."/>

        <FIELD NAME="seeallnotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="If not enabled, student sees only his own notes, independently of other contributions."/>

        <FIELD NAME="completionstickynotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Number of notes student must create to complete activity."/>

        <FIELD NAME="locknotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If enabled, locks notes creation for students."/>

        <FIELD NAME="lockvotes" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If enabled, locks votes for students."/>

      </FIELDS>

      <KEYS>

        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>

        <KEY NAME="fk_course" TYPE="foreign" FIELDS="course" REFTABLE="course" REFFIELDS="id"/>

      </KEYS>

    </TABLE>

    <TABLE NAME="stickynotes_column" COMMENT="Informations about columns in sticky notes activities">

      <FIELDS>

        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>

        <FIELD NAME="stickyid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the sticky notes activity"/>

        <FIELD NAME="title" TYPE="char" LENGTH="20" NOTNULL="false" DEFAULT="Title" SEQUENCE="false" COMMENT="Name of the column"/>

        <FIELD NAME="column_order" TYPE="int" LENGTH="6" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Defines the order position of the column"/>

      </FIELDS>

      <KEYS>

        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>

        <KEY NAME="fk_stickyid" TYPE="foreign" FIELDS="stickyid" REFTABLE="stickynotes" REFFIELDS="id"/>

      </KEYS>

    </TABLE>

    <TABLE NAME="stickynotes_note" COMMENT="Informations about the notes">

      <FIELDS>

        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>

        <FIELD NAME="stickyid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the activity"/>

        <FIELD NAME="stickycolid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the related column"/>

        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the user who created the note"/>

        <FIELD NAME="message" TYPE="char" LENGTH="200" NOTNULL="true" SEQUENCE="false" COMMENT="Content of the note"/>

        <FIELD NAME="color" TYPE="char" LENGTH="10" NOTNULL="true" DEFAULT="color1" SEQUENCE="false" COMMENT="ID of the background color"/>

        <FIELD NAME="ordernote" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="Order number in column"/>

        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Timestamp of when the note was added"/>

        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false" COMMENT="Timestamp of when the note was modified"/>

      </FIELDS>

      <KEYS>

        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>

        <KEY NAME="fk_stickyid" TYPE="foreign" FIELDS="stickyid" REFTABLE="stickynotes" REFFIELDS="id" COMMENT="ID of the activity"/>

        <KEY NAME="fk_stickycolid" TYPE="foreign" FIELDS="stickycolid" REFTABLE="stickynotes_column" REFFIELDS="id"/>

      </KEYS>

    </TABLE>

    <TABLE NAME="stickynotes_vote" COMMENT="Informations for users votes">

      <FIELDS>

        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>

        <FIELD NAME="stickyid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Instance ID"/>

        <FIELD NAME="stickynoteid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the note"/>

        <FIELD NAME="vote" TYPE="int" LENGTH="5" NOTNULL="true" SEQUENCE="false" COMMENT="Content of the vote, depends on the type of vote defined in table stickynotes"/>

        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="ID of the user who voted"/>

        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Timestamp of when the vote was added or modified"/>

      </FIELDS>

      <KEYS>

        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>

        <KEY NAME="fk_stickyid" TYPE="foreign" FIELDS="stickyid" REFTABLE="stickynotes" REFFIELDS="id" COMMENT="Instance ID"/>

        <KEY NAME="fk_stickynoteid" TYPE="foreign" FIELDS="stickynoteid" REFTABLE="stickynotes_note" REFFIELDS="id" COMMENT="ID of the note"/>

      </KEYS>

    </TABLE>

  </TABLES>

</XMLDB>