100606 15:32:42	  319 Connect	root@60.48.92.207 on mpcms11
		  319 Query	SET autocommit=0
100606 15:32:43	  319 Query	SHOW VARIABLES
100606 15:32:44	  319 Query	SHOW COLLATION
100606 15:32:45	  319 Query	SET character_set_results=NULL
100606 15:32:48	  319 Init DB	mpcms11
100606 15:33:27	  319 Query	SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
		  319 Query	BEGIN
100606 15:33:28	  319 Query	Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'
100606 15:33:29	  319 Query	Insert into tblReceipt Set receiptID=2162, outletID=11, employeeID=26, customerName='Cash', customerPhone='', totalCostAmount=257, totalSellingAmount=290, totalProfitAmount=33, changeAmount=0, profit='y', receiptDate = '2010:06:06', receiptTime = '15:18:34'
		  320 Connect	root@60.48.92.207 on mpcms11
		  320 Query	SET autocommit=0
100606 15:33:30	  320 Query	SHOW VARIABLES
100606 15:33:31	  320 Query	SHOW COLLATION
100606 15:33:32	  320 Query	SET character_set_results=NULL
		  319 Query	Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'
		  320 Init DB	mpcms11
		  319 Query	Update tblStock Set tblStock.stockStatus = 's'  Where tblStock.stockID=3120
100606 15:33:33	  320 Query	KILL QUERY 319
		  319 Query	Insert into tblReceiptDetails Set receiptID=2162, receiptDetailsID = 3687, outletID = 11,stockID = 3120, productID= 3007, productType = 'Imei', productQuantity = 1 , productSIQ = '359478030011584', costPrice = 257, sellingPrice = 290, profitAmount = 33, profit = 'y'
100606 15:33:34	  320 Quit	
		  319 Query	Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -257 Where tblProduct.productID=3007
100606 15:33:37	  319 Query	Insert into tblTransaction Set transactionID = 2162, transactionDetailsID=3687, stockID = 3120, productID= 3007, outletFromID = 11, outletToID = 11, totalAmountBefore = 514, totalAmountAfter = 257, totalQuantityBefore = 2, totalQuantityAfter = 1, averageCostBefore = 257, averageCostAfter = 257, quantity = 1, costPrice = 257, transactionPrice = 290, transactionEmployeeID = 26, transactionDate='2010:06:06', transactionTime='15:18:34', transactionType = 's'
		  319 Query	Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'
100606 15:33:40	  319 Query	Insert into tblPaymentDetails Set paymentDetailsID=2354, outletID = 11,receiptID = 2162, paymentTypeID= 1, amount = 290
100606 15:33:41	  319 Query	COMMIT
100606 15:33:42	  319 Quit