aboutsummaryrefslogtreecommitdiff
path: root/migrations/20231009123228_devices.sql
blob: 6983ada6d7a54d329c1a0169b51e35c3f58bc11e (plain) (blame)
1
2
3
4
5
6
7
8
9
-- Add migration script here
CREATE TABLE IF NOT EXISTS "devices"
(
    "id"                VARCHAR(255) PRIMARY KEY NOT NULL,
    "mac"               MACADDR NOT NULL,
    "broadcast_addr"    VARCHAR(39) NOT NULL,
    "ip"                INET NOT NULL,
    "times"             BIGINT[]
)