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