phpBB

Code Changes

File: phpbb/db/extractor/mssql_extractor.php

  Unmodified   Added   Modified   Removed
Line 132Line 132
		$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
{

		$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
{

			if (!sizeof($rows))

			if (!count($rows))

			{
$sql_data .= "ALTER TABLE [$table_name] WITH NOCHECK ADD\n";
$sql_data .= "\tCONSTRAINT [{$row['CONSTRAINT_NAME']}] PRIMARY KEY CLUSTERED \n\t(\n";
}
$rows[] = "\t\t[{$row['COLUMN_NAME']}]";
}

			{
$sql_data .= "ALTER TABLE [$table_name] WITH NOCHECK ADD\n";
$sql_data .= "\tCONSTRAINT [{$row['CONSTRAINT_NAME']}] PRIMARY KEY CLUSTERED \n\t(\n";
}
$rows[] = "\t\t[{$row['COLUMN_NAME']}]";
}

		if (sizeof($rows))

		if (count($rows))

		{
$sql_data .= implode(",\n", $rows);
$sql_data .= "\n\t) ON [PRIMARY] \nGO\n";

		{
$sql_data .= implode(",\n", $rows);
$sql_data .= "\n\t) ON [PRIMARY] \nGO\n";