Project

General

Profile

Actions
Copy link

Feature #151

closed

Data Porting for Split Bill Cutover

Added by Chooi-Mey over 12 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Chong-Ting
Start date:
06/29/2012
Due date:
% Done:

0%

Estimated time:
Resolution:

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.

Actions
Copy link
 #1

Updated by Soh Keong over 12 years ago

  • 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

Actions
Copy link
 #2

Updated by Chooi-Mey over 12 years ago

  • Status changed from New to Closed
Actions
Copy link

Also available in: Atom PDF