VbzCart/docs/tables/orders/migration: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables‎ | orders
Jump to navigation Jump to search
imported>Woozle
m (updated syntax highlighting tag)
m (Woozle moved page VbzCart/VbzCart/tables/orders/migration to VbzCart/docs/tables/orders/migration without leaving a redirect: part 4/5)
 
(No difference)

Latest revision as of 01:57, 25 February 2024

Migration

This was used to migrate the data on 2016-03-06: 

INSERT INTO orders_new(
  `ID`,
  `Number`,
  `SortPfx`,
  `ID_Cart`,
  `ID_Pull`,
  `ID_Buyer`,
  `ID_Recip`,
  `BuyerName`,
  `RecipName`,
  `RecipAddr`,
  `PayType`,
  `ID_BuyerCard`,
  `ID_RecipAddr`,
  `WebTotal_Merch`,
  `WebTotal_Ship`,
  `WebTotal_Final`,
  `WhenStarted`,
  `WhenPlaced`,
  `WhenRevised`,
  `WhenNeeded`,
  `WhenClosed`
)
SELECT 
  `ID`,
  `Number`,
  `SortPfx`,
  `ID_Cart`,
  `ID_Pull`,
  `ID_Buyer`,
  `ID_Recip`,
  `BuyerName`,
  `RecipName`,
  `RecipAddr`,
  `PayType`,
  `ID_BuyerCard`,
  `ID_RecipAddr`,
  `WebTotal_Merch`,
  `WebTotal_Ship`,
  `WebTotal_Final`,
  `WhenStarted`,
  `WhenPlaced`,
  `WhenEdited`,
  `WhenNeeded`,
  `WhenClosed`
FROM orders

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...)

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/orders/migration&oldid=6937"