CREATE DATABASE XMLInvoices
GO

USE XMLInvoices
GO

CREATE TABLE dbo.Invoices
	(
		InvoiceId INT IDENTITY(1,1) NOT NULL CONSTRAINT InvoiceId_PK PRIMARY KEY CLUSTERED
		,InvoiceNumber INT NOT NULL
		,InvoiceDate DATE NOT NULL
		,XMLPosition INT NOT NULL
	)
GO

CREATE TABLE dbo.InvoiceRows
	(
		InvoiceRowId INT IDENTITY(1,1) NOT NULL CONSTRAINT InvoiceRowId_PK PRIMARY KEY NONCLUSTERED
		,InvoiceId INT NOT NULL CONSTRAINT InvoiceRows_InvoiceId_FK FOREIGN KEY REFERENCES dbo.Invoices(InvoiceId)
		,Product VARCHAR(10) NOT NULL
		,Amount INT NOT NULL
	)
GO

CREATE UNIQUE CLUSTERED INDEX
	InvoiceRows_CLU
ON
	dbo.InvoiceRows (InvoiceId, InvoiceRowId)
GO