Cancel credit memo

CopyUPDATE `sales_flat_order` SET
`base_discount_refunded`=null,
`base_shipping_refunded`=null,
`base_shipping_tax_refunded`=null,
`base_subtotal_refunded`=null,
`base_tax_refunded`=null,
`base_total_offline_refunded`=null,
`base_total_online_refunded`=null,
`base_total_refunded`=null,
`discount_refunded`=null,
`shipping_refunded`=null,
`shipping_tax_refunded`=null,
`subtotal_refunded`=null,
`tax_refunded`=null,
`total_offline_refunded`=null,
`total_online_refunded`=null,
`total_refunded`=null,
`hidden_tax_refunded`=null,
`base_hidden_tax_refunded`=null
WHERE entity_id=71508

UPDATE `sales_flat_creditmemo` SET
`adjustment_positive`=0,
`base_shipping_tax_amount`=0,
`base_discount_amount`=0,
`grand_total`=0,
`base_adjustment_negative`=0,
`base_subtotal_incl_tax`=0,
`shipping_amount`=0,
`subtotal_incl_tax`=0,
`adjustment_negative`=0,
`base_shipping_amount`=0,
`base_adjustment`=0,
`base_subtotal`=0,
`discount_amount`=0,
`subtotal`=0,
`adjustment`=0,
`base_grand_total`=0,
`base_adjustment_positive`=0,
`base_tax_amount`=0,
`shipping_tax_amount`=0,
`tax_amount`=0,
`hidden_tax_amount`=0,
`base_hidden_tax_amount`=0,
`shipping_hidden_tax_amount`=0,
`base_shipping_hidden_tax_amnt`=0,
`shipping_incl_tax`=0,
`base_shipping_incl_tax`=0,
`state`=3
WHERE order_id=71508

UPDATE `sales_flat_creditmemo_grid` SET
`grand_total`=0,
`base_grand_total`=0,
`state`=3
WHERE order_id=71508