| 1 |
efrain |
1 |
<!ELEMENT schema (table*, sql*)>
|
|
|
2 |
<!ATTLIST schema version CDATA #REQUIRED>
|
|
|
3 |
<!ELEMENT table (descr?, (field+|DROP), constraint*, opt*, index*, data*)>
|
|
|
4 |
<!ATTLIST table
|
|
|
5 |
name CDATA #REQUIRED
|
|
|
6 |
platform CDATA #IMPLIED
|
|
|
7 |
version CDATA #IMPLIED>
|
|
|
8 |
<!ELEMENT field (descr?, (NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?, NOQUOTE?, UNSIGNED?, constraint*, opt*)>
|
|
|
9 |
<!ATTLIST
|
|
|
10 |
field name CDATA #REQUIRED
|
|
|
11 |
type (C|C2|X|X2|XL|B|D|T|L|I|I1|I2|I4|I8|F|N) #REQUIRED
|
|
|
12 |
size CDATA #IMPLIED
|
|
|
13 |
opts CDATA #IMPLIED>
|
|
|
14 |
<!ELEMENT data (descr?, row+)>
|
|
|
15 |
<!ATTLIST data platform CDATA #IMPLIED>
|
|
|
16 |
<!ELEMENT row (f+)>
|
|
|
17 |
<!ELEMENT f (#PCDATA)>
|
|
|
18 |
<!ATTLIST f name CDATA #IMPLIED>
|
|
|
19 |
<!ELEMENT descr (#PCDATA)>
|
|
|
20 |
<!ELEMENT NOTNULL EMPTY>
|
|
|
21 |
<!ELEMENT KEY EMPTY>
|
|
|
22 |
<!ELEMENT PRIMARY EMPTY>
|
|
|
23 |
<!ELEMENT AUTO EMPTY>
|
|
|
24 |
<!ELEMENT AUTOINCREMENT EMPTY>
|
|
|
25 |
<!ELEMENT DEFAULT EMPTY>
|
|
|
26 |
<!ATTLIST DEFAULT value CDATA #REQUIRED>
|
|
|
27 |
<!ELEMENT DEFDATE EMPTY>
|
|
|
28 |
<!ELEMENT DEFTIMESTAMP EMPTY>
|
|
|
29 |
<!ELEMENT NOQUOTE EMPTY>
|
|
|
30 |
<!ELEMENT UNSIGNED EMPTY>
|
|
|
31 |
<!ELEMENT DROP EMPTY>
|
|
|
32 |
<!ELEMENT constraint (#PCDATA)>
|
|
|
33 |
<!ATTLIST constraint platform CDATA #IMPLIED>
|
|
|
34 |
<!ELEMENT opt (#PCDATA)>
|
|
|
35 |
<!ATTLIST opt platform CDATA #IMPLIED>
|
|
|
36 |
<!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)>
|
|
|
37 |
<!ATTLIST index
|
|
|
38 |
name CDATA #REQUIRED
|
|
|
39 |
platform CDATA #IMPLIED>
|
|
|
40 |
<!ELEMENT col (#PCDATA)>
|
|
|
41 |
<!ELEMENT CLUSTERED EMPTY>
|
|
|
42 |
<!ELEMENT BITMAP EMPTY>
|
|
|
43 |
<!ELEMENT UNIQUE EMPTY>
|
|
|
44 |
<!ELEMENT FULLTEXT EMPTY>
|
|
|
45 |
<!ELEMENT HASH EMPTY>
|
|
|
46 |
<!ELEMENT sql (query+, descr?)>
|
|
|
47 |
<!ATTLIST sql
|
|
|
48 |
name CDATA #IMPLIED
|
|
|
49 |
platform CDATA #IMPLIED
|
|
|
50 |
key CDATA #IMPLIED
|
|
|
51 |
prefixmethod (AUTO|MANUAL|NONE) #IMPLIED>
|
|
|
52 |
<!ELEMENT query (#PCDATA)>
|
|
|
53 |
<!ATTLIST query platform CDATA #IMPLIED>
|