You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
48 lines
1.0 KiB
JavaScript
48 lines
1.0 KiB
JavaScript
require("dotenv").config();
|
|
|
|
const db = require("./db");
|
|
|
|
db.query(`
|
|
DROP TABLE IF EXISTS public.temperature_measurements;
|
|
DROP TABLE IF EXISTS public.light_measurements;
|
|
DROP TABLE IF EXISTS public.events;
|
|
|
|
DROP TYPE IF EXISTS public."EventType";
|
|
|
|
CREATE TYPE public."EventType" AS ENUM
|
|
(
|
|
'Armed',
|
|
'Arming',
|
|
'Disarmed',
|
|
'Disarming',
|
|
'Triggered'
|
|
);
|
|
|
|
CREATE TABLE public.temperature_measurements
|
|
(
|
|
id SERIAL NOT NULL PRIMARY KEY,
|
|
deviceId INTEGER NOT NULL,
|
|
value DOUBLE PRECISION NOT NULL,
|
|
timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE TABLE public.light_measurements
|
|
(
|
|
id SERIAL NOT NULL PRIMARY KEY,
|
|
deviceId INTEGER NOT NULL,
|
|
value DOUBLE PRECISION NOT NULL,
|
|
timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE TABLE public.events
|
|
(
|
|
id SERIAL NOT NULL PRIMARY KEY,
|
|
deviceId INTEGER,
|
|
type "EventType" NOT NULL,
|
|
timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
|
|
);
|
|
`)
|
|
.then(()=>{
|
|
db.end();
|
|
process.exit(0);
|
|
}) |