---

$tableName = [string]$Item

try { 
	$cmd = $Connection.CreateCommand()
	$cmd.CommandText = "SELECT [Goods supplier number] FROM [$Item] WHERE 1 = 0"

	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
} 
catch {
	$cmd = $Connection.CreateCommand()
	$cmd.CommandText = @"
	ALTER TABLE [$TableName] ADD [Goods supplier number] TEXT(50) 
"@
	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
}

try { 
	$cmd = $Connection.CreateCommand()
	$cmd.CommandText = "SELECT [Goods supplier name] FROM [$Item] WHERE 1 = 0"

	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
} 
catch {
	$cmd = $Connection.CreateCommand()

	$cmd.CommandText = @"
	ALTER TABLE [$TableName] ADD [Goods supplier name] TEXT(255) 
"@
	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
}

try { 
	$cmd = $Connection.CreateCommand()
	$cmd.CommandText = "SELECT [Complete Name] FROM [$Item] WHERE 1 = 0"

	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
} 
catch {
	$cmd = $Connection.CreateCommand()

	$cmd.CommandText = @"
	ALTER TABLE [$TableName] ADD [Complete Name] TEXT(255) 
"@
	$cmd.ExecuteNonQuery() | Out-Null
	$cmd.Dispose()
}