bb-drummer /
my-application
@@ -568,39 +568,39 @@ |
||
| 568 | 568 | $fields = trim($m[3]); |
| 569 | 569 | switch($action) |
| 570 | 570 | { |
| 571 | - case 'drop': |
|
| 572 | - if ($type=='primary') { |
|
| 573 | - $result.= 'DROP PRIMARY KEY'; |
|
| 574 | - } |
|
| 575 | - else |
|
| 576 | - { |
|
| 577 | - $result.= 'DROP INDEX `'.$name.'`'; |
|
| 578 | - } |
|
| 579 | - break; |
|
| 580 | - case 'add': |
|
| 581 | - if ($type=='primary') { |
|
| 582 | - $result.= 'ADD PRIMARY KEY '.$fields; |
|
| 583 | - } |
|
| 584 | - elseif ($type=='') { |
|
| 585 | - $result.= 'ADD INDEX `'.$name.'` '.$fields; |
|
| 586 | - } |
|
| 587 | - else |
|
| 588 | - { |
|
| 589 | - $result .='ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
|
| 590 | - } |
|
| 591 | - break; |
|
| 592 | - case 'modify': |
|
| 593 | - if ($type=='primary') { |
|
| 594 | - $result.='DROP PRIMARY KEY, ADD PRIMARY KEY '.$fields; |
|
| 595 | - } |
|
| 596 | - elseif ($type=='') { |
|
| 597 | - $result.='DROP INDEX `'.$name.'`, ADD INDEX `'.$name.'` '.$fields; |
|
| 598 | - } |
|
| 599 | - else |
|
| 600 | - { |
|
| 601 | - $result.='DROP INDEX `'.$name.'`, ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
|
| 602 | - } |
|
| 603 | - break; |
|
| 571 | + case 'drop': |
|
| 572 | + if ($type=='primary') { |
|
| 573 | + $result.= 'DROP PRIMARY KEY'; |
|
| 574 | + } |
|
| 575 | + else |
|
| 576 | + { |
|
| 577 | + $result.= 'DROP INDEX `'.$name.'`'; |
|
| 578 | + } |
|
| 579 | + break; |
|
| 580 | + case 'add': |
|
| 581 | + if ($type=='primary') { |
|
| 582 | + $result.= 'ADD PRIMARY KEY '.$fields; |
|
| 583 | + } |
|
| 584 | + elseif ($type=='') { |
|
| 585 | + $result.= 'ADD INDEX `'.$name.'` '.$fields; |
|
| 586 | + } |
|
| 587 | + else |
|
| 588 | + { |
|
| 589 | + $result .='ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
|
| 590 | + } |
|
| 591 | + break; |
|
| 592 | + case 'modify': |
|
| 593 | + if ($type=='primary') { |
|
| 594 | + $result.='DROP PRIMARY KEY, ADD PRIMARY KEY '.$fields; |
|
| 595 | + } |
|
| 596 | + elseif ($type=='') { |
|
| 597 | + $result.='DROP INDEX `'.$name.'`, ADD INDEX `'.$name.'` '.$fields; |
|
| 598 | + } |
|
| 599 | + else |
|
| 600 | + { |
|
| 601 | + $result.='DROP INDEX `'.$name.'`, ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
|
| 602 | + } |
|
| 603 | + break; |
|
| 604 | 604 | |
| 605 | 605 | } |
| 606 | 606 | } |
