diff options
Diffstat (limited to 'migrations/20231009123228_devices.sql')
-rw-r--r-- | migrations/20231009123228_devices.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/20231009123228_devices.sql b/migrations/20231009123228_devices.sql index d36946c..6983ada 100644 --- a/migrations/20231009123228_devices.sql +++ b/migrations/20231009123228_devices.sql | |||
@@ -2,8 +2,8 @@ | |||
2 | CREATE TABLE IF NOT EXISTS "devices" | 2 | CREATE TABLE IF NOT EXISTS "devices" |
3 | ( | 3 | ( |
4 | "id" VARCHAR(255) PRIMARY KEY NOT NULL, | 4 | "id" VARCHAR(255) PRIMARY KEY NOT NULL, |
5 | "mac" VARCHAR(17) NOT NULL, | 5 | "mac" MACADDR NOT NULL, |
6 | "broadcast_addr" VARCHAR(39) NOT NULL, | 6 | "broadcast_addr" VARCHAR(39) NOT NULL, |
7 | "ip" VARCHAR(39) NOT NULL, | 7 | "ip" INET NOT NULL, |
8 | "times" BIGINT[] | 8 | "times" BIGINT[] |
9 | ) | 9 | ) |