diff options
| author | FxQnLr <[email protected]> | 2024-02-18 21:16:46 +0100 |
|---|---|---|
| committer | FxQnLr <[email protected]> | 2024-02-18 21:16:46 +0100 |
| commit | 2f9f18b80a9e2134f674f345e48a5f21de5efadd (patch) | |
| tree | c4202bb5c1a490233e89d928cf8c5b91258d4c90 /migrations/20231009123228_devices.sql | |
| parent | 016fa3a31f8847d3f52800941b7f8fe5ef872240 (diff) | |
| download | webol-2f9f18b80a9e2134f674f345e48a5f21de5efadd.tar webol-2f9f18b80a9e2134f674f345e48a5f21de5efadd.tar.gz webol-2f9f18b80a9e2134f674f345e48a5f21de5efadd.zip | |
Refactor stuff. Use Postgres Types
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 | ) |