lib/adodb/xmlschema03.dtd

   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 ]>