diff options
| author | FxQnLr <[email protected]> | 2023-11-06 11:09:34 +0100 |
|---|---|---|
| committer | GitHub <[email protected]> | 2023-11-06 11:09:34 +0100 |
| commit | 1cd2a8e4aecfaad2a8385a6bea61580209b86398 (patch) | |
| tree | c357bcaca0681caf9a6742c857bb494dc4315900 /migrations/20231009123228_devices.sql | |
| parent | d9d7b125e4fcaa3aedd7b57a69e6880e012ccf33 (diff) | |
| parent | 32561060a8dc6fc6118498da06bdd8f5b4c3f0fd (diff) | |
| download | webol-1cd2a8e4aecfaad2a8385a6bea61580209b86398.tar webol-1cd2a8e4aecfaad2a8385a6bea61580209b86398.tar.gz webol-1cd2a8e4aecfaad2a8385a6bea61580209b86398.zip | |
Merge pull request #6 from FxQnLr/ping
Ping
Diffstat (limited to 'migrations/20231009123228_devices.sql')
| -rw-r--r-- | migrations/20231009123228_devices.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/migrations/20231009123228_devices.sql b/migrations/20231009123228_devices.sql index 9d0c7ca..b911b19 100644 --- a/migrations/20231009123228_devices.sql +++ b/migrations/20231009123228_devices.sql | |||
| @@ -1,7 +1,8 @@ | |||
| 1 | -- Add migration script here | 1 | -- Add migration script here |
| 2 | CREATE TABLE IF NOT EXISTS "devices" | 2 | CREATE TABLE IF NOT EXISTS "devices" |
| 3 | ( | 3 | ( |
| 4 | "id" TEXT PRIMARY KEY NOT NULL, | 4 | "id" VARCHAR(255) PRIMARY KEY NOT NULL, |
| 5 | "mac" TEXT NOT NULL, | 5 | "mac" VARCHAR(17) NOT NULL, |
| 6 | "broadcast_addr" TEXT NOT NULL | 6 | "broadcast_addr" VARCHAR(39) NOT NULL, |
| 7 | "ip" VARCHAR(39) NOT NULL | ||
| 7 | ) | 8 | ) |