https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Ftables%2Forders%2Fmigration 2026-06-29T23:56:10Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/tables/orders/migration&diff=25898&oldid=prev 2020-02-03T15:55:08Z

<p>updated syntax highlighting tag</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:55, 3 February 2020</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Migration===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Migration===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This was used to migrate the data on 2016-03-06:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This was used to migrate the data on 2016-03-06:</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;mysql&gt;INSERT INTO orders_new(</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;<ins style="font-weight: bold; text-decoration: none;">source lang=</ins>mysql&gt;INSERT INTO orders_new(</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `ID`,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `ID`,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `Number`,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `Number`,</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l46">Line 46:</td> <td colspan="2" class="diff-lineno">Line 46:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `WhenNeeded`,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `WhenNeeded`,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `WhenClosed`</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   `WhenClosed`</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>FROM orders&lt;/<del style="font-weight: bold; text-decoration: none;">mysql</del>&gt;Note that "WhenEdited" was copied to "WhenRevised" in the new table, not to "WhenEdited". (2016-03-07 Update: it turns out that this can be done with a single SQL command, which MySQL Workbench can facilitate via some controls that are normally hidden in a drop-down area. Now I know...)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>FROM orders&lt;/<ins style="font-weight: bold; text-decoration: none;">source</ins>&gt;Note that "WhenEdited" was copied to "WhenRevised" in the new table, not to "WhenEdited". (2016-03-07 Update: it turns out that this can be done with a single SQL command, which MySQL Workbench can facilitate via some controls that are normally hidden in a drop-down area. Now I know...)</div></td></tr> </table>

Woozle https://htyp.org/mw/index.php?title=VbzCart/tables/orders/migration&diff=22707&oldid=prev 2017-06-03T16:18:14Z

<p>extracted from main page</p> <p><b>New page</b></p><div>===Migration===<br /> This was used to migrate the data on 2016-03-06:<br /> &lt;mysql&gt;INSERT INTO orders_new(<br /> `ID`,<br /> `Number`,<br /> `SortPfx`,<br /> `ID_Cart`,<br /> `ID_Pull`,<br /> `ID_Buyer`,<br /> `ID_Recip`,<br /> `BuyerName`,<br /> `RecipName`,<br /> `RecipAddr`,<br /> `PayType`,<br /> `ID_BuyerCard`,<br /> `ID_RecipAddr`,<br /> `WebTotal_Merch`,<br /> `WebTotal_Ship`,<br /> `WebTotal_Final`,<br /> `WhenStarted`,<br /> `WhenPlaced`,<br /> `WhenRevised`,<br /> `WhenNeeded`,<br /> `WhenClosed`<br /> )<br /> SELECT <br /> `ID`,<br /> `Number`,<br /> `SortPfx`,<br /> `ID_Cart`,<br /> `ID_Pull`,<br /> `ID_Buyer`,<br /> `ID_Recip`,<br /> `BuyerName`,<br /> `RecipName`,<br /> `RecipAddr`,<br /> `PayType`,<br /> `ID_BuyerCard`,<br /> `ID_RecipAddr`,<br /> `WebTotal_Merch`,<br /> `WebTotal_Ship`,<br /> `WebTotal_Final`,<br /> `WhenStarted`,<br /> `WhenPlaced`,<br /> `WhenEdited`,<br /> `WhenNeeded`,<br /> `WhenClosed`<br /> FROM orders&lt;/mysql&gt;Note that &quot;WhenEdited&quot; was copied to &quot;WhenRevised&quot; in the new table, not to &quot;WhenEdited&quot;. (2016-03-07 Update: it turns out that this can be done with a single SQL command, which MySQL Workbench can facilitate via some controls that are normally hidden in a drop-down area. Now I know...)</div>

Woozle