added ending dates of service
[openemr.git] / library / adodb / xmlschema.dtd
blob083bc9032c2bd7d7f02fd544a0005de31ff03584
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*)>
6 <!ELEMENT field ((NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?, NOQUOTE, constraint, descr?)>
7 <!ELEMENT descr (#CDATA)>
8 <!ELEMENT NOTNULL EMPTY>
9 <!ELEMENT KEY EMPTY>
10 <!ELEMENT PRIMARY EMPTY>
11 <!ELEMENT AUTO EMPTY>
12 <!ELEMENT AUTOINCREMENT EMPTY>
13 <!ELEMENT DEFAULT EMPTY>
14 <!ELEMENT DEFDATE EMPTY>
15 <!ELEMENT DEFTIMESTAMP EMPTY>
16 <!ELEMENT NOQUOTE EMPTY>
17 <!ELEMENT DROP EMPTY>
18 <!ELEMENT constraint (#CDATA)>
19 <!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED>
20 <!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED>
21 <!ATTLIST DEFAULT value CDATA #REQUIRED>
22 <!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)>
23 <!ELEMENT col (#CDATA)>
24 <!ELEMENT CLUSTERED EMPTY>
25 <!ELEMENT BITMAP EMPTY>
26 <!ELEMENT UNIQUE EMPTY>
27 <!ELEMENT FULLTEXT EMPTY>
28 <!ELEMENT HASH EMPTY>
29 <!ATTLIST index name CDATA #REQUIRED>
30 <!ELEMENT sql (query+, descr?)>
31 <!ELEMENT query (#CDATA)>
32 <!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE) >
33 ] >