
USE SodaDB
GO

-- Literal schema
CREATE XML SCHEMA COLLECTION dbo.InventoryReq_xsd
AS
'<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.company.com/inventoryRequest">
  <xs:element name="InventoryReq">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="order" type="xs:integer" />
        <xs:element name="product" type="xs:integer" />
        <xs:element name="units" type="xs:integer" />
        <xs:element name="status" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>'
GO

