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