Exemplos de mssql10_table::contains_index em PHP

Exemplo n.º 1

Arquivo: mssql10_diff_tables.php Projeto: williammoran/DBSteward

 public static function diff_clusters_table($ofs, $old_schema, $old_table, $new_schema, $new_table)
 {
     if ($old_table == NULL) {
         $old_cluster = NULL;
     } else {
         $old_cluster = isset($old_table['clusterIndex']) ? $old_table['clusterIndex'] : NULL;
     }
     $new_cluster = isset($new_table['clusterIndex']) ? $new_table['clusterIndex'] : NULL;
     if ($old_cluster == NULL && $new_cluster != NULL || $old_cluster != NULL && $new_cluster != NULL && strcmp($new_cluster, $old_cluster) != 0) {
         $ofs->write("ALTER TABLE " . mssql10::get_quoted_schema_name($new_schema['name']) . '.' . mssql10::get_quoted_table_name($new_table['name']) . " CLUSTER ON " . mssql10::get_quoted_column_name($new_cluster) . ";\n");
     } else {
         if ($old_cluster != NULL && $new_cluster == NULL && mssql10_table::contains_index($new_schema, $new_table, $old_cluster)) {
             $ofs->write("ALTER TABLE " . mssql10::get_quoted_schema_name($new_schema['name']) . '.' . mssql10::get_quoted_table_name($table['name']) . " SET WITHOUT CLUSTER;" . "\n");
         }
     }
 }