fix SQL init

server/package-lock.json

@@ -10,6 +10,7 @@
       "license": "ISC",
       "dependencies": {
         "cors": "^2.8.5",
+        "dotenv": "^16.4.7",
         "express": "^4.21.2",
         "mariadb": "^3.4.0",
         "reflect-metadata": "^0.2.2",
@@ -585,6 +586,18 @@
         "node": ">=6.0.0"
       }
     },
+    "node_modules/dotenv": {
+      "version": "16.4.7",
+      "resolved": "https://registry.npmjs.org/dotenv/-/dotenv-16.4.7.tgz",
+      "integrity": "sha512-47qPchRCykZC03FhkYAhrvwU4xDBFIj1QPqaarj6mdM/hgUzfPHcpkHJOn3mJAufFeeAxAzeGsr5X0M4k6fLZQ==",
+      "license": "BSD-2-Clause",
+      "engines": {
+        "node": ">=12"
+      },
+      "funding": {
+        "url": "https://dotenvx.com"
+      }
+    },
     "node_modules/dottie": {
       "version": "2.0.6",
       "resolved": "https://registry.npmjs.org/dottie/-/dottie-2.0.6.tgz",

server/package.json

@@ -20,6 +20,7 @@
   },
   "dependencies": {
     "cors": "^2.8.5",
+    "dotenv": "^16.4.7",
     "express": "^4.21.2",
     "mariadb": "^3.4.0",
     "reflect-metadata": "^0.2.2",

server/sql/tables.sql

@@ -47,7 +47,7 @@ CREATE TABLE IF NOT EXISTS ttn_gateway_reception (
 
 CREATE TABLE IF NOT EXISTS location (
     location_id UUID PRIMARY KEY,
-    lp_ttn_end_device_uplinks_id UUID,lp_ttn_end_device_uplinks
+    lp_ttn_end_device_uplinks_id UUID,
     wifi_latitude DOUBLE,
     wifi_longitude DOUBLE,
     gnss_latitude DOUBLE,