pixies

1import Sequelize from 'sequelize';
2import db from '../config/database.js';
3
4export default db.define("speedtests", {
5    id: {
6        type: Sequelize.INTEGER,
7        primaryKey: true,
8        autoIncrement: true,
9    },
10    serverId: {
11        type: Sequelize.INTEGER,
12        defaultValue: 0
13    },
14    serverName: {
15        type: Sequelize.STRING,
16        allowNull: true,
17        defaultValue: null
18    },
19    serverHost: {
20        type: Sequelize.STRING,
21        allowNull: true,
22        defaultValue: null
23    },
24    ping: {
25        type: Sequelize.INTEGER,
26        allowNull: false
27    },
28    jitter: {
29        type: Sequelize.DOUBLE,
30        allowNull: true,
31        defaultValue: null
32    },
33    download: {
34        type: Sequelize.DOUBLE,
35        allowNull: false
36    },
37    upload: {
38        type: Sequelize.DOUBLE,
39        allowNull: false
40    },
41    error: {
42        type: Sequelize.STRING,
43        allowNull: true
44    },
45    type: {
46        type: Sequelize.STRING,
47        defaultValue: "auto"
48    },
49    resultId: {
50        type: Sequelize.STRING,
51        allowNull: true
52    },
53    time: {
54        type: Sequelize.INTEGER,
55        defaultValue: 0
56    },
57    created: {
58        type: process.env.DB_TYPE === "mysql" ? Sequelize.STRING : Sequelize.TIME,
59        defaultValue: Sequelize.NOW
60    }
61}, {createdAt: false, updatedAt: false});