IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryDate')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryDate] DATETIME NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryAttention')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryAttention] NVARCHAR(200) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryTelephone')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryTelephone] NVARCHAR(200) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryInstructions')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryInstructions] NVARCHAR(1000) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryStreet')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryStreet] NVARCHAR(64) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliverySuburb')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliverySuburb] NVARCHAR(64) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryCity')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryCity] NVARCHAR(32) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryState')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryState] NVARCHAR(32) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryPostalCode')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryPostalCode] NVARCHAR(16) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'deliveryCountry')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [deliveryCountry] NVARCHAR(32) NULL
END

