1<?xml version="1.0"?> 2 3<!-- 4 Copyright (c) 2003, Oracle and/or its affiliates. All rights reserved. 5 DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 6 7 This code is free software; you can redistribute it and/or modify it 8 under the terms of the GNU General Public License version 2 only, as 9 published by the Free Software Foundation. Oracle designates this 10 particular file as subject to the "Classpath" exception as provided 11 by Oracle in the LICENSE file that accompanied this code. 12 13 This code is distributed in the hope that it will be useful, but WITHOUT 14 ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or 15 FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License 16 version 2 for more details (a copy is included in the LICENSE file that 17 accompanied this code). 18 19 You should have received a copy of the GNU General Public License version 20 2 along with this work; if not, write to the Free Software Foundation, 21 Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA. 22 23 Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA 24 or visit www.oracle.com if you need additional information or have any 25 questions. 26--> 27 28<xsd:schema 29 xmlns:xsd="http://www.w3.org/2001/XMLSchema" 30 targetNamespace="http://standards.iso.org/iso/9075/2002/12/sqlxml" 31 xmlns:sqlxml="http://standards.iso.org/iso/9075/2002/12/sqlxml"> 32 <xsd:annotation> 33 <xsd:documentation> 34 ISO/IEC 9075-14:2003 (SQL/XML) 35 This document contains definitions of types and 36 annotations as specified in ISO/IEC 9075-14:2003. 37 </xsd:documentation> 38 </xsd:annotation> 39 40 <xsd:simpleType name="kindKeyword"> 41 <xsd:restriction base="xsd:string"> 42 <xsd:enumeration value="PREDEFINED"/> 43 <xsd:enumeration value="DOMAIN"/> 44 <xsd:enumeration value="ROW"/> 45 <xsd:enumeration value="DISTINCT"/> 46 <xsd:enumeration value="ARRAY"/> 47 <xsd:enumeration value="MULTISET"/> 48 </xsd:restriction> 49 </xsd:simpleType> 50 51 <xsd:simpleType name="typeKeyword"> 52 <xsd:restriction base="xsd:string"> 53 <xsd:enumeration value="CHAR"/> 54 <xsd:enumeration value="VARCHAR"/> 55 <xsd:enumeration value="CLOB"/> 56 <xsd:enumeration value="BLOB"/> 57 <xsd:enumeration value="NUMERIC"/> 58 <xsd:enumeration value="DECIMAL"/> 59 <xsd:enumeration value="INTEGER"/> 60 <xsd:enumeration value="SMALLINT"/> 61 <xsd:enumeration value="BIGINT"/> 62 <xsd:enumeration value="FLOAT"/> 63 <xsd:enumeration value="REAL"/> 64 <xsd:enumeration value="DOUBLE PRECISION"/> 65 <xsd:enumeration value="BOOLEAN"/> 66 <xsd:enumeration value="DATE"/> 67 <xsd:enumeration value="TIME"/> 68 <xsd:enumeration value="TIME WITH TIME ZONE"/> 69 <xsd:enumeration value="TIMESTAMP"/> 70 <xsd:enumeration value="TIMESTAMP WITH TIME ZONE"/> 71 <xsd:enumeration value="INTERVAL YEAR"/> 72 <xsd:enumeration value="INTERVAL YEAR TO MONTH"/> 73 <xsd:enumeration value="INTERVAL MONTH"/> 74 <xsd:enumeration value="INTERVAL DAY"/> 75 <xsd:enumeration value="INTERVAL DAY TO HOUR"/> 76 <xsd:enumeration value="INTERVAL DAY TO MINUTE"/> 77 <xsd:enumeration value="INTERVAL DAY TO SECOND"/> 78 <xsd:enumeration value="INTERVAL HOUR"/> 79 <xsd:enumeration value="INTERVAL HOUR TO MINUTE"/> 80 <xsd:enumeration value="INTERVAL HOUR TO SECOND"/> 81 <xsd:enumeration value="INTERVAL MINUTE"/> 82 <xsd:enumeration value="INTERVAL MINUTE TO SECOND"/> 83 <xsd:enumeration value="INTERVAL SECOND"/> 84 </xsd:restriction> 85 </xsd:simpleType> 86 87 <xsd:complexType name="fieldType"> 88 <xsd:attribute name="name" type="xsd:string"/> 89 <xsd:attribute name="mappedType" type="xsd:string"/> 90 </xsd:complexType> 91 92 <xsd:element name="sqltype"> 93 <xsd:complexType> 94 <xsd:sequence> 95 <xsd:element name="field" type="sqlxml:fieldType" 96 minOccurs="0" maxOccurs="unbounded"/> 97 </xsd:sequence> 98 <xsd:attribute name="kind" 99 type="sqlxml:kindKeyword"/> 100 <xsd:attribute name="name" 101 type="sqlxml:typeKeyword" use="optional"/> 102 <xsd:attribute name="length" type="xsd:integer" 103 use="optional"/> 104 <xsd:attribute name="maxLength" type="xsd:integer" 105 use="optional"/> 106 <xsd:attribute name="characterSetName" type="xsd:string" 107 use="optional"/> 108 <xsd:attribute name="collation" type="xsd:string" 109 use="optional"/> 110 <xsd:attribute name="precision" type="xsd:integer" 111 use="optional"/> 112 <xsd:attribute name="scale" type="xsd:integer" 113 use="optional"/> 114 <xsd:attribute name="maxExponent" type="xsd:integer" 115 use="optional"/> 116 <xsd:attribute name="minExponent" type="xsd:integer" 117 use="optional"/> 118 <xsd:attribute name="userPrecision" type="xsd:integer" 119 use="optional"/> 120 <xsd:attribute name="leadingPrecision" type="xsd:integer" 121 use="optional"/> 122 <xsd:attribute name="maxElements" type="xsd:integer" 123 use="optional"/> 124 <xsd:attribute name="catalogName" type="xsd:string" 125 use="optional"/> 126 <xsd:attribute name="schemaName" type="xsd:string" 127 use="optional"/> 128 <xsd:attribute name="domainName" type="xsd:string" 129 use="optional"/> 130 <xsd:attribute name="typeName" type="xsd:string" 131 use="optional"/> 132 <xsd:attribute name="mappedType" type="xsd:string" 133 use="optional"/> 134 <xsd:attribute name="mappedElementType" type="xsd:string" 135 use="optional"/> 136 <xsd:attribute name="final" type="xsd:boolean" 137 use="optional"/> 138 </xsd:complexType> 139 </xsd:element> 140 141 <xsd:simpleType name="objectType"> 142 <xsd:restriction base="xsd:string"> 143 <xsd:enumeration value="CATALOG" /> 144 <xsd:enumeration value="SCHEMA" /> 145 <xsd:enumeration value="BASE TABLE" /> 146 <xsd:enumeration value="VIEWED TABLE" /> 147 <xsd:enumeration value="CHARACTER SET" /> 148 <xsd:enumeration value="COLLATION" /> 149 </xsd:restriction> 150 </xsd:simpleType> 151 152 <xsd:element name="sqlname"> 153 <xsd:complexType> 154 <xsd:attribute name="type" type="sqlxml:objectType" 155 use="required" /> 156 <xsd:attribute name="catalogName" type="xsd:string" /> 157 <xsd:attribute name="schemaName" type="xsd:string" /> 158 <xsd:attribute name="localName" type="xsd:string" /> 159 </xsd:complexType> 160 </xsd:element> 161 162</xsd:schema> 163