-- XPathFunctions_ID-IDREF_BookPublisher_XmlSchemaCollection_Script
if	(exists (
		select	*
			from	sys.xml_schema_collections
			where	(xml_schema_collections.[schema_id] = schema_id('dbo'))
				and (xml_schema_collections.name = 'BookPublisher')
		))
	begin
		drop xml schema collection	dbo.BookPublisher
	end
go

create xml schema collection	dbo.BookPublisher
as
N'<?xml version="1.0" encoding="UTF-16"?>
<xs:schema
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	targetNamespace="http://schemas.milambda.net/pubs"
	elementFormDefault="qualified"
	attributeFormDefault="qualified">
	<xs:element name="pubs">
		<xs:complexType>
			<xs:sequence>
				<xs:element name="publisherCollection">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="publisher" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="name" type="xs:string"/>
										<xs:element name="city" type="xs:string"/>
										<xs:element name="state" type="xs:string" nillable="true"/>
										<xs:element name="country" type="xs:string"/>
									</xs:sequence>
									<xs:attribute name="publisherId" type="xs:ID" use="required"/>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="titleCollection">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="title" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="title" type="xs:string"/>
										<xs:element name="type" type="xs:string"/>
										<xs:element name="price" type="xs:decimal" nillable="true"/>
									</xs:sequence>
									<xs:attribute name="titleId" type="xs:ID" use="required"/>
									<xs:attribute name="publisherId" type="xs:IDREF" use="optional"/>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
</xs:schema>'
go