注销用户

UPDATE `ea_account` SET `equity`=10000.00, `balance`=10000.00, `initbalance`=10000.00, `freemargin`=10000.00 WHERE  `user_id`=1592 LIMIT 1;
DELETE FROM `pick_pick` WHERE  `creator_id`=1592;
DELETE FROM `ea_ticketlog` WHERE  `account_id`=3328;
DELETE FROM `ea_ticket` WHERE  `account_id`=3328;
DELETE FROM `ea_tradeinhours` WHERE  `account_id`=3328;
DELETE FROM `ea_tradeindays` WHERE  `account_id`=3328;
DELETE FROM `ea_trade_trend_stat` WHERE  `account_id`=3328;
DELETE FROM `ea_trade_period_stat` WHERE  `account_id`=3328;
DELETE FROM `ea_trade_pair_stat` WHERE  `account_id`=3328;
DELETE FROM `ea_trade_profit_stat` WHERE  `account_id`=3328;
DELETE FROM `ea_tradebysymbol` WHERE  `account_id`=3328;
posted @ 2012-10-19 16:09  firesnow  阅读(292)  评论(0编辑  收藏  举报