1 | <?xml version="1.0"?>
|
---|
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>
|
---|
11 | <!ELEMENT row (f+)>
|
---|
12 | <!ELEMENT f (#CDATA)>
|
---|
13 | <!ATTLIST f name CDATA #IMPLIED>
|
---|
14 | <!ELEMENT descr (#CDATA)>
|
---|
15 | <!ELEMENT NOTNULL EMPTY>
|
---|
16 | <!ELEMENT KEY EMPTY>
|
---|
17 | <!ELEMENT PRIMARY EMPTY>
|
---|
18 | <!ELEMENT AUTO 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>
|
---|
26 | <!ELEMENT DROP 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>
|
---|
38 | <!ELEMENT HASH 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>
|
---|
43 | ]> |
---|