[Sommaire] [Imprimer]

   1  <!--
   2      Propel XML database schema DTD
   3      $Id: database.dtd,v 1.7 2005/03/30 11:38:18 hlellelid Exp $
   4  
   5      This is based very closely on the schema DTD for Torque, but
   6      some differences do exist.
   7  -->
   8  
   9  <!--
  10  
  11  defaultPhpNamingMethod determines how a table or column name,
  12  from the name attribute in the xml database file, is converted to a
  13  PHP class or method name.
  14  
  15       nochange   - indicates not change is performed.
  16       underscore - Underscores are removed, First letter is
  17                capitalized, first letter after an underscore
  18                is capitalized, the rest of the letters are
  19                converted to lowercase.
  20       phpname   - same as underscore, but no letters are converted
  21                to lowercase.
  22  -->
  23  
  24  <!ELEMENT database (external-schema*, table+)>
  25  <!ATTLIST database
  26    name CDATA #IMPLIED
  27    defaultIdMethod (native|none) "none"
  28    defaultTranslateMethode CDATA #IMPLIED
  29    package CDATA #IMPLIED
  30    baseClass CDATA #IMPLIED
  31    basePeer CDATA #IMPLIED
  32    defaultPhpNamingMethod (nochange|underscore|phpname) "underscore"
  33    heavyIndexing (true|false) "false"
  34  >
  35  
  36  <!ELEMENT external-schema EMPTY>
  37  <!ATTLIST external-schema
  38    filename CDATA #REQUIRED
  39  >
  40  
  41  <!--
  42       note: the interface="true", requires that useManagers=true in the
  43       properties file.
  44  -->
  45  <!ELEMENT table (column+,(foreign-key|index|unique|id-method-parameter|validator|vendor)*)>
  46  <!ATTLIST table
  47    name CDATA #REQUIRED
  48    phpName CDATA #IMPLIED
  49    idMethod (native|autoincrement|sequence|none|null) "null"
  50    skipSql (true|false) "false"
  51    readOnly (true|false) "false"
  52    abstract (true|false) "false"
  53    isTree (true|false) "false"
  54    package CDATA #IMPLIED
  55    baseClass CDATA #IMPLIED
  56    basePeer CDATA #IMPLIED
  57    alias CDATA #IMPLIED
  58    interface CDATA #IMPLIED
  59    phpNamingMethod (nochange|underscore|phpname) #IMPLIED
  60    heavyIndexing (true|false) #IMPLIED
  61    description CDATA #IMPLIED
  62  >
  63  
  64  <!ELEMENT id-method-parameter EMPTY>
  65  <!ATTLIST id-method-parameter
  66    name CDATA "default"
  67    value CDATA #REQUIRED
  68  >
  69  
  70  <!ELEMENT column ((inheritance|vendor)*)>
  71  <!ATTLIST column
  72    name CDATA #REQUIRED
  73    phpName CDATA #IMPLIED
  74    peerName CDATA #IMPLIED
  75    primaryKey (true|false) "false"
  76    required (true|false) "false"
  77    type
  78      (
  79            BIT  | TINYINT | SMALLINT    | INTEGER    | BIGINT    | FLOAT
  80          | REAL | NUMERIC | DECIMAL     | CHAR       | VARCHAR   | LONGVARCHAR
  81          | DATE | TIME    | TIMESTAMP   | BINARY     | VARBINARY | LONGVARBINARY
  82          | NULL | OTHER   | PHP_OBJECT  | DISTINCT   | STRUCT    | ARRAY
  83          | BLOB | CLOB    | REF         | BOOLEANINT | BOOLEANCHAR
  84          | DOUBLE | BOOLEAN
  85      ) "VARCHAR"
  86    phpType (object|primitive) #IMPLIED
  87    size CDATA #IMPLIED
  88    scale CDATA #IMPLIED
  89    default CDATA #IMPLIED
  90    autoIncrement (true|false) "false"
  91    inheritance (single|false) "false"
  92    inputValidator CDATA #IMPLIED
  93    phpNamingMethod (nochange|underscore|phpname) #IMPLIED
  94    description CDATA #IMPLIED
  95    lazyLoad (true|false) "false"
  96  >
  97  
  98  <!ELEMENT inheritance EMPTY>
  99  <!ATTLIST inheritance
 100    key CDATA #REQUIRED
 101    class CDATA #REQUIRED
 102    package CDATA #IMPLIED
 103    extends CDATA #IMPLIED
 104  >
 105  
 106  <!ELEMENT foreign-key (reference+, vendor*)>
 107  <!ATTLIST foreign-key
 108    foreignTable CDATA #REQUIRED
 109    name CDATA #IMPLIED
 110    onUpdate (CASCADE|cascade|SETNULL|setnull|RESTRICT|restrict|NONE|none) "none"
 111    onDelete (CASCADE|cascade|SETNULL|setnull|RESTRICT|restrict|NONE|none) "none"
 112  >
 113  
 114  <!ELEMENT reference EMPTY>
 115  <!ATTLIST reference
 116    local CDATA #REQUIRED
 117    foreign CDATA #REQUIRED
 118  >
 119  
 120  <!ELEMENT index (index-column+)>
 121  <!ATTLIST index
 122    name CDATA #IMPLIED
 123  >
 124  
 125  <!ELEMENT index-column (vendor*)>
 126  <!ATTLIST index-column
 127    name CDATA #REQUIRED
 128    size CDATA #IMPLIED
 129  >
 130  
 131  <!ELEMENT unique (unique-column+)>
 132  <!ATTLIST unique
 133    name CDATA #IMPLIED
 134  >
 135  
 136  <!ELEMENT unique-column (vendor*)>
 137  <!ATTLIST unique-column
 138    name CDATA #REQUIRED
 139  >
 140  
 141  <!ELEMENT validator (rule+)>
 142  <!ATTLIST validator
 143    column CDATA #REQUIRED
 144    translate CDATA #IMPLIED
 145  >
 146  
 147  <!ELEMENT rule EMPTY>
 148  <!ATTLIST rule
 149    name (mask|maxLength|maxValue|minLength|minValue|required|unique|validValues) #REQUIRED
 150    value CDATA #IMPLIED
 151    size ID #IMPLIED
 152    message CDATA #IMPLIED
 153  >
 154  
 155  <!ELEMENT vendor (parameter+)>
 156  <!ATTLIST validator
 157    type CDATA #REQUIRED
 158  >
 159  
 160  <!ELEMENT parameter EMPTY>
 161  <!ATTLIST parameter
 162    name CDATA #REQUIRED
 163    value CDATA #REQUIRED
 164  >