[Summary view] [Print] [Text view]

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