diff options
author | fx <[email protected]> | 2023-10-21 21:11:28 +0200 |
---|---|---|
committer | fx <[email protected]> | 2023-10-21 21:11:28 +0200 |
commit | bf1aeb7191bfaa75f1acf47c675bc68b9fac1cd8 (patch) | |
tree | 5cd77421900fd8ec02f05d15e6fb195f28dfceb4 /migrations/20231009123228_devices.sql | |
parent | f5928b90748b0bb4c0c498ccc77ebde4eaec8841 (diff) | |
download | webol-bf1aeb7191bfaa75f1acf47c675bc68b9fac1cd8.tar webol-bf1aeb7191bfaa75f1acf47c675bc68b9fac1cd8.tar.gz webol-bf1aeb7191bfaa75f1acf47c675bc68b9fac1cd8.zip |
add migrate macro
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 5856c3a..9d0c7ca 100644 --- a/migrations/20231009123228_devices.sql +++ b/migrations/20231009123228_devices.sql | |||
@@ -1,7 +1,7 @@ | |||
1 | -- Add migration script here | 1 | -- Add migration script here |
2 | CREATE TABLE "devices" | 2 | CREATE TABLE IF NOT EXISTS "devices" |
3 | ( | 3 | ( |
4 | "id" TEXT PRIMARY KEY NOT NULL, | 4 | "id" TEXT PRIMARY KEY NOT NULL, |
5 | "mac" TEXT NOT NULL, | 5 | "mac" TEXT NOT NULL, |
6 | "broadcast_addr" TEXT NOT NULL | 6 | "broadcast_addr" TEXT NOT NULL |
7 | ) \ No newline at end of file | 7 | ) |