<?xml version="1.0" encoding="utf-8"?>

<providers

xmlns="http://ibatis.apache.org/providers"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<clear/>

<provider

    name="sqlServer1.0"

    description="Microsoft SQL Server 7.0/2000, provider V1.0.3300.0 in framework .NET V1.0"

    enabled="true"

    assemblyName="System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.SqlClient.SqlConnection"

    commandClass="System.Data.SqlClient.SqlCommand"

    parameterClass="System.Data.SqlClient.SqlParameter"

    parameterDbTypeClass="System.Data.SqlDbType"

    parameterDbTypeProperty="SqlDbType"

    dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"

    commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="@"/>

<provider

    name="sqlServer1.1"

    description="Microsoft SQL Server 7.0/2000, provider V1.0.5000.0 in framework .NET V1.1"

    enabled="true"

    default="true"

    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.SqlClient.SqlConnection"

    commandClass="System.Data.SqlClient.SqlCommand"

    parameterClass="System.Data.SqlClient.SqlParameter"

    parameterDbTypeClass="System.Data.SqlDbType"

    parameterDbTypeProperty="SqlDbType"

    dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"

    commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="@"/>

<provider

        name="sqlServer2.0"

        enabled="true"

        description="Microsoft SQL Server 2005, provider V2.0.50215.0 in framework .NET V2.0"

        assemblyName="System.Data, Version=2.0.50215.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

        connectionClass="System.Data.SqlClient.SqlConnection"

        commandClass="System.Data.SqlClient.SqlCommand"

        parameterClass="System.Data.SqlClient.SqlParameter"

        parameterDbTypeClass="System.Data.SqlDbType"

        parameterDbTypeProperty="SqlDbType"

        dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"

        commandBuilderClass=" System.Data.SqlClient.SqlCommandBuilder"

        usePositionalParameters = "false"

        useParameterPrefixInSql = "true"

        useParameterPrefixInParameter = "true"

        parameterPrefix="@"

        />

<provider

        name="sqlServer4.0"

        enabled="true"

        default="true"

        description="Microsoft SQL Server, provider V4.0.0.0 in framework .NET V4.0"

        assemblyName="System.Data, Version=4.0.0.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089"

        connectionClass="System.Data.SqlClient.SqlConnection"

        commandClass="System.Data.SqlClient.SqlCommand"

        parameterClass="System.Data.SqlClient.SqlParameter"

        parameterDbTypeClass="System.Data.SqlDbType"

        parameterDbTypeProperty="SqlDbType"

        dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"

        commandBuilderClass=" System.Data.SqlClient.SqlCommandBuilder"

        usePositionalParameters = "false"

        useParameterPrefixInSql = "true"

        useParameterPrefixInParameter = "true"

        parameterPrefix="@"

        allowMARS="true"

/>

<provider name="OleDb1.1"

    description="OleDb, provider V1.0.5000.0 in framework .NET V1.1"

    enabled="true"

    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.OleDb.OleDbConnection"

    commandClass="System.Data.OleDb.OleDbCommand"

    parameterClass="System.Data.OleDb.OleDbParameter"

    parameterDbTypeClass="System.Data.OleDb.OleDbType"

    parameterDbTypeProperty="OleDbType"

    dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"

    commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"

    usePositionalParameters="true"

    useParameterPrefixInSql="false"

    useParameterPrefixInParameter="false"

    parameterPrefix=""/>

<provider

    name="Odbc1.1"

    description="Odbc, provider V1.0.5000.0 in framework .NET V1.1"

    enabled="true"

    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.Odbc.OdbcConnection"

    commandClass="System.Data.Odbc.OdbcCommand"

    parameterClass="System.Data.Odbc.OdbcParameter"

    parameterDbTypeClass="System.Data.Odbc.OdbcType"

    parameterDbTypeProperty="OdbcType"

    dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"

    commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"

    usePositionalParameters="true"

    useParameterPrefixInSql="false"

    useParameterPrefixInParameter="false"

    parameterPrefix="@"/>

<provider

    name="oracle9.2"

    description="Oracle, Oracle provider V9.2.0.401"

    enabled="false"

    assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection"

    commandClass="Oracle.DataAccess.Client.OracleCommand"

    parameterClass="Oracle.DataAccess.Client.OracleParameter"

    parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"

    parameterDbTypeProperty="OracleDbType"

    dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"

    commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="false"

    parameterPrefix=":"

    useDeriveParameters="false"/>

<provider

    name="oracle10.1"

    description="Oracle, oracle provider V10.1.0.301"

    enabled="false"

    assemblyName="Oracle.DataAccess, Version=10.1.0.301, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionClass="Oracle.DataAccess.Client.OracleConnection"

    commandClass="Oracle.DataAccess.Client.OracleCommand"

    parameterClass="Oracle.DataAccess.Client.OracleParameter"

    parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"

    parameterDbTypeProperty="OracleDbType"

    dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"

    commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"

    usePositionalParameters="true"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix=":"

    useDeriveParameters="false"/>

<provider

    name="oracleClient1.0"

    description="Oracle, Microsoft provider V1.0.5000.0"

    enabled="false"

    assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.OracleClient.OracleConnection"

    commandClass="System.Data.OracleClient.OracleCommand"

    parameterClass="System.Data.OracleClient.OracleParameter"

    parameterDbTypeClass="System.Data.OracleClient.OracleType"

    parameterDbTypeProperty="OracleType"

    dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"

    commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="false"

    parameterPrefix=":"/>

<provider

    name="ByteFx"

    description="MySQL, ByteFx provider V0.7.6.15073"

    enabled="false"

    assemblyName="ByteFX.MySqlClient, Version=0.7.6.15073, Culture=neutral, PublicKeyToken=f2fef6fed1732fc1" connectionClass="ByteFX.Data.MySqlClient.MySqlConnection"

    commandClass="ByteFX.Data.MySqlClient.MySqlCommand"

    parameterClass="ByteFX.Data.MySqlClient.MySqlParameter"

    parameterDbTypeClass="ByteFX.Data.MySqlClient.MySqlDbType"

    parameterDbTypeProperty="MySqlDbType"

    dataAdapterClass="ByteFX.Data.MySqlClient.MySqlDataAdapter"

    commandBuilderClass="ByteFX.Data.MySqlClient.MySqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="@"/>

<provider

    name="MySql"

    description="MySQL, MySQL provider V1.0.5.13785"

    enabled="false"

    assemblyName="MySql.Data, Version=1.0.5.13785, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionClass="MySql.Data.MySqlClient.MySqlConnection"

    commandClass="MySql.Data.MySqlClient.MySqlCommand"

    parameterClass="MySql.Data.MySqlClient.MySqlParameter"

    parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType"

    parameterDbTypeProperty="MySqlDbType"

    dataAdapterClass="MySql.Data.MySqlClient.MySqlDataAdapter"

    commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="?"/>

<provider name="SQLite3"

    description="SQLite, SQLite.NET provider V0.21.1869.3794"

    enabled="false"

    assemblyName="SQLite.NET, Version=0.21.1869.3794, Culture=neutral, PublicKeyToken=c273bd375e695f9c"

    connectionClass="Finisar.SQLite.SQLiteConnection"

    commandClass="Finisar.SQLite.SQLiteCommand"

    parameterClass="Finisar.SQLite.SQLiteParameter"

    parameterDbTypeClass="System.Data.DbType, System.Data"

    parameterDbTypeProperty="DbType"

    dataAdapterClass="Finisar.SQLite.SQLiteDataAdapter"

    commandBuilderClass="Finisar.SQLite.SQLiteCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="@"

    setDbParameterPrecision="false"

    setDbParameterScale="false"/>

<provider

    name="Firebird1.7"

    description="Firebird, Firebird SQL .NET provider V1.7.0.33200"

    enabled="false"

    assemblyName="FirebirdSql.Data.Firebird, Version=1.7.0.33200, Culture=neutral, PublicKeyToken=fa843d180294369d" connectionClass="FirebirdSql.Data.Firebird.FbConnection"

    commandClass="FirebirdSql.Data.Firebird.FbCommand"

    parameterClass="FirebirdSql.Data.Firebird.FbParameter"

    parameterDbTypeClass="FirebirdSql.Data.Firebird.FbDbType"

    parameterDbTypeProperty="FbDbType"

    dataAdapterClass="FirebirdSql.Data.Firebird.FbDataAdapter"

    commandBuilderClass="FirebirdSql.Data.Firebird.FbCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix="@"/>

<provider

    name="PostgreSql0.7"

    description="PostgreSql, Npgsql provider V0.7.0.0"

    enabled="false"

    assemblyName="Npgsql, Version=0.7.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"

    connectionClass="Npgsql.NpgsqlConnection"

    commandClass="Npgsql.NpgsqlCommand"

    parameterClass="Npgsql.NpgsqlParameter"

    parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType"

    parameterDbTypeProperty="NpgsqlDbType"

    dataAdapterClass="Npgsql.NpgsqlDataAdapter"

    commandBuilderClass="Npgsql.NpgsqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix=":"/>

<provider

    name="PostgreSql0.7.1"

    description="PostgreSql, Npgsql provider V0.7.1.0"

    enabled="false"

    assemblyName="Npgsql, Version=0.7.1.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"

    connectionClass="Npgsql.NpgsqlConnection"

    commandClass="Npgsql.NpgsqlCommand"

    parameterClass="Npgsql.NpgsqlParameter"

    parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType"

    parameterDbTypeProperty="NpgsqlDbType"

    dataAdapterClass="Npgsql.NpgsqlDataAdapter"

    commandBuilderClass="Npgsql.NpgsqlCommandBuilder"

    usePositionalParameters="false"

    useParameterPrefixInSql="true"

    useParameterPrefixInParameter="true"

    parameterPrefix=":"/>

<provider

    name="iDb2.10"

    description="IBM DB2 Provider, V 10.0"

    enabled="false"

    assemblyName="IBM.Data.DB2.iSeries, Version=10.0.0.0,Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26, Custom=null" connectionClass="IBM.Data.DB2.iSeries.iDB2Connection"

    commandClass="IBM.Data.DB2.iSeries.iDB2Command"

    parameterClass="IBM.Data.DB2.iSeries.iDB2Parameter"

    parameterDbTypeClass="IBM.Data.DB2.iSeries.iDB2DbType"

    parameterDbTypeProperty="iDB2DbType"

    dataAdapterClass="IBM.Data.DB2.iSeries.iDB2DataAdapter"

    commandBuilderClass="IBM.Data.DB2.iSeries.iDB2CommandBuilder"

    usePositionalParameters="true"

    useParameterPrefixInSql="false"

    useParameterPrefixInParameter="false"

    parameterPrefix=""/>

<provider

    name="Informix"

    description="Informix NET Provider, 2.81.0.0"

    enabled="false"

    assemblyName="IBM.Data.Informix, Version=2.81.0.0, Culture=neutral, PublicKeyToken=7c307b91aa13d208"

    connectionClass="IBM.Data.Informix.IfxConnection"

    commandClass="IBM.Data.Informix.IfxCommand"

    parameterClass="IBM.Data.Informix.IfxParameter"

    parameterDbTypeClass="IBM.Data.Informix.IfxType"

    parameterDbTypeProperty="IfxType"

    dataAdapterClass="IBM.Data.Informix.IfxDataAdapter"

    commandBuilderClass="IBM.Data.Informix.IfxCommandBuilder"

    usePositionalParameters = "true"

    useParameterPrefixInSql = "false"

    useParameterPrefixInParameter = "false"

    useDeriveParameters="false"

    />

</providers>

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema targetNamespace="http://ibatis.apache.org/dataMapper"

elementFormDefault="qualified"

xmlns:mstns="http://tempuri.org/XMLSchema.xsd"

xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns="http://ibatis.apache.org/dataMapper"

xmlns:vs="http://schemas.microsoft.com/Visual-Studio-Intellisense"

vs:friendlyname="iBATIS.NET DataMapper Configuration Schema"

vs:ishtmlschema="false"

vs:iscasesensitive="true"

vs:requireattributequotes="true"

vs:defaultnamespacequalifier=""

vs:defaultnsprefix=""> 

    <xs:annotation>

        <xs:documentation>

        DataMapper XML Schema Definition

    </xs:documentation>

    </xs:annotation>

    <xs:element name="typeAlias">

        <xs:complexType>

            <xs:attribute name="alias" type="xs:string" use="required"/>

            <xs:attribute name="type" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="typeHandler">

        <xs:complexType>

            <xs:attribute name="type" type="xs:string"/>

            <xs:attribute name="dbType" type="xs:string"/>

            <xs:attribute name="callback" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="typeHandlers">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="typeHandler" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="alias">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="typeAlias" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="dataSource">

        <xs:complexType>

            <xs:attribute name="name" type="xs:string" use="required"/>

            <xs:attribute name="connectionString" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="database">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="provider"/>

                <xs:element ref="dataSource"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="properties">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="property" minOccurs="0" maxOccurs="unbounded"/>

            </xs:sequence>

            <xs:attribute name="resource" type="xs:string"/>

            <xs:attribute name="url" type="xs:string"/>

            <xs:attribute name="embedded" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="property">

        <xs:complexType>

            <xs:attribute name="resource" type="xs:string"/>

            <xs:attribute name="url" type="xs:string"/>

            <xs:attribute name="embedded" type="xs:string"/>

            <xs:attribute name="key" type="xs:string"/>

            <xs:attribute name="value" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="provider">

        <xs:complexType>

            <xs:attribute name="name" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="setting">

        <xs:complexType>

            <xs:attribute name="useStatementNamespaces" type="xs:string"  default="false"/>

            <xs:attribute name="cacheModelsEnabled" type="xs:string"/>

            <xs:attribute name="validateSqlMap" type="xs:string" default="false"/>

            <xs:attribute name="useEmbedStatementParams" type="xs:boolean" default="false"/>

            <xs:attribute name="useReflectionOptimizer" type="xs:boolean" default="true"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="settings">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="setting" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="sqlMap">

        <xs:complexType>

            <xs:attribute name="resource" type="xs:string"/>

            <xs:attribute name="url" type="xs:string"/>

            <xs:attribute name="embedded" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="providers">

        <xs:complexType>

            <xs:attribute name="resource" type="xs:string"/>

            <xs:attribute name="url" type="xs:string"/>

            <xs:attribute name="embedded" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:annotation>

        <xs:documentation>

         The document root.

        </xs:documentation>

    </xs:annotation>

    <xs:element name="sqlMapConfig">

        <xs:complexType mixed="true">

            <xs:sequence>

                <xs:element ref="properties" minOccurs="0"/>

                <xs:element ref="settings" minOccurs="0"/>

                <xs:element ref="providers" minOccurs="0"/>

                <xs:element ref="database" minOccurs="0"/>

                <xs:element ref="alias" minOccurs="0"/>

                <xs:element ref="typeHandlers" minOccurs="0"/>

                <xs:element ref="sqlMaps" minOccurs="0"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="sqlMaps">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="sqlMap" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

</xs:schema>

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema

targetNamespace="http://ibatis.apache.org/mapping"

elementFormDefault="qualified"

xmlns:mstns="http://tempuri.org/XMLSchema.xsd"

xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns="http://ibatis.apache.org/mapping"

xmlns:vs="http://schemas.microsoft.com/Visual-Studio-Intellisense"

vs:friendlyname="iBATIS.NET mapping file Configuration Schema"

vs:ishtmlschema="false"

vs:iscasesensitive="true"

vs:requireattributequotes="true"

vs:defaultnamespacequalifier=""

vs:defaultnsprefix="" >

    <xs:annotation>

        <xs:documentation>

        Mapping XML Schema Definition

    </xs:documentation>

    </xs:annotation>

    <xs:element name="alias">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="typeAlias" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="discriminator">

        <xs:complexType>

            <xs:attribute name="column" type="xs:string"/>

            <xs:attribute name="type" type="xs:string"/>

            <xs:attribute name="typeHandler" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="subMap">

        <xs:complexType>

            <xs:attribute name="value" use="required" type="xs:string"/>

            <xs:attribute name="resultMapping" use="required" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="cacheModel">

        <xs:complexType>

            <xs:sequence maxOccurs="unbounded">

                <xs:element ref="flushInterval" minOccurs="0"/>

                <xs:element ref="flushOnExecute" minOccurs="0" maxOccurs="unbounded"/>

                <xs:element ref="property" minOccurs="0" maxOccurs="unbounded"/>

            </xs:sequence>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="serialize" type="xs:string"  default="false"/>

            <xs:attribute name="readOnly" type="xs:string"  default="true"/>

            <xs:attribute name="implementation" use="required">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="LRU"/>

                        <xs:enumeration value="MEMORY"/>

                        <xs:enumeration value="FIFO"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="cacheModels">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="cacheModel" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="procedure">

        <xs:complexType mixed="true">

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="parameterMap" type="xs:string" />

            <xs:attribute name="resultMap" type="xs:string"/>

            <xs:attribute name="resultClass" type="xs:string"/>

            <xs:attribute name="cacheModel" type="xs:string"/>

            <xs:attribute name="listClass" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="delete">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="generate"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="id" use="required"/>

            <xs:attribute name="parameterMap" type="xs:string"/>

            <xs:attribute name="parameterClass" type="xs:string"/>

            <xs:attribute name="extends" type="xs:string"/>

            <xs:attribute name="remapResults">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="include">

        <xs:complexType mixed="true">

            <xs:attribute name="refid" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="dynamic">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="flushInterval">

        <xs:complexType>

            <xs:attribute name="milliseconds" type="xs:byte"/>

            <xs:attribute name="seconds" type="xs:byte"/>

            <xs:attribute name="minutes" type="xs:byte"/>

            <xs:attribute name="hours" type="xs:byte"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="flushOnExecute">

        <xs:complexType>

            <xs:attribute name="statement" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="generate">

        <xs:complexType>

            <xs:attribute name="table" type="xs:string" use="required"/>

            <xs:attribute name="by" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="insert">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="selectKey"/>

                <xs:element ref="generate"/>

                <xs:element ref="dynamic"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="parameterClass" type="xs:string"/>

            <xs:attribute name="parameterMap" type="xs:string"/>

            <xs:attribute name="resultClass" type="xs:string"/>

            <xs:attribute name="remapResults">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNotParameterPresent">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNotPropertyAvailable">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isEmpty">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isEqual">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNull">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isGreaterEqual">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isGreaterThan">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isLessEqual">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isLessThan">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNotEmpty">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNotEqual">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="compareProperty" type="xs:string"/>

            <xs:attribute name="compareValue" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isNotNull">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isParameterPresent">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="isPropertyAvailable">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="prepend" type="xs:string"/>

            <xs:attribute name="property" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="iterate">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="open" type="xs:string" use="required"/>

            <xs:attribute name="close" type="xs:string" use="required"/>

            <xs:attribute name="conjunction" type="xs:string" use="required"/>

            <xs:attribute name="property" type="xs:string"/>

            <xs:attribute name="prepend" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="parameter">

        <xs:complexType>

            <xs:attribute name="property" type="xs:string" use="required"/>

            <xs:attribute name="column" type="xs:string"/>

            <xs:attribute name="nullValue" type="xs:string"/>

            <xs:attribute name="type" type="xs:string"/>

            <xs:attribute name="dbType" type="xs:string"/>

            <xs:attribute name="size" type="xs:string"/>

            <xs:attribute name="scale" type="xs:string"/>

            <xs:attribute name="precision" type="xs:string"/>

            <xs:attribute name="typeHandler" type="xs:string"/>

            <xs:attribute name="direction">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="Input"/>

                        <xs:enumeration value="Output"/>

                        <xs:enumeration value="InputOutput"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="parameterMap">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded"/>

            </xs:sequence>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="class" type="xs:string" />

            <xs:attribute name="extends" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="parameterMaps">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="parameterMap" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="property">

        <xs:complexType>

            <xs:attribute name="name" type="xs:string" use="required"/>

            <xs:attribute name="value" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="result">

        <xs:complexType>

            <xs:attribute name="property" type="xs:string" use="required"/>

            <xs:attribute name="column" type="xs:string"/>

            <xs:attribute name="lazyLoad">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

            <xs:attribute name="select" type="xs:string"/>

            <xs:attribute name="nullValue" type="xs:string"/>

            <xs:attribute name="type" type="xs:string"/>

            <xs:attribute name="dbType" type="xs:string"/>

            <xs:attribute name="columnIndex" type="xs:string"/>

            <xs:attribute name="resultMapping" type="xs:string"/>

            <xs:attribute name="typeHandler" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="argument">

        <xs:complexType>

            <xs:attribute name="argumentName" type="xs:string" use="required"/>

            <xs:attribute name="column" type="xs:string"/>

            <xs:attribute name="select" type="xs:string"/>

            <xs:attribute name="nullValue" type="xs:string"/>

            <xs:attribute name="type" type="xs:string"/>

            <xs:attribute name="dbType" type="xs:string"/>

            <xs:attribute name="columnIndex" type="xs:string"/>

            <xs:attribute name="resultMapping" type="xs:string"/>

            <xs:attribute name="typeHandler" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="constructor">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="argument" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="resultMap">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="constructor" minOccurs="0" maxOccurs="1"/>

                <xs:element ref="result" minOccurs="0" maxOccurs="unbounded"/>

                <xs:element ref="discriminator" minOccurs="0" maxOccurs="1"/>

                <xs:element ref="subMap" minOccurs="0" maxOccurs="unbounded"/>

            </xs:sequence>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="class" type="xs:string" use="required"/>

            <xs:attribute name="extends" type="xs:string"/>

            <xs:attribute name="groupBy" type="xs:string"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="resultMaps">

        <xs:complexType>

            <xs:sequence>

                <xs:element ref="resultMap" minOccurs="0" maxOccurs="unbounded"/>

            </xs:sequence>

        </xs:complexType>

    </xs:element>

    <xs:element name="select">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="dynamic"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

                <xs:element ref="generate"/>

            </xs:choice>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="parameterClass" type="xs:string"/>

            <xs:attribute name="resultMap" type="xs:string"/>

            <xs:attribute name="resultClass" type="xs:string"/>

            <xs:attribute name="parameterMap" type="xs:string"/>

            <xs:attribute name="cacheModel" type="xs:string"/>

            <xs:attribute name="listClass" type="xs:string"/>

            <xs:attribute name="extends" type="xs:string"/>

            <xs:attribute name="remapResults">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="selectKey">

        <xs:complexType>

            <xs:simpleContent>

                <xs:extension base="xs:string">

                    <xs:attribute name="property" type="xs:string" use="required"/>

                    <xs:attribute name="type" use="required">

                        <xs:simpleType>

                            <xs:restriction base="xs:NMTOKEN">

                                <xs:enumeration value="post"/>

                                <xs:enumeration value="pre"/>

                            </xs:restriction>

                        </xs:simpleType>

                    </xs:attribute>

                    <xs:attribute name="resultClass" type="xs:string" use="required"/>

                </xs:extension>

            </xs:simpleContent>

        </xs:complexType>

    </xs:element>

    <xs:element name="sqlMap">

        <xs:complexType>

            <xs:all>

                <xs:element ref="alias" minOccurs="0"/>

                <xs:element ref="cacheModels" minOccurs="0"/>

                <xs:element ref="resultMaps" minOccurs="0"/>

                <xs:element ref="statements" minOccurs="0" />

                <xs:element ref="parameterMaps" minOccurs="0"/>

            </xs:all>

            <xs:attribute name="namespace" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="sql">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="dynamic"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="id" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="statement">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="dynamic"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="parameterClass" type="xs:string"/>

            <xs:attribute name="resultMap" type="xs:string"/>

            <xs:attribute name="resultClass" type="xs:string"/>

            <xs:attribute name="parameterMap" type="xs:string"/>

            <xs:attribute name="listClass" type="xs:string"/>

            <xs:attribute name="cacheModel" type="xs:string"/>

            <xs:attribute name="remapResults">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

    <xs:element name="statements">

        <xs:complexType>

            <xs:choice maxOccurs="unbounded">

                <xs:element ref="sql"/>

                <xs:element ref="statement"/>

                <xs:element ref="insert"/>

                <xs:element ref="update"/>

                <xs:element ref="delete"/>

                <xs:element ref="select"/>

                <xs:element ref="procedure"/>

            </xs:choice>

        </xs:complexType>

    </xs:element>

    <xs:element name="typeAlias">

        <xs:complexType>

            <xs:attribute name="alias" type="xs:string" use="required"/>

            <xs:attribute name="type" type="xs:string" use="required"/>

        </xs:complexType>

    </xs:element>

    <xs:element name="update">

        <xs:complexType mixed="true">

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                <xs:element ref="include"/>

                <xs:element ref="generate"/>

                <xs:element ref="dynamic"/>

                <xs:element ref="isEmpty"/>

                <xs:element ref="isEqual"/>

                <xs:element ref="isGreaterEqual"/>

                <xs:element ref="isGreaterThan"/>

                <xs:element ref="isLessThan"/>

                <xs:element ref="isLessEqual"/>

                <xs:element ref="isNotEmpty"/>

                <xs:element ref="isNotEqual"/>

                <xs:element ref="isNotNull"/>

                <xs:element ref="isNotParameterPresent"/>

                <xs:element ref="isNotPropertyAvailable"/>

                <xs:element ref="isNull"/>

                <xs:element ref="isParameterPresent"/>

                <xs:element ref="isPropertyAvailable"/>

                <xs:element ref="iterate"/>

            </xs:choice>

            <xs:attribute name="id" type="xs:string" use="required"/>

            <xs:attribute name="parameterMap" type="xs:string"/>

            <xs:attribute name="parameterClass" type="xs:string"/>

            <xs:attribute name="extends" type="xs:string"/>

            <xs:attribute name="remapResults">

                <xs:simpleType>

                    <xs:restriction base="xs:NMTOKEN">

                        <xs:enumeration value="false"/>

                        <xs:enumeration value="true"/>

                    </xs:restriction>

                </xs:simpleType>

            </xs:attribute>

        </xs:complexType>

    </xs:element>

</xs:schema>