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

create xml schema collection	dbo.BookAuthor
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="authorCollection">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="author" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="lastName" type="xs:string"/>
										<xs:element name="firstName" type="xs:string"/>
									</xs:sequence>
									<xs:attribute name="authorId" 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="authorIds" type="xs:IDREFS" use="optional"/>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
</xs:schema>'
go