From 1fd083b95f9ebc5ef01ee554eda43f07d12457e2 Mon Sep 17 00:00:00 2001 From: schneefux Date: Tue, 4 Apr 2017 13:09:09 +0200 Subject: rename item use table --- model.js | 4 ++-- models/item_participant.js | 33 +++++++++++++++++++++++++++++++++ models/participant_item_use.js | 33 --------------------------------- 3 files changed, 35 insertions(+), 35 deletions(-) create mode 100644 models/item_participant.js delete mode 100644 models/participant_item_use.js diff --git a/model.js b/model.js index 093fc66..b2a2c17 100644 --- a/model.js +++ b/model.js @@ -7,7 +7,7 @@ module.exports = (seq, Seq) => { Roster = seq.import("./models/roster.js"), Participant = seq.import("./models/participant.js"), ParticipantExt = seq.import("./models/participant_ext.js"), - ParticipantItemUse = seq.import("./models/participant_item_use.js"), + ItemParticipant = seq.import("./models/item_participant.js"), Player = seq.import("./models/player.js"), PlayerExt = seq.import("./models/player_ext.js"), Item = seq.import("./models/item.js"); @@ -15,5 +15,5 @@ module.exports = (seq, Seq) => { Roster.belongsTo(Match, { foreignKey: "match_api_id", targetKey: "api_id" }); Participant.belongsTo(Roster, { foreignKey: "roster_api_id", targetKey: "api_id" }); - return {Match, Roster, Participant, ParticipantExt, ParticipantItemUse, Player, PlayerExt, Asset, Item}; + return {Match, Roster, Participant, ParticipantExt, ItemParticipant, Player, PlayerExt, Asset, Item}; }; diff --git a/models/item_participant.js b/models/item_participant.js new file mode 100644 index 0000000..92584f4 --- /dev/null +++ b/models/item_participant.js @@ -0,0 +1,33 @@ +/* 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.STRING(191), + allowNull: false + }, + item_id: { + type: DataTypes.STRING(191), + allowNull: false + }, + action: { + type: DataTypes.STRING(191), + allowNull: false + }, + time_from_start: { + type: DataTypes.INTEGER(11), + allowNull: true + } + }, { + tableName: 'item_participant', + timestamps: false, + underscored: true, + freezeTableName: true + }); +}; diff --git a/models/participant_item_use.js b/models/participant_item_use.js deleted file mode 100644 index 850fba9..0000000 --- a/models/participant_item_use.js +++ /dev/null @@ -1,33 +0,0 @@ -/* jshint indent: 2 */ - -module.exports = function(sequelize, DataTypes) { - return sequelize.define('participant_item_use', { - id: { - type: DataTypes.INTEGER(10).UNSIGNED, - allowNull: false, - primaryKey: true, - autoIncrement: true - }, - participant_api_id: { - type: DataTypes.STRING(191), - allowNull: false - }, - item_id: { - type: DataTypes.STRING(191), - allowNull: false - }, - action: { - type: DataTypes.STRING(191), - allowNull: false - }, - time_from_start: { - type: DataTypes.INTEGER(11), - allowNull: true - } - }, { - tableName: 'participant_item_use', - timestamps: false, - underscored: true, - freezeTableName: true - }); -}; -- cgit v1.3.1