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