9789 Connect     root@60.50.10.32 on mpcms6
		   9789 Query       SHOW VARIABLES
		   9789 Query       SHOW COLLATION
		   9789 Query       SET character_set_results=NULL
		   9789 Init DB     mpcms6
		   9789 Query       SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
		   9789 Query       BEGIN
		   9790 Connect     root@60.50.10.32 on mpcms
100403 18:22:21	   9790 Query       SHOW VARIABLES
		   9790 Query       SHOW COLLATION
		   9790 Query       SET character_set_results=NULL
		   9790 Init DB     mpcms
		   9790 Query       SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
		   9790 Query       BEGIN
		   9790 Query       Select tblProduct.productID, tblFranchiseTransferDetails.stockID , tblFranchiseTransferDetails.franchiseTransferDetailsID , tblProduct.productType , tblFranchiseTransferDetails.costPrice , tblFranchiseTransferDetails.franchiseTransferPrice , tblFranchiseTransferDetails.stockSIQ From tblFranchiseTransferDetails Inner Join tblFranchiseTransfer On tblFranchiseTransfer.franchiseTransferID = tblFranchiseTransferDetails.franchiseTransferID Inner Join tblProduct On tblProduct.productID = tblFranchiseTransferDetails.productID Where tblFranchiseTransfer.outletFromID = 1  And tblFranchiseTransfer.franchiseTransferID = 852  And tblFranchiseTransferDetails.franchiseTransferID = 852  And tblFranchiseTransferDetails.outletID = 1
		   9789 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock'
		   9789 Query       Insert into tblStock Set receiveOrderID= 852,receiveOrderDetailsID = 4448, stockID = 2764,outletFromID = 1,outletID = 6,productID = 3504, productType='Imei', stockSIQ = '358039037160906', stockBalance = 1 ,costPrice = 555, stockPrice = 557, stockDate='2010:04:03', stockTime='18:22:36', transactionType='t'
		   9790 Query       Insert into tblStockCentral Set receiveOrderID=852,receiveOrderDetailsID = 4448, stockID = 2764,outletFromID = 1,outletID = 6,productID = 3504, stockSIQ = '358039037160906', transactionType = 't'
		   9790 Query       Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358039037160906'  And tblStockCentral.stockID=21348 And tblStockCentral.outletID=1
		   9789 Query       Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 557, tblProduct.productTotalAmount = 557 Where tblProduct.productID=3504
		   9790 Query       Update tblProduct Set tblProduct.branch6TotalStock = 1, tblProduct.branch6TotalAmount = 557 Where tblProduct.productID=3504
		   9789 Query       Insert into tblTransaction Set transactionID = 852, transactionDetailsID=4448, stockID = 2764, productID= 3504, outletFromID = 1, outletToID = 6, totalAmountBefore = 0, totalAmountAfter = 557, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 0, averageCostAfter = 557, quantity = 1, costPrice = 555, transactionPrice = 557, transactionEmployeeID = 86, transactionDate='2010:04:03', transactionTime='18:22:36', transactionType = 'ti'
100403 18:22:22	   9790 Query       Insert into tblTransaction Set transactionID = 852, transactionDetailsID=4448, stockID = 2764, productID= 3504, outletFromID = 1, outletToID = 6, totalAmountBefore = 0, totalAmountAfter = 557, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 0, averageCostAfter = 557, quantity = 1, costPrice = 555, transactionPrice = 557, transactionEmployeeID = 86, transactionDate='2010:04:03', transactionTime='18:22:36', transactionType = 'ti'
		   9789 Quit       
		   9790 Query       Update  tblFranchiseTransfer Set employeeToID='86',franchiseTransferStatus ='y',franchiseTransferToDate='2010:04:03', franchiseTransferToTime='18:22:36' Where franchiseTransferID=852 And  outletFromID =1
		   9790 Quit