| @@ 587-590 (lines=4) @@ | ||
| 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') { |
|
| @@ 596-598 (lines=3) @@ | ||
| 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 |
|
| @@ 599-602 (lines=4) @@ | ||
| 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 | ||
| 605 | } |
|