@@ -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'); |