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
>
13 <!ATTLIST f name CDATA #IMPLIED
>
14 <!ELEMENT descr (#CDATA)
>
15 <!ELEMENT NOTNULL EMPTY
>
17 <!ELEMENT PRIMARY 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
>
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
>
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
>