每日归档： 2014年8月12日

这个是测试成功的

Organization name: Rick Dong

Serial Key: eNrzzU/OLi0odswsqgnKTM5WcMnPS1eoMTQyMjexMDQyAIEa5xpDAA8pDD8=

——————————————————————————————————————————

License Name:www.bonashen.com

License Key for All Product

 

MockupsFogBugz’s key:

eJzzzU/OLi0odstPdypNr6opLy/XS8rPSyzOSM3TS87PrTE0BkEgsjQxN6xxrnECSuoFA2UBZAsT7A==

 

MockupsConfluence’s key:

eJzzzU/OLi0ods7PS8spTc1LTq0pLy/XS8rPSyzOSM3TS87PrTE0BkEgsjSxMK9xrnECSuoFA2UBsI0VQQ==

 

MockupsCompanion’s key:

eJzzzU/OLi0ods7PLUjMy8zPqykvL9dLys9LLM5IzdNLzs+tMTQGQSCyNLEwr3GucQJK6gUDZQGZ2RTj

 

MockupsAir’s key:

eJzzzU/OLi0odswsqikvL9dLys9LLM5IzdNLzs+tMTQGQSCyNLGwqHGucQJK6gUDZQEMMRJc

 

MockupsJIRA’s key:

eJzzzU/OLi0o9vIMcqwpLy/XS8rPSyzOSM3TS87PrTE0BkEgsjSxsKhxrnECSuoFA2UBEaMSZg==

 

MockupsXWiki’s key:

eJzzzU/OLi0ojgjPzM6sKS8v10vKz0sszkjN00vOz60xNAZBILI0sbCsca5xAkrqBQNlATh7Ey0=

 

 

 

SELECT *
FROM voucher
WHERE CONCAT(prefix, LPAD(voucher_no,6,'00')) IN ('CR005496','CR000032','CR003930','CR007992','CR002811','CR002812');

UPDATE voucher SET expiry_time='2014-08-08 23:59:59', extend_cnt=1, is_expired='N' where voucher_id in (262032,264811,264812,265930,267496,269992);

INSERT INTO `voucher_action` (`id`, `voucher_id`, `action_id`, `action_time`, `user_id`, `comment`, `ct_user`) 
SELECT NULL,voucher_id,11,'2014-08-12 10:00:00', 10, 'Manual extend to 8 Aug.', NULL FROM voucher
WHERE voucher_id IN ('262032','264811','264812','265930','267496','269992');

 

Voucher2：

UPDATE voucher SET type_id=0,status_id=1,stock_id=1,expiry_date= NULL WHERE CONCAT(prefix, LPAD(voucher_no,7,'0')) IN ('JP500001598','JP500001599','JP500001600','JP500001498');


delete from voucher_action where voucher_id in (15498,15598,15599,15600) and action_id = 30  
delete from voucher_campaign_issue where voucher_id in (15498,15598,15599,15600)             
delete from voucher_campaign_issue_request where request_id in (10541,10543,10542)           
delete from voucher_request_approve where request_id in (10541,10543,10542)                  
delete from voucher_receipt_numbers where receipt_no in ('DS0000993','DS0000995','DS0000994')

UPDATE voucher SET expiry_time=adddate(NOW(),7), extend_cnt=1, is_expired='N' where voucher_id in (75562,75563);

INSERT INTO `voucher_action` (`id`, `voucher_id`, `action_id`, `action_time`, `user_id`, `comment`, `ct_user`) 
SELECT NULL,voucher_id,11,NOW(), 10, 'Manual extend to 7 days.', NULL FROM voucher
WHERE voucher_id IN (75562,75563);