@@ -51,45 +51,45 @@ |
||
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | switch ($step) { |
| 54 | - case 1: // no tables exist |
|
| 55 | - $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_1; |
|
| 56 | - $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_1; |
|
| 57 | - break; |
|
| 58 | - case 2: // create initial table |
|
| 59 | - $migrate->addTable($uglyTableName); |
|
| 60 | - $migrate->addColumn($uglyTableName, 'id', 'int(10) NOT NULL AUTO_INCREMENT'); |
|
| 61 | - $migrate->addColumn($uglyTableName, 'content', 'text NOT NULL'); |
|
| 62 | - $migrate->addColumn($uglyTableName, 'uid', 'int(10) NOT NULL DEFAULT \'0\''); |
|
| 63 | - $migrate->addPrimaryKey($uglyTableName, 'id'); |
|
| 64 | - $migrate->addIndex('uidid', $uglyTableName, 'uid, id'); |
|
| 65 | - $migrate->executeQueue(); |
|
| 66 | - // fall through |
|
| 67 | - case 3: // have initial table |
|
| 68 | - $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_3; |
|
| 69 | - $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_3; |
|
| 70 | - break; |
|
| 71 | - case 4: // rename initial table |
|
| 72 | - $migrate->useTable($uglyTableName); |
|
| 73 | - $migrate->renameTable($uglyTableName, $mainTableName); |
|
| 74 | - $migrate->addColumn($mainTableName, 'update_time', 'int(10) NOT NULL DEFAULT \'0\''); |
|
| 75 | - $migrate->dropIndexes($mainTableName); |
|
| 76 | - $migrate->addIndex('uidupdate_time', $mainTableName, 'uid, update_time'); |
|
| 77 | - $migrate->executeQueue(); |
|
| 78 | - // fall through |
|
| 79 | - case 5: // have renamed table |
|
| 80 | - $migrate->resetQueue(); // getting the changes for display |
|
| 81 | - $migrate->useTable($mainTableName); |
|
| 82 | - $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_5; |
|
| 83 | - $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_5; |
|
| 84 | - break; |
|
| 85 | - case 6: // drop table and restart demo |
|
| 86 | - $migrate->useTable($mainTableName); |
|
| 87 | - $migrate->dropTable($mainTableName); |
|
| 88 | - $migrate->executeQueue(); |
|
| 54 | + case 1: // no tables exist |
|
| 55 | + $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_1; |
|
| 56 | + $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_1; |
|
| 57 | + break; |
|
| 58 | + case 2: // create initial table |
|
| 59 | + $migrate->addTable($uglyTableName); |
|
| 60 | + $migrate->addColumn($uglyTableName, 'id', 'int(10) NOT NULL AUTO_INCREMENT'); |
|
| 61 | + $migrate->addColumn($uglyTableName, 'content', 'text NOT NULL'); |
|
| 62 | + $migrate->addColumn($uglyTableName, 'uid', 'int(10) NOT NULL DEFAULT \'0\''); |
|
| 63 | + $migrate->addPrimaryKey($uglyTableName, 'id'); |
|
| 64 | + $migrate->addIndex('uidid', $uglyTableName, 'uid, id'); |
|
| 65 | + $migrate->executeQueue(); |
|
| 66 | + // fall through |
|
| 67 | + case 3: // have initial table |
|
| 68 | + $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_3; |
|
| 69 | + $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_3; |
|
| 70 | + break; |
|
| 71 | + case 4: // rename initial table |
|
| 72 | + $migrate->useTable($uglyTableName); |
|
| 73 | + $migrate->renameTable($uglyTableName, $mainTableName); |
|
| 74 | + $migrate->addColumn($mainTableName, 'update_time', 'int(10) NOT NULL DEFAULT \'0\''); |
|
| 75 | + $migrate->dropIndexes($mainTableName); |
|
| 76 | + $migrate->addIndex('uidupdate_time', $mainTableName, 'uid, update_time'); |
|
| 77 | + $migrate->executeQueue(); |
|
| 78 | + // fall through |
|
| 79 | + case 5: // have renamed table |
|
| 80 | + $migrate->resetQueue(); // getting the changes for display |
|
| 81 | + $migrate->useTable($mainTableName); |
|
| 82 | + $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_5; |
|
| 83 | + $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_5; |
|
| 84 | + break; |
|
| 85 | + case 6: // drop table and restart demo |
|
| 86 | + $migrate->useTable($mainTableName); |
|
| 87 | + $migrate->dropTable($mainTableName); |
|
| 88 | + $migrate->executeQueue(); |
|
| 89 | 89 | |
| 90 | - $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_1; |
|
| 91 | - $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_1; |
|
| 92 | - break; |
|
| 90 | + $formCaption = _MA_XMFDEMO_TABLE_FORM_TITLE_1; |
|
| 91 | + $formMessage = _MA_XMFDEMO_TABLE_FORM_MESSAGE_1; |
|
| 92 | + break; |
|
| 93 | 93 | } |
| 94 | 94 | |
| 95 | 95 | $form = new \XoopsThemeForm($formCaption, 'form', '', 'POST'); |