1  -- Copyright (c) 2024 Anoduck
 2  -- 
 3  -- This software is released under the MIT License.
 4  -- https://opensource.org/licenses/MIT
 5  -- SSID,NetID,Encryption,Channel,Last Update,Latitude,Longitude
 6  
 7  DROP TABLE IF EXISTS acess_points;
 8  CREATE TABLE IF NOT EXISTS acess_points (
 9      id       SERIAL PRIMARY KEY,
10      SSID     VARCHAR(255) NOT NULL,
11      NETID    macaddr NOT NULL,
12      Encryption VARCHAR(255) NOT NULL,
13      Channel   INT NOT NULL,
14      UNIQUE(SSID, NETID)
15  )