summaryrefslogtreecommitdiff
path: root/models/event.js
diff options
context:
space:
mode:
Diffstat (limited to 'models/event.js')
-rw-r--r--models/event.js57
1 files changed, 57 insertions, 0 deletions
diff --git a/models/event.js b/models/event.js
new file mode 100644
index 0000000..beed589
--- /dev/null
+++ b/models/event.js
@@ -0,0 +1,57 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+ return sequelize.define('event', {
+ id: {
+ type: DataTypes.INTEGER(10).UNSIGNED,
+ allowNull: false,
+ primaryKey: true,
+ autoIncrement: true
+ },
+ api_id: {
+ type: DataTypes.STRING(191),
+ allowNull: true
+ },
+ group_id: {
+ type: DataTypes.INTEGER(11),
+ allowNull: false
+ },
+ name: {
+ type: DataTypes.STRING(191),
+ allowNull: false
+ },
+ team_1_id: {
+ type: DataTypes.INTEGER(11),
+ allowNull: false
+ },
+ team_1_score: {
+ type: DataTypes.INTEGER(11),
+ allowNull: true
+ },
+ team_2_id: {
+ type: DataTypes.INTEGER(11),
+ allowNull: false
+ },
+ team_2_score: {
+ type: DataTypes.INTEGER(11),
+ allowNull: true
+ },
+ date: {
+ type: DataTypes.TIME,
+ allowNull: true
+ },
+ bestOf: {
+ type: DataTypes.ENUM('1','3','5','7','9'),
+ allowNull: true
+ },
+ winner_id: {
+ type: DataTypes.INTEGER(11),
+ allowNull: true
+ }
+ }, {
+ tableName: 'event',
+ timestamps: false,
+ underscored: true,
+ freezeTableName: true
+ });
+};