Feature #151
closed
Data Porting for Split Bill Cutover
Added by Chooi-Mey over 12 years ago.
Updated over 12 years ago.
Description
Please prepare the sql for data porting of all records in Qiwi_Interface table into Qiwi_Interface_Sub table, so that data will be consistent after the split bill enhancement is deployed to production.
- Assignee changed from Soh Keong to Chong-Ting
Below is the SQL statement for data porting all records from Qiwi_Interface to Qiwi-Interface_Sub table.
INSERT INTO QIWI_INTERFACE_SUB (SUB_ORDER_ID, ORDER_ID, SUB_AMT, STATUS, CREATE_DATETIME, MODIFY_DATETIME) SELECT ORDER_ID, ORDER_ID, CHARGE_AMT, STATUS, CREATE_DATETIME, MODIFY_DATETIME FROM QIWI_INTERFACE
Thanks
- Status changed from New to Closed
Also available in: Atom
PDF