From 22cbefbc697e5f85d206af672af29ec30a32b733 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 7 Nov 2017 19:46:41 +0100
Subject: add vampirism and healing columns to phase point

---
 crunch_phases.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'crunch_phases.sql')

diff --git a/crunch_phases.sql b/crunch_phases.sql
index e194dfa..5a82162 100644
--- a/crunch_phases.sql
+++ b/crunch_phases.sql
@@ -65,10 +65,15 @@ select
     sum(ability_aacrit_damage_dealt),
     sum(heal_heal_hero),
     sum(heal_healed_hero),
+    sum(heal_heal_ally),
+    sum(heal_healed_ally),
     sum(heal_heal_other),
     sum(heal_healed_other),
     sum(heal_rcvd_heal_hero),
     sum(heal_rcvd_healed_hero),
+    sum(heal_rcvd_healed_vamp),
+    sum(heal_rcvd_heal_ally),
+    sum(heal_rcvd_healed_ally),
     sum(heal_rcvd_heal_other),
     sum(heal_rcvd_healed_other),
     _ph_item_uses_insert
@@ -135,4 +140,17 @@ ability_aa_damage_true = ability_aa_damage_true + values(ability_aa_damage_true)
 ability_aa_damage_dealt = ability_aa_damage_dealt + values(ability_aa_damage_dealt),
 ability_aacrit_damage_true = ability_aacrit_damage_true + values(ability_aacrit_damage_true),
 ability_aacrit_damage_dealt = ability_aacrit_damage_dealt + values(ability_aacrit_damage_dealt),
+heal_heal_hero = heal_heal_hero + values(heal_heal_hero),
+heal_healed_hero = heal_healed_hero + values(heal_healed_hero),
+heal_heal_ally = heal_heal_ally + values(heal_heal_ally),
+heal_healed_ally = heal_healed_ally + values(heal_healed_ally),
+heal_heal_other = heal_heal_other + values(heal_heal_other),
+heal_healed_other = heal_healed_other + values(heal_healed_other),
+heal_rcvd_heal_hero = heal_rcvd_heal_hero + values(heal_rcvd_heal_hero),
+heal_rcvd_healed_hero = heal_rcvd_healed_hero + values(heal_rcvd_healed_hero),
+heal_rcvd_healed_vamp = heal_rcvd_healed_vamp + values(heal_rcvd_healed_vamp),
+heal_rcvd_heal_ally = heal_rcvd_heal_ally + values(heal_rcvd_heal_ally),
+heal_rcvd_healed_ally = heal_rcvd_healed_ally + values(heal_rcvd_healed_ally),
+heal_rcvd_heal_other = heal_rcvd_heal_other + values(heal_rcvd_heal_other),
+heal_rcvd_healed_other = heal_rcvd_healed_other + values(heal_rcvd_healed_other),
 _ph_item_uses_update
-- 
cgit v1.3.1

