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