fix re-init of tables

2024-12-30 19:10:46 +01:00
parent 26e6cd0b7e
commit 35cac7bb0d
1 changed files with 1 additions and 1 deletions
--- a/server/sql/tables.sql
+++ b/server/sql/tables.sql
@ -13,7 +13,7 @@ CREATE TABLE IF NOT EXISTS lp_ttn_end_device_uplinks (
    updated_at_utc TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 );

-CREATE UNIQUE INDEX idx_unique_device ON lp_ttn_end_device_uplinks (
+CREATE UNIQUE INDEX IF NOT EXISTS idx_unique_device ON lp_ttn_end_device_uplinks (
    device_id,
    application_ids,
    dev_eui,