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)?,
7 NOQUOTE?, CONSTRAINT*, descr?)
>
11 <!ELEMENT descr (#CDATA)
>
12 <!ELEMENT NOTNULL EMPTY
>
14 <!ELEMENT PRIMARY EMPTY
>
16 <!ELEMENT AUTOINCREMENT EMPTY
>
17 <!ELEMENT DEFAULT EMPTY
>
18 <!ELEMENT DEFDATE EMPTY
>
19 <!ELEMENT DEFTIMESTAMP EMPTY
>
20 <!ELEMENT NOQUOTE EMPTY
>
22 <!ELEMENT CONSTRAINT (#CDATA)
>
23 <!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED
>
24 <!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED
>
25 <!ATTLIST data platform CDATA #IMPLIED
>
26 <!ATTLIST f name CDATA #IMPLIED
>
27 <!ATTLIST DEFAULT VALUE CDATA #REQUIRED
>
28 <!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)
>
29 <!ELEMENT col (#CDATA)
>
30 <!ELEMENT CLUSTERED EMPTY
>
31 <!ELEMENT BITMAP EMPTY
>
32 <!ELEMENT UNIQUE EMPTY
>
33 <!ELEMENT FULLTEXT EMPTY
>
35 <!ATTLIST index name CDATA #REQUIRED platform CDATA #IMPLIED
>
36 <!ELEMENT sql (query+, descr?)
>
37 <!ELEMENT query (#CDATA)
>
38 <!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE)
>