[Sommaire] [Imprimer]

   1  <?xml version="1.0"?>
   2  <!DOCTYPE adodb_schema [
   3  <!ELEMENT schema (table*, sql*)>
   4  <!ATTLIST schema version CDATA #REQUIRED>
   5  <!ELEMENT table ((field+|DROP), constraint*, descr?, index*, data*)>
   6  <!ELEMENT field ((NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?, NOQUOTE, CONSTRAINT, descr?)>
   7  <!ELEMENT data (row+)>
   8  <!ELEMENT row (f+)>
   9  <!ELEMENT f (#CDATA)>
  10  <!ELEMENT descr (#CDATA)>
  11  <!ELEMENT NOTNULL EMPTY>
  12  <!ELEMENT KEY EMPTY>
  13  <!ELEMENT PRIMARY EMPTY>
  14  <!ELEMENT AUTO EMPTY>
  15  <!ELEMENT AUTOINCREMENT EMPTY>
  16  <!ELEMENT DEFAULT EMPTY>
  17  <!ELEMENT DEFDATE EMPTY>
  18  <!ELEMENT DEFTIMESTAMP EMPTY>
  19  <!ELEMENT NOQUOTE EMPTY>
  20  <!ELEMENT DROP EMPTY>
  21  <!ELEMENT constraint (#CDATA)>
  22  <!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED>
  23  <!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED>
  24  <!ATTLIST data platform CDATA #IMPLIED>
  25  <!ATTLIST f name CDATA #IMPLIED>
  26  <!ATTLIST DEFAULT VALUE CDATA #REQUIRED>
  27  <!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)>
  28  <!ELEMENT col (#CDATA)>
  29  <!ELEMENT CLUSTERED EMPTY>
  30  <!ELEMENT BITMAP EMPTY>
  31  <!ELEMENT UNIQUE EMPTY>
  32  <!ELEMENT FULLTEXT EMPTY>
  33  <!ELEMENT HASH EMPTY>
  34  <!ATTLIST index name CDATA #REQUIRED platform CDATA #IMPLIED>
  35  <!ELEMENT sql (query+, descr?)>
  36  <!ELEMENT query (#CDATA)>
  37  <!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE) >
  38  ] >