replace participant_item with csv

2 files changed, 4 insertions, 37 deletions

diff --git a/models/item_participant.js b/models/item_participant.js
deleted file mode 100644
index ca8ef15..0000000
--- a/models/item_participant.js
+++ /dev/null
@@ -1,37 +0,0 @@
-/* jshint indent: 2 */
-
-module.exports = function(sequelize, DataTypes) {
-  return sequelize.define('item_participant', {
-    id: {
-      type: DataTypes.INTEGER(10).UNSIGNED,
-      allowNull: false,
-      primaryKey: true,
-      autoIncrement: true
-    },
-    participant_api_id: {
-      type: DataTypes.CHAR(36),
-      allowNull: false
-    },
-    item_id: {
-      type: DataTypes.STRING(191),
-      allowNull: false
-    },
-    number: {
-      type: DataTypes.INTEGER(5).UNSIGNED,
-      allowNull: false
-    },
-    action: {
-      type: DataTypes.ENUM('grant','sell','use','final'),
-      allowNull: false
-    },
-    time_from_start: {
-      type: DataTypes.INTEGER(5).UNSIGNED,
-      allowNull: true
-    }
-  }, {
-    tableName: 'item_participant',
-    timestamps: false,
-    underscored: true,
-    freezeTableName: true
-  });
-};
diff --git a/models/participant_stats.js b/models/participant_stats.js
index 3512cdf..dca0d0e 100644
--- a/models/participant_stats.js
+++ b/models/participant_stats.js
@@ -21,6 +21,10 @@ module.exports = function(sequelize, DataTypes) {
       allowNull: false,
       defaultValue: "1"
     },
+    items: {
+      type: DataTypes.STRING(255),
+      allowNull: false
+    },
     participant_api_id: {
       type: DataTypes.CHAR(36),
       allowNull: false