{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Courier New;}{\f1\fswiss\fcharset0 Arial;}} {\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20 080913 0:08:37\tab 211 Connect root@localhost on mpcms3\par \tab\tab 211 Query SHOW VARIABLES\par \tab\tab 211 Query SHOW COLLATION\par \tab\tab 211 Query SET character_set_results=NULL\par \tab\tab 211 Init DB mpcms3\par \tab\tab 211 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 211 Quit \par \tab\tab 212 Connect root@localhost on mpcms3\par \tab\tab 212 Query SHOW VARIABLES\par \tab\tab 212 Query SHOW COLLATION\par \tab\tab 212 Query SET character_set_results=NULL\par \tab\tab 212 Init DB mpcms3\par \tab\tab 212 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 212 Quit \par 080913 0:38:38\tab 213 Connect root@localhost on mpcms3\par \tab\tab 213 Query SHOW VARIABLES\par \tab\tab 213 Query SHOW COLLATION\par \tab\tab 213 Query SET character_set_results=NULL\par \tab\tab 213 Init DB mpcms3\par \tab\tab 213 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 213 Quit \par \tab\tab 214 Connect root@localhost on mpcms3\par \tab\tab 214 Query SHOW VARIABLES\par \tab\tab 214 Query SHOW COLLATION\par \tab\tab 214 Query SET character_set_results=NULL\par \tab\tab 214 Init DB mpcms3\par \tab\tab 214 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 214 Quit \par 080913 1:04:48\tab 215 Connect root@60.48.245.60 on \par 080913 1:04:49\tab 215 Query Set names 'utf8'\par \tab\tab 215 Query set sql_mode=''\par \tab\tab 215 Query show databases\par 080913 1:06:53\tab 215 Query use `mpcms3`\par \tab\tab 215 Query show table status from `mpcms3` where engine is not NULL\par 080913 1:06:58\tab 215 Query show table status from `mpcms3` where engine is not NULL\par \tab\tab 215 Query show table status from `mpcms3` where engine is not NULL\par 080913 1:07:08\tab 216 Connect root@60.48.245.60 on \par \tab\tab 216 Query show variables\par \tab\tab 216 Query SET NAMES UTF8\par \tab\tab 216 Query USE `mpcms3`\par \tab\tab 216 Query Show tables from `mpcms3`\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbladdress`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbladdress`\par \tab\tab 216 Query show keys from `mpcms3`.`tbladdress`\par \tab\tab 216 Query select * from `mpcms3`.`tbladdress`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbladdress'\par \tab\tab 216 Query set sql_mode=''\par 080913 1:07:09\tab 216 Query show create table `mpcms3`.`tblbank`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblbank`\par \tab\tab 216 Query show keys from `mpcms3`.`tblbank`\par \tab\tab 216 Query select * from `mpcms3`.`tblbank`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblbank'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblcouponstock`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblcouponstock`\par \tab\tab 216 Query show keys from `mpcms3`.`tblcouponstock`\par \tab\tab 216 Query select * from `mpcms3`.`tblcouponstock`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblcouponstock'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblcreditcardtype`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblcreditcardtype`\par \tab\tab 216 Query show keys from `mpcms3`.`tblcreditcardtype`\par \tab\tab 216 Query select * from `mpcms3`.`tblcreditcardtype`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblcreditcardtype'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldealer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldealer`\par \tab\tab 216 Query select * from `mpcms3`.`tbldealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldealer'\par 080913 1:07:10\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldeposit`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldeposit`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldeposit`\par \tab\tab 216 Query select * from `mpcms3`.`tbldeposit`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldeposit'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldepositfullrefund`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldepositfullrefund`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldepositfullrefund`\par \tab\tab 216 Query select * from `mpcms3`.`tbldepositfullrefund`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldepositfullrefund'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldepositpaymentdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldepositpaymentdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldepositpaymentdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tbldepositpaymentdetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldepositpaymentdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldepositproductcancel`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldepositproductcancel`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldepositproductcancel`\par 080913 1:07:11\tab 216 Query select * from `mpcms3`.`tbldepositproductcancel`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldepositproductcancel'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldepositproducts`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldepositproducts`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldepositproducts`\par \tab\tab 216 Query select * from `mpcms3`.`tbldepositproducts`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldepositproducts'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbldepositrefund`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbldepositrefund`\par \tab\tab 216 Query show keys from `mpcms3`.`tbldepositrefund`\par \tab\tab 216 Query select * from `mpcms3`.`tbldepositrefund`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbldepositrefund'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblemployee`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblemployee`\par \tab\tab 216 Query show keys from `mpcms3`.`tblemployee`\par \tab\tab 216 Query select * from `mpcms3`.`tblemployee`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblemployee'\par 080913 1:07:12\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblfranchisetransfer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblfranchisetransfer`\par \tab\tab 216 Query show keys from `mpcms3`.`tblfranchisetransfer`\par \tab\tab 216 Query select * from `mpcms3`.`tblfranchisetransfer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblfranchisetransfer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblfranchisetransferdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblfranchisetransferdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblfranchisetransferdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblfranchisetransferdetails`\par 080913 1:07:13\tab 216 Query SHOW TRIGGERS LIKE 'tblfranchisetransferdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblfranchisetransferproductbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblfranchisetransferproductbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tblfranchisetransferproductbelowcost`\par \tab\tab 216 Query select * from `mpcms3`.`tblfranchisetransferproductbelowcost`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblfranchisetransferproductbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblfullrefund`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblfullrefund`\par \tab\tab 216 Query show keys from `mpcms3`.`tblfullrefund`\par \tab\tab 216 Query select * from `mpcms3`.`tblfullrefund`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblfullrefund'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblfullrefunddetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblfullrefunddetails`\par 080913 1:07:14\tab 216 Query show keys from `mpcms3`.`tblfullrefunddetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblfullrefunddetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblfullrefunddetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblid`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblid`\par \tab\tab 216 Query show keys from `mpcms3`.`tblid`\par \tab\tab 216 Query select * from `mpcms3`.`tblid`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblid'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblimeistock`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblimeistock`\par \tab\tab 216 Query show keys from `mpcms3`.`tblimeistock`\par \tab\tab 216 Query select * from `mpcms3`.`tblimeistock`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblimeistock'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblinvoice`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblinvoice`\par \tab\tab 216 Query show keys from `mpcms3`.`tblinvoice`\par \tab\tab 216 Query select * from `mpcms3`.`tblinvoice`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblinvoice'\par 080913 1:07:15\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblinvoicedetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblinvoicedetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblinvoicedetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblinvoicedetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblinvoicedetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblinvoiceproductbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblinvoiceproductbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tblinvoiceproductbelowcost`\par \tab\tab 216 Query select * from `mpcms3`.`tblinvoiceproductbelowcost`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblinvoiceproductbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblmainmenu`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblmainmenu`\par \tab\tab 216 Query show keys from `mpcms3`.`tblmainmenu`\par \tab\tab 216 Query select * from `mpcms3`.`tblmainmenu`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblmainmenu'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblmenuauthorization`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblmenuauthorization`\par \tab\tab 216 Query show keys from `mpcms3`.`tblmenuauthorization`\par \tab\tab 216 Query select * from `mpcms3`.`tblmenuauthorization`\par 080913 1:07:16\tab 216 Query SHOW TRIGGERS LIKE 'tblmenuauthorization'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblorderdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblorderdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblorderdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblorderdetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblorderdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbloutlet`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbloutlet`\par \tab\tab 216 Query show keys from `mpcms3`.`tbloutlet`\par \tab\tab 216 Query select * from `mpcms3`.`tbloutlet`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbloutlet'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpartialrefund`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpartialrefund`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpartialrefund`\par \tab\tab 216 Query select * from `mpcms3`.`tblpartialrefund`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblpartialrefund'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpartialrefunddetails`\par 080913 1:07:17\tab 216 Query select count(*) from `mpcms3`.`tblpartialrefunddetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpartialrefunddetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblpartialrefunddetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblpartialrefunddetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpaymentdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpaymentdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpaymentdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblpaymentdetails`\par 080913 1:07:19\tab 216 Query SHOW TRIGGERS LIKE 'tblpaymentdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpaymenttype`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpaymenttype`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpaymenttype`\par \tab\tab 216 Query select * from `mpcms3`.`tblpaymenttype`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblpaymenttype'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpricechanges`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpricechanges`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpricechanges`\par \tab\tab 216 Query select * from `mpcms3`.`tblpricechanges`\par 080913 1:07:22\tab 216 Query SHOW TRIGGERS LIKE 'tblpricechanges'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproduct`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproduct`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproduct`\par \tab\tab 216 Query select * from `mpcms3`.`tblproduct`\par 080913 1:07:29\tab 216 Query SHOW TRIGGERS LIKE 'tblproduct'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductbelowcost`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductbelowcost`\par 080913 1:07:30\tab 216 Query SHOW TRIGGERS LIKE 'tblproductbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductbrand`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductbrand`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductbrand`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductbrand`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductbrand'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductcategory`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductcategory`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductcategory`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductcategory`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductcategory'\par 080913 1:07:31\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductgroup`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductgroup`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductgroup`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductgroup`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductgroup'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductsettingsfranchiseoutlet`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductsettingsfranchiseoutlet`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsettingsfranchiseoutlet`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsettingsfranchiseoutlet`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsettingsfranchiseoutlet'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductsettingsnonfranchiseoutlet`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductsettingsnonfranchiseoutlet`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsettingsnonfranchiseoutlet`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsettingsnonfranchiseoutlet`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsettingsnonfranchiseoutlet'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductsettingstier1dealer`\par 080913 1:07:32\tab 216 Query select count(*) from `mpcms3`.`tblproductsettingstier1dealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsettingstier1dealer`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsettingstier1dealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsettingstier1dealer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductsettingstier2dealer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductsettingstier2dealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsettingstier2dealer`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsettingstier2dealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsettingstier2dealer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductsettingstier3dealer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductsettingstier3dealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsettingstier3dealer`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsettingstier3dealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsettingstier3dealer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblproductstatus`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductstatus`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductstatus`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductstatus`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductstatus'\par \tab\tab 216 Query set sql_mode=''\par 080913 1:07:33\tab 216 Query show create table `mpcms3`.`tblproductsubcategory`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblproductsubcategory`\par \tab\tab 216 Query show keys from `mpcms3`.`tblproductsubcategory`\par \tab\tab 216 Query select * from `mpcms3`.`tblproductsubcategory`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblproductsubcategory'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpurchaseorder`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpurchaseorder`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpurchaseorder`\par \tab\tab 216 Query select * from `mpcms3`.`tblpurchaseorder`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblpurchaseorder'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblpurchaseorderdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblpurchaseorderdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblpurchaseorderdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblpurchaseorderdetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblpurchaseorderdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreceipt`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreceipt`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreceipt`\par \tab\tab 216 Query select * from `mpcms3`.`tblreceipt`\par 080913 1:07:36\tab 216 Query SHOW TRIGGERS LIKE 'tblreceipt'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreceiptbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreceiptbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreceiptbelowcost`\par 080913 1:07:37\tab 216 Query select * from `mpcms3`.`tblreceiptbelowcost`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblreceiptbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreceiptdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreceiptdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreceiptdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblreceiptdetails`\par 080913 1:07:53\tab 216 Query SHOW TRIGGERS LIKE 'tblreceiptdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreceiveorder`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreceiveorder`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreceiveorder`\par \tab\tab 216 Query select * from `mpcms3`.`tblreceiveorder`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblreceiveorder'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreturnexchange`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreturnexchange`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreturnexchange`\par \tab\tab 216 Query select * from `mpcms3`.`tblreturnexchange`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblreturnexchange'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblreturnexchangedetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblreturnexchangedetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblreturnexchangedetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblreturnexchangedetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblreturnexchangedetails'\par 080913 1:07:54\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsaletodealer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsaletodealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsaletodealer`\par \tab\tab 216 Query select * from `mpcms3`.`tblsaletodealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsaletodealer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsaletodealerdetails`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsaletodealerdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsaletodealerdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tblsaletodealerdetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsaletodealerdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsaletodealerproductbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsaletodealerproductbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsaletodealerproductbelowcost`\par \tab\tab 216 Query select * from `mpcms3`.`tblsaletodealerproductbelowcost`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsaletodealerproductbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblstock`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblstock`\par \tab\tab 216 Query show keys from `mpcms3`.`tblstock`\par \tab\tab 216 Query select * from `mpcms3`.`tblstock`\par 080913 1:08:16\tab 216 Query SHOW TRIGGERS LIKE 'tblstock'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblstockcentral`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblstockcentral`\par \tab\tab 216 Query show keys from `mpcms3`.`tblstockcentral`\par 080913 1:08:17\tab 216 Query select * from `mpcms3`.`tblstockcentral`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblstockcentral'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsubmenu1`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsubmenu1`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsubmenu1`\par \tab\tab 216 Query select * from `mpcms3`.`tblsubmenu1`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsubmenu1'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsubmenu2`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsubmenu2`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsubmenu2`\par \tab\tab 216 Query select * from `mpcms3`.`tblsubmenu2`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsubmenu2'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblsupplier`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblsupplier`\par \tab\tab 216 Query show keys from `mpcms3`.`tblsupplier`\par \tab\tab 216 Query select * from `mpcms3`.`tblsupplier`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblsupplier'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltempfranchisetransfer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltempfranchisetransfer`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltempfranchisetransfer`\par 080913 1:08:18\tab 216 Query select * from `mpcms3`.`tbltempfranchisetransfer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltempfranchisetransfer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltempreceipt`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltempreceipt`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltempreceipt`\par \tab\tab 216 Query select * from `mpcms3`.`tbltempreceipt`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltempreceipt'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltempsaletodealer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltempsaletodealer`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltempsaletodealer`\par \tab\tab 216 Query select * from `mpcms3`.`tbltempsaletodealer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltempsaletodealer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltemptransfer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltemptransfer`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltemptransfer`\par \tab\tab 216 Query select * from `mpcms3`.`tbltemptransfer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltemptransfer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltradein`\par 080913 1:08:19\tab 216 Query select count(*) from `mpcms3`.`tbltradein`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltradein`\par \tab\tab 216 Query select * from `mpcms3`.`tbltradein`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltradein'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltransfer`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltransfer`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltransfer`\par \tab\tab 216 Query select * from `mpcms3`.`tbltransfer`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltransfer'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltransferdetails`\par 080913 1:08:20\tab 216 Query select count(*) from `mpcms3`.`tbltransferdetails`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltransferdetails`\par \tab\tab 216 Query select * from `mpcms3`.`tbltransferdetails`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltransferdetails'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tbltransferproductbelowcost`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tbltransferproductbelowcost`\par \tab\tab 216 Query show keys from `mpcms3`.`tbltransferproductbelowcost`\par \tab\tab 216 Query select * from `mpcms3`.`tbltransferproductbelowcost`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tbltransferproductbelowcost'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblupdatecentral`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblupdatecentral`\par \tab\tab 216 Query show keys from `mpcms3`.`tblupdatecentral`\par \tab\tab 216 Query select * from `mpcms3`.`tblupdatecentral`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblupdatecentral'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblupdatecentralcopy`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblupdatecentralcopy`\par \tab\tab 216 Query show keys from `mpcms3`.`tblupdatecentralcopy`\par 080913 1:08:21\tab 216 Query select * from `mpcms3`.`tblupdatecentralcopy`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblupdatecentralcopy'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblupdatelocal`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblupdatelocal`\par \tab\tab 216 Query show keys from `mpcms3`.`tblupdatelocal`\par \tab\tab 216 Query select * from `mpcms3`.`tblupdatelocal`\par \tab\tab 216 Query SHOW TRIGGERS LIKE 'tblupdatelocal'\par \tab\tab 216 Query set sql_mode=''\par \tab\tab 216 Query show create table `mpcms3`.`tblupdatetemp`\par \tab\tab 216 Query select count(*) from `mpcms3`.`tblupdatetemp`\par \tab\tab 216 Query show keys from `mpcms3`.`tblupdatetemp`\par \tab\tab 216 Query select * from `mpcms3`.`tblupdatetemp`\par 080913 1:08:38\tab 217 Connect root@localhost on mpcms3\par \tab\tab 217 Query SHOW VARIABLES\par \tab\tab 217 Query SHOW COLLATION\par \tab\tab 217 Query SET character_set_results=NULL\par \tab\tab 217 Init DB mpcms3\par \tab\tab 217 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 217 Quit \par \tab\tab 218 Connect root@localhost on mpcms3\par \tab\tab 218 Query SHOW VARIABLES\par \tab\tab 218 Query SHOW COLLATION\par \tab\tab 218 Query SET character_set_results=NULL\par \tab\tab 218 Init DB mpcms3\par \tab\tab 218 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 218 Quit \par 080913 1:09:57\tab 216 Query SHOW TRIGGERS LIKE 'tblupdatetemp'\par \tab\tab 216 Query select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'mpcms3' and `TABLE_TYPE` = 'VIEW'\par 080913 1:09:58\tab 216 Query select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'mpcms3' and ROUTINE_TYPE = 'PROCEDURE'\par \tab\tab 216 Query select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'mpcms3' and ROUTINE_TYPE = 'FUNCTION'\par \tab\tab 216 Quit \par 080913 1:13:47\tab 215 Query select * from tblproduct where productBooked<0\par 080913 1:25:37\tab 215 Quit \par 080913 1:38:39\tab 219 Connect root@localhost on mpcms3\par \tab\tab 219 Query SHOW VARIABLES\par \tab\tab 219 Query SHOW COLLATION\par \tab\tab 219 Query SET character_set_results=NULL\par \tab\tab 219 Init DB mpcms3\par \tab\tab 219 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 219 Quit \par \tab\tab 220 Connect root@localhost on mpcms3\par \tab\tab 220 Query SHOW VARIABLES\par \tab\tab 220 Query SHOW COLLATION\par \tab\tab 220 Query SET character_set_results=NULL\par \tab\tab 220 Init DB mpcms3\par \tab\tab 220 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 220 Quit \par 080913 2:08:40\tab 221 Connect root@localhost on mpcms3\par \tab\tab 221 Query SHOW VARIABLES\par \tab\tab 221 Query SHOW COLLATION\par \tab\tab 221 Query SET character_set_results=NULL\par \tab\tab 221 Init DB mpcms3\par \tab\tab 221 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 221 Quit \par \tab\tab 222 Connect root@localhost on mpcms3\par \tab\tab 222 Query SHOW VARIABLES\par \tab\tab 222 Query SHOW COLLATION\par \tab\tab 222 Query SET character_set_results=NULL\par \tab\tab 222 Init DB mpcms3\par \tab\tab 222 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 222 Quit \par 080913 2:38:40\tab 223 Connect root@localhost on mpcms3\par \tab\tab 223 Query SHOW VARIABLES\par \tab\tab 223 Query SHOW COLLATION\par \tab\tab 223 Query SET character_set_results=NULL\par \tab\tab 223 Init DB mpcms3\par \tab\tab 223 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 223 Quit \par \tab\tab 224 Connect root@localhost on mpcms3\par \tab\tab 224 Query SHOW VARIABLES\par \tab\tab 224 Query SHOW COLLATION\par \tab\tab 224 Query SET character_set_results=NULL\par \tab\tab 224 Init DB mpcms3\par \tab\tab 224 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 224 Quit \par 080913 3:08:41\tab 225 Connect root@localhost on mpcms3\par \tab\tab 225 Query SHOW VARIABLES\par \tab\tab 225 Query SHOW COLLATION\par \tab\tab 225 Query SET character_set_results=NULL\par \tab\tab 225 Init DB mpcms3\par \tab\tab 225 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 225 Quit \par \tab\tab 226 Connect root@localhost on mpcms3\par \tab\tab 226 Query SHOW VARIABLES\par \tab\tab 226 Query SHOW COLLATION\par \tab\tab 226 Query SET character_set_results=NULL\par \tab\tab 226 Init DB mpcms3\par \tab\tab 226 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 226 Quit \par 080913 3:38:44\tab 227 Connect root@localhost on mpcms3\par \tab\tab 227 Query SHOW VARIABLES\par \tab\tab 227 Query SHOW COLLATION\par \tab\tab 227 Query SET character_set_results=NULL\par \tab\tab 227 Init DB mpcms3\par \tab\tab 227 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 227 Quit \par \tab\tab 228 Connect root@localhost on mpcms3\par \tab\tab 228 Query SHOW VARIABLES\par \tab\tab 228 Query SHOW COLLATION\par \tab\tab 228 Query SET character_set_results=NULL\par \tab\tab 228 Init DB mpcms3\par \tab\tab 228 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 228 Quit \par 080913 4:08:44\tab 229 Connect root@localhost on mpcms3\par \tab\tab 229 Query SHOW VARIABLES\par \tab\tab 229 Query SHOW COLLATION\par \tab\tab 229 Query SET character_set_results=NULL\par \tab\tab 229 Init DB mpcms3\par \tab\tab 229 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 229 Quit \par \tab\tab 230 Connect root@localhost on mpcms3\par \tab\tab 230 Query SHOW VARIABLES\par \tab\tab 230 Query SHOW COLLATION\par \tab\tab 230 Query SET character_set_results=NULL\par \tab\tab 230 Init DB mpcms3\par \tab\tab 230 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 230 Quit \par 080913 4:38:47\tab 231 Connect root@localhost on mpcms3\par \tab\tab 231 Query SHOW VARIABLES\par \tab\tab 231 Query SHOW COLLATION\par \tab\tab 231 Query SET character_set_results=NULL\par \tab\tab 231 Init DB mpcms3\par \tab\tab 231 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 231 Quit \par \tab\tab 232 Connect root@localhost on mpcms3\par \tab\tab 232 Query SHOW VARIABLES\par \tab\tab 232 Query SHOW COLLATION\par \tab\tab 232 Query SET character_set_results=NULL\par \tab\tab 232 Init DB mpcms3\par \tab\tab 232 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 232 Quit \par 080913 5:08:47\tab 233 Connect root@localhost on mpcms3\par \tab\tab 233 Query SHOW VARIABLES\par \tab\tab 233 Query SHOW COLLATION\par \tab\tab 233 Query SET character_set_results=NULL\par \tab\tab 233 Init DB mpcms3\par \tab\tab 233 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 233 Quit \par \tab\tab 234 Connect root@localhost on mpcms3\par \tab\tab 234 Query SHOW VARIABLES\par \tab\tab 234 Query SHOW COLLATION\par \tab\tab 234 Query SET character_set_results=NULL\par \tab\tab 234 Init DB mpcms3\par \tab\tab 234 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 234 Quit \par 080913 5:38:48\tab 235 Connect root@localhost on mpcms3\par \tab\tab 235 Query SHOW VARIABLES\par \tab\tab 235 Query SHOW COLLATION\par \tab\tab 235 Query SET character_set_results=NULL\par \tab\tab 235 Init DB mpcms3\par \tab\tab 235 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 235 Quit \par \tab\tab 236 Connect root@localhost on mpcms3\par \tab\tab 236 Query SHOW VARIABLES\par \tab\tab 236 Query SHOW COLLATION\par \tab\tab 236 Query SET character_set_results=NULL\par \tab\tab 236 Init DB mpcms3\par \tab\tab 236 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 236 Quit \par 080913 6:08:49\tab 237 Connect root@localhost on mpcms3\par \tab\tab 237 Query SHOW VARIABLES\par \tab\tab 237 Query SHOW COLLATION\par \tab\tab 237 Query SET character_set_results=NULL\par \tab\tab 237 Init DB mpcms3\par \tab\tab 237 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 237 Quit \par \tab\tab 238 Connect root@localhost on mpcms3\par \tab\tab 238 Query SHOW VARIABLES\par \tab\tab 238 Query SHOW COLLATION\par \tab\tab 238 Query SET character_set_results=NULL\par \tab\tab 238 Init DB mpcms3\par \tab\tab 238 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 238 Quit \par 080913 6:38:50\tab 239 Connect root@localhost on mpcms3\par \tab\tab 239 Query SHOW VARIABLES\par \tab\tab 239 Query SHOW COLLATION\par \tab\tab 239 Query SET character_set_results=NULL\par \tab\tab 239 Init DB mpcms3\par \tab\tab 239 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 239 Quit \par \tab\tab 240 Connect root@localhost on mpcms3\par \tab\tab 240 Query SHOW VARIABLES\par \tab\tab 240 Query SHOW COLLATION\par \tab\tab 240 Query SET character_set_results=NULL\par \tab\tab 240 Init DB mpcms3\par \tab\tab 240 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 240 Quit \par 080913 7:08:50\tab 241 Connect root@localhost on mpcms3\par \tab\tab 241 Query SHOW VARIABLES\par \tab\tab 241 Query SHOW COLLATION\par \tab\tab 241 Query SET character_set_results=NULL\par \tab\tab 241 Init DB mpcms3\par \tab\tab 241 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 241 Quit \par \tab\tab 242 Connect root@localhost on mpcms3\par \tab\tab 242 Query SHOW VARIABLES\par \tab\tab 242 Query SHOW COLLATION\par \tab\tab 242 Query SET character_set_results=NULL\par \tab\tab 242 Init DB mpcms3\par \tab\tab 242 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 242 Quit \par 080913 7:38:52\tab 243 Connect root@localhost on mpcms3\par \tab\tab 243 Query SHOW VARIABLES\par \tab\tab 243 Query SHOW COLLATION\par \tab\tab 243 Query SET character_set_results=NULL\par \tab\tab 243 Init DB mpcms3\par \tab\tab 243 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 243 Quit \par \tab\tab 244 Connect root@localhost on mpcms3\par \tab\tab 244 Query SHOW VARIABLES\par \tab\tab 244 Query SHOW COLLATION\par \tab\tab 244 Query SET character_set_results=NULL\par \tab\tab 244 Init DB mpcms3\par \tab\tab 244 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 244 Quit \par 080913 8:08:54\tab 245 Connect root@localhost on mpcms3\par \tab\tab 245 Query SHOW VARIABLES\par \tab\tab 245 Query SHOW COLLATION\par \tab\tab 245 Query SET character_set_results=NULL\par \tab\tab 245 Init DB mpcms3\par \tab\tab 245 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 245 Quit \par \tab\tab 246 Connect root@localhost on mpcms3\par \tab\tab 246 Query SHOW VARIABLES\par \tab\tab 246 Query SHOW COLLATION\par \tab\tab 246 Query SET character_set_results=NULL\par \tab\tab 246 Init DB mpcms3\par \tab\tab 246 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 246 Quit \par 080913 8:39:00\tab 247 Connect root@localhost on mpcms3\par \tab\tab 247 Query SHOW VARIABLES\par \tab\tab 247 Query SHOW COLLATION\par \tab\tab 247 Query SET character_set_results=NULL\par \tab\tab 247 Init DB mpcms3\par \tab\tab 247 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 247 Quit \par \tab\tab 248 Connect root@localhost on mpcms3\par \tab\tab 248 Query SHOW VARIABLES\par \tab\tab 248 Query SHOW COLLATION\par \tab\tab 248 Query SET character_set_results=NULL\par \tab\tab 248 Init DB mpcms3\par \tab\tab 248 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 248 Quit \par 080913 9:09:01\tab 249 Connect root@localhost on mpcms3\par \tab\tab 249 Query SHOW VARIABLES\par \tab\tab 249 Query SHOW COLLATION\par \tab\tab 249 Query SET character_set_results=NULL\par \tab\tab 249 Init DB mpcms3\par \tab\tab 249 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 249 Quit \par \tab\tab 250 Connect root@localhost on mpcms3\par \tab\tab 250 Query SHOW VARIABLES\par \tab\tab 250 Query SHOW COLLATION\par \tab\tab 250 Query SET character_set_results=NULL\par \tab\tab 250 Init DB mpcms3\par \tab\tab 250 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 250 Quit \par 080913 9:39:03\tab 251 Connect root@localhost on mpcms3\par \tab\tab 251 Query SHOW VARIABLES\par \tab\tab 251 Query SHOW COLLATION\par \tab\tab 251 Query SET character_set_results=NULL\par \tab\tab 251 Init DB mpcms3\par \tab\tab 251 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 251 Quit \par \tab\tab 252 Connect root@localhost on mpcms3\par \tab\tab 252 Query SHOW VARIABLES\par \tab\tab 252 Query SHOW COLLATION\par \tab\tab 252 Query SET character_set_results=NULL\par \tab\tab 252 Init DB mpcms3\par \tab\tab 252 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 252 Quit \par 080913 10:09:06\tab 253 Connect root@localhost on mpcms3\par \tab\tab 253 Query SHOW VARIABLES\par \tab\tab 253 Query SHOW COLLATION\par \tab\tab 253 Query SET character_set_results=NULL\par \tab\tab 253 Init DB mpcms3\par \tab\tab 253 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 253 Quit \par \tab\tab 254 Connect root@localhost on mpcms3\par \tab\tab 254 Query SHOW VARIABLES\par \tab\tab 254 Query SHOW COLLATION\par \tab\tab 254 Query SET character_set_results=NULL\par \tab\tab 254 Init DB mpcms3\par \tab\tab 254 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 254 Quit \par 080913 10:39:07\tab 255 Connect root@localhost on mpcms3\par \tab\tab 255 Query SHOW VARIABLES\par \tab\tab 255 Query SHOW COLLATION\par \tab\tab 255 Query SET character_set_results=NULL\par \tab\tab 255 Init DB mpcms3\par \tab\tab 255 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 255 Quit \par \tab\tab 256 Connect root@localhost on mpcms3\par \tab\tab 256 Query SHOW VARIABLES\par \tab\tab 256 Query SHOW COLLATION\par \tab\tab 256 Query SET character_set_results=NULL\par \tab\tab 256 Init DB mpcms3\par \tab\tab 256 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 256 Quit \par 080913 11:09:12\tab 257 Connect root@localhost on mpcms3\par \tab\tab 257 Query SHOW VARIABLES\par \tab\tab 257 Query SHOW COLLATION\par \tab\tab 257 Query SET character_set_results=NULL\par \tab\tab 257 Init DB mpcms3\par \tab\tab 257 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 257 Query BEGIN\par 080913 11:09:15\tab 257 Query Update tblProductBrand Set productBrandCode='7210c',productBrandDescription='7210c'Where productBrandID = '71'\par \tab\tab 257 Query Insert into tblProduct Set productID =1988,productCategoryID='1',productSubCategoryID='24',productBrandID='71',productGroupID='9',productStatusID='1',productCode='HP-NK-7210c-BLU-O',productName='NOKIA 7210c BLUE',productType='Imei',rrpMarkUpType='Amount',rrpMarkUpAmount=100,rrpMarkUpFixed=0,rrpMarkUpPercentage=0\par \tab\tab 257 Query Insert into tblProduct Set productID =1989,productCategoryID='1',productSubCategoryID='24',productBrandID='71',productGroupID='21',productStatusID='2',productCode='HP-NK-7210c-STD-SH',productName='NOKIA 7210c USED',productType='Imei',rrpMarkUpType='Amount',rrpMarkUpAmount=100,rrpMarkUpFixed=0,rrpMarkUpPercentage=0\par \tab\tab 257 Query COMMIT\par \tab\tab 257 Quit \par \tab\tab 258 Connect root@localhost on mpcms3\par \tab\tab 258 Query SHOW VARIABLES\par \tab\tab 258 Query SHOW COLLATION\par \tab\tab 258 Query SET character_set_results=NULL\par \tab\tab 258 Init DB mpcms3\par \tab\tab 258 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 258 Quit \par \tab\tab 259 Connect root@localhost on mpcms3\par \tab\tab 259 Query SHOW VARIABLES\par \tab\tab 259 Query SHOW COLLATION\par \tab\tab 259 Query SET character_set_results=NULL\par \tab\tab 259 Init DB mpcms3\par \tab\tab 259 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 259 Quit \par 080913 11:19:47\tab 260 Connect root@localhost on mpcms3\par \tab\tab 260 Query SHOW VARIABLES\par \tab\tab 260 Query SHOW COLLATION\par \tab\tab 260 Query SET character_set_results=NULL\par \tab\tab 260 Init DB mpcms3\par \tab\tab 260 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='5026'\par \tab\tab 260 Quit \par 080913 11:19:57\tab 261 Connect root@localhost on mpcms3\par \tab\tab 261 Query SHOW VARIABLES\par \tab\tab 261 Query SHOW COLLATION\par \tab\tab 261 Query SET character_set_results=NULL\par \tab\tab 261 Init DB mpcms3\par \tab\tab 261 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080956'\par \tab\tab 262 Connect root@localhost on mpcms3\par \tab\tab 262 Query SHOW VARIABLES\par \tab\tab 262 Query SHOW COLLATION\par \tab\tab 262 Query SET character_set_results=NULL\par \tab\tab 262 Init DB mpcms3\par \tab\tab 262 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 262 Query BEGIN\par \tab\tab 262 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080956' And tblStock.stockID=9560\par \tab\tab 262 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9560', stockSIQ ='0002172800080956', employeeID = '16', tempReceiptTimeStamp='2008:09:13 11:19:57'\par \tab\tab 262 Query COMMIT\par \tab\tab 262 Quit \par \tab\tab 261 Quit \par 080913 11:20:15\tab 263 Connect root@localhost on mpcms3\par \tab\tab 263 Query SHOW VARIABLES\par \tab\tab 263 Query SHOW COLLATION\par \tab\tab 263 Query SET character_set_results=NULL\par \tab\tab 263 Init DB mpcms3\par \tab\tab 263 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080957'\par \tab\tab 264 Connect root@localhost on mpcms3\par \tab\tab 264 Query SHOW VARIABLES\par \tab\tab 264 Query SHOW COLLATION\par \tab\tab 264 Query SET character_set_results=NULL\par \tab\tab 264 Init DB mpcms3\par \tab\tab 264 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 264 Query BEGIN\par \tab\tab 264 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080957' And tblStock.stockID=9561\par \tab\tab 264 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9561', stockSIQ ='0002172800080957', employeeID = '16', tempReceiptTimeStamp='2008:09:13 11:20:15'\par \tab\tab 264 Query COMMIT\par \tab\tab 264 Quit \par \tab\tab 263 Quit \par 080913 11:20:21\tab 265 Connect root@localhost on mpcms3\par \tab\tab 265 Query SHOW VARIABLES\par \tab\tab 265 Query SHOW COLLATION\par \tab\tab 265 Query SET character_set_results=NULL\par \tab\tab 265 Init DB mpcms3\par \tab\tab 265 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080958'\par \tab\tab 266 Connect root@localhost on mpcms3\par \tab\tab 266 Query SHOW VARIABLES\par \tab\tab 266 Query SHOW COLLATION\par \tab\tab 266 Query SET character_set_results=NULL\par \tab\tab 266 Init DB mpcms3\par \tab\tab 266 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 266 Query BEGIN\par \tab\tab 266 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080958' And tblStock.stockID=9562\par \tab\tab 266 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9562', stockSIQ ='0002172800080958', employeeID = '16', tempReceiptTimeStamp='2008:09:13 11:20:21'\par \tab\tab 266 Query COMMIT\par \tab\tab 266 Quit \par \tab\tab 265 Quit \par 080913 11:20:28\tab 267 Connect root@localhost on mpcms3\par \tab\tab 267 Query SHOW VARIABLES\par \tab\tab 267 Query SHOW COLLATION\par \tab\tab 267 Query SET character_set_results=NULL\par \tab\tab 267 Init DB mpcms3\par \tab\tab 267 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080959'\par \tab\tab 268 Connect root@localhost on mpcms3\par \tab\tab 268 Query SHOW VARIABLES\par \tab\tab 268 Query SHOW COLLATION\par \tab\tab 268 Query SET character_set_results=NULL\par \tab\tab 268 Init DB mpcms3\par \tab\tab 268 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 268 Query BEGIN\par \tab\tab 268 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080959' And tblStock.stockID=9563\par \tab\tab 268 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9563', stockSIQ ='0002172800080959', employeeID = '16', tempReceiptTimeStamp='2008:09:13 11:20:28'\par \tab\tab 268 Query COMMIT\par \tab\tab 268 Quit \par \tab\tab 267 Quit \par 080913 11:38:04\tab 269 Connect root@localhost on mpcms3\par \tab\tab 269 Query SHOW VARIABLES\par \tab\tab 269 Query SHOW COLLATION\par \tab\tab 269 Query SET character_set_results=NULL\par \tab\tab 269 Init DB mpcms3\par \tab\tab 269 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 269 Query BEGIN\par \tab\tab 270 Connect root@localhost on mpcms3\par \tab\tab 270 Query SHOW VARIABLES\par \tab\tab 270 Query SHOW COLLATION\par \tab\tab 270 Query SET character_set_results=NULL\par \tab\tab 270 Init DB mpcms3\par \tab\tab 270 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 11:38:32\tab 270 Quit \par \tab\tab 271 Connect root@localhost on mpcms3\par \tab\tab 271 Query SHOW VARIABLES\par \tab\tab 271 Query SHOW COLLATION\par \tab\tab 271 Query SET character_set_results=NULL\par \tab\tab 271 Init DB mpcms3\par \tab\tab 271 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 11:39:03\tab 271 Quit \par \tab\tab 272 Connect root@localhost on mpcms3\par \tab\tab 272 Query SHOW VARIABLES\par \tab\tab 272 Query SHOW COLLATION\par \tab\tab 272 Query SET character_set_results=NULL\par \tab\tab 272 Init DB mpcms3\par \tab\tab 272 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 272 Quit \par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par 080913 11:39:04\tab 269 Query Insert into tblReceipt Set receiptID=2264, outletID=3, employeeID=16, customerName='Cash', customerPhone='', totalCostAmount=38.92, totalSellingAmount=40, totalProfitAmount=1.08, changeAmount=0, profit='y', receiptDate = '2008:09:13', receiptTime = '11:39:04'\par 080913 11:39:06\tab 269 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 11:39:08\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:13\tab 269 Query Insert into tblReceiptDetails Set receiptID=2264, receiptDetailsID = 8883, outletID = 3,stockID = 9560, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080956', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 11:39:19\tab 269 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 11:39:20\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:22\tab 269 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 11:39:23\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:24\tab 269 Query Insert into tblReceiptDetails Set receiptID=2264, receiptDetailsID = 8884, outletID = 3,stockID = 9561, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080957', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 11:39:27\tab 269 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 11:39:28\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:31\tab 273 Connect root@localhost on mpcms3\par \tab\tab 273 Query SHOW VARIABLES\par \tab\tab 273 Query SHOW COLLATION\par \tab\tab 273 Query SET character_set_results=NULL\par \tab\tab 273 Init DB mpcms3\par \tab\tab 273 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 273 Quit \par \tab\tab 274 Connect root@localhost on mpcms3\par \tab\tab 274 Query SHOW VARIABLES\par \tab\tab 274 Query SHOW COLLATION\par \tab\tab 274 Query SET character_set_results=NULL\par \tab\tab 274 Init DB mpcms3\par \tab\tab 274 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 274 Quit \par 080913 11:39:33\tab 269 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 11:39:34\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:36\tab 269 Query Insert into tblReceiptDetails Set receiptID=2264, receiptDetailsID = 8885, outletID = 3,stockID = 9562, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080958', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 11:39:42\tab 269 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 11:39:43\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:45\tab 269 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 11:39:46\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:50\tab 269 Query Insert into tblReceiptDetails Set receiptID=2264, receiptDetailsID = 8886, outletID = 3,stockID = 9563, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080959', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 11:39:53\tab 269 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 11:39:54\tab 269 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 11:39:59\tab 269 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 269 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par 080913 11:40:00\tab 269 Query Insert into tblPaymentDetails Set paymentDetailsID=2321, outletID = 3,receiptID = 2264, paymentTypeID= 1, amount = 40\par 080913 11:40:01\tab 269 Query Delete From tblTempReceipt\par \tab\tab 269 Query COMMIT\par 080913 11:40:03\tab 269 Quit \par \tab\tab 275 Connect root@localhost on mpcms3\par \tab\tab 275 Query SHOW VARIABLES\par \tab\tab 275 Query SHOW COLLATION\par \tab\tab 275 Query SET character_set_results=NULL\par \tab\tab 275 Init DB mpcms3\par \tab\tab 275 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2264\par \tab\tab 275 Quit \par \tab\tab 276 Connect root@localhost on mpcms3\par \tab\tab 276 Query SHOW VARIABLES\par \tab\tab 276 Query SHOW COLLATION\par \tab\tab 276 Query SET character_set_results=NULL\par \tab\tab 276 Init DB mpcms3\par \tab\tab 276 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2264\par \tab\tab 276 Quit \par \tab\tab 277 Connect root@localhost on mpcms3\par \tab\tab 277 Query SHOW VARIABLES\par \tab\tab 277 Query SHOW COLLATION\par \tab\tab 277 Query SET character_set_results=NULL\par \tab\tab 277 Init DB mpcms3\par \tab\tab 277 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2264\par \tab\tab 277 Quit \par 080913 11:41:04\tab 278 Connect root@localhost on mpcms3\par \tab\tab 278 Query SHOW VARIABLES\par \tab\tab 278 Query SHOW COLLATION\par \tab\tab 278 Query SET character_set_results=NULL\par \tab\tab 278 Init DB mpcms3\par \tab\tab 278 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='23298'\par \tab\tab 278 Quit \par 080913 11:41:25\tab 279 Connect root@localhost on mpcms3\par \tab\tab 279 Query SHOW VARIABLES\par \tab\tab 279 Query SHOW COLLATION\par \tab\tab 279 Query SET character_set_results=NULL\par \tab\tab 279 Init DB mpcms3\par \tab\tab 279 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='356388020726641'\par \tab\tab 280 Connect root@localhost on mpcms3\par \tab\tab 280 Query SHOW VARIABLES\par \tab\tab 280 Query SHOW COLLATION\par \tab\tab 280 Query SET character_set_results=NULL\par \tab\tab 280 Init DB mpcms3\par \tab\tab 280 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 280 Query BEGIN\par \tab\tab 280 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='356388020726641' And tblStock.stockID=9003\par \tab\tab 280 Query Insert into tblTempReceipt Set productType='Imei', productID=1946, stockID ='9003', stockSIQ ='356388020726641', employeeID = '4', tempReceiptTimeStamp='2008:09:13 11:41:25'\par \tab\tab 280 Query COMMIT\par \tab\tab 280 Quit \par \tab\tab 279 Quit \par 080913 11:41:44\tab 281 Connect root@localhost on mpcms3\par \tab\tab 281 Query SHOW VARIABLES\par \tab\tab 281 Query SHOW COLLATION\par \tab\tab 281 Query SET character_set_results=NULL\par \tab\tab 281 Init DB mpcms3\par \tab\tab 281 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 281 Query BEGIN\par \tab\tab 282 Connect root@localhost on mpcms3\par \tab\tab 282 Query SHOW VARIABLES\par \tab\tab 282 Query SHOW COLLATION\par \tab\tab 282 Query SET character_set_results=NULL\par \tab\tab 282 Init DB mpcms3\par \tab\tab 282 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 11:42:13\tab 282 Quit \par \tab\tab 283 Connect root@localhost on mpcms3\par \tab\tab 283 Query SHOW VARIABLES\par \tab\tab 283 Query SHOW COLLATION\par \tab\tab 283 Query SET character_set_results=NULL\par \tab\tab 283 Init DB mpcms3\par \tab\tab 283 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 11:42:43\tab 283 Quit \par \tab\tab 284 Connect root@localhost on mpcms3\par \tab\tab 284 Query SHOW VARIABLES\par \tab\tab 284 Query SHOW COLLATION\par \tab\tab 284 Query SET character_set_results=NULL\par \tab\tab 284 Init DB mpcms3\par \tab\tab 284 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 284 Quit \par \tab\tab 281 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par 080913 11:42:44\tab 281 Query Insert into tblReceipt Set receiptID=2265, outletID=3, employeeID=4, customerName='Cash', customerPhone='', totalCostAmount=927, totalSellingAmount=980, totalProfitAmount=53, changeAmount=0, profit='y', receiptDate = '2008:09:13', receiptTime = '11:42:44'\par 080913 11:42:46\tab 281 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 281 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 11:42:47\tab 281 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=1946\par 080913 11:42:49\tab 281 Query Insert into tblReceiptDetails Set receiptID=2265, receiptDetailsID = 8887, outletID = 3,stockID = 9003, productID= 1946, productType = 'Imei', productQuantity = 1 , productSIQ = '356388020726641', costPrice = 927, sellingPrice = 980, profitAmount = 53, profit = 'y'\par 080913 11:42:55\tab 281 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -927 Where tblProduct.productID=1946\par 080913 11:42:56\tab 281 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=1946\par 080913 11:43:04\tab 281 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 281 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par 080913 11:43:05\tab 281 Query Insert into tblPaymentDetails Set paymentDetailsID=2322, outletID = 3,receiptID = 2265, paymentTypeID= 1, amount = 980\par 080913 11:43:08\tab 281 Query Delete From tblTempReceipt\par \tab\tab 281 Query COMMIT\par 080913 11:43:11\tab 281 Quit \par \tab\tab 285 Connect root@localhost on mpcms3\par \tab\tab 285 Query SHOW VARIABLES\par \tab\tab 285 Query SHOW COLLATION\par \tab\tab 285 Query SET character_set_results=NULL\par \tab\tab 285 Init DB mpcms3\par \tab\tab 285 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2265\par \tab\tab 285 Quit \par \tab\tab 286 Connect root@localhost on mpcms3\par \tab\tab 286 Query SHOW VARIABLES\par \tab\tab 286 Query SHOW COLLATION\par \tab\tab 286 Query SET character_set_results=NULL\par \tab\tab 286 Init DB mpcms3\par \tab\tab 286 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2265\par \tab\tab 286 Quit \par \tab\tab 287 Connect root@localhost on mpcms3\par \tab\tab 287 Query SHOW VARIABLES\par \tab\tab 287 Query SHOW COLLATION\par \tab\tab 287 Query SET character_set_results=NULL\par \tab\tab 287 Init DB mpcms3\par \tab\tab 287 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2265\par \tab\tab 287 Quit \par 080913 12:09:42\tab 288 Connect root@localhost on mpcms3\par \tab\tab 288 Query SHOW VARIABLES\par \tab\tab 288 Query SHOW COLLATION\par \tab\tab 288 Query SET character_set_results=NULL\par \tab\tab 288 Init DB mpcms3\par \tab\tab 288 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 288 Quit \par \tab\tab 289 Connect root@localhost on mpcms3\par \tab\tab 289 Query SHOW VARIABLES\par \tab\tab 289 Query SHOW COLLATION\par \tab\tab 289 Query SET character_set_results=NULL\par \tab\tab 289 Init DB mpcms3\par \tab\tab 289 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 289 Quit \par 080913 12:11:49\tab 290 Connect root@localhost on mpcms3\par \tab\tab 290 Query SHOW VARIABLES\par \tab\tab 290 Query SHOW COLLATION\par \tab\tab 290 Query SET character_set_results=NULL\par \tab\tab 290 Init DB mpcms3\par \tab\tab 290 Query Select outletCode,outletID From tblOutlet Where tblOutlet.outletStatus='y' and tblOutlet.outletID!=3 Order By tblOutlet.outletID\par \tab\tab 290 Quit \par 080913 12:38:07\tab 291 Connect root@localhost on mpcms3\par \tab\tab 291 Query SHOW VARIABLES\par \tab\tab 291 Query SHOW COLLATION\par \tab\tab 291 Query SET character_set_results=NULL\par \tab\tab 291 Init DB mpcms3\par \tab\tab 291 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='46496'\par 080913 12:38:08\tab 291 Quit \par 080913 12:38:13\tab 292 Connect root@localhost on mpcms3\par \tab\tab 292 Query SHOW VARIABLES\par \tab\tab 292 Query SHOW COLLATION\par \tab\tab 292 Query SET character_set_results=NULL\par \tab\tab 292 Init DB mpcms3\par \tab\tab 292 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='4646'\par \tab\tab 292 Quit \par 080913 12:38:21\tab 293 Connect root@localhost on mpcms3\par \tab\tab 293 Query SHOW VARIABLES\par \tab\tab 293 Query SHOW COLLATION\par \tab\tab 293 Query SET character_set_results=NULL\par \tab\tab 293 Init DB mpcms3\par \tab\tab 293 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='353263011467740'\par \tab\tab 294 Connect root@localhost on mpcms3\par \tab\tab 294 Query SHOW VARIABLES\par \tab\tab 294 Query SHOW COLLATION\par \tab\tab 294 Query SET character_set_results=NULL\par \tab\tab 294 Init DB mpcms3\par \tab\tab 294 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 294 Query BEGIN\par \tab\tab 294 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='353263011467740' And tblStock.stockID=9385\par \tab\tab 294 Query Insert into tblTempReceipt Set productType='Imei', productID=507, stockID ='9385', stockSIQ ='353263011467740', employeeID = '13', tempReceiptTimeStamp='2008:09:13 12:38:21'\par \tab\tab 294 Query COMMIT\par \tab\tab 294 Quit \par \tab\tab 293 Quit \par 080913 12:38:33\tab 295 Connect root@localhost on mpcms3\par \tab\tab 295 Query SHOW VARIABLES\par \tab\tab 295 Query SHOW COLLATION\par \tab\tab 295 Query SET character_set_results=NULL\par \tab\tab 295 Init DB mpcms3\par \tab\tab 295 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID\par \tab\tab 295 Quit \par 080913 12:38:42\tab 296 Connect root@localhost on mpcms3\par \tab\tab 296 Query SHOW VARIABLES\par \tab\tab 296 Query SHOW COLLATION\par \tab\tab 296 Query SET character_set_results=NULL\par \tab\tab 296 Init DB mpcms3\par \tab\tab 296 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage From tblProduct Where productID=970\par \tab\tab 297 Connect root@localhost on mpcms3\par \tab\tab 297 Query SHOW VARIABLES\par \tab\tab 297 Query SHOW COLLATION\par \tab\tab 297 Query SET character_set_results=NULL\par \tab\tab 297 Init DB mpcms3\par \tab\tab 297 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 297 Query BEGIN\par \tab\tab 297 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked + 1 Where tblProduct.productID=970\par \tab\tab 297 Query Insert into tblTempReceipt Set productType='Accessory', productID=970, stockID ='6', stockSIQ ='1', employeeID = '13', tempReceiptTimeStamp='2008:09:13 12:38:42'\par \tab\tab 297 Query COMMIT\par \tab\tab 297 Quit \par \tab\tab 296 Quit \par 080913 12:38:47\tab 298 Connect root@localhost on mpcms3\par \tab\tab 298 Query SHOW VARIABLES\par \tab\tab 298 Query SHOW COLLATION\par \tab\tab 298 Query SET character_set_results=NULL\par \tab\tab 298 Init DB mpcms3\par \tab\tab 298 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 298 Query BEGIN\par \tab\tab 299 Connect root@localhost on mpcms3\par \tab\tab 299 Query SHOW VARIABLES\par \tab\tab 299 Query SHOW COLLATION\par \tab\tab 299 Query SET character_set_results=NULL\par \tab\tab 299 Init DB mpcms3\par \tab\tab 299 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 12:39:02\tab 299 Quit \par \tab\tab 300 Connect root@localhost on mpcms3\par \tab\tab 300 Query SHOW VARIABLES\par \tab\tab 300 Query SHOW COLLATION\par \tab\tab 300 Query SET character_set_results=NULL\par \tab\tab 300 Init DB mpcms3\par \tab\tab 300 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 12:39:45\tab 300 Quit \par \tab\tab 301 Connect root@localhost on mpcms3\par \tab\tab 301 Query SHOW VARIABLES\par \tab\tab 301 Query SHOW COLLATION\par \tab\tab 301 Query SET character_set_results=NULL\par \tab\tab 301 Init DB mpcms3\par \tab\tab 301 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 301 Quit \par \tab\tab 298 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par 080913 12:39:49\tab 298 Query Insert into tblReceipt Set receiptID=2266, outletID=3, employeeID=13, customerName='Cash', customerPhone='', totalCostAmount=407.36, totalSellingAmount=850, totalProfitAmount=442.64, changeAmount=0, profit='y', receiptDate = '2008:09:13', receiptTime = '12:39:49'\par 080913 12:39:52\tab 298 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 298 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 12:39:53\tab 298 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=507\par 080913 12:39:54\tab 298 Query Insert into tblReceiptDetails Set receiptID=2266, receiptDetailsID = 8888, outletID = 3,stockID = 9385, productID= 507, productType = 'Imei', productQuantity = 1 , productSIQ = '353263011467740', costPrice = 402, sellingPrice = 850, profitAmount = 448, profit = 'y'\par 080913 12:40:09\tab 298 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -402 Where tblProduct.productID=507\par 080913 12:40:10\tab 298 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=507\par 080913 12:40:11\tab 298 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 298 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 12:40:12\tab 298 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked From tblProduct Where tblProduct.productID=970\par \tab\tab 298 Query Select tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=970 Order By tblStock.stockID\par \tab\tab 298 Query Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +1, tblStock.stockBalance = tblStock.stockBalance -1 Where tblStock.stockID=6174\par 080913 12:40:13\tab 298 Query Insert into tblReceiptDetails Set receiptID=2266, receiptDetailsID = 8889, outletID = 3,stockID = 6174, productID= 970, productType = 'Accessory', productQuantity = 1, productSIQ = '1', costPrice = 5.36, sellingPrice = 0, profitAmount = -5.36, profit = 'n', stockStatus ='g'\par \tab\tab 302 Connect root@localhost on mpcms3\par \tab\tab 302 Query SHOW VARIABLES\par \tab\tab 302 Query SHOW COLLATION\par \tab\tab 302 Query SET character_set_results=NULL\par \tab\tab 302 Init DB mpcms3\par \tab\tab 302 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 302 Quit \par \tab\tab 303 Connect root@localhost on mpcms3\par \tab\tab 303 Query SHOW VARIABLES\par \tab\tab 303 Query SHOW COLLATION\par \tab\tab 303 Query SET character_set_results=NULL\par \tab\tab 303 Init DB mpcms3\par \tab\tab 303 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 303 Quit \par 080913 12:40:19\tab 298 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productBooked = tblProduct.productBooked -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -5.36 Where tblProduct.productID=970\par \tab\tab 298 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked From tblProduct Where tblProduct.productID=970\par 080913 12:40:21\tab 298 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 298 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par 080913 12:40:23\tab 298 Query Insert into tblPaymentDetails Set paymentDetailsID=2323, outletID = 3,receiptID = 2266, paymentTypeID= 1, amount = 850\par 080913 12:40:29\tab 298 Query Delete From tblTempReceipt\par \tab\tab 298 Query COMMIT\par 080913 12:40:31\tab 298 Quit \par \tab\tab 304 Connect root@localhost on mpcms3\par \tab\tab 304 Query SHOW VARIABLES\par \tab\tab 304 Query SHOW COLLATION\par \tab\tab 304 Query SET character_set_results=NULL\par \tab\tab 304 Init DB mpcms3\par \tab\tab 304 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2266\par \tab\tab 304 Quit \par \tab\tab 305 Connect root@localhost on mpcms3\par \tab\tab 305 Query SHOW VARIABLES\par \tab\tab 305 Query SHOW COLLATION\par \tab\tab 305 Query SET character_set_results=NULL\par \tab\tab 305 Init DB mpcms3\par \tab\tab 305 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2266\par \tab\tab 305 Quit \par \tab\tab 306 Connect root@localhost on mpcms3\par \tab\tab 306 Query SHOW VARIABLES\par \tab\tab 306 Query SHOW COLLATION\par \tab\tab 306 Query SET character_set_results=NULL\par \tab\tab 306 Init DB mpcms3\par \tab\tab 306 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2266\par \tab\tab 306 Quit \par 080913 12:41:05\tab 307 Connect root@localhost on mpcms3\par \tab\tab 307 Query SHOW VARIABLES\par \tab\tab 307 Query SHOW COLLATION\par \tab\tab 307 Query SET character_set_results=NULL\par \tab\tab 307 Init DB mpcms3\par \tab\tab 307 Query Select tblReceipt.receiptID, tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productSIQ, tblReceiptDetails.costPrice, tblReceiptDetails.sellingPrice, tblReceiptDetails.profitAmount, tblEmployee.employeeUserName From tblReceipt Inner Join tblReceiptDetails On tblReceipt.receiptID = tblReceiptDetails.receiptID Inner Join tblEmployee On tblReceipt.employeeID = tblEmployee.employeeID Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceipt.receiptDate Between '2008-09-13' And '2008-09-13'\par \tab\tab 307 Quit \par 080913 12:57:40\tab 308 Connect root@localhost on mpcms3\par \tab\tab 308 Query SHOW VARIABLES\par \tab\tab 308 Query SHOW COLLATION\par \tab\tab 308 Query SET character_set_results=NULL\par \tab\tab 308 Init DB mpcms3\par \tab\tab 308 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='0888'\par \tab\tab 308 Quit \par 080913 12:58:00\tab 309 Connect root@localhost on mpcms3\par \tab\tab 309 Query SHOW VARIABLES\par \tab\tab 309 Query SHOW COLLATION\par \tab\tab 309 Query SET character_set_results=NULL\par \tab\tab 309 Init DB mpcms3\par \tab\tab 309 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002098200051109'\par \tab\tab 310 Connect root@localhost on mpcms3\par \tab\tab 310 Query SHOW VARIABLES\par \tab\tab 310 Query SHOW COLLATION\par \tab\tab 310 Query SET character_set_results=NULL\par \tab\tab 310 Init DB mpcms3\par \tab\tab 310 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 310 Query BEGIN\par \tab\tab 310 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002098200051109' And tblStock.stockID=8894\par \tab\tab 310 Query Insert into tblTempReceipt Set productType='Coupon', productID=304, stockID ='8894', stockSIQ ='0002098200051109', employeeID = '19', tempReceiptTimeStamp='2008:09:13 12:58:00'\par \tab\tab 310 Query COMMIT\par \tab\tab 310 Quit \par \tab\tab 309 Quit \par 080913 12:58:04\tab 311 Connect root@localhost on mpcms3\par \tab\tab 311 Query SHOW VARIABLES\par \tab\tab 311 Query SHOW COLLATION\par \tab\tab 311 Query SET character_set_results=NULL\par \tab\tab 311 Init DB mpcms3\par \tab\tab 311 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='1234'\par \tab\tab 311 Quit \par 080913 12:59:45\tab 312 Connect root@localhost on mpcms3\par \tab\tab 312 Query SHOW VARIABLES\par \tab\tab 312 Query SHOW COLLATION\par \tab\tab 312 Query SET character_set_results=NULL\par \tab\tab 312 Init DB mpcms3\par \tab\tab 312 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='1234'\par \tab\tab 312 Quit \par \tab\tab 313 Connect root@localhost on mpcms3\par \tab\tab 313 Query SHOW VARIABLES\par \tab\tab 313 Query SHOW COLLATION\par \tab\tab 313 Query SET character_set_results=NULL\par \tab\tab 313 Init DB mpcms3\par \tab\tab 313 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 313 Query BEGIN\par \tab\tab 314 Connect root@localhost on mpcms3\par \tab\tab 314 Query SHOW VARIABLES\par \tab\tab 314 Query SHOW COLLATION\par \tab\tab 314 Query SET character_set_results=NULL\par \tab\tab 314 Init DB mpcms3\par \tab\tab 314 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 12:59:57\tab 314 Quit \par \tab\tab 315 Connect root@localhost on mpcms3\par \tab\tab 315 Query SHOW VARIABLES\par \tab\tab 315 Query SHOW COLLATION\par \tab\tab 315 Query SET character_set_results=NULL\par \tab\tab 315 Init DB mpcms3\par \tab\tab 315 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 13:00:16\tab 315 Quit \par \tab\tab 316 Connect root@localhost on mpcms3\par \tab\tab 316 Query SHOW VARIABLES\par \tab\tab 316 Query SHOW COLLATION\par \tab\tab 316 Query SET character_set_results=NULL\par \tab\tab 316 Init DB mpcms3\par \tab\tab 316 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 316 Quit \par \tab\tab 313 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par 080913 13:00:21\tab 313 Query Insert into tblReceipt Set receiptID=2267, outletID=3, employeeID=19, customerName='Cash', customerPhone='', totalCostAmount=30.51, totalSellingAmount=30, totalProfitAmount=-0.510000000000002, changeAmount=0, profit='n', receiptDate = '2008:09:13', receiptTime = '13:00:21'\par 080913 13:00:24\tab 313 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 313 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 13:00:56\tab 313 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=304\par 080913 13:00:57\tab 313 Query Insert into tblReceiptDetails Set receiptID=2267, receiptDetailsID = 8890, outletID = 3,stockID = 8894, productID= 304, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002098200051109', costPrice = 30.51, sellingPrice = 30, profitAmount = -0.510000000000002, profit = 'n'\par 080913 13:01:04\tab 313 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -30.51 Where tblProduct.productID=304\par 080913 13:01:06\tab 313 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=304\par 080913 13:01:07\tab 313 Query Select tblID.lastValue From tblID Where tblID.tableName='tblProductBelowCost'\par \tab\tab 313 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblProductBelowCost'\par 080913 13:01:08\tab 313 Query Insert into tblProductBelowCost Set productBelowCostID=695, receiptID = 2267, receiptDetailsID = 8890, outletID = 3,employeeID= 15, productBelowCostReason = 'L\par '\par 080913 13:01:10\tab 313 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 313 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par 080913 13:01:11\tab 313 Query Insert into tblPaymentDetails Set paymentDetailsID=2324, outletID = 3,receiptID = 2267, paymentTypeID= 1, amount = 30\par 080913 13:01:12\tab 313 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptBelowCost'\par \tab\tab 313 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptBelowCost'\par 080913 13:01:13\tab 313 Query Insert into tblReceiptBelowCost Set receiptBelowCostID=189, receiptID = 2267, outletID = 3,employeeID= 15, receiptBelowCostReason = 'K\par '\par 080913 13:01:14\tab 313 Query Delete From tblTempReceipt\par \tab\tab 313 Query COMMIT\par 080913 13:01:19\tab 313 Quit \par \tab\tab 317 Connect root@localhost on mpcms3\par \tab\tab 317 Query SHOW VARIABLES\par \tab\tab 317 Query SHOW COLLATION\par \tab\tab 317 Query SET character_set_results=NULL\par \tab\tab 317 Init DB mpcms3\par \tab\tab 317 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2267\par \tab\tab 317 Quit \par \tab\tab 318 Connect root@localhost on mpcms3\par \tab\tab 318 Query SHOW VARIABLES\par \tab\tab 318 Query SHOW COLLATION\par \tab\tab 318 Query SET character_set_results=NULL\par \tab\tab 318 Init DB mpcms3\par \tab\tab 318 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2267\par \tab\tab 318 Quit \par \tab\tab 319 Connect root@localhost on mpcms3\par \tab\tab 319 Query SHOW VARIABLES\par \tab\tab 319 Query SHOW COLLATION\par \tab\tab 319 Query SET character_set_results=NULL\par \tab\tab 319 Init DB mpcms3\par \tab\tab 319 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2267\par \tab\tab 319 Quit \par 080913 13:05:15\tab 320 Connect root@localhost on mpcms3\par \tab\tab 320 Query SHOW VARIABLES\par \tab\tab 320 Query SHOW COLLATION\par \tab\tab 320 Query SET character_set_results=NULL\par \tab\tab 320 Init DB mpcms3\par \tab\tab 320 Query Select productCode, Cast(Concat(productID,'#',productName,'#',productType) As Char) as productNameID From tblProduct Where productStatus='y' And (productType='Accessory' or productType='Coupon') Order By productCode ASC\par \tab\tab 320 Query Select tblOutlet.outletCode, tblOutlet.outletID From tblOutlet Where tblOutlet.outletStatus='y' And tblOutlet.outletID!=3 And tblOutlet.outletType='NonFranchise' Order By tblOutlet.outletID\par \tab\tab 320 Quit \par 080913 13:07:26\tab 321 Connect root@localhost on mpcms3\par \tab\tab 321 Query SHOW VARIABLES\par \tab\tab 321 Query SHOW COLLATION\par \tab\tab 321 Query SET character_set_results=NULL\par \tab\tab 321 Init DB mpcms3\par \tab\tab 321 Query Select tblProduct.productID, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.productTotalAmount From tblStock Inner Join tblProduct On tblStock.productID = tblProduct.productID Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='352943021528760' And tblStock.productType='Imei'\par \tab\tab 322 Connect root@localhost on mpcms3\par \tab\tab 322 Query SHOW VARIABLES\par \tab\tab 322 Query SHOW COLLATION\par \tab\tab 322 Query SET character_set_results=NULL\par \tab\tab 322 Init DB mpcms3\par \tab\tab 322 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 322 Query BEGIN\par \tab\tab 322 Query Update tblStock Set tblStock.stockStatus = 'b'Where tblStock.stockSIQ='352943021528760' And tblStock.stockID=9457\par \tab\tab 322 Query Insert into tblTempTransfer Set productType='Imei', productID=1872, stockID ='9457', stockSIQ ='352943021528760', employeeID = '4', tempTransferTimeStamp='2008:09:13 13:07:26'\par \tab\tab 322 Query COMMIT\par \tab\tab 322 Quit \par \tab\tab 321 Quit \par 080913 13:07:30\tab 323 Connect root@localhost on mpcms3\par \tab\tab 323 Query SHOW VARIABLES\par \tab\tab 323 Query SHOW COLLATION\par \tab\tab 323 Query SET character_set_results=NULL\par \tab\tab 323 Init DB mpcms3\par \tab\tab 323 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 323 Query BEGIN\par \tab\tab 324 Connect root@localhost on mpcms3\par \tab\tab 324 Query SHOW VARIABLES\par \tab\tab 324 Query SHOW COLLATION\par \tab\tab 324 Query SET character_set_results=NULL\par \tab\tab 324 Init DB mpcms3\par \tab\tab 324 Query Select tblUpdateCentralCopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 13:08:03\tab 324 Quit \par \tab\tab 325 Connect root@localhost on mpcms3\par \tab\tab 325 Query SHOW VARIABLES\par \tab\tab 325 Query SHOW COLLATION\par \tab\tab 325 Query SET character_set_results=NULL\par \tab\tab 325 Init DB mpcms3\par \tab\tab 325 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 13:09:09\tab 325 Quit \par \tab\tab 326 Connect root@localhost on mpcms3\par \tab\tab 326 Query SHOW VARIABLES\par \tab\tab 326 Query SHOW COLLATION\par \tab\tab 326 Query SET character_set_results=NULL\par \tab\tab 326 Init DB mpcms3\par \tab\tab 326 Query Select tblID.lastValue From tblID Where tblID.tableName='tblTransfer'\par \tab\tab 326 Quit \par \tab\tab 323 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransfer'\par 080913 13:09:11\tab 323 Query Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'\par \tab\tab 323 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'\par 080913 13:09:12\tab 323 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=1872\par \tab\tab 323 Query Insert into tblTransferDetails Set transferDetailsID = 163, transferID=104, outletID = 3, stockID = 9457, productID= 1872, productType = 'Imei', stockQuantity = 1, stockSIQ = '352943021528760', costPrice = 1370, transferPrice = 1370\par 080913 13:09:19\tab 323 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -1370 Where tblProduct.productID=1872\par 080913 13:09:28\tab 323 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=1872\par 080913 13:09:32\tab 323 Query Insert into tblTransfer Set transferID=104, outletFromID=3, outletToID=1, employeeFromID=4, totalCostAmount=1370, totalTransferAmount=1370, totalProfitAmount=0, transferFromDate='2008:09:13', transferFromTime='13:09:32'\par 080913 13:09:35\tab 323 Query Delete From tblTempTransfer\par \tab\tab 323 Query COMMIT\par 080913 13:09:41\tab 323 Quit \par \tab\tab 327 Connect root@localhost on mpcms3\par \tab\tab 327 Query SHOW VARIABLES\par \tab\tab 327 Query SHOW COLLATION\par \tab\tab 327 Query SET character_set_results=NULL\par \tab\tab 327 Init DB mpcms3\par \tab\tab 327 Query Select tblProduct.productID, tblProduct.productName, tblProduct.productCode, tblTransferDetails.productType, tblTransferDetails.stockSIQ, tblTransferDetails.transferPrice From tblTransferDetails Inner Join tblTransfer On tblTransfer.transferID = tblTransferDetails.transferID Inner Join tblProduct On tblProduct.productID = tblTransferDetails.productID Where tblTransfer.outletFromID = 3 And tblTransfer.transferID = 104 And tblTransferDetails.transferID = 104 And tblTransferDetails.outletID = 3\par \tab\tab 328 Connect root@localhost on mpcms3\par \tab\tab 328 Query SHOW VARIABLES\par \tab\tab 328 Query SHOW COLLATION\par \tab\tab 328 Query SET character_set_results=NULL\par \tab\tab 328 Init DB mpcms3\par \tab\tab 328 Query Select outletFrom.outletCode as outletFromName, outletTo.outletCode as outletToName, Cast(DATE_FORMAT(tblTransfer.transferFromDate, '%d/%m/%Y') As Char) as transferFromDate, tblTransfer.transferFromTime From tblOutlet as outletFrom,tblOutlet as outletTo, tblTransfer Where outletFrom.outletID=tblTransfer.outletFromID And outletTo.outletID=tblTransfer.outletToID And tblTransfer.transferID = 104 And tblTransfer.outletFromID = 3\par \tab\tab 328 Quit \par \tab\tab 327 Quit \par 080913 13:10:23\tab 329 Connect root@localhost on mpcms3\par \tab\tab 329 Query SHOW VARIABLES\par \tab\tab 329 Query SHOW COLLATION\par \tab\tab 329 Query SET character_set_results=NULL\par \tab\tab 329 Init DB mpcms3\par \tab\tab 329 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='5026'\par \tab\tab 329 Quit \par 080913 13:10:32\tab 330 Connect root@localhost on mpcms3\par \tab\tab 330 Query SHOW VARIABLES\par \tab\tab 330 Query SHOW COLLATION\par \tab\tab 330 Query SET character_set_results=NULL\par \tab\tab 330 Init DB mpcms3\par \tab\tab 330 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 330 Quit \par \tab\tab 331 Connect root@localhost on mpcms3\par \tab\tab 331 Query SHOW VARIABLES\par \tab\tab 331 Query SHOW COLLATION\par \tab\tab 331 Query SET character_set_results=NULL\par \tab\tab 331 Init DB mpcms3\par \tab\tab 331 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 331 Quit \par 080913 13:10:35\tab 332 Connect root@localhost on mpcms3\par \tab\tab 332 Query SHOW VARIABLES\par \tab\tab 332 Query SHOW COLLATION\par \tab\tab 332 Query SET character_set_results=NULL\par \tab\tab 332 Init DB mpcms3\par \tab\tab 332 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='353153023946221'\par 080913 13:10:37\tab 332 Quit \par 080913 13:10:48\tab 333 Connect root@localhost on mpcms3\par \tab\tab 333 Query SHOW VARIABLES\par \tab\tab 333 Query SHOW COLLATION\par \tab\tab 333 Query SET character_set_results=NULL\par \tab\tab 333 Init DB mpcms3\par \tab\tab 333 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='353153023946221'\par \tab\tab 333 Quit \par 080913 13:21:59\tab 334 Connect root@localhost on mpcms3\par \tab\tab 334 Query SHOW VARIABLES\par \tab\tab 334 Query SHOW COLLATION\par \tab\tab 334 Query SET character_set_results=NULL\par \tab\tab 334 Init DB mpcms3\par \tab\tab 334 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeeUserName='REMY' And tblEmployee.employeePassword='23298'\par \tab\tab 335 Connect root@localhost on mpcms3\par \tab\tab 335 Query SHOW VARIABLES\par \tab\tab 335 Query SHOW COLLATION\par \tab\tab 335 Query SET character_set_results=NULL\par \tab\tab 335 Init DB mpcms3\par \tab\tab 335 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 335 Query BEGIN\par \tab\tab 336 Connect root@localhost on mpcms3\par \tab\tab 336 Query SHOW VARIABLES\par \tab\tab 336 Query SHOW COLLATION\par \tab\tab 336 Query SET character_set_results=NULL\par \tab\tab 336 Init DB mpcms3\par \tab\tab 336 Query Select tblTempTransfer.productType, tblTempTransfer.productID, tblTempTransfer.stockID, tblTempTransfer.stockSIQ From tblTempTransfer\par \tab\tab 336 Quit \par \tab\tab 337 Connect root@localhost on mpcms3\par \tab\tab 337 Query SHOW VARIABLES\par \tab\tab 337 Query SHOW COLLATION\par \tab\tab 337 Query SET character_set_results=NULL\par \tab\tab 337 Init DB mpcms3\par \tab\tab 337 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 337 Query BEGIN\par \tab\tab 338 Connect root@localhost on mpcms3\par \tab\tab 338 Query SHOW VARIABLES\par \tab\tab 338 Query SHOW COLLATION\par \tab\tab 338 Query SET character_set_results=NULL\par \tab\tab 338 Init DB mpcms3\par \tab\tab 335 Quit \par \tab\tab 338 Query Select tblTempFranchiseTransfer.productType, tblTempFranchiseTransfer.productID, tblTempFranchiseTransfer.stockID, tblTempFranchiseTransfer.stockSIQ From tblTempFranchiseTransfer\par \tab\tab 338 Quit \par \tab\tab 339 Connect root@localhost on mpcms3\par \tab\tab 339 Query SHOW VARIABLES\par \tab\tab 339 Query SHOW COLLATION\par \tab\tab 339 Query SET character_set_results=NULL\par \tab\tab 339 Init DB mpcms3\par \tab\tab 339 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 339 Query BEGIN\par \tab\tab 340 Connect root@localhost on mpcms3\par \tab\tab 340 Query SHOW VARIABLES\par \tab\tab 340 Query SHOW COLLATION\par \tab\tab 340 Query SET character_set_results=NULL\par \tab\tab 340 Init DB mpcms3\par \tab\tab 340 Query Select tblTempSaleToDealer.productType, tblTempSaleToDealer.productID, tblTempSaleToDealer.stockID, tblTempSaleToDealer.stockSIQ From tblTempSaleToDealer\par \tab\tab 340 Quit \par \tab\tab 341 Connect root@localhost on mpcms3\par \tab\tab 341 Query SHOW VARIABLES\par \tab\tab 341 Query SHOW COLLATION\par \tab\tab 341 Query SET character_set_results=NULL\par \tab\tab 341 Init DB mpcms3\par \tab\tab 341 Query Select Distinct tblMainMenu.mainMenuName,tblMenuAuthorization.mainMenuID From tblMainMenu,tblMenuAuthorization Where tblMainMenu.mainMenuID=tblMenuAuthorization.mainMenuID And tblMenuAuthorization.employeeID=4 Order By tblMenuAuthorization.mainMenuID\par \tab\tab 342 Connect root@localhost on mpcms3\par \tab\tab 342 Query SHOW VARIABLES\par \tab\tab 342 Query SHOW COLLATION\par \tab\tab 342 Query SET character_set_results=NULL\par \tab\tab 342 Init DB mpcms3\par \tab\tab 342 Query Select Distinct tblSubMenu1.subMenu1Name, tblMenuAuthorization.subMenu1ID From tblSubMenu1,tblMenuAuthorization Where tblSubMenu1.subMenu1ID=tblMenuAuthorization.subMenu1ID And tblMenuAuthorization.mainMenuID='2' And tblMenuAuthorization.employeeID=4\par \tab\tab 342 Quit \par \tab\tab 343 Connect root@localhost on mpcms3\par \tab\tab 343 Query SHOW VARIABLES\par \tab\tab 343 Query SHOW COLLATION\par \tab\tab 343 Query SET character_set_results=NULL\par \tab\tab 343 Init DB mpcms3\par \tab\tab 343 Query Select Distinct tblSubMenu1.subMenu1Name, tblMenuAuthorization.subMenu1ID From tblSubMenu1,tblMenuAuthorization Where tblSubMenu1.subMenu1ID=tblMenuAuthorization.subMenu1ID And tblMenuAuthorization.mainMenuID='3' And tblMenuAuthorization.employeeID=4\par \tab\tab 343 Quit \par \tab\tab 341 Quit \par \tab\tab 334 Quit \par 080913 13:22:15\tab 337 Quit \par \tab\tab 339 Quit \par 080913 13:40:42\tab 344 Connect root@localhost on mpcms3\par \tab\tab 344 Query SHOW VARIABLES\par \tab\tab 344 Query SHOW COLLATION\par \tab\tab 344 Query SET character_set_results=NULL\par \tab\tab 344 Init DB mpcms3\par \tab\tab 344 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 344 Quit \par \tab\tab 345 Connect root@localhost on mpcms3\par \tab\tab 345 Query SHOW VARIABLES\par \tab\tab 345 Query SHOW COLLATION\par \tab\tab 345 Query SET character_set_results=NULL\par \tab\tab 345 Init DB mpcms3\par \tab\tab 345 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 345 Quit \par 080913 14:10:55\tab 346 Connect root@localhost on mpcms3\par \tab\tab 346 Query SHOW VARIABLES\par \tab\tab 346 Query SHOW COLLATION\par \tab\tab 346 Query SET character_set_results=NULL\par \tab\tab 346 Init DB mpcms3\par \tab\tab 346 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 346 Quit \par \tab\tab 347 Connect root@localhost on mpcms3\par \tab\tab 347 Query SHOW VARIABLES\par \tab\tab 347 Query SHOW COLLATION\par \tab\tab 347 Query SET character_set_results=NULL\par \tab\tab 347 Init DB mpcms3\par \tab\tab 347 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 347 Quit \par 080913 14:13:11\tab 348 Connect root@localhost on mpcms3\par \tab\tab 348 Query SHOW VARIABLES\par \tab\tab 348 Query SHOW COLLATION\par \tab\tab 348 Query SET character_set_results=NULL\par \tab\tab 348 Init DB mpcms3\par \tab\tab 348 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080948'\par \tab\tab 349 Connect root@localhost on mpcms3\par \tab\tab 349 Query SHOW VARIABLES\par \tab\tab 349 Query SHOW COLLATION\par \tab\tab 349 Query SET character_set_results=NULL\par \tab\tab 349 Init DB mpcms3\par \tab\tab 349 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 349 Query BEGIN\par \tab\tab 349 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080948' And tblStock.stockID=9552\par \tab\tab 349 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9552', stockSIQ ='0002172800080948', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:11'\par \tab\tab 349 Query COMMIT\par \tab\tab 349 Quit \par \tab\tab 348 Quit \par 080913 14:13:16\tab 350 Connect root@localhost on mpcms3\par \tab\tab 350 Query SHOW VARIABLES\par \tab\tab 350 Query SHOW COLLATION\par \tab\tab 350 Query SET character_set_results=NULL\par \tab\tab 350 Init DB mpcms3\par \tab\tab 350 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080949'\par \tab\tab 351 Connect root@localhost on mpcms3\par \tab\tab 351 Query SHOW VARIABLES\par \tab\tab 351 Query SHOW COLLATION\par \tab\tab 351 Query SET character_set_results=NULL\par \tab\tab 351 Init DB mpcms3\par \tab\tab 351 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 351 Query BEGIN\par \tab\tab 351 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080949' And tblStock.stockID=9553\par \tab\tab 351 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9553', stockSIQ ='0002172800080949', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:16'\par \tab\tab 351 Query COMMIT\par \tab\tab 351 Quit \par \tab\tab 350 Quit \par 080913 14:13:23\tab 352 Connect root@localhost on mpcms3\par \tab\tab 352 Query SHOW VARIABLES\par \tab\tab 352 Query SHOW COLLATION\par \tab\tab 352 Query SET character_set_results=NULL\par \tab\tab 352 Init DB mpcms3\par \tab\tab 352 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080950'\par \tab\tab 353 Connect root@localhost on mpcms3\par \tab\tab 353 Query SHOW VARIABLES\par \tab\tab 353 Query SHOW COLLATION\par \tab\tab 353 Query SET character_set_results=NULL\par \tab\tab 353 Init DB mpcms3\par \tab\tab 353 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 353 Query BEGIN\par \tab\tab 353 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080950' And tblStock.stockID=9554\par \tab\tab 353 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9554', stockSIQ ='0002172800080950', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:23'\par \tab\tab 353 Query COMMIT\par \tab\tab 353 Quit \par \tab\tab 352 Quit \par 080913 14:13:28\tab 354 Connect root@localhost on mpcms3\par \tab\tab 354 Query SHOW VARIABLES\par \tab\tab 354 Query SHOW COLLATION\par \tab\tab 354 Query SET character_set_results=NULL\par \tab\tab 354 Init DB mpcms3\par \tab\tab 354 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080951'\par \tab\tab 355 Connect root@localhost on mpcms3\par \tab\tab 355 Query SHOW VARIABLES\par \tab\tab 355 Query SHOW COLLATION\par \tab\tab 355 Query SET character_set_results=NULL\par \tab\tab 355 Init DB mpcms3\par \tab\tab 355 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 355 Query BEGIN\par \tab\tab 355 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080951' And tblStock.stockID=9555\par \tab\tab 355 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9555', stockSIQ ='0002172800080951', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:28'\par \tab\tab 355 Query COMMIT\par \tab\tab 355 Quit \par \tab\tab 354 Quit \par 080913 14:13:37\tab 356 Connect root@localhost on mpcms3\par \tab\tab 356 Query SHOW VARIABLES\par \tab\tab 356 Query SHOW COLLATION\par \tab\tab 356 Query SET character_set_results=NULL\par \tab\tab 356 Init DB mpcms3\par \tab\tab 356 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080952'\par \tab\tab 357 Connect root@localhost on mpcms3\par \tab\tab 357 Query SHOW VARIABLES\par \tab\tab 357 Query SHOW COLLATION\par \tab\tab 357 Query SET character_set_results=NULL\par \tab\tab 357 Init DB mpcms3\par \tab\tab 357 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 357 Query BEGIN\par \tab\tab 357 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080952' And tblStock.stockID=9556\par \tab\tab 357 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9556', stockSIQ ='0002172800080952', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:37'\par \tab\tab 357 Query COMMIT\par \tab\tab 357 Quit \par \tab\tab 356 Quit \par 080913 14:13:42\tab 358 Connect root@localhost on mpcms3\par \tab\tab 358 Query SHOW VARIABLES\par \tab\tab 358 Query SHOW COLLATION\par \tab\tab 358 Query SET character_set_results=NULL\par \tab\tab 358 Init DB mpcms3\par \tab\tab 358 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080953'\par \tab\tab 359 Connect root@localhost on mpcms3\par \tab\tab 359 Query SHOW VARIABLES\par \tab\tab 359 Query SHOW COLLATION\par \tab\tab 359 Query SET character_set_results=NULL\par \tab\tab 359 Init DB mpcms3\par \tab\tab 359 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 359 Query BEGIN\par \tab\tab 359 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080953' And tblStock.stockID=9557\par \tab\tab 359 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9557', stockSIQ ='0002172800080953', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:42'\par \tab\tab 359 Query COMMIT\par \tab\tab 359 Quit \par \tab\tab 358 Quit \par 080913 14:13:48\tab 360 Connect root@localhost on mpcms3\par \tab\tab 360 Query SHOW VARIABLES\par \tab\tab 360 Query SHOW COLLATION\par \tab\tab 360 Query SET character_set_results=NULL\par \tab\tab 360 Init DB mpcms3\par \tab\tab 360 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080954'\par \tab\tab 361 Connect root@localhost on mpcms3\par \tab\tab 361 Query SHOW VARIABLES\par \tab\tab 361 Query SHOW COLLATION\par \tab\tab 361 Query SET character_set_results=NULL\par \tab\tab 361 Init DB mpcms3\par \tab\tab 361 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 361 Query BEGIN\par \tab\tab 361 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080954' And tblStock.stockID=9558\par \tab\tab 361 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9558', stockSIQ ='0002172800080954', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:48'\par \tab\tab 361 Query COMMIT\par \tab\tab 361 Quit \par \tab\tab 360 Quit \par 080913 14:13:53\tab 362 Connect root@localhost on mpcms3\par \tab\tab 362 Query SHOW VARIABLES\par \tab\tab 362 Query SHOW COLLATION\par \tab\tab 362 Query SET character_set_results=NULL\par \tab\tab 362 Init DB mpcms3\par \tab\tab 362 Query Select tblProduct.productID, tblProduct.productType, tblStock.stockID, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblStock,tblProduct Where tblStock.stockStatus ='y' And tblStock.productID=tblProduct.productID And tblStock.stockSIQ='0002172800080955'\par \tab\tab 363 Connect root@localhost on mpcms3\par \tab\tab 363 Query SHOW VARIABLES\par \tab\tab 363 Query SHOW COLLATION\par \tab\tab 363 Query SET character_set_results=NULL\par \tab\tab 363 Init DB mpcms3\par \tab\tab 363 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 363 Query BEGIN\par \tab\tab 363 Query Update tblStock Set tblStock.stockStatus = 's'Where tblStock.stockSIQ='0002172800080955' And tblStock.stockID=9559\par \tab\tab 363 Query Insert into tblTempReceipt Set productType='Coupon', productID=303, stockID ='9559', stockSIQ ='0002172800080955', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:13:53'\par \tab\tab 363 Query COMMIT\par \tab\tab 363 Quit \par \tab\tab 362 Quit \par 080913 14:13:59\tab 364 Connect root@localhost on mpcms3\par \tab\tab 364 Query SHOW VARIABLES\par \tab\tab 364 Query SHOW COLLATION\par \tab\tab 364 Query SET character_set_results=NULL\par \tab\tab 364 Init DB mpcms3\par \tab\tab 364 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 364 Query BEGIN\par \tab\tab 365 Connect root@localhost on mpcms3\par \tab\tab 365 Query SHOW VARIABLES\par \tab\tab 365 Query SHOW COLLATION\par \tab\tab 365 Query SET character_set_results=NULL\par \tab\tab 365 Init DB mpcms3\par \tab\tab 365 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 14:14:38\tab 365 Quit \par \tab\tab 366 Connect root@localhost on mpcms3\par \tab\tab 366 Query SHOW VARIABLES\par \tab\tab 366 Query SHOW COLLATION\par \tab\tab 366 Query SET character_set_results=NULL\par \tab\tab 366 Init DB mpcms3\par \tab\tab 366 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 14:15:26\tab 366 Quit \par \tab\tab 367 Connect root@localhost on mpcms3\par \tab\tab 367 Query SHOW VARIABLES\par \tab\tab 367 Query SHOW COLLATION\par \tab\tab 367 Query SET character_set_results=NULL\par \tab\tab 367 Init DB mpcms3\par \tab\tab 367 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 367 Quit \par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par 080913 14:15:28\tab 364 Query Insert into tblReceipt Set receiptID=2268, outletID=3, employeeID=16, customerName='Cash', customerPhone='', totalCostAmount=77.84, totalSellingAmount=80, totalProfitAmount=2.15999999999998, changeAmount=0, profit='y', receiptDate = '2008:09:13', receiptTime = '14:15:28'\par 080913 14:15:35\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:15:36\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:15:37\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8891, outletID = 3,stockID = 9552, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080948', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:15:49\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:15:51\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:15:53\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:15:55\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:15:56\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8892, outletID = 3,stockID = 9553, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080949', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:15:58\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:15:59\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:01\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:04\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:05\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8893, outletID = 3,stockID = 9554, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080950', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:16:08\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:16:09\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:11\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:12\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:15\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8894, outletID = 3,stockID = 9555, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080951', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:16:18\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:16:19\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:21\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:23\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:26\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8895, outletID = 3,stockID = 9556, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080952', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:16:29\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:16:31\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:33\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:34\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:35\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8896, outletID = 3,stockID = 9557, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080953', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:16:37\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:16:38\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:41\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:42\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:43\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8897, outletID = 3,stockID = 9558, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080954', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:16:48\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:16:53\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:16:57\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par 080913 14:16:58\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:17:00\tab 364 Query Insert into tblReceiptDetails Set receiptID=2268, receiptDetailsID = 8898, outletID = 3,stockID = 9559, productID= 303, productType = 'Coupon', productQuantity = 1 , productSIQ = '0002172800080955', costPrice = 9.73, sellingPrice = 10, profitAmount = 0.27, profit = 'y'\par 080913 14:17:04\tab 364 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -9.73 Where tblProduct.productID=303\par 080913 14:17:06\tab 364 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=303\par 080913 14:17:08\tab 364 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 364 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par 080913 14:17:11\tab 364 Query Insert into tblPaymentDetails Set paymentDetailsID=2325, outletID = 3,receiptID = 2268, paymentTypeID= 1, amount = 80\par 080913 14:17:19\tab 364 Query Delete From tblTempReceipt\par \tab\tab 364 Query COMMIT\par 080913 14:17:27\tab 364 Quit \par \tab\tab 368 Connect root@localhost on mpcms3\par \tab\tab 368 Query SHOW VARIABLES\par \tab\tab 368 Query SHOW COLLATION\par \tab\tab 368 Query SET character_set_results=NULL\par \tab\tab 368 Init DB mpcms3\par \tab\tab 368 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2268\par \tab\tab 368 Quit \par \tab\tab 369 Connect root@localhost on mpcms3\par \tab\tab 369 Query SHOW VARIABLES\par \tab\tab 369 Query SHOW COLLATION\par \tab\tab 369 Query SET character_set_results=NULL\par \tab\tab 369 Init DB mpcms3\par \tab\tab 369 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2268\par \tab\tab 369 Quit \par \tab\tab 370 Connect root@localhost on mpcms3\par \tab\tab 370 Query SHOW VARIABLES\par \tab\tab 370 Query SHOW COLLATION\par \tab\tab 370 Query SET character_set_results=NULL\par \tab\tab 370 Init DB mpcms3\par \tab\tab 370 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2268\par \tab\tab 370 Quit \par 080913 14:17:33\tab 371 Connect root@localhost on mpcms3\par \tab\tab 371 Query SHOW VARIABLES\par \tab\tab 371 Query SHOW COLLATION\par \tab\tab 371 Query SET character_set_results=NULL\par \tab\tab 371 Init DB mpcms3\par \tab\tab 371 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='5022'\par 080913 14:17:36\tab 371 Quit \par 080913 14:17:44\tab 372 Connect root@localhost on mpcms3\par \tab\tab 372 Query SHOW VARIABLES\par \tab\tab 372 Query SHOW COLLATION\par \tab\tab 372 Query SET character_set_results=NULL\par \tab\tab 372 Init DB mpcms3\par \tab\tab 372 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='5026'\par \tab\tab 372 Quit \par 080913 14:19:22\tab 373 Connect root@localhost on mpcms3\par \tab\tab 373 Query SHOW VARIABLES\par \tab\tab 373 Query SHOW COLLATION\par \tab\tab 373 Query SET character_set_results=NULL\par \tab\tab 373 Init DB mpcms3\par \tab\tab 373 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=350\par 080913 14:19:23\tab 373 Quit \par \tab\tab 374 Connect root@localhost on mpcms3\par \tab\tab 374 Query SHOW VARIABLES\par \tab\tab 374 Query SHOW COLLATION\par \tab\tab 374 Query SET character_set_results=NULL\par \tab\tab 374 Init DB mpcms3\par \tab\tab 374 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=350\par 080913 14:19:24\tab 374 Quit \par 080913 14:19:28\tab 375 Connect root@localhost on mpcms3\par \tab\tab 375 Query SHOW VARIABLES\par \tab\tab 375 Query SHOW COLLATION\par \tab\tab 375 Query SET character_set_results=NULL\par \tab\tab 375 Init DB mpcms3\par \tab\tab 375 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 375 Query BEGIN\par \tab\tab 375 Query Delete From tblTempReceipt\par \tab\tab 375 Query COMMIT\par \tab\tab 375 Quit \par 080913 14:19:44\tab 376 Connect root@localhost on mpcms3\par \tab\tab 376 Query SHOW VARIABLES\par \tab\tab 376 Query SHOW COLLATION\par \tab\tab 376 Query SET character_set_results=NULL\par \tab\tab 376 Init DB mpcms3\par \tab\tab 376 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=350\par \tab\tab 376 Quit \par 080913 14:19:45\tab 377 Connect root@localhost on mpcms3\par \tab\tab 377 Query SHOW VARIABLES\par \tab\tab 377 Query SHOW COLLATION\par \tab\tab 377 Query SET character_set_results=NULL\par \tab\tab 377 Init DB mpcms3\par \tab\tab 377 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=350\par \tab\tab 377 Quit \par \tab\tab 378 Connect root@localhost on mpcms3\par \tab\tab 378 Query SHOW VARIABLES\par \tab\tab 378 Query SHOW COLLATION\par \tab\tab 378 Query SET character_set_results=NULL\par \tab\tab 378 Init DB mpcms3\par \tab\tab 378 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=350\par \tab\tab 378 Quit \par 080913 14:22:49\tab 379 Connect root@localhost on mpcms3\par \tab\tab 379 Query SHOW VARIABLES\par \tab\tab 379 Query SHOW COLLATION\par \tab\tab 379 Query SET character_set_results=NULL\par \tab\tab 379 Init DB mpcms3\par \tab\tab 379 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=14\par 080913 14:22:50\tab 379 Quit \par 080913 14:23:12\tab 380 Connect root@localhost on mpcms3\par \tab\tab 380 Query SHOW VARIABLES\par \tab\tab 380 Query SHOW COLLATION\par \tab\tab 380 Query SET character_set_results=NULL\par \tab\tab 380 Init DB mpcms3\par \tab\tab 380 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=3\par \tab\tab 381 Connect root@localhost on mpcms3\par \tab\tab 381 Query SHOW VARIABLES\par \tab\tab 381 Query SHOW COLLATION\par \tab\tab 381 Query SET character_set_results=NULL\par \tab\tab 381 Init DB mpcms3\par \tab\tab 381 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 381 Query BEGIN\par \tab\tab 381 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked + 1 Where tblProduct.productID=3\par \tab\tab 381 Query Insert into tblTempReceipt Set productType='Accessory', productID=3, stockID ='7', stockSIQ ='1', employeeID = '16', tempReceiptTimeStamp='2008:09:13 02:23:12'\par \tab\tab 381 Query COMMIT\par \tab\tab 381 Quit \par \tab\tab 380 Quit \par 080913 14:23:25\tab 382 Connect root@localhost on mpcms3\par \tab\tab 382 Query SHOW VARIABLES\par \tab\tab 382 Query SHOW COLLATION\par \tab\tab 382 Query SET character_set_results=NULL\par \tab\tab 382 Init DB mpcms3\par \tab\tab 382 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='1234'\par \tab\tab 382 Quit \par 080913 14:23:45\tab 383 Connect root@localhost on mpcms3\par \tab\tab 383 Query SHOW VARIABLES\par \tab\tab 383 Query SHOW COLLATION\par \tab\tab 383 Query SET character_set_results=NULL\par \tab\tab 383 Init DB mpcms3\par \tab\tab 383 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='12343'\par \tab\tab 383 Quit \par \tab\tab 384 Connect root@localhost on mpcms3\par \tab\tab 384 Query SHOW VARIABLES\par \tab\tab 384 Query SHOW COLLATION\par \tab\tab 384 Query SET character_set_results=NULL\par \tab\tab 384 Init DB mpcms3\par \tab\tab 384 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='12343'\par 080913 14:23:46\tab 384 Quit \par 080913 14:23:49\tab 385 Connect root@localhost on mpcms3\par \tab\tab 385 Query SHOW VARIABLES\par \tab\tab 385 Query SHOW COLLATION\par \tab\tab 385 Query SET character_set_results=NULL\par \tab\tab 385 Init DB mpcms3\par \tab\tab 385 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='1234'\par \tab\tab 385 Quit \par 080913 14:23:50\tab 386 Connect root@localhost on mpcms3\par \tab\tab 386 Query SHOW VARIABLES\par \tab\tab 386 Query SHOW COLLATION\par \tab\tab 386 Query SET character_set_results=NULL\par \tab\tab 386 Init DB mpcms3\par \tab\tab 386 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 386 Query BEGIN\par \tab\tab 387 Connect root@localhost on mpcms3\par \tab\tab 387 Query SHOW VARIABLES\par \tab\tab 387 Query SHOW COLLATION\par \tab\tab 387 Query SET character_set_results=NULL\par \tab\tab 387 Init DB mpcms3\par \tab\tab 387 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy\par 080913 14:24:02\tab 387 Quit \par \tab\tab 388 Connect root@localhost on mpcms3\par \tab\tab 388 Query SHOW VARIABLES\par \tab\tab 388 Query SHOW COLLATION\par \tab\tab 388 Query SET character_set_results=NULL\par \tab\tab 388 Init DB mpcms3\par \tab\tab 388 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral\par 080913 14:28:08\tab 388 Quit \par \tab\tab 389 Connect root@localhost on mpcms3\par \tab\tab 389 Query SHOW VARIABLES\par \tab\tab 389 Query SHOW COLLATION\par \tab\tab 389 Query SET character_set_results=NULL\par \tab\tab 389 Init DB mpcms3\par \tab\tab 389 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'\par \tab\tab 389 Quit \par \tab\tab 386 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'\par \tab\tab 386 Query Insert into tblReceipt Set receiptID=2269, outletID=3, employeeID=16, customerName='Cash', customerPhone='', totalCostAmount=22, totalSellingAmount=15, totalProfitAmount=-7, changeAmount=0, profit='n', receiptDate = '2008:09:13', receiptTime = '14:28:08'\par 080913 14:28:11\tab 386 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'\par \tab\tab 386 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'\par \tab\tab 386 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked From tblProduct Where tblProduct.productID=3\par \tab\tab 386 Query Select tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=3 Order By tblStock.stockID\par \tab\tab 386 Query Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +1, tblStock.stockBalance = tblStock.stockBalance -1 Where tblStock.stockID=1012\par 080913 14:28:13\tab 386 Query Insert into tblReceiptDetails Set receiptID=2269, receiptDetailsID = 8899, outletID = 3,stockID = 1012, productID= 3, productType = 'Accessory', productQuantity = 1, productSIQ = '1', costPrice = 22, sellingPrice = 15, profitAmount = -7, profit = 'n', stockStatus ='s'\par 080913 14:28:18\tab 386 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productBooked = tblProduct.productBooked -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -22 Where tblProduct.productID=3\par \tab\tab 386 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked From tblProduct Where tblProduct.productID=3\par 080913 14:28:20\tab 386 Query Select tblID.lastValue From tblID Where tblID.tableName='tblProductBelowCost'\par \tab\tab 386 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblProductBelowCost'\par 080913 14:28:22\tab 386 Query Insert into tblProductBelowCost Set productBelowCostID=696, receiptID = 2269, receiptDetailsID = 8899, outletID = 3,employeeID= 15, productBelowCostReason = 'S\par '\par 080913 14:28:23\tab 386 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'\par \tab\tab 386 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'\par \tab\tab 386 Query Insert into tblPaymentDetails Set paymentDetailsID=2326, outletID = 3,receiptID = 2269, paymentTypeID= 1, amount = 15\par 080913 14:28:24\tab 386 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptBelowCost'\par \tab\tab 386 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptBelowCost'\par \tab\tab 386 Query Insert into tblReceiptBelowCost Set receiptBelowCostID=190, receiptID = 2269, outletID = 3,employeeID= 15, receiptBelowCostReason = 'OFFER\par \par '\par 080913 14:28:25\tab 386 Query Delete From tblTempReceipt\par \tab\tab 386 Query COMMIT\par 080913 14:28:29\tab 386 Quit \par 080913 14:28:30\tab 390 Connect root@localhost on mpcms3\par \tab\tab 390 Query SHOW VARIABLES\par \tab\tab 390 Query SHOW COLLATION\par \tab\tab 390 Query SET character_set_results=NULL\par \tab\tab 390 Init DB mpcms3\par \tab\tab 390 Query Select tblProduct.productCode, tblProduct.productName, tblReceiptDetails.productType, tblReceiptDetails.productSIQ, tblReceiptDetails.sellingPrice, tblReceiptDetails.stockStatus From tblReceiptDetails Inner Join tblProduct On tblReceiptDetails.productID = tblProduct.productID Where tblReceiptDetails.receiptID = 2269\par \tab\tab 390 Quit \par \tab\tab 391 Connect root@localhost on mpcms3\par \tab\tab 391 Query SHOW VARIABLES\par \tab\tab 391 Query SHOW COLLATION\par \tab\tab 391 Query SET character_set_results=NULL\par \tab\tab 391 Init DB mpcms3\par \tab\tab 391 Query Select tblReceipt.totalSellingAmount, Cast(Concat(tblOutlet.outletCode,receiptID) As Char), tblEmployee.employeeUserName, Cast(DATE_FORMAT(tblReceipt.receiptDate, '%d/%m/%Y')As Char), tblReceipt.receiptTime, tblReceipt.customerName, tblReceipt.changeAmount From tblReceipt Inner Join tblEmployee On tblEmployee.employeeID=tblReceipt.employeeID Inner Join tblOutlet On tblReceipt.outletID = tblOutlet.outletID Where tblReceipt.receiptID=2269\par \tab\tab 391 Quit \par \tab\tab 392 Connect root@localhost on mpcms3\par \tab\tab 392 Query SHOW VARIABLES\par \tab\tab 392 Query SHOW COLLATION\par \tab\tab 392 Query SET character_set_results=NULL\par \tab\tab 392 Init DB mpcms3\par \tab\tab 392 Query Select tblPaymentDetails.paymentTypeID, tblPaymentDetails.creditCardTypeID, tblPaymentDetails.amount From tblPaymentDetails Where tblPaymentDetails.receiptID = 2269\par \tab\tab 392 Quit \par 080913 14:41:23\tab 393 Connect root@localhost on mpcms3\par \tab\tab 393 Query SHOW VARIABLES\par \tab\tab 393 Query SHOW COLLATION\par \tab\tab 393 Query SET character_set_results=NULL\par \tab\tab 393 Init DB mpcms3\par \tab\tab 393 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 393 Quit \par \tab\tab 394 Connect root@localhost on mpcms3\par \tab\tab 394 Query SHOW VARIABLES\par \tab\tab 394 Query SHOW COLLATION\par \tab\tab 394 Query SET character_set_results=NULL\par \tab\tab 394 Init DB mpcms3\par \tab\tab 394 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 394 Quit \par 080913 14:41:41\tab 395 Connect root@localhost on mpcms3\par \tab\tab 395 Query SHOW VARIABLES\par \tab\tab 395 Query SHOW COLLATION\par \tab\tab 395 Query SET character_set_results=NULL\par \tab\tab 395 Init DB mpcms3\par \tab\tab 395 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeePassword='0888'\par \tab\tab 395 Quit \par 080913 14:42:00\tab 396 Connect root@localhost on mpcms3\par \tab\tab 396 Query SHOW VARIABLES\par \tab\tab 396 Query SHOW COLLATION\par \tab\tab 396 Query SET character_set_results=NULL\par \tab\tab 396 Init DB mpcms3\par \tab\tab 396 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productCode, tblProduct.productName, tblProduct.productPrice, tblProduct.rrpMarkUpType, tblProduct.rrpMarkUpFixed, tblProduct.rrpMarkUpAmount, tblProduct.rrpMarkUpPercentage, tblProduct.productTotalAmount From tblProduct Where productID=536\par \tab\tab 397 Connect root@localhost on mpcms3\par \tab\tab 397 Query SHOW VARIABLES\par \tab\tab 397 Query SHOW COLLATION\par \tab\tab 397 Query SET character_set_results=NULL\par \tab\tab 397 Init DB mpcms3\par \tab\tab 397 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 397 Query BEGIN\par \tab\tab 397 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked + 1 Where tblProduct.productID=536\par \tab\tab 397 Query Insert into tblTempReceipt Set productType='Accessory', productID=536, stockID ='8', stockSIQ ='1', employeeID = '19', tempReceiptTimeStamp='2008:09:13 02:42:00'\par \tab\tab 397 Query COMMIT\par \tab\tab 397 Quit \par \tab\tab 396 Quit \par 080913 15:11:34\tab 398 Connect root@localhost on mpcms3\par \tab\tab 398 Query SHOW VARIABLES\par \tab\tab 398 Query SHOW COLLATION\par \tab\tab 398 Query SET character_set_results=NULL\par \tab\tab 398 Init DB mpcms3\par \tab\tab 398 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 398 Quit \par \tab\tab 399 Connect root@localhost on mpcms3\par \tab\tab 399 Query SHOW VARIABLES\par \tab\tab 399 Query SHOW COLLATION\par \tab\tab 399 Query SET character_set_results=NULL\par \tab\tab 399 Init DB mpcms3\par \tab\tab 399 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 399 Quit \par 080913 15:33:46\tab 400 Connect root@localhost on mpcms3\par \tab\tab 400 Query SHOW VARIABLES\par \tab\tab 400 Query SHOW COLLATION\par \tab\tab 400 Query SET character_set_results=NULL\par \tab\tab 400 Init DB mpcms3\par \tab\tab 400 Query Select productCode, Cast(Concat(productID,'#',productName,'#',productType) As Char) as productNameID From tblProduct Where productStatus='y' And (productType='Accessory' or productType='Coupon') Order By productCode ASC\par \tab\tab 400 Query Select tblOutlet.outletCode, tblOutlet.outletID From tblOutlet Where tblOutlet.outletStatus='y' And tblOutlet.outletID!=3 And tblOutlet.outletType='Franchise' Order By tblOutlet.outletID\par \tab\tab 400 Quit \par 080913 15:34:52\tab 401 Connect root@localhost on mpcms3\par \tab\tab 401 Query SHOW VARIABLES\par \tab\tab 401 Query SHOW COLLATION\par \tab\tab 401 Query SET character_set_results=NULL\par \tab\tab 401 Init DB mpcms3\par \tab\tab 401 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeeUserName='REMY' And tblEmployee.employeePassword='23298'\par \tab\tab 401 Quit \par \tab\tab 402 Connect root@localhost on mpcms3\par \tab\tab 402 Query SHOW VARIABLES\par \tab\tab 402 Query SHOW COLLATION\par \tab\tab 402 Query SET character_set_results=NULL\par \tab\tab 402 Init DB mpcms3\par \tab\tab 402 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 402 Query BEGIN\par \tab\tab 403 Connect root@localhost on mpcms3\par \tab\tab 403 Query SHOW VARIABLES\par \tab\tab 403 Query SHOW COLLATION\par \tab\tab 403 Query SET character_set_results=NULL\par \tab\tab 403 Init DB mpcms3\par \tab\tab 403 Query Select tblTempReceipt.productType, tblTempReceipt.productID, tblTempReceipt.stockID, tblTempReceipt.stockSIQ From tblTempReceipt\par \tab\tab 402 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked - 1 Where tblProduct.productID=536\par \tab\tab 402 Query Delete From tblTempReceipt\par \tab\tab 402 Query COMMIT\par \tab\tab 402 Quit \par \tab\tab 403 Quit \par \tab\tab 404 Connect root@localhost on mpcms3\par \tab\tab 404 Query SHOW VARIABLES\par \tab\tab 404 Query SHOW COLLATION\par \tab\tab 404 Query SET character_set_results=NULL\par \tab\tab 404 Init DB mpcms3\par \tab\tab 404 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID\par \tab\tab 404 Query Select tblBank.bankID, tblBank.bankCode From tblBank Where bankStatus='y' Order By bankCode\par \tab\tab 404 Quit \par 080913 15:35:12\tab 405 Connect root@localhost on mpcms3\par \tab\tab 405 Query SHOW VARIABLES\par \tab\tab 405 Query SHOW COLLATION\par \tab\tab 405 Query SET character_set_results=NULL\par \tab\tab 405 Init DB mpcms3\par \tab\tab 405 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeeUserName='REMY' And tblEmployee.employeePassword='23298'\par \tab\tab 405 Quit \par \tab\tab 406 Connect root@localhost on mpcms3\par \tab\tab 406 Query SHOW VARIABLES\par \tab\tab 406 Query SHOW COLLATION\par \tab\tab 406 Query SET character_set_results=NULL\par \tab\tab 406 Init DB mpcms3\par \tab\tab 406 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 406 Query BEGIN\par \tab\tab 407 Connect root@localhost on mpcms3\par \tab\tab 407 Query SHOW VARIABLES\par \tab\tab 407 Query SHOW COLLATION\par \tab\tab 407 Query SET character_set_results=NULL\par \tab\tab 407 Init DB mpcms3\par \tab\tab 407 Query Select tblTempReceipt.productType, tblTempReceipt.productID, tblTempReceipt.stockID, tblTempReceipt.stockSIQ From tblTempReceipt\par \tab\tab 407 Quit \par \tab\tab 408 Connect root@localhost on mpcms3\par \tab\tab 408 Query SHOW VARIABLES\par \tab\tab 406 Quit \par \tab\tab 408 Query SHOW COLLATION\par \tab\tab 408 Query SET character_set_results=NULL\par \tab\tab 408 Init DB mpcms3\par \tab\tab 408 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID\par \tab\tab 408 Query Select tblBank.bankID, tblBank.bankCode From tblBank Where bankStatus='y' Order By bankCode\par \tab\tab 408 Quit \par 080913 15:35:27\tab 409 Connect root@localhost on mpcms3\par \tab\tab 409 Query SHOW VARIABLES\par \tab\tab 409 Query SHOW COLLATION\par \tab\tab 409 Query SET character_set_results=NULL\par \tab\tab 409 Init DB mpcms3\par \tab\tab 409 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 409 Query BEGIN\par \tab\tab 409 Query Delete From tblTempReceipt\par \tab\tab 409 Query COMMIT\par \tab\tab 409 Quit \par 080913 15:35:49\tab 410 Connect root@localhost on mpcms3\par \tab\tab 410 Query SHOW VARIABLES\par \tab\tab 410 Query SHOW COLLATION\par \tab\tab 410 Query SET character_set_results=NULL\par \tab\tab 410 Init DB mpcms3\par \tab\tab 410 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeeUserName='remy' And tblEmployee.employeePassword='23298'\par \tab\tab 410 Quit \par \tab\tab 411 Connect root@localhost on mpcms3\par \tab\tab 411 Query SHOW VARIABLES\par \tab\tab 411 Query SHOW COLLATION\par \tab\tab 411 Query SET character_set_results=NULL\par \tab\tab 411 Init DB mpcms3\par \tab\tab 411 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 411 Query BEGIN\par \tab\tab 412 Connect root@localhost on mpcms3\par \tab\tab 412 Query SHOW VARIABLES\par \tab\tab 412 Query SHOW COLLATION\par \tab\tab 412 Query SET character_set_results=NULL\par \tab\tab 412 Init DB mpcms3\par \tab\tab 412 Query Select tblTempReceipt.productType, tblTempReceipt.productID, tblTempReceipt.stockID, tblTempReceipt.stockSIQ From tblTempReceipt\par \tab\tab 412 Quit \par \tab\tab 413 Connect root@localhost on mpcms3\par \tab\tab 413 Query SHOW VARIABLES\par \tab\tab 411 Quit \par \tab\tab 413 Query SHOW COLLATION\par \tab\tab 413 Query SET character_set_results=NULL\par \tab\tab 413 Init DB mpcms3\par \tab\tab 413 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID\par \tab\tab 413 Query Select tblBank.bankID, tblBank.bankCode From tblBank Where bankStatus='y' Order By bankCode\par \tab\tab 413 Quit \par 080913 15:35:53\tab 414 Connect root@localhost on mpcms3\par \tab\tab 414 Query SHOW VARIABLES\par \tab\tab 414 Query SHOW COLLATION\par \tab\tab 414 Query SET character_set_results=NULL\par \tab\tab 414 Init DB mpcms3\par \tab\tab 414 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 414 Query BEGIN\par \tab\tab 414 Query Delete From tblTempReceipt\par \tab\tab 414 Query COMMIT\par \tab\tab 414 Quit \par 080913 15:35:56\tab 415 Connect root@localhost on mpcms3\par \tab\tab 415 Query SHOW VARIABLES\par \tab\tab 415 Query SHOW COLLATION\par \tab\tab 415 Query SET character_set_results=NULL\par \tab\tab 415 Init DB mpcms3\par \tab\tab 415 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 415 Query BEGIN\par \tab\tab 415 Query Delete From tblTempReceipt\par \tab\tab 415 Query COMMIT\par \tab\tab 415 Quit \par 080913 15:36:11\tab 416 Connect root@localhost on mpcms3\par \tab\tab 416 Query SHOW VARIABLES\par \tab\tab 416 Query SHOW COLLATION\par \tab\tab 416 Query SET character_set_results=NULL\par \tab\tab 416 Init DB mpcms3\par \tab\tab 416 Query Select tblEmployee.employeeID From tblEmployee Where tblEmployee.employeeUserName='remy' And tblEmployee.employeePassword='23298'\par \tab\tab 416 Quit \par \tab\tab 417 Connect root@localhost on mpcms3\par \tab\tab 417 Query SHOW VARIABLES\par \tab\tab 417 Query SHOW COLLATION\par \tab\tab 417 Query SET character_set_results=NULL\par \tab\tab 417 Init DB mpcms3\par \tab\tab 417 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 417 Query BEGIN\par \tab\tab 418 Connect root@localhost on mpcms3\par \tab\tab 418 Query SHOW VARIABLES\par \tab\tab 418 Query SHOW COLLATION\par \tab\tab 418 Query SET character_set_results=NULL\par \tab\tab 418 Init DB mpcms3\par \tab\tab 418 Query Select tblTempReceipt.productType, tblTempReceipt.productID, tblTempReceipt.stockID, tblTempReceipt.stockSIQ From tblTempReceipt\par \tab\tab 418 Quit \par \tab\tab 419 Connect root@localhost on mpcms3\par \tab\tab 417 Quit \par \tab\tab 419 Query SHOW VARIABLES\par \tab\tab 419 Query SHOW COLLATION\par \tab\tab 419 Query SET character_set_results=NULL\par \tab\tab 419 Init DB mpcms3\par \tab\tab 419 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID\par \tab\tab 419 Query Select tblBank.bankID, tblBank.bankCode From tblBank Where bankStatus='y' Order By bankCode\par 080913 15:36:12\tab 419 Quit \par 080913 15:36:50\tab 420 Connect root@localhost on mpcms3\par \tab\tab 420 Query SHOW VARIABLES\par \tab\tab 420 Query SHOW COLLATION\par \tab\tab 420 Query SET character_set_results=NULL\par \tab\tab 420 Init DB mpcms3\par \tab\tab 420 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 420 Query BEGIN\par \tab\tab 420 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked - 1 Where tblProduct.productID=536\par \tab\tab 420 Query Delete From tblTempReceipt\par \tab\tab 420 Query COMMIT\par \tab\tab 420 Quit \par \tab\tab 421 Connect root@localhost on mpcms3\par \tab\tab 421 Query SHOW VARIABLES\par \tab\tab 421 Query SHOW COLLATION\par \tab\tab 421 Query SET character_set_results=NULL\par \tab\tab 421 Init DB mpcms3\par \tab\tab 421 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 421 Query BEGIN\par \tab\tab 421 Query Delete From tblTempReceipt\par \tab\tab 421 Query COMMIT\par \tab\tab 421 Quit \par 080913 15:36:51\tab 422 Connect root@localhost on mpcms3\par \tab\tab 422 Query SHOW VARIABLES\par \tab\tab 422 Query SHOW COLLATION\par \tab\tab 422 Query SET character_set_results=NULL\par \tab\tab 422 Init DB mpcms3\par \tab\tab 422 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 422 Query BEGIN\par \tab\tab 422 Query Delete From tblTempReceipt\par \tab\tab 422 Query COMMIT\par \tab\tab 422 Quit \par \tab\tab 423 Connect root@localhost on mpcms3\par \tab\tab 423 Query SHOW VARIABLES\par \tab\tab 423 Query SHOW COLLATION\par \tab\tab 423 Query SET character_set_results=NULL\par \tab\tab 423 Init DB mpcms3\par \tab\tab 423 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 423 Query BEGIN\par \tab\tab 423 Query Delete From tblTempReceipt\par \tab\tab 423 Query COMMIT\par \tab\tab 423 Quit \par 080913 15:36:54\tab 424 Connect root@localhost on mpcms3\par \tab\tab 424 Query SHOW VARIABLES\par \tab\tab 424 Query SHOW COLLATION\par \tab\tab 424 Query SET character_set_results=NULL\par \tab\tab 424 Init DB mpcms3\par \tab\tab 424 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ\par \tab\tab 424 Query BEGIN\par \tab\tab 424 Query Delete From tblTempReceipt\par \tab\tab 424 Query COMMIT\par \tab\tab 424 Quit \par 080913 15:41:58\tab 425 Connect root@localhost on mpcms3\par \tab\tab 425 Query SHOW VARIABLES\par \tab\tab 425 Query SHOW COLLATION\par \tab\tab 425 Query SET character_set_results=NULL\par \tab\tab 425 Init DB mpcms3\par \tab\tab 425 Query Select updateCentralQuery From tblUpdateCentral\par \tab\tab 425 Quit \par \tab\tab 426 Connect root@localhost on mpcms3\par \tab\tab 426 Query SHOW VARIABLES\par \tab\tab 426 Query SHOW COLLATION\par \tab\tab 426 Query SET character_set_results=NULL\par \tab\tab 426 Init DB mpcms3\par \tab\tab 426 Query Select updateCentralCopyQuery From tblUpdateCentralCopy\par \tab\tab 426 Quit \par \tab\tab \f1\par }