| 1 | efrain | 1 | <?xml version="1.0" encoding="UTF-8" ?>
 | 
        
           |  |  | 2 | <XMLDB PATH="mod/url/db" VERSION="20120122" COMMENT="XMLDB file for URL module"
 | 
        
           |  |  | 3 |     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 | 
        
           |  |  | 4 |     xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
 | 
        
           |  |  | 5 | >
 | 
        
           |  |  | 6 |   <TABLES>
 | 
        
           |  |  | 7 |     <TABLE NAME="url" COMMENT="each record is one url resource">
 | 
        
           |  |  | 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="false" SEQUENCE="false"/>
 | 
        
           |  |  | 13 |         <FIELD NAME="introformat" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
 | 
        
           |  |  | 14 |         <FIELD NAME="externalurl" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
 | 
        
           |  |  | 15 |         <FIELD NAME="display" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
 | 
        
           |  |  | 16 |         <FIELD NAME="displayoptions" TYPE="text" NOTNULL="false" SEQUENCE="false"/>
 | 
        
           |  |  | 17 |         <FIELD NAME="parameters" TYPE="text" NOTNULL="false" 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 |   </TABLES>
 | 
        
           |  |  | 28 | </XMLDB>
 |