53 lines
1.1 KiB
TypeScript
53 lines
1.1 KiB
TypeScript
import { DataTypes, Model } from "sequelize";
|
|
import { sequelize } from "../database/database";
|
|
|
|
export class WifiLocation extends Model {
|
|
public mac!: string;
|
|
public latitude!: number;
|
|
public longitude!: number;
|
|
public request_limit_exceeded!: boolean;
|
|
public location_not_resolvable!: boolean;
|
|
public created_at_utc!: Date;
|
|
public updated_at_utc!: Date;
|
|
}
|
|
|
|
WifiLocation.init(
|
|
{
|
|
mac: {
|
|
type: DataTypes.STRING,
|
|
primaryKey: true,
|
|
allowNull: false,
|
|
},
|
|
latitude: {
|
|
type: DataTypes.NUMBER,
|
|
},
|
|
longitude: {
|
|
type: DataTypes.NUMBER,
|
|
},
|
|
request_limit_exceeded: {
|
|
type: DataTypes.BOOLEAN,
|
|
defaultValue: false,
|
|
},
|
|
location_not_resolvable: {
|
|
type: DataTypes.BOOLEAN,
|
|
defaultValue: false,
|
|
},
|
|
created_at_utc: {
|
|
type: DataTypes.DATE,
|
|
defaultValue: DataTypes.NOW,
|
|
allowNull: false,
|
|
},
|
|
updated_at_utc: {
|
|
type: DataTypes.DATE,
|
|
defaultValue: DataTypes.NOW,
|
|
allowNull: false,
|
|
},
|
|
},
|
|
{
|
|
sequelize,
|
|
modelName: "WifiLocation",
|
|
tableName: "wifi_location",
|
|
timestamps: false,
|
|
}
|
|
);
|