localhorst/LocationHub
SHA256
1
0
Fork 0
Code Issues 2 Pull Requests 1 Actions Packages Projects Releases Wiki Activity

fix: remove blocking index from db

Browse Source
This commit is contained in:
Philipp Schweizer 2024-12-30 23:23:15 +01:00
parent 9ef53f4116
commit d2b299c83b
1 changed files with 0 additions and 8 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

8
server/sql/tables.sql
View File

@ -13,14 +13,6 @@ CREATE TABLE IF NOT EXISTS lp_ttn_end_device_uplinks (
updated_at_utc TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP updated_at_utc TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
); );
CREATE UNIQUE INDEX IF NOT EXISTS idx_unique_device ON lp_ttn_end_device_uplinks (
device_id,
application_ids,
dev_eui,
join_eui,
dev_addr
);
CREATE TABLE IF NOT EXISTS wifi_scan ( CREATE TABLE IF NOT EXISTS wifi_scan (
wifi_scan_id UUID PRIMARY KEY, wifi_scan_id UUID PRIMARY KEY,
lp_ttn_end_device_uplinks_id UUID, lp_ttn_end_device_uplinks_id UUID,