17 lines
399 B
SQL
17 lines
399 B
SQL
-- ©AngelaMos | 2026
|
|
-- 003_sensors.sql
|
|
|
|
-- +goose Up
|
|
CREATE TABLE sensors (
|
|
id TEXT PRIMARY KEY,
|
|
hostname TEXT NOT NULL,
|
|
region TEXT NOT NULL DEFAULT 'local',
|
|
public_ip TEXT,
|
|
services TEXT[] NOT NULL DEFAULT '{}',
|
|
started_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
status TEXT NOT NULL DEFAULT 'active'
|
|
);
|
|
|
|
-- +goose Down
|
|
DROP TABLE IF EXISTS sensors;
|