| [12] | 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 | ]> |
|---|
