import new ability schema

1 files changed, 70 insertions, 30 deletions

diff --git a/models/participant_phases.js b/models/participant_phases.js
index 369c242..3780b90 100644
--- a/models/participant_phases.js
+++ b/models/participant_phases.js
@@ -240,49 +240,89 @@ module.exports = function(sequelize, DataTypes) {
       type: "DOUBLE",
       allowNull: true
     },
-    items: {
-      type: DataTypes.STRING(191),
+    draft_position: {
+      type: DataTypes.INTEGER(11),
       allowNull: true
     },
-    item_grants: {
-      type: DataTypes.BLOB,
+    ban: {
+      type: DataTypes.INTEGER(11),
       allowNull: true
     },
-    item_sells: {
-      type: DataTypes.BLOB,
+    pick: {
+      type: DataTypes.INTEGER(11),
       allowNull: true
     },
-    ability_levels: {
-      type: DataTypes.BLOB,
-      allowNull: true
+    items: {
+      type: "BLOB",
+      allowNull: false
     },
-    ability_uses: {
-      type: DataTypes.BLOB,
-      allowNull: true
+    item_grants: {
+      type: "BLOB",
+      allowNull: false
     },
-    ability_damage: {
-      type: DataTypes.BLOB,
-      allowNull: true
+    item_sells: {
+      type: "BLOB",
+      allowNull: false
     },
-    item_uses: {
-      type: DataTypes.BLOB,
-      allowNull: true
+    ability_a_use: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
     },
-    player_damage: {
-      type: DataTypes.BLOB,
-      allowNull: true
+    ability_b_use: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
     },
-    draft_position: {
-      type: DataTypes.INTEGER(11),
-      allowNull: true
+    ability_c_use: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
     },
-    ban: {
-      type: DataTypes.INTEGER(11),
-      allowNull: true
+    ability_a_damage_true: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
     },
-    pick: {
-      type: DataTypes.INTEGER(11),
-      allowNull: true
+    ability_a_damage_dealt: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_b_damage_true: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_b_damage_dealt: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_c_damage_true: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_c_damage_dealt: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_aa_damage_true: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_aa_damage_dealt: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_aacrit_damage_true: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    ability_aacrit_damage_dealt: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
+    item_uses: {
+      type: "BLOB",
+      allowNull: false
+    },
+    player_damage: {
+      type: "BLOB",
+      allowNull: false
     }
   }, {
     tableName: 'participant_phases',