AutorÃa | Ultima modificación | Ver Log |
<?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>