On 09/21/2012 01:25 PM, John Webber wrote:
Thanks for the answer, unfortunately editing the xsd is not an option, since
it's downloaded from the net
Then you should send an email to the authors of the schema reporting
what is a bug, albeit a minor one.
and I don't control the document. Or could I somehow make a modified version of
the xsd known to xxe?
Sure. Simply create an XML catalog
(http://xerces.apache.org/xml-commons/components/resolver/resolver-article.html)
pointing to a local copy of the schema. Of course, this local copy would
not contain the bug.
It's so simple that I've done that for you. Please copy the 2 attached
files to the *addon* *subdirectory* of your user preferences directory,
restart XXE, clear the schema cache and you are done.
Your user preferences directory is:
-----------------------------------
* $HOME/.xxe5/ on Linux.
* $HOME/Library/Application Support/XMLmind/XMLEditor5/ on the Mac.
* %APPDATA%\XMLmind\XMLEditor5\ on Windows XP, Vista and 7.
Example: C:\Documents and Settings\john\Application
Data\XMLmind\XMLEditor5\ on Windows XP.
C:\Users\john\AppData\Roaming\XMLmind\XMLEditor5\ on Windows Vista and 7.
If you cannot see the "Application Data" directory using
Microsoft Windows File Manager, turn on Tools>Folder Options>View>File
and Folders>Show hidden files and folders.
-----------------------------------
More information about configuring XXE:
http://www.xmlmind.com/xmleditor/_distrib/doc/configure/config_file.html
The error message seems rather strong
In our opinion, the error message is quite precise rather than being
``strong''.
, if it can be otherwise safely ignored - it would be a nice feature if one could select
a checkbox "don't show this again".
As I've explained it in my previous answer, there is no bug we could
fix. (We would have gladly fixed it ASAP if it was the case.) Moreover,
no offense intended, but we don't see the point of implementing an
option saying "silently accept XSD having minor errors".
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema";
targetNamespace="http://www.liquibase.org/xml/ns/dbchangelog"; xmlns="http://www.liquibase.org/xml/ns/dbchangelog";
elementFormDefault="qualified">
<xsd:simpleType name="propertyExpression" id="propertyExpression">
<xsd:restriction base="xsd:string">
<xsd:pattern value="$\{[\w\.]+\}"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="booleanExp" id="booleanExp">
<xsd:annotation>
<xsd:appinfo>
<xsd:documentation>Extension to standard XSD boolean type to allow ${} parameters</xsd:documentation>
</xsd:appinfo>
</xsd:annotation>
<xsd:union>
<xsd:simpleType>
<xsd:restriction base="xsd:boolean"/>
</xsd:simpleType>
<xsd:simpleType>
<xsd:restriction base="propertyExpression"/>
</xsd:simpleType>
</xsd:union>
</xsd:simpleType>
<xsd:simpleType name="integerExp" id="integerExp">
<xsd:annotation>
<xsd:appinfo>
<xsd:documentation>Extension to standard XSD integer type to allow ${} parameters</xsd:documentation>
</xsd:appinfo>
</xsd:annotation>
<xsd:union>
<xsd:simpleType>
<xsd:restriction base="xsd:integer"/>
</xsd:simpleType>
<xsd:simpleType>
<xsd:restriction base="propertyExpression"/>
</xsd:simpleType>
</xsd:union>
</xsd:simpleType>
<xsd:simpleType name="onChangeSetPreconditionErrorOrFail">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="HALT" />
<xsd:enumeration value="WARN" />
<xsd:enumeration value="CONTINUE" />
<xsd:enumeration value="MARK_RAN" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="onChangeLogPreconditionErrorOrFail">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="HALT" />
<xsd:enumeration value="WARN" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="onChangeLogPreconditionOnSqlOutput">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="TEST" />
<xsd:enumeration value="FAIL" />
<xsd:enumeration value="IGNORE" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="onChangeSetValidationFail">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="HALT" />
<xsd:enumeration value="MARK_RAN" />
</xsd:restriction>
</xsd:simpleType>
<!-- This is the main (root) part of the xsd -->
<xsd:element name="databaseChangeLog">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="property" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="file" type="xsd:string" />
<xsd:attribute name="name" type="xsd:string" />
<xsd:attribute name="value" type="xsd:string" />
<xsd:attribute name="dbms" type="xsd:string" />
<xsd:attribute name="context" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="preConditions" minOccurs="0"
maxOccurs="1">
<xsd:complexType>
<xsd:choice>
<xsd:group ref="PreConditionChildren" maxOccurs="unbounded" />
</xsd:choice>
<xsd:attribute name="onFailMessage" type="xsd:string" />
<xsd:attribute name="onErrorMessage" type="xsd:string" />
<xsd:attribute name="onFail"
type="onChangeLogPreconditionErrorOrFail" />
<xsd:attribute name="onError"
type="onChangeLogPreconditionErrorOrFail" />
<xsd:attribute name="onSqlOutput"
type="onChangeLogPreconditionOnSqlOutput" />
</xsd:complexType>
</xsd:element>
<xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="changeSet" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="validCheckSum" minOccurs="0"
maxOccurs="unbounded">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element ref="comment" minOccurs="0"
maxOccurs="1" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="preConditions" minOccurs="0"
maxOccurs="1">
<xsd:annotation>
<xsd:appinfo>
<xsd:documentation>onChangeLogPreconditionOnSqlOutput determines what should happen when evaluating this precondition in updateSQL mode. TEST: Run precondition, FAIL: Fail precondition, IGNORE: Skip precondition check [DEFAULT]</xsd:documentation>
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:choice>
<xsd:group ref="PreConditionChildren" maxOccurs="unbounded" />
</xsd:choice>
<xsd:attribute name="onFailMessage" type="xsd:string" />
<xsd:attribute name="onErrorMessage" type="xsd:string" />
<xsd:attribute name="onFail"
type="onChangeSetPreconditionErrorOrFail" />
<xsd:attribute name="onError"
type="onChangeSetPreconditionErrorOrFail" />
<xsd:attribute name="onSqlOutput"
type="onChangeLogPreconditionOnSqlOutput" />
</xsd:complexType>
</xsd:element>
<xsd:choice>
<xsd:element ref="tagDatabase" maxOccurs="1" />
<xsd:group ref="changeSetChildren" minOccurs="0"
maxOccurs="unbounded" />
</xsd:choice>
<xsd:element name="modifySql" minOccurs="0"
maxOccurs="unbounded">
<xsd:complexType>
<xsd:choice>
<xsd:group ref="modifySqlChildren" minOccurs="1"
maxOccurs="unbounded" />
</xsd:choice>
<xsd:attribute name="dbms" type="xsd:string" />
<xsd:attribute name="context" type="xsd:string" />
<xsd:attribute name="applyToRollback" type="booleanExp" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attributeGroup ref="changeSetAttributes" />
</xsd:complexType>
</xsd:element>
<!-- include -->
<xsd:element name="include" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="file" type="xsd:string" use="required" />
<xsd:attribute name="relativeToChangelogFile" type="booleanExp" />
</xsd:complexType>
</xsd:element>
<xsd:element name="includeAll" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="path" type="xsd:string" use="required" />
<xsd:attribute name="relativeToChangelogFile" type="booleanExp" />
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:sequence>
<xsd:attributeGroup ref="changeLogAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:group name="modifySqlChildren">
<xsd:choice>
<xsd:element name="replace" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="replace" type="xsd:string" use="required" />
<xsd:attribute name="with" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="regExpReplace" minOccurs="0"
maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="replace" type="xsd:string" use="required" />
<xsd:attribute name="with" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="prepend" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="value" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="append" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="value" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:group>
<!-- Attributes for DatabaseInfo -->
<xsd:attributeGroup name="DatabaseInfoAttributes">
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="version" type="xsd:string" />
<xsd:attribute name="username" type="xsd:string" />
<xsd:attribute name="password" type="xsd:string" />
<xsd:attribute name="port" type="integerExp" />
<xsd:attribute name="host" type="xsd:string" />
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="driverName" type="xsd:string" />
</xsd:attributeGroup>
<!-- Attributes for changeSet -->
<xsd:attributeGroup name="changeLogAttributes">
<xsd:attribute name="logicalFilePath" type="xsd:string" />
</xsd:attributeGroup>
<!-- Attributes for changeSet -->
<xsd:attributeGroup name="changeSetAttributes">
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="author" type="xsd:string" use="required" />
<xsd:attribute name="context" type="xsd:string" />
<xsd:attribute name="dbms" type="xsd:string" />
<xsd:attribute name="runOnChange" type="booleanExp" />
<xsd:attribute name="runAlways" type="booleanExp" />
<xsd:attribute name="failOnError" type="booleanExp" />
<xsd:attribute name="onValidationFail" type="onChangeSetValidationFail" />
<xsd:attribute name="runInTransaction" type="booleanExp" default="true" />
<xsd:attribute name="logicalFilePath" type="xsd:string" />
</xsd:attributeGroup>
<!-- Attributes for constraints -->
<xsd:attributeGroup name="constraintsAttributes">
<xsd:attribute name="nullable" type="booleanExp" />
<xsd:attribute name="primaryKey" type="booleanExp" />
<xsd:attribute name="primaryKeyName" type="xsd:string" />
<xsd:attribute name="primaryKeyTablespace" type="xsd:string" />
<xsd:attribute name="unique" type="booleanExp" />
<xsd:attribute name="uniqueConstraintName" type="xsd:string" />
<xsd:attribute name="references" type="xsd:string" />
<xsd:attribute name="foreignKeyName" type="xsd:string" />
<xsd:attribute name="deleteCascade" type="booleanExp" />
<xsd:attribute name="deferrable" type="booleanExp" />
<xsd:attribute name="initiallyDeferred" type="booleanExp" />
</xsd:attributeGroup>
<xsd:attributeGroup name="column">
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="value" type="xsd:string" />
<xsd:attribute name="valueNumeric" type="xsd:string" />
<xsd:attribute name="valueBoolean" type="xsd:string" />
<xsd:attribute name="valueDate" type="xsd:string" />
<xsd:attribute name="valueComputed" type="xsd:string" />
<xsd:attribute name="defaultValue" type="xsd:string" />
<xsd:attribute name="defaultValueNumeric" type="xsd:string" />
<xsd:attribute name="defaultValueDate" type="xsd:string" />
<xsd:attribute name="defaultValueBoolean" type="booleanExp" />
<xsd:attribute name="defaultValueComputed" type="xsd:string" />
<xsd:attribute name="autoIncrement" type="booleanExp" />
<xsd:attribute name="remarks" type="xsd:string" />
</xsd:attributeGroup>
<xsd:attributeGroup name="dropTableAttributes">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="cascadeConstraints" type="booleanExp" />
</xsd:attributeGroup>
<xsd:attributeGroup name="renameTableAttributes">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="oldTableName" type="xsd:string"
use="required" />
<xsd:attribute name="newTableName" type="xsd:string"
use="required" />
</xsd:attributeGroup>
<xsd:attributeGroup name="renameViewAttributes">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="oldViewName" type="xsd:string" use="required" />
<xsd:attribute name="newViewName" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:attributeGroup name="tableNameAttribute">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:attributeGroup name="renameColumnAttributes">
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attribute name="oldColumnName" type="xsd:string"
use="required" />
<xsd:attribute name="newColumnName" type="xsd:string"
use="required" />
<xsd:attribute name="columnDataType" type="xsd:string" />
</xsd:attributeGroup>
<xsd:attributeGroup name="dropColumnAttributes">
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:attributeGroup name="sequenceAttributes">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="sequenceName" type="xsd:string"
use="required" />
<xsd:attribute name="startValue" type="xsd:string" />
<xsd:attribute name="incrementBy" type="xsd:string" />
<xsd:attribute name="maxValue" type="xsd:string" />
<xsd:attribute name="minValue" type="xsd:string" />
<xsd:attribute name="ordered" type="booleanExp" />
</xsd:attributeGroup>
<xsd:attributeGroup name="indexName">
<xsd:attribute name="indexName" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:attributeGroup name="createIndex">
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attributeGroup ref="indexName" />
<xsd:attribute name="associatedWith" type="xsd:string" use="optional" />
<xsd:attribute name="unique" type="booleanExp" />
<xsd:attribute name="tablespace" type="xsd:string" />
</xsd:attributeGroup>
<xsd:element name="addPrimaryKey">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnNames" type="xsd:string"
use="required" />
<xsd:attribute name="constraintName" type="xsd:string" />
<xsd:attribute name="tablespace" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropPrimaryKey">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="constraintName" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="addUniqueConstraint">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnNames" type="xsd:string"
use="required" />
<xsd:attribute name="constraintName" type="xsd:string" />
<xsd:attribute name="tablespace" type="xsd:string" />
<xsd:attribute name="disabled" type="booleanExp" />
<xsd:attribute name="deferrable" type="booleanExp" />
<xsd:attribute name="initiallyDeferred" type="booleanExp" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropUniqueConstraint">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="constraintName" type="xsd:string" />
<xsd:attribute name="uniqueColumns" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="modifyDataType">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="newDataType" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="addLookupTable">
<xsd:complexType>
<xsd:attribute name="existingTableSchemaName" type="xsd:string" />
<xsd:attribute name="existingTableName" type="xsd:string"
use="required" />
<xsd:attribute name="existingColumnName" type="xsd:string"
use="required" />
<xsd:attribute name="newTableSchemaName" type="xsd:string" />
<xsd:attribute name="newTableName" type="xsd:string"
use="required" />
<xsd:attribute name="newColumnName" type="xsd:string"
use="required" />
<xsd:attribute name="newColumnDataType" type="xsd:string" />
<xsd:attribute name="constraintName" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="addAutoIncrement">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="columnDataType" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="addDefaultValue">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="columnDataType" type="xsd:string" />
<xsd:attribute name="defaultValue" type="xsd:string" />
<xsd:attribute name="defaultValueNumeric" type="xsd:string" />
<xsd:attribute name="defaultValueDate" type="xsd:string" />
<xsd:attribute name="defaultValueBoolean" type="xsd:string" />
<xsd:attribute name="defaultValueComputed" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropDefaultValue">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="columnDataType" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="loadData">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element name="column" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="index" type="integerExp" />
<xsd:attribute name="header" type="xsd:string" />
<xsd:attribute name="name" type="xsd:string" />
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="defaultValue" type="xsd:string" />
<xsd:attribute name="defaultValueNumeric" type="xsd:string" />
<xsd:attribute name="defaultValueDate" type="xsd:string" />
<xsd:attribute name="defaultValueBoolean" type="booleanExp" />
<xsd:attribute name="defaultValueComputed" type="xsd:string" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="file" type="xsd:string" />
<xsd:attribute name="encoding" type="xsd:string" default="UTF-8"/>
<xsd:attribute name="separator" type="xsd:string" default=","/>
<xsd:attribute name="quotchar" type="xsd:string" default="""/>
</xsd:complexType>
</xsd:element>
<xsd:element name="loadUpdateData">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element name="column" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="index" type="integerExp" />
<xsd:attribute name="header" type="xsd:string" />
<xsd:attribute name="name" type="xsd:string" />
<xsd:attribute name="type" type="xsd:string" />
<xsd:attribute name="defaultValue" type="xsd:string" />
<xsd:attribute name="defaultValueNumeric" type="xsd:string" />
<xsd:attribute name="defaultValueDate" type="xsd:string" />
<xsd:attribute name="defaultValueBoolean" type="booleanExp" />
<xsd:attribute name="defaultValueComputed" type="xsd:string" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="file" type="xsd:string" />
<xsd:attribute name="encoding" type="xsd:string" default="UTF-8"/>
<xsd:attribute name="primaryKey" type="xsd:string" use="required" />
<xsd:attribute name="separator" type="xsd:string" default=","/>
<xsd:attribute name="quotchar" type="xsd:string" default="""/>
</xsd:complexType>
</xsd:element>
<xsd:simpleType name="fkCascadeActionOptions">
<xsd:restriction base="xsd:token">
<xsd:enumeration value="CASCADE"></xsd:enumeration>
<xsd:enumeration value="SET NULL"></xsd:enumeration>
<xsd:enumeration value="SET DEFAULT"></xsd:enumeration>
<xsd:enumeration value="RESTRICT"></xsd:enumeration>
<xsd:enumeration value="NO ACTION"></xsd:enumeration>
</xsd:restriction>
</xsd:simpleType>
<xsd:attributeGroup name="addForeignKeyConstraintAttrib">
<xsd:attribute name="baseTableSchemaName" type="xsd:string" />
<xsd:attribute name="baseTableName" type="xsd:string"
use="required" />
<xsd:attribute name="baseColumnNames" type="xsd:string"
use="required" />
<xsd:attribute name="constraintName" type="xsd:string"
use="required" />
<xsd:attribute name="referencedTableSchemaName" type="xsd:string" />
<xsd:attribute name="referencedTableName" type="xsd:string"
use="required" />
<xsd:attribute name="referencedColumnNames" type="xsd:string"
use="required" />
<xsd:attribute name="deferrable" type="booleanExp" />
<xsd:attribute name="initiallyDeferred" type="booleanExp" />
<xsd:attribute name="deleteCascade" type="booleanExp" />
<xsd:attribute name="onDelete" type="fkCascadeActionOptions" />
<xsd:attribute name="onUpdate" type="fkCascadeActionOptions" />
<xsd:attribute name="referencesUniqueColumn" type="booleanExp" />
</xsd:attributeGroup>
<xsd:attributeGroup name="addNotNullConstraintAttrib">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="defaultNullValue" type="xsd:string" />
<xsd:attribute name="columnDataType" type="xsd:string" />
</xsd:attributeGroup>
<xsd:element name="addNotNullConstraint">
<xsd:complexType>
<xsd:attributeGroup ref="addNotNullConstraintAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:element name="addForeignKeyConstraint">
<xsd:complexType>
<xsd:attributeGroup ref="addForeignKeyConstraintAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:attributeGroup name="dbmsAttrib">
<xsd:attribute name="type" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:element name="dbms">
<xsd:complexType>
<xsd:attributeGroup ref="dbmsAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:element name="changeSetExecuted">
<xsd:complexType>
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="author" type="xsd:string" use="required" />
<xsd:attribute name="changeLogFile" type="xsd:string"
use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="tableExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="columnExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="sequenceExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="sequenceName" type="xsd:string"
use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="foreignKeyConstraintExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="foreignKeyTableName" type="xsd:string" />
<xsd:attribute name="foreignKeyName" type="xsd:string"
use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="indexExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="indexName" type="xsd:string"/>
<xsd:attribute name="tableName" type="xsd:string" />
<xsd:attribute name="columnNames" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="changeLogPropertyDefined">
<xsd:complexType>
<xsd:attribute name="property" type="xsd:string" use="required" />
<xsd:attribute name="value" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="primaryKeyExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="primaryKeyName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="viewExists">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="viewName" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="sqlCheck">
<xsd:complexType mixed="true">
<xsd:attribute name="expectedResult" type="xsd:string"
use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="customPrecondition">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="param" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="value" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="className" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="and">
<xsd:complexType>
<xsd:choice>
<xsd:group ref="PreConditionChildren" minOccurs="1"
maxOccurs="unbounded" />
</xsd:choice>
</xsd:complexType>
</xsd:element>
<xsd:element name="or">
<xsd:complexType>
<xsd:choice>
<xsd:group ref="PreConditionChildren" minOccurs="1"
maxOccurs="unbounded" />
</xsd:choice>
</xsd:complexType>
</xsd:element>
<xsd:element name="not">
<xsd:complexType>
<xsd:choice>
<xsd:group ref="PreConditionChildren" minOccurs="1"
maxOccurs="unbounded" />
</xsd:choice>
</xsd:complexType>
</xsd:element>
<xsd:attributeGroup name="runningAsAttrib">
<xsd:attribute name="username" type="xsd:string" use="required" />
</xsd:attributeGroup>
<xsd:element name="runningAs">
<xsd:complexType>
<xsd:attributeGroup ref="runningAsAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:attributeGroup name="dropForeignKeyConstraintAttrib">
<xsd:attribute name="baseTableSchemaName" type="xsd:string" />
<xsd:attribute name="baseTableName" type="xsd:string"
use="required" />
<xsd:attribute name="constraintName" type="xsd:string" />
</xsd:attributeGroup>
<xsd:element name="dropForeignKeyConstraint">
<xsd:complexType>
<xsd:attributeGroup ref="dropForeignKeyConstraintAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:attributeGroup name="dropAllForeignKeyConstraintsAttrib">
<xsd:attribute name="baseTableSchemaName" type="xsd:string" />
<xsd:attribute name="baseTableName" type="xsd:string"
use="required" />
</xsd:attributeGroup>
<xsd:element name="dropAllForeignKeyConstraints">
<xsd:complexType>
<xsd:attributeGroup ref="dropAllForeignKeyConstraintsAttrib" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropNotNullConstraint">
<xsd:complexType>
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="tableName" type="xsd:string" use="required" />
<xsd:attribute name="columnName" type="xsd:string" use="required" />
<xsd:attribute name="columnDataType" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="constraints">
<xsd:complexType>
<xsd:attributeGroup ref="constraintsAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="column">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element ref="constraints" minOccurs="0" />
</xsd:sequence>
<xsd:attributeGroup ref="column" />
</xsd:complexType>
</xsd:element>
<!-- Children for createTable -->
<xsd:element name="createTable">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="column" minOccurs="1" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attribute name="tablespace" type="xsd:string" />
<xsd:attribute name="remarks" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<!-- Children for createView -->
<xsd:element name="createView">
<xsd:complexType>
<xsd:simpleContent>
<xsd:extension base="xsd:string">
<xsd:attribute name="schemaName" type="xsd:string" />
<xsd:attribute name="viewName" type="xsd:string" use="required" />
<xsd:attribute name="replaceIfExists" type="booleanExp" />
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
</xsd:element>
<!-- Children for insert -->
<xsd:element name="insert">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="column" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attributeGroup ref="tableNameAttribute" />
</xsd:complexType>
</xsd:element>
<xsd:element name="update">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element ref="column" minOccurs="1" maxOccurs="unbounded" />
<xsd:element name="where" minOccurs="0" maxOccurs="1" />
</xsd:sequence>
<xsd:attributeGroup ref="tableNameAttribute" />
</xsd:complexType>
</xsd:element>
<xsd:element name="delete">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element name="where" minOccurs="0" maxOccurs="1" />
</xsd:sequence>
<xsd:attributeGroup ref="tableNameAttribute" />
</xsd:complexType>
</xsd:element>
<!-- Children for addColum -->
<xsd:element name="addColumn">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="column" minOccurs="1" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attributeGroup ref="tableNameAttribute" />
</xsd:complexType>
</xsd:element>
<xsd:element name="rollback">
<xsd:complexType mixed="true">
<xsd:choice>
<xsd:group ref="changeSetChildren" minOccurs="0"
maxOccurs="unbounded" />
</xsd:choice>
<xsd:attribute name="changeSetPath" type="xsd:string" />
<xsd:attribute name="changeSetAuthor" type="xsd:string" />
<xsd:attribute name="changeSetId" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<!-- comment -->
<xsd:element name="comment" type="xsd:string" />
<!-- sql -->
<xsd:element name="sql">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element ref="comment" minOccurs="0" maxOccurs="1" />
</xsd:sequence>
<xsd:attribute name="stripComments" type="booleanExp" />
<xsd:attribute name="splitStatements" type="booleanExp" />
<xsd:attribute name="endDelimiter" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="createProcedure">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element ref="comment" minOccurs="0" maxOccurs="1" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="executeCommand">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="arg" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType>
<xsd:attribute name="value" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="executable" type="xsd:string" use="required" />
<xsd:attribute name="os" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="sqlFile">
<xsd:complexType>
<xsd:attribute name="path" type="xsd:string" use="required" />
<xsd:attribute name="stripComments" type="booleanExp" />
<xsd:attribute name="splitStatements" type="booleanExp" />
<xsd:attribute name="encoding" type="xsd:string" default="UTF-8"/>
<xsd:attribute name="endDelimiter" type="xsd:string" />
<xsd:attribute name="relativeToChangelogFile" type="booleanExp" />
</xsd:complexType>
</xsd:element>
<xsd:element name="tagDatabase">
<xsd:complexType>
<xsd:attribute name="tag" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="stop">
<xsd:complexType mixed="true" />
</xsd:element>
<!-- renameTable -->
<xsd:element name="renameTable">
<xsd:complexType>
<xsd:attributeGroup ref="renameTableAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="renameView">
<xsd:complexType>
<xsd:attributeGroup ref="renameViewAttributes" />
</xsd:complexType>
</xsd:element>
<!-- dropTable -->
<xsd:element name="dropTable">
<xsd:complexType>
<xsd:attributeGroup ref="dropTableAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropView">
<xsd:complexType>
<xsd:attribute name="viewName" type="xsd:string" use="required" />
<xsd:attribute name="schemaName" type="xsd:string" />
</xsd:complexType>
</xsd:element>
<!-- renameColumn -->
<xsd:element name="renameColumn">
<xsd:complexType>
<xsd:attributeGroup ref="renameColumnAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropColumn">
<xsd:complexType>
<xsd:attributeGroup ref="dropColumnAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="mergeColumns">
<xsd:complexType>
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attribute name="column1Name" type="xsd:string"
use="required" />
<xsd:attribute name="joinString" type="xsd:string" use="required" />
<xsd:attribute name="column2Name" type="xsd:string"
use="required" />
<xsd:attribute name="finalColumnName" type="xsd:string"
use="required" />
<xsd:attribute name="finalColumnType" type="xsd:string"
use="required" />
</xsd:complexType>
</xsd:element>
<xsd:group name="whereClause">
<xsd:sequence>
<xsd:element name="whereClause" type="xsd:string"
minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:group>
<xsd:element name="createSequence">
<xsd:complexType>
<xsd:attributeGroup ref="sequenceAttributes" />
<xsd:attribute name="cycle" type="booleanExp">
<xsd:annotation>
<xsd:documentation>
true for a cycling sequence, false for a non-cycling sequence.
Default is false.
</xsd:documentation>
</xsd:annotation>
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="alterSequence">
<xsd:complexType>
<xsd:attributeGroup ref="sequenceAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropSequence">
<xsd:complexType>
<xsd:attributeGroup ref="sequenceAttributes" />
</xsd:complexType>
</xsd:element>
<xsd:element name="createIndex">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="column" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attributeGroup ref="createIndex" />
</xsd:complexType>
</xsd:element>
<xsd:element name="dropIndex">
<xsd:complexType>
<xsd:attributeGroup ref="tableNameAttribute" />
<xsd:attributeGroup ref="indexName" />
<xsd:attribute name="associatedWith" type="xsd:string" use="optional" />
</xsd:complexType>
</xsd:element>
<xsd:element name="customChange">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="param" minOccurs="0" maxOccurs="unbounded">
<xsd:complexType mixed="true">
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="value" type="xsd:string" />
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="class" type="xsd:string" use="required" />
<xsd:anyAttribute processContents="lax" />
</xsd:complexType>
</xsd:element>
<!-- Children for changeSet -->
<xsd:group name="changeSetChildren">
<xsd:choice>
<xsd:element ref="comment" maxOccurs="1" />
<xsd:element ref="createTable" maxOccurs="unbounded" />
<xsd:element ref="dropTable" maxOccurs="unbounded" />
<xsd:element ref="createView" maxOccurs="unbounded" />
<xsd:element ref="renameView" maxOccurs="unbounded" />
<xsd:element ref="dropView" maxOccurs="unbounded" />
<xsd:element ref="insert" maxOccurs="unbounded" />
<xsd:element ref="addColumn" maxOccurs="unbounded" />
<xsd:element ref="sql" maxOccurs="unbounded" />
<xsd:element ref="createProcedure" maxOccurs="unbounded" />
<xsd:element ref="sqlFile" maxOccurs="unbounded" />
<xsd:element ref="renameTable" maxOccurs="unbounded" />
<xsd:element ref="renameColumn" maxOccurs="unbounded" />
<xsd:element ref="dropColumn" maxOccurs="unbounded" />
<xsd:element ref="mergeColumns" maxOccurs="unbounded" />
<xsd:element ref="modifyDataType" maxOccurs="unbounded" />
<xsd:element ref="createSequence" maxOccurs="unbounded" />
<xsd:element ref="alterSequence" maxOccurs="unbounded" />
<xsd:element ref="dropSequence" maxOccurs="unbounded" />
<xsd:element ref="createIndex" maxOccurs="unbounded" />
<xsd:element ref="dropIndex" maxOccurs="unbounded" />
<xsd:element ref="addNotNullConstraint" maxOccurs="unbounded" />
<xsd:element ref="dropNotNullConstraint" maxOccurs="unbounded" />
<xsd:element ref="addForeignKeyConstraint" maxOccurs="unbounded" />
<xsd:element ref="dropForeignKeyConstraint" maxOccurs="unbounded" />
<xsd:element ref="dropAllForeignKeyConstraints"
maxOccurs="unbounded" />
<xsd:element ref="addPrimaryKey" maxOccurs="unbounded" />
<xsd:element ref="dropPrimaryKey" maxOccurs="unbounded" />
<xsd:element ref="addLookupTable" maxOccurs="unbounded" />
<xsd:element ref="addAutoIncrement" maxOccurs="unbounded" />
<xsd:element ref="addDefaultValue" maxOccurs="unbounded" />
<xsd:element ref="dropDefaultValue" maxOccurs="unbounded" />
<xsd:element ref="addUniqueConstraint" maxOccurs="unbounded" />
<xsd:element ref="dropUniqueConstraint" maxOccurs="unbounded" />
<xsd:element ref="customChange" maxOccurs="unbounded" />
<xsd:element ref="update" maxOccurs="unbounded" />
<xsd:element ref="delete" maxOccurs="unbounded" />
<xsd:element ref="loadData" maxOccurs="unbounded" />
<xsd:element ref="loadUpdateData" maxOccurs="unbounded" />
<xsd:element ref="executeCommand" maxOccurs="unbounded" />
<xsd:element ref="stop" maxOccurs="unbounded" />
<xsd:element ref="rollback" maxOccurs="1" />
<xsd:any namespace="##other" processContents="lax" minOccurs="0"
maxOccurs="unbounded" />
</xsd:choice>
</xsd:group>
<!-- Children for Precondition -->
<xsd:group name="PreConditionChildren">
<xsd:sequence>
<xsd:choice>
<xsd:element ref="and" maxOccurs="unbounded" />
<xsd:element ref="or" maxOccurs="unbounded" />
<xsd:element ref="not" maxOccurs="unbounded" />
<xsd:element ref="dbms" maxOccurs="unbounded" />
<xsd:element ref="runningAs" maxOccurs="unbounded" />
<xsd:element ref="changeSetExecuted" maxOccurs="unbounded" />
<xsd:element ref="tableExists" maxOccurs="unbounded" />
<xsd:element ref="columnExists" maxOccurs="unbounded" />
<xsd:element ref="sequenceExists" maxOccurs="unbounded" />
<xsd:element ref="foreignKeyConstraintExists" maxOccurs="unbounded" />
<xsd:element ref="indexExists" maxOccurs="unbounded" />
<xsd:element ref="primaryKeyExists" maxOccurs="unbounded" />
<xsd:element ref="viewExists" maxOccurs="unbounded" />
<xsd:element ref="sqlCheck" maxOccurs="unbounded" />
<xsd:element ref="changeLogPropertyDefined" maxOccurs="unbounded" />
<xsd:element ref="customPrecondition" maxOccurs="unbounded" />
</xsd:choice>
</xsd:sequence>
</xsd:group>
</xsd:schema>
<catalog xmlns="urn:oasis:names:tc:entity:xmlns:xml:catalog">
<uri name="http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd";
uri="dbchangelog-2.0.xsd"/>
</catalog>
--
XMLmind XML Editor Support List
[email protected]
http://www.xmlmind.com/mailman/listinfo/xmleditor-support
